3 replies to this topic

[jparram]

I am new to the forum and to MOM.

I am currently working with MOM ver. 5.0 demo. and I am building an interface to query Order information and inventory information. What tables would I need to query to produce the information generated when you do an order lookup?

Thanks

[planetdj]

I am new to the forum and to MOM.

I am currently working with MOM ver. 5.0 demo. and I am building an interface to query Order information and inventory information. What tables would I need to query to produce the information generated when you do an order lookup?

Thanks

I'm shooting from memory here since I don't have the time to look right now. But I believe you'll need to include BOX, CMS, CUST, INVOICE, ITEMS, JOURNAL and STOCK. You'll also need PRICE if wanting to list the pricing.

[jparram]

I'm shooting from memory here since I don't have the time to look right now. But I believe you'll need to include BOX, CMS, CUST, INVOICE, ITEMS, JOURNAL and STOCK. You'll also need PRICE if wanting to list the pricing.

Great!...Thank you for your help

[planetdj]

Let me know how the project goes... I've been thinking of starting the same for a while now, but have been busy with other projects.