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
|
|
I want to be able to set an empty date into the customer JobEndDate, how do I do that? |
Author |
Message |
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-02-26 10:58:10 |
The correct and tested syntax is:
Update Customer Set JobEndDate=NULL where ListID='80000-1045537156'
however, you will get an error message saying: "Cannot clear the element in the job end date field" as it's not allowed by Intuit's qbXML SDK.
So, you will need to either clear the JobEndDate manually using QuickBooks itself, or change it to another valid date other than NULL, ie:
Update Customer Set JobEndDate={d'2008-08-12'} where ListID='80000-1045537156' |
|
|
|
KofK |
|
Group | : Members |
Posts | : 43 |
Joined | : 2006-04-04 |
|
Profile |
|
Posted : 2007-06-16 00:40:21 |
Is this going to be fixed be Intuit? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-06-16 03:36:28 |
Unfortunately this gets tied up with separating a job from a Customer programatically. It's more than just clearing the JobEndDate for the job -- there are transactions referencing the job.
The solution is:
- Modify the original customer to rename it something guaranteed not to conflict with any other entity record in QuickBooks.
- Create a new customer with all the information from the original customer, except the job information.
- Modify the original customer record again to rename it Job 1 (if we duplicate what the UI does, or a more descriptive name if our application knows better than QuickBooks) and to set its ParentRef to the new customer we created in step 2.
- Create the new job we intended to create, and set its ParentRef to the new customer we created in step 2.
-- its the same one QB uses internally if you want to add a second job to a customer with job info.
|
|
|
|
|