Release Notes: V18.4.410.58.26

NB: If you or a client is using a prior version of V410.58, then you will need to go into Data Integrity and run “Reinstall Stored Procedures”.

Palladium Enterprise V10 Release 2

ADDITIONAL FIXES

  1. General Ledger (Cash Book Report) – 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.
  2. Accounts Payable (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.”.

 

CURRENT PALLADIUM PROJECT CHANGES

Palladium Enterprise (V18.4.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.
  1. 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)
  1. 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.”.
  1. Export Active Reports to Excel
  • Fixed bug, removed Cell Merging when executing the Excel Export function.
  1. 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.
  1. 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.
  1. 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.
  1. 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

  1. 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

  1. 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.
  1. 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.
  1. 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

  1. 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.
  1. 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.”.
  1. 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.
  1. 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.
  1. 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

  1. 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

  1. 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.
  1. 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.
  1. 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.
  1. 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.
  • Fixed bug, when Related Items exist, when using Decimals (0.5), the Related Item wasn’t being added to the grid.
  1. 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.
  1. 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)”.
  1. 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.
  1. 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.
  1. 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

  1. 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

  1. 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.
  1. 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.
  1. 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.
  1. Adjustments
  • Fixed bug, when capturing a negative Quantity, the Amount wasn’t being recalculated.
  1. 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
  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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.

 

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.
  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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

  1. 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).
  1. 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

  1. 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.”.
  1. 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.”.

 

MANUFCTURING

Processing

  1. 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.”.
  1. 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

  1. 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

  1. 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.
  1. Production Variance
  • Included a new report to compare the Assembled Items Manufactured Quantities and Values to the Requested Quantities and Values.
  1. Manufacturing Variance
  • Included a new report to compare the Components Manufactured Quantities and Values to the Requested Quantities and Values.

 

POINT OF SALES

Processing

  1. 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.
  1. 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.
  1. 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.
  1. 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

  1. Company Options
  • Within the “Naming Conventions” tab, renamed the tab from “Various Naming Conventions” to “General Naming Conventions”.

 

Company Administration

  1. 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

  1. 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.
  1. Inventory Images
  • Fixed bug, when trying to Import a large amount of Images, not all the Images are imported.
  1. 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.”.
  1. Sales Data
  • Fixed bug, when selecting the Item Type “Orders (Game Template)”, the column numbering was hard coded, 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

  1. 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

  1. 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)”.

 

Release Notes: V18.4.410.58.25

NB: If your or a client is using a prior version of V410.58, then you will need to go into Data Integrity and run “Reinstall Stored Procedures”.

Palladium Enterprise V10 Release 

ADDITIONAL FIXES

  1. 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)
  1. Point Of Sales (Sales) – 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.

CURRENT PALLADIUM PROJECT CHANGES

Palladium Enterprise (V18.4.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.
  1. 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)
  1. 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.”.
  1. Export Active Reports to Excel
  • Fixed bug, removed Cell Merging when executing the Excel Export function.
  1. 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.
  1. 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.
  1. 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.
  1. 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

  1. 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

  1. 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.
  1. 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.
  1. 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

  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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

  1. 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

  1. 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.
  1. 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.
  1. 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.
  1. 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.
  • Fixed bug, when Related Items exist, when using Decimals (0.5), the Related Item wasn’t being added to the grid.
  1. 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.
  1. 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)”.
  1. 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.
  1. 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.
  1. 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

  1. 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

  1. 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.
  1. 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.
  1. 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.
  1. Adjustments
  • Fixed bug, when capturing a negative Quantity, the Amount wasn’t being recalculated.
  1. 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
  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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.

 

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.
  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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

  1. 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).
  1. 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

  1. 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.”.
  1. 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

  1. 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.”.
  1. 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

  1. 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

  1. 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.
  1. Production Variance
  • Included a new report to compare the Assembled Items Manufactured Quantities and Values to the Requested Quantities and Values.
  1. Manufacturing Variance
  • Included a new report to compare the Components Manufactured Quantities and Values to the Requested Quantities and Values.

POINT OF SALES

Processing

  1. 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.
  1. 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.
  1. 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.
  1. 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

  1. Company Options
  • Within the “Naming Conventions” tab, renamed the tab from “Various Naming Conventions” to “General Naming Conventions”.

Company Administration

  1. 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

  1. 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.
  1. Inventory Images
  • Fixed bug, when trying to Import a large amount of Images, not all the Images are imported.
  1. 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.”.
  1. Sales Data
  • Fixed bug, when selecting the Item Type “Orders (Game Template)”, the column numbering was hard coded, 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

  1. 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

  1. 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)”.

 

Your business may be battling to compete because of this common misperception

Common misunderstandings about functionality and affordability of ERP may well be holding your business back, says Stephen Corrigan, MD of Palladium

Imagine competing in a high-stakes chess game, where your opponent has real-time access to strategic insights as the game progresses – guiding them as to which move to make next.

