I've developed a custom web application (PHP/JS) for order picking purposes. We're running Accpac 5.6 and using PervasiveSQL 10.3. The gist of what happens is that we're using a barcode scanning device (LineaPro) to scan the order barcode. My software then reads that order from Accpac and places it into a separate MySQL database that has been tweaked for my purposes. No writes back to Accpac occur...all changes are just made to my own MySQL db.
Now for the issue...we frequently run into issues where we may not have inventory on the shelf (or at least in a high enough quantity that we want to rid ourselves of the shelf inventory since we're both wholesale and retail). My process now is that I allow the order picker to change the quantity pulled to 0 (or whatever number lesser than the actual amount ordered) and at the end of their order picking for that order I display a quantity change report showing all updates that must be made on Accpac.
The process then is for the order picker to open O/E on a real computer, open that order and then go through and edit the quantities for those items that had qty changed.
What I would REALLY like to do is to allow my program to just go ahead and make those qty changes in the Accpac database instead of requiring that extra time consuming step at the end. I've attempted this in the past but was met with an array of issues...mostly revolving around the apparent need to "re-post" the order after making changes. I realize that this should be possible to do by writing directly to the Accpac db, but it's obvious to me that Accpac is changing a great deal of tables when only qty has been changed. In my testing I changed qty, updated the total accordingly, etc but was still met with integrity issues and an obvious issue during day end.
Since my program is in PHP/JS and I'm using ODBC, I'm pretty much SOL on other ways of doing this.
I suppose my question is should I just give up hope for doing this in my application or is there a viable way to do this?
Now for the issue...we frequently run into issues where we may not have inventory on the shelf (or at least in a high enough quantity that we want to rid ourselves of the shelf inventory since we're both wholesale and retail). My process now is that I allow the order picker to change the quantity pulled to 0 (or whatever number lesser than the actual amount ordered) and at the end of their order picking for that order I display a quantity change report showing all updates that must be made on Accpac.
The process then is for the order picker to open O/E on a real computer, open that order and then go through and edit the quantities for those items that had qty changed.
What I would REALLY like to do is to allow my program to just go ahead and make those qty changes in the Accpac database instead of requiring that extra time consuming step at the end. I've attempted this in the past but was met with an array of issues...mostly revolving around the apparent need to "re-post" the order after making changes. I realize that this should be possible to do by writing directly to the Accpac db, but it's obvious to me that Accpac is changing a great deal of tables when only qty has been changed. In my testing I changed qty, updated the total accordingly, etc but was still met with integrity issues and an obvious issue during day end.
Since my program is in PHP/JS and I'm using ODBC, I'm pretty much SOL on other ways of doing this.
I suppose my question is should I just give up hope for doing this in my application or is there a viable way to do this?
![[ponder]](/data/assets/smilies/ponder.gif "[ponder] [ponder]")