Inventory mapping to GL

[Judy01]

Is there a report in AccountRight that shows which GL accounts each inventory item is mapped to?

[Steven_M]

Hi @Judy01 

I personally don't know of a report that will show that information within AccountRight.

However, the way I would get that information is via the Import/Export Assistant. Below is the full process that I would use:

1. Navigate to File>>Import/Export Assistant
2. Select Export Data
3. Select Items
4. Select the desired data separator (personally I use Tabs)
5. Select the desired field you want to add to the export i.e. Item number, Item name, Asset acct, Income acct, Expense/COS acct
6. Select Export

The above process will provide you with a text file that contains the information of those items that can be opened in Excel or Notepad or a similar product.

More information on exporting data can be found in Help Article: Exporting data

[Judy01]

Thank you. I will give that a go. Something is mapped incorrectly but I have no idea which code is is as we have several hundred.