|
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
|
|
| Changing an Invoice Date |
| Author |
Message |
| Ian |
| |
| Group | : Members |
| Posts | : 8 |
| Joined | : 2007-02-08 |
|
| Profile |
|
| Posted : 2007-10-20 12:14:11 |
| Is there a way to alter the date of an invoice. Currently our invoices are entered when we charge a customer, however, we'd like to alter the date to the shipping date (which may or may not be the same day) without actually waiting to enter the invoice. Is this doable? From what I could tell in the FAQ on how to create a new invoice line, there was not a line for the Date. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-10-22 08:27:02 |
QuickBooks will use the default date if no date is specified in transaction inserts, but you can include a transaction date like this :-
INSERT INTO "InvoiceLine" ("CustomerRefListID", "TxnDate", "RefNumber",
"InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate",
"InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID", "FQSaveToCache")
VALUES ('AC0000-1197757899', {d '2007-10-22'}, 'Q001', '250000-933272656',
'Bin Permit Renovations', 200.00000, 200.00, '20000-999022286', 0)
See: How do I create a new Customer, invoice them and mark the invoice as paid? for more. |
|
|
|
|