NB: If the Client is using a prior version of V410.58, then you will need to go into Control Panel, Data Integrity Check and run “Reinstall Stored Procedures” at the bottom of the page.
Changes for 410.58.28
- Inventory (Internal Requisition)
- Fixed bug, when Adjusting a document, after selecting “Record”, the Allocated Quantity wasn’t being recalculated.
- Fixed bug, when Adjusting a document, after selecting “Record”, the next Document Number was being increased by one.
- Fixed bug, the next Document Number gets fetched when loading the form, this has now been changed on the Clear function, as well as when selecting “Record”.
2. Inventory (Adjustments) – Fixed bug, the next Document Number gets fetched when loading the form, this has now been changed on the Clear function, as well as when selecting “Record”.
3. Inventory (Issue Requisition) – Fixed bug, the next Document Number gets fetched when loading the form, this has now been changed on the Clear function, as well as when selecting “Record”.
Previous Changes for 410.58
MAIN
1. Business Intelligence
- Fixed bug, there were Refreshing Issues throughout all Cubes.
- Fixed bug, the launching of the OLAP Control causes the application to hand when large data exists, and one of the main areas where this gets encountered was the selection for “Inventory Items”.
- Fixed bug, when Tax hasn’t been setup, the below Cubes wasn’t displaying any data, due to INNER JOINS being used within the Views:
- Purchase Invoices
- Purchase Orders
- Purchase Requisitions
- Sales Orders
- Sales Quotes
- Fixed bug, due to the speed issues on Loading (Inventory Items), the Settings for “Row Totals” and “Column Totals” weren’t being Refreshed as per the Saved Settings, but I’ve changed the process of the Loading, so the Total Settings are done last, after all the filters have been executed.
- Fixed bug, when a View doesn’t contain a “Transaction Date” field, then an error was encountered “Invalid column name ‘Date Last Sold’.”. A validation check has been included, if the date dropdown doesn’t contain “Transaction Date”, it will default to “Date Last Sold”, and if this doesn’t exist, then it will default to “No Date Column Selected.
2. Price & Stock Check
- Removed the validation on Location User Rights, so all Locations will be displayed with the Quantities. The below are the Screens where this button is available:
- Main
- Point Of Sales (F10)
- Purchase Documents (F4)
- Receiving (GRV) (F4)
- Sales Documents (F4)
- Delivery Advices (F4)
- Freehand Quotes (F4)
- Stock Pick (F4)
- Shipments (F4)
- Containers (F4)
3. Inventory Picker
- Removed the validation on Location User Rights, so all Locations will be displayed within the Location Dropdown.
- When selecting “Stock Check”, removed the validation on Location User Rights, so all Locations will be displayed with the Quantities.
- Fixed bug, when searching for an Item that contains a “%” symbol, an error is encountered “Error in Like operator: the string pattern ‘%Item%’ is invalid.”.
4. Export Active Reports to Excel
- Fixed bug, removed Cell Merging when executing the Excel Export function.
5. File Attachments
- Fixed bug, when launching the File Browser on the below Processing Screens, the Email couldn’t be sent due to the Customer / Vendor Number not being passed into the control.
- Sales Invoices, Delivery Advices, Sales Orders, Sales Quotes, Freehand Quotes
- Receipts
- Purchase Invoices, Receiving (GRV), Purchase Orders, Requisitions & Quotations
- Payments & Payment Approvals
- Shipments & Containers
- Fixed bug, when selecting “Email”, the email address was being inserted into the “Bcc” box instead of “To” box.
- Fixed bug, when selecting “Email”, after launching Outlook Email, the File Browser was being closed and the Attachments wasn’t being saved to the Document, as well as the File was being deleted from the Directory.
6. General Ledger Account Security
- Fixed bug, when processing Documents, a GL Security Validation was checking if the GL Account existed even though the Home Amount / Foreign Amount was Zero. This logic has changed to only Validate if GL Security exists and the Home Amount / Foreign Amount isn’t Zero.
- Main (Sales Document Picker)
- Fixed bug, speed optimization on the Load Event, by changing the List View Control to a Grid Control.
- Fixed bug, within the Search text box, included a delay, which will allow the User to type before searching, and included the Search Filter within the SQL Static Query.
- The below are the forms that are affected:
- Accounts Receivable
- Sales Invoices (Open, Convert, Convert Delivery Advices)
- Delivery Advices (Open, Convert)
- Sales Orders (Open, Convert)
- Sales Quotes (Open)
- Freehand Quotes (Open)
- Credit Notes (Open, Convert)
- Credit Requests (Open, Apply To Credit Note)
- Contract Billing (Open)
- Warehouse
- Stock Pick (Open, Convert)
- Shipments (Open)
- Containers (Open)
- Point Of Sales
- Sales (Convert Sales Orders, Convert Sales Quotes, Return)
GENERAL LEDGER
Processing
1. Journal Entry
- Fixed bug, when selecting “New”, the “Projects” button is always enabled, instead of only enabling the button when an existing Document is loaded.
- Fixed bug, when entering within the “Account” column, the Account Picker is launched (GL, AP, AR), after entering a search and select “Enter”, the Account Picker closed and reopened, and the Journal Entry row remained blank.
- Fixed bug, when the button “Project” gets disabled, the Menu Option “Projects” was still enabled.
- Fixed bug, when entering within the “GL Contra Account” column, the Account Picker is launched (GL, AP, AR), after entering a search and select “Enter”, the Account Picker closed and reopened, and the Journal Entry row remained blank.
- Fixed bug, when capturing a “GL” row, within the “GL Contra Account”, when selecting a Department, an unhandled error gets encountered and forces the application to be closed.
2. Receipt & Payment Journal
- Fixed bug, when entering within the “Account” column, the Account Picker is launched, after entering a search and select “Enter”, the Account Picker closed and reopened, and the row remained blank.
- Fixed bug, when entering within the “Account” column, the Account Picker is launched, after entering a search and select “Enter”, the Account Picker closed and reopened, and the row remained blank.
- Fixed bug, when the buttons “Project Pmt” and “Project Rec” gets disabled, the Menu Options “Projects Pmt” and “Projects Rec” was still enabled.
- Implemented a new change to the GL Account Finder, the button is now enabled when selecting “Adjust”, which allows the Bank Account to be changed, but will only display the same Currency Bank Accounts.
Maintenance
- Accounts
- When selecting “New” or “Edit”, the “Account Type” and “Account Class” can now be changed.
- Fixed bug, when multiple GL Segments has been setup, and Departments enabled, when Editing an Account, when selecting “OK”, an error is encountered “Text Exceeds Maximum Length”, due to the table (tblAccountsDept) only maintaining a Description length of 20 characters.
Ledger Reports
Transactions
- General Ledger
- Fixed bug, optimized speed issues when loading as a timeout error occurred, as well as duplications were encountered.
- Fixed bug, when a Journal contains the same GL Account number and Amount, the Stored Procedure was retrieving the data by means of a DISTINCT clause, which will only return a single line and discard the duplications. The Stored Procedure has been amended to include the Line Number, so these records won’t be discarded anymore.
- Fixed bug, included all new Export to Excel changes to the Email (Export) function.
- Fixed bug, when using the Search function for a group of Accounts, after selecting “Select All” and launch the Report, the Grouping on the Report was incorrect, so the same GL Account Number was being displayed multiple times.
- Fixed bug, when running the Report for “Historical”, an error is encountered “Incorrect syntax near the keyword ‘AND’.”.
- Fixed bug, the screen height was too big, so on some screens, the “OK” and “Cancel” button couldn’t be seen.
- Fixed bug, when drilling down to a GRV Document, an error was encountered, as it was trying to launch the Purchase Invoice screen instead of the Receiving (GRV) screen.
- Fixed bug, when drilling down to a GRV Document, an error was encountered, as it was trying to launch the Purchase Invoice screen instead of the Receiving (GRV) screen.
- Fixed bug, when drilling down to a Work In Progress or Closed Job Document, no screen was being launched, as these weren’t included within the Drill Down Functionality.
- Fixed bug, due to the merging of branches, existing fixes were overwritten, so the “DISTINCT” was reinserted, causing documents with the same line information to only display one value instead of the correct summed value.
- Fixed bug, when using the Search function for a group of Accounts, after selecting “Select All” and launch the Report, the Grouping on the Report was incorrect, so the same GL Account Number was being displayed multiple times.
2. Cash Book
- Fixed bug, the “Comment” column will now display the Line Comments captured within the Journal Entry and Receipt & Payment Journal screens, instead of using the Header Comment.
- Fixed bug, when selecting “Historical”, additional entries were displaying on the Report, as the Transactions being returned weren’t being filtered by the Historical Year.
- Fixed bug, when drilling down to a “Payment”, the Payments Document Number was displaying the next Payment Number, instead of displaying the actual Document Number selected.
3. Sales Taxes / VAT
- Fixed bug, included all new Export to Excel changes to the Email (Export) function.
- Fixed bug, when selecting “Summary” with the option “Group Amounts by Tax Codes” activated, when selecting “Selected Taxes” with a single Tax Code selected, the report was displaying all Tax Codes.
Departments
1. Department Trial Balance
- Fixed bug, after selecting “Previous” / “Historical” and filter on certain Departments, when selecting “OK” an error is encountered “Conversation failed when converting the nvarchar value ‘1000, 2000’ to data type int.”.
- Fixed bug, the screen height was too big, so on some screens, the “OK” and “Cancel” button couldn’t be seen.
ACCOUNTS PAYABLE
Processing
- Purchase Invoices
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
- Fixed bug, when “Allow Negative Inventory Levels” has been deactivated, after selecting “Adjust”, if there has been Sales Invoices executed, when selecting “Record” an error is encountered when reversing the Purchase Invoice “Transaction Would Leave Inventory in Negatives”.
- Fixed bug, after populating the rows by using the “Multiple Select” on the Inventory Picker, when the User tabs off the Number column that contains an Item, the Inventory Picker screen is launched again.
- Fixed bug, when pressing “Enter” within the “Number” column, the Inventory Picker wasn’t being launched.
- Fixed bug, when tabbing off on the “Number” column which contained a Part Number, the Inventory Picker screen was being launched.
- Fixed bug, when the Accrual Processing has been activated for “Use GRV for Item Cost”, when converting a GRV and the Price gets changed to a higher value, the variance wasn’t being written to the GRV Accrual Account. The below validation checks have now been included:
- Inventory – Use the Variance Account setup within the Account Set.
- Service – Use the Expense Account setup within the Account Set.
- Buyout – Use the Expense (COGS) Account setup within the Account Set.
- Journal Code – Use the Linked Account setup within the Journal Code.
- Fixed bug, when converting GRV’s that contain Serial / Lot Items, if new Items are added and the original GRV Items are removed, when selecting “Record”, the reversing entries for serial / lot numbers weren’t being written to the Serial / Lot Tracking and the Quantities weren’t being recalculated, causing the available On Hand Quantities for the Serial / Lot Numbers to be incorrect.
- Fixed bug, when converting GRV’s that contain Serial / Lot Items, the Quantity couldn’t be changed on the original GRV Items. When the Quantity gets changed now, a message is now displayed to state that the Buy Quantity Has Increased / Decreased, which will allow for the Serial / Lot Numbers to be Increased / Decreased.
- Fixed bug, when converting a GRV that contains Serial Numbers, if the Quantity gets decreased, within the Serial Number Assigning Screen, the ability to Delete Rows wasn’t possible.
- Fixed bug, when converting a GRV that has been setup for “Use GRV for Item Cost”, when selecting “Record”, an error is encountered “Conversion from string ‘InvItem’ to type ‘Integer’ is not valid.”.
- Fixed bug, when the “Accrual Processing” has been activated for “Use Vendor Invoice for Item Cost”, when converting a GRV that contains Serial / Lot Items, if the Serial / Lot Item contains an Outward Movement after the Original GRV was processed (Sales Invoices, Inventory Transfer, Inventory Adjustment), when selecting “Record”, the GRV Reversal Move wasn’t being created, causing the Serial / Lot Numbers to go out of Balance.
- Fixed bug, when the “Accrual Processing” has been activated for “Use GRV for Item Cost”, when converting a GRV that contains Serial / Lot Items, when the Quantity gets changed, when selecting “Record”, the entire Serial / Lot Numbers were being reversed, instead of the Quantity entered, causing the Serial / Lot Numbers to go out of Balance.
- Fixed bug, when the GRV Accruals has been setup as “Use Vendor Invoice for Item Cost”, when converting a GRV that contains Serial Items, after the “Qty” gets changed and the relevant Serial Numbers removed, when selecting “Record”, a warning message gets displayed “Can’t Adjust Serial Items that Contain Subsequent Movement”, which prevented the Invoice from being recorded.
- Fixed bug, when the GRV Accruals has been setup as “Use GRV for Item Cost”, when converting a GRV that contains Serial Items, if partially converted, when loading the document, the remaining quantity is displayed, causing the Assign Serial Numbers screen to be launched, the previously converted Serial Numbers display with a Prefix “PI” within the first column, these Serial Numbers weren’t able to be deleted, which prevented the Invoice from being recorded.
2. Purchase Orders
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
- Fixed bug, after populating the rows by using the “Multiple Select” on the Inventory Picker, when the User tabs off the Number column that contains an Item, the Inventory Picker screen is launched again.
- Fixed bug, when pressing “Enter” within the “Number” column, the Inventory Picker wasn’t being launched.
- Fixed bug, when tabbing off on the “Number” column which contained a Part Number, the Inventory Picker screen was being launched.
- Purchase Orders) – Fixed bug, when a Pricelist contains different Date Ranges, when selecting “Order Form”, an error is encountered “Subquery returned more than 1 value.”.
3. Requisitions & Quotations
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
- Fixed bug, when Purchase Order Approvals have been activated, when two Users who are Approvers, create a Purchase Requisition and Record at the same time, only one of the Purchase Requisitions get converted to two different Purchase Orders.
- Fixed bug, after populating the rows by using the “Multiple Select” on the Inventory Picker, when the User tabs off the Number column that contains an Item, the Inventory Picker screen is launched again.
- Fixed bug, when pressing “Enter” within the “Number” column, the Inventory Picker wasn’t being launched.
- Fixed bug, when tabbing off on the “Number” column which contained a Part Number, the Inventory Picker screen was being launched.
4. Returns
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
5. Payments
- Fixed bug, when selecting “Adjust”, after recording the Payment, the Document Number gets changed to the next available Document Number instead of maintaining the existing Document Number where the adjustment was done.
Payables Reports
Financials
- Vendor Aged
- Fixed bug, included all new Export to Excel changes to the Email (Export) function.
- Fixed bug, once the Summary Report is launched, when drilling down to the Detailed Report, when selecting Export to Excel or Email Excel, then an unhandled error was encountered and the entire application closes.
ACCOUNTS RECEIVABLE
Processing
- Sales Invoices
- Courier Integration
- Fixed bug, the Customer Description was being passed into the Receiver Contact Person tag instead of the Receiver Company tag.
- Fixed bug, included a new Function (fnStripNonNumerics), which will strip all the Non Numeric Characters from the Phone Number before passing into the Receiver Cell tag.
- Fixed bug, the “Suburb” was being passed into Receiver Address 3 tag instead of Receiver Address 4 tag, and “City” was being passed into Receiver Address 4 tag instead of Receiver Address 3.
- Fixed bug, when converting a Sales Order that contains Pick Tickets, the Tax Amount gets recalculated correctly when converting Partial Quantities, but the Tax Amount doesn’t get recalculated correctly on the remainder Back Order Quantities.
- Fixed bug, when the Parent Item has been setup with “Related Items”, when selecting separate Items that contain the same Related Item, the Quantity was being overwritten with the Last Calculated Quantity, instead of generated a separate detail line for each Related Item.
- Fixed bug, when selecting “Related”, the “Quantity” wasn’t being recalculated if the “Use Proportionate” option is activated.
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
- Fixed bug, when a User doesn’t have Access Rights to change the Price, after converting and recording a Sales Order that contains an overall Discount, when selecting “Convert”, the Overall Discount Authorization screen is launched due to the field not being cleared during the Clear Form process.
- Fixed bug, after populating the rows by using the “Multiple Select” on the Inventory Picker, when the User tabs off the Number column that contains an Item, the Inventory Picker screen is launched again.
- Fixed bug, when converting a Delivery Advice that contains an Overall Discount, and the User hasn’t got Access Rights to change the Price, then the Authorization screen kept being launched.
- Fixed bug, when pressing “Enter” within the “Number” column, the Inventory Picker wasn’t being launched. This was related to the fix when tabbing off on the “Number” column which contained a Part Number, but the Inventory Picker screen still launched.
- Fixed bug, when Related Items exist, when using Decimals (0.5), the Related Item wasn’t being added to the grid.
- Fixed bug, when converting Delivery Advices that contain Serial / Lot Items, if new Items are added and the original Delivery Advice Items are removed, when selecting “Record”, the reversing entries for serial / lot numbers weren’t being written to the Serial / Lot Tracking and the Quantities weren’t being recalculated, causing the available On Hand Quantities for the Serial / Lot Numbers to be incorrect.
- Fixed bug, when converting Delivery Advices that contain Serial / Lot Items, the Quantity couldn’t be changed on the original Delivery Advice Items. When the Quantity gets changed now, a message is now displayed to state that the Sell Quantity Has Increased / Decreased, which will allow for the Serial / Lot Numbers to be Increased / Decreased.
- Fixed bug, when converting a Delivery Advice that contains Lot Numbers, when viewing the Assigned Lot Numbers, the Available Lot Numbers were displaying the incorrect Quantity Available, as it was subtracting the Assigned Quantity from the Available List Quantity.
- Fixed bug, when converting a Delivery Advice that contains Lot Numbers, when changing the Quantity, the Assigned Lot Number Quantities weren’t being recalculated when changing the Grids Quantity.
- Fixed bug, when a Lot Item has been setup for Embedded Barcoding, within the Assigning Lot Number screen, if the User inputs the Lot Number instead of scanning the Barcode or selecting from the Available list, a warning message kept being displayed “Barcode Prefix Cannot Be Matched (E) – Barcode Prefix (L)”.
- Fixed bug, when converting a Delivery Advice that contains a Lot Item, when amending the Quantity, if the Available Lot Number Quantity is the same as the Original Lot Quantity, then the Lot Number wasn’t appearing within the Available Lot Number list, and if the Quantity gets amended to the Required Quantity within the Assigning Lot Number screen, then a warning message gets displayed “The Entered Quantity (12.00) Cannot Exceed The Stock Quantity Available (10.00).”.
- Fixed bug, when converting multiple Sales Orders / Sales Quotes, once the data has been populated, the “Reference #” and “Additional Info” text boxes were still disabled.
- Fixed bug, when converting a Delivery Advice that contains Serial / Lot Items, if the Serial / Lot Item contains an Inward Movement after the Original Delivery Advice was processed (Purchase Invoices, Inventory Transfer, Inventory Adjustment), when selecting “Record”, the Delivery Advice Reversal Move wasn’t being created, causing the Serial / Lot Numbers to go out of Balance.
- Fixed bug, when converting a Delivery Advice that contains Serial Items, after the “Qty” gets changed and the relevant Serial Numbers removed, when selecting “Record”, a warning message gets displayed “Can’t Adjust Serial Items that Contain Subsequent Movement”, which prevented the Invoice from being recorded.
- Fixed bug, when the setting (Warning / Block) has been selected for “Sales Order / Works Order Processing with Unavailable Inventory”, the validation check was using the On Hand Quantity and not the actual Available Quantity.
2. Delivery Advices
- Fixed bug, when converting a Sales Order that contains Pick Tickets, the Tax Amount gets recalculated correctly when converting Partial Quantities, but the Tax Amount doesn’t get recalculated correctly on the remainder Back Order Quantities.
3. Sales Orders
- Courier Integration
- Fixed bug, the Customer Description was being passed into the Receiver Contact Person tag instead of the Receiver Company tag.
- Fixed bug, included a new Function (fnStripNonNumerics), which will strip all the Non Numeric Characters from the Phone Number before passing into the Receiver Cell tag.
- Fixed bug, the “Suburb” was being passed into Receiver Address 3 tag instead of Receiver Address 4 tag, and “City” was being passed into Receiver Address 4 tag instead of Receiver Address 3.
- Fixed bug, when the Parent Item has been setup with “Related Items”, when selecting separate Items that contain the same Related Item, the Quantity was being overwritten with the Last Calculated Quantity, instead of generated a separate detail line for each Related Item.
- Fixed bug, when selecting “Related”, the “Quantity” wasn’t being recalculated if the “Use Proportionate” option is activated.
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
- Fixed bug, when Adjusting a Document that contains a Service Item, when the database is installed on a SQL Server 2012 instance, when selecting “Record”, an error is encountered “Conversion from type ‘DBNull’ to type ‘String’ is not valid.”.
- Fixed bug, after populating the rows by using the “Multiple Select” on the Inventory Picker, when the User tabs off the Number column that contains an Item, the Inventory Picker screen is launched again.
- Fixed bug, when pressing “Enter” within the “Number” column, the Inventory Picker wasn’t being launched. This was related to the fix when tabbing off on the “Number” column which contained a Part Number, but the Inventory Picker screen still launched.
- Fixed bug, when Related Items exist, when using Decimals (0.5), the Related Item wasn’t being added to the grid.
4. Sales Quotes
- Fixed bug, when the Parent Item has been setup with “Related Items”, when selecting separate Items that contain the same Related Item, the Quantity was being overwritten with the Last Calculated Quantity, instead of generated a separate detail line for each Related Item.
- Fixed bug, when selecting “Related”, the “Quantity” wasn’t being recalculated if the “Use Proportionate” option is activated.
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
- Fixed bug, after populating the rows by using the “Multiple Select” on the Inventory Picker, when the User tabs off the Number column that contains an Item, the Inventory Picker screen is launched again.
- Fixed bug, when pressing “Enter” within the “Number” column, the Inventory Picker wasn’t being launched. This was related to the fix when tabbing off on the “Number” column which contained a Part Number, but the Inventory Picker screen still launched.5.
- Fixed bug, when Related Items exist, when using Decimals (0.5), the Related Item wasn’t being added to the grid.
5. Freehand Quotes
- Fixed bug, when the Parent Item has been setup with “Related Items”, when selecting separate Items that contain the same Related Item, the Quantity was being overwritten with the Last Calculated Quantity, instead of generated a separate detail line for each Related Item.
- Fixed bug, when selecting “Related”, the “Quantity” wasn’t being recalculated if the “Use Proportionate” option is activated.
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
- Fixed bug, when using the Copy Freehand Quote History function, when selecting an Item that doesn’t exist within the Inventory Masterfile, then an error is encountered “Invalid parameters for Select method.”.
- Fixed bug, after populating the rows by using the “Multiple Select” on the Inventory Picker, when the User tabs off the Number column that contains an Item, the Inventory Picker screen is launched again.
- Fixed bug, when pressing “Enter” within the “Number” column, the Inventory Picker wasn’t being launched. This was related to the fix when tabbing off on the “Number” column which contained a Part Number, but the Inventory Picker screen still launched.
- Fixed bug, when Related Items exist, when using Decimals (0.5), the Related Item wasn’t being added to the grid.
- Fixed bug, when creating a new Preferred Vendor, when double-clicking the Preferred Vendor within the Grid for selection, the Vendor is duplicated, so when selecting “Convert AP”, the Item will be duplicated within the grid.
6. Credit Notes
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
- Fixed bug, when a Lot Item has been setup for Embedded Barcoding, within the Assigning Lot Number screen, if the User inputs the Lot Number instead of scanning the Barcode or selecting from the Available list, a warning message kept being displayed “Barcode Prefix Cannot Be Matched (E) – Barcode Prefix (L)”.
7. Credit Requests
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
8. Receipts
- Fixed bug, when the “Allow Receipt Processing to Sales Orders / Credit Requests” has been activated, when selecting “Auto Match” or “Match All”, the first Credit Request kept being changed to the same Receipt Amount as the last Credit Request or Sales Order, this was due to the Unique Key “LngID” containing a Zero for the Customer Transaction ID, as this isn’t contained in the table (tblCustTrans), so a GUID has been included as the Unique Key.
- Fixed bug, when selecting “Search”, if the selected Customer isn’t setup as consolidated, the “Customer” column was being displayed after the grid gets reloaded.
- Fixed bug, after a Customer has been selected and the grid has been loaded, when selecting the Customer Picker button, then an unhandled error gets encountered and closes the entire application.
- Fixed bug, when Receipt Amounts have been allocated, after processing a Credit Request, the grid gets reloaded and the Allocated Amounts are added, but the Receipt Totals were displaying Zero instead of being recalculated.
- Fixed bug, after opening an existing Receipts, after selecting “Reverse”, once the “OK” button gets selected, an unhandled error is encountered and the entire application closes.
9. Collection Letters
- Fixed bug, changed the Static SQL Calls to a Stored Procedure, when stepping through the grid where large data exists, a Server Timeout error is encountered.
- Included a new “Refresh” button, as the grid keeps populating as the Date is being selected, so now the User can select the “As At” Date and then Refresh the Data.
Batch Sending
- Courier Waybill Audit Trail
- Fixed bug, the Customer Description was being passed into the Receiver Contact Person tag instead of the Receiver Company tag.
- Fixed bug, included a new Function (fnStripNonNumerics), which will strip all the Non Numeric Characters from the Phone Number before passing into the Receiver Cell tag.
- Fixed bug, the “Suburb” was being passed into Receiver Address 3 tag instead of Receiver Address 4 tag, and “City” was being passed into Receiver Address 4 tag instead of Receiver Address 3.
Maintenance
- Contract Billing
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
Receivables Reports
Financials
1. Customer Aged
- Fixed bug, included all new Export to Excel changes to the Email (Export) function.
- Fixed the “ORDER BY” clause when running the Report for “Customer Name”, as it the ordering goes out when different Customer Numbers contain the same Customer Name.
- Fixed bug, once the Summary Report is launched, when drilling down to the Detailed Report, when selecting Export to Excel or Email Excel, then an unhandled error was encountered and the entire application closes.
2. Customer Statements
- Fixed bug, when selecting “Brought Forward”, the “Display” options get disabled, but the “Document Date” was displaying as active instead of the “Document Due Date”, as the Report gets run using the Document Due Date.
- Fixed bug, when selecting “Balance Forward”, the aging buckets weren’t displaying the same totals as the Customer Aging & Customer Statement (Open Item) Reports, as the calculations were one day out.
- Sales Trends by Customer
- Fixed bug, when selecting “Export As”, an error was encountered “Overload resolution failed because no Public ‘Export’ is most specific for these arguments.”.
INVENTORY
Processing
1. Inventory Enquiries
- Within the “Locations” tab, changed the column heading from “Inactive” to “Active”.
- Fixed bug, within the “Pricing” tab, removed the date format of “Short Date” on the Start Date & End Date, as it wasn’t displaying the Pricelists where the End Date was set to “01/01/2020”, as it was stating that “01/01/2020” wasn’t greater than the “30/04/2018”.
- Fixed bug, within the “Pricing” tab, included an “ORDER BY” clause within the SQL Query, to order by Pricelist Name.
2. Adjustments
- Fixed bug, when capturing a negative Quantity, the Amount wasn’t being recalculated.
- Fixed bug, the next Document Number gets fetched when loading the form, this has now been changed on the Clear function, as well as when selecting “Record”.
3. Issue Requisition
- Fixed bug, the next Document Number gets fetched when loading the form, this has now been changed on the Clear function, as well as when selecting “Record”.
4. Internal Requisition
- Fixed bug, when Adjusting a document, after selecting “Record”, the Allocated Quantity wasn’t being recalculated.
- Fixed bug, when Adjusting a document, after selecting “Record”, the next Document Number was being increased by one.
- Fixed bug, the next Document Number gets fetched when loading the form, this has now been changed on the Clear function, as well as when selecting “Record”.
6. Transfers
- Fixed bug, when the Inventory Integration Method has been activated for “Periodic (Non-Integrated)”, an imbalance was being encountered when recording a transaction that will move the entire On Hand Quantity for a Location, but a Variance was encountered and now the Variance Account has been included within the allowed GL Accounts. The rule has been changed and also affects the below processing screens:
- Inventory Adjustments
- Inventory Assembly
- Inventory Production Job
- Inventory Repackaging
- Manufacture Job Close
- Manufacture Jobs
- Manufacture Issue Work In Progress
- Point Of Sales
- Purchase Invoices
- Receiving (GRV)
- Sales Invoices
- Delivery Advices
7. Stock Count
- Fixed bug, when selecting a “Location”, all Items were being displayed, instead of only the Items that have been activated for that Location.
- Fixed bug, when selecting “Print”, when there is a large number of Rows, when Extended Descriptions exist for the Items, the function to convert the HTML to a Rich Text Format was taking a large amount of time and crashing the application, but this converting stage isn’t required for Internal Reports, so now has been removed.
8. Stock Count PDT
- Fixed bug, when selecting “Print”, when there is a large number of Rows, when Extended Descriptions exist for the Items, the function to convert the HTML to a Rich Text Format was taking a large amount of time and crashing the application, but this converting stage isn’t required for Internal Reports, so now has been removed.
9. Inventory Forecasting
- A Tool Tip (“Used to determine minimum level (Days Sales x Order Lead Time + Safety Factor).”) has been included for column “Safety Factor %”.
- A Tool Tip (“Used to determine minimum level (Days Sales x Order Lead Time + Safety Factor).”) has been included for column “Order Lead Time”.
- A Tool Tip (“Number of Days Stockholding (Days Sales x Average Daily Sales + Min Qty = Max Qty).”) has been included for column “Days Sales”.
- Removed the Label & Control for “Stock Days to Forecast (Min Qty)”.
- Included a new Group box “Update Masterfile / Refresh Grid (Selected Items Only”, which maintains the “Update” or “Refresh” on the Fields “Safety Factor Percentage“, “Order Lead Time” and “Days Sales in Stock”.
- When selecting “Inventory Forecast Inactive” button, these Items are displayed with the “Select” as deselected. If the User selects this Items, if they select the “Inventory Forecast Inactive” button, then the Item gets deselected and hidden.
- When the “Category” get changed, the grid is automatically refreshed, instead of selecting the “Load” button.
- Fixed bug, when Items have been excluded from Forecasting, when Loading the grid, these Items are made invisible, and if an excluded Item is hidden on the first row, the Warehouse Information was still displaying the breakdown for this Item and not the first visible Item.
- Fixed bug, when selecting all the rows for the the “Selected” column, when selecting “Exclude Item Forecasting” Items, these rows were being made invisible but select had the “Select” column selected, so when selecting “Update”, these Items were being included within the Update function.
- Fixed bug, the Tooltips will be displayed when the Mouse hovers over the relevant Column Heading.
10. Repackaging
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grids.
Processing
1. Assembly
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grids.
2. Works Order
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
- Fixed bug, when the setting (Warning / Block) has been selected for “Sales Order / Works Order Processing with Unavailable Inventory”, the validation check was using the On Hand Quantity and not the actual Available Quantity.
Maintenance
1. Inventory & Services
- Changed the way the functionality was handling the Location “Inactive” flag. Within the tab “Location”, changed the column heading from “Inactive” to “Active”. Included the below Validation Rules:
- If the “Account Set” column is captured, then the “Active” column is activated.
- If the “Active” column is deactivated, then the “Account Set” column is made Blank.
- The “Account Set Required (Location)” label will only be displayed after checking the Activated Locations.
- Fixed bug, optimized speed issues when loading the form.
- Fixed bug, within the “BOM” tab, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
- Fixed bug, within the “Related Items” tab, the “Quantity” column wasn’t saving Decimals, as it was converting the Quantity to an Integer.
2. Pricelists
- Fixed bug, when selecting “Set Pricing”, optimized speed issues after selecting the Date Filter, Selection and Loading processes.
- When selecting “Set Pricing”, when the Pricelist filter has been selected for “Multiple”:
- Fixed bug, when a Date filter has been selected, the Loaded Pricelists were displaying all Price Lists which fall in between the Date Filter and not only the Date Filter selected.
- Fixed bug, when changing between Pricelists, the input data wasn’t being maintained, due to the same Row Indexes being stored for the different Pricelists, so uses the first Row where the Row Index matches.
- Fixed bug, when selecting “Calculate”, an error was encountered “Server Timeout”. Speed Optimization has been included during the “Calculate” process, and the Progress Form is now displayed.
- Fixed bug, when a Date filter has been selected, the Loaded Pricelists were displaying all Price Lists which fall in between the Date Filter and not only the Date Filter selected.
- When selecting “Set Pricing”
- Fixed bug, when selecting “Calculate”, an error was encountered “‘Invalid Argument Used. Value’ should be between minimum and maximum.”.
- When selecting “Load” or selecting a Pricelist within the Grid, a Wait Cursor has been included to notify the User that the screen is busy loading.
- Fixed bug, when the Pricelist filter has been selected for “Multiple”, when selecting “Calculate”, if a Pricelist hadn’t been selected, then the new calculations weren’t being done.
- Fixed bug, when the Pricelist filter has been selected for “Multiple”, when selecting “Export”, no rows were being displayed within the Excel Spreadsheet, as the incorrect Grid was being exported.
3. Item Renumbering
- Fixed bug, when renumbering an Item that has been setup as a “Related Item” or “Container Item” within the Inventory Masterfile, the Part Number wasn’t being Updated, so still displayed the original Part Number.
Inventory Reports
Financials
1. Value by Location Summary
- Fixed bug, optimized speed issues when loading the Report.
2. Inventory Cost Analysis
- Fixed bug, included all new Export to Excel changes to the Email (Export) function.
Transactions
1. Ledger by Location
- Fixed bug, optimized speed issues when loading the Report.
2. Inventory Adjustments
- Fixed bug, when running the Report with a large data return, when Extended Descriptions exist for Items, the function to convert the HTML to a Rich Text Format was taking a large amount of time and crashing the application, but this converting stage isn’t required for Internal Reports, so now has been removed.
3. Internal Requisitions
- Fixed bug, when running the Report with a large data return, when Extended Descriptions exist for Items, the function to convert the HTML to a Rich Text Format was taking a large amount of time and crashing the application, but this converting stage isn’t required for Internal Reports, so now has been removed.
4. MRP Report
- Fixed bug, within the “Summary Of Components” section, if the same Item is used within multiple BOM’s, then the Quantities were being summed up (On Hand, Purchase Orders, Sales Orders, Reorder). The “To Order” calculation was changed to be the same as the Manufacturing MRP Report, as the Maximum Level wasn’t being utilized within the formula.
Lists
- Inventory & Services List
- Fixed bug, when running the Report with a large data return, when Extended Descriptions exist for Items, the function to convert the HTML to a Rich Text Format was taking a large amount of time and crashing the application, but this converting stage isn’t required for Internal Reports, so now has been removed.
- Fixed bug, when Filtering by Category / Items / Services / All, the Items were being duplicated, so an additional criteria was required within the SQL Statements to include only Active Inventory Locations (New Feature Included).
2. Stock Count Sheets
- Fixed bug, optimized speed issues when loading the Report.
- Fixed bug, when running the Report with a large data return, when Extended Descriptions exist for Items, the function to convert the HTML to a Rich Text Format was taking a large amount of time and crashing the application, but this converting stage isn’t required for Internal Reports, so now has been removed.
WAREHOUSE
Shipping
- Shipments
- When selecting “Load INV”, included a Date Filter within the Selection screen, which will default the Dates to the Current Financial Year.
- Fixed bug, when selecting “Labels”, the Shipment doesn’t use a Location, but when selecting “OK”, a warning message was being displayed “Location cannot be blank”, and when selecting “Continue” an error is encountered “ExecuteReader requires an open and available Connection.”.
2. Shipment Containers
- Fixed bug, when selecting “Load SH”, if no “Customer” has been selected, the List View is blank, and when selecting “OK”, an unhandled error gets encountered and the entire application closes.
- Fixed bug, when selecting “Labels”, the Shipment doesn’t use a Location, but when selecting “OK”, a warning message was being displayed “Location cannot be blank”, and when selecting “Continue” an error is encountered “ExecuteReader requires an open and available Connection.”.
MANUFACTURING
Processing
- Process Jobs
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grids.
- Fixed bug, when selecting “Pick List”, if Lot Items exists, then an error is encountered “Column ‘bitDimensionExist’ does not allow nulls.”.
- Fixed bug, within the “Components” grid, if the same Item exists with different Locations, when selecting “Print”, an error gets encountered “Failed to enable constraints.”.
- Fixed bug, when a Customer has been selected and contains an email length greater than 50 characters (Main, Invoices, Statements), then an error gets encountered “Failed to enable constraints.”.
2. Issue Work In Progress
- Fixed bug, when Opening an existing Document, within the “Machinery” tab, the “Variable Hrs” was being populated with the Variable Rate instead of the Variable Hours.
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
- Fixed bug, when entering a “Return Qty” for a Serial / Lot Item, when the Serial / Lot Number Assigning screen gets launched, the previous issued Serial / Lot Numbers will be displayed within the List View.
- Fixed bug, when a Job contains multiple Issues and Returns for a Serial / Lot Number, when returning stock, when the Serial / Lot assigning screen gets launched, the Quantity being displayed was incorrect, as it was adding the Return Quantities instead of subtracting them.
Maintenance
- Bill Of Materials
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grids.
- Fixed bug, when selecting the Assembled Item, the Location dropdown wasn’t displaying the Defaulted Location setup for the Item.
Manufacturing Reports
Transactions
- Work In Progress
- Fixed bug, the “Jobs” section was displaying all Job Types instead of only the Type “Work In Progress”.
- Fixed bug, when launching the selection screen, changed the defaults to “All Customers”, “All Jobs” and “All Work Centres”.
- Fixed bug, when running the Report with a large data return, when Extended Descriptions exist for Items, the function to convert the HTML to a Rich Text Format was taking a large amount of time and crashing the application, but this converting stage isn’t required for Internal Reports, so now has been removed.
2. Production Variance
- Included a new report to compare the Assembled Items Manufactured Quantities and Values to the Requested Quantities and Values.
- Manufacturing Variance
- Included a new report to compare the Components Manufactured Quantities and Values to the Requested Quantities and Values.
POINT OF SALES
Processing
- Sales
- Fixed bug, when Multi Bins haven’t been activated, and no Users exist, when opening a Company the Default Location becomes “DEFAULT”, so when another Location has been setup as the Default Location, this Location wasn’t being displayed within the Grid.
- Fixed bug, when Converting a Sales Order that contains Pick Tickets, once the User has completed with this Document, if the User selects a Sales Quote to Convert, when selecting “Record”, the message is still displayed for the Pick Ticket on the previous Sales Order Number, as these variables weren’t being cleared.
BUSINESS
Business Reports
Project / Job Costing
1. Sales Matrix
- Fixed bug, the “Qty” fields weren’t displaying Decimals.
- Fixed bug, the “Value” fields were being cut off if too long.
2. Cost Matrix
- Fixed bug, the Journal Entry Allocations for the “GL” Module weren’t being included within the Report.
- Fixed bug, the “Qty” fields weren’t displaying Decimals.
- Fixed bug, the “Value” fields were being cut off if too long.
- Fixed bug, included a validation to only include Revenue & Expense GL Accounts.
3. Combined Matrix
- Fixed bug, the Journal Entry Allocations for the “GL” Module weren’t being included within the Report.
- Fixed bug, the “Qty” fields weren’t displaying Decimals.
- Fixed bug, the “Value” fields were being cut off if too long.
4. Actual VS Budget
- Fixed bug, the Journal Entry Allocations for the “GL” Module weren’t being included within the Report.
- Fixed bug, the “Qty” fields weren’t displaying Decimals.
- Fixed bug, the “Value” fields were being cut off if too long.
CONTROL PANEL
Company Setup
- Company Options
- Within the “Naming Conventions” tab, renamed the tab from “Various Naming Conventions” to “General Naming Conventions”.
Company Administration
- Exclusive Mode
- Fixed bug, when selecting this option, exclusive mode couldn’t be executed and a warning message kept being displayed “Unable to obtain exclusive mode at this time. Please ensure all users are out of the system.”. This issue was also being encountered within the Company Upgrade function.
Import & Export
- Inventory
- Fixed bug, when selecting “Get Data”, after amending and select “Import”, an error was encountered “Conversion from type ‘DBNull’ to type ‘String’ is not valid.”.
1. Inventory Locations
- Included a validation check, so when selecting “Import”, if the “bitInactive” is “False”, then the Account Set will be updated with a NULL, as this is required if not an Active Location.
2. Inventory Images
- Fixed bug, when trying to Import a large amount of Images, not all the Images are imported.
3. Manufacture BOM
- Fixed bug, included the two missing columns “bitBOMPrintSO” & “bitBOMPrintDN”. Will fetch these fields when selecting “Get Data”, will validate the columns when selecting “Load File”, and will Insert or Update the columns when selecting “Import”, as previously when selecting “Import” an error was encountered “Column name or number of supplied values does not match table definition.”.
4. Sales Data
- Fixed bug, when selecting the Item Type “Orders (Game Template)”, the column numbering was hardcoded, and the Portal has changed the column structure, causing the “Load File” to fail, so now the Columns are now found and set as a Variable, which is used when Loading the Data.
Data Conversion
- Pastel Partner Data Extractor
- Fixed bug, when running the Customer Invoice History / Vendor Invoice History / Customer Open Items / Vendor Open Items, the fetching of the Foreign Flag has been changed from the Transactions, now fetches the Flag by using the Currency Code from the Customer / Vendor Masterfile.
HELP
Help & Support Options
- Import Templates
- Within the “Ent_InventoryLocation.xls” template, included additional rows to show that the “Account Set” column doesn’t require an entry if the “Inactive” column is set to “True”.
- Fixed bug, within the “Ent_ManufactureBOM.xls” template, included the two missing columns “bitBOMPrintSO” & “bitBOMPrintDN”, as these were the new fields added to the table.
- Within the template “Ent_JournalEntries.xls”, included the Department as an example, with a comment “To Add Department in GL Module Use This Format (Account / Department)”.
