Temp Projects

Please see the CSV sheet for reference.

EU19696&EU20041 gave 2 times in the sheet.

Rijas P wrote:

Imported SCV sheet to RG screen. Same item gave 2 times in CSV Sheet

1st line 20041 4 Ctns
2nd line 20041 81 Each

The unit price of the item is 1.05, Divide rate 96 and CTN Price should be 1.05X96 = 100.80 but in RG screen the CTN price showing 105.60

PS: there are some other items also given 2 times in the CSV sheet but there is no issue in Carton price.

This is what I have found
PO "EU-79-20211111" is created on 2021-11-24 18:41:17 and during that time Each price in the system for the item is 1.1
Due to that carton price in PO is set to 105.60 (=1.1*96)for 15 CTNs
When we perform RG against a PO and the uom is not changed, it will take the price from PO which is correct,i.e 105.60
Each price of the item was changed to 1.05 on 2021-12-23 12:02:50
Now when you add a new line for the same item in a uom other than the ordered one,i.e Each, the system took the latest price of the item 1.05 for the entered uom
Since the carton price is different from the multiplied amount of the base uom price the system created a new price for CTN to the system

Rijas P wrote:

Imported SCV sheet to RG screen. Same item gave 2 times in CSV Sheet

1st line 20041 4 Ctns
2nd line 20041 81 Each

The unit price of the item is 1.05, Divide rate 96 and CTN Price should be 1.05X96 = 100.80 but in RG screen the CTN price showing 105.60

PS: there are some other items also gave 2 times in CSV sheet but there is no issue in Carton price.