Method Community

Thank you for your reply Greg. Correct me if I am wrong, but, in inventory control, the lot number is stored with the purchase receiving transaction. In QB the Lot number is entered on the purchase receiving transaction. The lot number is then stored with the inventory quantity on hand in a "lot layer" of quantity on had per that ...

Hello,     The lot number is stored in the SalesOrderLine and InvoiceLine table. The InventoryControlBin table is from an obsolete application in Method and is not used anymore.  The InventoryControlLocation table will store the location of the bin.  To see it in your Sales Order or Invoice screen, you will have to add ...

Thanks Matt for the post.  You are correct.  In the screen designer, there is no merge function.  You would have to add lines to one section and drag your objects to those free lines. Have a good day, Greg

Hi Afrec, There is no way to automatically combine sections. All you need to do is move the objects (fields and buttons) from one section to another.

Ok. Thanks! for some reason it wasn't letting me scroll to see the rest of the tags below the first few.  I have another Tag question though :) I would like to add the tag list option that is in the edit contact screen to the New Lead Screen. I followed the instructions in the help center article: "Any table can support tags. ...

Hi.  Sorry you where having troubles this morning.  I’m not sure this is really an API issue, since you are generating reports rather than using the API, but the syntax of the SQL should be the same regardless.  We have applied no patches to the DB server that would have caused this stop working.  Most likely, there ...

I figured it out!!  Thankfully I am a DBA and knew where to look.  There must have been a SQL Server patch applied today in Methods DB that started strongly enforcing datatypes in SQL WHERE statements.  I had a X > 0 on a TEXT (varchar) column that started breaking the WHERE.  I checked the data types and found X was TEXT. ...

I figured it out!!  Thankfully I am a DBA and knew where to look.  There must have been a SQL Server patch applied today in Methods DB that started strongly enforcing datatypes in SQL WHERE statements.  I had a X > 0 on a TEXT (varchar) column that started breaking the WHERE.  I checked the data types and found X was TEXT. ...

Are the QBE Advanced Inventory lot numbers able to sync with MethodCRM. I have loaded the latest engine but when I export the InventoryControlBin file it is empty.

Around 10:30 EST on July 17, 2014, we started having an issue with Method reports.  Many of our reports stopped working at the same time.  These are custom reports from custom screens that have been running well for months and have not been changed recently.  I am trying to find out what the Method folks may ...