Searching for a report that will serve my needs.

We are a product distributor an are constantly purchasing and shipping products. My job is to expedite the order. Our orders are sent by

email  and while we insist on a confirmation, in most cases we do not receive one.

My first task is to fetch the printed hardcopy of the PO and call the vendor to verify they have the order, check pricing, etc.

My next task is to update the items that have been backordered for our sales department.... well this is where I think I may be missing

something. Based on the reports I have found, I print Sales Order/Reports/Back Order Report, sorted by either item or customer number.

Now I have an item number to follow up on, I use Item Maintenance/History. then click the vendor rcpt button to tell who we purchased

from. I then start a handwritten list for that vendor, because as I go through the list, I will find several items from the same vendor.

I then phone each vendor for an update on the shipping of our order.

There must be a more intuitive way to do this. Thanks in advance for any help. Gregory

  • 0
    I would be running the Open Purchase Order Report from the PO module and sorting it by Vendor.

    I would also use the Required Date on the PO to record when you expect to receive the material. Then you can filter the report by that as well.
  • 0
    Perhaps you should post a request on thereportstore.com for someone to make you a report. New site, but there are some great Sage 100 writers on there already.
  • 0 in reply to Helium
    Is there a report that will show both the vendor and the item number?
  • 0 in reply to GregoryScott
    Sorry, what I need is that I need is a report with the PO and the Item number. What I would dream of is a report that;

    Good
    PO# / Item number
    PO# / Item number
    PO# / Item number
    PO# / Item number

    PO# / Item number
    PO# / Item number
    PO# / Item number
    PO# / Item number


    Best case report
    Vendor Name
    Item number / PO #
    Item number / PO #
    Item number / PO #
    Item number / PO #

    Vendor Name
    Item number / PO #
    Item number / PO #
    Item number / PO #
    Item number / PO #
  • 0 in reply to Kevin M
    This is actually an area that I was also thinking about this week, regarding both short term work arounds and long term solutions. Some of the multi bin solutions out there actually have ways of marrying orders to stock and purchase orders. MAS already has a way to link orders POs to Sales Orders with auto generation tools, but that only applies for distributors who order from their vendors based on specific customer orders and not so much for distributors who carry stock for customers and want to allocate on hand and inbound stock to customer orders. Kevin's recommendation helps to get the data, but then we need some way to assign the goods to orders for promising. I have built some reports in Access to cross reference this and track what is still available to promise, but the multi-bin solutions are probably the best solution, and tweaking the Open Order Reports will help you track down the supply. I have used some UDFs to cross reference what inbound purchase order quantities are linked to particular sales orders and back orders. But the multi bin solutions do a better job of generating those pick tickets when the goods come in.