Hi all,
for various reasons, some of our orders need to be shipped outside of Nav, through a web app that I'm developing. The app will have the SO number and various other details, and it will generate a shipping label and tracking number etc.
Once I have those are ready, how can I inform Nav that the order was shipped?
I've been digging through the various tables today and I see there are some changes to the Sales Header table and the Warehouse Request table. For the most part, I can make those changes manually via Web Services myself. But there's one column I can't seem to find an appropriate value for in the Sales Header table, column "Last Shipping No.". I'm not sure where to grab that number from.
I've been digging around looking for it, but in the back of my mind I'm concerned that Nav would normally make changes to other tables in the DB, and if I just manually update one or two but leave the rest unchanged, it could cause problems.
Is there some other/better way to tell Nav that an order has shipped?