Description

This document contains detailed information about processing stock adjustments/Item Adjustment.

Detail Steps

Single Item adjustment:- 

  1. Select the Items Register.
  2. Right-click Item>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 either type a number, or use a plus or minus amount. For example, to adjust quantity by an additional 10, type in “+10”. Then select a Reason for the adjustment.
  6. Select Record Adjustment.
  7. If under Tools > Preferences > Inventory > setting ticked TURNED ON

then on Record selection pop-up message will advise to Send Adjustment to MYOB

8. Select OK to send to MYOB or Cancel


Multiple Item adjustment:- 

  1. Goto 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 either type a number, or use a plus or minus amount. For example, to adjust quantity by an additional 10, type in “+10”. Then select a Reason for the adjustment.
  7. Select Record Adjustment.
  8. If under Tools > Preferences > Inventory > below setting ticked TURNED ON 

then on Record selection pop-up message will advise to Send Adjustment to MYOB

8. Select OK to send to MYOB or Cancel

Please ensure you tick the "include the historic stock groups" and "include untracked" for adjustment of zero qty items. 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. Goto Tools>Stock History>filter by date and ENTER,
  2. Goto Adjustments tab >double click the AO > 'Create MYOB Adjustment'




Adjustments not going thru to MYOB. 

One of the reason adjustment can’t be send to MYOB is due to having duplicate supplier card.

However, the adjustment can be send to MYOB by the following steps:

1- Open/Launch your MYOB

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 name slightly different from the other(image below-Marked in Red)


 

5- Click “OK” and Exit MYOB

6- Open/Launch WMS

7- Run Maintenance Replication

8- Send the Adjustment to MYOB (Create MYOB Adjustment)


  •  Adjustments can ONLY be sent as Order/Bill - AccountRightLive does not support QUOTES - check the preferences.
  • Please not to 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, Security called "Prompt to create MYOB PO on Stock adjustment" to prompt the user to send to MYOB on 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. 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.

WHAT ABOUT THE COST OF GOODS?


  • Costs are sent to MYOB with the Adjustment.
  • The costing method is set in the Tools, Preferences, Replication Tab "Adjustments as" the options are "Average","Last","Standard".
  • To set a fixed price for the adjustment enter the "per item cost" into the reason field including the dollar sign, for example "$1.20".
  • If the item code is setup in MYOB "\SHRINKAGE" is the standard Net cost item when no selection is made, however, you can create your own Net cost items in MYOB, items must start with "\" to be made available for use (Ensure the expense account is set correctly in MYOB)
  • 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 MYOB, the cost of the adjustment will be posted against this item.

    for Example  OLD item 101248SR which replace with NEW item R278