Share
ReportGreetings All,
Like many businesses, the pandemic has caused many issues with our supply chain. With 18,000+ inventory items spread out over 200+ Vendors, we are constantly updating ETA's on product that is spread out across 100+ open Purchase Orders, and impacts 300+ open Sales Orders. Needless to say, we are searching for the most expedient way to update the "Expected Receipt Date" field on our PO's.
A suggestion to have our Partner add an editable "Expected Receipt Date" field in the Purchase Order List page was given consideration, but this would only work for PO's for a single inventory item, and a single ETA. Most PO's contain multiple line items and therefore, multiple ETA's.
We can produce a Purchase Order Status report that pulls the information that we need (Inventory/Items/.../Reports/Orders/Inventory Purchase Orders). This report can be filtered by Vendor and includes the inventory Item #, the Expected arrival date, and all of the PO's that contain that Item #, and we can open and edit that report in Excel, however, we are unsure if there is any way to upload the report (as an Excel file) to "push" the revised data back, perhaps similar to how we upload and apply data through Configuration Packages?
Does anyone know if this is possible? Is there an easier, softer way that I am unaware of?
Thanks to all!
Paul
All responses (
Answers (
159
