Setting up credit notes

[Guest]

Hi,

I'm making a sales and invoicing system, but I'm struggling with the credit
notes.

So far, I have set up the sales orders and sales order lines in two separate
tables.

Same with the credit notes, and credit note lines.

The credit note is based on a sales order, but doesn't necessarily contain
all the same lines as there were in the sales order. Therefore, I need to
pull through a copy of the sales order lines into the credit note lines, and
then edit from there.

How do I pull a copy of the sales lines for a particular sales order through
into the relevant credit note lines table associated with the original sales
order?

Thanks,

Franc.

 

[UpRider]

Franc, An idea. It would *greatly* simplify things if you could keep the
sales orders and credit notes in the same table. Add a field to identify
which it is.
HTH, UpRider

 

[Guest]

Hi there,

I thought of that one, but the sales orders and credit notes have a
different sequence of id numbers, so had to put them in different tables. At
least, if I have understood you correctly?

Franc.