{"id":18345,"date":"2018-03-20T10:07:12","date_gmt":"2018-03-20T10:07:12","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=18345"},"modified":"2024-03-27T04:26:21","modified_gmt":"2024-03-27T04:26:21","slug":"generic-macro-of-sales-order-import","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/03\/20\/generic-macro-of-sales-order-import\/","title":{"rendered":"Generic Macro of Sales Order Import"},"content":{"rendered":"

ERP (Enterprise Resource Planning) is built for accounting and business. With the help of ERP, we can develop Report\/customization as per client requirement.<\/p>\n

In this blog, we will discuss about Sales Order Import Macro – How to Import a record of Sales Order using Sales Order Macro.<\/p>\n

New Stuff:\u00a0<\/em><\/strong>Display Finish Good Item on manufacturing issuance Screen<\/a><\/p>\n

Refer Below screen:<\/strong>
\n\"\"<\/a>
\nOnce selecting the appropriate excel sheet and after clicking on Import File button, the process starts by validating the data fields of Order number, Order Date, Customer No, Location etc. If the data is valid, then only macro process these rows else it will write error log for invalid data rows & proceed further.<\/p>\n

NOTE: – This will be a manual process. The user has to select browse file & import it.<\/strong><\/p>\n

The Import format is as follows:-\"\"<\/a>
\nAfter completing the entire process of Sales Order Entry Import Routine, you can check Sales Order is created automatically in Sage 300.<\/em><\/a>\"\"<\/a><\/p>\n

Field Mapping:<\/strong><\/p>\n