GL transactions are generated when stock movements occur.
GL Postings for Stock Transactions
Confirm Sales Invoice (in addition to revenue posting)
When an invoice is posted to GL:
Debit: Cost of Goods Sold (from product group GL template) → Qty invoiced × standard cost
Credit: Stock (from product group GL template) → Qty invoiced × standard cost
Note:
Multiple lines possible based on product groups
If the standard cost is zero, no GL postings will be created.
Confirm Movement for a Sales Return
When a credit is posted to GL:
Debit: Stock (from product group GL template) → Qty credited × standard cost
Credit: Cost of Goods Sold → Qty credited × standard cost
Purchase Receipts
When goods are received:
Debit: Stock → Qty received × standard cost
Credit/Debit: Purchase Price Differences (integration settings) → (Order price – standard price)
Credit: Purchasing account (integration settings)
Manual Stock Transactions and Import Stock Items
Journal entries:
Debit/Credit: Stock (Debit for Buy/Find/Make; Credit for Write-off/Sell)
Debit/Credit: Stock Discrepancies (integration settings) (Debit for Write-off/Sell; Credit for Buy/Find/Make)
Amount = Qty × standard cost
If the standard cost is zero, no GL postings will be created.
Note: To enable GL postings for stock transactions, you must first set up Stock Balance Sheet Groups and Cost of Goods Sold Groups, assign them to the appropriate General Ledger Template, link the correct accounts in Accounting Integrations, and activate the ‘Create Stock Movement Journals’ toggle.
Post Ledger Transactions
To view and post these entries, ensure the following permissions are active for your role:
Action: Ledger Transaction Integration Posting
Workplace: Ledger Transaction
Go to Finance -> Ledger Transactions
An overview screen will open, where you can review and post ledger transactions individually or in batches.
Do you need Help? Start a conversation using the help bubble at the bottom-right