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 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 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 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

    • Yellow Dog/Spot On(Appetize) Integration Overview

      The document will provide an overview of the Yellow Dog Spot On(Appetize) integration Integration Approach The integration between Yellow Dog and Spot On (Appetize) can be configured to be a 1Way (sales pull only) or 2Way (sales pull and item push) ...
    • Yellow Dog/InfoGenesis Integration Overview

      The document will provide an overview of the Yellow Dog InfoGenesis Integration Integration Approach This integration can be setup as a 1Way (Sales Pull Only) or a 2Way (Pull Sales & Push Items) Sales – pulled in from a .txt file provided by ...
    • Yellow Dog/Shopify Integration Overview

      This document will provide an overview of the Yellow Dog Shopify Integration Integration Approach This integration can be set up in 4 primary ways: 1Way - pull sales only 2Way – pull sales and push on hands 2Way – pull sales and push items and on ...
    • Yellow Dog/Simpony2 w/Oracle Integration Overview

      This document will provide an overview of the Yellow Dog /Simphony 2Way integration Integration Approach The Yellow Dog/Simphony integration is a 2Way integration Sales – pulled in from files provided by Oracle once per day Codes – pulled from the ...
    • Yellow Dog/NCR Silver Integration Overview

      This document will provide an overview of the Yellow Dog/NCR Silver integration Integration Overview The Yellow Dog/NCR Silver integration is a 2Way integration Sales – Pulled from the NCR API Codes For reporting codes are pulled from the NCR API For ...