JTank
Member
Wednesday, 1 November 2000
Software [Version]: WorldSoftware [A73C6]
Operating System: OS/400 V4R4
I am looking for suggestions/direction regarding the following
requirements that we have.
Process: We receive raw materials from a number of suppliers. The
shipping of the product between supplier and plant is done via carriers that
we have contracted with for that purpose. Each invoice (supplier and
carrier) contains multiple line items reflecting multiple shipments (usually
a daily summary). A given carrier can operate from any number of supplier
locations. A given supplier can expect to have multiple carriers picking up
products. The end result is that a single carrier invoice will not contain
the same line items as an associated supplier invoice.
There are two forms of documentation that I have available. The shipping
document travels with the product and is generally the first document to
which we have access. The supplier/carrier invoice is the second document
and follows the shipping document. The exception to this is when our own
plants ship to other company plants utilizing our billing system. In this
case the billing system will provide the equivalent of the invoice overnight
and the shipping documents follow.
Requirement: We need to be able to match the shipping documents with
both the supplier and carrier invoices. If only dealing with the material,
it would be an easy matter. The need to account for the freight clouds up
the picture. Is there an easier way to handle this situation than use the
shipping documents to create multiple purchase orders (one for each supplier
and carrier being used) and receiving against the purchase order using the
invoice as the receiving document.
The information regarding freight processing from a procurement need has
been scarce. Any help in answering these issues would be appreciated.
James Tank
Lead Systems Analyst - MIS
RMC Pacific Materials, Inc.
Software [Version]: WorldSoftware [A73C6]
Operating System: OS/400 V4R4
I am looking for suggestions/direction regarding the following
requirements that we have.
Process: We receive raw materials from a number of suppliers. The
shipping of the product between supplier and plant is done via carriers that
we have contracted with for that purpose. Each invoice (supplier and
carrier) contains multiple line items reflecting multiple shipments (usually
a daily summary). A given carrier can operate from any number of supplier
locations. A given supplier can expect to have multiple carriers picking up
products. The end result is that a single carrier invoice will not contain
the same line items as an associated supplier invoice.
There are two forms of documentation that I have available. The shipping
document travels with the product and is generally the first document to
which we have access. The supplier/carrier invoice is the second document
and follows the shipping document. The exception to this is when our own
plants ship to other company plants utilizing our billing system. In this
case the billing system will provide the equivalent of the invoice overnight
and the shipping documents follow.
Requirement: We need to be able to match the shipping documents with
both the supplier and carrier invoices. If only dealing with the material,
it would be an easy matter. The need to account for the freight clouds up
the picture. Is there an easier way to handle this situation than use the
shipping documents to create multiple purchase orders (one for each supplier
and carrier being used) and receiving against the purchase order using the
invoice as the receiving document.
The information regarding freight processing from a procurement need has
been scarce. Any help in answering these issues would be appreciated.
James Tank
Lead Systems Analyst - MIS
RMC Pacific Materials, Inc.