I found that each inventory item is linked to an Account. So how would I show all items by account and link them to the proper account? If I just change the Account, will that cause a problem for my inventory?

Hi Norlite,

If you want to see what asset linked accounts are used for your inventory items, in Sage 50 home screen, please go to Reports in the menu bar, Lists and click Inventory & Services....

In the Modify Report window, click Report Columns on the left hand side and select Custom report column settings.  Then, highlight Asset in the table on the left hand side and click the Add> button to put it to the table on the right hand side.  Click OK and you will see the report with asset account used for each item. 

My suggestion is to use Adjust Inventory to bring the the item quantity and value back to zero first.  Then, you change the asset linked account of the items.  After that, use Adjust Inventory again to bring the quantity and value back up with the correct asset account.  For more information of how to use the Inventory Adjustment, you can follow the knowledgebase article below.

12805 How to enter an Inventory Adjustment

Remember to do a backup (Files, Backup) before you do any adjustment.

Hope this helps.

Am I doing each one, one at a time?

Hi Norlite,

You can do a lump sum Inventory Adjustment to bring all the items' quantity and value back to zero.  Then, go to each item record, Linked tab to change the asset linked account.  After that, you can do another lump sum Inventory Adjustment to bring up all the items' quantity and value back. 

Hope this helps. 

Keith,

How do I get the items listed on the Inventory Adjustment List? One at a time?

Keith,

I see the Account I need from the Account Lists but when in Inventory Adjustment, it is not there to choose from.

1. Run an Inventory summary report by account, report on 'latest transaction'.   Choose any accounts that you DON"T want.

2. Go through the list of items with wrong account numbers, and change each one's Asset account to the account that you DO want.   When you're done, refresh the report and make sure there are no more items to fix.

3.  Run the summary report again, choosing the Asset account that you DO want.  Note the total.  This will probably not match the G/L balance as of the end of the latest fiscal year (the balance that shows in the 'Accounts' screen).  

To fix that:

4. Follow the procedure in the technical document mentioned in the previous post, to adjust the G/L dollar balances.  

5.  When The former Inventory Accounts that have no inventory attached should be adjusted to zero.

Run the summary and G/L reports again to make sure everything is in balance.

From this point on, inventory reports will remain in balance between the G/L and the subledger accounts provided:

- No prior transactions are reversed or cleared.

- No account linking is changed.

- No inventory item is changed to a 'service' item.

Inventory summary reports are based on what's currently linked, so if it was different in the past, past reports won't line up.

Another suggestion if you can do it:

if you are not using 1260 for anything else then combine that account nbr with 1240. That way all previous transactions to 1260 will now show as 1240.

The power to combine accounts is reserved for those who have the Accountants' Edition of Sage 50.  

Mere mortals may only combine payable vendors and receivable customers

oh darn!