pixi 22.04 is available from 5 April 2022. It includes several bug fixes, new features, enhancements and optimizations.
Please note: We have rescheduled the release date for pixi 22.05 from 03.05.22 to 10.05.22.
API
🟩 Bug fix: An issue has been resolved concerning API call PixiGetSOrders. In case the purchase order number for a goods receipt document was a long numeric value, the datatype conversion failed. (604238)
🟪 Enhancement: The documentation for API call pixiCreatePicklist was enhanced. (603050)
🟨 New feature: pixi's API documentation is now located at the Descartes API Portal. (599267)
Web Application
Administration (Shipping Station)
🟪 Enhancement: The Shipping Station was enhanced with printing options: Invoices, Credits, Return Forms and Delivery Notes. The drop-down menu for the printer selection turns active after Print is selected in the field above. The options are:
Don't print: The invoice is not printed and on the Package Overview page the option for reprinting the invoice is disabled. The invoice will not be uploaded.
Don't print - save it locally: The invoice is not printed but it is saved to the folder which is defined in the JSON file - pixi Connector settings
Print: The invoice is printed via pixi Connector
Print - save it locally: The invoice is printed via pixi Connector and it's saved to a defined folder in pixiToolboxSettings.json
Print from pixi Desktop: The invoice client opens and the invoice is printed via the client
Credit documents are uploaded to the document storage according to the document storage. In case the Don't print option or disabled database setting Save PDF Invoices/Reminders the documents are not uploaded. When a credit document is uploaded to Document Storage, the document can be attached to the email. (476124, 476128,, 476130, 476131, 551678, 503866)
Please note: You cannot reprint a document at ship out when the option Don't Print is selected for the document type.
Administration (Templates)
🟪 Enhancement: A new tab was added: Invoice. The following templates can be uploaded here: (476125)
Invoice
Return Form
Credit
Customer Service (Invoices and Credits)
🟩 Bug fix: Various issues were resolved: (605021)
Searching for a Document Type and Order Type did not work
The Clear button did not reset the search fields for document and order type
"%" did not work as a wildcard character for Document Nr., External Order Nr. and Tracking ID
The search functionality did not cut off spaces before or after the input
🟪 Enhancement: In the advanced search, the parameter All was added as an additional search option for Document Type. (605021)
🟪 Enhancement: One or multiple invoices and credit documents can be printed from the list and details pages. The documents are printed according to the defined printing settings for invoices and credits in the Shipping Station. If in this context Print from pixi Desktop is selected in Shipping Station, only one document can be printed. (503868)
🟪 Enhancement: Packages were added as a new tab to Invoices details pages. It is not visible on credit (!) details pages. The tab shows the same package information as the Package overview page on Ship-Out (item, weight, shipping vendor etc.). The tab Packages is empty for invoices that were shipped via the pixi Shipping client and if not all items from an invoice have been shipped yet. (503867)
Customer Service (Orders)
🟩 Bug fix: In case more than 2000 tags (e.g. 5000 tags) existed in a database, searching by tag included only the first 2000 tags (in alphabetical order). (588565)
🟩 Bug fix: On order detail pages, the orderline table was limited to 50 entries. The limit was raised to 1,000 entries. (597618)
General
🟦 Optimization: Several optimizations were applied for scan-in and invoice creation to resolve performance issues that occurred after updating to pixi 22.03. (604580)
Items (Item Management)
🟪 Enhancement: When a new supplier is added or edited for an item using a different supplier item number and price but the same EAN UPC/barcode, the supplier will be marked as the current supplier. When the current supplier of an item is deleted, the only supplier that is left or was last edited is now marked as the current supplier. (584394)
🟪 Enhancement: When adding/editing/deleting suppliers of items, the EANUPC is also updated in the items table. Overall, the data consistency for items in the Suppliers tab is improved with item codes. The changes will also improve server performance. (599210, 604178, 604116)
Logistics (Scan-in/Ship-Out Performance)
🟪 Enhancement: Various changes were made to procedures that update statistics in the most used tables. (592084)
Logistics (1SS)
🟪 Enhancement: A new error message was implemented for cases when an item from 1SS picklist with payment type setting CA Do Not Allow Ship Out If Not Paid is enabled ("Invoice is not paid."). (476124)
Logistics (Ship-Out)
🟪 Enhancement: The return form is printed after the ship-out is completed when the print option Print is selected. In the case of Multiple Packages, the return form is printed after the last package is created. Reprinting the return form can only be done via the Package Overview page (the same as reprint Invoice). (476127)
Purchasing (Purchase Orders)
🟩 Bug fix: Purchase Orders could not be created from templates in pixi Web. A connection error occurred. (611553)
Quick Search
🟪 Enhancement: Quicksearch now features searching by invoice and credit number. (550263)
Desktop Application
Bin Client
🟩 Bug fix: The following components were removed from the main window of Put into Stock, Take from Stock, and Change Quantity: (603566)
Title and input field for Change Barcode
The Change button
Barcodes can be changed in pixi Web Item details (tab Suppliers) and in the desktop application Bin (Searching for an item > Item Info > Suppliers).
Connector
🟪 Enhancement: New variables for saving documents (SaveDocumentSettings) were added to pixiToolboxSettings.json: (476129)
-
SavedDocumentsPath:
The folder for saving documents is specified here and it can be created by pixi Connector.
The log file will record an error if no folder was specified in the JSON file.
-
CreateSubfoldersForEachMonth can be set to:
-
false
Files are saved directly into the folder that is specified in SavedDocumentsPath
-
true
files will be saved into subfolders according to DocumentDate
folder name for subfolders: month - year, e.g. file with "DocumentDate": "2022-01-07T10:05:52.8885751Z" is saved into subfolder 01 - 2022
-
In case no document saving settings are specified in pixiToolboxSettings.json, pixi Connector doesn't save documents. In this case, an error message is printed into the log file ("@mt":"No SaveDocumentSettings section detected, documents will not be saved!" ,"@l":"Warning", "Username":"ttester"})
Data of a JSON file that includes the new variables (click to unfold)
{
"SaveDocumentSettings": {
"SavedDocumentsPath": "C:\\pixi\\SavedDocuments",
"CreateSubfoldersForEachMonth": true
},
"Profiles": [
{
"ProfileName": "DHL CSV Profile SP",
"ParsingMethod": 0,
"ShipVendorFolder": "C:\\pixi\\DHL\\TrackingIds\\",
"FileFilter": "*.csv",
"ProcessedFilePath": "C:\\pixi\\DHL\\TrackingIds\\",
"ProcessedFileType": ".done",
"ErrorFilePath": "C:\\pixi\\DHL\\TrackingIds\\",
"ErrorFileType": ".error",
"IgnoreHeader": true,
"Separator": ";",
"TrackingIDIndex": 1,
"ReturnTrackingIDIndex": 66,
"InvoiceNumberIndex": 22
},
{
"ProfileName": "DHL CSV Profile MP",
"ParsingMethod": 0,
"ShipVendorFolder": "C:\\pixi\\DHL\\TrackingIdsSubfolders\\",
"FileFilter": "*.csv",
"ProcessedFilePath": "C:\\pixi\\DHL\\TrackingIdsSubfolders\\Processed\\",
"ProcessedFileType": ".done",
"ErrorFilePath": "C:\\pixi\\DHL\\TrackingIdsSubfolders\\Error\\",
"ErrorFileType": ".error",
"IgnoreHeader": true,
"Separator": ";",
"TrackingIDIndex": 1,
"ReturnTrackingIDIndex": 66,
"PackageIDIndex": 0,
"InvoiceNumberIndex": 22
}
]
}
Import & Export
🟩 Bug fix: A capacity limit on reservations caused an import stop for orders. (590692)
🟩 Bug fix: Commas were not recognized as decimal separators for imported orders, which caused false sums in pixi. (611175)
🟪 Enhancement: With pixi 22.03 an issue concerning the import of category and supplier IDs was resolved. pixi 22.04 comes with changes to the current category and supplier synchronization:
The synchronization of the category (CatgoryID) is changed from certain triggers to item import.
The synchronization of the supplier (SupplNr and SupplierId) is changed from certain triggers to item import and web (creating a new item and updating the supplier of an item).
The information of a supplier (Supplier, Supplier ID, Supplier Item Number and Supplier Price) is now populated in pixi clients (Bin Client > Item Info) and in web (Item Management > Items > Edit Item > tab Suppliers) at the same time.
Due to these changes, "ConfigType" was removed from the intermediate tables (suppliers tab)
These changes were made to ensure data consistency, improve performance and prevent deadlocks. Additionally, upcoming features can be implemented more easily. (584395, 584396)
🟪 Enhancement: The channel setting PlentyCustomerNrExternal was enhanced with a new parameter: PlentyOrderNumber. If the channel setting is set to PlentyOrderNumber, the order is imported with a prefix PON_ and the PlentyOrderId (pixi OrderNrExternal) as CustomerNrExternal (e.g. PON_355). (598586)
Control Center
🟪 Enhancement: Tracking of user activities with Google Analytics can be disabled via database setting Google Analytics. Before this release, the setting only affected pixi Mobile. From pixi 22.04 also prevents any kind of tracking in pixi web and for pixi Connector. After the database setting is enabled, the settings will be effective on the next day. (603540)
Invoices (ESR QR Payment Slips)
🟩 Bug fix: The country name was displayed in the last row of Swiss vendor addresses, which led to irritations because it was not the valid address format. (583187)
Reports
🟩 Bug fixes: The calculation of the delta value was incorrect in several reports. It is now modified to (Delta = (1-(Turnover CP/Turnover Net))*(-100)). The following 4 reports have been modified accordingly: (579298)
Turnover By Items
Turnover By Item Variants
Turnover By Suppliers
Turnover By Categories
Template Editor
🟪 Enhancement: Return Forms can now be added and edited in the Template Editor. The variables are identical to those used for invoices and the return form is downloadable. (517254, 517281, 517283)
🟪 Enhancement: Templates Invoices and Credits were added as a new document type to the Template Editor. (574677, 503866)
🟪 Enhancement: New variables were added to the delivery note template: (552885)
Gross Shipping costs
Gross Total
Net Shipping costs
Net Total
Voucher ID
🟪 Enhancement: The invoice template was enhanced with parameter Not delivered. (574680)
Updates, New Client Versions and Installer
Contact our support team for an update appointment
Via email: Click the following link, fill out the email template and send it to servicedesk@descartes.com.
Via the portal: Log in to the Portal and open a Ticket.
Updates can either be done from Monday to Friday between 7:00 am and 5:00 pm or overnight. Ask the pixi Support team for an appointment.