This appendix covers the following topics:
The Global Accounting Engine provides an accounting system for Oracle subledger applications, including Oracle Payables, Oracle Receivables, and Oracle Inventory that satisfies legal and fiscal requirements in certain countries.
You can create subledger journal entries for Inventory and Work In Process (WIP) material transactions using permanent inventory accounting rules. There are Subledger Accounting (SLA) rules with the same functionality that is made available by the Global Accounting Engine (AX) rules in previous releases. Inventory rules from prior releases of the Global Accounting Engine (AX) are compatible with rules in the Sub Ledger Accounting (SLA) architecture.
In European countries, a local statute requires that Inventory Accounting be expressed in revenue and expense terms.
In release 11i, Warehouse Management (WMS) and Project Manufacturing (PJM) products were released which processes accounting for standard costing at the cost group level. However, for standard cost organizations, 11i AX accounting for expense was derived based on sub-inventory.
European customers can use WMS and PJM in standard costing to comply with these local statutory accounting requirements. Category accounting for permanent inventory supports WMS and PJM cost group accounting derivations.
Note: Customers using the 11i AX Global Accounting engine along with PJM and WMS require functionality to derive category accounts based on cost groups in a standard accounting setup. This requirement is fulfilled in the R12.1.1+ Permanent Inventory Application Accounting setup. R12.1.1 customers must apply patch 10244514:R12.BOM.C to use this functionality.
Enhanced category accounting sources in Subledger Accounting (SLA) for costing used in permanent inventory to support the flexibility required to use cost group derivation in standard costing preserves backward compatibility with current design, which is sub-inventory based. The category account for permanent inventory in a standard cost environment is derived based on sub-inventory.
If you are required to change to the cost group account derivation method, then the following setup is required:
Prerequisites
Permanent Inventory Accounting for PJM enabled organization in standard.
Costing will use the cost group derivation method if the following parameters are met:
The organization is using Perpetual Standard Costing.
The organization is a project reference-able PJM organization.
The PJM organization Cost Group Option is by Project.
The Profile Option CST: Category Account Level is Cost Group.
Without the above prerequisites, category accounts are derived based on sub-inventory only.
If you choose to keep the sub-inventory category account derivation, then you must set the CST: Category Account Level profile option to Sub-Inventory.
Note: The category accounts setup window has been modified to support category account setup according to the profile option. Oracle has pre-seeded the category accounts derivation for PJM and WMS in Permanent Inventory AAD to support this setup.
If you require more complex logic for sub-inventory or cost group for standard costing, the standard cost hook CSTPSCHK.cg_or_subinv has been released:
CSTPSCHK.cg_or_subinv | |
(p_organization_id | IN NUMBER |
,p_primary_cost_method | IN NUMBER |
,p_wms_enabled | IN VARCHAR2 |
,p_pjm_reference | IN NUMBER |
,p_cost_group_accounting | IN NUMBER |
,p_cost_group_id | IN NUMBER |
,p_subinv | IN VARCHAR2 |
,p_ship_recv | IN VARCHAR2 |
,p_mmt_id | IN NUMBER DEFAULT NULL) |
RETURN VARCHAR2 |
By default, the application uses the cost group or sub-inventory derivation method according to the standard setup. However, you can change the derivation criteria at the transaction level.
This section describes the setup required for AX support in Subledger Accounting (SLA).
To set up the Subledger Accounting Method:
Navigate to the Subledger Accounting Methods window. In the Find Subledger Accounting Methods window, click the New button to create a new method, or enter search criteria to view existing subledger accounting methods.
Click New to create a Subledger Accounting Method for the Costing application.
Save your work.
To set up the Item Category flexfield structure:
Navigate to the Key Flexfield Segments window.
Enter Accounting (Item) Category details.
Save your work.
To set up the Product Line Category:
From the Inventory responsibility, navigate to the Categories window.
Create a Category Code.
Create a Category Set.
Assign a Product Line Accounting functional area category set.
Save your work.
To set up Category Accounts:
Navigate to the Category Accounts window.
Enter Category Account details.
Save your work.
To assign the Product Line Category to items:
Navigate to the Organization Item window.
Select an Item from the Find Organization Items window..
From the Tools menu, choose Categories. The Category Assignment window appears.
Enter the Category Set, Control Level, and Category.
Save your work.
The inter-organization bridging, expense, and revenue accounts are set up in the Shipping Networks window.
The WIP bridging and expense accounts are set up in the WIP Accounting Class window.
Existing inventory rules in the Global Accounting Engine will be migrated into the Subledger Accounting Architecture. The rules have been migrated according to t
he specifications defined in the following sections.
Transaction | Scenario | Expected Journal Entry | DR | CR |
---|---|---|---|---|
Receipt into receiving inspection | One-time item delivered to an expense destination | 10 units of item @11.00 Receiving Area Quantity * PO price Expense Quantity * PO price |
110.00 |
110.00 |
Asset item delivered to an expense destination | 10 units of item @11.00 Receiving Area Quantity * PO price Expense Quantity * PO price |
110.00 |
110.00 |
|
Asset item delivered to an inventory destination | 10 units of item @11.00 Receiving Area Quantity * PO price Inventory AP Accrual Quantity * PO price |
110.00 |
110.00 |
|
Expense item delivered to an inventory destination | 10 units of item @11.00 Receiving Area Quantity * PO price Inventory AP Accrual Quantity * PO price |
110.00 |
110.00 |
|
OSP Item with Shop Floor Destination | 10 units of item @11.00 Receiving Area Quantity * PO price Inventory AP Accrual Quantity * PO price |
110.00 |
110.00 |
|
Return to Supplier from receiving inspection | Asset item delivered to an inventory destination | 10 units of item @11.00 Receiving Area Quantity * PO price Inventory AP Accrual Quantity * PO price |
110.00 |
110.00 |
PO Delivery to Expense Destination | One-time item delivered to an expense destination | 10 units of item @11.00 Receiving Area Quantity * PO price Expense Quantity * PO price |
110.00 |
110.00 |
Asset item delivered to an expense destination | 10 units of item @11.00 Receiving Area Quantity * PO price Expense Quantity * PO price |
110.00 |
110.00 |
|
Expense item delivered to an expense destination | 10 units of item @11.00 Receiving Area Quantity * PO price Expense Quantity * PO price |
110.00 |
110.00 |
|
PO Delivery to Inventory Destination | Asset item delivered to an asset sub inventory (standard cost) | 10 units of item @ 11.00 Material Quantity * standard cost (excluding material overhead) Material Overhead Quantity * material overhead cost Overhead Absorption Quantity * material overhead cost Purchase Price Variance Quantity * (PO price - standard cost excluding material overhead) Bridging Quantity * PO price Receiving Area Quantity * PO price Expense Quantity * PO price |
900.00 300.00 200.00 1100.00 |
300.00 1100.00 1100.00 |
Asset item delivered to an expense sub inventory (standard cost) | 10 units of item @11.00 Receiving Area Quantity * PO price Expense Quantity * PO price |
110.00 |
110.00 |
|
Expense item delivered to an asset sub inventory (standard cost) | 10 units of item @11.00 Receiving Area Quantity * PO price Expense Quantity * PO price |
110.00 |
110.00 |
|
Expense item delivered to an expense sub inventory (standard cost) | 10 units of item @11.00 Receiving Area Quantity * PO price Expense Quantity * PO price |
110.00 |
110.00 |
|
Asset item delivered to an asset sub inventory (average cost) | 10 units of item 200.6 @ 1500.00 Material Quantity * PO price Material Overhead Quantity * PO price Overhead Absorption Quantity * material overhead cost Bridging Quantity * PO price Receiving Area Quantity * PO price Expense Quantity * PO price |
15000.00 1500.00 15000.00 |
1500.00 15000.00 15000.00 |
|
Asset item delivered to an expense sub inventory (average cost) | 10 units of item 200.6 @ 1500.00 Receiving Area Quantity * PO price Expense Quantity * PO price |
15000.00 |
15000.00 |
|
Expense item delivered to an asset sub inventory (average cost) | 10 units of item 200.8 @ 1500.00 Receiving Area Quantity * PO price Expense Quantity * PO price |
15000.00 |
15000.00 |
|
Expense item delivered to an expense sub inventory (average cost) | 10 units of item 200.8 @ 1500.00 Receiving Area Quantity * PO price Expense Quantity * PO price |
15000.00 |
15000.00 |
|
Return to Receiving from expense destination | 10 units of item @11.00 Receiving Area Quantity * PO price Expense Quantity * PO price |
110.00 |
110.00 |
|
Return to Receiving from inventory destination | 10 units of item @11.00 Material Quantity * standard cost (excluding material overhead) Material Overhead Quantity * material overhead cost Overhead Absorption Quantity * material overhead cost Purchase Price Variance Quantity * (PO price - standard cost excluding material overhead) Bridging Quantity * PO price Receiving Area Quantity * PO price Expense Quantity * PO price |
300.00 1100.00 1100.00 |
900.00 300.00 200.00 11.00 |
|
Return to Supplier from Inventory | Standard cost | 3 units of item @ 11.00 Material Quantity * standard cost (excluding material overhead) Material Overhead Quantity * material overhead cost Overhead Absorption Quantity * material overhead cost Purchase Price Variance Quantity * (PO price - standard cost excluding material overhead) Bridging Quantity * PO price Receiving Area Quantity * PO price Expense Quantity * PO price |
9.00 33.00 33.00 |
27.00 9.00 6.00 33.00 |
Average cost | 1 unit of item @ 1500.00 Material Quantity * PO price Material Overhead Quantity * material overhead cost Overhead Absorption Quantity * material overhead cost Bridging Quantity * PO price Receiving Area Quantity * PO price Expense Quantity * PO price |
150.00 1500.00 1500.00 |
1500.00 150.00 1500.00 |
|
Transfer from Consignment to Regular Inventory | Asset item delivered to an asset sub inventory (standard cost) | 10 units of item @ 11.00 Material Quantity * standard cost (excluding material overhead) Material Overhead Quantity * material overhead cost Overhead Absorption Quantity * material overhead cost Purchase Price Variance Quantity * (PO price - standard cost excluding material overhead) Bridging Quantity * PO price AP Accrual Quantity * PO price Expense Quantity * PO price |
900.00 300.00 200.00 1100.00 |
300.00 1100.00 1100.00 |
Transfer from Regular to Consignment Inventory | 10 units of item @ 11.00 Material Quantity * standard cost (excluding material overhead) Material Overhead Quantity * material overhead cost Overhead Absorption Quantity * material overhead cost Purchase Price Variance Quantity * (PO price - standard cost excluding material overhead) Bridging Quantity * PO price AP Accrual Quantity * PO price Expense Quantity * PO price |
300.00 1100.00 1100.00 |
900.00 300.00 200.00 1100.00 |
|
Delivery Adjustment on a PO | Standard cost | 2 units of item @ 11.00 Material Quantity * standard cost (excluding material overhead) Material Overhead Quantity * material overhead cost Overhead Absorption Quantity * material overhead cost Purchase Price Variance Quantity * (PO price - standard cost excluding material overhead) Bridging Quantity * PO price Receiving Area Quantity * PO price Expense Quantity * PO price |
18.00 6.00 4.00 22.00 |
6.00 22.00 22.00 |
Average cost | -10 units of item @ 1500.00 Material Quantity * PO price Material Overhead Quantity * material overhead cost Overhead Absorption Quantity * material overhead cost Bridging Quantity * PO price Receiving Area Quantity * PO price Expense Quantity * PO price |
1500.00 15000.00 |
15000.00 1500.00 15000.00 15000.00 |
Transaction | Scenario | Expected Journal Entry | DR | CR |
---|---|---|---|---|
Miscellaneous Receipt, Account Receipt, Account Alias Receipt | Miscellaneous receipt of an asset item from an asset sub inventory (standard cost) | 10 units of item @ 55.00 Material Quantity * standard cost Material Overhead Quantity * standard cost Inventory Offset Quantity * standard cost |
500.00 50.00 |
550.00 |
Miscellaneous Issue, Account Issue, Account Alias Issue | Miscellaneous issue of an asset item from an asset sub inventory (standard cost) | 10 units of item @ 55.00 Material Quantity * standard cost Material Overhead Quantity * standard cost Inventory Offset Quantity * standard cost |
550.00 |
500.00 50.00 |
Miscellaneous Receipt, Account Receipt, Account Alias Receipt | Miscellaneous receipt of an asset item from an asset subinventory (average cost) | 1 unit of item @ 1100.00 Material Quantity * current cost or quantity * entered cost Material Overhead Quantity * current cost or quantity * entered cost Inventory Offset Quantity * current cost or quantity * entered cost |
1000.00 100.00 |
1100.00 |
Miscellaneous Issue, Account Issue, Account Alias Issue | Miscellaneous issue of an asset item from an asset sub inventory (average cost) | 1 unit of item @ 1100.00 Material Quantity * current cost or quantity * entered cost Material Overhead Quantity * current cost or quantity * entered cost Inventory Offset Quantity * current cost or quantity * entered cost |
1100.00 |
1000.00 100.00 |
Sub inventory Transfer | Transfer of an asset item, between two asset sub inventories (standard cost) | 4 units of item @ 12.00 Material (Sending sub inventory) Quantity * standard cost Material Overhead (Sending sub inventory) Quantity * standard cost Bridging (Sending sub inventory) Quantity * standard cost Material (Receiving sub inventory) Quantity * standard cost Material (Receiving sub inventory) Quantity * standard cost Bridging (Receiving sub inventory) Quantity * standard cost |
48.00 36.00 12.00 |
36.00 12.00 48.00 |
Transfer of an asset item, between an asset sub inventory and an expense sub inventory (standard cost) | 4 units of item @ 12.00 Material (Sending sub inventory) Quantity * standard cost Material Overhead (Sending sub inventory) Quantity * standard cost Bridging (Sending sub inventory) Quantity * standard cost Expense (Receiving sub inventory) Quantity * standard cost Expense (Sending sub inventory) Quantity * standard cost |
48.00 48.00 |
36.00 12.00 48.00 |
|
Sub inventory Transfer | Transfer of an asset item, between two asset sub inventories (average cost) | 1 unit of item @ 1100.00 Material (Sending sub inventory) Quantity * current cost Material Overhead Quantity * current cost or quantity * entered cost Bridging (Sending sub-inventory) Quantity * current cost Material (Receiving sub-inventory) Quantity * current cost Material Overhead Quantity * current cost or quantity * entered cost Bridging (Receiving sub-inventory) Quantity * current cost |
1100.00 1000.00 100.00 |
1000.00 100.00 1100.00 |
Transfer of an asset item, between an asset sub inventory and an expense sub inventory (average cost) | 1 unit of item @ 1100.00 Material (Sending sub inventory) Quantity * standard cost Material Overhead (Sending sub-inventory) Quantity * standard cost Bridging (Sending sub inventory) Quantity * standard cost Expense (Receiving sub-inventory) Quantity * standard cost Expense (Sending sub-inventory) Quantity * standard cost |
1100.00 1100.00 |
1000.00 100.00 1100.00 |
|
Sales Order pick, Internal Order pick | Transfer of an asset item, between two asset sub-inventories (standard cost) | 4 units of item @ 12.00 Material (Sending sub-inventory) Quantity * standard cost Material Overhead (Sending sub-inventory) Quantity * standard cost Bridging (Sending sub-inventory) Quantity * standard cost Material (Receiving sub-inventory) Quantity * standard cost Material (Receiving sub-inventory) Quantity * standard cost Bridging (Receiving sub-inventory) Quantity * current cost |
48.00 36.00 12.00 |
36.00 12.00 48.00 |
Sales Order issue | Asset item (standard cost) | 4 units of item @ 114.10 Material Quantity * standard cost Material Overhead Quantity * standard cost Resources Quantity * standard cost Overhead Quantity * standard cost Deferred Cost of Goods Sold Quantity * standard cost |
456.40 |
96.00 32.00 284.00 44.44 |
Asset item (average cost) | 1 unit of item @ 2956.00 Material Quantity * current cost Material Overhead Quantity * current cost Resources Quantity * current cost Overhead Quantity * current cost Deferred Cost of Goods Sold Quantity * current cost |
2956.00 |
1500.00 150.00 1110.00 196.00 |
|
RMA Receipt | Asset item in asset sub inventory (standard cost) | 2 units of item 300.1 Material Quantity * standard cost Material Overhead Quantity * standard cost Resources Quantity * standard cost Overhead Quantity * standard cost Deferred Cost of Goods Sold Quantity * standard cost |
48.00 16.00 142.00 22.20 |
228.20 |
Asset item in asset sub-inventory (average cost) | 1 unit of item @ 2956.00 Material Quantity * current cost Material Overhead Quantity * current cost Resources Quantity * current cost Overhead Quantity * current cost Deferred Cost of Goods Sold Quantity * current cost |
1500.00 150.00 1110.00 196.00 |
2956.00 |
|
Move Order Issue | Asset item issued from an asset sub-inventory (standard cost) | 10 units of item @ 55.00 Material Quantity * standard cost Material Overhead Quantity * standard cost Move Order Account Quantity * standard cost |
550.00 |
500.00 50.00 |
Asset item issued from an asset sub-inventory (average cost) | 10 units of item @ 55.00 Material Quantity * average cost Material Overhead Quantity * average cost Move Order Account Quantity * average cost |
550.00 |
500.00 50.00 |
|
Move Order Transfer, Internal Order Transfer | Transfer of an asset item, between two asset sub-inventories (standard cost) | 4 units of item @ 12.00 Material (Sending sub-inventory) Quantity * standard cost Material Overhead (Sending sub-inventory) Quantity * standard cost Bridging (Sending sub-inventory) Quantity * standard cost Material (Receiving sub-inventory) Quantity * standard cost Material (Receiving sub-inventory) Quantity * standard cost Bridging (Receiving sub-inventory) Quantity * current cost |
48.00 36.00 12.00 |
36.00 12.00 48.00 |
Transfer of an asset item, between two asset sub-inventories (average cost) | 4 units of item @ 12.00 Material (Sending sub-inventory) Quantity * average cost Material Overhead (Sending sub-inventory) Quantity * average cost Bridging (Sending sub-inventory) Quantity * average cost Material (Receiving sub-inventory) Quantity * average cost Material (Receiving sub-inventory) Quantity * average cost Bridging (Receiving sub-inventory) Quantity * average cost |
48.00 36.00 12.00 |
36.00 12.00 48.00 |
|
Internal Order Issue | Asset item issued from asset sub-inventory (average cost) | 1 unit of item @ 1100.00 Material Quantity * current cost Material Overhead Quantity * current cost or quantity * entered cost Internal Requisition Distribution Charge Account Quantity * current cost |
1100.00 |
1000.00 100.00 |
Cycle Count Adjustment | Standard cost | -1 unit of item @ 12.00 Material Quantity difference * standard cost Material Overhead Quantity * standard cost difference Inventory Offset Quantity difference * standard cost |
12.00 |
9.00 3.00 |
Average cost | -1 unit of item @ 2200.00 Material Quantity difference * current cost Material Overhead Quantity difference * current cost Inventory Offset Quantity difference * current cost |
2200.00 |
2000.00 200.00 |
|
Physical Inventory Adjustment | Standard cost | -2 units of item @ 132.00 Material Quantity difference * standard cost Material Overhead Quantity * standard cost difference Inventory Offset Quantity difference * standard cost |
264.00 |
240.00 24.00 |
Average cost | -2 units of item @ 1320.00 Material Quantity difference * current cost Material Overhead Quantity difference * current cost Inventory Offset Quantity difference * current cost |
2640.00 |
2400.00 240.00 |
|
Average Cost Update | 1 unit of item 200.6 Material Quantity * average cost difference Material Overhead Quantity * current cost Cost Update Adjustment Account Quantity * average cost difference |
200.00 20.00 |
220.00 |
|
Standard Cost Update | 9 units of item @ 77.00 Material Quantity * standard cost difference Material Overhead Quantity * standard cost difference Cost Update Adjustment Account Quantity * standard cost difference |
630.00 63.00 |
693.00 |
Transaction | Scenario | Expected Journal Entry | DR | CR |
---|---|---|---|---|
Transfers Between two Organizations (In-transit, FOB : Receipt) | Sending Organization: standard cost Receiving Organization: standard cost | Ship to in-transit sourced from Inventory Material (Sending Organization) Quantity * standard cost Material Overhead (Sending Organization) Quantity * standard cost Bridging (Sending Organization) Quantity * standard cost In-transit (Sending Organization: Inter org account) Quantity * standard cost In-transit Bridging (Sending Organization: Inter org account) Quantity * standard cost |
60.00 60.00 |
45.00 15.00 60.00 |
Receive from In-transit In-transit (Sending Organization: Inter org account) Quantity * standard cost In-transit Bridging (Sending Organization: Inter org account) Quantity * standard cost Transfer (Sending Organization: Inter org account) Transfer cost Freight (Sending Organization: Freight account) Freight cost Receivables (Sending Organization: Inter org account ) (Quantity * standard cost) + transfer cost + freight cost Revenue (Sending Organization: Inter org account) Quantity * standard cost Material (Receiving Organization) Quantity * standard cost (excluding material overhead) Material Overhead (Receiving Organization) Quantity * material overhead cost Overhead Absorption (Receiving Organization) Quantity * material overhead cost Inter-org Price Variance (Receiving Organization: Inter org account) Quantity * (transaction cost - standard cost excluding material overhead) Bridging (Receiving Organization) Quantity * transaction cost Payables (Receiving Organization: Inter org account) Quantity * transaction cost Expense (Receiving Organization: Inter org account) Quantity * transaction cost |
60.00 78.00 45.00 15.00 33.00 78.00 |
60.00 11.00 7.00 60.00 15.00 78.00 78.00 |
||
Sending Organization: standard cost Receiving Organization: average cost | Ship to in-transit sourced from Inventory Material (Sending Organization) Quantity * standard cost Material Overhead (Sending Organization) Quantity * standard cost Bridging (Sending Organization) Quantity * standard cost In-transit (Sending Organization: Inter org account) Quantity * standard cost In-transit Bridging (Sending Organization: Inter org account) Quantity * standard cost |
60.00 60.00 |
45.00 15.00 60.00 |
|
Receive from In-transit In-transit (Sending Organization: Inter org account) Quantity * standard cost In-transit Bridging (Sending Organization: Inter org account) Quantity * standard cost Transfer (Sending Organization: Inter org account) Transfer cost Freight (Sending Organization: Freight account) Freight cost Receivables (Sending Organization: Inter org account ) (Quantity * standard cost) + transfer cost + freight cost Revenue (Sending Organization: Inter org account) Quantity * standard cost Material (Receiving Organization) quantity * transaction cost Material Overhead (Receiving Organization) Quantity * material overhead cost Overhead Absorption (Receiving Organization) Quantity * material overhead cost Bridging (Receiving Organization) Quantity * transaction cost Payables (Receiving Organization: Inter org account) Quantity * transaction cost Expense (Receiving Organization: Inter org account) Quantity * transaction cost |
60.00 78.00 78.00 7.80 78.00 78.00 |
60.00 11.00 7.00 60.00 7.80 78.00 |
||
Sending Organization : average cost Receiving Organization : average cost | Shipment Transaction 1 unit of item 200.6 Material (Sending Organization) Quantity * current cost Material Overhead (Sending Organization) Quantity * current cost In-transit (Sending Organization : Inter org account) Quantity * current cost Bridging (Sending Organization) Quantity * current cost In-transit Bridging (Sending Organization : Inter org account) Quantity * current cost |
1100.00 1100.00 |
1000.00 100.00 1100.00 |
|
Receipt Transaction In-transit (Sending Organization: Inter org account) Quantity * current cost Transfer (Sending Organization : Inter org account) Transfer cost Freight (Sending Organization : Inter org account) Freight cost Receivables (Sending Organization: Inter org account) (quantity * current cost) + transfer cost + transportation cost In-transit Bridging (Sending Organization : Inter org account) Quantity * current cost Revenue (Sending Organization : Inter org account) Quantity * current cost Material (Receiving Organization) Quantity * transaction cost Material Overhead (Receiving Organization) Quantity * material overhead cost Overhead Absorption (Receiving Organization) Quantity * material overhead cost Payables (Receiving Organization : Inter org account) Quantity * transaction cost Bridging (Receiving Organization) Quantity * transaction cost Expense (Receiving Organization : Inter org account) Quantity * transaction cost |
1565.00 1100.00 1565.00 156.50 1565.00 |
1100.00 145.00 320.00 1100.00 156.50 1565.00 1565.00 |
||
Sending Organization : average cost Receiving Organization : standard cost | Shipment Transaction 1 unit of item 200.6 Material (Sending Organization) Quantity * current cost Material Overhead (Sending Organization) Quantity * current cost In-transit (Sending Organization : Inter org account) Quantity * current cost Bridging (Sending Organization) Quantity * current cost In-transit Bridging (Sending Organization : Inter org account) Quantity * current cost |
1100.00 1100.00 |
1000.00 100.00 1100.00 |
|
Receipt Transaction In-transit (Sending Organization: Inter org account) Quantity * current cost Transfer (Sending Organization : Inter org account) Transfer cost Freight (Sending Organization : Inter org account) Freight cost Receivables (Sending Organization: Inter org account) (quantity * current cost) + transfer cost + transportation cost In-transit Bridging (Sending Organization : Inter org account) Quantity * current cost Revenue (Sending Organization : Inter org account) Quantity * current cost Material (Receiving Organization) Quantity * transaction cost Material Overhead (Receiving Organization) Quantity * material overhead cost Overhead Absorption (Receiving Organization) Quantity * material overhead cost Inter-org Price Variance (Receiving Organization) Quantity * (transaction cost - standard cost excluding material overhead) Payables (Receiving Organization : Inter org account) Quantity * transaction cost Bridging (Receiving Organization) Quantity * transaction cost Expense (Receiving Organization : Inter org account) Quantity * transaction cost |
1565.00 1100.00 1200.00 120.00 365.00 1565.00 |
1100.00 145.00 320.00 1100.00 120.00 1565.00 1565.00 |
||
Transfers Between two Organizations (Intransit, FOB : Shipment) | Sending Organization : standard cost Receiving Organization : standard cost | Ship to In-transit sourced from Inventory Material (Sending Organization) Quantity * standard cost Material Overhead (Sending Organization) Quantity * standard cost Bridging (Sending Organization) Quantity * standard cost Freight (Receiving Organization : Freight account) Freight cost Transfer (Sending Organization : Inter org account) Transfer cost Receivables (Sending Organization : Inter org account) (quantity * standard cost) + transfer cost only Revenue (Sending Organization : Inter org account) Quantity * standard cost In-transit (Receiving Org : Inter org account) Quantity * standard cost excluding material overhead Inter-org Price Variance (Receiving Org : Inter org account) Quantity * (transaction cost - standard cost excluding material overhead) In-transit Bridging (Receiving Org : Inter org account) Quantity * transaction cost Payables (Receiving Org : Inter org account) Quantity * transaction cost Expense (Receiving Organization : Inter org account) Quantity * transaction cost |
60.00 71.00 45.00 33.00 78.00 |
45.00 15.00 7.00 11.00 60.00 78.00 71.00 |
Receive from In-transit Material (Receiving Organization) (Broken down into its cost elements) Quantity * standard cost Material Overhead (Receiving Organization) Quantity * material overhead cost Overhead Absorption (Receiving Organization) Quantity * material overhead cost Bridging (Receiving Organization) Quantity * standard cost In-transit (Receiving Organization : Inter org account) Quantity * standard cost In-transit Bridging (Receiving Organization : Inter org account) Quantity * standard cost |
45.00 15.00 78.00 |
15.00 78.00 45.00 |
||
Sending Organization : standard cost Receiving Organization : average cost | Ship to In-transit sourced from Inventory Material (Sending Organization) Quantity * standard cost Material Overhead (Sending Organization) Quantity * standard cost Bridging (Sending Organization) Quantity * standard cost Freight (Receiving Organization : Freight account) Freight cost Transfer (Sending Organization : Inter org account) Transfer cost Receivables (Sending Organization : Inter org account) (quantity * standard cost) + transfer cost only Revenue (Sending Organization : Inter org account) Quantity * standard cost In-transit (Receiving Org : Inter org account) Quantity * transaction cost In-transit Bridging (Receiving Org : Inter org account) Quantity * transaction cost Payables (Receiving Org : Inter org account) Quantity * transaction cost Expense (Receiving Org : Inter org account) Quantity * transaction cost |
60.00 71.00 78.00 78.00 |
45.00 15.00 7.00 11.00 60.00 78.00 71.00 |
|
Receive from In-transit Material (Receiving Organization) Quantity * transaction cost Material Overhead (Receiving Organization) Quantity * material overhead cost Overhead Absorption (Receiving Organization) Quantity * material overhead cost Bridging (Receiving Organization) Quantity * transaction cost In-transit (Receiving Organization : Inter org account) Quantity * transaction cost In-transit Bridging (Receiving Organization : Inter org account) Quantity * transaction cost |
78.00 7.80 78.00 |
7.80 78.00 78.00 |
||
Sending Organization : average cost Receiving Organization : average cost | Shipment Transaction 1 unit of item 200.6 Material (Sending Organization) Quantity * current cost Material Overhead (Sending Organization) Quantity * current cost Bridging (Sending Organization) quantity * current cost Transfer (Sending Organization : Inter Org Account) Transfer cost Freight (Receiving Organization : freight account) Freight cost Receivables (Sending Organization : Inter Org Account) (quantity * current cost) + transfer cost + transportation cost Revenue (Sending Organization : Inter Org Account)Quantity * current cost In-transit (Receiving Org : Inter org account) Quantity * Transaction cost In-transit Bridging (Receiving Org : Inter org account) Quantity * transaction cost Payables (Receiving Org : Inter org account) Quantity * transaction cost Expense (Receiving Org : Inter org account) Quantity * transaction cost |
1100.00 1245.00 1565.00 1565.00 |
1000.00 100.00 145.00 320.00 1100.00 1565.00 1245.00 |
|
Receipt Transaction Material (Receiving Organization) Quantity * transaction cost Material Overhead (Receiving Organization) Quantity * material overhead cost Overhead Absorption (Receiving Organization) Quantity * material overhead cost Bridging (Receiving Organization) Quantity * transaction cost In-transit (Receiving Organization) Quantity * transaction cost In-transit Bridging (Inter org) Quantity * transaction cost |
1565.00 156.50 1565.00 |
156.50 1565.00 1565.00 |
||
Sending Organization : average cost Receiving Organization : standard cost | Shipment Transaction 1 unit of item 200.6 Material (Sending Organization) Quantity * current cost Material Overhead (Sending Organization) Quantity * current cost Bridging (Sending Organization) Quantity * current cost Transfer (Sending Organization : Inter Org Account) Transfer cost Freight (Receiving Organization : freigth account) Freight cost Receivables (Sending Organization : Inter Org Account) (quantity * current cost) + transfer cost + transportation cost Revenue (Sending Organization : Inter Org Account) Quantity * current cost In-transit (Receiving Org : Inter org account) Quantity * transaction cost In-transit Bridging (Receiving Org : Inter org account) Quantity * transaction cost Payables (Receiving Org : Inter org account) Quantity * transaction cost Expense (Receiving Org : Inter org account) Quantity * transaction cost |
1100.00 1245.00 1565.00 1565.00 |
1000.00 100.00 145.00 320.00 1100.00 1565.00 1245.00 |
|
Receipt Transaction Material (Receiving Organization) quantity * transaction cost Material Overhead (Receiving Organization) quantity * material overhead cost Overhead Absorption (Receiving Organization) quantity * material overhead cost Inter-org Price Variance (Receiving Organization) quantity * (transaction cost - standard cost excluding material overhead) Bridging (Receiving Organization) quantity * transaction cost In-transit (Receiving Organization) quantity * transaction cost In-transit Bridging (Inter org) quantity * transaction cost |
1200.00 120.00 365.00 1565.00 |
120.00 1565.00 1565.00 |
||
Direct Transfer between two Organizations | Sending Organization : standard cost Receiving Organization : standard cost | 5 units of item @ 12.00 Material (Sending Organization) Quantity * standard cost Material Overhead (Sending sub-inventory) Quantity * standard cost Bridging (Sending Organization) Quantity * standard cost Transfer (Sending Organization : Inter org account) tTransfer cost Freight (Sending Organization : freight account) Freight cost Receivables (Sending Organization : Inter org account) (quantity * standard cost) + transfer cost + freight cost Revenue (Sending Organization : Inter org account) Quantity * standard cost Material (Receiving Organization) Quantity * standard cost (excluding material overhead) Material overhead (Receiving Organization) Quantity * material overhead cost Overhead Absorption (Receiving Organization) Quantity * material overhead cost Inter-org Price Variance (Receiving Organization) Quantity * (transaction cost - standard cost excluding material overhead) Bridging (Receiving Organization) Quantity * transaction cost (excluding material overhead) Payables (Receiving Organization : Inter org account) Quantity * transaction cost Expense (Receiving Organization : Inter org account) Quantity * transaction cost |
60.00 78.00 45.00 15.00 33.00 78.00 |
45.00 15.00 11.00 7.00 60.00 15.00 78.00 78.00 |
Sending Organization : standard cost Receiving Organization : average cost | 5 units of item @ 12.00 Material (Sending Organization) Quantity * standard cost Material Overhead (Sending sub inventory) Quantity * standard cost Bridging (Sending Organization) Quantity * standard cost Transfer (Sending Organization : Inter org account) transfer cost Freight (Sending Organization : freight account) Freight cost Receivables (Sending Organization : Inter org account) (quantity * standard cost) + transfer cost + freight cost Revenue (Sending Organization : Inter org account) Quantity * standard cost Material (Receiving Organization) Quantity * transaction cost Material overhead (Receiving Organization) Quantity * material overhead cost Overhead Absorption (Receiving Organization) Quantity * material overhead cost Bridging (Receiving Organization) Quantity * transaction cost Payables (Receiving Organization : Inter org account) Quantity * transaction cost Expense (Receiving Organization : Inter org account) Quantity * transaction cost |
60.00 78.00 78.00 7.80 78.00 |
45.00 15.00 11.00 7.00 60.00 7.80 78.00 78.00 |
|
Direct Transfer between two Organizations | Sending Organization : average cost Receiving Organization : average cost | 1 unit of item 200.6 Material Quantity * current cost Material Overhead Quantity * current cost Transfer (Sending Organization : Inter org account) Transfer cost Freight (Sending Organization : Inter org account) Freight cost Receivables (Sending Organization : Inter org account) (quantity * current cost) + transfer cost + transportation cost Bridging (Sending Organization) Quantity * current cost Revenue (Sending Organization : Inter org account) Quantity * current cost |
1280.00 1100.00 |
1000.00 100.00 100.00 80.00 1100.00 |
Material (Receiving Organization) Quantity * transaction cost Material overhead (Receiving Organization) Quantity * material overhead cost Overhead Absorption (Receiving Organization) Quantity * material overhead cost Payables (Receiving Organization : Inter org account) Quantity * transaction cost Bridging (Receiving Organization) Quantity * transaction cost Expense (Receiving Organization : Inter org account) Quantity * transaction cost |
1280.00 128.00 1280.00 |
128.00 1280.00 1280.00 |
||
Sending Organization : average cost Receiving Organization : standard cost | 1 unit of item 200.6 Material (Sending Organization) Quantity * current cost Material Overhead Quantity * current cost Transfer (Sending Organization : Inter org account) Transfer cost Freight (Sending Organization : Inter org account) Freight cost Receivables (Sending Organization : Inter org account) (quantity * current cost) + transfer cost + transportation cost Bridging (Sending Organization) Quantity * current cost Revenue (Sending Organization : Inter org account) Quantity * current cost |
1280.00 1100.00 |
1000.00 100.00 100.00 80.00 1100.00 |
|
Material (Receiving Organization) Quantity * Standard cost Material Overhead (Receiving Organization) Quantity * material overhead standard cost Overhead Absorption (Receiving Organization) Quantity * material overhead standard cost Inter-org Price Variance (Receiving Organization) quantity * (transaction cost - standard cost excluding material overhead) Payables (Receiving Organization : Inter org account) Quantity * transaction cost Bridging (Receiving Organization) Quantity * transaction cost Expense (Receiving Organization : Inter org account) Quantity * transaction cost |
1200.00 120.00 80.00 1280.00 |
120.00 1280.00 1280.00 |
Transaction | Scenario | Expected Journal Entry | DR | CR |
---|---|---|---|---|
WIP Component Issue | 10 units of item 200.1 and 10 units of item 200.2 Material Quantity * standard cost Material Overhead Quantity * standard cost Bridging Quantity * standard cost WIP Material Quantity * standard cost WIP Material Overhead Quantity * standard cost WIP Bridging Quantity * standard cost |
320.00 240.00 80.00 |
240.00 80.00 320.00 |
|
WIP Negative Component Issue | 2 units of component @ 12.00 Material Quantity * standard cost Material Overhead Quantity * standard cost Bridging Quantity * standard cost WIP Material Quantity * standard cost WIP Material Overhead Quantity * standard cost difference WIP Bridging Quantity * standard cost |
18.00 6.00 24.00 |
24.00 18.00 6.00 |
|
WIP Component Return | 1 unit of item @ 12.00 Material Quantity * standard cost Material Overhead Quantity * standard cost Bridging Quantity * standard cost WIP Material Quantity * standard cost WIP Material Overhead Quantity * standard cost WIP Bridging Quantity * standard cost |
9.00 3.00 12.00 |
12.00 9..00 3.00 |
|
WIP Negative Component Return | 2 units of component @ 12.00 Material Quantity * standard cost Material Overhead Quantity * standard cost Bridging Quantity * standard cost WIP Material Quantity * standard cost WIP Material Overhead Quantity * standard cost WIP Bridging Quantity * standard cost |
24.00 18.00 6.00 |
18.00 6.00 24.00 |
|
WIP Scrap | 1 units of assembly 300.1 WIP Material (scrap job cost) WIP Material Overhead quantity * standard cost WIP Resource quantity * standard cost WIP Overhead quantity * standard cost User entered (depending on WIP setup options) (scrap job cost) |
144.10 |
24.00 8.00 71.00 11.10 |
|
WIP Assembly Completion | Without WIP Outside Processing | 9 units of item 300.1 Material Quantity * standard cost Material Overhead quantity * standard cost WIP Resource Quantity * standard cost WIP Overhead Quantity * standard cost Bridging Quantity * standard cost WIP Material Quantity * standard cost WIP Material Overhead Quantity * standard cost WIP Resource Quantity * standard cost WIP Overhead Quantity * standard cost WIP Bridging Quantity * standard cost |
216.00 72.00 639.00 99.99 1026.99 |
1026.99 216.00 72.00 639.00 99.99 |
With WIP Outside Processing | 10 units of item @ 55.00 Material Quantity * standard cost Material Overhead quantity * standard cost WIP Resource Quantity * standard cost WIP Overhead Quantity * standard cost WIP Outside Processing Qantity * standard cost Bridging Quantity * standard cost WIP Material Quantity * standard cost WIP Material Overhead Quantity * standard cost WIP Resource Quantity * standard cost WIP Overhead Quantity * standard cost WIP Outside Processing Quantity * standard cost WIP Bridging Quantity * standard cost |
500.00 50.00 1600.00 160.00 300.00 2610.00 |
2610.00 500.00 50.00 1600.00 160.00 300.00 |
|
WIP Assembly Return | 2 units of item 300.1 Material Quantity * standard cost Material Overhead Quantity * standard cost Resource Quantity * standard cost Overhead Quantity * standard cost Bridging Quantity * standard cost WIP Material Quantity * standard cost WIP Material Overhead Quantity * standard cost WIP Resource Quantity * standard cost WIP Overhead Quantity * standard cost WIP Bridging Quantity * standard cost |
228.20 18.00 16.00 142.00 22.20 |
48.00 16.00 142.00 22.20 228.20 |
|
WIP Move at receipt PO (for outside processing) | 10 units of item @ 25.00 Receipt account Quantity * PO price Outside Processing Quantity * standard cost Variance S/T (from resource) Quantity * (standard cost - PO price) Bridging Quantity * standard cost WIP Bridging Quantity * standard cost |
300.00 250.00 |
250.00 50.00 250.00 |
Transaction | Scenario | Expected Journal Entry | DR | CR |
---|---|---|---|---|
Intercompany Drop Ship Flow | Scenario: Internal drop shipment – Sending Org Standard Costing a) Sales Order Pick – Sending Organization |
Sending organization -10 Units @ organization frozen cost Material sending sub-inventory Quantity * sending organization cost Bridging sending sub-inventory Quantity * sending organization cost Material staging sub-inventory Quantity * sending organization cost Bridging staging sub-inventory Quantity * sending organization cost |
10.00 10.00 |
10.00 10.00 |
b) Logical Intercompany Sales Issue – Sending organization | Sending Organization Intercompany Cost of Goods Sold Quantity * Transfer Price Inventory Valuation Sending organization Quantity * Transfer Price |
20.00 |
20.00 |
|
c) Logical Intercompany Shipment Receipt | Selling Organization Inventory Valuation Selling organization Quantity * Transfer Price Bridging Selling Organization Quantity * Transfer Price Expense Quantity * Transfer Price Intercompany AP Accrual Quantity * Transfer Price |
20.00 20.00 |
20.00 20.00 |
|
d) Logical Sales Order Issue | Selling Organization Deferred Cost of Goods Sold Quantity * Transfer Price Inventory Valuation Quantity * Transfer Price |
20.00 |
20.00 |
|
Intercompany Drop Ship Flow | Scenario: Internal drop shipment – Sending Org Average Costing a) Sales Order Pick – Sending Organization |
Sending organization -10 Units @ organization current cost Material Sending Cost Group Quantity * sending organization cost Bridging Sending Cost Group Quantity * sending organization cost Material Sending Cost Group Quantity * sending organization cost Bridging sending Cost Group Quantity * sending organization cost |
11.00 11.00 |
11.00 11.00 |
b) Logical Intercompany Sales Issue – Sending organization | Sending Organization Intercompany Cost of Goods Sold Quantity * Transfer Price Inventory Valuation Sending organization Quantity * Transfer Price |
30.00 |
30.00 |
|
c) Logical Intercompany Shipment Receipt | Selling Organization Inventory Valuation Selling organization Quantity * Transfer Price Bridging Selling Organization Quantity * Transfer Price Expense Quantity * Transfer Price Intercompany AP Accrual Quantity * Transfer Price |
30.00 30.00 |
30.00 30.00 |
|
d) Logical Sales Order Issue | Selling Organization Deferred Cost of Goods Sold Quantity * Transfer Price Inventory Valuation Quantity * Transfer Price |
30.00 |
30.00 |
|
Intercompany Global Procurement | Receiving Organizaton – Standard Costing a) Receive |
Receiving Organization Inventory Valuation Quantity * Frozen Cost Intercompany AP Accrual Quantity * PO Price Purchase Price Variance Quantity * price difference Bridging Quantity * Frozen Cost Expense Quantity * Frozen Cost |
130.00 130.00 |
100.00 30.00 130.00 |
Buying Organization b) Logical Receive |
Buying Organization Clearing Quantity * PO Price Intercompany AP Accrual Quantity * PO Price |
100.00 |
100.00 |
|
c) Logical Delivery | Buying Organization Inventory Valuation Quantity * PO Price Clearing Quantity * PO Price Bridging Quantity * PO Price Expense Quantity * PO Price |
100.00 100.00 |
100.00 100.00 |
|
d) Logical intercompany sales order issue | Buying Organization Inventory Valuation Quantity * PO Price Intercompany COGS Quantity * PO Price |
100.00 |
100.00 |
|
Intercompany Global Procurement | Receiving Organization – Standard Costing a) Receive |
Receiving Organization Inventory Valuation Quantity * PO Price Intercompany AP Accrual Quantity * PO Price Bridging Quantity * PO Price Expense Quantity * PO Price |
100.00 130.00 |
100.00 130.00 |
Buying Organization b) Logical Receive |
Procuring Organization Clearing Quantity * PO Price Intercompany AP Accrual Quantity * PO Price |
100.00 |
100.00 |
|
c) Logical Delivery | Procuring Organization Inventory Valuation Quantity * PO Price Clearing Quantity * PO Price Bridging Quantity * PO Price Expense Quantity * PO Price |
100.00 100.00 |
100.00 100.00 |
|
d) Logical intercompany sales order issue | Procuring Organization Inventory Valuation Quantity * PO Price Intercompany COGS Quantity * PO Price |
100.00 |
100.00 |
|
Intercompany External Drop Shipment | a) Logical receipt | Procuring Organization Intercompany AP Accrual Quantity * PO Price Clearing Quantity * PO Price |
100.00 |
100.00 |
b) Logical deliver | Procuring Organization Inventory Valuation Quantity * PO Price Clearing Quantity * PO Price Bridging Quantity * PO Price Expense Quantity * PO Price |
100.00 100.00 |
100.00 100.00 |
|
c) Logical intercompany sales issue | Procuring Organization Intercompany COGS Quantity * PO Price Inventory Valuation Quantity * PO Price Bridging Quantity * PO Price Expense Quantity * PO Price |
100.00 100.00 |
100.00 100.00 |
|
d) Logical intercompany shipment receipt | Selling Organization Inventory Valuation Quantity * Transfer Price Intercompany AP Accrual Quantity * Transfer Price Bridging Quantity * Transfer Price Expense Quantity * Transfer Price |
130.00 130.00 |
130.00 130.00 |
|
e) Logical Sales Order Issue | Selling Organization Deferred Cost Of Goods Sold Quantity * Transfer Price Inventory Valuation Quantity * Transfer Price Bridging Quantity * Transfer Price Expense Quantity * Transfer Price |
130.00 130.00 |
130.00 130.00 |
The Inventory rules in the Global Accounting Engine use the feature Control Account Balances to give you a detailed balance per account and period at the organization level by subinventory or cost group. A similar feature exists in the Subledger Accounting Architecture but it is limited to the definition of the accounts as third party control accounts, and this definition is not natural with the accounts used in Inventory (third party control accounts are used in Payables and Receivables). To keep the same functionality, the SLA PI rules uses the Supporting References functionality as follows:
Supporting Reference Header | Supporting Reference Details |
---|---|
Inventory Value | Organization |
Subinventory | |
Cost Group |
The Supporting Reference Inventory Value will be assigned to all the journal lines that use a subinventory valuation account in the events for Inventory transactions.
As part of the upgrade from release 11i to release 12, if you are using the inventory rules in the Global Accounting Engine, then you must migrate the accounting data from AX to SLA. The upgrade program must migrate the following data into SLA:
Events and transaction entities: The existing events in the Global Accounting Engine are migrated into the Subledger Accounting data model based on the following relationship between event types (the SLA event types have been defined by the Costing team as part of the uptake of SLA):
AX Event Type | SLA Event Class | SLA Event Type |
---|---|---|
INV_EVENT_1 | PO Delivery into Inventory | Return to Receiving Inspection from Inventory |
INV_EVENT_10 | Logical Intercompany | Logical Intercompany Shipment Receipt |
INV_EVENT_11 | PO Delivery into Inventory | Logical PO Delivery Adjustment |
INV_EVENT_121 | Intransit Interorg Receipt for FOB Shipment | Intransit Interorg Receipt for FOB Shipment |
INV_EVENT_122 | Recipient-side Intransit Interorg Receipt for FOB Receipt | Recipient-side Intransit Interorg Receipt for FOB Receipt, no Transfer Pricing |
INV_EVENT_122FM | Sender-side Intransit Interorg Receipt for FOB Receipt | Sender-side Intransit Interorg Receipt for FOB Receipt, no Transfer Pricing |
INV_EVENT_122FMT | Sender-side Intransit Interorg Receipt for FOB Receipt | Sender-side Intransit Interorg Receipt for FOB Receipt, Transfer Pricing |
INV_EVENT_122SC | Recipient-side Intransit Interorg Receipt for FOB Receipt | Recipient-side Intransit Interorg Receipt for FOB Receipt, no Transfer Pricing |
INV_EVENT_122TO | Recipient-side Intransit Interorg Receipt for FOB Receipt | Recipient-side Intransit Interorg Receipt for FOB Receipt, no Transfer Pricing |
INV_EVENT_122TOTA | Recipient-side Intransit Interorg Receipt for FOB Receipt | Recipient-side Intransit Interorg Receipt for FOB Receipt, Transfer Pricing |
INV_EVENT_122TOTN | Recipient-side Intransit Interorg Receipt for FOB Receipt | Recipient-side Intransit Interorg Receipt for FOB Receipt, Transfer Pricing |
INV_EVENT_13 | Logical Intercompany | Logical Intercompany Receipt Return |
INV_EVENT_14 | Logical Intercompany | Logical Intercompany Sales Return |
INV_EVENT_17 | Internal Order to Expense | Internal Order Receipt into Expense, no Transfer Pricing |
Internal Order to Expense | Internal Order Receipt into Expense, Transfer Pricing | |
INV_EVENT_1M | Intraorg Transfer | Cost Group Transfer |
Miscellaneous | Account Alias Issue | |
Miscellaneous | Account Issue | |
Miscellaneous | Miscellaneous Issue | |
Miscellaneous | Move Order Issue | |
INV_EVENT_1SO | Sales Order Issue | RMA Return |
Sales Order Issue | Sales Order Issue | |
INV_EVENT_2 | Intraorg Transfer | Cycle Count Transfer |
Intraorg Transfer | Internal Order Transfer | |
Intraorg Transfer | Move Order Transfer | |
Intraorg Transfer | Physical Inventory Transfer | |
Intraorg Transfer | Subinventory Transfer | |
INV_EVENT_211 | Recipient-side Intransit Interorg Shipment for FOB Shipment | Recipient-side Intransit Interorg Shipment for FOB Shipment, no Transfer Pricing |
INV_EVENT_211FM | Sender-side Intransit Interorg Shipment for FOB Shipment | Sender-side Intransit Interorg Shipment for FOB Shipment, no Transfer Pricing |
INV_EVENT_211FMT | Sender-side Intransit Interorg Shipment for FOB Shipment | Sender-side Intransit Interorg Shipment for FOB Shipment, Transfer Pricing |
INV_EVENT_211SC | Recipient-side Intransit Interorg Shipment for FOB Shipment | Recipient-side Intransit Interorg Shipment for FOB Shipment, no Transfer Pricing |
INV_EVENT_211TO | Recipient-side Intransit Interorg Shipment for FOB Shipment | Recipient-side Intransit Interorg Shipment for FOB Shipment, no Transfer Pricing |
INV_EVENT_211TOTA | Recipient-side Intransit Interorg Shipment for FOB Shipment | Recipient-side Intransit Interorg Shipment for FOB Shipment, Transfer Pricing |
INV_EVENT_211TOTN | Recipient-side Intransit Interorg Shipment for FOB Shipment | Recipient-side Intransit Interorg Shipment for FOB Shipment, Transfer Pricing |
INV_EVENT_212 | Intransit Interorg Shipment for FOB Receipt | Intransit Interorg Shipment for FOB Receipt |
INV_EVENT_24A | Material Cost Update | Average Cost Update |
Material Cost Update | IPV Transfer to Inventory | |
Material Cost Update | Layer Cost Update | |
INV_EVENT_24S | Material Cost Update | Standard Cost Update |
INV_EVENT_26 | PO Delivery into Inventory | Logical PO Delivery into Inventory |
INV_EVENT_26RMA | Sales Order Issue | Logical RMA Receipt |
INV_EVENT_27 | PO Delivery into Inventory | PO Delivery into Inventory |
INV_EVENT_27M | Miscellaneous | Account Alias Receipt |
Miscellaneous | Account Receipt | |
Miscellaneous | Miscellaneous Receipt | |
Miscellaneous | Move Order Receipt | |
INV_EVENT_27SO | Sales Order Issue | RMA Receipt |
INV_EVENT_28 | Intraorg Transfer | Internal Order Staging Transfer |
Intraorg Transfer | Sales Order Staging Transfer | |
INV_EVENT_29 | PO Delivery into Inventory | PO Delivery Adjustment |
Miscellaneous | Internal Requisition Receipt Adjustment | |
Miscellaneous | Shipment Receipt Adjustment | |
INV_EVENT_34 | Internal Order to Expense | Internal Order Issue to Expense, no Transfer Pricing |
Internal Order to Expense | Internal Order Issue to Expense, Transfer Pricing | |
INV_EVENT_3R | Direct Interorg Receipt | Direct Interorg Receipt, No Transfer Price |
Direct Interorg Receipt | Direct Interorg Receipt, Transfer Price | |
INV_EVENT_3RSC | Direct Interorg Receipt | Direct Interorg Receipt, No Transfer Price |
INV_EVENT_3S | Direct Interorg Shipment | Direct Interorg Shipment, No Transfer Price |
Direct Interorg Shipment | Direct Interorg Shipment, No Transfer Price | |
INV_EVENT_4M | Miscellaneous | Cycle Count Adjustment |
INV_EVENT_55 | Intraorg Transfer | Cost Group Transfer |
INV_EVENT_6 | Consigned Inventory Ownership Transfer | Transfer from Regular to Consigned Inventory |
Consigned Inventory Ownership Transfer | Transfer from Consigned to Regular Inventory | |
INV_EVENT_7 | Sales Order Issue | Logical Sales Order Issue |
INV_EVENT_7RTV | PO Delivery into Inventory | Logical Return to Receiving Inspection from Inventory |
INV_EVENT_8M | Miscellaneous | Physical Inventory Adjustment |
INV_EVENT_9 | Logical Intercompany | Logical Intercompany Sales Issue |
INV_EVENT_1W | WIP Material | WIP Component Issue |
INV_EVENT_1WT | WIP Material | WIP Component Issue |
INV_EVENT_27W | WIP Material | WIP Component Return |
INV_EVENT_27WT | WIP Material | WIP Component Return |
INV_EVENT_30W | WIP Material | WIP Assembly Scrap |
WIP Material | WIP Estimated Scrap Reversal | |
INV_EVENT_31W | WIP Material | WIP Assembly Completion |
INV_EVENT_32W | WIP Material | WIP Assembly Return |
INV_EVENT_33W | WIP Material | WIP Negative Component Issue |
INV_EVENT_33WT | WIP Material | WIP Negative Component Issue |
INV_EVENT_34W | WIP Material | WIP Negative Component Return |
INV_EVENT_34WT | WIP Material | WIP Negative Component Return |
INV_EVENT_OPW | Outside Processing | Outside Processing |
Note: In some cases, the AX event type is not enough to identify the SLA event type and some additional check must be done to identify the resulting event type.
Journal entries: The journal entries created by the Global Accounting Engine are migrated into the Subledger Accounting data model based on a one-to-one relationship.
Balances: The existing balances in the Global Accounting Engine are migrated into the Subledger Accounting data model based on a one-to-one relationship.