How to keep, in LCM, the charge proration done in the Match Other Charges to Receipt form, in AP (Doc ID 2025109.1)

Last updated on SEPTEMBER 01, 2021

Applies to:

Goal

Keep, in LCM, the charge proration done in the Match Other Charges to Receipt form, in AP.

Steps
 

LCM Shipment 123
Shipment Line 1 (Receipt Line 1): Item X, Qty 10, Unit Price $7, Total Amount $70
Shipment Line 2 (Receipt Line 2): Item Y, Qty 10, Unit Price $3, Total Amount $30

Freight Cost Factor has Allocation Basis by "Value"

Example 1:
a. In the Match Other Charges to Receipt AP form, a $10 freight amount is automatically prorated (by quantity) into 2 receipt lines of Qty 10 each.
b. Each Line gets $5
c. Then the Invoice is sent to LCM
d. As per standard behavior, the $10 freight amount is reporated into the shipment lines, by their value, like this:
Shipment Line 1: $7
Shipment Line 2: $3
e. With the customization, LCM would keep the proration done in AP, like this:
Shipment Line 1: $5
Shipment Line 2: $5

Example 2:
a. In the Match Other Charges to Receipt AP form, a $10 freight amount is manually prorated into 2 receipt lines
b. Receipt Line 1 gets $2 and Receipt Line 2 gets $8
c. Then the Invoice is sent to LCM
d. As per standard behavior, the $10 freight amount is reporated into the shipment lines, by their value, like this:
Shipment Line 1: $7
Shipment Line 2: $3
e. With the customization, LCM would keep the proration done in AP, like this:
Shipment Line 1: $2
Shipment Line 2: $8

Solution

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