I figured I would start this thread. This is to let others use the VBA/Flex code that you have created for your own company. I will start first.
You may do with this code as you wish. If you wish to only use parts of it, feel free. If you have any questions please let me know.
In this zip file you will find 4 text files (the code) & the screenset files. Just copy & paste the code into the appropirate screens. I recommend you do this on a backup-server first. The code will do the following:
OE
----
1) I had to create a special OE to PO process (couldn't use ES's) since we only wanted to automatically create POs if it was a "special" item (where the Qty to Ship < Qty Ordered) It will take into account any columns that have been moved around by the user. Without going into deep explanation (comments are in the code) it will take any special items and put them into a text file (I created a button for this on the screen called OEtoPO). Then once you open up the PO screen it will automatically fill in all the information and create a PO with those special items. Once you press the OEtoPO button it will ask you for a vendor for each special item. If you mistype the vendor name it will let you know. It's so that importation into the PO screen runs smoothly. It's best when you run this that you group all special items by vendor during OE because it creates a new release number for each new vendor.
2) In the OE screen if you change the ShipDate it will ask you if you want to change all the line items to that date. If yes, it will change the req_ship, requested & promise dates. We have this so our users don't have to manually go in & change dates on each line item. We have orders that are over 100 line items long.
3) It will grab the windows username and put this name in 'user_def_fld_1' field of the OE Header table. I also have a text_box on the OE Header screen that will then display which Inside Sales person placed the order. I use this also on my pick tickets & order acknowledgements to easily identify who placed the order.
PO
----
1) Code to import data from the text file that OE creates for special items.
2) When the Requested Date is changed on a line item it will ask you if you wish to change requested dates on all line items. Again you can alter this to anything you like.
Please be advised that you must create a DSN called AccesstoSQLHQ (if you change this you must change it in the code). This points to your SQL Server & to your default ES database. It's so that it has access to the SQL tables.
We have used these mods for 2 months and they seem to be working great for me.
If anyone else has code they would like to share please feel free to do so! Exact software charges $175 per hour for coding. I figure I might save someone some money by showing or giving ideas on how to accomplish some things in flex. All this code was done by myself. For them to do these mods they wanted approxmiately $10,000.
To download click this:
You may do with this code as you wish. If you wish to only use parts of it, feel free. If you have any questions please let me know.
In this zip file you will find 4 text files (the code) & the screenset files. Just copy & paste the code into the appropirate screens. I recommend you do this on a backup-server first. The code will do the following:
OE
----
1) I had to create a special OE to PO process (couldn't use ES's) since we only wanted to automatically create POs if it was a "special" item (where the Qty to Ship < Qty Ordered) It will take into account any columns that have been moved around by the user. Without going into deep explanation (comments are in the code) it will take any special items and put them into a text file (I created a button for this on the screen called OEtoPO). Then once you open up the PO screen it will automatically fill in all the information and create a PO with those special items. Once you press the OEtoPO button it will ask you for a vendor for each special item. If you mistype the vendor name it will let you know. It's so that importation into the PO screen runs smoothly. It's best when you run this that you group all special items by vendor during OE because it creates a new release number for each new vendor.
2) In the OE screen if you change the ShipDate it will ask you if you want to change all the line items to that date. If yes, it will change the req_ship, requested & promise dates. We have this so our users don't have to manually go in & change dates on each line item. We have orders that are over 100 line items long.
3) It will grab the windows username and put this name in 'user_def_fld_1' field of the OE Header table. I also have a text_box on the OE Header screen that will then display which Inside Sales person placed the order. I use this also on my pick tickets & order acknowledgements to easily identify who placed the order.
PO
----
1) Code to import data from the text file that OE creates for special items.
2) When the Requested Date is changed on a line item it will ask you if you wish to change requested dates on all line items. Again you can alter this to anything you like.
Please be advised that you must create a DSN called AccesstoSQLHQ (if you change this you must change it in the code). This points to your SQL Server & to your default ES database. It's so that it has access to the SQL tables.
We have used these mods for 2 months and they seem to be working great for me.
If anyone else has code they would like to share please feel free to do so! Exact software charges $175 per hour for coding. I figure I might save someone some money by showing or giving ideas on how to accomplish some things in flex. All this code was done by myself. For them to do these mods they wanted approxmiately $10,000.
To download click this: