Inventory Accrual and Stock in Transit implementation. (GRNI, GINR)
This article explain how Inventory Accrual and Stock in Transit concepts are implemented in DEAR. It is recommended to understand the concepts in Processing a Purchase first before reading this article.
Purchase orders can be processed Invoice First or Stock First.
Inventory Accrual transactions and cost calculation take place when a Stock First Purchase is processed. (Goods Received, Not Invoiced)
Stock in Transit transactions are happening when an Invoice First Purchase is processed. (Goods Invoiced Not Received).
This functionality only has effect when Inventory Accrual setting is enabled.
If Inventory Accrual is disabled, or mapping for relevant account is not provided, the functionality of Purchase won't change from no accrual implementation and only real costs will be accounted for.
To enable Inventory Accrual:
- Navigate to Settings -> General Settings
- Scroll to Purchase process customisation
- Set Enable Accrued Inventory transactions to Enabled
When you enable this setting, you need to provide mapping for two accounts:
- Inventory Accrual account (can be of class ASSET or LIABILITY)
- Stock In Transit (can be of class ASSET).
Mapping for these two accounts can be done in both General Settings and Account Mapping. These accounts are not visible when Inventory Accrual is disabled.
Stock First - Inventory Accrual
In this scenario Cost movements with dates of stock received are added once Stock Received is authorised.
For accrual cost calculation, DEAR uses purchase order cost value (when it is present) or Average Cost of product on the moment of Stock Received authorisation otherwise.
Additional cost in Purchase order is NOT used in accrual cost calculation. To reflect accrual cost movements in transactions, special Manual Journals are automatically added to the purchase with Debit = Inventory account (Product/Default Purchase task levels) and Credit = Inventory Accrual account from mapping. These journals cannot be manually deleted and will be exported to Xero/QuickBooks regardless of Manual Journals authorisation status.
On invoice authorisation, Cost Movements with invoice date will be created identical to accrual cost movements but with negative amount. Also another system journals will be added to purchase identical to accrual journals but with negative amount. At the same time, normal cost movements will also be created based on normal cost calculation logic, while special accrual manual journals will be excluded from that logic.
On Undo, special accrual journals will be deleted automatically and will be voided in linked accounting software. All cost movements can be verified in Product Movements tab.
Invoice First - Stock In Transit
In this scenario when invoice is authorised, instead of creating transactions with accounts in invoice lines, all ASSET class accounts will be replaced with Stock in Transit account. When exporting this invoice to Xero/QuickBooks, same replacement will be done and in these systems Stock in Transit account will be displayed on the documents.
On stock authorisation, special manual journal is added to Purchase Manual Journals that can't be manually deleted. This journal has date of maximum stock received and Debit = Accounts from invoice, Credit = Stock in Transit and will be exported to Xero/QuickBooks without Manual Journals authorisation.
Once stock is authorised, you can't change account in invoice lines without Undo.