Your chances of staying in the game would be minimal at best.

But, the scary truth is that competing in any business environment without a true ERP solution to aid your progress is even riskier. And the stakes are much, much higher.

Think of it this way – if you sell a product at the wrong price for just six weeks it could sink your business. 

What you may not realise though is that the technology to avoid this through real-time business management does exist, and it exists in enterprise resource planning (ERP) solutions that are highly affordable for businesses of any size.

Outdated systems create misperceptions

The problem is that you simply wouldn’t know this, because legacy software providers are still selling outdated and ineffective technology that leaves companies with a completely incorrect perception of what ERP should do and how much it should cost.

Part of the misperception is that as a smaller business you can’t afford a system that manages everything from one place. So you acquire a number of smaller systems which need to be managed manually. You think you can’t afford the bigger, more sophisticated system, but that simply isn’t true.

The cost of software and data is actually coming down every year. With a system like Palladium, for example, the number of features the system provides increases exponentially each year in relation to the cost.

Any business can afford ERP

And your business can get monthly subscriptions to ‘pay as you go’ for ERP. In fact, Palladium hosts software on the cloud, so your company can forego the cost of a server, which has traditionally been a major inhibitor to implementing ERP.

Because ERP systems like Palladium can be deployed on the cloud, they’re also scalable. This means that the system grows with your business, so you don’t have the cost of rolling out a new system when your needs outgrow the current one.

You also may not realise the extent to which ERP can transform your company’s operations and, in turn, even the behaviour of your workforce.  

For example, Palladium has developed a feature that helps your business manage cancelled orders. So whenever an order gets cancelled, the system asks for a reason why, enabling you to improve your win rate. And suddenly employees, who have previously been more admin-focused are more sales-focused, because they know their performance is being monitored.

It’s about creating features to change the game

There are an endless number of similar features that Palladium has created to help your business improve its turnover, increase its margins and enhance its operational efficiencies. From auto-prompts that remind the sales team to upsell complementary items to clients, to a function that automatically sends copies of customer invoices with e-mailed statements in order to increase cash flow, these features bring a great deal of common sense and efficiency into the way your business is run.

But, most companies just don’t realise ERP is capable of half these functions, because legacy systems simply haven’t been designed with the goal of improving business operations in mind.

The result is that you may well be doing reactive reporting rather than proactive management. You acquire an accounting software package because your auditor recommends it to you and become trapped in a process of having to try mould your business around the software. What you may not realise is that in this day and age the software should be able to adapt to your business needs – as is the case with modern systems like Palladium.

Switching over is easy

On the other hand, you might already have realised that your business is being held back by outdated software, but you are wary of rectifying the situation because you know the failure rate of switching over to ERP is high.

In truth though, these failures are largely the result of companies handling implementation badly on broad ERP scales. But, with our data conversion and import utilities, it’s easy for systems like Palladium to import  the relevant data.

At the end of the day, the pressures your business faces on a daily basis – from rising cost pressures to growing customer demands – are only going to increase.

To remain relevant, companies big and small need every available tool at their disposal. And so the question is not whether your business can afford to have ERP, but rather whether it can afford not to?

 

 

Release Notes – V10R1.18.6.310.51

Palladium Enterprise (V18.6.310.51):  Current Project Changes

MAIN

  1. Inventory Picker
  • 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.”.

ACCOUNTS RECEIVABLE

Processing

  1. Sales Orders
  • 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.”.

 


Release Notes – V10R2.18.4.410.58.14

