We raise a sales order that has more than one line of the same item [these items are usually spare parts]. Each line of the same item has a different delivery address which corresponds to a machine to which the parts are fitted. All lines are shipped at the same time. The purpose of this is so that we can tell our customer by periodic report how much they have spent on each of their machines.

However, on the sales invoice we only want to show one line per item, with the total quantity of the item shown. How do we achieve this by modifying the report layout or setup in some way?

Normally the same item lines with have consecutive positions on the sales order - but there is a chance the order entry may not always achieve this.

Thanks for any help!

There are two ways to do this, either using GROUP BY clause in script level as follows, or also possible to do same by changing some settings in Report Layout level as well.

extern domain tcqsl1 del.qty

{
select tdsls041.item, sum(tdsls041.dqty):del.qty
from tdsls041
where <condition>
group by tdsls041.item

selectdo
rprt_send()
endselect
}


regards
Srilal

Dear Ed,

You might want to change the sort sequence for the sales invoice to:
inco, Ascending, 1
tdsls045.orno, Ascending, 2
tdsls041.item, Ascending, 3
tdsls045.dino, Ascending, 4
tdsls045.pono, Ascending, 5
In addition, you need to make quite a few adjustments to the sales invoice layouts

By doing it this way, you'd only change the appearance of the sales invoice without changing the standard sales invoicing business process in BaanIV

Rgds,
Paul

Hi,
You don't mean to have a new invoice number for each line. If this is the reqmt then you have to change the program script or do in some othe fashion. We are doing sales invoice by picking list.

Arvind

Thanks for your suggestions - I will get and try them soon.

p.s. Arvind, the requirement is to have one invoice line per item.

example, if on the order it says:

POS ITEM QTY

10 ABC 1.0
20 ABC 3.0

And they are all delivered at the same time.

I want 1 invoice line to say "4.0 ABC £XX.XX"