Inventory Transactions to Journals

Order and Inventory Management – Accounting Connector can create journals in Accounting from relevant inventory transaction perpetual records in Order and Inventory Management.

For more information about these objects, see the following:

• Inventory Transaction Perpetual Record Fields
• What is a Journal?

Eligible Inventory Transactions

For a journal to be created, the value of the Inventory Transactions field of the perpetual record must be one of the following:

• "Accrual Reversal"
• "Add Logistics Cost"
• "Add Service Cost"
• "Adjust Current Value"
• "Allocate Production Order Items"
• "AP Voucher Credit"
• "Bill Drop Ship Item"
• "Confirm Production Order Pick-list"
• "Credit Drop Ship Item"
• "Credit Use Tax"
• "Cycle Count"
• "Inspection Reject Return Parts to Vendor"
• "Inspection Reject Scrap Parts"
• "Issue Customer Items Pick-list"
• "Issue Production Order Pick"
• "Issue Supplier Items Pick-list"
• "Item Changed Ownership"
• "Item Transfer Inbound"
• "Item Transfer Outbound"
• "Manufacture Item"
• "Miscellaneous Issue"
• "Miscellaneous Receipt"
• "PPV"
• "Receive Customer Returned Material"
• "Receive Exchanged Items (Cores)"
• "Receive Purchased Material"
• "Removed from Inventory - Consumed in Service Purchase Order"
• "Reverse Receive Customer Returned Material"
• "Reverse Receive Purchased Material"
• "Reverse Production Order Allocation"
• "Scrap Inventory"
• "Use Tax"
• "Void PPV"
• Custom inventory transaction type

Automatically Populated Fields

When inventory transactions are created, Order and Inventory Management – Accounting Connector automatically populates certain fields that are required for creating a journal. The tables below provide more information.

Inventory Transaction Perpetual Records

Fields Automatically Populated on an Inventory Transaction Perpetual Record

Field	Description
Accounting Company	Determined as follows: If the Accounting Company field of the related ICP is defined, that company is used. If the Company Name field is defined for the related purchase order, this is set to the Accounting company with the same name. Depending on the type of perpetual record, it might be linked directly to a purchase order or through an AP voucher.
Accounting Currency	Set to the Accounting currency that belongs to the Accounting company has the same ISO code as one of the following currencies: The currency of the ICP of the warehouse to which the related purchase order belongs. The currency of the related purchase order.
Journal Date	Determined as follows: If the value of the Inventory Transactions field is "Bill Drop Ship Item", this is set to the Invoice Date field from the related invoice. If the value of the Inventory Transactions field is "PPV" or “Accrual Reversal”, this is set to the Invoice Date field from the related AP voucher. Otherwise, this is set to the date on which the perpetual record was created.

Journal Type

The Journal Type field is determined based on the value of the Inventory Transactions field on the perpetual record. The table below provides more information.

Inventory Transactions to Journal Type Mappings

Inventory Transactions	Journal Type
"Bill Drop Ship Item"	"SCM Drop Ship Journal"
"Credit Drop Ship Item"
"Accrual Reversal"	"SCM Procurement Journal"
"AP Voucher Credit"
"PPV"
"Use Tax"
"Void PPV"
"Add Logistics Cost"	"SCM Inventory Journal"
"Add Service Cost"
"Adjust Current Value"
"Allocate Production Order Items"
"Confirm Production Order Pick-list"
"Cycle Count"
"Inspection Reject Return Parts to Vendor"
"Inspection Reject Scrap Parts"
"Issue Customer Items Pick-list"
"Issue Production Order Pick"
"Issue Supplier Items Pick-list"
"Item Changed Ownership"
"Item Transfer Inbound"
"Item Transfer Outbound"
"Manufacture Item"
"Miscellaneous Issue"
"Miscellaneous Receipt"
"Receive Customer Returned Material"
"Receive Exchanged Items (Cores)"
"Receive Purchased Material"
"Removed from Inventory - Consumed in Service Purchase Order"
"Reverse Production Order Allocation"
"Reverse Receive Customer Returned Material"
"Reverse Receive Purchased Material"
"Scrap Inventory"

Inventory Transaction Financial Records

The General Ledger Account field on inventory transaction financial records is populated from related records or from GL account mapping records. The table below provides more information about how the connector determines the general ledger account from records related to the financial record.

Conditions for Populating the General Ledger Account Field on an Inventory Transaction Perpetual Record

