Project Inventory Tracking by Warehouse Location: Generated Transactions
When you process a purchase order for a project, you create purchase receipts and accounts payable bills. On release of the inventory receipt associated with the purchase receipt or the AP bill, the system generates the GL and project transactions described in the following sections.
GL Transactions Generated on Inventory Receipt Release
When an inventory receipt created on release of a purchase receipt prepared for a purchase order is released, the system creates a batch of the general ledger transactions shown in the table below.
The system uses the following accounts as the source of the debited account in the GL batch it creates:
- The inventory account, which is specified for the posting class of a stock item in the Inventory/Accrual Account box on the GL Accounts tab of the Posting Classes (IN206000) form.
- The expense account, which is specified for the posting class of a non-stock item that requires receipt in the COGS/Expense Account box on the GL Accounts tab of the Posting Classes form.
| Account | Source of Account | Debit | Credit |
|---|---|---|---|
| PO accrual account | Item | 0.00 | Amount |
| Inventory/expense account | Posting class of the item | Amount | 0.00 |
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 batch on the Journal Transactions (GL301000) form.
Project Transaction Generated on Inventory Receipt Release
When a batch of general ledger transactions created on release of the inventory receipt is released, the system generates the project transaction shown in the following table.
| Debit Account | Credit Account | Source of Account | Amount |
|---|---|---|---|
| Inventory/expense account | Empty | GL transaction | Amount |
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 AP Bill Release
When an accounts payable bill prepared for a service line of a purchase order is released, the system creates a batch of the general ledger transactions shown in the following table.
| Account | Source of Account | Debit | Credit |
|---|---|---|---|
| Accounts payable account | Vendor | 0.00 | Amount |
| Expense account | Item | Amount | 0.00 |
On the Financial tab (Link to GL section) of the Bills and Adjustments (AP301000) form, you can click the link in the Batch Nbr. box to view the details of the batch on the Journal Transactions (GL301000) form.
Project Transaction Generated on AP Bill Release
When a batch of general ledger transactions is created on release of an accounts payable bill, the system also generates the project transaction shown in the following table.
| Debit Account | Credit Account | Source of Account | Amount |
|---|---|---|---|
| Expense account | Empty | GL transaction | Amount |
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. In the table, you can find the project transaction created on release of the accounts payable bill by the reference number of the AP bill in the Orig. Doc. Nbr. column.