2 replies to this topic

[[email protected]]

Hello,

I've been trying to figure out a way to extract

Purchase orders, both non-drop ship and drop ship,

from MOM. The goal would be to create a file which

we could then go to our suppliers web site and up

load.

The reason for this is that many of our suppliers

are moving away from purchase orders which are sent

via fax, or email. They woulld rather have us either

hand type it into their web interface or upload a

file via their web site.

The file would need to be created on a supplier

basis. Meaning, we would extract the PO data for

each supplier for a particular date. Example,

extract the purchase orders for todays date for

supplier XYZ, extract the purchase orders for todays

orders for the next supplier. Each extracted file

would have a slightly different file format

depending upon what the supplier requires in the

file format. Obviously the PO's for the drop

shipments would contact the info as to who the items

are being sent to.

I spoke with the people at Dydacomp and they

identified the following tables as having the data

we would need:

Purchase.dbf
Puritem.dbf
Cms.dbf
Cust.dbf

They suggested that we could use Report Writer,

Crystal Report or Fox Pro to write a program which

would extract the data based on the criteria we

would define. This program would be run after our

drop ships have been done and after the normal

purchase orders have been done. By done, I mean that

they have been completed in MOM, but they have not

been sent to the supplier. I'm thinking that we

would set all PO's to just print.

My question is, has anyone tried this?

Thanks

[dseibold]

I haven't tried it but the data would be located in the following tables

puritem.dbf list of items ordered and related details.
purchase.dbf list of P.O. numbers, dates, and supplier code for the items
listed in puritem.dbf
supplier.dbf supplier name, address, etc.

It can be done in Access very easily. Report Writer is slightly more difficult IMHO.
I have no experience with the other programs.

David Seibold

[Videoflicks2004]

I haven't tried it but the data would be located in the following tables

puritem.dbf    list of items ordered and related details.
purchase.dbf  list of P.O. numbers, dates, and supplier code for the items
                      listed in puritem.dbf
supplier.dbf    supplier name, address, etc.

It can be done in Access very easily. Report Writer is slightly more difficult IMHO.
I have no experience with the other programs.

David Seibold

Hi,

Why not use my OPEN PO REPORTas a base. It can be modified to show all suppliers (not just drop ship suppliers).

This is a good way to start. I use this report to export my printed purchase orders to my suppliers in an excel format.

However, it sounds like you are really trying to get an EDI system in place. These are expensive to develop but I am working on one now.

Cheers,

Videoflicks2004