Version 4.87 Release 3 - 29 August 2010 --------------------------------------- - Bug fixes - Receivables Statements - Fixed problem where the new Customer Order Number & Sales Order Number fields where not visible in the statement stationery layout designer. - Inventory - Fixed errors when creating documents using manual numbering. Bug introduced in v4.87 R1. - Purchase Orders - Fixed problem with vat status of document after creating a new order from another order. - Internal Notes - Compatibility: AcePOS v4.79, AcePOS Manager 4.79, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.87 Release 2 - 27 August 2010 --------------------------------------- - Bug fixes - Inventory - Goods Received & Returns to Suppliers - Fixed problem where document totals were incorrectly calculated for ADS users. Bug introduced in v4.87 R1. - Sales Orders & Quotations - Fixed 7057 error for ADS users when capturing new lines in documents. Bug introduced in v4.87 R1. - Internal Notes - Compatibility: AcePOS v4.79, AcePOS Manager 4.79, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.87 Release 1 - 24 August 2010 --------------------------------------- - Changes & Enhancements - General - Added functionality to apply filters to data grids directly in the search field. To apply a filter use the wildcard character % in the search text. eg. Entering %ABC% in the search field will apply a filter and search for the text 'ABC' anywhere in the selected column. - Receivables & Payables - Receivables Statements - Customer Order Number & Sales Order Number fields are now available in the statement stationery layout. - Transaction Listing Report - Added Receipt\Payment Advice number to report. Report can also be sorted by this field. - Inventory - Item Master - Height of the Department panel is now saved and restored. - Added new 'Views' button which allows you to choose between the following views : 'All Items', 'By Department', 'By Supplier' - Item Barcode field can now be displayed in the item grid and be searched upon. - All active price lists can now be displayed in the item grid. - New dedicated transaction tables - AceAcc no longer creates temporary batch tables for ADS or Multi-Store Module users when creating new inventory documents (Invoices, Credit Notes etc). AceAcc now uses a dedicated permanent table for each transaction type. Lines for a document is also not removed from these permanent tables when a document is posted. This results in the following benefits: - Fewer tables in a company, especially when alot of inventory documents are unposted. - Unposting & posting of documents is now a little faster. - Online ADS backups are now more reliable because there is no frequent creating & dropping of temporary batch tables. - Point Of Sale - Added a specific price list for POS Cash Sales, with the option of having a different vat status (including or excluding vat) for this price list from the inventory price lists. This option can be enabled in the "POS Setup | Cash Sales" section, by checking the "Use POS Price List" option and choosing the vat status for this price list. Once this option is checked the price list will become visible in the item master screen together with the standard inventory price lists. This feature is useful for busineses that have a wholesale division that quotes item prices to customers excluding of vat, and a retail shop with item prices displayed to customers including vat. - CSV Data Import - Added option "Inventory - Department Info Only" to import the department master from a CSV file. - Added option to link an item to a department during import. - Bug fixes - Data Dictionary - Fixed issue where tables GLCCHART & GLCCHARTFC was not added to the data dictionary during creation of client. - General Ledger Integration - Fixed issue with GL integration from the other modules (Receivables, Payable & Inventory) where GL transactions was not stamped with the user & date\time details. - Installation Sale - Fixed SQL error when running Statements for a range of accounts. - CSV Data Import - Fixed error in the “Receivables – All Information” option when including debtors balance in the import. - Customer Deliveries - Fixed issues with GL Integration when posting customer deliveries. - Lay-Byes - Fixed error when creating a new Lay-Bye account from the Inventory Lay-Bye document screen. - Verify Data - Fixed errors in Lay-Bye data verification. - Internal Notes - Compatibility: AcePOS v4.79, AcePOS Manager 4.79, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.86 Release 6 - 7 June 2010 ------------------------------------ - Changes & Enhancements - Inventory - Sales Orders, Invoices, GRN's - When creating the above documents based on another document you can now choose whether to link to the original document or just copy the original document without any linking. By copying without linking you will not be bound to the items or pricing from the original document. This feature can be disabled in the inventory - Bug fixes - Receivables, Payables - Fixed issue where batches with prior year transactions could be unposted. - Modify Allocations - Fixed issue where payment allocations was leaving the value of the Storeid field for new records as null. - Creating a new Company - Fixed Data dictionary error message when creating a company and copying GL Financial Category template only - General Ledger - Trial Balance Enquiry - Percentage difference value was invalid in previous versions. Needed to be multiplied by 100. - Pastel Trial Balance Import - Fixed problem where Journal import batch had vat enabled. - Receivables & Payables - Fixed error when trying to delete accounts when referential integrity was enabled. - Internal Notes - Compatibility: AcePOS v4.77, AcePOS Manager 4.77, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.86 Release 5 - 25 May 2010 ------------------------------------ - Changes & Enhancements - Inventory - Quotations - New option "Allow multiple sales orders to be created on a quotation" has been added to the module setup. When enabled will allow multiple sales orders to be created on a quotation. - Quotations & Sales Orders - When creating a new one from another Quotation or Sales Order, delivery dates are now also copied from the source document if the date is not in the past. - GRN Data Entry - GRN documents now always default to excluding vat for item prices. Should a GRN document that you are capturing is on the including vat basis then you must select this vat basis from the options menu. In a future release, we will allow the vat basis to be stored at a supplier level, so when a new GRN is created for a supplier the correct vat setting will automatically be selected for you. - When creating a new transaction document (eg. Invoice) from another document (eg. Quotation), AceAcc now copies item/line notes from the source document to the new document. - Re-Order Enquries - Added columns Supplier Code and Supplier Name to grid. - Receivables, Payables & General Ledger - Quick Batch posting to Ledger - Added option in module setup to control posting to Ledger after the data entry window is closed. Three options are available: Auto Post (default), Prompt User or Don't Post. - Receivables, Payables - Modify Payment Allocations - The "Allocate Amount" option now supports Inventory Credit Note transactions thus allowing you to specify a custom amount when allocating a credit note to an invoice, instead of allocating the full credit note amount. Using this feature a single credit note transactions could therefore be split and allocated to multiple invoices. - Added feature to specify user access rights for the various options in this screen (allocate, de-allocate, auto allocate etc) for multi-user editions. - General - Application Updater - Support for Release Numbers has been added to Application Updater. - Bug fixes - General Ledger - Bank Reconciliation Report - Fixed issue where Credit Card refund transactions appeared as a zero amount in the report resulting in the bank reconciliation report being out of balance. - Inventory - Quotations, Sales orders, Invoicing - Fixed issue where customers on price lists 4 to 10 were not coming through in data entry screens - GRN Data Entry - Fixed problem where AceAcc complained about incorrect line totals after capturing a new line in a GRN document with item prices including vat setting. - Return to Suppliers - Fixed SQL error msg when raising a new RTS on a GRN. - Re-Order Enquiries - Fixed error msg when raising a Purchase Order from the enquiry. - Internal Notes - Compatibility: AcePOS v4.77, AcePOS Manager 4.77, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.86 Release 4 - 23 April 2010 -------------------------------------- - Bug fixes - Creating a new company - Fixed error "The Data Dictionary path was invalid" which occurred when creating a new company under ALS. - Fixed error "??? is not a valid value for field 'DefaultTransInMethod'" which occurred sometimes when creating a new company. - Receivables Data Entry - Fixed issue where account name label could sometimes display the wrong account when a new transaction line was cancelled. - Financial Reporting - Implemented an interim workaround to the access violation & document corruption that occurs when saving a spreadsheet after printing to certain network printer drivers. When the a/v is raised during the spreadsheet save operation, ProAcc will now abort the save operation and not archive the document in the financial reporting table. ProAcc will also prompt the user to save any changes to the spreadsheet before printing a spreadsheet to prevent any data loss from any subsequent error that may occur. - Internal Notes - Compatibility: AcePOS v4.77, AcePOS Manager 4.77, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.86 Release 3 - 15 April 2010 -------------------------------------- - Bug fixes - Inventory - Item Edit Screen - Fixed issue with overlapping price fields when "Item Prices Include Vat" was configured in the module setup screen. - Fixed issue where inventory batches which were created using manual document numbering failed to post because the batch table could not be found. Problem introduced v4.86 Release 1. - General - Fixed issue where "Tools|Check Stationery Layout files" incorrectly reported the new layout files as needing upgrading. - Internal Notes - Compatibility: AcePOS v4.77, AcePOS Manager 4.77, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.86 Release 2 - 13 April 2010 -------------------------------------- - Changes & Enhancements - Financial Reporting - Implemented an interim workaround to the access violation & document corruption that occurs when saving a spreadsheet after printing to certain network printer drivers. When the a/v is raised during the spreadsheet save operation, AceAcc will now abort the save operation and not archive the document in the financial reporting table. AceAcc will also prompt the user to save any changes to the spreadsheet before printing a spreadsheet to prevent any data loss from any subsequent error that may occur. - Bug fixes - General Ledger - Year End & 13th Period Rollover - Fixed issue where GL batches for the 13th period was not changed to period 1 by the Year End Process. - Internal Notes - Compatibility: AcePOS v4.77, AcePOS Manager 4.77, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.86 Release 1 - 6 April 2010 ------------------------------------- - Changes & Enhancements - General Ledger - Year End - Support for 13th period transaction rollover to next year has now been added to the Express & Standard Editions. See v4.75 notes for more information on this feature. - Batch Menu - Added "Print Other Batch Info" option to "Print Batch Report Options" window. This option will include or exclude batch creation and modification details in the batch report. - Receivables & Payables - Payment Types & Statuses - Added an IsActive flag to these masters which will allow you to control which payment types & statuses are active and available to users. - Sales Reps - Added an IsActive flag to this master which will allow you to control which Sales Reps are active in the business. - Payments & PDC's & GL integration - Payments can no longer be captured for dates that are prior to the current GL financial year. 13th period transactions rollover is now available in ALL editions and this feature allows you to postpone the year end until all AR/AP payments have been captured, so there is no longer a need any longer to capture AR/AP payments into prior years. - AceAcc now warns the user if a payment date is in the future for all payment types (eg. Cash, EFT) except post dated cheques which is higlighted in bold in the transaction grid. The payment date for all payment types (except post dated cheques) however must be within the current GL financial year. Post dated cheque payments is the only payment type that is allowed to go beyond the current GL financial year. The date for these PDC transactons in the GL will appear as the last date of the financial or rollover period. - You can now have post dated cheque payments posted to an "unpresented payments" control account instead of to the "cheque" payment type bank account. This new feature can be enabled in the GL integration tab of the module setup section. The default accounts setup for this feature is 563 for Accounts Receivable and 605 for Accounts Payables. By posting "unpresented payments" to this control account and thereafter posting deposits of post dates cheques directly to this control account when they become due, you will get a more accurate reflection in the Trial Balance report as to the value of your Bank, AR & AP control accounts and also the value of posted dated cheques that you currently have on hand. - Active flag - An active flag has been introduced in the AR/AP master screen. Flagging an AR account as inactive for example will now prevent invoices, sales orders etc from being placed on the customer account. Payment and journal transactions are still permitted on an inactive account. - Payment batches & Open Item allocations - AceAcc can now properly detect and handle over allocations to a transaction. This occurs when there are two or more payment transactions in a batch allocated to the same invoice resulting in an over allocation or over payment. Under ADS, AceAcc will report the problem and the transaction will be rolled back and the batch will be unposted. Under the local server, AceAcc will report the problem but is unable to rolled back. The batch will be posted, but the payment allocations will not be done. - Inventory - Departments - Added an IsActive flag to the Department masters which will allow you to control which Departments are active in the business. When making a Group, Sub-Group, Department inactive or active you will also be prompted whether you want to make its children inactive or active. - Specials - Added an IsActive flag to the Specials masters which will allow you to quickly deactivate a special or an item within a special. - Item Price Lists - Number of price lists have been increased to 5 price lists for the Professional edition and 10 price lists for the Enterprise edition. Lower editions are still limited to a maximium of 3 price lists. Price lists under all editions can now also be flagged as inactive. An inactive price list cannot be allocated to a customer and will also be hidden by default in the item master edit screen. - Supplier Item code - Support has been added for capturing a "Supplier Item Code" in the item master. - Orders & GRN's can now be captured using the supplier item code when the Payables account flag "Order / GRN Inventory using Supplier Item Code" is ticked in the Payables master screen. - Added "Supplier Item Code" field to various enquiry screens & stationery layouts. - Module Setup - The option "Don't post to Receivables Ledger if invoice fully paid & for Cash Sale Account" has been removed. The reason being that by not posting the transaction to the Receivable Ledger, will result in reports based on the Receivable Ledger is inaccurate. - ADS Online Backups - Fixed issue where certain batch operations failed (eg. editing/posting/unposting of a batch) and returned an error when an ADS online backup was in progress. Previously AceAcc relied on exclusive access to the main batch or transaction table to perform these operations. If the table concerned was being backed up by ADS, AceAcc would not be able to obtain exclusive access to the table and thus returned an error message to the user. This problem was momentory, and the operation could thereafter be attempted by the user a few seconds later and would then work. To resolve this problem, AceAcc has been changed to no longer attempt to obtain exclusive access to a batch or transaction table for routine functions like editing, posting, unposting of batches. Instead the tables are opened in shared mode, thus allowing ADS to perform the backup and a user to work on the table simultaneously. However, certain critical operations (eg. Year End, Transaction Purge, Verification of GL data) still require exclusive access to certain tables. When these operations are performed it is therefore recommend that you disable ADS online backups for the duration of the procedure. - Bug Fixes - General Backups - Fixed issue where AceAcc only recorded the date (not time) a backup was last done for a company. The time portion was always displayed as 12:00am. This has been resolved and both the date & time will now be recorded for all future backups. - Multi-User Editions & Remote Company - Fixed issue where user was not logged off correctly from local or remote site when AceAcc detected version differences between the company data and the current executing version of AceAcc and the user declined to open the company. - Colour & Sizes Modules - Fixed "VatPurch" field error when trying to create a new inventory document. - Inventory Module - Fixed issue where inventory documents failed to post due to update SQL syntax problem in the GL Integration. Issue introduced in v4.84. - Fixed issue where POS Cash up records where not removed when using the Purge Transactions utility. - Licensing - Fixed issue where feature to remove computers from licensing showed an empty list of computers. - Internal Notes - Compatibility: AcePOS v4.77, AcePOS Manager 4.77, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.85 Release 2 - 28 January 2010 ---------------------------------------- - Bug fixes - Fixed issue where Purchase Order or GRN document failed to post due to AceAcc complaining of incorrect document totals. Issue introduced in v4.85. - Fixed non-standard behaviour in Credit Notes data entry screen where customer list auto drop down appeared when typing in the customer account code. - Internal Notes - Compatibility: AcePOS v4.75, AcePOS Manager 4.75, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.85 - 17 January 2010 ------------------------------ - Changes & Enhancements - Receivables or Payables Payment batches - The GL "Presented" status for payment transactions (used by the Bank Reconciliation section) is now saved when a payments batch is unposted and reposted. Bank Reconciliations will no longer have to be redone for payment transactions after a batch has been unposted and reposted now. - Added "GL Presented status" flag to payment types master. When this flag is set than any payment transaction that uses the selected payment type will automatically have its presented flag set when posted to GL. This flag has been set for the 'EFT' payment type and will therefore reduce the time take to do bank reconciliations. - Inventory - Inventory document totals can become invalid in the event of a system or power failure whilst a user was editing an inventory document. Document totals are now therefore validated by AceAcc before the inventory transaction is posted. If AceAcc detects that any total is invalid, it prevents the user from posting the transaction and prompts them to re-open the document in the data entry window. This will result in AceAcc correctng the invalid total. - Bug fixes - Fixed issue where inventory documents failed to post due to SQL syntax problem in the GL Integration. Issue introduced in v4.84. - Internal Notes - Compatibility: AcePOS v4.74, AcePOS Manager 4.74, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.84 - 30 December 2009 ------------------------------- - Bug fixes - Fixed issues with Inventory module GL integration that caused the GL/TB to not balance under the following circumstances: - the inventory document that was being posted had a discount applied to it at the document total level. - all the lines in an inventory document had a custom GL account assigned to it at the department level. When AceAcc detects a rounding issue (up to 3c) the problem will be resolved by automatically posting a “rounding difference journal” to the GL, to ensure that the GL/TB always balances. - Internal Notes - Compatibility: AcePOS v4.74, AcePOS Manager 4.74, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.83 - 9 November 2009 ------------------------------ - Changes & Enhancements - Inventory - Transactions Report - Added option to filter by customer or supplier account. - Improved speed of report generation. Report generation is up to 20 times faster for remote users. - Inventory Documents - Added Volume & Weight Totals to data entry screens and stationery layouts of Quotation, Credit Note, Purchase Order, Goods Received & Returns to Suppliers. Totals are available at a line and document total. - Inventory Departments & Adjustments - Added option to Department master (on Professional Edition or higher) to specify a custom GL account to post stock adjustments to for a specific department - Added option (on Standard Edition or higher) to prompt for a custom GL account when capturing new stock adjustments. - General Ledger - Journals Data Entry - Changed new option 'Prompt for Contra Account' added v4.81 to work only after inserting a new journal transaction and not after modifing an existing transaction. - Bug fixes - Inventory GRN integration with GL - Fixed problem with a rounding issue when posting to custom GL accounts for a department when a company is setup as non registered for vat. This problem would result in the Trial Balance being out of balance by 1 cent. - Inventory documents - Fixed possible rounding issues across inventory documents when posting to custom GL accounts for a department. - Payables Account Setup - Fixed issue on Standard Edition were custom GL expenditure account would sometimes get lost when modifying a Payables account. - Internal Notes - Compatibility: AcePOS v4.72, AcePOS Manager 4.72, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.82 - 13 October 2009 ------------------------------ - Changes & Enhancements - Receivables, Payables - Increased length of email address field from 30 to 100 characters. - Transactions listing report - Added "User" column which is the user that created/posted the transaction. - Modify Payment Allocations - Added new option "Allocate Amount" which allows you to specify a custom amount when allocating a payment or journal credit to an invoice, instead of allocating the full payment or journal amount. - Price Matrix - Line discounts or docket discounts are now ignored when saving unit pricing to the price matrix for a customer. - General Ledger: Journal Data Entry - Auto Incrementing Reference field - Added new right click option 'Increment only on new Journal Group' to the Reference field heading. This option allows one to turn off the incrementing of the reference number only when a new journal group is started which was introduced in v4.81. When this option is off, the reference number will be incremented on every new journal transaction. - Vat Report - Added option to display the Supplier Invoice Number for GRN transactions in the "Ref" column, instead of the GRN document number. - Bug fixes - Receivables, Payables - Journals - Fixed bug where custom vat amounts where removed on a journal credit transaction after an allocation was done for the transaction whilse in the Journals data entry screen. - Transactions Listing & Allocation Report - Fixed issue where batch ref number was invalid when "Print Batch Details" was enabled. - Internal Notes - Compatibility: AcePOS v4.71, AcePOS Manager 4.71, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.81 - 30 August 2009 ----------------------------- - Changes & Enhancements - Receivables & Payables - Journal Data Entry - Added button "GL Account" which allows one to specify a custom GL account to post the transaction to in the General Ledger, instead of the standard sales/purchases account. This can be used for example, in the case of bad debts written off to specify the GL account 218 to post the transaction to. - General Ledger - Vat - Added support for Vat types "Z"ero rated and "E"xempt in data entry screens and Vat report. - Journals Data Entry - Added new option 'Prompt for Contra Account' in data entry screen. When ticking this option, and the initial journal transaction has been captured, Ace Accounting will prompt you for a contra account and repeat the same journal transaction in the batch to the selected account with a contra amount. This is essentially a time saving feature that helps to reduce the repetitive nature of journal capturing. The last contra account chosen is also remembered and pre-selected for future contra journals, thus saving further keystrokes when capturing a set of journals for the same contra account. - Auto Incrementing Reference field - When the auto incrementing of the reference field is enabled, Ace Accounting is now smarter in deciding when a new journal group is starting and only increments the reference field when it detects this. - Amount field - When capturing journals, Ace Accounting now attempts to predict the amount of the next journal transaction by using the accumulative total of the debit & credit transactions. - General - Added "View|Customise Toolbar" option. - Bug fixes - General - Fixed the following Windows Vista issues when UAC was enabled - Unable to print or display Receivables Statements. - Error message "Unable to write to RBuilder.ini" displayed when selecting "Tools|Stationery Layout Designer" - Fixed issue where right click menu on toolbar was not displayed because toolbars were docked on the pulldown menu dockbar. - Internal Notes - Compatibility: AcePos v4.71, AcePOS Manager 4.71, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.80 - 3 August 2009 ---------------------------- - Changes & Enhancements - Payment Basis Vat Category - Improved support for the above vat category. Vat on Inventory transactions (Invoices, Credit Notes, GRN, RTS) are no longer posted to the Vat Output/ Input accounts in the General Ledger. In prior versions the vat integration between the Inventory and GL Module was incorrect, and integrated was done under the Invoice Basis, even though the Vat Category was defined as Payment Basis. This has now been corrected. - Added support for the Payment basis in the Vat Report. - Inventory - Re-Order Enquiries - Added "Include items with no re-order quantity" checkbox which will display items with zero re-order qty but with insufficient stock levels to meet customer orders etc. - When creating purchase orders automatically, order quantities are now raised for the standard re-order qty amount and quantities required for any outstanding customer orders. - Advantage Database Server - ADS clients are now configured to communicate with ADS via TCP/IP by default instead of UDP. (see ads.ini configuration file) - Bug fixes - Vat Report - Fixed issue where vat on Accounts Receivables\Payables Journal Credits did not appear under the correct vat report category. AceAcc will now also detect incorrect vat type (input or output) specified for journal transactions and advise the user on the correct vat type to use. - Fixed issue where vat on Accounts Receivables\Payables payment discounts did not appear under the correct vat report category. - Receivables Statements & Detailed Age Analysis - Fixed issue where account which had no transactions (except for an opening balance) for the specified period was not included in the report. - Inventory - Fixed issue where user could post an inventory document upon exit of the document even though the user was not granted the access right. - Re-Order Enquiries - Fixed issue where purchase orders that were raised did not include item description and amounts. - Fixed access violation error when selecting all records and raising a purchase order. - Fixed issue with drill down into sales and purchase orders not working. - Manufacturing - Fixed issue where stock qty was allowed to go negative when posting a manufacturing batch even though "Allow Negative Inventory Quantities" was disabled in the module setup. - Internal Notes - Compatibility: AcePos v4.71, AcePOS Manager 4.71, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.79 - 5 July 2009 -------------------------- - Changes & Enhancements - Remote Companies - Improved speed of logging into remote companies by reducing the time taken to obtain a user's access rights. - Most reports now uses aggressive caching which will speed up reporting by 20% to 60%. - Inventory - Item Sales Report - Added new Group Limit option which allows you to limit the number of records displayed per group. A limit of 0 displays all records. - Added Qty to "Sort by" option. - Added new "Sort order" option which allows to choose between ascending or descending sorting. This allows you to determine slow or fast selling items. - New Item Purchases Report - This new report allows to you analyse item purchases by department, supplier etc for a specific period. Report data can also be sorted by qty or cost value. - Inventory Count Report - Added option to display system qty or not on report. - Bug fixes - Inventory & GL Integration - Fixed issue related to doubling of vat in the Stock Account for GRN's that were posted to the GL. The issue occurred when custom GL accounts where specified at a department level and a company was defined as "Not Registered" for vat. - Fixed issue with vat entries being posted to the Vat Output acount for Returns to Supplier transactions, even though a company was defined as "Not Registered" for vat. - Internal Notes - Compatibility: AcePos v4.71, AcePOS Manager 4.71, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.78 - 18 June 2009 --------------------------- - Changes & Enhancements - Improved Vat Report that now makes completion of SARS Vat Return extremely simple! - The Vat Report now contains a summary of the output & input tax categories on the 1st page followed by the actual transactions in the subsequent pages. - The initial Vat Report Summary page is similar in layout and content to the actual SARS vat return, thus by just refering to this Vat Summary page alone one will be able to complete the SARS vat return with little effort, without requiring any assistance from your accountant etc. - The Vat Report now also includes totals & transaction details for the following: - Zero Rates Sales - Exempt Sales - Adjustments (Credit Note Issued & Received) - Removed dependancy of vat report being available only when a company has the GL module enabled. AceAcc will now generate the vat report using info obtained from the actual transaction tables from each module, in the event of the GL module not being enabled in a company. - Bug fixes - Inventory Items - Fixed issue where item price field was disabled when "Sell Vat Status" was Exempt or Zero Rated and the module setup was configured for item prices being captured inclusive of vat. - Colours & Sizes - Fixed issues with prices excl vat not being restored correctly in the item edit screen when the module setup was configured for item prices being captured inclusive of vat. - Internal Notes - Compatibility: AcePos v4.68, AcePOS Manager 4.65, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.77 R2 - 13 May 2009 ----------------------------- - Bug fixes - Fixed "invalid field LoyaltyValue" error in stored procs used for calculating AR/AP aging balances. Version 4.77 - 6 May 2009 ------------------------- - Changes & Enhancements - General - Added support for restoring Advantage Database Server Online backups that were created via ADS Task Scheduler v1.41 or later. - Added support for AceAcc.ini configuration to be stored in the windows user specific application data folder when a user does not have administrator privileges. - General Ledger - Batches: Vat on transactions - "Vat on transactions" can no longer be enabled for a batch if "Vat Processing" is not enabled in the GL Module Setup section. - Receivables\Payables - Data Entry - Implemented "Skip Payment Type" & "Skip Vat" options. Right click on column headings to enable/disable these features. - Detailed Age Analysis Report - Added new report option "New Page per Account". - Point Of Sale - Added support for Credit Cards in Credit Sale transactions. - Added support for accepting Voucher payments in Cash & Credit Sales. The voucher payment type has also been added to all POS stationery layouts, enquiry screens & reports. A custom GL account can also be specified for Voucher payments in the POS setup section. - Added support for viewing item/line notes (in enquiry screens) and stationery layouts, which can now be captured for docket lines in Ace POS Standard Edition (or higher). - Customer Loyalty (New Module!) - This new module allows you to specify loyalty points against items which customers who are enabled as a "loyalty customer" can accumulated points when purchasing these items. Loyalty points are currently earned against invoicing of the items in Ace Accounting or Ace POS, and reduced in the case of Credit notes or POS returns. Ace Accounting keeps a history and balance of all loyalty points earned against transactions which can be viewed in the Receivables Enquiry section. - Improved support for Businesses that are NOT registered for Vat. - New Vat Category "Not Registered" has been added to the "Setup|Company Information|Modules && Accounting" section to support these unregistered businesses. - Items now support a "Sell Vat Status" and a "Purchase Vat Status", so these unregistered businesses can setup the "Sell Vat Status" as Exempt and "Purchase Vat Status" of Vatable in the case where purchases are being made from a Vat Vendor. - GRN's from Vat Invoices received from suppliers can now be captured with prices excluding Vat. AceAcc will automatically calculate the vat on the items and include them in the cost price when calculating the new average cost for the item. No vat transactions will appear in the General Ledger. - Remote Company - Added support for obtaining the remote site’s IP Address from a web page before connecting to the site. This feature can be used when the remote site is hosted on a dynamic IP address. - Bug fixes - Receivables Batch Listing - Fixed bug where Vat column was empty even though the batch was enabled for vat. - Conversion to v4.72 - Accounts Payable - Fixed bug where the custom GL expenditure account for an AP account was changed to "use account specified in the module setup". - Fixed bug where the customer GL account field was not visible even though a custom account was specified. - CSV Import Wizard - Fixed order of fields displayed in import mapping grid. - Internal Notes - Compatibility: AcePos v4.68, AcePOS Manager 4.65, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.76 - 8 March 2009 --------------------------- - Changes & Enhancements - Financial Reporting - Added option "Financial|Advanced|Consolidate Sub-Accounts" in the spreadsheet. When enabled this option will consolidate sub-account balances with their parent account, and sub-accounts will no longer be directly accessible in the financial report. - Bug fixes - Remote Companies - Fixed error message 'Unknown Remote Application Type' that would occur when attempting to open a ProAcc client remotely. - General Ledger - GL Account modification - Fix bug where error msg "Cannot create new bank account" was displayed for Professional (or lesser) edition when modifying a GL account. - Sales Commission Report - Fixed 7008 error when running the report remotely through the Internet Server. - Inventory Item Sales Report - Fixed SQL error when filtering by item or department code when the POS module was enabled. - Internal Notes - Compatibility: AcePos v4.68, AcePOS Manager 4.65, ProAcc v4.31, ADS v9.10 - Requires: D2007 v1.06 Version 4.75 - 4 February 2009 ------------------------------ - Changes & Enhancements - General Ledger - New 13th period rollover to next year feature added to GL, Professional & Enterprise Editions - Added support for the transactions of the 13th period to be carried forward to the 1st period of the next financial year during the year end process. This feature is useful when you do not have all transactions as yet captured into your company and you need to start a new financial year. To enable this feature : a) Go to "Setup | Company Information | Modules & Accounting" section. b) Change your periods from 12 to 13 and tick the "Rollover period 13 to next year at year end." Leave your financial year dates the same. (eg. 01-03-2008 to 28-02-2009). c) For period 13 enter the date 31-03-2009. (You basically now have 30 days to capture your outstanding Feb 2009 transactions) d) Click OK to save. e) Continue you day to day transaction processing for March 2009 now. Once you have captured all outstanding transactions for Feb 2009, do the year end process as normal. Ace Accounting will automatically convert period 13 transactions to period 1 transactions of the new financial year. - Bug fixes - General Ledger - Year End - Fixed issue where year end process would fail to remove AR/AP posted batches and reported a table open error, when a companies data had referential integrity enabled. - Fixed issue where unposted GL batch tables were deleted but not removed from the data dictionary. - POS Setup - Fixed "Cannot focus a disabled window ..." error message that would occur when saving the POS setup and the company path field was blank and ONLINE mode selected. - Internal Notes - Compatibility: AcePos v4.68, AcePOS Manager 4.65, ProAcc v4.30, ADS v9.10 - Requires: D2007 v1.06 Version 4.74 - 18 January 2009 ------------------------------ - Changes & Enhancements - Inventory Documents - When creating inventory documents (quotations, invoices, GRN's etc) for individuals, the name on the document now includes the title and first name fields. Previously only the surname with appear as the name. - Open Remote Company - Added feature to create a new remote company setup by copying an existing one. - General - Update ARTHost support tool to version 1.15 - Bug fixes - Inventory - Fixed bug where inactive items where still displayed in dropdown lists. - Fixed bug where service items where not allowed to go into negative qty balance when the module option "Allow Negative Inventory Quantities" was disabled. - Receivables / Payables - Enquiries - Fixed incorrect opening/closing balances in Analysis tab introduced in v4.73 - Payments Allocations - Fixed SQL error when "Show Additional Transaction Info" was enabled and the company did not have the inventory module enabled. - Inventory Enquiries - Fixed incorrect opening/closing balances in Analysis tab introduced in v4.73 - Internal Notes - Compatibility: AcePos v4.67, ProAcc v4.06 or later, ADS v9.10 - Requires: D2007 v1.06 Version 4.73 - 05 December 2008 ------------------------------- - Changes & Enhancements - Improved performance of inserting new records in database tables. Depending on the number transactions in batches, remote users could potentially see up to a 50% improvement in speed when posting large batches. - General Ledger - Trial Balance Enquiries - "All Years" enquiries now display the financial year end date in the column heading captions instead of Current Year, Last Year 1, Last Year 2 etc. - "All Periods" enquiries now display the period end date in the column heading captions instead of Period 1, Period 2, Period 3 etc. - Period Comparatives Report - Report now display the period end date in the column heading captions instead of 1, 2, 3 etc. - Financial categories - Abbreviations for financial categories are now mandatory. - "Redo Year End" feature now checks that all financial categories have an abbrevation defined before redoing the year end. - Financial Reporting - When loading a financial reporting, AceAcc now displays a warning to the user if it detects that a financial category has no abbrevation defined. - Point Of Sale - Added new configuration options in setup section - Line deletions in a docket requires supervisor password - Transaction cancellations requires supervisor password - Licensing - Added feature to select computers from a grid when removing authorised computers from license (trigger code 43). - General - Update ARTHost support tool to version 1.14 - Bug fixes - Receivables / Payables - Fixed issue with Journal credit transactions not having the correct sign (a negative value) in the Transaction listing report. - Fixed conversion error (missing table apptype) to v4.72 - Internal Notes - Compatibility: ProAcc v4.06 or later, ADS v9.10 - Requires: D2007 v1.06 Version 4.72 - 25 September 2008 -------------------------------- - Changes & Enhancements - General - Due to a new version being used for the backup compression library, the install for this version must be run on all pc's. - Upgraded Remote Support software. - Receivables - Added new "GL Integration" tab in the Receivables account setup screen for the Enterprise Edition. In this tab you can specify the Income & AR control accounts to use for the customer when posting transactions to the General Ledger. - Payables - The GL integration options has been moved to a seperate "GL Integration" tab. A new option has also been added for the Enterprise Edition to specify the AP control account to use for the creditor when posting transactions to the General Ledger. - Receivables & Payables - Vat on Discounts - Vat on discounts are now calculated and post to the GL for companies that are on the invoice basis for vat. - Quick Payments - Added feature to enter a discount in the quick payment screen. By default, this feature is disabled and can be activated in the module setup section. - Payment Manager - Transactions with had no payment type defined during data capture are now displayed in the payment manager screen so that the payment type can be setup for the transaction. - Added unique index to ledger table to trap and prevent duplicate transactions. - General Ledger - Transaction Enquiries - Added financial category columns. Transactions can therefore now be grouped and analysed by financial category in this screen. - Multi-Store Modules - Added "Inter-Branch Transfer" feature with capability to track in-transit stock. - Added feature to specify user access rights to stores at a location and inventory document level. - General tweaks and enhancements to Ace Accounting to support multi-store capabilities. - Data Dictionary - Tweaks and enhancements have been added to "Referential Integrity" option with better error reporting when enabling referential integrity on a companies data files. - Bug fixes - Inventory - Fixed error when creating items when referential integrity was enabled in the data dictionary. - Fixed problem where RTS documents could not be unposted. - General Ledger - Chart Of Accounts Transfer - Fixed problem with transferring a chart of accounts from a data dictionary enabled company to a drive or path and then re-importing it as a template. - General - Fixed problem with 'Check for Updates' feature not working because new updates where checked for on microace.co.za instead of aceacc.co.za. - Emailing of reports - Changed temporary path used for generating email attachments from root directory to windows temporary directory for Windows Vista UAC compatibility. - Verify Data - Fixed sql error when verifying company data with POS module enabled. - Internal Notes - Requires D2007 v1.05 Version 4.71 - 29 July 2008 --------------------------- - Changes & Enhancements - General - Users can now invoke the dropdown calculator for numeric fields by pressing +, -, / or *. - Receivables & Payables - Removed limitation of only 9 payment types. Further payment types can now be added using alphabets as codes. - Added feature to allow negative amounts for transactions in a payment batch. This type of transaction can be used for refunds to customers or from suppliers. Stationery layouts have also beeen updated so that receipts printed for these type of payment transactions will automatically use "refund" wording. - Enquiries - Added new column 'Batch Ref'. Which provides the associated batch reference from which the transaction originated from. - Added option in "Setup|Module Setup|GL Integration" to post AR/AP transaction notes as the GL transaction notes. This option is ON by default. - GL Account description is now displayed for custom GL accounts specified in Payables invoice & journal batches. - General Ledger - Integration from other modules - Changed the GL integration so that in the case when a transaction has a zero value it will not get posted to the General Ledger. - Edit Ledger Transactions - Added new column 'Batch Ref'. Which provides the associated batch reference from which the transaction originated from. - Reports - Excel Export - Improved export of numbers in reports so that they are seen by Excel as a numeric value instead of text. - Verify Company Data - Added feature to detect and correct duplicate GL batch filenames which occurred as a result of the GL import batch process allowing mixed case batch filenames. - Data Dictionary - Added new "Tools|Data Dictionary|Referential Integrity" submenu to enable referential integrity in a companies data. Referential integrity is a database constraint that ensures that references between data are indeed valid and intact. Referential integrity is a fundamental principle of database theory and arises from the notion that a database should not only store data, but should actively seek to ensure its quality. For referential integrity to hold, any field in a table that is declared a foreign key can contain only values from a parent table's primary key field. For example, customer account numbers in a customer file are the primary keys, and customer account numbers in the order file are the foreign keys. If a customer record is deleted, the order records must also be deleted, otherwise they are left without a primary reference. By enabling referential integrity, the database engine also tests for this data validity, besides the normal checks that have been built into an application. Therefore the main benefit of enabling referential integrity is improved data quality in the database. There can still be errors, but at least data references are genuine and intact. - Bug fixes - Financial Reporting - Fixed problems with converting forumlas from one accounting function to another. There were certain cases where the converted formula contained invalid functions return the error "#NAME?". - General Ledger - Financial Categories - Fixed "List index out Bounds" error when searching for a financial category. - Receivables & Payables Enquiries - Fixed problem where transaction notes were not visible in the grid, even though notes were captured against the transactions. - Payables - Fixed problem where when clicking on "Setup|Payment Types" one was taken to the Receivables Payment Types instead of the Payables types. - Licensing - Fixed error "LF could not be closed - Error #17" that would sometimes popup after licensing. - Internal Notes - Requires D2007 v1.04 R2 Version 4.70 - 14 July 2008 --------------------------- - Changes & Enhancements - General Ledger - Transaction Enquiries - Added new column 'Batch Ref'. Which provides the associated batch reference from which the transaction originated from. - Added new column 'Amount Excl Vat'. - Trial Balance Enquiries - Added totals to amount columns in the group footer. - Add new "Setup|Module Setup" option which allows you to "Enable Vat Processing" for the GL Module. - Licensing - Added licensing configuration option #13. - Bug fixes - Payables GL Integration - Fixed problem with GL Integration where the correct default GL account was not focused when prompting the user for a GL account during data entry. - Fixed problem with GL Integration with vatable journal transactions which lead to the GL & TB going out of balance. Bug introduced in v4.69. - General Ledger - Trial Balance - Fixed problem where inactive master accounts where not displayed for active sub-accounts. - Fixed problem when consolidating sub-accounts where the master account was displayed with a sub-account name. - Trial Balance Enquiries - Fixed 'Itemindex out of range' error when drilling down balances for the period view. - Inventory - Sales\Item Sales\Customer Sales Reports - Fixed inaccurate profit percentage totals. - Remote Access - Fixed problem where network user rights for a remote site was not saved after modification. - Internal Notes - Requires D2007 v1.04 R2 Version 4.69 - 3 July 2008 -------------------------- - Changes & Enhancements - Installment Sale - Periods Master - Added option to quickly create installment sale periods. - Statements - Added check for unallocated credit transactions before processing Installment sale statements. - Added Network user rights for installment sale options. - Added "Utilities|Purge transactions" feature. - General Ledger - General Ledger Report - New option "Print transaction amounts excluding vat" has been added to "Setup|Preferences|Ledger Reports" section. By default this option is off When this option is enabled transaction amounts in the debit/credit columns are displayed excluding of vat. - Trial Balance Report & Enquiries - Added option to consolidate sub-accounts in the trial balance. When this option is enabled sub-accounts for an account are not displayed and their totals are accumulated with the main account's total. - Inactive master accounts are no shown when there are active sub-accounts in the Trial balance Enquiries - Batch Duplication tool - Added options to change the description, period and opening balance of a duplicated batch. - Receivables, Payables - Open Item Allocations - Added support for detecting invalid payment allocation amounts & discounts in the allocations window or when posting a payments batch. - Modify Allocations window - Added tab "All Unallocated transactions". This section shows all unallocated transactions. Double clicking on a transaction quickly takes you to the transaction in the "Modify Account Allocations" section and automatically selects it for allocation. - When a payment (or credit transaction) is allocated to an invoice of a lesser value. The remaining payment transaction is now automatically selected for the user after the allocation is done. This is done to speed up the allocation of the remaing balance to another invoice. - Users can now double-click the mouse to select payments and also double-click to do allocations. This is much quicker then right clicking the mouse and selecting an operation from a menu. - GL Integration - When vat processing has been enabled, amounts are now posted including vat to the GL Sales & Purchases accounts. The vat on the tansactions are also posted to the "Vat amount" column. This has been changed to conform with the vat processing standard of the other modules. - Inventory - Sales Report - Restored functionality where POS transactions are displayed as daily totals, instead of individual transactions. Individual POS transactions will only be displayed when grouping by account option is selected. - Licensing - Added licensing configuration option #11. - Bug fixes - Inventory - Adjustments - Fixed issue with captions not being updated correctly when adjustment type was changed. - Sales Report - Fixed sql error when filtering by sales rep code. - General Ledger - Consolidations - Fixed error messages in consolidation process - Trial Balance Enquiries - Fixed 'Include Inactive Accounts' option which did not work correctly. - Batch Conversion tool - Fixed problem where the vat output & input accounts were not set when adding vat status to a batch. - Internal Notes - Requires D2007 v1.04 R2 Version 4.68 - 17 June 2008 --------------------------- - Changes & Enhancements - Inventory Customer Delivery Stationery Layout - Added the following customer fields: Company Registration, Vat Registration Number, Telephone, Fax, Cell - Installment Sale - Added installment sale customer statements. - Statements - Removed limitation of previous versions where only one customer statements preview window can be opened at a time. Multiple network users can also now run customer statements simultaneously. - Bug fixes - Purchase Orders Data Entry - Fixed issue where item desciption was not updated for a line when the 'auto search lookup fields' was disabled. - Receivables, Payables - Fixed bug introduced in v4.66 where invoice transactions from Receivables & Payables batches were not displayed in the payment allocation window. - CSV Import - Fixed issues with importing stockcode and inventory quantities from a csv file - Conversion from version 3.x - Fixed issue with default aging calculation method not being initialised to local client. - Internal Notes - Requires D2007 v1.04 R2 Version 4.67 - 9 June 2008 -------------------------- - Changes & Enhancements - Licensing - Added support to limit USB flash drives to remote company capabilities only. - Program Preferences - Email Disclaimer - Added support for carriage returns in disclaimer text. - Stationery Layouts - Added the following supplier fields to stationery layouts: Company Registration Number, Vat Registration Number, Telephone, Fax, Cell and Email - Bug fixes - Customer Deliveries - Fixed 'StockQtyTable locate' error when 'Display Item Qty on Hand' option was enabled in customer delivery data entry window - Internal Notes - Requires D2007 v1.04 R2 Version 4.66 - 26 May 2008 -------------------------- - Changes & Enhancements - Receivables, Payables - Added feature to show additional invoice/grn info in the payment allocations window. Customer Order/Delivery Note/Supplier Invoice numbers can now be displayed or even searched upon. - General - Improved "View|Toolbar" feature which hides or re-displays toolbars - Licensing - Further tweaks have been done to licensing routines to prevent checksum failures. - Added support for using MAC address for computer number generations. - Added support for using PCName for computer number generations. - Added support for allowing larger computer number variances. - Bug fixes - Licensing - Fixed licensing issue when verifying computer details with UNC paths. - Resumed support for licensing on removable media which was broken from v4.60. - Fixed issue with toolbars displaying icons when icons should not be visible for user selection or customisation. - Inventory Count Report - Fixed SQL error message when doing count report at a specific date. - Stationery Layout Templates - Fixed incorrect formatting of the supplier invoice no field in the GRN layout - Fixed problem where "Help|Check for Updates" option was not visible. - Internal Notes - Requires D2007 v1.04 R2 Version 4.65 - 6 May 2008 ------------------------- - Changes & Enhancements - Receivables/Lay-Bye Statements - Added support for printing statements with credit balances but excluding zero balances. - Added support for sorting statments by the account group code. (Enterprise Edition only) - Added account group code and description fields to stationery layout designer. - Bug fixes - Fixed Receivables Statements error which was introduced in v4.64 - Internal Notes - Requires D2007 v1.04 R2 Version 4.64 - 5 May 2008 ------------------------- - Changes & Enhancements - Inventory Stationery Layouts - Added the following customer fields to stationery layouts: Company Registration Number, Telephone, Fax, Cell, Credit Limits, Price Matrix Indicator. - Licensing - Tweaks and fixes have been done to licensing routines to prevent checksum failures. - Bug fixes - Inventory Sales/Purchase Orders - Fixed error when re-instating cancelled orders. - Internal Notes - Requires D2007 v1.04 R2 Version 4.63 - 13 April 2008 ---------------------------- - Changes & Enhancements - Inventory Stationery Layouts - Added 'Contact Person' field to stationery layouts. - Preview of the Installment Sale module is now available in this version. - Bug fixes - Inventory Sales Report - Fixed "PTypQuery" error msg when payment information was not displayed. - Colours & Sizes - Fixed problem where editing in the grid was disabled for the colour & sizes masters. - Receivables, Payables Quick payments - Fixed problem where the correct aging descriptions was not displayed in this window. - Receivables Statements - Fixed problem where an account did not get a statement generated, when there were no transactions in the period selected even though the account had an opening balance for the period. - Payables - Fixed problem in enquiries section were printer selected under the "Options|Printer Setup" option was not used for subsequent reports printed. - Licensing - When doing an activation, serial number is now only requested after the activation has completed. - General - When opening a company on an older version of AceAcc than the company was lasted worked on previously, AceAcc updated the companies version number with the older version number which it shouldn't have done. - Fixed issues with the demo companies pos module not configured correctly to work with Ace POS. - Installation - Fixed problem where stationary layout template arstatement2.alt was not included in the setup. - Internal Notes - Requires D2007 v1.04 Version 4.62 - 10 March 2008 ---------------------------- - Changes & Enhancements - All Editions - Receivables Age Analysis Reprot - Added option to show account terms on report. - Inventory Sales Report - Added new 'group by' option to group the report by Date, Transaction Type, Customer account and Sales Rep - Speeded up report so that it now runs much faster remotely. - Inventory Item Sales Report - Added options to 'group by' and filter by Sales Rep. - Inventory Setup - Added option "When posting invoice and customer has exceeded credit limit" under Invoice tab, which will allow you choose whether to confirm with the user or not to permit processing of the invoice. - POS Setup - Added option "When posting invoice and customer has exceeded credit limit" under Invoice tab. This option allows you choose whether to confirm with the user, confirm via a supervisor password or not to permit processing of the invoice. - Licensing - Added support for 30 day trial periods. - Minor bug fixes and tweaks. - Internal Notes - Requires D2007 v1.04 Version 4.61 - 25 February 2008 ------------------------------- - Changes & Enhancements - Enterprise Edition - Receivables & Payables - Added new Account Groups functionality for grouping accounts for reporting and analysis purposes - Licensing - Minor bug fixes and improvements - Added option to email license files to MicroAce for support purposes in the "License Info" section. - Bug fixes - POS Modules - Fixed problem with Inventory Sales report. Did not filter by account code & sales rep correctly. - Internal Notes - Requires D2007 v1.04 Version 4.60 - 11 February 2008 ------------------------------- - Changes & Enhancements - General - Support added for new editions: Express, Standard, GL, Professional & Enterprise. Refer to our website for more information on the features of each edition. - Licensing - Due to fundamental changes, all existing users will need to be re-activated on the Enterprise Edition for this new version. Existing users will also be issued with a serial number for their license. - Faster and easier multi-user licensing. Activation only has to be done from a single PC now. - New "Help|License Information" section which displays full license details, next activation date, support expiry date etc. - Receivables - Added "Print & Email" statement option in Receivables account setup. - Bug fixes - Receivables, Payables, General Ledger - Fixed exception that was raised for data dictionary enabled companies after deleting a batch from the posted section immediately after it was posted. - Receivables, Payables, Lay-Byes - Fixed bug where an account could not be deleted even though there were no transactions in the ledger. - Fixed issue with executing a SQL script on a remote company. - Installation - Fixed problem where stationary layout templates where installed on network client pc's. - Internal Notes - Requires D2007 v1.04 Version 4.58 - 16 January 2008 ------------------------------ - Bug fixes - Receivables, Payables & Lay-Byes - Fixed bug in Detailed Age Analysis Report were aging of previous account was displayed for an account when it had no transactions and the "Include Zero Balances" option was enabled. - Bank Reconciliation Report - Fixed totalling problem in final reconciliation section of report - Receivables, Lay-Bye Statements - Fixed problem where running balance or aging in laser statement templates for open item accounts were incorrect when the statement printing option "Print Open Item Unallocated Trans. only" was enabled. Laser stationery layout templates (arstatement*.alt2) for customer statements have therefore been updated to resolve part of this problem. IMPORTANT: If you are using a custom laser layout for statements and open item accounts in your business, you should update your layout to use the latest templates. - Verify Data - Fixed SQL error when checking open item account balances for companies that had only had the accounts payable module and not the receivables module. - Internal Notes - Requires D2007 v1.03 Version 4.57 - 27 December 2007 ------------------------------- - Changes & Enhancements - General Ledger - Chart of Accounts - Fullstops in account codes are now permitted. - Importing of Pastel 2007 Trial Bdalance ascii text files have been validated and users should now be able to import these files into Ace Accounting. - Creating a new company - Support has now been added to allow the user to only transfer a template's financial categories. The new companies chart of accounts will thus be empty after it is created. This is necessary when importing a trial balance from a third party accounting software when only financials are going to be prepared in Ace Accounting. - Inventory - Item edit screen - Changed Barcode field to force upper case of characters. - Point Of Sale - If GL Integration method for POS module differs from Inventory module's GL Integration method a warning is now displayed to the user. - Bug fixes - Inventory - Fixed av that occurred when searching in item window when no column was focused. - Fixed blank company name problem and error msg "Dataset not in edit/insert mode" when cancelling creation of a new item while in document data entry. - Fixed bug where invoices which contained BOM items that had to be auto manufactured could not be posted because of index problem on inventory ledger. - Fixed bug were new Item Attributes could not be captured because Grid editing was disabled. - Internal Notes - Requires D2007 v1.03 Version 4.56 - 03 December 2007 ------------------------------- - Changes & Enhancements - Added remote support option in help menu. - Inventory - Added option in item master to multi-select items and change departments quickly via right click 'Cut' and 'Paste' options on the item & department grids. - Removed 12 character limitation on item code field. Should have been limited to 20 characters which is the actual field length. - Bug fixes - Laser Stationery Layout Templates - Fixed problems with invalid formatting expressions in the account code & balance fields in the new customer statement templates. - Inventory - New Item Capture - Fixed bug where barcode, re-order/min/max levels, weight & volume was not saved when captured in the new item screen. - Internal Notes - Requires D2007 v1.03 Version 4.55 - 27 November 2007 ------------------------------- - Changes & Enhancements - Inventory - Added option in setup section to prevent or warn users from selling items below cost. This feature will warn or prevent such an error from occurring when: a) modifying an item b) modifying or posting a quotation, sales order or invoice. - Payment Integration with General Ledger - Payments that are captured in the Receivables/Payables/Lay-Byes/Inventory/POS modules are posted to the General Ledger when integration is enabled. Depending on the payment type selected (eg. EFT), these payments were posted to the General Ledger Bank account and would appear in the bank recon section for reconciliation purposes. However, in previous versions there was no consistency with regards to the 'Debit' or 'Credit' column that the payment amounts appeared in, in the bank recon section. This has now been improved upon: Receivable payments will always appear in a 'Deposit' column and Payable payments in a 'Payments' column. Also, the Receivable payments transaction type has changed from a 'R' to 'ARP' and Payable payments from 'P' to 'APP', to differantiate these transactions from the standard GL 'Receipt and Payment' batch transaction types. - General Ledger - Bank Reconciliation - Changed grid column headings from 'Debit' & 'Credit' to 'Deposits' & 'Payments'. - Added 'Transactions' combobox to filter transactions between 'All', 'Deposits Only' or 'Payments only'. - 'Deposit' & 'Payment' transactions are now highlighted in navy & maroon colours for easier identification. - Transactions Enquiry - Debit & Credit transactions are now highlighted in navy & maroon colours for easier identification. - Improved support for payment transactions from the Receivables, Payables, Lay-Byes & POS Modules. These transactions are now properly catered for and processed in the Bank Reconciliation section, Bank Transactions report & Year End process. - New Laser stationery layout report generator & designer - The previous Laser stationery layout report generator & designer has been replaced with a new and improved report generator & designer. Layouts created with the old designer can still be printed, but support will eventually be removed for these old layout files in a future version. The old layouts must therefore be re-designed in the new designer as soon as possible. Contact MicroAce for assistance in converting these old layouts. - Features & benefits of the new report generator & designer - Reporting Engine - Report generation is up to 3x faster than previous engine. - Supports "endless" page mode. - Supports drill down groups. - Report can contain dialogue forms to ask for some data before the report is run. - Print Preview - You can now search for text in the report while in the preview window. - 'Report Outline' allows you to jump to a specific group/section quickly. - Support for thumbnail view of pages. - Ability to edit a page layout before printing. - Multiple pages can viewed at once. - Printing support for: - Splitting a big page to several small pages - Printing several small pages on one big - Printing a page on a specified sheet (with scale) - Duplex handling from print dialogue - Printing copy name on each printed copy (for example, "First copy", "Second copy") - Designer - Supports zooming, undo, redo & guidelines for easy positioning of objects. - Powerful scripting engine supports 4 languages and code completion (ctrl-space) - Debugging support via stepping, breakpoints & watches - Bug fixes - Payables Batch & GL Intregation - Fixed bug where transactions did not get posted to the custom GL Account specified in the payables account setup. - Receivables, Payables, Lay-Byes - Detailed Age Analysis Report - Fixed bug when "Print Batch Details" option was enabled an empty report was generated. - Receivables, Lay-Byes Statements - Fixed bug in emailing of statements. Attachments generated for emails could contain incorrect accounts. - Lay-Bye Statements - Fixed SQL error that was displayed when statements were run. - CSV Import - Fixed bugs in Inventory items import routine. - Internal Notes - Requires D2007 v1.03 Version 4.54 - 22 October 2007 ------------------------------ - Changes & Enhancements - Inventory Setup - Added new options for the inventory documents Invoice, CRN, GRN & RTS to prevent users from creating multiple documents out of another document in error. eg. The option for invoices is called "Allow new invoice on document when unposted invoice on document already exists" - Inventory Stationery Layouts - Added 'Customer Vat Registration No' field to sales order & quotation layouts. - Bug fixes - Inventory Module - Fixed problem with OK button being disabled in the new inventory document windows when they shouldn't be. - Fixed bug in Sales order print settings option window - If a custom sales order layout was selected, AceAcc forced the user to also select a custom sales order picking slip layout. - General Ledger - Fixed bug in Batch Menu: When the last batch was deleted the Delete button remained enabled. - Network User Administration - Fixed "Key field not found" error message which occurred when the grid was sorted by a specific column and the user tried to focus on a row. - Internal Notes - Requires D2007 v1.02 Version 4.53 - 16 September 2007 -------------------------------- - Changes & Enhancements - Verify Company Data - Added feature to verify Trial Balance period totals with the General Ledger transactions and to correct any discrepancies. - Inventory - Departments - Added dialog windows for adding or modifying department groups & sub-groups. - Count Report - Added option to exclude service items - Bug fixes - General Ledger Module - Bank Reconciliation Report - The bank account balance calculated for a bank recon report at a specific period date could be incorrect at times, because it included last years unpresented transactions in the calculated total. This has been corrected. - Importing Financial Reports - Fixed error msg that occurred when trying to import a financial report from a data dictionary bound table. - Inventory Data Entry Screens - Fixed some 'Cannot focus a disable window' error messages when moving between fields with the enter key. Version 4.52 - 5 September 2007 ------------------------------- - Changes & Enhancements - Grids - New "Filter Row" added to data grids. - This powerful feature allows to apply a filter condition directly within most grids, without having to invoke popup dialogs or dropdown windows which invariably slows you down. To turn on the "Filter Row" feature right click on a grid and select the "Filter Row" option, and then select "Enabled". An empty row will be displayed at the top of the grid where you can quickly enter the desired filter values. By default "Incremental Filtering" is on, which means that filtering will be performed as you type characters in the filter row - thus the number of matching records will be narrowed down as you enter more & more characters. If you have a very large number of records in a grid, it is recommended that you turn off "Incremental Filtering" to improve performance. This can be done by right clicking a grid and selecting the "Filter Row" option, and then unchecking "Incremental Filtering" by clicking on it. When "Incremental Filtering" is off, the filter engine searches for exact matches instead of doing partial matches. The filter is also only applied when you leave the filter cell or press ENTER while the cell still has input focus. You can still peform wildcard searches for text in a cell, by specifying the % character at the beginning or end of text. For example: "%SMITH%", "A%". - Emailing - Added support for sending email via the new Windows Mail application on Vista. - Network Preferences - Added option to allow blank user passwords. - Bug fixes - General Ledger Module - General Ledger Integration from other modules - Fixed bug where period balances where incorrect for sales, purchases accounts for vatable transactions because the vat amount was not deducted from the total posted to these accounts. YTD figures were however correct. - Redo Year End - Fixed issue where the profit split account could go out of balance when doing a redo year end for a client from 1st year of trading to the 2nd year of trading. - Fixed error where log displayed profit as loss and vice versa. - Internal Notes - Requires D2007 v1.01 - Changes to first time installation - Demo license changed to 7 days Network Edition. - ADMIN is now created with a blank password. Version 4.51 - 27 August 2007 ----------------------------- - Changes & Enhancements - 'Standard' Theme - Vista: Menus & toolbars now conforms to the vista standard. - XP: Now uses XP Style theme. - POS Module is now activated for the demo version. - Bug fixes - Vista - Fixed 'Canvas does not allow drawing' error. - Fixed Vista Licensing Issues - 60 day demo license did not work on Vista after first time installation. 'LF Open Error #9' was displayed. - Internal Notes - Requires D2007 v1.01 Version 4.50 - 16 August 2007 ----------------------------- - Changes & Enhancements - Open Company Window - Added support for compressed and hidden company folders. Previous versions of AceAcc did not display company folders which had these features enabled. - Windows Vista Compatibility - Moved location of aceacc.ini file from c:\windows to c:\programdata folder for Vista users to improve compatibility with this OS. - Log Viewer - Added print option. - Added email option so that log files can easily be emailed for support purposes. - General - Grid Filtering - Column filter dropdowns now use checked lists. This means that you can easily choose multiple filter values and never have to invoke additional dialogs to slow down the filtering process. - Filter buttons are now only visible when you position the mouse over a column header. This new behavior not only helps to avoid text truncation in column headers but also greatly reduces visual noise by eliminating numerous repeating elements. - Bug fixes - Receivables, Payables, Inventory, General Ledger - Fixed problem in batch menu where multiple batch operations did not execute on all batches when the grid was sorted on a specific column. - Internal Notes - Requires D2007 v1.00 - Changes - Added Virtual PC detection - Compiled with D2007 U2 - Now using DevExpress v6.27 - Now using PP 4.4.0.3 Version 4.49 - 6 August 2007 ---------------------------- - Changes & Enhancements - Email Company Backup - Added new feature in File menu to email single or multiple company backups. Your email preferences must be correctly setup in the "Setup|Preferences|Email" section before this feature can be used. - Company Data Protection - Added new feature to lock company data from any further changes for a specific module. Data for the following modules : Receiables, Payables, Lay-Byes, Inventory, General ledger or Financial reporting modules can now be locked or unlocked. When data for a standard module is locked, no new transactions can be posted or existing transactions modified for that module. When data for the Financial Reporting module is locked, no changes can be made to any of the companies financial reports and reports can only be opened in read only mode. All locking and unlocking operations performed by users are logged. - Bug fixes - Inventory Enquiries - Restored column filtering capabilities. Click on the date or any other column header and the filtering drop-down list will be enabled for all columns. - Inventory Data Screens - Tweaked updating of company name in Inventory data screens to resolve blank company name problems. - Conversion from version 3.xx - Some v3.xx companies failed to convert successfully because the Company Log & GL Budget tables did not exist. Added check for existance of these tables and created these tables if they did not exist for the company. - Internal Notes - Requires D2006 v1.00 Version 4.48 - 23 July 2007 --------------------------- - Changes & Enhancements - Bank Reconciliation - By default in version 4, when a transaction is flagged as presented or unpresented the changes are posted immediately and the transaction will disappear from view. In version 3, the change was not posted until the user moved focus to another transaction. Users who prefer the version 2 functionality can now switch back to this method by right clicking on the Bank Recon grid and unticking the "Immediate Post" option by simply clicking on it. - Edit Ledger Transactions - Restored certain ProAcc version 3 functionality & behaviour - Grid does not go into edit mode when clicking on a cell. Focus can therefore be moved from one cell to the next using the arrow keys now. - Pressing the Enter key after changing the account of a transaction, no longer posts the tansaction, giving the user a chance to make changes to other fields. - New General Ledger Report options - Print Debits Balances Only - New Page per account - Bug fixes - Edit Ledger Transactions - Ledger account and Journals total are now displayed in the footer section of the grid. - After changing journal transaction amounts, AceAcc would sometimes calculate the new debit and credit totals for the corresponding journal batch incorrectly. This has been fixed. - Receivables - Enquiries - Double clicking on a POS payment in the enquiries section did not display the payment document, instead a blank invoice document was displayed. Fixed. - Internal Notes - Requires D2006 v1.00 Version 4.47 - 15 July 2007 --------------------------- - Changes & Enhancements - Backup Restore - Before a company backup is restored, Ace Accounting now deletes all files in the company directory before performing the restore operation. This will prevent backups from older version causing problem when they are restored onto later version company data files. - General Ledger - Transfer Batch - Posted batches can now be transferred to a disk/path without having to unpost the batch first. - Import batch - Import batch is now more accurate than version 2, since batches that are transferred to a disk/path now stores the actual account code that the transactions were posted to. When the batch is imported into another client, AceAcc automatically locates the corresponding account with the same code and allocates the transaction to it. - Data Dictionary - Added option "Verify Dictionary Tables" under the "Tools|Data Dictionary" submenu. This procedure was initially part of the "Tools|Clean Data Dictionary" procedure but has now been moved to a seperate option. This option validates the tables in a data dictionary to ensure that the table physically exists in the company directory. If the table does not physically exist, the user is given the choice of removing the invalid tables in the dictionary. This feature can be used to fix "5132" dictionary errors when creating new or unposting batches. - Bug fixes - General Ledger - Data Entry - Fixed problem were the wrong transaction would get deleted when deleting a transaction when the sort order was date or reference order. - Fixed error message that was displayed when changing transaction sort order. - Batch Menu - Fixed access rights issues for batch transfer/import options in Batch menu for Network version users. - Transfer/Import Batch - Fixed issue were transactions were allocated to the wrong account after importing a batch. This problem was introduced in v4, because of the change in the internal stucture of the chart of accounts table. The batch Transfer/Import process has been re-designed to accomodate the v4 changes and should now be 100% accurate. - General - Fixed GUI problems in certain screens were navigator buttons disappeared and controls did not paint correctly. - Internal Notes - Requires D2006 v1.00 Version 4.46 - 4 July 2007 -------------------------- - Changes & Enhancements - Company Log - Log date now includes time. This will provide a better overview of the sequence of events when certain actions happen consecutively. - General Ledger Financial Categories - Added a '0' to the front of the financial category code for the master chart of account templates. This will prevent sorting problems in the Trial Balance when financial category codes go pass '100'. - Stationery Layout Archives - Added proper detection and prompting to the user when updated or new layouts are detected in the company directory and the user is given a choice whether to update the layout archives table for the company. For the network version, these detections are only done for users who have access to the layout desinger or the system administrator. So in the event, of a layout being designed offsite for a company. The new layout must be placed in the company directory and a user with the appropriate rights must enter the "Tools|Stationery Layout Designer" section. AceAcc will detect the new layout and confirm whether the new layout must be imported in the layout archives table so that all user can access and use the new layout. - Bug fixes - Stationery Layout Archives - Fixed issue where the wrong layout record was deleted when deleting a stationery layout. - Internal Changes - Reverted back to DevExpress v5.23 - Added functionality for AceAcc to accept command-lines parameters to do a conversion of a ProAcc exported company from version 3 to version 4. Version 4.45 - 28 June 2007 --------------------------- - Changes & Enhancements - Receivables, Payables, Lay-Bye Modules - Age Analysis, Detailed Aged Analysis, Statements etc - Optimised and changed report design to use SQL only. Remote internet users should see the biggest benefit from this change and reports for these modules will now run 10 to 30 times faster for remote users. - Aging Calculations - Added support for server based aging calculations when the Advantage Database Server is being used. One can now choose between local and server based aging caculations in each module setup. Note however that, AceAcc will ignore this setting in the module setup and always use server based calcuations for remote internet users. Differences between local & server based aging calculations: Previous versions of AceAcc only supported local client based aging calculations - where all the transactions of an account was sent to the local client which performed the aging caculations by traversing the transactions one by one and performing the calculation. Depending on the number of transactions for an account, this method generally resulted in slow report generation for remote internet users. With server based aging calculations, the local client only makes a request to ADS to calculate the aging of an account. After receiving the request, ADS performs the aging calculation at the server and returns only a tiny aging result set back to the client, thus resulting in much faster report generation for remote internet users. - Open Item Accounts - Improved accuracy of transactions displayed when viewing custom periods for open item accounts. In previous versions, a payments was not displayed for a period, if the payment was already allocated to a transaction which belonged to a different period. This limitation has been removed, resulting in a more accurate view of open item accounts. - Custom Stationery layouts & Remote Users. - Removed limitation were custom stationery layouts could not be utilised or designed by remote users. AceAcc now creates a stationery layout table for all companies and stores the custom layouts using zip compression in this table for remote users to access. Local network users still have the stationery layout as an ordinary file in the company data directory. The compressed layout stored in the table is kept in synch automatically by AceAcc whenever local users update stationery layouts. When remote users login to a company and print a document that uses a custom layout, the latest layout is automatically retrieved by the remote user and stored in the \AceAcc\RemoteWorkDir\ directory on the local machine. Local network users can detect layout changes immediately, but remote AceAcc users by default will only check for layout changes once during a particular company session, i.e. when a layout is used for the first time. Thereafter this same layout is used by remote users, until the company is closed and re-opened, when AceAcc will re-check once only to ensure it has the latest layout on the remote users local machine. Remote users can also modify or create custom stationery layouts. Local network users may need to close and re-open a company to see these new or modified layouts. - Point Of Sale - Added option in POS Setup section to prevent users from selling items below cost. - General Ledger - Account Setup - Added check to ensure that account code does not contain invalid characters like fullstops, dashes etc, which will conflict with the financial reporting account functions. - Bug fixes - Receivables, Payables, Lay-Bye Modules - Fixed bug in aging when displaying unallocation transactions and there were partially paid invoices for the account. - Enquiries, Detailed Aged Analysis & Statements - Fixed open item account problem where balances for an account could be inaccurate when a custom date range was specified by the user. (See v4.16 notes for more information about this feature introduced for open item accounts.) The problem: When payments that were allocated to invoices fell out of the "to date" filter, they were still taken into account when determining an opening balance at the "from date" by the various screens/reports, resulting in incorrect balances being displayed at the "to date". Only the Age Analysis report worked correctly and displayed the correct balance at the "to date". Laser stationery layout templates (arstatement*.alt) for customer statements have also been updated as calculations to determine running balances have changed to resolve this problem. IMPORTANT: If you are using a custom laser layout for statements and open item accounts in your business, you should update your layout to use the latest templates. - Inventory Sales Order Enquiries - Fixed SQL error message. - Remote Company - Fixed slow list box population when opening a local company when a remote company is already opened. - Fixed error where Stationery layout templates screen could not be accessed when a remote company was open. An ADS error was displayed instead. - Fixed problem where when a remote user logged into a site and opened a company, the Network monitor window did not display this. - Opening Companies - Removed check for different program types when opening a company. This is not necessary an longer and could display unnecessary messages to the user. Version 4.44 - 20 May 2007 --------------------------- - Bug fixes - Fixed access violation that occurred randomly when creating a company that had the POS module enabled. Version 4.43 - 13 May 2007 --------------------------- - Changes & Enhancements - Point Of Sale - Added support in AceAcc to allow AcePOS to process Quotations and Sales Orders - Configuration options have been added to the POS Setup section to configure AcePOS to allow converting of Quotations and Orders to sale dockets. - POS transaction enquiry section will now display the related quotation or order document number for a POS sale that was processed from one of these document types. - General Ledger - Journal Report - Added options to filter report by type (3 letter description captured for a batch) and reference. - Bug fixes - Financial Reporting - Fixed bug in 'Convert Formula' & 'Paste as' options. "Invalid class typecast" error msg was displayed when options were selected. - Internal Changes - Now uses Advantage v8.10.0.15 - Now using RB v10.06 Version 4.42 - 23 April 2007 ---------------------------- - Changes & Enhancements - Online Help - Context senstive online help has been added for the General Ledger and Financial Reporting modules. - Inventory - Added settings in module setup to control whether each inventory document can be unposted or not. If an inventory document is allowed to be unposted, then you can also specify a date limit on unposting this document. For the Network Edition, system administrators will be allowed to bypass this date limitation, but the unposting of the document will be logged. - Added User filter in each inventory document section for Network Edition users. Click on the View menu to choose between "Any user's documents" or "My documents". You can also restrict a user via the "Network User Setup" section to only allow the user to see his or hers own documents. - Added 14 & 30 day date filters to the inventory document sections. - Company Log - Added support for logging changes to the Receivable, Payables, Lay-Byes and Inventory Module/Stationery settings in the company log. - Data Dictionary - Data Dictionary for a company can be now removed from the Tools menu, without having to open a company. - Problems with the Application Data Dictionary can now be detected in the network login window, and AceAcc will now attempt to re-create the dictionary if the user agrees. - In the event of problems, the Application Data Dictionary can now also be re-created by using the shortcut key CTRL-ALT-N, even when the user is logged off. - Bug fixes - General - Fixed problem with numeric fields that had a dropdown calculator - Enter key could not be used to end the calculation and display the final total. - Data Dictionary - Fixed problem when opening a company that had a problem with its data dictionary. After the data dictionary error message was displayed the connection to the dictionary was not closed resulting in problems when trying to delete and re-create the dictionary. - Inventory Module - In previous versions, 'Prices & Vat' setting in the inventory setup section, could be switched between excluding or including vat while quotations, sales orders, invoice, laybye documents where unposted. When these unposted documents were opened after the change to this setting the line totals were incorrect. AceAcc now only allows changes to this critical setting when there are no unposted customer inventory documents. - Added validation when saving a line in an inventory data entry screen. The validation ensures that (Qty * Unit Price) - Discount = Line Total. There has been certain instances when users have captured a line total amount with a qty already specified in the qty field. Our software calculated the unit price from the line total and qty fields. Because the line total & qty field contained values with fractions and the decimals for item price where only set to 2, the resulting unit price calculated by our software when multiplied by the qty did not equal to the original line total captured by the user. Because the vat was calculated from the line total captured by the user, it was now incorrect. We have added the validation to ensure that this does not occur in future and the user is also warned by the application to increase their decimal places for item prices when the application detects this problem. - When a change was made to the 'Prices & Vat' setting in the inventory setup, and older customer inventory documents were unposted the line totals for these documents were incorrect in the data entry screen. This has been fixed. - Fixed 'operation aborted' error message that was displayed when aborting the creation of a new item in the data entry window. - Fixed 'StockCode' invalid index error when opening data entry window. - POS Module - When changes were made to "Decimal Places for Quantities - Data Entry" in the inventory setup the settings was not saved correctly in POS settings files. A decimal place value of 0 was saved. Version 4.41 - 12 April 2007 ---------------------------- - Bug fixes - All Modules - Fixed problem with numeric fields with calculator support. When a calculation was done in the drop down calculator, the resulting decimal places for the calculation could be greater than what was originally required. Version 4.40 - 11 April 2007 ---------------------------- - Changes & Enhancements - Verify Data for Inventory module - Added functionality to detect & restore deleted inventory documents from the various inventory list tables. Totals are recalculated for the recovered documents. The following limitations exists however for the recovery : a) Delivery addresses, order numbers & sales reps info are not recovered. b) Discount totals at the document level are not always accurately determined, and may be incorrect when discounts were applied at both line and document levels. c) Quotation & Order statuses are also not recovered. Version 4.39 - 02 April 2007 ---------------------------- - Changes & Enhancements - Improved Network peformance - AceAcc settings are stored in standard ini files. The routines to read/write to these ini files have been replaced with new optimized routines, resulting in excellent write performance to the ini files when compared with the older routines. Network users will especially notice an overall improvement in application peformance. - Receivables, Payables, Inventory, General Ledger module. - Speeded up creating of new documents. - Verify Data - Inventory Items - Add verification & fixing of invalid ItemId records in InStock & InPrice tables. - General - Changed location of buttons in most windows to be at the bottom right to conform to windows standard. - Bug fixes - General - Fixed problem with user double-clicking on toolbar buttons and calling events on buttons twice which could result in errors in the application. For the inventory module, this problem could cause documents numbers to be skipped when clicking the 'New' button. - Inventory Module - Fixed problem where buttons which a network user did not have rights to were inadvertently left enabled when switching between unposted & posted sections - Fixed problem where if the user pressed the ESC key quickly while opening/creating a document the data entry would display an error and could not be closed. - General Ledger - Batch Setup dialog - Fixed problem where batch description could not be changed manually. - Fixed problem where batch conversion did not work when data dictionary was enabled. - Receivables, Payables, Inventory, General Ledger Modules. - Fixed problem with the various data capture screens which allowed a user to clear the date fields by pressing the delete key, thus resulting in a 0 date value (or 30-12-1899) for the transaction concerned. - General Ledger Export - Exporting of a list of accounts did not work correctly. Only the first account in the list was exported. - Internal Changes - Changed ini routines from inifiles.pas to bigini.pas. - Added debug console - CTRL+F5 Version 4.38 - 13 March 2007 ---------------------------- - Changes & Enhancements - Support for Windows Vista added. - Windows Vista makes it possible for organizations to deploy a more manageable and secure desktop in which administrators can run as standard users and only run under elevated permissions to perform administrative tasks when necessary. Because of this change, a user account on Vista does not have full access to the machine as it generally would under Windows XP. Necessary changes have therefore been made to Ace Accounting to ensure that it can installed on Windows Vista using the Elevated Administrator mode & thereafter function and be used under the standard user mode. - Bug fixes - Conversion to version 4.15 routine - Fixed bug in the conversion to v4.15 when a company had the POS module enabled. POS user access rights was skipped and not converted and subsequent conversion routines would fail with errors on TempTable.Indexname. - Receivables, Payables, Lay-Byes - Statements - Fixed rounding problem which would result in statements being printed for an account even though its balance did not respect the statement options condition - "Print balances greater than xx.xx" - Modify Payment allocations - Fixed "list index out bounds" error which could occur when doing an auto-allocate. - Inventory - Sales Orders - Fixed bug where cost of item could be updated to latest system cost price even though "Allow users to change cost of items on sales order" was enabled in the module setup. - Fixed SQL error that would sometimes occur when creating a new inventory document and the "Item Qty, Cost & History" tool window was displayed when the document capture window was opened. - Internal Changes - Now using RB v10.05 - Now using DevExpress v5.23 - Now using PP 4.3.1.0 - Now using Innosetup 5.1.11 - Removed relocation table to decrease exe size - machnm1.exe & machnm32.sys now installed in windows system directory. Version 4.37 - 6 February 2007 ------------------------------ - Changes & Enhancements - Inventory - Creating a Quote from another Quote. - If the option "Allow users to change cost of items on quotation" is enabled, users will now be asked whether they would like to use the original quotation cost prices or the lastest system prices for the new quote. - Sales Orders - Added option "Allow users to change cost of items on sales order" in module setup. This feature is similar to the quotation feature and allows users to capture their own cost price for an item when preparing sales orders. - When creating a new order from a quote/order and the above module option is enabled, users will now be asked whether they would like to use the original quote/order cost prices or the latest system prices for the new quote. - Added option in data entry screen, to update order cost prices with the latest system cost prices for a single or all lines. - Data Entry - Added Qty field to the grid in the history tab of the "Item Qty, Cost & History" tool window. To add this field right click on the grid, select customise and drag & drop fields from/to the customise window. - Inventory Ledger Table - Added another index to this table to trap for duplicate or errorneous transactions when the Bill of Material module is enabled. - Tools - Added feature in "Tools|Clean Data Directory" option to also verify data dictionary tables to see if they physically exist and remove these invalid tables from the dictionary if necessary. This feature will resolve 5032 errors when attempting to unpost a batch whose tablename already exists in the data dictionary. - CTRL-F4 option to execute an SQL script now runs script under ADSSYS user. - Client/Server - Added "Keep Tables Open" configuration option in "Network|Preferences". By default this feature is now OFF. When this feature is ON, AceAcc will keep tables open after it has finished using them. In the event, of tables being needed again, the tables will already be open and no request has to be done to the server to re-open these tables, thereby increasing application performance. The disadvantage of using this option is that in the event of a power failure on the ADS Server, data corruption can occur if cached data for the tables (that are still open) has not yet been written to disk. If this feature is used, there is also an additional configuration option that can be used to automatically close inactive tables on a client, after a specific period of inactivity. Note: a) If other clients have the same table open, then ADS will not close a table until all other clients have also issued their request to also close the table. b) See the new "Flush Frequency" setting in the "Database Configuration Utility" below which is an additional feature to ensure all cached data is timeously written to disk. c) The "Keep Tables Open" configuration option is only for "local" client/server operation. Remote clients will ignore this setting and ALWAYS use this feature, because continually opening and closing tables is very time consuming over the internet and can slow down general application usage considerably. - Added option in the "Database Configuration Utility" to configure ADS's "Flush Frequency" setting. This setting determines how often ADS will instruct Windows to forcibly flush all cached table information to disk. ADS's default value for this setting is 10 minutes. We have reduced it to 30 seconds, as this feature has minimal overhead and will decrease the likelyhood of data corruption when tables are open and there is a power failure. - Bug fixes - Inventory, Receivables, Payables, General Ledger Modules. - Fixed various multi-user scenario problems ie. attempting to open or post a batch while it is being edited by another user. - Inventory - Quotation - Fixed bug where the option "Allow users to change cost of items on quotation" was enabled in the module setup section and the system cost prices was reloaded when the quote was opened thus overwriting the cost prices captured by the user. - GRN Document - Fixed vat total problem for GRN's that were created for subsequent deliveries of a purchase order. The vat total initially displayed was for the total order qty instead of the actual outstanding qty. - Creating Inventory documents from another unrelated document - For example when creating a sales order from another sales order (ie. copying it), only the outstanding lines/quantities where copied to the new order. This has been fixed so the new order is an exact duplicate of the original document. - Data Entry - Fixed focus issue with item search window and "Item Qty, Cost & History" tool window introduced in v4.36 - Customer Deliveries - Fixed problem where customer delivery document could not print. - Fixed line order problem in data entry & printed delivery document. - Fixed SQL error message that occurred when opening an inventory document and the Bill of Materials module was enabled for the company. - General Ledger - Fixed DB error 5022 when deleting multiple transactions in the data entry screen. - Financial Reporting - Fixed DB error 5022 when deleting multiple financial reports. - Fixed problem where button shortcuts did not work. Version 4.36 - 28 January 2007 ------------------------------ - Changes & Enhancements - Inventory Document Data Entry - The "Item Qty, Cost & History" tool window for GRN, RTS & Purchase Order documents now has a GRN history tab which shows the last 3 purchases for the selected item. You can also toggle between history for selected supplier or all suppliers. - You can also toggle between history for selected customer or all customers in "Item Qty, Cost & History" tool window for Quotes, Sales Orders, Invoices & Credit Notes documents. - When the item search window is diplayed the "Item Qty, Cost & History" tool window can now be focused and the tabs changed. - Bug fixes - Inventory Document Data Entry - Fixed problem when the "Item Qty, Cost & History" tool window was not updated when the item search window was displayed. - Financial Reporting - Fixed bug where date functions YStartDate1 & YEndDate1 returned dates in short date format instead of long date format. - Internal Changes - Now uses Advantage v8.10.0.6 - Now uses JVCL 3.30 Version 4.35 - 14 January 2007 ------------------------------ - Changes & Enhancements - General - Added right click menu option on toolbars to re-align toolbars. Toolbars will also be automatically re-aligned from now onwards when creating a new company or restoring toolbar layout to ensure toolbars are correctly aligned. - Remote Companies - When "Disable high bandwidth features" is enabled for a remote company setup the following features are now turned off when using the remote company to speed up application usage : - Custom sorting of grids is not saved & restored. - When entering unposted or posted section of batch windows, the first record is always highlighted and not the last record. - General Ledger - Year End - When a year end is done to the existing company code, AceAcc will now ask the user if a backup and restore must be done for the company to another company code automatically. For Example : If a General Ledger year end is being attempted on company code ACE, financial year end 28-02-2007. AceAcc will now ask the user if a backup and restore of ACE must be done to the code ACE2007 automatically before proceeding with the year end. Note : This feature has been added since we know recommend our users to not prefix their company codes with the financial year. In a large multi-user scenario a change in company code at the start of a financial year, could result in certain users still logging on to the old code/financial year and attempting to do processing on the wrong financial year, resulting in unnecessary support requests. Existing users should remove the financial year from their company codes and take advantage of this new feature. - Bug fixes - Grids - Fixed problem where after clicking on a column header and sorting by that column, filtering for the columns was not enabled for certain grids. - Tab Bar Alignment - Fixed problem with the alignment of tab bar buttons when toolbars were docked on the left hand side of the main window. - Inventory data capture screens. - Fixed bug where the search criteria (code or description) selected in item fields was not saved and restored. Version 4.34 - 4 January 2007 ----------------------------- - Changes & Enhancements - Added workaround for opening ProAcc v4.00 clients that were missing the AceAccVersion key in the company settings files. - Changed filename of toolbar ini files so that it does not conflict with ProAcc's toolbar ini filename. - Bug fixes - Fixed problem where ProAccVersion key was not added to the company settings file when a new company was created. Version 4.33 - 2 January 2007 ----------------------------- - Changes & Enhancements - General - Application theme, view menu and main toolbar settings are now saved on a per user basis, instead of on a per company basis. However, toolbar locations and button settings are still stored on a per company basis. - You can now save a default toolbar layout. To do this customise the toolbar buttons and layout first and then right click on the toolbar and go to the "Toolbar layouts" option and select "Save current layout as my default". All new companies created will automatically use this default layout. Also, at any time you can restore your default toolbar layout by selecting the "Restore my default layout" option. - General Ledger - New Trial Balance Enquiries section added. This enquiry section allows you to easly view the following trial balance types : Current Year / Last Year, Period # / Last Period, All Period & All Years. This grid based view of a trial balance supports the following exciting feature over the normal trial balance report : * Drill down into the general ledger for current year transactions, so that you can now quickly see what transactions are posted to an account. Also, double clicking on a transaction displayed in the drill down will automatically take you to the edit ledger transaction section for quick editing of the transaction. * Charts/Graphs can be displayed (or printed) for period & year comparatives. * Differences (by Amount & percentage) can be displayed for "Current Year / Last Year" and "Period # / Last Period" trial balance types. - New Transaction Enquiries section added. This enquiry section allows you to quickly search for transactions in the general ledger. A combination of fields can be used to search for a particular ledger transaction, including : Date, reference, description, account, amount etc. - Financial Reporting - Toolbar and pulldown menus for the integrated spreadsheet and wordprocessor have been redesigned with new modern images. - Bug fixes - Inventory - Fixed problem where invoice discounts where not converted to 2 decimals when posting invoice totals to Receivables\General Ledgers. This resulted in the amounts in these ledgers having more than 2 decimals. - General Ledger - Edit Ledger Transactions - Fixed access violation that occured after changing an account code for a transaction and pressing the down arrow key. - Financial Reporting - Fixed problem with wordprocessor print preview not displaying white page background. - Fixed problem with the wordprocessor & spreadsheeet inital print preview not being the correct size.