Creating Automated Data Import - Journal and Inventory
In a partucular scenario, my customer wants to be able to import pre-prepared excel files (in a way that SBO understands and accepts) into the sytem.
Additionally, they want either this import to trigger certain inventory deductions (or another batch of similar imports) to create inventory deductions.
The customer runs a trading business, where he sends inventory on a consignment basis. He therefore, will be receiveing all this data from his staff from separate (sale) sites.
My approach has so far been to show this by means of creating user friendly excel templates and using DTW to import all the data.
Is there a better way to do this ? Or, the other solution is to write a SDK solution to conduct on-click import operations ?
All ideas will be highly appreciated.