GL Mappings
GL Transaction Mappings tell Cetec which general-ledger account each posting goes to, for every kind of transaction (invoices, receipts, vouchers, payments and so on). They drive your ledger, P&L, balance sheet and the other financial reports.Updated Nov 9 2026
Before you start
- GL Transaction Mappings is under Admin > Config Settings. The menu item is shown to the Admin role by default, and the page needs the Can Edit Config Settings function (Config Settings role by default; Admin always). Without it Cetec shows Admin Access Required!.
- Saving a mapping needs the Admin role.
- Set up your chart of accounts first; you can only map to accounts that exist.
- Consult your CPA to make sure each posting goes to the right account.
-
Review the transaction mappings
- Go to Admin > Config Settings > GL Transaction Mappings. The page is titled GL Transaction Mapping.
- Each row is a Transaction (for example Ar Payment, Receipt, Voucher, Warehouse Transfer). Status shows how many of its postings have an account, such as 7 / 7 Set.
- Click a Transaction to see and set its postings.
-
Set the account for a posting
- Open Admin > Config Settings > GL Transaction Mappings and click the Transaction. The page is titled GL Transaction Mapping - Edit transaction.
- Find the posting by its Description. Descriptions name the document that posts, not the
transaction row you clicked (on Ar Payment they read Customer Payment - …), and a page
can include a related transaction's posting (Progress Invoice starts with *External Invoice
- Debit Full Amount To*). Info shows the Suggested/Default Account: (the account Cetec looks for by name when nothing is set) and the Type. A red Account cell showing (select account) means no account is set and your chart has no account with the suggested name, so pick one yourself.
- Pick the account in the Account list (type to search; accounts show as number name) and click Set on that row. Picking alone saves nothing. Set saves at once; Cetec shows Set! Value is followed by the account's id.
- To map one warehouse location differently, choose it in Location To Map and click Submit. Cetec shows Setting Mapping For Transactions From Location … Only and adds - <location> to each description. Submit only reloads the rows for that location; they start with the same accounts as All. Set each row with its own Set.
- Back To All GL Transactions opens the older transaction list. To get back to the current one, use Admin > Config Settings > GL Transaction Mappings again.