Method Community

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

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.

Yes, I figured that out right before I got your reply! :) Now my next issue - somehow, my Group Header1 and Group Header2 switched places and I can't get them back.  I didn't switch them, and have no idea how they could've switched, but they did.  I'm not getting the option to move them up or down - it's greyed ...

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 ...

Apologies please see my edit below. + Company + Invoice  <---- Expand me + InvoiceLine + Company + Invoice    -Field 1    -Field 2    +InvoiceLine       -Rate <---- Use me       -Qty    -Field 3    -Field 4 + Invoice - Ashur

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 ...

When you open your report, look at the Field List section, usually on the right side of the screen, and ensure you're using fields from the correct detail table. You want to use the fields from the InvoiceLine table and drag them to the Detail section of the report. Example below. + Company + Invoice + InvoiceLine <---- Expand ...

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

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 ...

Thanks Ashur, I actually figured out the spacing, what I can't figure out , and is the bigger problem, is why it's repeating the same item row from the line item table, rather then listing each line item that is on the invoice. I have created this template in Report Designer. Thanks! Karen