Missing Link in Drop Shipments

We are currently running Sage 300 Premium 2022 Update 4.  Our current process to dropship parts directly to the customer is below:

1. A sales order is created and the ship via is selected as vendor drop ship

2. A purchase order is created and the SO# is listed in the Reference box, the drop ship boxed is selected but no information is added, the ship to address is entered in the ship to location on the PO.

3. Accounts payable receives the invoice from the vendor showing the ship to location going to a customer.  Verification is done and the part is received.

4. Accounts payable then has to email the shipping department that it is ok to invoice the customer for the sales order.

5. The shipping department then gets the cost of shipping adds it to the sales order and invoices the customer.

Is there a way in Sage 300 for accounts payable to not have to email shipping so he knows it is ok to invoice the customer?  It is too easy to forget to send an email and it would be great if Sage somehow automated that process.  Even if there is a report that could be run to show you drop orders that have been received in PO but not invoiced in OE.

  • 0

    Hello Mandy, 

    I supposed the only report would be the Invoice Action Report in Order Entry.  you can select by either order number or Shipment Number in Summary and Detail.

    Regards,

    David Crampton

  • 0

    Hi Mandy,

    I have done several automation/integration parts for my customers. I believe that the scenario you described can be automated from the point of the PO is created up to emailing the invoice to the customer, including validation in all steps, etc.

    I think you would need an ETL tool (I use Realisable IMAN) and a couple of optional fields.


    Cheers

    Eudes