Hi,
In our project (DW10, SWIFT & NAV '13) we would like to update orderlines with the 'amount shipped'.
Flow:
1. Order placed on DW
2. Order created in NAV
3. Order partially shipped in NAV
4. Orderline in DW gets updated with 'amount shipped = X"
Possible methods
- Using custom order line fields
- Pro: easy to create and easier to render frontend
- Con: harder to make an integration due to different tables
- Using a custom table
- Pro: easier structur in DB
- Con: Not sure on how to define keys
Does anyone have any experience or good advice?