Grendata Computer Systems
Store/Product Code to Posting Summary Cross Reference
PLEASE NOTE:
Before using this utility, we are assuming that you have already Built your PRODUCT CODE FILE, LEGITIMATE STORE CODE FILE, AND YOUR POSTING SUMMARY RECORDS.
This utility allows you to set up a relationship between product and stores to your Accounts Receivable posting summary.
You must have one of these records for every possible combination of sale company wide.
Example:
You have many stores in your company. Each store has a two character code. In our case, one of our stores code is HA . We sell computers that have a product code of 100 . Every time we sell a computer from store HA, we want the sale to show up in our Accounts receivable posting summary under summary code COMP . The screen as you see it above will process this for us.
So any item from inventory that has a product code of 100 and is sold in store HA will show up on our posting summary as an entry into COMP.
If you have more than one store, and you do not need to separate the sales that will eventually end up in your general ledger, then you would set up a record as above for each store code, with the Accounts Receivable Posting Summary Code being COMP for all of them.
If on the other hand, you wish to keep sales separate for each store, you could set up the record for the first store as STORE CODE HA, PROD. CODE 100, SUM CODE HACOMP. Then your second xref record could be for STORE BA, PROD. CODE 100, SUM CODE BACOMP etc.