Re: Fulfilment report generation /data extraction

Hi may I ask, what is the best way to extract data/generate a report related to deliveries and fulfilment from Sage 300.

For example – I would like to know what are the items that are delivered on a daily basis - other than physically combing through the individual POs and recording the deliveries, is there another way that I can extract this information? 

On a separate note- how can I tell whether this is a complete fulfilment of a purchase order ( i.e. in (a) PO ABC 1 = 1000pcs , and 1000 pcs were delivered , and in (b) PO ABC 1 = 1000pcs , and 300 pcs were delivered, balance of 700 to be fulfilled.

Thanks.

Jeffrey

Parents
  • 0

    Hi Jeffrey, 

    There is the P/O Pending Receipts Inquiry that allows you quick access to viewing Expected PO's by Item Number and or by Vendor Number.

    But the P/O Purchase Order Action Report gives you some of the information required.. There are also several other P/O Analytical Reports that will provide various statistic and transactional information.  I would start with those reports and see if any of them provide you the desired information.

    For your second question, the P/O Purchase Order Action Report can provide Complete/Incomplete Item Statuses.  I would check with that report. 

    Regards,

    DCrampton

  • 0 in reply to DCrampton

    Thanks for the advise and guidance - much appreciated.

Reply Children
No Data