We’re a webshop from the Netherlands looking for some assistance 😊
Current situation
We use a plugin that connects Business Central to our Magento webshop.
Through this integration:
Incoming Magento orders are automatically created as Sales Orders in BC
Product data is pushed from BC to Magento
We work with internal work orders that are printed and used for shipments from our own warehouse — these internal shipments are not linked to any Purchase Orders
Our sales → purchase → shipment → invoice process is automated as far as possible
We have many suppliers whose pricing and stock levels change daily.
All dropshipment items are routed to the cheapest supplier using two custom job queues:
Job Queue 1: Reads the Sales Order lines based on several filters (purchasing code, supplier name, purchase status) and places the items into the Requisition Worksheet.
Job Queue 2 :Checks stock availability and supplier pricing, and applies bundling rules (e.g., if price difference < €30, use one supplier; otherwise split the order).
Tracking automation
Daily, via Power Automate, we receive tracking information from our suppliers.
We match this to the relevant Purchase Orders and store the tracking data in custom fields. A second Power Automate flow pushes this tracking information to our webshop using Magento’s Shipment APIs.
The problem
Part of our products is shipped from our internal warehouse.
These items are shipped using work orders, not purchase orders. Just like the dropshipment flow, this internal process is automated using a job queue that prints the work orders, sends them to the warehouse, and posts the shipments to update inventory. Because these are internal movements, there is no Purchase Order record available where we can store or automate tracking information. This results in two separate logistics processes:
Dropshipments → linked to Purchase Orders (with tracking)
Internal shipments → work orders only (no place to store tracking info)
Goal / question
Is it possible to let internal warehouse shipments run through, or be based on, the Purchase Order table? It is important that these new “purchase orders”:
Do not interfere with our actual supplier purchases
Do not create double purchasing or financial postings.
In other words, can internally generated shipment lines be associated with a Purchase Order so that:
Our warehouse can act as a vendor
Tracking information can be stored in the same way as for external suppliers
Automation tools (like Power Automate) only need to monitor one unified set of tables for both external and internal shipments
I've also looked into warehouse warehouse shipments which i could add some custom fields to for our tracking information, but i can't seem to find the right job queues and get them to work. In this situation each sales order would need to have it's own warehouse shipment to write away the tracking information in a usefull manner.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
3,316
