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
|
|
UPS export shipping charges and tracking number |
Author |
Message |
|
Posted : 2007-11-15 11:25:21 |
What are the table and field names needed locate and insert a freight line item into quickbooks from UPS worldship? I have a service item named "freight" in inventory. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-11-15 11:41:21 |
|
|
|
|
Posted : 2007-11-17 08:44:10 |
Well both me and the UPS IT guy thought it would be a slam dunk using the TxId to find the right invoice to add the line and it does find it, but we got ODBC ERROR = S0000 field not allowed in insert when writing to Item, Description, rate, or Amount. He could write to a custom field. Any idea what went wrong? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-11-18 21:42:22 |
Well I guess you slam dunk didn't pay attention. You cannot perform insers on the invoice table, you must only do inserts using the invoiceline table. Because the invoice already exists you must the Plan B method as shown in: Using ClassRefListID when inserting invoice lines |
|
|
|
|