How to get NAV No Series and increment No Series...

farrel

Hi All,

I have to insert records from other system to Navision Sales header. My problem is how to get and increment the no series of NAV.

thanks in advance.

kriki

[Topic moved from Navision Tips & Tricks forum to Navision forum]

Program it simulating that a user would do it on a form:

CLEAR(recSalesHeader);
recSalesHeader."Document Type" := recSalesHeader."Document Type"::Order; // needed because the noseries must take a number from the correct series and from quotes for example
recSalesHeader.INSERT(TRUE); // this creates a new "No."
recSalesHeader.VALIDATE("Sell-to Customer No.",codSomeCode);
......
recSalesHeader.MODIFY(TRUE);

ara3n

Also you cannot run Business Logic from outside of Navision (SQL),
I would suggest to create a staging table and populate it.
Then from Navision have NAS monitor the table and create the orders.

farrel

ara3n wrote:

Also you cannot run Business Logic from outside of Navision (SQL),
I would suggest to create a staging table and populate it.
Then from Navision have NAS monitor the table and create the orders.

Hi,

Where can i read about NAS? Can I ask for any link?

Thanks,

ara3n

It's on installation cd in the doc folder.
There is also a sell hello with Navision on MSDN. There are a lot of threads in here on NAS as well.