Troy:

I would suggest to get in touch with Sage Support. They will do a quick fix. The issue is probably a rounding error of some sort within Sage.

Hello Agate,  Thank you for your help.  Sage support was able to correct this error.  However in doing so when I check my data integrity I am now getting an error under the historical Information.  Specifically the Inventory and Services section is showing not balanced.  This is our first fiscal year and no historical entries were posted.  Any idea of what may have happened or how to fix?

Please let me know.

Thank you,

Troy Beauregard

Troy:

Are you referring to Goods Received vs Uninvoiced Goods Received and Delivery Orders vs Uninvoiced Delivery Orders in the Data Integrity Check?

Please see above as it shows as historical Information at the bottom of the summary.  The numbers all match and it says Data OK above.

Please see above as it shows as historical Information at the bottom of the summary.  The numbers all match and it says Data OK above.

Troy:

The value of your inventory items vs your general ledger inventory account(s) do not agree. I would imagine your opening numbers in your ledger do not agree with your opening values for the inventory items, quantities and amounts you entered into Sage 50. You may have to use your Adjust Inventory feature to balance the Historical amounts or change your opening figure in your general ledger account for inventory.

Hello Agate,

I started the year with a blank inventory and actually entered all inventory through a Purchase Invoice from the Sole proprietor.  No opening balances were used.  It was mentioned that I may have to send off our data to a specialist to have it fixed.  Does this seem right?  I have no clue how it would be out of balance as all transactions were done through either a Purchase Invoice or Sales Invoice, Inventory adjustment or build.  How might I isolate which item it could be?

Thanks,

Troy

Troy:

Were your entries entered as historical transactions? If so, then one of your transactions has either been entered incorrectly or the opening balance entry was incorrect. If you have entered these through the regular purchase invoice entry with no opening general ledger amount then yes, Sage support will have to be contacted

It was entered through a purchase invoice.  No historical entries were made.  I will contact support.  Thanks Agate!