Hello,
We are a printing company. We are planning on integrating D365 Business Central with our existing Job Production Software. Our "jobs" often have multiple products that we manufacture and ship (imagine a catalog with a "Retail" version and a "Wholesale" version. Or a magazine with different languages or a "Mail" and a "Non-mail" version (as demonstrated below). Each of those versions can have many shipping addresses (a specified amount (10,000) of a particular product (mail version) shipped to a particular location (particular post office in Arizona). I also need to calculate tax for individual shipments (using Avalara).
Again, our existing software handles all manufacturing and shipping. I want D365 to handle the invoicing and accounting functions.
Example:
- ABC Magazine
- Mail Version
- We ship 10,000 copies directly to a USPS facility in Arizona for mailing
- Each of these has a value of $.80 ea.
- Non-Mail Version
- We ship 500 copies to the publisher in Arizona for their reference and use.
- Each of these has a value of $.75 ea.
- We ship 5 copies to the parent company in Texas for their reference and use.
- Each of these has a value of $.77 ea.
This is the method I am trying to test:
- Use the API to create an "Item" with the basic information from each shipment on the job (again, using our existing software, not D365).
- In my example, 3 items would be created.
- Automatically create a Sales Order in Business Central.
- Each line of the Sales Order would reference one of the Items created as per the process described above.
- I am hoping that an integration with Avalara would calculate the tax for each Sales Order Line (each line could be shipped to a different taxing location - in this example, we are shipping to 2 different locations in Arizona and 1 in Texas).
- Post the Sales Order and create a single invoice for the customer.
Item Card might look like this (the No. field is a reference to our existing production system):
The Sales Order might look like this:
The problem is that each line of the sales order in Business Central needs to have its own shipping address. I don't know how to accomplish this since the Sales Order has the address information in the Header - not at the Line level.
I am also open to other ways of doing this if anyone has recommendations.
Thank you!
