Method Community

What causes TxnLineID sync errors? Is there an easy way to fix these? 

I have a new Sales Order that won't sync to QB. It looks like every line item has a problem with the TxnLineID. When I delete the line item and re-add it, the conflict seems to get cleared up. WTH. There are 23 line items on the order...so now I have to delete and re-add every one of these? Is there an easier way to clear this up? What ...

Thank you. I think all my data is fine. Luckily the screens my users are on each day don't make use of data updates in grid loops. Just some read-only validation logic but nothing that does bulk updates/deletions, thank God. Hopefully you guys now have some automated tests for this going forward.

It appears looping is working correctly again. Any reason I need to hold off putting users back on the system? Thx

Awesome. Thank you

Ditto. The same yellow message showing record looping progress was what caused me to look into the issue further as well. That's what led me to turn on debug trace and pull the sql being executed. The total record count matched that of my entire SalesOrderLine table. This started yesterday around 2:30PM CST but I didn't get a chance to ...

Here's the thread I have going on the issue. https://www.method.me/cs/forums/t/7891.aspx You can see I posted the SQL that shows the unconstrained query resulting in a full table loop. Freaks me out...if I have any updates executing inside an unconstrained grid loop...that's potentially a VERY damaging bug/issue. Hopefully I'm ...

I've deactivated all my user logins until this issue is fixed. I'm just really freaked out seeing unconstrained queries running over entire tables. Really wish someone at Method would confirm the issue, provide some feedback on this. Thx 

This could be really damaging as we run table loops all over the place in Method. We could be executing logic over entire tables and messing up A LOT OF DATA if I'm thinking about this properly

There's definitely a problem with the Start Loop Through Grid action. I'm seeing this on my Sales Order screen right now, too. The query is running unbounded with no constraint for the current sales order hence a LOOP OVER THE ENTIRE TABLE! Here's the debug trace for my sales order screen's Loop Through Grid action. See my note at ...