openerp-community team mailing list archive

["Alan Lord (Gmail)" <alanslists@xxxxxxxxx>]

Just wondering if anyone else has come up against this as a reporting 
issue before...

Our customer creates long quotes (perhaps a hundred or more line items 
with lots of quantity). (Sale orders need to be set to Invoice from the 
Picking).

Customer approves and they confirm the order.

They then start to deliver the goods over an extended period of time 
(several months).

Things change... So they update the delivery order to reflect what has 
changed. (Might be new items, or more or less of an existing line item).

They want to know the value of everything to Invoice right now.

The Lines to Invoice report could be really useful, but it, of course, 
is linked to the sale.order, not the subsequently modified stock.picking 
records.

We are thinking about extending the Deliveries to Invoice report to show 
the value as well. But of course with new stock.picking line records any 
discounts (or markups) applied on the original sale.order are not going 
to be easily available.

I'm wondering if we are going about this in the wrong way from the 
start... Perhaps we need some kind of intermediate state on a sale.order 
so we can update it once the order has been confirmed and it propagates 
any changes *forward* to open stock.picking records?

Any thoughts/ideas anyone?

Cheers

Al