Forum Discussion

Judy01's avatar
Judy01
Trusted User
3 years ago

Inventory mapping to GL

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

2 Replies

Replies have been turned off for this discussion
  • Judy01's avatar
    Judy01
    Trusted User
    3 years ago

    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.

  • 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