Barcode Scanners and Microsoft Access Database
I was wondering if someone can just help me get an answer to the following scenario.
I want to be able to keep track of Completed Stock and Potentionally RAW Materials using a Bar Code Scanner and allowing that to input a location/item number into the current database.
I am currently in the process of moving the system from Access Database/Sage Line 50 to Microsoft Dynamics AX so the future vision is for the barcode scanners to some how talk to Dynamics.
So, I have an Access Database How Simple is it to modify it slightly so that I can add a Barcode next to Finished Stock... and how do I link it to know where it is in the warehouse or which site.
Or is it difficult and I should probably leave it to continue manually for now and approach this again when AX goes Live Properly in November.