Method Community

Michael, I've looked further into this problem and I really need some help with it. We have too many Invoices where the Invoiced QTY is not updating the Sales Order Line Item Invoiced QTY. I have added RecordID to the Sales Order Line Item Grid so I can see the Line Item RecordID and to make sure this data is available in the Grid for Loop ...

Michael, All my screens are custom, but these values update on their own 90 to 95% of the time.   But, I've always had these few that don't update properly. I can't find a conflict on the conflict tab that explains things, but these log entries are very difficult to read and I always have tons of conflicts.  Every Bill we ...

Ditto to Michael.   QB handles all the updates of the boolean "IsFullyInvoiced" AND the QTY's.  If this was done in Method it would be easy to fix or modify the behaviour, but since it happens automagically by QB, we have to be careful not to trip up the QB logic, get double counts etc. Back to my original premise that ...

I am having some problems getting some Invoices to post their invoiced line items to the corresponding Order. All of the Invoices are created from the Create Invoice action sequence and I can see that the Invoice Header has the correct recordid for the "parent" Order.  But the quantities will not post.  I have looked at both ...

Smohyee- This is one of my favorite technical topics for QB Method integration.  No joke, I'm really that interested. There is a related process where the entire Order gets marked as closed.  I believe this actually happens in QB as it compares the Order QTY of all line items to the Invoiced QTY.  If the Invoice QTY is >= ...

Fixed.  Thanks for the quick response.

Oh, and I forgot to add, the fields appear to be gone from both the table and screen, so everything "looks" clean.

Oops, I think I've corrupted one of my tables, SalesOrderLine and/or screen. I deleted a couple of fields from table SalesOrderLine without First removing the fields from a screen.  Now when the screen attempts to open it says "Invalid column name 'PartIDImage'. Invalid column name ...

Michael, my customized SalesOrder_CreateInvoice screen is now working, I think because I replaced the End Loop Through Table statement with End Loop Through Grid.  But, the Full Blown Method Edition of this screen still has the corrupt Action sequence logic.  It appears to have some new logic to handle line item groups, but it ...

Michael, will that fix my customized screen?  I can look at Action Sequence of the Method default screen and try to match mine.  I did not change any of the logic, I only added fields to the insert row action so my custom line item details are added, but I'll still need to get this working in a customized screen.  I'll ...