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
Can Journal Ledger Be Imported to General Ledger?
Q - Can the General Journal ledger be imported from a spreadsheet into the General Ledger as opposed to manually entering it? A - Yes. You can go to General Ledger -> Processing -> Interface from Other Package -> CSV Import. See sample screen below. ...
COMPRESS General Ledger Processing Compress General Ledger TRX File
Compress General Ledger Trx File Application Overview The Compress General Ledger Transaction File application will consolidate General Ledger transactions according to the account's compression code in the G/L Account file for all transactions dated ...
ARSLSENT Accounts Receivable Sales and CR/DR Memo Processing
Sales & CR/DR Memo Processing Application Overview Sales & CR/DR Memo Processing is an application that you will use very often. You will use it whenever you want to record in your Accounts Receivable new transactions that have occurred. For example, ...
CP0501 Customer Order Processing Sales History Trx Processing
Sales History Trx Processing Application Overview The Sales History Trx Processing is a standard transaction entry module allowing add, change and delete/inquire functions, as well as an edit list print‑out to verify that the transactions entered are ...
CPSLSDSK Customer Order Processing Sales Desk
Sales Desk Application Overview Sales Desk is designed for companies who need versatile order entry functions and improved customer service. It is designed to be used by salespersons, order entry personnel and telemarketers. Sales Desk is extremely ...