Sage 100

I have a customer on Sage 100 2019 that is asking about reports to track vendor on-time performance as it relates to purchase order delivery times ( expected vs actual).

Has anyone created such a report or have any suggestions on the best way to extract this information?

I suppose this is just a Crystal Report pulling from: 

PO_ReceiptHistoryHeader
PO_ReceiptHistoryDetail
PO_PurchaseOrderHistoryHeader
PO_PurchaseOrderHistoryDetail
AP_Vendor

Any shortcuts to this ?

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

I know I've done these before, but the only one I can think of off the top of my head is still in 3.x format and uses a UDF for a date.  A couple of things, though - I don't think you need the PO History files because the Required Date is in the PO Receipt files, so that should be all you have to compare the actual receipt date to.  And the Vendor name is included in the Receipt files, too, I think, so you wouldn't need the AP_Vendor unless you need more than name.  Fewer files, quicker running.

I'll keep trying to think of who else I may have written this for and will send one over if I can find it.

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Tennessee Software Solutions
269-445-1625
------------------------------

You could probably use the Purchase Order Receipt History Report as a foundation and source UDFs into it if needed.  This could help reduce table joins in the actual report.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 07-21-2021 10:27
From: Beth Bowers
Subject: Vendor performance tracking ( PO Expected vs Actual ) - ISO

I know I've done these before, but the only one I can think of off the top of my head is still in 3.x format and uses a UDF for a date.  A couple of things, though - I don't think you need the PO History files because the Required Date is in the PO Receipt files, so that should be all you have to compare the actual receipt date to.  And the Vendor name is included in the Receipt files, too, I think, so you wouldn't need the AP_Vendor unless you need more than name.  Fewer files, quicker running.

I'll keep trying to think of who else I may have written this for and will send one over if I can find it.

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Tennessee Software Solutions
269-445-1625
------------------------------

I think that PO Receipt History files is going to work. I’m meeting with the customer today.


---------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
---------------------------------



Original Message:
Sent: 07-23-2021
From: David Speck II
Subject: RE: Vendor performance tracking ( PO Expected vs Actual ) - ISO

You could probably use the Purchase Order Receipt History Report as a foundation and source UDFs into it if needed.  This could help reduce table joins in the actual report.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------