search

meridianww / M4PLBase

0 stars 1 forks source link

NAV SO Not Created - Downstream Logistics #452

Closed nmfujimoto closed 3 years ago

nmfujimoto commented 3 years ago

All AWC orders that are assigned to the vendor Downstream Logistics - Atlanta location encounter an error when trying to create the SO in NAV.

The Vendor Location Code is: DOWATLGA The NAV Ship-To Code is: DOWATLGA

Both systems show the ERP ID as: V-80019

nmfujimoto commented 3 years ago

Example of 2 errors for the NAV SO creation: Error is occuring while Generating the Sales order: Request Url is: https://nav.meridianww.com:7048/Test/ODataV4/Company('AWC Test')/SalesOrder, Request body json was { "Sell_to_Customer_No": "C-30002", "Order_Date": "2021-02-04", "Received_Date": "2021-02-12", "Delivery_Date": "2021-02-18", "External_Document_No": "07765800001010200", "Cust_Reference_No": "JP 35335830", "M4PL_Job_ID": "291794", "Ship_from_Code": "DOWATLGA", "Ship_to_Code": null, "Ship_to_Name": "LOWES #2968", "Ship_to_Address": "1665 S HIGHWAY 27", "Ship_to_Address_2": null, "Ship_to_City": "CARROLLTON", "Ship_to_County": "GA", "Ship_to_Post_Code": "30117", "Ship_to_Contact": "LOWES #2968", "Ship_to_Phone": "6784234900", "Ship_to_Mobile": "6784234900", "Ship_to_Email": null, "Shortcut_Dimension_1_Code": "44", "Shortcut_Dimension_2_Code": "DOWATLGA", "Shipment_Date": "2021-02-11", "Parent_ID": null, "Mileage": 0.0, "Storage": 6.0, "Electronic_Invoice": true, "Posting_Date": "2021-02-18" }

Error is occuring while Generating the Sales order: Request Url is: https://nav.meridianww.com:7048/Test/ODataV4/Company('AWC Test')/SalesOrder, Request body json was { "Sell_to_Customer_No": "C-30002", "Order_Date": "2021-02-09", "Received_Date": "2021-02-10", "Delivery_Date": "2021-02-18", "External_Document_No": "07764741001011500", "Cust_Reference_No": "JP 34522585", "M4PL_Job_ID": "294884", "Ship_from_Code": "DOWATLGA", "Ship_to_Code": null, "Ship_to_Name": "PAYNE, ANGELA", "Ship_to_Address": "145 MARLBORO WAY", "Ship_to_Address_2": null, "Ship_to_City": "LAGRANGE", "Ship_to_County": "GA", "Ship_to_Post_Code": "30240", "Ship_to_Contact": "PAYNE, ANGELA", "Ship_to_Phone": "7063338142", "Ship_to_Mobile": "4042908063", "Ship_to_Email": null, "Shortcut_Dimension_1_Code": "44", "Shortcut_Dimension_2_Code": "DOWATLGA", "Shipment_Date": "2021-02-09", "Parent_ID": null, "Mileage": 0.0, "Storage": 8.0, "Electronic_Invoice": true, "Posting_Date": "2021-02-18" }

nmfujimoto commented 3 years ago

@prashantjustp Please run the script below and create the NAV Sales Orders and Purchase Orders for the jobs.

SELECT TOP 1000 * FROM SYSTM000ErrorLog WHERE ErrRelatedTo LIKE 'Sales order creation%' AND ErrDateStamp > '2/16/2021' ORDER BY Id desc

nmfujimoto commented 3 years ago

Issue was correct on NAV side by using the code "DOWNORGA" for the dimension and Ship-To address.