search

meridianww / M4PLBase

0 stars 1 forks source link

Electrolux Order With POD But Status Is Delivered #375

Open nmfujimoto opened 3 years ago

nmfujimoto commented 3 years ago

Please research Electrolux order 7804003718 (Job Id 223836) as the order contains a POD record and POD Completion gateway but the Gateway Status is still showing Delivered.

Was a NAV SO/PO created?

nmfujimoto commented 3 years ago

image

KamalAdhikary commented 3 years ago

@nmfujimoto please check below attach image details 1) Which we have investigated with production database of order number :7804003718, shows us as per latest gateway "Delivered" on the date of latest GatewayACD value. So it is showing in job form as per latest updated value. 2) Also we have check in job table JobCustomerPurchaseOrder, JobCustomerSalesOrder fields is updated as followed to our table NAV000JobSalesOrderMapping and NAV000JobPurchaseOrderMapping with job id 223836.

Please let us know anything we have missed.

223836-1 223836-2

nmfujimoto commented 3 years ago

@KamalAdhikary Thank you for confirming that the NAV Sales and Purchase orders were created for the order (7804003718).

nmfujimoto commented 3 years ago

@KamalAdhikary Please correct the order to display the proper Gateway Status, which is POD Completion.

nmfujimoto commented 3 years ago

@nmfujimoto Please check query Kamal provided to update the duplicate gateways.

nmfujimoto commented 3 years ago

@KamalAdhikary The query to update duplicate gateways looks correct. Please run the query.

Madhusmi commented 3 years ago

@nmfujimoto Testing Completed and it is working as expected.