E1: 43: Voucher Match Wrongly Updates the Lot Cost when Landed Costs are being Used

Last updated on APRIL 30, 2018

Applies to:

Symptoms

When running P4314 and voucher matching a receipt, with the Processing option set to Update Lot Cost, the P4105 Lot cost (06) is wrongly updated.

SETUP:
P41291 - Landed cost rule GM - 2 landed cost records for a EUR supplier with Include in Cost and Voucher options set to Y.
Supplier: 4327 USD/EUR currencies
Item: GMLOT -
Inventory Cost level = 3,
Purchasing cost level = 3,
Lot controlled (Lot date)
Branch: 70 (company 00070 - EUR)
P4105 - No cost setup yet. 06 cost method is used for Inventory/Sales and Purchasing methods.

TEST:
1. Enter purchase order - P4310 (Landed cost rule defined in processing options)
50 EA of GMLOT at a cost of 80 USD/EA. Total foreign amount = 4000 USD.
- Exchange rate: 1 USD = .8 EUR
- Domestic amounts: Unit cost = 64 EUR, Extended = 3200 EUR.

2. P4312 - Receive the order. Do not apply the landed costs now.
Check cardex, P4111, notice one line is added for the receipt of 50 EA at 64 EUR.
P4105 - 06 cost = 64 EUR

3.P43214 - Apply standalone Landed cost. Select the order and apply LC. 100 EUR each.
Check P4111 - 2 extra lines added 100 EUR, with a unit cost of 2 EUR.
P4105 - 06 cost = 68 EGP

This is OK so far.

4. P4314 - voucher match for the receipt alone, supplier 4327. (processing options is set to Update Lot Cost)
P4105 - 06 cost gets updated to 64 EUR. This is not correct as the cost did not change and F4111 is out of balance.
P4314 - voucher match for one of the LC rules lines of 100.
P4105 - 06 Cost = 2 EUR. Again, there will be mismatch between F41021 and F4111.
Note: In 9.0 the cost remains unchanged.

Changes

Cause