Jump to content


Photo

Hello


  • Please log in to reply
3 replies to this topic

#1 jparram

jparram

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 11 April 2008 - 08:39 AM

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

#2 planetdj

planetdj

    Advanced Member

  • Members
  • PipPipPip
  • 109 posts
  • Location:Reno, NV, USA

Posted 11 April 2008 - 06:47 PM

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.
Chris Whybrew
PLANET DJ, INC
www.planetdj.com

#3 jparram

jparram

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 16 April 2008 - 06:24 AM

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

#4 planetdj

planetdj

    Advanced Member

  • Members
  • PipPipPip
  • 109 posts
  • Location:Reno, NV, USA

Posted 18 April 2008 - 06:10 AM

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.
Chris Whybrew
PLANET DJ, INC
www.planetdj.com




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users