Conditions	Value
The value of the GL Account field is "PPV". The value of the Inventory Transactions field of the related perpetual record is "PPV". The related purchase order line item is of type "Category".	Inventory Transaction > Purchase Order Line Item > Category > Purchase Analysis GLA for Category
The value of the GL Account field is "Expenses". The related purchase order line item is of type "Capital Equipment".	Inventory Transaction > Purchase Order Line Item > General Ledger Account or Inventory Transaction > Purchase Order Line Item > Item Being Procured > Product Group > Product > Purchase Analysis Account
The value of the GL Account field is "Expenses" or "AP Liability". The related purchase order line item is of type "Description".	Inventory Transaction > Purchase Order Line Item > General Ledger Account or Inventory Transaction > Purchase Order Line Item > Item Being Procured > Product Group > Product > Purchase Analysis Account
The value of the GL Account field is "Expenses". The related purchase order line item is of type "Category".	Inventory Transaction > Purchase Order Line Item > General Ledger Account or Inventory Transaction > Purchase Order Line Item > Category > Purchase Analysis GLA for Category
The value of the GL Account field is "Inventory". The value of the Inventory Transactions field of the related perpetual record is "Removed from Inventory - Consumed in Service Purchase Order".	Inventory Transaction > Purchase Order Line Item > Item Being Procured > Product Group > Inventory GLA
The value of the GL Account field is "Inventory". The value of the Inventory Transactions field of the related perpetual record is not "Removed from Inventory - Consumed in Service Purchase Order".	Inventory Transaction > Item Master > Product Group > Inventory GLA
The value of the GL Account field is "Cost of Goods Sold".	Inventory Transaction > Item Master > Product Group > Cost of Goods Sold GLA
The value of the GL Account field is "Miscellaneous".	Inventory Transaction > Reason Code > General Ledger Account

In all remaining cases, the General Ledger Account field is determined from the relevant GL account mapping records. For more, see Mapping Order and Inventory Management GL Accounts to Accounting General Ledger Accounts.

Creating Journals from Inventory Transactions

You can create journals from inventory transactions in several ways:

• Manually, by clicking Create from Inventory Transactions on the Journals list view. For more information, see Creating Journals from All Eligible Inventory Transactions.
• Automatically, when the inventory perpetual record is created or based on custom criteria defined in your org. For more information, contact your administrator and see Setting up Automatic Document Creation.
• Automatically, when a scheduled job executes. For more information, contact your administrator and see Managing Scheduled Jobs.

Mappings

The following table lists how fields on the Inventory Transaction Perpetual Record object map to the relevant fields on the Journal object. In some cases, the connector provides static values.

Note:

Your administrator might have changed the default mappings or added custom mappings.

Default Mappings between Inventory Transaction Perpetual Record Fields and Journal Fields

Inventory Transaction Perpetual Record Field	Static Value	Journal Field
Accounting Company		Company
Accounting Currency		Journal Currency
AP Voucher > Period		Period
Journal Date		Journal Date
Journal Type		Type
Inventory Transactions		Journal Description
Inventory Transactions		Reference
Record ID		Inventory Transaction Perpetual Record
	Deselected (false)	Derive Currency
	Selected (true)	Derive Period

Once a journal is created from a perpetual record, the Export Status field on the perpetual record is set to "Exported" and the Journal field is populated with the newly created journal.

Note:

When you create a journal from Inventory Transaction Perpetual Record with the value "PPV" or "Accrual Reversal", it checks first if the period of the related AP Voucher is populated. If it is populated and not closed, the journal is created without error. If the period is not populated, it checks the journal date which is automatically populated from the invoice date of the related AP Voucher.

Line Items

When creating the journal, inventory transaction financial records are used to create journal line items.

The following table lists how fields on the Inventory Transaction Financial Record object map to the relevant fields on the Journal Line Item object. In some cases, the connector looks up information from related records or provides static values.

Default Mappings between Inventory Transaction Financial Record Fields and Journal Line Item Fields

Inventory Transaction Financial Record Field	Static Value	Journal Line Item Field
GL Account		Line Description
General Ledger Account		General Ledger Account
ICP Value Amount		Value
Inventory Transaction > Item > Product Group > Dimension 1		Dimension 1
Inventory Transaction > Item > Product Group > Dimension 2		Dimension 2
Inventory Transaction > Item > Product Group > Dimension 3		Dimension 3
Inventory Transaction > Item > Product Group > Dimension 4		Dimension 4
Record ID		Inventory Transaction Financial Record
	"General Ledger Account"	Line Type