Creating Sales Order on Importing Excel

(1) Share

Report

Posted on by Lester DSouza

Hi,

I am working on a customization in NAV were I can create a sales order on importing an excel document. I have created a codeunit were I am able to upload my excel document but I am not able to create a sales order record from the values present in it. Can anyone suggest a solution on how can I create a sales order record which will contain the field values present on my excel sheet?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Community Member on at

Like (3)

Report

You can use XML port to import an excel file and generate sales order from it.

Check this link for your reference :

msdn.microsoft.com/.../hh165760(v=nav.90).aspx

Was this reply helpful? Yes No
Lester DSouza on at

Like (0)

Report

Thank you, your suggestion has solved my problem.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

It was for ADP payroll only. The client need to pay extra to ADP for the correct file layout. I do not know if it still exists. My guess is that it does not. Trying to contact ADP was a joke because no one there knew anything about it.

Was this reply helpful? Yes No