Something to show # of boxes?

yuppicide · 2009-09-17

Navision 3.10.. Do you think this is possible or too much for me to attempt?

When mailing out invoices and packing lists to customers we have to manually draw a line to indicate what is in box 1, what is in box 2, and then the total number of boxes on the last page.

Would it be possible to have a report that asks me for the posted invoice #, number of boxes, and where box 1 ends, where box 2 ends, etc.?

In the example picture I've attached here (I blurred our our Customer's Info) it would need to add the line under 1450-9509 and under 5462-9806, then it would need to write box #'s. On the last page it would write Total Boxes = #.

During our busy season I would say I might have to manually draw this do this 30 to 50 times a week.. on both packing list and invoice.

David_Singleton · 2009-09-17

Yes its pretty simple, though I would do it like this:

-- BOX 1

Item a
item b
Item C
-- BOX 2

Item r
item s
Item t
-- BOX 3

Item X
item Y
Item Z

Just add a tick box on the sales line that says you are starting a new Box, then insert a new section in the report (Sales Ship Line) before the existing line and use a currreport.showoutput("New Box"); to print the box indicator.

Should take about an hours work.

Savatage · 2009-09-17

just to add..

I know you don't use e-ship - but it does this when using the fast pack option.
It creates packages and lists the items in each package.

Something to show # of boxes?

Comments

Categories