~~~~~~~~ Revision 2.26 ~~~~~~~~ Bug fix for LogOn/LogOff Save current sales entries, was recalling last sale details for customer orders when Log off after each sale was active. Corrected. ~~~~~~~~ Revision 2.25 ~~~~~~~~ Checkout.mde - TEMP_Transaction_Details_User table added Log On / Log Off - Now Saves and recalls current users sales entries at log on / log off Data.mdb - tblProduct_Barcode - Field added - StockShiftQuantity Number Long Default = 1 Products Form - Barcodes Sub Form - New field added - StockShiftQuantity Products Form - Add New Barcode Form - New field added - StockShiftQuantity New feature - StockshiftQuantity - allows deduction of multiple items from stock when an item is sold. ~~~~~~~~ Revision 2.24 ~~~~~~~~ Data.mdb - tblProduct - Added Field - Stocklevel_AfterStocktake - Long integer default = 0 Stocktake form - Added - Save new stocklevels button added to reports menu, allowing the saving of current stocklevels following a stocktake and allowing reports to be run at a later date. Product form - History tab - Added - Stock Level Prior to last stocktake Product form - History tab - Added - Stock Level After last stocktake Product form - History tab - Added - Last Stocktake Date Sales screen - Customer lookuop - error if no account number for the customer - corrected ~~~~~~~~ Revision 2.23 ~~~~~~~~ Denomination buttons added to tender screen £5, £10, £20, £50. Setup screen drop down boxes added for the above Customer Account Statements - MSAccess date format error - corrected Products form - Clone Product - Category1 - error selecting category1 - corrected ~~~~~~~~ Revision 2.22 ~~~~~~~~ description on A4 invoives was being shortened to 30 chars - corrected ~~~~~~~~ Revision 2.21 ~~~~~~~~ Quantity discounts - were still being applied even when an item which was part of a qnt discount promotion had already had a discount or price change applied. Changed such that qnty discounts do not apply to item which have already been manually discounted or had a price change applied. BOGOF discounts - As above Multibuy discounts - As above Fixed Price discounts - As above ~~~~~~~~ Revision 2.20 ~~~~~~~~ PO Number added to Delivery option from tender form Delivery details form now recalls info entered at time of creating the order Delete buttons added to the Sales Customer Orders form Redscreen - No Tender allowed until redscreen cleared. Sales Tax Code Added to New Barcode Add New Product form ~~~~~~~~ Revision 2.19 ~~~~~~~~ Sales Screen - Now allows Customer Orders to be edited Customer Orders Screen - new button to print individual customer orders for Today's Pending and completed orders. Sales Tender screen - new option for printing as an A4 Order ~~~~~~~~ Revision 2.18 ~~~~~~~~ Z Printout - Added ZID Z Printout - A4 Report Option Added X Printout - A4 Report Option Added Data.mdb - tblZ - field added - Deposits double, fixed, 2 dec, default 0, Z - Total deposits figure now stored in tblZ, figure includes cash card, cheque etc. Z's form - added Deposits ~~~~~~~~ Revision 2.14 ~~~~~~~~ Database rebuilt ~~~~~~~~ Revision 2.12 ~~~~~~~~ Added - Process Orders from other branches Added - Create Orders for other Branches table chages to data.mdb... Added - tblBranches - InvoiceNumber Added - tblBranches - TransferPath Added - tblBranches - ImportPath Added - tblBranches - Transfer_Active Added - tblBranches - LastUpdateDate Added - tblBranches - LastUpdateFile Added - tblProduct - Aisle Added - tblProduct - Rack Added - tblProduct - SubRack Added - tblProduct - Bin Product Form - details tab - added fields - Aisle, Rack, SubRack, Bin Order.mdb - tblOrder_details - Update_Stauts field changed to 12 chars TEMP_Branch_Order table - Update_Status field changed to 12 chars TEMP_Branch_Order_Create table - Added TEMP_Branch_Order_Create table - Update_Status field changed to 12 chars View Update Status form - renamed View Export Status View Export Status form - Added - Order Details tab Send data to warehouse - Added - set Customer_Order_Details UpdateSent Flag to yes Send data to warehouse - Added - set Customer_Order_Payment UpdateSent Flag to yes Branch Details - Added - field - Import folder Branch Details - Added - button create Import Folder Branch Details - Added - field - Transfer folder Branch Details - Added - button create Transfer Folder Branch Details - Added - field - DialUp No / IP Address Branch Details - Added - field - Last Updated Branch Details - Added - field - Last Update File Make Branch Update File - Added - Branches tab - Allows selection of branches to receive export / update file. Make Branch Update File - Settings - export Orders set to default = Yes Import branch Data form - Added - Path to Import folder - now lists each branches import folders individually. Import branch Data form - Added - Branches Tab - for Viewing import folder path Menu Iten - Added - central - contains all Head Office features. form - Orders View - Added - Delete buttons Lost sale function - missing # in front of #Lostsale - corrected frmSales_Refund - Changed to include security frmProduct - Add new barcode - RRP was not being added - corrected. Invoices - Payment Terms now displayed in RED ~~~~~~~~ Revision 2.11 ~~~~~~~~ Categories added to Branch Update Export and Import routines. report - Sales Tax on Sales - Detailed... Error msg removed report - Sales Tax on Purchases - Detailed... Error msg removed Customer form - Delete button - warning added 'Delete this Customer's record Y or N Payment Method types - tblPayment_Method!payment_method changed to 10 characters ~~~~~~~~ Revision 2.10 ~~~~~~~~ Setup form - requery added after recalling settings Suppliers form - Products Tab - Stocklevel Locked for Non SuperUser's ~~~~~~~~ Revision 2.09 ~~~~~~~~~ Sysytem Security - Description of View by Category form changed to View - View by Category Users form - Add New User - End Date now created without the time stamp on the end. Sales form - time was not refreshing - corrected. Sales form - LogOff Timer enabled. Product form - Delete Product routine chaged. Product Form - Clone Product, changed, now saves record and moves to newly created clone product. also closes the clone product form after each clone. qryUpdate_Product - missing link to productcode qryUpdate_StockLevels - missing Link to productcode ~~~~~~~~ Revision 2.08 ~~~~~~~~~ Quickchange form now adds the item changed to the ticket printing screen. Product form - region1 field changed tab to move to region2 after update Product form - region2, region3, region4, region5, region6 - changed as above Product form - Stocklevel is locked for all Non SuperUsers. Sales Tax Number - changed to print the Sales Tax number provided on the Setup > Printing menu. ~~~~~~~~ Revision 2.07 ~~~~~~~~~ Change price of item - Permanaent - Network Error msg corrected. msg changed to ' Price Change not allowed' - if already marked as changed or discounted. ~~~~~~~~ Revision 2.06 ~~~~~~~~~ 'Reset All Total Sales figures' - option - added to maintenance list 'Copy Data from Server' routine changed such that update is not attempted if the network link is down. Also local tables are not deleted until after data.mdb has been successfully copied from the server.