Palladium Enterprise V10 Release 2: Additional Fixes 

  1. Accounts Receivable (Sales Invoices) – 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.
  2. Accounts Receivable (SI, SO, SQ, FHQ) – 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.
  3. Accounts Receivable (PI, PO, PR)
  • 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.
  1. Manufacturing (Issue Work In Progress) – 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.
  2. Inventory (Stock Count Sheets 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.
  3. Inventory (Inventory Adjustments 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.
  4. Inventory (Internal Requisitions 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.
  5. Inventory (Inventory & Services List 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.
  6. Manufacturing (Work In Progress 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.
  7. Inventory (Stock Count) – 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. Inventory (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. Accounts Receivable (Sales Orders) – 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.”.
  10. Help (Import Templates) – Fixed bug, included the two missing columns “bitBOMPrintSO” & “bitBOMPrintDN”, as these were the new fields added to the table.
  11. Control Panel (Import & Export 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.”.
  12. Inventory (Inventory Forecasting)
  • 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.
  1. Accounts Receivable (Sales Invoices) – 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.
  2. Help (Import Templates) – 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)”.
  3. Accounts Receivable (Freehand Quotes) – 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.”.
  4. Accounts Receivable (SI, SO, SQ, FHQ) – 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.
  5. Accounts Payable (PI, PO, PR) – 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.
  6. Main (Inventory Picker) – 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.”.
  7. Control Panel (Import & Export Inventory Images) – Fixed bug, when trying to Import a large amount of Images, not all the Images are imported.
  8. Manufacturing (Issue Work In Progress) – 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.

Palladium Enterprise (V18.4.410.58): Current Project Changes

MAIN

  1. Business Intelligence
  • Fixed bug, there were Refreshing Issues throughout all Cubes.
  1. 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)
  1. 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.”.
  1. Export Active Reports to Excel
  • Fixed bug, removed Cell Merging when executing the Excel Export function.

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.
  1. 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.

 

Ledger Reports

  1. 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.
  1. 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.
  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

  1. 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.
  1. 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.
  1. 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.
  1. 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.

Payables Reports

  1. Vendor Aged
  • Fixed bug, included all new Export to Excel changes to the Email (Export) function.

ACCOUNTS RECEIVABLE

Processing

  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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.

Batch Sending

  1. 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

  1. 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

  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.
  1. Customer Sales Trends
  • 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.
  1. 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
  1. 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.
  1. 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.
  1. 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.
  1. 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.
  1. 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.

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 Blak.
    • 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.
  1. Pricelists
  • Fixed bug, when selecting “Set Pricing”, optimized speed issues after selecting the Date Filter.

Inventory Reports

  1. Value by Location Summary
  • Fixed bug, optimized speed issues when loading the Report.
  1. Ledger by Location
  • Fixed bug, optimized speed issues when loading the Report.
  1. Inventory Cost Analysis
  • Fixed bug, included all new Export to Excel changes to the Email (Export) function.
  1. 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.
  1. 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.
  1. 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.
  1. 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

  1. 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.”.
  1. 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

  1. 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.”.
  1. 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

  1. 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 drop-down wasn’t displaying the Defaulted Location setup for the Item.

Manufacturing Reports

  1. 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.
  1. Production Variance
  • Included a new report to compare the Assembled Items Manufactured Quantities and Values to the Requested Quantities and Values.
  1. Manufacturing Variance
  • Included a new report to compare the Components Manufactured Quantities and Values to the Requested Quantities and Values.

POINT OF SALES

Processing

  1. 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.

BUSINESS

Business Reports

  1. Sales Matrix
  • Fixed bug, the “Qty” fields weren’t displaying Decimals.
  • Fixed bug, the “Value” fields were being cut off if too long.
  1. 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.
  1. 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.
  1. 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

Import & Export

  1. 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.
  1. Inventory Images
  • Fixed bug, when trying to Import a large amount of Images, not all the Images are imported.
  1. 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.”.

Data Conversion

  1. 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

  1. 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)”.

Feature Spotlight: Pick Tickets

This week we would like to highlight a feature that can improve your warehouse efficiency; Pick Tickets.

The Pick Ticket function within Palladium allows you to define Pick Routes within your warehouse to control Picked vs Unpicked Orders. In addition, we have the ability to Split Picking across Locations (Warehouses or Yards) and to collate them at time of Invoicing.

We also have the ability to create workflow steps for the Releasing, Assigning, and/or Printing of Pick Tickets. Palladium gives you the ability to view all un-issued Pick Tickets, Issued but not Picked, and Picked but not Invoiced tickets, using the drop-down filter. In addition, these statuses can be filtered by Location, Department and Delivery Method for ease of control.

Easily issue pick tickets by checking the sales orders that you would like to issue pick tickets for.

 
 

The Print Pick Ticket function provides a separate step to flag pick tickets as printed or unprinted alleviating the possibility of duplicate printing. 
 

Once the stock has been picked the Stock Pick function is used to tell Palladium which items were picked and in what quantities.
 

Coming Soon: Multi-bin Locations & Warehouse Management System

The Pick Ticket function has been enhanced in the Palladium Premium edition, with full mobile capabilities as well as the ability to move the picked items to a “picked-for-shipping” bin location. 

Palladium Premium integrates effortlessly with the Palladium mobile Warehouse Management System (WMS) application which is built to work with Zebra Android Scanners. WMS will give businesses better control over their warehouses and stock. Users will be able to manage GRVs, Pick Tickets, Stock Takes as well as Warehouse and Bin Transfers from Zebra mobile scanners, improving efficiency and accuracy.
 

If you need more information please contact us on sales@palladium.co.za or call +27 (0)11 568 2900. 

Palladium enters the Cloud

Palladium Business Solutions has signed an Enterprise agreement with Microsoft to host client’s data in the cloud. This means that clients are no longer required to purchase costly hardware in the form of servers or have upfront fees to purchase the MS SQL server database.
Read More

Five ERP best practices for corporate governance

Businesses may not realise that their accounting system holds the key to good corporate governance.

When running a business, pretty much everything that you need to do is impacted by good governance. For example, if you want access to finance, you need to be able to prove that you have adequate controls in place that mitigate both risk and contingent liabilities. Read More

Get a Quote