Project Inventory Tracking: Generated Transactions

The following sections describe the GL transactions and project transactions that are generated for sales and purchases of stock items and non-stock items requiring receipt for projects.

Note:
For the list of transactions that are generated for non-stock items not requiring receipt that are being purchased for projects, see Purchasing Services for Projects: Generated Transactions.

GL Transactions Generated on Release of an Inventory Receipt

On release of a project-related purchase receipt with a stock item, the corresponding inventory receipt is created. When the inventory receipt is released, the system creates the following batch of general ledger transaction.

AccountSource of AccountProjectDebitCredit
Inventory accountPosting class of the itemX (non-project code)Received amount (quantity * item price)0.00
PO accrual accountPosting class of the itemX (non-project code)0.00Received amount (quantity * item price)

On release of a project-related purchase receipt with a non-stock item requiring receipt, the corresponding inventory receipt is created. When the inventory receipt is released, the system creates the following batch of general ledger transaction.

AccountSource of AccountProject Budget KeyDebitCredit
Expense accountInventory itemProject, project task, and cost code in the inventory receipt lineReceived amount (quantity * item price)0.00
Inventory accountInventory itemX (non-project code)0.00Received amount (quantity * item price)

On the Financial tab of the Receipts (IN301000) form, you can click the link in the Batch Nbr. box to view the details of the general ledger transaction on the Journal Transactions (GL301000) form.

Project Transaction Generated on Release of the Inventory Receipt

On release of the general ledger transaction which was created on release of the inventory receipt with a stock item, the system generates no project transaction.

On release of the general ledger transaction which was created on release of the inventory receipt with a non-stock item requiring receipt, the system generates the following project transaction.

Project Budget Key Account Group Debit AccountAmount
Project, project task, inventory item, and cost code in inventory receipt line Account group mapped to the Expense account of the itemExpense account of the itemAmount

You can review the created project transaction on the Project Transaction Details (PM401000) form. In the Selection area of this form, you select the project in the Project box.

GL Transactions Generated on Release of an Inventory Issue

On release of an inventory issue with a stock item issued for a project, the system generates a batch of general ledger transactions.

AccountSource of AccountProject Budget KeyDebitCredit
PO Accrual accountPosting class of the itemX (non-project code) 0.00Issued amount (quantity * item cost)
Expense accountReason code in the inventory issue lineProject, project task, and cost code in the inventory issue line Issued amount (quantity * item cost)0.00

You can view the reference number of the GL batch in the Batch Nbr. box on the Financial tab of the Issues (IN302000) form. You can click the link in this box to view the details of the batch on the Journal Transactions (GL301000) form.

Project Transaction Generated on Release of the Inventory Issue

On release of the general ledger transaction created on release of the inventory issue with a stock item for project, the system generates the following project transaction that updates the project's actual amounts:

Project Budget Key Account Group Debit AccountAmount
Project, project task, inventory item, and cost code in inventory issue line Account group mapped to the GOGS accountCOGS account of the itemAmount

You can review the created project transaction on the Project Transaction Details (PM401000) form. In the Selection area of this form, you select the project in the Project box.