Description

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

  •  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.

Detail Steps

Single Item adjustment 

  1. Select the Items List Register.

  2. Select Item > Right-click >Item Adjustment 

  3. Select a Location.

  4. Select "Search Inventory".

  5. 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”.

  6. Then select a Reason for the adjustment.

  7. Select Record Adjustment.

  8. Select OK to continue.


Multiple Item adjustment

  1. Go to Tools >Stock Adjustment

  2. Select a Location

  3. Select other relevant options as described in more detail below.

  4. You can also use the List Builder icon "..." next to the item field to select multiple items.

  5. Select "Search Inventory"

  6. 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”.

  7. Then select a Reason for the adjustment.

  8. Select Record Adjustment.

  9. Select OK to continue.

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.


Resend Adjustment

  1. Go to Tools >Stock History > filter by date and ENTER

  2. Go to the Adjustments tab > find adjustment transaction > open > select “Create Accounting Entry”.


Adjustments are not going thru to the Accounting system. 

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.


WHAT ABOUT THE COST OF GOODS?

  • 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

Related Information

Managing Nett Costs - Adjustments