Skip to Content
0
Nov 05, 2019 at 06:04 AM

Unable to upload Sales Order Via Excel Template

314 Views Last edit Nov 05, 2019 at 10:01 AM 2 rev

Hi Team,

Requirement - To add a Product Specification Field in Sales Order Excel Template. Steps - Used KBA to Add Product Specification: 1972763 - How to Add the Sales Unit Field in the Excel Upload Template 1. Go to Sales Order Woc --> select Sales Order view --> Click on the New button and select the Sales Order from Microsoft Excel® option. 2. Open the excel file NewSalesOrder --> Select any field such as the Account ID --> Right-click on the field and select XML > XML Source --> Locate and select the node ProductRequirementSpecificationKey --> RequirementSpecificationId --> Select the <value> field --> Save 3. Again, Go to Sales Order Woc --> select Sales Order view --> Click on the New button and select the Sales Order from Microsoft Excel® option --> pop up will open to select the template from List --> select New Sales Order - PRS. 4. enter the details 5. Logon SAP Byd. 6. Click on Save Data To button. 7. An error occurred: The Value of the field Product Specification is INVALID.

I had a discussion on this with Roshni via expert chat already.

Please find the attached PDF in which I explained everything clearly with screenshots.

Regards,

Esther