Inventory mapping to GL

Question

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

Judy01 · Answer

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.

Steven_M · Answer

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:

* Navigate to File>>Import/Export Assistant
* Select Export Data
* Select Items
* Select the desired data separator (personally I use Tabs)
* Select the desired field you want to add to the export i.e. Item number, Item name, Asset acct, Income acct, Expense/COS acct
* 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