My Oracle Support Banner

Freight Charge On Cost Accounting Page does not Match With Voucher Freight Charge (Doc ID 2995753.1)

Last updated on JANUARY 05, 2024

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When a voucher is created for a PO, freight charge is added to the voucher header and Extract landed cost (LC_EXTRACT) is run. When Cost Accounting(CM_CSTACCTG) the freight amount generated in the CM_ACCTG_LINE
table does not match with the amount entered on the voucher. This issue occurs when items used have very large quantities but a very small unit cost.

Steps:
1. Setup Item. Update the Item Cost on the Purchasing Item Attributes and setup an item supplier.
       Items > Define Items and Attributes > Define Item
2. Create Business Unit Item. Assign Item to Zones on the Inventory tab.
      Items > Define Items and Attributes > Define Business Unit Item
3. Define Default Putaway Location for the Item.
      Inventory > Maintain Storage Location > Default Putaway Location
4. Define Fixed Picking Location for the Item.
      Inventory > Maintain Storage Location > Fixed Picking Location
5. Create requisition for the above item and ensure Inventory BU is updated in distribution.
       Purchasing > Requisitions > Add/Update Requisition
6. Source the requisition to PO with receiving and Matching required.
       Purchasing > Purchase Order > Add/Update POs
7. Create a PO receipt and putaway the items.
       Purchasing > Receipts > Add/Update Receipts
8.  Check the Freight Miscellaneous Charge has Landed Cost Component selected.
       Set Up Financials/Supply Chain > Product Related > Procurement Options > Charges/Costs > Misc and Landed Cost Defn
9. Create a Voucher, Match and post it.
       Accounts Payable > Vouchers  > Add/Update > Regular Entry
10. Run the Landed Cost Extraction Process.
       Accounts Payable > Batch Processes > Extracts and Loads > Extract Landed Cost
11. Run the Cost Accounting process.
       Cost Accounting> Inventory and Mfg Accounting > Create Accounting Entries > Cost Accounting Creation
12. Open the  Edit Unposted Accounting Lines and search for Transaction group 401 lines to see that freight charge generated here is different than the amount entered on Voucher page
       Cost Accounting > Inventory and Mfg Accounting > Create Accounting Entries > Edit Unposted Accounting Lines.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.