Making Stock Adjustments | Datapel Help Center

Description

This document contains detailed information about processing Stock adjustments or Item Adjustments.

Workflow Options

Adjustments can ONLY be sent as Order/Bill - AccountRightLive does not support QUOTES - check the preferences.
Please not send Adjustments with NEGATIVE lines as ORDERS. Please send as BILL.

Transactions should be sent to MYOB in most cases; therefore, a preference can be found in Tools, Preferences, and Security called "Prompt to create MYOB PO on Stock adjustment" to prompt the user to send to the MYOB record. If sending fails or the transaction needs to be resent, it can be accessed via the stock history.
Please ensure you tick the "include the historic stock groups" and "include untracked" for adjustment of zero qty items. Then, alternately right, clicking on the item in the adjustment screen will allow you to copy the line details to a new line and adjust as required.
Returning stock to a supplier? Select the supplier on the left-hand side to send the adjustment to the supplier card instead of the location card.

Scenarios
1. Non-inventory with WMS cost tracking off. No cost adjustment required for WMS process directly in accounting and replicate.
2. Non-Inventory in accounting, forced inventory in WMS with WMS cost on, WMS adjustment - remove 1 item (at average cost) and add 1 x back in (at required total cost increase + 1 x average cost) - need to tick allow cost changes in the adjustment to edit costs.
3. Inventoried in accounting. No cost adjustment required for WMS process directly in accounting and replicate.

In all cases historic sales GP cannot be adjusted where sales have been made while stock was over or undervalued in the WMS, WMS sales can be manually adjusted in the extended line notes cost field for reporting purposes only

Workflow Restriction

Historic adjustments, while useful in some circumstances, are not recommended.
Numerous historic adjustments may clash with actual historic transactions.
You will receive an alert if you try to adjust stock which results in a figure below zero at any point in history.
The stock adjustment from WMS posted to MYOB
-It does not overwrite stock in MYOB. Instead, it will add the stock number to MYOB which was already in MYOB (or minus off)
Example: Item qty of 10 made it 20 in MYOB (because 10 was already there)

Select the Items List Register.
Select Item > Right-click > Item Adjustment.
Select a Location.
Select "Search Inventory".
To make an adjustment, type over the value in the Counted field. You can type a number or use a plus or minus amount. For example, to adjust the quantity by an additional 10, type in “+10”.
Then select a Reason for the adjustment.
Select Record Adjustment.
Select OK to continue.

Go to Tools > Stock Adjustment.
Select a Location.
Select other relevant options as described in more detail below.
You can also use the List Builder icon "..." next to the item field to select multiple items.
Select "Search Inventory".
To make an adjustment, type over the value in the Counted field. You can type a number or use a plus or minus amount. For example, to adjust the quantity by an additional 10, type in “+10”.
Then select a Reason for the adjustment.
Select Record Adjustment.
Select OK to continue.

Workflow Restrictions

Please ensure you tick the "include the historic stock groups" and "include untracked" for adjustment of zero qty items.

Then, alternately right, clicking on the item in the adjustment screen will allow you to copy the line details to a new line and adjust as required.

Go to Tools > Stock History > filter by date and ENTER.
Go to the Adjustments tab > Find adjustment transaction > Open > select “Create Accounting Entry”.

One of the reasons that adjustments can’t be sent to the Accounting system is having a duplicate supplier card.

However, the adjustment can be sent by the following steps:

1. Open/Launch your Accounting System.

2. Search for Supplier cards and look for identical/same card name(image below-Marked in Red).

3. Double click on one of the supplier card.

4. Rename one of the identical/same supplier card names slightly different from the other.

5. Open/Launch WMS.

6. Run Detailed Replication.

7. Re-Send the Adjustment.

Costs are sent to the Accounting system with the Adjustment.
The costing method is set in the Preferences > Replication Tab "Adjustments as" the options are "Average", "Last", and "Standard".
To set a fixed price for the adjustment, enter the "per item cost" into the reason field, including the dollar sign, "$1.20". When $0.00 is added it will send to accounting with $0.00 as the cost.
If the item code is setup in the Accounting system, "\SHRINKAGE" is the standard Net cost item when no selection is made; however, you can create your Net cost items in the Accounting system; items must start with "\" to be made available for use (Ensure the expense account is set correctly).
Are you moving stock from one item code to another? Try the net costing option, choose "selected NCI" on the left-hand side, and "*NCI" from the reason drop-down list against the item you want the adjustment value to be posted to; when sent to the Accounting system, the cost of the adjustment will be posted against this item.

For Example, OLD item 101248SR which replace with NEW item R278