Importing of Sales Order Excel to NAV Issue

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I am trying to import the sales orders from excel to NAV using Rapid Start Service --> Conf. package. I have done the number series for my sales order doc number. When I export the package, one of the mandatory field is the document no. Whenever I try to export it is displaying error due to the doc. number, that the doc no. cannot be found. Is there a way to implement new sales orders into nav through excel? Thank you for your kind attention

Regards,

Ganesh

*This post is locked for comments

All responses (27)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Importing of Sales Order Excel to NAV Issue

hi,

I have already expanded the general tab to show more field, ive scrolled to 'left' to show the rest of my fields at line tab.

I've attach two pictures. Thank you, looking forward for a reply.
Suggested answer

Maneesha 5,889 on at

Like (0)

Report

RE: Importing of Sales Order Excel to NAV Issue

Expand your General Tab ...

"Show more field "
Community Member Microsoft Employee on at

Like (0)

Report

RE: Importing of Sales Order Excel to NAV Issue

Hi,

This is my sales order screenshot. *My order no. was manually inputed.

Thank you.

Regards,

Ganesh
Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Importing of Sales Order Excel to NAV Issue

You need to insert first Sales Header and then import Sales Line
Suggested answer

Maneesha 5,889 on at

Like (0)

Report

RE: Importing of Sales Order Excel to NAV Issue

ganesh baskaran ,

I just ask your Sales order Screen shot

Like this .....

I just need to view your General sales order

CAN YOU SHOW ME YOUR SO,,,,
Community Member Microsoft Employee on at

Like (0)

Report

RE: Importing of Sales Order Excel to NAV Issue

Hi,

I have removed the no. series for Sales order and I enter the Doc no.

But I am getting this error,

Please advise, as I am trying to do this method, and not XML port. Sorry hope you will help. Thank you for your kind attention.

Regards,

Ganesh
Community Member Microsoft Employee on at

Like (0)

Report

RE: Importing of Sales Order Excel to NAV Issue

.
Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Importing of Sales Order Excel to NAV Issue

You need to define document no as it is part of primary key and it has relation with Sale header.

I would suggest go for XMLPORT for importing Sales order.
Suggested answer

Rajasekhar@MS 5,567 on at

Like (0)

Report

RE: Importing of Sales Order Excel to NAV Issue

Hi Ganesh

If you want to import Sales Header and Sales lines using Rapid Start , you need to specify Document No. in your excel, if you don't want to use document no. in excel and wants to pickup form the number series create xmlport or write program to import data form excel
Community Member Microsoft Employee on at

Like (0)

Report

RE: Importing of Sales Order Excel to NAV Issue

Hi,

Do you want me take the screen shot of my full excel sheet? If it is, those are the records I have and created to import. If not do want the screenshot of my conf pack or other screenshot? Thank You.

Regards,

Ganesh