Inventory mapping to GL
Is there a report in AccountRight that shows which GL accounts each inventory item is mapped to?
Forum Discussion
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
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.
