a first hint I got here, however I'm unable to add a field with the right parameters:
loops Post subject: Re: Adding
"Customer Reference" to Invoice - 5â¬
REWARD PostPosted: Thu Dec 08, 2011
9:52 pm Offline
Joined: Wed May 27, 2009 1:16 am
Posts: 28 Hi
I know this problem. We had it as well
and it is now solved. It is a bit more
tricky than playing around with the
text field "origin" imho.
Our solution is for invoice from
packings because this is what we do.
We do not do invoice from SO. But it
can be generalazied (see below).
This is what we did (and implemented
by synkronized.be): Introduce a
one2many field to packings on invoice.
When invoice is generated, one packing
or many packings (in case of grouped
by partner is ticked) are entered in
this field. In the report you can now
cycle through the packings, from there
get to the SO and from there get to
the SO fields.
Here's the header info from one of my
invoices:
Rechnungsdatum: 04.11.2011
Auftragsbestätigungen: SO874, SO891
Lieferungen: PACK4307 (22.09.2011),
PACK4469 (13.10.2011)
Zahlungskonditionen: 30 Tage netto
ohne Abzug Ihre Aufträge: EB041860,
EB042406 Auftragsdatum: 05.08.2011,
05.09.2011 Ihre Kontakte: Juan Garcia, Juan Garcia
Note the multiple customer references
in "Ihre Aufträge". Nice, isn't it?
I'm surprised that not more users have
this problem. Many of our customers
reject invoices that do not have thier
order references on them.
If you want to do something similar
when generating invoices from SO then
add a one2many field to SO on invoice
and fill it during generation of the
invoice.
To generalize, here's what I think we
should aggree on in the openerp
community: RULE: When an object has
the need to give an "origin" (such as
in MO, PO, Pack, invoice, ...) it is a
bad idea to do that just with a text
field. I know that the object type of
the origin can be different, but the
number of different object types is
not infinite, typically it is 2 to 3.
So just add a one2many field for each
object type ("origin SO", "origin
pack"). You can still have a text
field "Origin" that summarized it if
it makes you happy.
Hope it helps
Cheerio, loops