Last updated on AUGUST 14, 2015
Applies to:Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.
In 12.1.3, Incorrect calculation of Accrual amount for split order lines in Trade management
We see the Accrual amount(Adjusted amount) calculated wrongly in OZF_FUNDS_UTILIZED_ALL_B for partial shipments. The Accrual amount gets calculated at the time of booking the line (For the whole quantity)and in addition to the the accrual amount again gets calculated when the line gets split while shipping.
Accruals are posted to GL only while Invoicing as per our profile option setups but the accrual amount gets calculated multiple times whenever the order line get split and a new child line is created.
For Instance if the order quantity is 1000 ($1/each) and the discount rate is 10%. We do shipments partially (500+500).
The Accrual amount will be calculated as 100 first time and after the 1st shipment we again have a accrual amount for 50 which in total 150 but actually for $1000 the accrual amount should be $100.
We give Off-Invoice discount and we have this issue only for partial B2B shipments.
We need to find a solution to get the accrual amount calculation done only once for the total quantity and not for the partial quantity every time when it splits.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms