[QODBC-Desktop] How to change the Income Account for a Stock Item that has already been invoiced
Posted by brad waddell on 12 March 2009 05:21 PM
|
|
An Example of a Change in the Income Account for a Stock item that has been InvoicedCreate an Invoice for a StockHere we create an invoice for a stock part called 'Door Frame': INSERT INTO "InvoiceLine" ("CustomerRefFullName", "RefNumber",
Retrieve the TxnID for the transaction just CreatedTo retrieve the TxnID for the transaction I just created, I use the QODBC stored procedure: SP_LASTINSERTID InvoiceLine
Retrieve the TxnLineID from the Invoice LineI can then retrieve the TxnLineID for the invoice line using the TnxID: '5DE5-1197763322': select TxnID, InvoiceLineTxnLineID, InvoiceLineSeqNo from InvoiceLine
The TnxID and TxnLineID for the Invoice line I just created are: 5DE5-1197763322 and 5DE7-1197763322 The result is Displayed in QuickBooks. In QuickBooks, a brief report for the invoice I just created shows the income account to be: Construction: Materials.
Change the Income AccountUsing the TnxID and TxnLineID for the Invoice line I just created, I can change the income account to a new Income Account by using the following UPDATE statement: UPDATE InvoiceLine
The result is Displayed in QuickBooks. When I refresh the Quick Report in QuickBooks, it now shows the Income Account as New Income Account
| |
|