Search results by user ID 5652

Re: Customer Table, Notes Field

nick_warren — Mon, 20 Oct 2014 11:54:56 GMT

Figured it out, its vbLf

Customer Table, Notes Field

nick_warren — Mon, 20 Oct 2014 11:34:45 GMT

Does someone know of a way to trigger a "New Line" in the Notes field inside QuickBooks.

I tried back tracing this by entering a string with New Line in QuickBooks and syncing it back to method. It seems that the API returns it as one long string without any chars signifying the newline.

For instance, if I enter this in the Notes field in QB:

"This

Test"

It comes back to me in the API: <MethodIntegration Table='Customer'> <Record> <Notes>This is a Test</Notes>

I tried sending \r\n to QuickBooks but that didn't work.

Any suggestions?

Sales By Item Report with Dates and Item Filter

nick_warren — Sun, 25 Nov 2012 13:03:41 GMT

Any idea on which Query to use for a Sales By Item Report?

I thought about putting all the Sales Order using a date range on a datatable and then checking S.O by S.O for the specific item requsted - seems tedious to me.

Any Ideas?

Full Sync All the Time

nick_warren — Mon, 22 Oct 2012 18:10:23 GMT

For some reason, the Sync Engine does full syncs all the time, one after the other.

Can anybody help with this? Its a nightmare. We have 30,000 items in QB and a full sync takes an hour.

Nick

Re: Issues with Address Fields

nick_warren — Sun, 30 Sep 2012 16:51:14 GMT

Paul,

Sending the blank fields and then waiting for sync is not an option for us. We need this to be a so called, real time solution. We cannot keep syncing QB, go back to our software, send the address again and then sync again. It will make the work very tedious, which is what we're trying to prevent.

Moreover, my problem which I stated before and you guys did not address is that I am sending EMPTY values to the City, State, PostalCode and Note fields through the API but when the sync occurs, those are not shown in the XML request to QuickBooks. This is where the problem starts. Why can't we force these fields into the request, even if they are empty inside Method? On every request to Method, I'm "deleting" those City, State, PostalCode and Note fields. The wierd thing here that in the request to QuickBooks, Method sends the Note field with the empty value (<Note />) but not the City, State and PostalCode.

Another issue that I noticed is that when I update Method through the API, Method updates correctly. For some reason when SYNCING, QuickBooks "re-arranges" the address field and updates Method. I'm not sure why this is happenning.

Can you think of any other way to make this work?

Nick

Re: Issues with Address Fields

nick_warren — Thu, 20 Sep 2012 15:13:55 GMT

Well, you guys changed the location of the question to the API forum, not me :)

Dave, this has nothing to do with the conflicts. I suggest you access my account and see for yourself. Moreover, I'm pretty sure you are not replcating the issue here, because you are starting from a new customer.

Please try to do the following:

Add this customer to QuickBooks using the following ShipTo Address:

<addr2>100 Broadway St</addr2>

<addr4>Phone: 1111111</addr4>

After you added this customer please try to EDIT it through the API and send the following address

<addr2>Nick Warren</addr2>

<addr3>100 Broadway St</addr3>

<addr5>Phone: 1111111</addr5>

You will see a conflict. QuickBooks will not go ahead and make the changes.

After the API call the data do CHANGE in my Method account, but a confilict occurs. QB Sync is invoked from Method Desktop App.

Moreover, when you send blank fields, you do not see them in the request. For instance, I try to send a <city></city>. I do see it when debugging but when it reaches QuickBooks your Sync Engine is ignoring it and its now shown in the request.

Nick

Re: Issues with Address Fields

nick_warren — Wed, 19 Sep 2012 16:12:20 GMT

Guys I understand all of you are exteremly busy but this issue is very urgent for us and I will really apprecaite it if you can attend to it.

My biggest problem at this time is that the Sync engine simply ignores all the empty fields that we send its way through the API.

Thank you!

Nick

Re: Issues with Address Fields

nick_warren — Wed, 19 Sep 2012 00:40:15 GMT

Paul,

It’s not working for me – QuickBooks does not update the address fields with empty rows, no matter what I do. I verified all the fields are sent.

Another issue you failed to address previously is the fact that I do not see these fields in the request. When I send a field through the API with an “” value, I do not see it in the Sync Request with QuickBooks later on. When the conflict appears on the control panel it has all the values but the empty ones.

Nick

Re: Issues with Address Fields

nick_warren — Sun, 16 Sep 2012 14:34:13 GMT

Paul,

When I send an empty address through the API to QuickBooks, Method populates the information and all address fields are empty.

When the sync triggers, instead of populating QuickBooks with empty addresses, Method takes the existing address from QuickBooks and puts it in the document. This is not a normal behavior as I want Method to update QuickBooks not the other way around.

We have a requirement to put the phone number in the ShipTo address, there is no way around it, therefore using City, State and PostalCode are out of the question and we're forced to use Add1-Addr5.

Your (3) suggestion simply doesn't work. When I send an empty address to Method through the API, Method updates properly. Again, as I explained before, when the Sync triggers, QuickBooks updates Method for some reason with the previous address.

As it seems now, I cannot overcome this issue. Is there a way to force this "one way" syncing and to populate QuickBooks with an empty address field.

Nick

Re: Issues with Address Fields

nick_warren — Sat, 15 Sep 2012 18:33:28 GMT

Does the Sync process is the one which is responsible of "avoiding" these "" fields? If so, it is related to the Sync process.

On the other hand, you probably CANNOT REPLICATE this issue from the Method Interface and therefore it is API related.

I doubt it if anyone that is unable to replicate the issue will be of any help.

Nick