How to Distribute Sales to General Ledger by Warehouse Location
Release Date: 03/20/18
Q - Is there a way to process sales that will let us categorize those sales by warehouse in the GL? In other words, is there a way to link a profit center to a warehouse? Would we have to set up the product type by location table for all product types and all warehouses?
A - You can either have one sales account as defined in A/R Setup, or sales account by Product Category/Location Account file. Therefore, if you wish to categorize sales by warehouse, you will need to set up every possible combination of Product Category/Location. The common mistake with this method is that users forget to set up the Product Category/Location account file when a new product category or location is added in the future.
The other possibility is for you to handle this as a general journal entry. That is to say, you don’t set up the Product Category/Location account file. So all sales go to the default sales account set up in A/R. At the end of the month, you can run the sales report to give you a breakdown total by location. Then you can make journal entry adjustments that will be reflected on your financial statement.
EMK
Related Articles
GLACTMNU General Ledger G/L Account File
G/L Account File Application Overview The G/L Account File is used to set up and maintain, as well as print out a list of all or a subset of all accounts on file. The Account number entered for each record can be divided into three related components ...
GLMENU General Ledger Package Overview
Overview Package Overview How To Use This Manual When most people receive a new product, they want to use it right away. Unfortunately, this is not quite possible when dealing with computer hardware and software. This manual is intended to serve as a ...
GNJINLENT General Ledger General Journal Trx Processing
Processing General Journal Trx Processing Application Overview The General Journal Transaction Processing application allows for Journal Transaction entries and changes before posting to the General Ledger. Transactions may be keyed directly into the ...
GLSRCMNT General Ledger Source File Maintenance
Source File Maintenance Application Overview The Source File application links the "source" with a corresponding General Ledger transaction. All such transactions encompassed in the main General Ledger Transaction file originate in a specific Journal ...
GLRECENT General Ledger Recurring Journal Trx Processing
Recurring Journal Trx Processing Application Overview The Recurring Journal Transaction Processing application allows standard recurring journal transactions to be entered. They may also be changed before being posted to the General Ledger through ...