HI
I have a doubt on Nav 2016
I would like to get an excel data from nav with below details in it.
SO NO | SO LINE NO | Parent Item | Parent Item Description | Assembly Order NO | Assembly Order Line Item No | Description | Colour | Finish | Qty Per | Total |
The problem i am facing is, when i Download SO details, I get parent item no but can't find Assembly order no associated to each item.
for getting the Ass. Order no, i have to click on each item separately and open the Assembly order no and copy the Assembly order lines. But if i save this to excel,
this is not carrying Parent item NO nore SO no
My issue is i am not able to find any common detail to make a compiled report as above. and if i have to do it manually that takes fortunes.
any one can help me with a suggestion to get a report as above or anyway i can do a compilation of various report to get the above one.
Thanks In advance.
Sumesh