Sorry to revive this tread,
So, I've stopped waiting for Microvellum and a new version of Alis. I'm currently into a project of mine to create a custom shipping/backorder workbook in excel that uses extracted data from the job .mdb file.
- 1 spreadsheet will have all the products for the job listed with multiple columns showing if it got scanned, shipped, or is on backorder and the biggest feature yet... A date stamp showing when it got scanned. So from a quick look of this main spreadsheet, one can track a complete job very easily.
- another spreadsheet is getting setup to create shipping reports. This is where the shipper scans its products in and it will return some product details and again it will stamp the date scanned.
- I am not restricting the shipping reports to only scan products from 1 release at a time. the shipping reports spreadsheet will scan any product that is ready for shipment.
- There will be formulas tied in so the shipper can only scan the same product the amount of times listed in the qty. column in the .mdb file. Otherwise a warning will appear.
When I get a tried and tested complete workbook done, I'll try to post it in the downloads forum for others to benefit from.