Method Community

Hi, I got a problem that can not set value to a field of a new created item line in a purchase order. My scenario is: 1. I have a "Depot" table, which has a "Location" field (text, unique) 2. In PurchaseOrderLine, I add a pushdown field "DepotLocation" which points to "Location" field of ...

Hi, Is it possible to generate multiple rows in a Grid by Actions? I'm working on PurchaseOrder screen, in my case, I need to create multiple rows in "PurchaseOrderLine" grid automatically. Each row should be fill with specific value (item, quantity and unit price) In the action, I can see "Insert new row into grid", ...

Hi, Here is my table layout: (a) In my own table "ProductInfo", there are two fields "ProductUniqueID" (an unique field) and "ProductName".  (b) In "PurchaseOrderLine" table, a Linked field to ProductInfo.RecordID is inserted as a dropdown, and named as "AssociatedProduct". (c) In ...

Hi Fran, Yes, you are right, and thank you for detail answer.  And, yes, to associate single SOLine with my own Product will do the job. Sorry that I did not mention a key part that my client requests, that is "Quantity" for every item line can be adjusted (1 or more.) The request is, in my client's case, one ...

Justin, it is all about to keep synchronize with Quickbooks desktop. In our inventory system, every product is associated with a QuickBooks Item, also, every our product has an uniqe ID, and we need to track this product ID in all kinds of transactions. So, after sync Method data back to Quickbooks, accounting person can know inventory status of ...

Hi Justin, Got it about Vender/Entity relationship.  regarding my inventory system. We try to use "items" like in QB. It works like, for example in a Sales Order: 1. We create a Table "MyProduct", each record row defines one of product in inventory system.  2. In a Sales Order screen, we try to link ...

Thanks, Justin. It seems that "Vender" table has no any link connected to "Entity" table, is there anything been done automatically to connect them both? I'm asking is if I can use the same configuration for my use case. I'm building an inventory system, and every product in this system need to be associated with ...

Hi, In CRM_VenderList, I tried to figure out how vender table and transaction are linked but can not get any idea. In CRM_VenderList screen, when I click a vender in left-section, "Transaction" tab in the right panel is updated immediately. I only know "Transaction" table is attached to this screen, but don't know exactly ...

Hi All, I read from previous post regarding "Transaction" table like: === The "Transaction" table is a special "combined" table in Method that merges together some of the key fields of all the transactions tables (like invoices, payments, sales receipts, etc.).  Unlike other tables, the Transaction table does ...

Hi, is there any action in Method that can take a file (import from users) then parse it to get the content? I have a case that users would like to import data from excel file, then put it in a grid. Is there any action that can import file and any parse function or file I/O functin? thanks. -- Alex