Method:Classic General Q&A

Re: Sales Order Fields Won't Update

Blake C — Tue, 12 Feb 2013 22:53:33 GMT

It's enabled right now. I'm free tomorrow, Wed 2/13 at 9:30AM CST

Re: Sales Order Fields Won't Update

Method_Ashur — Tue, 12 Feb 2013 22:44:20 GMT

Blake,

Please enable the MethodSupport user and let me know when you would be free to start a screen sharing session tomorrow.

- Ashur

Re: Sales Order Fields Won't Update

Blake C — Tue, 12 Feb 2013 22:02:20 GMT

I just noticed this issue is recurring....tried to update a field on a Sales Order to an empty value. The push engine is updating it to it's previous value again. Perhaps the bug fix from mid-December you guys implemented didn't get folded back into the main trunk? Just a thought....

Re: Sales Order Fields Won't Update

Method_Ashur — Wed, 19 Dec 2012 17:58:37 GMT

Good to hear! Sorry, I don't know the details of the fix.

- Ashur

Re: Sales Order Fields Won't Update

Blake C — Wed, 19 Dec 2012 17:47:54 GMT

Yes. Looks good. Must have been a fix in the web UI "push" code, then?

Re: Sales Order Fields Won't Update

Method_Ashur — Mon, 17 Dec 2012 14:57:07 GMT

Hi Blake,

This issue should now be resolved, let me know if you experience any problems.

- Ashur

Re: Sales Order Fields Won't Update

Blake C — Fri, 07 Dec 2012 16:39:59 GMT

Dang. Wasn't aware of that. I certainly didn't want to feel special re: this issue. We never did look at my Method QB Sync. settings yesterday but there's nothing special there, I don't think.

One thing I noticed in my AuditTrail immediately after the record update goes through (the record with blank values) is the message below. The computer making the change is the computer the QB file and sync engine is located on.

The DesktopSync Engine modified the SalesOrder transaction '52691...', which was modified in QuickBooks on 12/6/2012 10:30:50 PM.

Let me know if there's anything else to check on my side.

Thx again

Re: Sales Order Fields Won't Update

Method_Ashur — Fri, 07 Dec 2012 15:35:16 GMT

Just to clarify, I haven't come across anyone else experiencing this issue, and we haven't been able to replicate it on our end so it seems to only be affecting your account. That's why we started the screen sharing session; to see it happen along with checking to see whether the QuickBooks or Method settings played a factor, which they did not.

- Ashur

Re: Sales Order Fields Won't Update

Blake C — Fri, 07 Dec 2012 15:10:19 GMT

Yeah, I saw that. Thanks for the help yesterday. Good luck on fixing that bug. I wouldn't think that would be a difficult fix. A few more unit tests and perhaps some minor refactoring on the sync engine code should do it. I'm just glad the issue will be addressed and no other Method customers will have to spend a day spinning their wheels on the issue.

Thx again.

Re: Sales Order Fields Won't Update

Method_Ashur — Fri, 07 Dec 2012 14:48:17 GMT

Hey Blake,

As stated on our phone call yesterday I've created a ticket for our dev team to investigate this issue and will email you an update ASAP.

- Ashur

Re: Sales Order Fields Won't Update

Blake C — Thu, 06 Dec 2012 21:32:15 GMT

Wow. That "works". Disconnecting the sync engine makes the problem go away. Saving empty values works just fine while disconnected.

Connect it back up and the problem persists yet again. QB changes the value BACK to what it was before it was empty.

There must be bad logic in dealing with updates in the sync engine where empty fields are concerned.

This is a pervasive problem on ALL fields that are synced. I just replicated the problem on the SO line item description field.

Re: Sales Order Fields Won't Update

Method_Ashur — Thu, 06 Dec 2012 21:01:51 GMT

Do me a favor: Disconnect and shutdown your Method Integration Engine, then remove the data from those fields, and Save. Reload the screen after a few minutes, check the Sales Order you edited, and let me know whether the fields are populated again or not.

- Ashur

Re: Sales Order Fields Won't Update

Blake C — Thu, 06 Dec 2012 20:07:47 GMT

By the way...same behavior on Estimates, as well. Stock screen. SAME. EXACT. BEHAVIOR.

Once a field has a value in it, I'm unable to clear it out. The previous saved value always comes back the next time the record is loaded.

Re: Sales Order Fields Won't Update

Blake C — Thu, 06 Dec 2012 19:53:49 GMT

I'm looking in the Audit Trail and notice an interesting API call. The fields included are the ones I'm trying to clear out.

MethodAPISelect_XMLV2 - viewaccSalesOrder

The following query was created in MethodAPISelect_XMLV2: SELECT TOP 333334 [Customer],[Memo],[PONumber] FROM [viewaccSalesOrder] WITH (nolock) WHERE ([TenantID] IS NULL OR [TenantID]=1) ORDER BY [RecordID] desc at 12/6/2012 1:36:32 PM. Returned dataset size was: 28990

I can't seem to force this API call, though. Not sure what triggers it.

Re: Sales Order Fields Won't Update

Blake C — Thu, 06 Dec 2012 19:24:56 GMT

When you click Save...the data indeed clears from those fields. In fact, the data is saved properly (I exported the table immediately after Saving the record and see those fields are empty in the db).

But once you load the record again (click Select in the grid list), for some reason the previous values get loaded back and Saved to the db.

I'm doing this on the stock QuickBooks_SalesOrder screen.