This functionality applies to FirstBIT Contracting configuration starting from release 2.1.1.35.
Starting from release 2.1.1.35, the Stock GL Transaction checkbox is available in purchasing documents within the procurement chain, starting from the Purchase Order document.
The checkbox determines whether inventory transactions are generated automatically during the purchasing process.
When the checkbox is enabled, the system automatically generates the required inventory movements when the related Invoice Received document created from the Purchase Order is posted. This eliminates the need to create a separate document for the financial inventory transaction.
The Stock GL Transaction checkbox is determined automatically based on the settings of the selected Warehouse.
If the Separate Inventory and Financial Documents option is enabled for the selected Warehouse, the system automatically enables the Stock GL Transaction checkbox in purchasing documents.
Warehouse setting:
Separate Inventory and Financial Documents = Enabled
Document setting:
Stock GL Transaction = Enabled
This behavior applies to all documents within the purchasing chain starting from the Purchase Order.
When a new purchasing document is created, the system checks the Warehouse settings, including when the Warehouse is automatically populated from Personal Settings.
To enable automatic determination of the Stock GL Transaction checkbox, the following option must be enabled in the Warehouse settings:
Separate Inventory and Financial Documents
When this option is enabled, financial and inventory transactions are processed separately during the purchasing process.
When Stock GL Transaction is enabled:
Therefore, the financial recognition of the purchase and the actual receipt of goods can be processed using separate documents.
When Stock GL Transaction is enabled, additional movements are generated in the Inventory on Hand accumulation register when the documents are posted.
When the Invoice Received document created from the Purchase Order is posted, the system generates an additional consumption movement in the Inventory on Hand register.
At this stage, the goods have not yet been recorded as physically received into the Warehouse.
If the corresponding Material Receipt Note has not yet been posted, the reporting may show the goods as invoiced but not received.
When the Material Receipt Note is posted, the system generates the corresponding receipt movement in the Inventory on Hand register.
After both documents are posted:
the movements generated in the Inventory on Hand register offset each other, and the resulting balance becomes zero.
This behavior is standard and supports scenarios where the financial recognition of the purchase and the actual receipt of goods are processed separately.
When using Stock GL Transaction, consider the sequence in which the purchasing documents are posted.
If the Invoice Received has already been posted but the corresponding MRN has not yet been posted, the financial part of the purchase has already been recognized, while the actual receipt of the goods has not yet been recorded.
In this situation, the purchasing analysis may show the goods as invoiced but not received.
This is an intermediate state. After the corresponding Material Receipt Note is posted, the actual receipt of the goods is recorded in the system.
After the Material Receipt Note is posted, the actual receipt of the goods is recorded in the system.
As a result, the movements generated by Invoice Received and Material Receipt Note offset each other in the Inventory on Hand register, and the resulting balance becomes zero.
To identify purchases where the goods have already been recorded in Invoice Received but the actual receipt has not yet been recorded, use the Consolidated Analysis by Purchase Orders report.
In the report, pay attention to situations where the goods are shown as invoiced but not received.
The report can be opened directly from a selected Purchase Order. In this case, the analysis is generated for that particular Purchase Order.
The report is also available via:
Purchasing → Reports → Consolidated Analysis by Purchase Orders
This option allows you to review the information for multiple Purchase Orders.
If the report shows an invoiced but not received situation, check the corresponding Material Receipt Note and post it, if required, to record the actual receipt of the goods.
Starting from release 2.1.1.35:
This behavior is standard for FirstBIT Contracting starting from release 2.1.1.35.
Thank you for being FirstBIT Customer!