Release 12.228.R30 16-Aug-2024
Summary: The latest update to Datapel Cloud.WMS, Release 12.228.R30, is packed with enhancements designed to boost performance, streamline user workflows, and resolve critical issues, all with the goal of enhancing your daily operations. This update introduces several new features and refinements to existing modules, ensuring a more robust and user-friendly experience.
Key Feature Enhancements:
**Header Quantity Estimation for Kits: A new feature has been added to the Item Register, allowing you to estimate header quantities in kits more accurately. This feature can be customized to fit global preferences.
Performance Improvements for Sales Orders: We've made significant optimizations to the way sales orders are processed, resulting in faster system performance and reduced database activity.
General System Performance: Backend improvements have been implemented to speed up system startup and reduce initial load times, ensuring quicker access to your WMS.
Enhanced Attachment Import Process (eTrack): The attachment import process now includes the ability to update shipping references during the import, improving both accuracy and workflow integration.
Public API Master Key Management: Administrators now have access to more secure and flexible master key management within the Public API2 settings, facilitating smoother API integrations.
Barcode Scanner in Email Client: The Email Client now supports barcode scanning, enabling you to swiftly continue or cancel tasks directly from scanned data.
eTrack User Management: Users can now be seamlessly enabled as eTrack users within the myAccount module, simplifying user management across platforms.
Scheduled Task Enhancements: A new `/CloseSales` option is available in the command line interface, allowing for the smooth closure of shipped orders, optimizing order management processes.
Lock Management Enhancements: Lock management has been improved with UTC time storage and a 30-minute automatic expiry, ensuring that your transactions are handled securely and in real-time.
Resolved Issues:
Web Images Workflow: Fixed issues with exporting images that resulted in blank files. The image replacement functionality has also been improved for more accurate file overwriting.
Shipment Confirmation Reliability: Resolved an issue that caused shipment confirmation to fail due to a single quote in the reference field, leading to smoother order processing.
Email Client Stability: Resolved issues causing the Email Client to crash when handling certain attachments, enhancing overall stability.
Sales Order Workflow Fixes: Addressed multiple issues in the Sales Order module, including display and editing of fields, consistent application of discounts on kits, and accurate invoice number prompts.
Batch Serial Number Support: Updated to support single quotes in Batch Serial Number and BRN fields, improving data entry accuracy.
Referral Source Visibility: Expanded the display in WMS Explorer to show more than 8 referral sources, ensuring comprehensive data visibility.
UI and Interaction Enhancements: Various improvements to the user interface, including enhanced right-click functionality for iMac users and consistent display of the Payments tab in the Sales Form.
Price Field Consistency: Fixed an issue when entering the QTY field reset the unit price, ensuring pricing accuracy throughout the order process.
Sales Kit Quantity Management: Corrected an issue where updating kit quantities resulted in zero quantities, ensuring accurate stock management.
Sales Rounding Consistency: Addressed discrepancies in sales rounding during record and update processes, ensuring accurate financial reporting.
This release builds on our commitment to improving your warehouse management experience by enhancing performance, usability, and feature reliability. We are confident these updates will help you manage your operations more efficiently and effectively.
Release 12.228.R28 9-May-2024
Summary: Release 12.228.R28 is an extensive UX rework, performance, and maintenance release. Key fixes address issues with scheduled tasks, import mechanisms, sales tax calculations, and UI screen layouts.
Additionally, several features have been added or updated to improve workflow efficiency, such as the ability to include additional information when importing purchase orders and transfer orders, and enhancements to the location bins feature. Various bug fixes have also been implemented to resolve issues with barcode scanning, payment terms, and report criteria forms, among others. Overall, this release aims to provide a more streamlined and reliable user experience for all stakeholders involved.
Feature Enhancements:
Webhook extensions for Import Transactions.
Added new Web Product flag for eComms and myAccount.
Location Bins added empty/occupied flag.
Sale Orders Revision change auto cancels prior version then adds new version.
Allow use of item notes in transfers.
Enhanced API2 and integration capabilities
New Script Point - On Combine Sales.
Performance Optimisations:
Optimized Loading replaced sub-selects with JOINs.
Stock Legend BoM filter optimized.
Indexes required to optimize bin refills in mobility server.
Refactor of Business Logic to use direct UPDATE to reduce database traffic.
Polling loop correctly queries the ROQ to flush every 5 seconds.
Import Transactions:
Included Price, Line Note, and UOM Tag in PO XML imports.
Enhanced the Other Tab by adding the Imported Order Contact Name.
Correctly linked the Import Mechanism to the Referral Source List.
Ensured comprehensive audit details for imported orders, including PO numbers.
Improved web hooks retry management with additional Audit Table columns.
Added EDI Fields to Purchase and Transfer functionalities.
Enabled status change queues in scope webhooks.
Refactored code for importing XML Purchase Orders.
Refactored code for importing XML Transfer Orders.
Refactored code for importing XML Sales Orders.
Reporting:
Ensured proper selection and unpacking of USR reports.
Improved the Design button functionality to open the correct USR report being viewed.
Enhanced Supplier filter reliability to ensure reports load correctly.
Optimized form downloads to work seamlessly outside the AWS region.
Corrected the Receiving Report Location filter for accurate results.
General:
Resolved the rounding issue with Sales Tax Excluded for Tax Included pricing.
Ensured lines remain picked after closing the pick adjustment screen.
Corrected barcode scanning to display the correct item in the item list register.
Enabled the Barcode Exit (CANCEL) functionality in Confirm Order Shipment.
Implemented a block to prevent deletion of receiving records for blind returns.
Fixed SHIP Barcode functionality in the confirm shipment screen when any buttons are selected.
Enhanced batch management to prevent incorrect adjustments to stock values.
Ensured the customer name entry field captures the first letter typed on the first load.
Enabled selection of multiple locations in the Report Criteria Form.
Corrected the Sales reports issue with the bill-to/ship-to option, ensuring @PARAM_IsBillTo changes on selection.
Made image files for email templates accessible from other servers and ongoing usage.
Expanded barcode search functionality to include additional barcodes beyond UDF1.
Added support for serial number setting on receive in Workorders.
Addressed system freeze and closure issues caused by special characters.
Ensured correct numbers are pasted in the batch serial list, preventing incorrect or duplicate serial numbers.
Added Namespace or unique identifier to PDF downloads for enhanced security.
Included Hash coded instance Id in download file IDs to avoid potential duplicates.
Added payment terms for sales in scheduled task Auto import.
Extended job and invoice number fields to 100 characters in Sales and Purchase accounting tables.
Blocked overnight non-financial Check-In billing and enabled Manual Billing.
Improved error handling for changes in Inventory flagging from accounting adaptors.
Release 12.1.227 NFR 10-Aug-2023
Extensive User Experience Rework, Performance, and Maintenance Release (REQUIRED)
We're excited to announce the release of Version 12, packed with extensive user experience improvements, enhanced performance, and important maintenance updates. This release is essential for all users, as it brings a host of enhancements and fixes that contribute to a smoother workflow and improved usability.
Enhancements:
User Interface and User Experience enhancements in Report Dialogs
Background dimming of parent Modal Dialogs for improved visual focus
Achieved a remarkable 30% reduction in load times, enhancing overall performance
Improved selection of untracked FIFO stock for enhanced inventory management
General bug fixes that address various issues, ensuring a more stable system
Targeted Improvements: This release has a strong focus on enhancing the usability of the Report dialog and addressing GoLive fixes and change requests.
Issues Addressed: In this version, we've resolved a wide range of issues to provide you with a smoother and more efficient experience. Some of the resolved issues include:
Single replication sets causing loss of existing card record IDs and replication address issues
Enhanced reporting capabilities with the ability to filter by billed status
Improved disabling of contacts in SE MODE
Corrected date filter for Promised and Receive in Purchase Reports
Various Xero integration improvements and bug fixes
Optimized cost tracking in various scenarios
Enhanced user access control and usability
New Features: In addition to bug fixes and enhancements, we've introduced several exciting new features to elevate your experience:
Including dimensions and minimum unit of measures in Receiving
Refactored Report Dialogs for improved user experience
Enhanced Payments Report dialog
Background dimming to highlight Modal Dialogs
New options in various views for better navigation
Improved scripting capabilities and job list updates
Performance optimizations for faster load times
Replicator improvements for better data management
Release 12.1.226 NFR 27-Feb-2023
[XERO] - Company Name Contain & Onboards but Fails to Replicate Afterwards
[TaxCodes] Import Duty and Input Tax types blocked - MYOB ONLY
[Schema] Allocation Performance Indexes
[Item List Register] - Allow * back in search "Match Bin"
[Email Template] - CC and BCC Both Not Saving with Templates
[Locate Customer and Suppliers Screen] - Search by email, can't type "alias"
[Purchase] Drill to Order disabled for part received orders
[Email Template] - User unable save and edit Email Template
XERO API resolve issue when exceeds maximum calls per seconds (max concurrent calls = 5)
[Stock Register] - #Ref Column Shows PCK Number Instead of Invoice Number
[Receive Stock] - Double Receiving When Double Click "Split Receive"
[XERO Returns] Returns do not send to XERO With Discount %
[WMS SE] - When Update A Card, It Create Duplicate Address
[WMSExplorer] - Optimise Page View With Cache Record Count On All Registers
Resolved Only checking last name for a duplicate name match blocking new card creation.
[Xero] Discounts not permitted on Purchases or negative on Sales
[Item List Register] - Optimisation - Item List
[Replication] Wrong company File - due to legal name length
[Check In] Optimised Import of Checkins
[WMS Cost Tracking] Incorrect for Blind Returns
[Sale Imports] Fails to load sales into WMS for scheduled task of IMPORT_TSV
[Assemby] Build Splits to Picked and RTP with Zero Component Line Quantity
[Item Pick] Reserved Article mixed up for Transfers resolved
[Replicator] StandardCost back calculate from TaxInc if available
[Split Order] Added block to stop double receive due to Split Order double click
Features
[Transfers] Add Advanced Transfer Article Selections
[Receiving] Allow Paste Serial Numbers into Receive Line
[Receiving] Added option for Auto Lot Number
[Sales] Enable Datapel PayNow - payment services extensions
[Picking] New Pick Method by Lot Number Ascending or Descending
[Picking] Updated Pick Order UX to include filter by LOT and add shadow text
[Payment Services] PayNow implementation and reconciliation processes
[WMSExplorer] Optimise Page View with cache on Count Records
[WMS Explorer] UX revisions
[Pick Bins] Add Option to Bin Setup to define as Pick or Bulk
[Contacts] Add Default Location for Cards and Items
[Order Pick] Added Pick By Lot# Asc or Desc option
[Order Pick] Added First available Pick Bin option (see BinType)
[Import Transaction] Unknown Bin now created on import (Transfers Only)
[Bin Groups] Added New Bin Group and Type to LocationBin Table and Bin Create
[Transfers] Move Lot option added with Advanced Article selection
[Replicator] CostPlus Sell feature extended with Standard Cost options
[Reports] Added BinUsage and Item Storage Reports
[WMS Explorer] Extended Batch/Serial Search to include article comment with prefix ? In search box
[Receiving] Added AutoLot# per Line for pallet tracking
[Receiving] Dimenion Editor now sets Quantity Received using Buying Dimensions
[Item Detail] New Item Location Metric Icon
[Audit] New Audit events for any change of Item Location or Owner Contact and Istock
[Card Legend] Improved Validation on Currency change
[Card Legend] Default Salesperson and Default Contact Location edit and add
[Card Legend] Xero, SE now allows CustomField editing
[Card Legend] Search filter by Location Added
[Preferences] Xero Debit and Credit Accounts edit from Replication Tab
12.1.225 Release 21 July 2022
[XERO] Custom Lists names able to setup inside the software.
[Preferences] Standard preferences deployed for new sites.
[Quick Print] Multiple forms are allowed in Datapos.
[Purchases] Location update on purchases enhanced.
[Inventory Detail] - Locate Supplier screen enhanced.
[Custom List] - Delete custom list now is available for WMS Xero and WMS SE.
[Inventory Details] - System prompt error Message when click to update from Accounting resolved.
[Create New Location] - Create a new location; it stores as Location / Supplier.
[WMS SE] - Able to update Contact after Modifying Employee/User Card.
[Receiving] - Print Selection > The Other options (multi pick, pick slip, packing slip, job labels) is disabled.
[WO from Ordering Assistant] - The Mouse Icon functionality improved.
[Receive WO] - 'Delete this Order' function enhanced.
[Exchange Rates] - Improved "Export" in Bulk function for Currency Rates.
[Sales] - New 'Apply Surcharge' option to MYOB setup added in Pref.xml.
[User] - Logout Inactive Users Setting enhanced.
[WMS AVG. Costing] Costs for returns fixed.
[User Access Control] New function to amend Employee details via Contacts > Employees.
[Location Bins] For Inactive BINs, the putaway screen will now show *. Export Putaway Bins, only output Active Bins.
[Sales Orders] Enable 'Use Item Description on Order Transaction Lines' in Preferences - Inventory tab.
[Return Authority] - Posting RA to MYOB- the Category field is reflected in MYOB from the WMS referral source.
[Pack Order] - Recipient address shown on pack screen to allow users to change if required.
[Ship to card] New ability added to change 'Ship to' address after record/ update sale order.
[Returns] Returns qty removed under Analyse-> OnOrder tab
[Costing] WMS Average Cost on items received via Work Orders enhanced.
[Audit Log] Added logging for new WO and WO stages to Audit Trail.
[Address]Duplicate records in ADR_AddressList causing packing slip items to duplicate have been corrected.
[Flags]Red Flagged Stock Group functionality enhanced.
[Xero] Only ONE UnitMeasure Supported and copied to both BUY and SELL.
[Card] Incorrect card type show when editing - corrected.
[Sales Lines] Extended lines GP field calculation corrected.
[Purchase Order] - If the Order Status is BILLED - the user is unable to change the line Quantity only price and discount fields.
[Xero] - New custom list labels added in the Preferences-Inventory tab.
[Users]User Active Locks now showing when Drill to Source in Receiving Register.
[Access Control] Administrator is able to tick and untick ' Batch serial tracked' and 'Require this item to be tracked as inventoried in WMS'.
[Pack Form] Pack Screen now shows Received Address and can be edited.
[Import] Item UDFs and Dimensions Export and Import - now include Supplier and Supplier Item Number.
[WMS SE] - Now allow customer account On Hold function.
[SE Xero Only] 'Delete' button is visible and able to delete supplier name.
[Email] New options for an Auto prompt to send Email on Sale Ship and Sale Record.
[Order Management] Streamline Pick/Pack/Ship from Sales for simple eCommerce Orders.
[Sales Entry] Unit Prices were extended to 5 decimal places to match Purchasing enhancements.
[Contact Legend] Added a new option to search Employees - name and email address.
12.1.224 Release 11 February 2022
[Transfer Receive] Users can cancel the receiving record.
[Cards] Postcode Field length increased
[Reconciled Paid Invoices] Reconcile any paid invoices supported
[JOBS] New JobCode refresh activated
[Printing] Print pick lists from the Picking screen bypass printer selection
[Sales] Manual Price entry is overwritten/ not saved - resolved
[Rounding] Sales Tax Exc rounding issue with Tax Inc pricing improved
[WMS SE] - Item Set-up To Specify What The Tax Code When Sold or Bought improved
[WMS SE] - Added Tax Code Field in The Import File
[Workorders] Able to remove or add lines while recording workorder
[Referral Sources] Right-click list supports up to 16 referral sources
[Update Expiry Date] Able to change the expiry date on batches that have been incorrectly entered.
[KITs] Drill to Sale when kit item QTY = 0 enhanced
[Copy/Paste] Right Click Copy past function enabled
[Purchase descriptions] Advanced search to multi-select item codes in the Purchase Order entry workflow enhanced
[Print] Print Options dialogue Print All or Print Selection enhanced
[XeroAPI] Replication for items enhanced
[Sales] Double up Sale Lines enhanced
[Receiving] Double up receive lines enhanced
[Sale Order] - Wrong Spelling "Notification" (Missing i) resolved
[BOM] Added Search UX update
[Stock Detail] Forced Fractional turn off enhanced - SE XERO only
[WorkOrders] Overflows cause New WorkOrder to hang or fail enhanced
[Receiving] Batch Serial Duplicate block removed
[EMAIL] Allow a selection of email addresses when emailing out
[Adjustments] Optional import and export for COST column supported
[WMS SE] Default Terms and Setting Terms for and Supplier Customer enhanced
[Email] Enhanced Email Sender
[TaxCodes] Optional hiding of Buy and Sell Only TaxCodes
[XML Import] Purchase Orders and Requests updates
[Replication] Default options for Cost Track and Cost Method
[Email] New Security Options added for Integrated Email Client
[XeroAPI] Multi-Payment now supported for Xero as Prepayments
12.1.222 Release 27 November 2021
WorkOrders Enhancements Maintenance Release
[Assemblies] Advanced Item lookup and Multi add item load enhancement
[Despatch Register] Item Filter load enhancement
[SPS] Customer name load by ascending enhancement
[SPS] Suppliers - Search by name enhancement
[Payments] PO# added on the Credit Note
[Despatch Register] Change of SAL_RemoteStatus Icon to match sales register
[User Settings] Local User registry now stores user options like Print options on record of sale custom or STD forms
[Reconcile Payments] Replication enhancement
[Assemblies] User can cancel/delete picked workorder lines.
[Address] Drop Down selection enhancement
[Assembly] Enable the Up and Down Arrow for Grid Edit Cells
[Scheduled Tasks] Closure of Sales and Transfers in WMS SE
12.1.220 Release 10 September 2021
General UI and Usability Fixes reported via migrators
Inactivating Bins - hiding the Inactive Bins activated
Transfer Unit field corrected to show as units, not Qty
[Despatch Register] Promise date search added for transfers and checkouts
A sidebar short cut "New Despatch Order" and then right-click "New Despatch Order" now is available.
[Transfers] In Receiving register > filtering by specific location enhanced
[MYOB FX] Functionality removed add back Spot Rate update on POST Sales
[Reports] Sales Summary, Purchase Summary and Stock List report default to Users default location set in Preferences.
[Receiving Register] - Improved search for Supplier records > enter Supplier name to search, it shows all records on the full page when paging mode is turned on
[Order Assignment] Improved to view all picker names
[PURCHASING] Quick receive now works for Returns
[CLOUD PRINTING] Improvement to check for VUI mode - if the default printer is set to THINFINITY VUI PRINTER it will choose the default and push straight to the Google Printer dial
[SALES] After the new Sales Order creation with two forms being printed > Press CTRL+O (on keyboard) --> it is focused and shifts to the customer field. No need to reach for the mouse to select the field.
[Scan Pack] Non-Inventory and Negative Items don't auto pack (WMS Despatch Window Scan Pack Option) - fixed
[Remote Sales] Scheduled task Auto import (/IMPORT_SALES) now add payment terms for sales.
[FX Incorrect] Currency Page sync from Accounting corrected
[DATAPOS] Payment Terms for DataPOS improved.
[Purchases] Location update on purchases improved.
[Bulk print Pack Lists] Allowed RPT and NSA to be included in Pack List selection.
[Purchasing] Ship to another card now allows being sent to MYOB.
[Despatch Register] Cancel scan code added as the REFRESH function.
[Runtime Errors] Error handlers were added to all gradbar code routines for improved monitoring.
[Blind Return] Deliver to "other" card now available for Blind returns.
[Transfer] Ship address is wiped on Tab off selection - fixed by minor UI minor enhancement.
[Special Pricing] The ability to sort SPS pricing schedules by item number/headers is now available.
[Transfer] Ability to clone transfer orders is now available.
[Receiving] Receive date resets to current days date - fixed
[Special Pricing] Ability to import special pricing when duplicate card names / inactive cards have been removed.
[Inventory Detail] Custom List Header Name field size has been increased
[Sale] Cloned Sales contains payment from the original sale - fixed
[Stock Legend] Performance Optimisation
[Ordering Assistant] Improved Supplier's SPS load for use on purchases.
New ability to import CustomList and CustomFields for Xero and SE
New ability for the user to move Sale Line to different ROW. The user needs to click and drag row and will drop before the line you hover over.
[Assemblies] WorkOrders part pick enhancements. New Options for part pick added to Security Settings
[DashBoard] Replacement of Crystal Report Dashboard with Link enabled Boards.
12.1.216 Release 27 June 2021
Performance Enhancements and Optimised Form Loads (modals)
Item Lookup now supports Paging
Backward Compatibility with V9 Multi-Currency Exchange Rate update on Post
Usability and UX enhancements (flat controls)
[Xero] Token Refresh Failure fix
[MYOBApi] Closed and invoiced sales in WMS missing from MYOB - fixed
[CheckOuts] Error "The item number or barcode was not found." - fixed
[Replicator] Promised Date Mapping improved
[Xero Replicator] NON-Forced Fractional Items BST_MYOBQty field not being updated during replication - fixed
[WMSExplorer] Refresh time improved for ASON
[XERO] - Assemblies contain unrequired write of lines] - fixed
Replication issue fixed to invoice to MYOB where item number contains a single quote.
[Ordering Assistant] - When Filtering by Custom Lists Displaying Alphabetically improved
[Replication] Cost update improvement for Adjustments and Workorders sync to MYOB
[Status Reporter] - Logging an Error Code Better If Duplicate Shipmethods Coming from MYOB
[Replicator] SQL Error fix- The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
[MYOBAPI] Employee Mapping fixed for individuals trailing COMMA
[SALES] Ship to another card Drop down list locked (12.1.214R5)
[SALES] Ship to Another card, select card, Card name does not load in the address box (12.1.212) - fixed
[Assignee - picking screen] is locked for editing
[CheckOut Inventory] - Modify Ship to Address But Does Not Save, It Reverts to Postal Address - fixed
[Purchase Order] - Deliver to "Another" Address, The Data Field is Blank. - fixed
Kit lines reconciling to Payment in full
[Payments Memos] MYOB Memos info updated to Payment from [Customer Name or Address Line1 for ShipTo]; Invoice#XXXXXXX; Purchase#XXXXXXX
[Transfers] Apply default shipping methods to new transfers
[Sales Order] When copying Kit Items with multiple lines into the Sales Order screen, the CURSOR always goes to the last row.
[Picked Order] - When click "Fast Pack" >returns to Pack order screen
[Packed Order] - On the pack order screen, when clicking the "BACK" arrow, > returns to Despatch Register instead of showing Confirm Shipped screen.
[Adaptors Preferences] - Dropdown List of Default Salesperson fixed.
[PrefsXML] Added ReviseCurrencyOnPost option
LocationBins Control refreshes on Location Change fix.
[Receiving] RO_ON_RECEIVE Script point now supports CANCEL option
[CubicCalculator] CloudUI enhancements
[ContactLegend] Corrected FLASHING list on change row - triggering Attachment render disabled
[StockPick] Modal form changes to ensure SINGLE INSTANCE only
[StockPick] Persistent Object property compared to UI property before forcing an update
[StockPack] Modal form changes to ensure SINGLE INSTANCE only
[StockPack] Additional Property Updates on Form Hide or CloseUp
[PickPack] UI Flat controls added
[ShipOrder] Added Fix ONLY allow PACKED order STATUS to SHIP
[ShipOrder] Modal form changes to ensure SINGLE INSTANCE only
[StockSale] Minor UI changes to Print Preview options
[WMSExplorer] Page Render BLANKING fixed to over-write, giving page change a smoother appearance
[WMSExplorer] Sidebar options - New Despatch Order - added as alternate option
[StockDetail] Fix for Change Flag false trigger on load causing Refresh on form exit
[Speed Improvements] In the areas of Customer Cards, Location Bins load times
New feature [On Post Sale] - To Update Spot Rate on POST to MYOB
[Pack Order Screen] - Increased performance with Scan Pack on Cubic Calculator
12.1.210 Release 12 March 2021
Desktop and Mobility ScanPack Convergence
Audit Trail Standardising, Optimising, and Performance enhancements
New Import Transaction XML feature
Improved Search, Useability and UX enhancements (now supports US Date Formats)
[Stock Ordering management] Creating PO, supplier terms selection improved
Despatch scanning. Improved audible alarm if a wrong item is scanned
WMS-SE error resolved when trying to edit customer details
[Sales] Enable SAL_Comment Field on Closed Sales
[PO Payment] - Fully Paid Amount on PO But Still Leaves the Balance Amount
[Replicate Card Address] - Customer Cards with Address 3 sync improved
Item replication failure resolved due to odd response form MYOB for AverageCost
[Receive Register] Filtering by BILLED Status improved
[RA Receive] - Receiving Full Stock Status improved from Split to Closed
[Sales and Despatch] - "Approved" a Green Tick on both Sales and Despatch Registers
[Work Order] - Adding Suspend Duplicate Check for WO
[Sale Order] - Skip Payment Sending for Isnew Card
[Receiving Register] - Hide All closed Records improved
[Item List Details] - Stock Turn Stat in Item Details
[BXL_BoxList Data Loss] When re-opening the scan pack screen, all data is wiped for the related order in the BXL_BoxList table resolved.
[Scan Pack] Missing Data in BXL_BoxList Table
[Checkin and Checkout] - System Auto Pop Up Form After Record "Add Inventory" / "Remove Inventory"
[Purchase/Sales Address] - selecting a customer card in the delivery to another customer contact causes the mouse cursor in the deliver field to twitch for a while, and after the twitching completes, the address line is repeated more than 100 times - resolved
[IMPORT OPTION] Import Sale Order Line Description - Batch-Description and Description-Batch is no longer valid
[SALES] price reverts to zero after mouse click on tax code -resolved
[General] US Date formats added to User Preferences
[Cubic Calculator] ON_ADDPACK Script Point
[Cubic Calculator] Audit Trail Enhancements and Security Events Added
[Quick Despatch] Browser Audio Enabled
[Pick Stock] Minor correction to remaining pick Qty calculation
[Stock Detail] Repeated Header Caption on Drill Down Fixed
[Check-Out] Display on Record User Preference fixed
[Check-Out] Item not found popup can not be cleared - fixed
[Stock Receive] Removed Return/RA code causes options to disable
[Contacts SE] New Contact maintains contact type after record - fix
[Purchase Order] Alert Message truncates at 255 characters (fix)
[Purchase Order] Removed Duplicated Sales code to Release Orders/CancelReturns (code cleanup)
[Explorer] Extended Status in Despatch Register for Staging and Collected in Zone Pick Mode
[Explorer] Transfer comment now searchable Transfer register Search All option
[Explorer] Status BILL search fix
[Explorer] Query optimisations with No LOCK in register filters
[Explorer] Record Lock bug incorrectly applying to Sale Fix
[Explorer] Workflow Icons clickable security profile fix
[Explorer] Lost focus in Sale and Transfer register fix
[Pick] Order Close UseShipDateForSales tag direct checking with DB retries
[Replicator] Database Connection sharing enhancements
[Replicator] Sales and Purchase Default Terms fixes
[Replicator] Blocking of NewCard related transactions
[Replicator] improved error trapping on payment import failures
[StockSales] Alert Message trunc fix
[StockSales] unit Price zero issue with extended lines fix
[StockSales] Delivery Address autocomplete repeating lines fix
[StockPack] Audio Prompts fix for Browser
[StockPack] ScanTag load optimisations with progress bar (for scans with > 1000 tags)
[Checkout] - Autonumber in Sequence
[Audit List] Standardise the Audit Entry format to allow data analysis.
[Cubic Calculator] Prompt on Exit to Save Changes (lost data prevention)
[Cubic Calculator] Form UI modernisation
[Quick Despatch] Audit Trail Enhancements
[Stock Legend] Form UI modernisation
[Pick Stock] Form UI modernisation
[Check-Out] Transfer Reference Format Option enabled (count of uid)
[Stock Receive] New Search Grid icon added
[Transfers] New Search Grid Icon added
[Transfers] Drill Down on units for Article search to improve useability (CTRL+ENTER) overload.
[Confirm Ship Order] Form UI modernisation
[Purchase Order] Unit Price and Total Calculations extended to 5 DECIMAL PLACES
[RemoteOrderQ] ImportCommitDelay (seconds) added to throttle imports
[RemoteOrderQ] ImportFilesLimit (per cycle) added to throttle imports
[ScanCount] AllowUserBoxTags True False to enable editing of MASTER or ANY BOX IDENTIFICATION LABEL
[SessionActivity] RefreshIdleSession Tag added to cause a filter reset after 5 minutes inactivity
[Licensing] TrialService Tag to force interim End-User Service Agreement prior to Accessing Software
[Explorer] Item Barcode scanning now enabled for Assembly Register - must select an item search option
[Explorer] Audit Trail Enhancements
[Explorer] Page Mode Jump to the page by double click and font size to fit - fix
[Explorer] Page Mode PageUp/Down Keypress useability fix
[Explorer] Item Name added to Item Detail search in WorkOrders / Assembly Registers
[Explorer] TabView in Details modernisation
[Explorer] Sidebar address cleanup
[Explorer] Query Optimisations with hiding Closed Records ion Transfers and Assembly Registers
[Explorer] Logout Audit Events (forced or user-triggered)
[Transfers] UDF4 mapping enabled - for scripting
[Pick] Pick Engine Audit trail streamlining and suppression options
[Pick] Release Line optimisation Status update optimisations
[Remote SalesQ] Now supports XML Transaction format with Header option summarising
[Replicator] Audit Trail streamlining and improvements
[Replicator] Payment Replication query optimisations to improve memory usage
[Replicator] Credit Limit refresh query optimised for customers on both Xero and MYOB API
[StockPick] Sidebar UI enhancement with Grid Item Search options
[StockPick] Part Packed Order Splits enabled
[StockPick] Audit Trail Enhancements
[MessageBox] UI Modernisation and pull to front timer relaxed
[StockSales] Audit Trail streamlining and improvements
[StockSales] Enable Comment edit for closed Transactions
[StockSales] Grid Search now has icon selection to be consistent with Purchase, Transfer grids
[MYOBAdapter] Duplicate Purchase, Sale individual tags - WorkOrders, Adjustments suppress checking
[StockPack] Sidebar UI enhancement with Grid Item Search options
[StockPack] Prompt on ScanError GLOBAL preference added (Barcodes) to require a reason for NON-COMPLIANT scanning
[StockPack] BoxList Management enhancements to allow Mobility ScanPack management
[StockPack] User assigned Box Reference (LicensePlate) assignment via Add Box
[StockPack] Move Scan from SOURCE to DESTINATION box drag and drop OR through manual selection
[StockPack] Scan Pack Audit Trail enhancements and NON-COMPLIANCE audit logging
[StatusReporter] Page Mode now DEFAULT on entry with page selection enhancements from EXPLORER
[StatusReporter] UI modernisation
12.1.205 Release 14 December 2020
WMS SE and ICXE alignment updates
Performance enhancements
Import XML enhancements (load balancing), Auto ScanPack Box Number Improvements
Minor useability and UX fixes
[Remove Inventory - Checkout] - User Cannot Select Customer From "Despatch To" Drop Down- fixed
[Preference - Adaptor] - Default Salesperson Dropdown Does Not Seem to be Working - fixed
[Transfers] Customer Selection blocked for negative IDs - fixed
[Transfers] Lot Number duplicated in Dropdown for lines - fixed
[Transfers] InsertLine adds to the end of the list- fixed
[Transfers] Drill to Despatch Order works once only - fixed
[Transfers] Line Number ordering not retained- fixed
[Transfers] Manual Pick causes duplicate lines- fixed
[Orders] Limit Alert field to 255 characters
[Import] Allow Transfer reference to be incrementing AutoNumber
[WMSExplorer] Despatch Register now shows COLLECTED STAGED
[Order Pick] Internal Optimisation WITH (NOLOCK) added to various pick sub-tasks
[AutoNumber] Query optimised and NOLOCK hint updates
[Replicator] OpenConnection not preserving User Context
[MYOBAPI] Default Duplicate reject set to false (allow duplicates)
[Cubic Calc] Added new PK_ONADD_PACK script point
[Transfers] Autonumber Sequence to be different for CHECKOUT and TRANSFER orders
[RemoteSales] - Bulk Imports cause database blocking needs delay added between commit
[ScanPack] Correct for mobile scan pack to allow viewing/edit in WMS pack form
[ScanPack] Enable per box reference changes (limited)
[Bins] Added GIS code for Bin co-ordinates and HappySpace feature
[Controls] TextEdit Control now supports ShadowText property (UI enhancements)
12.1.201 Release 22 October 2020
Xero Integration with Support of OAuth2 standard
Enhanced MYOB API Duplicate checking
Import XML enhancements and corrections, Auto ScanPack of NON-Inventory Items
Minor useability and UX fixes
[Purchase] Address was overwritten on entering enter key of location selection- fixed
[Cubic Calculator] - Total Weight(kg) is Reflected Zero After Returning From Confirm Order Shipments Screen- fixed
Extended CustomField search to include UDF9 - UDF24 (previously 1-9 only)
[SPS Import] Supplier imports map to the customer's page
[Special Pricing] - Importing Special Pricing with error "FAIL" due to the special character (')"- fixed
ABN is not shown in the card legend ABN field- fixed
[Receive on RA] Batch Serial Number Does not Allocate to This Return After Receiving Stock- fixed
Change to paging in registers causes SQL errors- fixed
[WO Receive] After UNTICK "Order Inactive and Closed", Order Status Does Not Change From CLOSED to OPEN in The Receiving register
[RemoteSales] Alert user options - stops WMS from loading via browser.
[Password] Datapel login improvement
[TFA] Withhold emails security issue - fixed
Datapos - Salesperson and shipping method do not load
[Pick Order] Picker name not recorded against picked order
[Receiving for SO] - Invoice Column Shows as "WMSReorder" Instead of SO Number (e.g., SO-0517-0931)
[Multicurrency SO] Sales in NZD, When sent to MYOB, It Goes as AUD.
[Receiving] When Search by Alert status in Receive Register, System Does Not Found any Alert Transaction
[Special Pricing] - First Line of Sale does not use special pricing.
[Sales] Invoice and Purchase Order Numbers limit allowable characters
[Xero SDK] Oauth2 Compatibility added to Adaptor
[Xero] New Accounting Prefs XML Tag required for Xero Integration
[Xero] Onboarding Wizard for Xero Company files
XML Sales Import - Kits - Total Price not summing the order lines
[Purchase Order] Showing The SPS Flag But There's No SPS Setting for The Supplier
[Stock History] - The Date Sort Column of The Stock History Window Sorts by Day Instead of Date
Purchase Order Line Description - Edit line description is linked to Sale line edit preference.
The escape key in the calculator in the sale order sheet does not work. - fixed
[Supplier Returns] Unable to select the supplier return name
Sales Imports (KITS)
[CLOUDAPI] Truncation issue on Custom List Header Names
[Sales] Script Point on Sale Header initialisation
[UX] Move User Management to Right Hand Action [RHA] Menu
[ScanPack] Auto Pack / Count Non Inventory Items when Scan Packing
Customer Card] MYOB Credit Limit and Credit Hold Are Not Replicated to WMS
[Receiving Register] Loc ID not set on PO until received, cannot filter Open purchases by a location.
12.1.195 Release 24 July 2020
Paging Mode extended to all registers
Connection verification with ARL Accounting API
Critical fixes for insert/delete line edits
minor useability and UOM fixes
Stock Adjustment using Sell UoM to valuate
Sales Reconciliation Report - does not support Foreign Currency anymore and fails to get data with overflow errors.
[Stock Ordering Management] shows the OnOrder QTY, not UNITS; all other fields show Units.
[Sale Register] Right Click To Create Return Credit Option Is Missing
Line item price will change when inserting an item in a Quote/ Sales Order.
[Adjustments] Check Forced Fractional to ensure Costs are correct
Sales Reconciliation Query now corrected for ARL-API (requires xmpMapping.sql patch)
Added _Underscore to allowable search characters (WMSExplorer)
Health Check now verifies connection available before Verification
Enabled BCC from Prefs Tag (previously removed)
Fixed Ordering Assistant UnitOfMeasure (Fractional/MultiUOM) for OnOrder quantity by location.
Fixed Total OnOrder calculation for Stock Detail form (was not including Ordered stock never received).
Fixed Stock Adjustment Nett Cost calculation using SellUOM, now using BuyUOM.
Fixed Transaction Line (Sale/Purchase/Return) Price/Discount Errors after Insert or Delete of Lines
Item Register now applies correct numeric formatting for the DISABLED setting.
Fixed sidebar search fields SELECT ALL highlight issue when changing or refreshing register (intermittent issue)
Removed HealthCheck popup when \c missing to avoid Cloud Access blocks
Extended CustomField search to include UDF9 - UDF24 (previously 1-9 only)
Purchase Register LOCATION filter reworked and Register load time improvements.
Fixed Issue with Date Sorts (intermittent issue).
Updated Accounting Verification step to check for connectivity issues and exit on ALL errors/warnings.
Sales Invoice Paid Status in Accounting (Invoice Payment Reconciliation option) refactored/fixed for ARL_API.
Fixed Adjustment BuyUOMQty incorrectly applied for UOM<>1 and non-ForceFractional.
Fixed problem with individual Item Sync clearing Forced Fractional setting.
RemoteSales FX transaction corrects the issue with Tender amounts and applies Currency Prefix in Comments.
Page mode extended to ALL WMSExplorer registers (Reduced Memory Usage and improved performance)
Reconciliation performance improvements for InvoiceNumber matching (10x improvements)
Added New option to "Reset Connection", - which refreshes AccessToken from Datapel Validation Server.
Email Manager extended to allow global setting for ConnectionType(0-4) and Protocol(0-3) [see EASendMail configuration guide.
New option to BccSender (True/False) will append to default Prefs BCC address if set. (Effectively 2 Bcc Addresses)
Unable to access Accounting API - Service Unavailable. now reported to Audit Trail
Each Replication (read) Step Verifies connection availability before progressing.
Invoicing/Billing Steps now attempt additional Connection Verification checks.
Simplified Adjustment line description for ~ batch items.
12.1.194 Release 10 July 2020
The baseline for CloudWMS v12
This release identifies all Issues and Features Added from Release 12.1.180 to date.
CloudWMS 12.1.194 is the REQUIRED version for RDS VUI as of June 2020.
Job Codes required to be functional in
[Item Replication] failed replication due to special characters
Pasting with CTRL-V adds a V character in front of the paste
[Multicurrency] sending as AUD to MYOB
[Help Link] - Clicking on These Three 'Help-Link Then Nothing Happen
[Receiving] - CTRL-N in Purchase Order Then It Will Redirect to Open Link in New Window
[Sale Register] - CTRL-N in Sale Order Then It Will Redirect to Open Link in New Window
[Sale Register] - Double Screens Showing Up
PO Numbers skipping - improved
Payment method not showing in DataPOS - fixed
WMS Referral Source not Selecting in Sale When Typing Entry
Copy of a user’s permissions improved.
Split picking (with Auto Pick Pack on) ships the order
[Purchasing] unable to enter <0 Qnty for non-inventory items - fixed
[Assembly] All components change to required x1 when change location - fixed
Fixed Transfer issue with Referral Source
Fixed Transfer issue with intermittent Shipping Method becoming DISABLED
Fixed Issue on Sales/Purchases for Address loading where > 5000 contacts slow
Fixed Issue with the freeze on Contact search
Receiving Location Filter now handles all-trans types and open trans
Cut and Paste into Search field within Browser session improved
Help links restored and open in new Browser Tab
Fixed Stock Return minor issue with Currency Code did not reset after autocomplete finds a different currency code.
Barcode Stream TimeOut extended to account for slower browser connections
Improved support for NEXT/QUICK Scan Codes to reduce keyboard activity
Refresh Global barcodes - now update both master barcode list and secondary barcode list
New Assembly/WorkOrder fixed change of Location resets BOM component quantities
Stock Receive corrects issues with Return UOM and Fractional UOM (ForcedFractional)
Payments Form corrected for $ -1 on form load due to FX issue
Fixed BackOrders and ReOrder Wizard skipping PO# sequence (takes every second number)
Stock Pick now downloads reports and forms to Browser as PDF correctly
Stock / Item Lookup load time improved and reduced memory usage
Line Breaks (NewLines) now within same Accounting Description Line - not broken into multiple SaleLines
Correction for Kit Pricing by HEADER item (Kit Header Only pricing)
Minor bug fix for ShipTo Card (negative ID issue)
Corrected WorkOrder purchase details adding PriceExc/PriceInc to improve reporting
Restored "REFRESH" replication mode - last 24 hour changes reflected - now Express and Detail mode.
Added Check for Catastrophic fails in Item and Card pulls - if 0 results cancel replication step.
RemoteSales now applies SpotRate during FX transaction import
Kit Price import and KitPriceSuppress issues corrected
Kit PriceInc now calculated during import
Improvements to ReceiveOrder create to improve stability - more tolerant to DB locks and multiple stock groups.
ReceiveOrders now handle UOM / ForcedFractional correctly
Corrected problem with Auto Pick Pack changing status to SHIPPED - and missing PACK step.
Kit Rounding and Kits as TaxInc calculation improvements
Bootstrap for VUI added for Notification support
The reduced overall App load time when using page mode (up to 2x improvements)
Stock Transfer/Purchase/Receive/Sales now supports FIND (CTRL+F) function in grid
Sales can be previewed/toggled between TAX INC/TAX EXC mode while entering an order.
Added New Comment option to Sales/Purchases
New Search/Edit control added to Sale/Purchase/Transfer grid to improve useability.
Improved Return Authority details for Cost Accounting from Sales (New Return Authority)
Explorer now supports PageMode for ItemList.
Explorer Added Profile View -> Item Vitals History Chart showing last 12 months Sales/Purchases/Stock Onhand Trend.
Double Click Chart to toggle Labels (values for improved analysis)
New Contacts Shortcut - context-aware Contact lookup
Performance improvements with Grid population (Supplier/Customer lookup)
Improved Barcode scanning options with GS1 in ItemList
Explorer Now Supports XE (standalone operations)
XE Import Trans is now available for simplified AO,CO,CI,TO and pending options.
Assembly Pick Method now separated from Order Pick Method and new Preference Added.
Added new Adjustment ReasonCode - WrongBuild
Supplier Return now has an AR prefix to differentiate AD (Adjustment)
Adjustments now track total costs per item line
New Script Point on Adjustment Save to ALLOW or REJECT adjustments based on custom business logic
Two Factor Authentication option added to Global Preferences as Workspace Global setting.
Global Collection Refresh strategy modified to improve performance
Email options enhanced to allow both global or user-specific email credentials (must use same SMTP server)
CheckIn now supports GS1 scan options
New preference to Force GS1 code as Batch Number (to match Mobility Scanner functionality)
Script Manager now supports EAN128Config Edit in developer mode
Barcode Forms using native BarcodeWiz Scaling issues corrected for VUI browser mode.
Stock Detail now has Infograms - Stock OnHand / Valuation / Projected Stock Days (estimated days before Stock Outs)
Support for WMS Cost Accounting and average costs in Stock Details
WMS XE option for CustomList / CustomField Edits and selection directly from Stock Detail.
Contact Lookup improved support for WMS Managed Currency and other Contact properties.
Improved the refresh time after adding new Contact
Functionality modified to improve performance
Stock Register modified to reduce system freeze for users during wide date range queries.
WorkOrders now show Reference and WO# in Stock Register for improved traceability.
Stock Pack now supports enhanced Scan Pack workflow with Audit Trail timestamped by user/scan.
Partial Scan Pack now supported - to item line level.
API Accounts Replication Schema added
Added Accounts Replication Step
Jobs now support Paged Replication
Reads Global ARL default TermsID from company information
Simplified Replication Step Counts to 4 from 10
Terminology updated from MYOB to use generic "Accounting..." wording
Cost Updates from Accounting only for Inventory Items during transaction posts (NonInv/Forced Not required)
Cost Tracking within WMS only option added - allowing MYOB/WMS or WMSOnly Cost Accounting methods
Cost Of Goods now sent to Replication Tool for Business Essentials or optional Journal creation.
Improved MEMO description for WorkOrders/Adjustments
Added Option for WMS managed CustomLists and CustomFields (no longer replicated from Accounting)
Added Replication of Linked Accounts per Item for future reporting needs and Journal creation (Essentials)
Option for new DiscountByHost tag - to apply Volume discounts from Accounting while applying remote prices.
Script point added to PurchaseOrder import.
Applied NoLock to BillOfMaterials to improve performance
Added LastModified to BaseStock ItemMaster List to improve refresh performance
Added BaseStock Item Update Method to business logic
Added Account Codes and Inventory Valuation Fields
Added AddObject for Contacts to improve performance (StandaloneWMS)
Added All Pick Methods to WorkOrders (BATCH, BIN, CUSTOM SQL)
Added Scriptable Component Selection to WorkOrders
Improved WorkOrder Reference tracking in Stock History
Improved WorkOrder Cost Tracking in Receive Purchase
BoxList Table improved to link with Picked Table and LineItem details (for ScanPack)
Added NEW Scriptpoint RO_ONIMPORT_Attachment
Attachment Image Imports now support via RemoteSales (JPG only) to Sales/Purchase/Items.
Added StoredProcedures and Triggers for InventoryValue calculation on required Business Transaction Change Events
Triggers for LastModified to BaseStock and Stock Tables to improve performance