Method Community

Hi there,

I've had no trouble adding a grid for each LineItem table associated with an Inventory Item in our Inventory Item screen. I can show Purchase Orders, Item Receipts, Bills, Estimates, Sales Orders, and Invoices relevant to a given Inventory Item all in their own grid without a problem.

What I'd really like to do is basically something like a union query, where I can pull all of these into a single grid using custom SQL statements. We can use custom SQL elsewhere in Method.

Is this something that's in the hopper for v2? It would be immensely useful for companies that deal with physical inventory.

Thanks,

-S

Hello,
      It sounds like an interesting screen.  It almost sounds like you want to use the Transaction table, which is the parent table for the purchase order, sales order etc.  You can make a grid of this table and you may be able to display all of the records associated with the Inventory Item.
   
      V2 will have customization just like V1.  I am not privy to what features are planned for v2.  I know they are currently building the core functions and commands.  

- Greg