Jump to content


Photo

Open Purchase Orders after Receiving is done???


  • Please log in to reply
1 reply to this topic

#1 SandyMarie321

SandyMarie321

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 06 December 2007 - 11:33 AM

I have a drop shipping company that ships from about 92 different vendors. We do all the receiving on MOM 5.1 and keep up with open Purchase Orders that they haven't filled yet. Is there a way to print the remaining Purchase orders from each vendor after we process updates to inventory. I would rather put it into an excel file and send it as an attachment instead of having to make one manually everyday.

any help would be great.

Thanks.

#2 dseibold

dseibold

    Advanced Member

  • Moderators
  • PipPipPip
  • 137 posts
  • Gender:Male
  • Location:Stockton, CA

Posted 07 December 2007 - 09:47 AM

Since you're still using MOM 5, you could use MS ACCESS or R & R to read the purchase order and print a report or export an Excel file.

The Supplier information is in supplier.dbf
The Purchase Order information is in purchase.dbf.
The Items on the Purchase Order are in puritem.dbf

Currently MOM 6 doesn't have a working ODBC for those of us who need it.
David Seibold
Wild Horses, Inc.
Operations Manager




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users