How do I create Inventory Accounts(GL Codes) and assign them to items?

How do I create Inventory Accounts(GL Codes) and assign them to items?

Creating inventory accounts and assigning them to items: **You will need permissions to access System Setup & Interfaces for this task. **

1.    


1.    Navigate to Accounts under System Setup and select Inventory Accounts:

   

  2. Select Create new Accounting Code Group on the Right



  3. Enter a Description for the Accounting Code Group: i.e. Retail Items/Food/Alcohol/Cleaning Supplies etc. You will also enter the corresponding Account Code for each location.  (These account codes will come from your accountant, or your accounting software.)



   4. After Account Codes have been added select Save & Close



  5. You will now see your new Accounting Code Group listed with any other Inventory Accounts you may have 




  Assigning your Inventory (GL) Accounts to Items.

There are three ways that accounts can be assigned: 


1. Globally: This ensures that every item assigned to a store inherits an Inventory Account. These settings are located under System Setup. Yellow Dog advises setting interfaces at the Global level whenever possible. This will help ensure that no items are missing an Inventory Account, as well as being a faster way of updating items rather than opening each item individually



2.       Inventory Level: This ensures that every item in that department/category inherits that inventory account. These settings are located under Common Setup (Double click the level in question to open the level editor)
     



3.   Inventory Item: Inventory accounts can be set at the item or individual level for items that are outliers or should not inherit the inventory accounts of the other items in that department/category. Like setting the inventory accounts Globally or at the Level, you will navigate to the item in question in your inventory items screen. Double Click on the item in question to open the item editor and navigate to the Interfaces Tab to update or assign an Inventory Account. 














    • Related Articles

    • How to create a Full Physical Inventory

      This document will review the full physical process – from creating and committing to reading the Detailed Physical Inventory Report. Creating a Physical Inventory           1.     From within Yellow Dog select Physical Inventories under Physical ...
    • Reporting Explained: Accounting Interface Codes

      Business Need:  This report is helpful for users who want a report to show all interface accounting codes available to assign to their levels or items.  This report is especially useful if a user is trying to verify what accounting codes need to be ...
    • How do I create and set COGS accounts?

      COGS This ability provides Cost of Goods Sold (COGS) reporting but doesn’t require the use of recipes. We have added new COGS accounts which you can have automatically assigned to new inventory items via level interfaces as well as manually assigned ...
    • How do I create an Invoice?

      This video will demonstrate how to create an Invoice Invoice Records Invoices are usually received after or accompanying your products’ delivery. Invoices will contain your freight, handling, discounts, etc.   Convert a Receipt or Purchase Order into ...
    • How do I Alias Items?

      This video will demonstrate how to Alias Items in Invoices EDI Receipts/Invoices and Return to Vendors EDI, or Electronic Data Interchange, is the transfer of data from one computer system to another. In Yellow Dog Inventory, EDI allows you to ...
    • Recent Articles

    • Send Saved Report Emailing

      You can configure saved reports to be automatically emailed to you and/or team members on a set schedule. How do I schedule daily email reporting? You can configure saved reports to be automatically emailed to you and/or team members on a set ...
    • Purchasing Flow for Food and Beverage

      The Yellow Dog Inventory purchasing flow ensures that all aspects of inventory management, from restocking to adjusting errors in transfers, are covered systematically. Each document type in the flow serves specific functions that collectively ...
    • Updating Count XL Application

      You may need to update your Count XL application on your handheld device to ensure it runs properly and smoothly. If you have received the following errors, your Count XL application may need to be updated: • “Invalid network error” • “API error” • ...
    • Removing Items with On-Hand Quantity (Decimal)

      You might encounter difficulty removing specific inventory items due to an error indicating that the item cannot be removed since its on-hand quantity is not zero, possibly because the decimal point is not properly adjusted. Changing the Decimal ...
    • ZD411 Printer Troubleshooting

      Labels Skipping When Printing When you are not able to print labels or labels are skipped when printing you will need to adjust the sensor inside the printer. If your labels are skipping when printing, make sure you have adjusted your sensor. To do ...