|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Creating invoiceline without invoice header? |
| Author |
Message |
|
|
| Posted : 2008-11-01 03:54:09 |
I'm a bit confused about creating an invoice with multiple invoice lines. Ive read that without a customer reference one will need to add an invoice header. Now I'm guessing with the customer reference i wont need an invoice header. Can any one clarify this for me? I ran these queries and i can't find the actual invoice data i inserted. From looking at other queries i noticed a 'refnumber' field but I'm confused as to where i get this value from. Is this a lookup value from another table?
thank you
INSERT INTO INVOICELINE (CustomerRefListID, CustomerRefFullName, InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineAmount, InvoiceLineSalesTaxCodeRefFullName, FQSaveToCache ) Values ('80000A2F-1225378795','12046 - AlexCo TEST','**********' , '**********' , 1.00 , 25.00, 'NON' , 1 )
INSERT INTO INVOICELINE (CustomerRefListID, CustomerRefFullName, InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineAmount, InvoiceLineSalesTaxCodeRefFullName, FQSaveToCache ) Values ('80000A2F-1225378795','12046 - AlexCo TEST','*********' , ''**********' , 25.00 , 2,875.00, 'NON' , 1 )
INSERT INTO INVOICELINE (CustomerRefListID, CustomerRefFullName, InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineAmount, InvoiceLineSalesTaxCodeRefFullName, FQSaveToCache ) Values ('80000A2F-1225378795','12046 - AlexCo TEST','*********' , '**********' , 1.00 , 90.00, 'NON' , 0 )
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-11-03 09:21:44 |
|
|
|
|