Navision 4.0 non-sp1
we sell a lot of specific cost items on Sales orders, we always sale only one item per sales line,when it is a specific cost item, even though Navision would let you sell multiple items.
We would like to print on the posted sales invoice the serial number just below the part number. there is no direct link to the item tracking code from the sale invoice line table, the sales invoice line table has a link to the shipment line, witch has a link to the item tracking line table.
I can not figure a way to get the serial # into a variable on the sale invoice document so I can print it out.
any ideas ?
This seems like it should be standard functionality, would not everyone need the serial number of items sold to appear on sales documents ?
0
Comments
The InvoiceRowID in this case is
"113";"0";"103022";"";"0";"10000"
where
113 is table No.
103022 is invoice no.
10000 is invoice line no.
That is all you need to find value entry from which you then find the item ledger and once you've found the item ledger, you have your serial no.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I have a requirement where i need to sell an item of quantity 5 having different serial numbers and print all five serial nos along with the item no on the sales document/invoice.
so i have writen the following code to achieve this but its not working,
globals used are:
i->int
SerialNo ->an array of type text having dimension as 10 Actually i want to store all serial nos into the array SerialNo.
Can anybody tell me what wrong i am doing or can suggest me the appropriate solution.
You have to find the sales shipment document and then find the item ledger entry. THe other option is to find the value entries related to sales invoice
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Thanx for the reply, yes, i noticed this after my post when i saw the records of Item Ledger entry table.
Now, I dont want to print the array contents on the report like this: SerialNo[1],SerialNo[2]....and so on, instead i want to run a loop
is there any alternative to this
Salut!
Laura Nicolàs
Author of the book Implementing Dynamics NAV 2013
Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.
Thanx, problem is solved.