When setting up the inventory account in your MYOB accounting software, you can enter an Opening Balance. See our example below. 

Image Modified

If this is set differently to the value of your RetailManager shopfront inventory at the start of the business, your end total will be incorrect.

In RetailManager

1. Go to the Reconciliation menu and choose Print Cashup Reports.
   
2. Click to highlight an old session.
   
3. Click to view or print the Sales Summary report for this session.
   
4. Check the stock value.

In MYOB accounting software

1. From any command centre, click Find Transactions.
   
2. Click the Account tab.
   
3. In the Search by field, select Account and select your inventory asset account number.
   
4. In the Dated From and To fields, enter the same date that was used for the Sales Summary report in RetailManager.
   
5. Compare the displayed Ending Balance to the Stock Value in the RetailManager.
   
6. If these two figures match, repeat the above procedure selecting a later date range.
   
7. When the date range is identified where the inventory and stock values differ, continue with the following sections in this support note.

your MYOB accounting software, or the journals / purchases were imported twice thus creating duplicates. This can affect your accounting software stock value as these transactions contain the inventory adjustment value. See our example below showing a duplicate inventory adjustment.

Image Modified

How to find:

Look in

the Transaction Journal for duplicated transactions.

Transactions could have been entered directly into your MYOB accounting

software and not entered into RetailManager so the stock value in

the accounting software would change but the stock value in RetailManager will not.

How to find:

Run an account enquiry on the inventory asset account to list all transactions. To do this:

1. From any command centre, click Find Transactions.
   
2. Click the Account tab.
   
3. In the Search by field, select Account and select your inventory asset account number.
   
4. Enter a date range.
   
5. Look for any transactions that have not come from RetailManager. RetailManager transactions will appear as either Purchase RetailManager or Inventory Adjustment. Any transactions posted directly to this account will affect your inventory balance but not be reflected in RetailManager.

Doing an export of the stock file and during this time some items may have been sold. When doing the import of the stock file back in, matching all fields by name including the quantity will result in the quantity on hand value being replaced with the incorrect value.

Image Modified 

How to find:

This discrepancy is quite difficult to track down as there is no audit trail of the variance. You would need to know if this was done in order to track this issue.

Doing an export of the stock file out to do a stocktake and entering in the quantity in the Excel file and then importing it back into RetailManager. Not only will this overwrite the existing quantity in RetailManager but it will not track its movement in the audit tab of the stock information window and will not create an inventory adjustment value to export across to your MYOB accounting software.

Image Modified

Image Modified