Create a report for Sales Order-Excel functionality

Business Central/NAV Technical Forum
1

Hi All,

I want to create a report for Sales orders where in two scebarios would be counted

1For few 0 quantity items List all so where few items will be 0

2.For order with all 0 quantity items.-List all items where all items will be 0.

This has to be exported to excel.But qty with item not 0 should be placed in one column separted by column & for all qty placed in one column separated with column.Also other details like

SO no,Cutsomer no,customer name.

I created a report on Sales header & Sales line & when i call the fucntion to populate in excel it on after get records the customer no so no gets repeated for each line & also the items are not consolidated & comes in the same seq as entered in SO(Say in so i have 1 item-10 qty,2 item-0 ty,3rd item-5 qty).No in report i need item with o column-2 item,item with valid qty -1 item-10 & 3rd item-5).HOw do i create a report.It should be on Sales hedaer & line or integer & use of mark function.

Kindly help.

2

Which version of Navision you are using ?

3

Navision 2009 r2

4

Do you mean to say that your report excel output should be different from report preview ?

As well as do you want to display zero qty item in separate column in excel

How your report is structured to handle this condition ?