GL Mapping
The GL mapping is used to post transactions to the General Ledger.
All transactions are first checked in this table to identify the GL accounst to be used before posting.
MAPPING CODE = is the GL mapping code that the program will be using for this transaction.
MAP1 = Is the Branch / Warehouse / Store Location
MAP2 = is the Group / Type
MAP3 =
MAP4 =
GL Account = is the Natural GL Acoount to be used.
​
|
Module
|
|
Mapping Code
|
|
Notes
|
Map1
|
Map2
|
Map3
|
Map4
|
Gl_account
|
Status Codes when used
|
|---|---|---|---|---|---|---|---|---|---|---|
|
Module
|
|
Mapping Code
|
|
Notes
|
Map1
|
Map2
|
Map3
|
Map4
|
Gl_account
|
Status Codes when used
|
| Sales Orders | Subledger | ARSL | Accounts Receivable subledger control account | WH | TYPE | 90 | ||||
| Sales | SALN | Sales of stocked Items | WH | PG | 90 | |||||
| SALS | Sales of Special Items | WH | PG | 90 | ||||||
| Cost | COGN | Cost of Stocked Items | WH | PG | 90 | |||||
| COGS | Cost of Special Items | WH | PG | 90 | ||||||
| Tax | STAX | Tax collected in Sales invoices | WH | TAX | 90 | |||||
| Discounts | SDIS | Sales Discounts given to the customer in the invoice | WH | TYPE | 90 | |||||
| Inventory | INVN | Stocked Inventory | WH | PG | 90 | |||||
| INVS | Special inventory | WH | PG | 90 | ||||||
| Accounts receivable | Subledger | ARSL | Accounts Receivable subledger control account | WH | TYPE | 92 | ||||
| Discounts | ADIS | Customer settelment discounts | WH | TYPE | 92 | |||||
| CASH | CDRW | Cash drawer account | WH | |||||||
| Purchase Orders | Subledger | |||||||||
| Provisions | PPRN | Purchase Provision - Normal | WH | TYPE | ||||||
| PPRS | Purchase Provision - Special Items | |||||||||
| Inventory | INVN | Stocked Inventory | WH | PG | ||||||
| INVS | Special inventory | WH | PG | |||||||
