Method Community

VERY weird problem I noticed today on my Sales Order screen. Once a value is put into a text box and saved (say, a PO Number or the Memo) and then if that value is subsequently is removed, leaving the text box empty...the field seems to be updated, but once the record is loaded again (Set Active Record  ID for Screen by clicking Select in the SO List grid), the previous values return in the text boxes.

The net problem is: I can't clear out a textbox field once it is saved with a value. I can UPDATE the field to a different value, but clearing it out (making it empty)...no dice.

This happens on the stock screen as well as my custom screen.

What gives?

Thanks,

BC

UPDATE: This happens for the Customer Message (dropdown) and Due Date fields (datetime dropdown field) as well. It's not just simple text boxes. It's anything on the screen. Once a field is saved with a value, it will only update to other non-empty values. An empty value isn't honored.

Seems like a form post issue to me.

This is kind of a problem.

Hey Blake,

Are you making sure to Save your changes? There may also be some other validation rule you have setup, i.e. if Due Date is blank then stop processing more actions. I just tried this on my stock Sales Orders screen and was able to successfully remove all values in the Customer Message, Due Date, and Memo fields. Reloaded the Sales Order and the fields remained blank.

- Ashur

Yes. Save All Sections is in there...just like it is on the stock screen. Like I said, updates to other values work...just not udpates with empty values. I'm using the stock screen right now and seeing  the same behavior

Ensure you are not editing any screens, Publish then Save & Close. Try regenerating your Sales Order table; just find the table and click Edit Fields..., when the edit fields screen pops up just click Finished Editing Fields. Now try testing your stock screen again to see if that worked. If the issue persists please enable your MethodSupport user (Customize > Users) and let me know when that's done.

- Ashur

Still a problem. Saved Sales Order table (no changes made) and tried to clear these fields but the values come back for some reason.

Support is enabled. Account: TMC

Just tested it using your QuickBooks_SalesOrder screen and it worked fine. Go to Customize > Screens and click the View button that comes up to the left when you hover over the screen name. Click the first Sales Order on the top of the list, last four digits are 0111, and you'll see I was able to save it with the Due Date, Customer Message, and Memo fields without any values. There's a custom screen called QuickBooks_SalesOrderOriginal, is this the screen you thought was the stock screen? Best way to find out if you're on a stock screen or not is to hover over the tab link you clicked on to get to it and look at the name of the screen.

- Ashur

Thx for doing that....but go back and view that screen again. The data is back.

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.

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.

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.

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

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.

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

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.