Is there a way in Sage 50 to create a reports as follows (we do have Crystal Reports, just haven't used it in a long time):
Customer Name | Sales Order Number | Vendor Name | Vendor Purchase Order Amount (only show if invoice already paid) |
Acme | ABC111 | Widget Maker | (Widget Maker invoice has not been paid yet so it's blank) |
Smith Inc. | ABC222 | Stuff Maker | $4000.00 |
Thing Maker | $1234.00 | ||
Bob Bakery | ABC333 | Big Ovens | (Big Ovens invoice has not been paid yet so it's blank) |
Pan Place | $540.00 |
Every OPEN Customer Sales Order Needs to show
Every Vendor / Purchase Order needs to show, and if the Vendor Purchase Order Invoice has been paid, it needs to show the dollar amount.
Hope that makes sense.
Thanks,
Mitch