Temp Projects

Issue 2 - While calling vendor Shipment to RG screen.

1. I have completed vendor shipment by removing the error items.
2. From RG screen selected vendor shipment document
3. All items came to the cart but the line total showing is wrong.

Eg: EU22285, Divide rate =6, Unit Price $ = 6.72, Shipped Qty = 50CTNs

Actual Result line total = 50X6.72 = 336.00

Expect Result line total = 50X6X6.72 = 2016

Rijas P wrote:

Getting an error "3 lines with error in Receive GF220414 Souvenir.csv " while importing CSV to vendor shipment screen.

Actually these items have PO qty in same order, but we have changed the uom conversion for the items before doing vendor shipment [EU21707,EU21708,EU21714]. PFA error CSV for your reference.

Order completed with Uom Conversion "Carton" divide rate = 36

Vendor Shipment CSV Uom Conversion "Carton1" divide rate =72

@sahla please check the reported issues on priority

Rijas P wrote:

Getting an error "3 lines with error in Receive GF220414 Souvenir.csv " while importing CSV to vendor shipment screen.

Actually these items have PO qty in same order, but we have changed the uom conversion for the items before doing vendor shipment [EU21707,EU21708,EU21714]. PFA error CSV for your reference.

Order completed with Uom Conversion "Carton" divide rate = 36

Vendor Shipment CSV Uom Conversion "Carton1" divide rate =72

Dear Suhail,

Hope this issue has been fixed internally. Could you please update in our live server. Because we can't complete vendor shipment if the Uom given in CSV sheet is not match with PO Uom. All our vendor shipments are pending due to this error. Kindly request you to update this today itself.

Dear Noufal,

We have tested the fix of vendor shipment screen, please see our below comments

Issue 1 - Vendor Shipment CSV import can do only with PO Uom - Found fixed.

Issue 2 - Unit price issue while calling vendor shipment to RG screen - Unable to check this case, because in test server once calling vendor shipmen t document getting an error "/by Zero" PFA.

Sahla, Please check.

Noufal K wrote:

Sahla, Please check.

Issue due to QtyPriced having value on test db
Seems some issue with replication

Live Server

euro=# select description,c_uom_id,qtyordered,qtyentered,qtypriced,price_uom_id from c_orderline where c_orderline_id =2615041;
description | c_uom_id | qtyordered | qtyentered | qtypriced | price_uom_id
-------------------------------------------------+----------+------------+------------+-----------+--------------
BURJ KHALIFA METAL CRYSTAL BASE 3 COLOUR SIZE 1 | 1000000 | 6000 | 50.00 | 50 | 1000000
(1 row)

Test Server

euro_test=# select description,c_uom_id,qtyordered,qtyentered,qtypriced,price_uom_id from c_orderline where c_orderline_id =2615041;
description | c_uom_id | qtyordered | qtyentered | qtypriced | price_uom_id
-------------------------------------------------+----------+------------+------------+-----------+--------------
BURJ KHALIFA METAL CRYSTAL BASE 3 COLOUR SIZE 1 | 1000000 | 6000 | 50.00 | 0 |
(1 row)

Mohamed Suhail wrote:

Noufal K wrote:

Sahla, Please check.

Issue due to QtyPriced having value on test db
Seems some issue with replication

Live Server

euro=# select description,c_uom_id,qtyordered,qtyentered,qtypriced,price_uom_id from c_orderline where c_orderline_id =2615041;
description | c_uom_id | qtyordered | qtyentered | qtypriced | price_uom_id
-------------------------------------------------+----------+------------+------------+-----------+--------------
BURJ KHALIFA METAL CRYSTAL BASE 3 COLOUR SIZE 1 | 1000000 | 6000 | 50.00 | 50 | 1000000
(1 row)

Test Server

euro_test=# select description,c_uom_id,qtyordered,qtyentered,qtypriced,price_uom_id from c_orderline where c_orderline_id =2615041;
description | c_uom_id | qtyordered | qtyentered | qtypriced | price_uom_id
-------------------------------------------------+----------+------------+------------+-----------+--------------
BURJ KHALIFA METAL CRYSTAL BASE 3 COLOUR SIZE 1 | 1000000 | 6000 | 50.00 | 0 |
(1 row)

Updated qtypriced for all order lines in the reported shipment
Please check now Rijas P

Dear Suhail,

Now it's working and loaded items to RG screen by vendor shipment doc. But the line total is showing wrong for the item EU21699. [Total Pcs*CTN price instead of Total Pcs*Unit price]. PFA

Case closed