Build 569.5

Hot Fixes 1

B209140 - Agility 360 Startup Information Messages are not displayed to the user

B209140     1/1/0001

Agility 360 Startup Information Messages are not displayed to the user

Form Studio Startup Event Messages are not being displayed to the user in Agility 360

Enhancements 29

E186939 - SAP B1 - Sales Return Request

E186939     7/10/2023

SAP B1 - Sales Return Request

Added Return Request form to the Agility Essentials project.

E190447 - Add ability to not refresh grid on form cancel

E190447     7/10/2023

Add ability to not refresh grid on form cancel

Grids no longer refresh when the users hits cancel on a form opened from a button

E190901 - Create Pack Cartons From Pick List form

E190901     7/10/2023

Create Pack Cartons From Pick List form

Added new forms to WMS Packing; Pick to Carton and Pick to Pallet

E190901 - Create Pack Cartons From Pick List form

E190901     7/10/2023

Create Pack Cartons From Pick List form

Create Pack Cartons From Pick List form

E191911 - All SAP Essentials Forms should handle Multi-Branch

E191911     7/10/2023

All SAP Essentials Forms should handle Multi-Branch

SAP Agility Essentials Forms updated to handle multi-branch transactions

E194538 - SO Picking Pick Object Speed performance.

E194538     7/10/2023

SO Picking Pick Object Speed performance.

When using the SO Picking Pick Object Speed performance is an issue and causes delay when a picklist has 50 + items. Logic was added to increase the efficiency when picking a pick list with a large amount of items on the pick list.

E196559 - Sales Return Object from either a A/R Delivery or a A/R Return Request.

E196559     7/10/2023

Sales Return Object from either a A/R Delivery or a A/R Return Request.

Created a new Sales Return Object from either a A/R Delivery or a A/R Return Request.

E204842 - Add Return Label functionality to Agility Shipping

E204842     7/10/2023

Add Return Label functionality to Agility Shipping

Add Options and UI changes to support the creation of Return Labels in Agility Shipping

E208928 - Separate the Agility Shipping Label by Carrier

E208928     7/10/2023

Separate the Agility Shipping Label by Carrier

Split the Agility Label print function by carrier so the labels can be sent to different printers if needed.

E208969 - Create Object to create multiple packages and add to a shipment

E208969     7/10/2023

Create Object to create multiple packages and add to a shipment

This can be an overload of wisys.pkgtrx.pkgadd.addfloatpackageswithitems. or wisys.pkgtrx.pkgadd.addpackagewithitems.,The wisys.pkgtrx.pkgadd.addpackagewithitems may be best option adding qty per and allow partial method parameters.

E208988 - Agility Shipping - Add International Shipping

E208988     7/10/2023

Agility Shipping - Add International Shipping

Add support to Agility Shipping to ship from the United States to Canada as phase 1 of support for international shipping.

E209001 - Copy view should make use the right-mouse click button to copy the currently selected Agility element

E209001     7/10/2023

Copy view should make use the right-mouse click button to copy the currently selected Agility element

When in Agility Design studio the user should be able to highlight an Agility element on the list and by doing a right-click begin the copy process for that item

E209014 - Create a daily shipment summary grid in Fulfillment manager

E209014     7/10/2023

Create a daily shipment summary grid in Fulfillment manager

Added a Daily Shipment Summary grid to Fulfillment Manager to view shipments by date.

E209015 - Create a daily shipment summary Crystal Report to print from daily shipment summary grid

E209015     7/10/2023

Create a daily shipment summary Crystal Report to print from daily shipment summary grid

Added a Daily Shipment Summary Crystal Report that can be printed from the Daily Shipment Summary grid.

E209031 - Create form to transfer pallet from one warehouse to another

E209031     7/10/2023

Create form to transfer pallet from one warehouse to another

Added a warehouse pallet transfer form to the standard pallet project

E209039 - Create Purchase Request Document in SAP Preload/Post

E209039     7/10/2023

Create Purchase Request Document in SAP Preload/Post

Document object updated to allow creation of purchase request

E209041 - Create Object/Method to Copy Purchase Request to Purchase Order

E209041     7/10/2023

Create Object/Method to Copy Purchase Request to Purchase Order

Added new class/method to the Wisys.SAPDocument.dll. The new class is PurchaseOrder and the new method is CreateFromPurchaseRequest. This method requires the CardCode and BaseEntry and will return the PostedDocEntry

E209047 - Shipping Ship-Via and Payment Type mapping

E209047     7/10/2023

Shipping Ship-Via and Payment Type mapping

When setting up ShipVia mapping using Freight Pay Code. You can map an invalid Service\Payment type combination (FedEx Priority Overnight\Collect.) Add validation prior to shipping and passing information to Carrier.

E209053 - Add Checkbox for Single Sales Return in WiSys Options

E209053     7/10/2023

Add Checkbox for Single Sales Return in WiSys Options

Add Checkbox for Sales Return Single Transaction in WiSys Options

E209057 - Agility Shipping - Carrier Return Labels

E209057     7/10/2023

Agility Shipping - Carrier Return Labels

Add support to generate, print, and archive UPS, FedEx, and USPS carrier return labels during the initial shipment process.

E209073 - Create AR Credit Memo from AR Return Request

E209073     7/10/2023

Create AR Credit Memo from AR Return Request

When a return request is created from an AR Invoice, SAP only allows a credit memo to be created. An object is needed to copy an AR Return Request to an AR Credit Memo

E209101 - Updated UPS API Security

E209101     7/10/2023

Updated UPS API Security

Add support for UPS OAuth Security Token when accessing the APIs

E209134 - Create Goods Receipt PO by Item form in SAP

E209134     7/10/2023

Create Goods Receipt PO by Item form in SAP

Added Goods Receipt PO by Item form in SAP to the Essentials project.

E209135 - Add ability to reprint carrier labels per package in Fulfillment Manager (Pick Pack)

E209135     7/10/2023

Add ability to reprint carrier labels per package in Fulfillment Manager (Pick Pack)

Buttons were added to Reprint Agility Shipping Carrier Labels in Fulfillment Manager

E209168 - Pick List picking does not support manufacturer serial numbers

E209168     7/10/2023

Pick List picking does not support manufacturer serial numbers

Added support to the Pick method of the SalesOrderPicking object in the Wisys.SAPDocument dll to pick by manufacturer serial number.

E209171 - Sales/Purchasing Preload processing does not support manufacturer serial numbers

E209171     7/10/2023

Sales/Purchasing Preload processing does not support manufacturer serial numbers

E209172 - Sales/Purchasing Posting does not support manufacturer serial numbers

E209172     7/10/2023

Sales/Purchasing Posting does not support manufacturer serial numbers

Added support for manufacturer serial numbers on Sales and Purchasing documents

E209194 - Adjust forms to support Manufacturer Serial number transactions

E209194     7/10/2023

Adjust forms to support Manufacturer Serial number transactions

Add manufacturer serial support to Serial Transaction forms:

E209216 - Pending Document View - add mfg serial number to grid

E209216     7/10/2023

Pending Document View - add mfg serial number to grid

Added Mfg Serial numbers to Pending Document views on handheld forms.

Resolved Issues 58

B193138 - Wisys.Shipping can deadlock in Agility 360

B193138     7/10/2023

Wisys.Shipping can deadlock in Agility 360

Wisys.Shipping can deadlock in Agility 360 when multiple users are performing shipping based transactions on the handheld

B194429 - Fulfillment Manager - Freight multiplying on the shipment record if delivery fails

B194429     7/10/2023

Fulfillment Manager - Freight multiplying on the shipment record if delivery fails

Corrected logic to recalculate freight each time the delivery is attempted.

B195118 - Shipping Tree Integrate ASN not available with Agility Shipping

B195118     7/10/2023

Shipping Tree Integrate ASN not available with Agility Shipping

When Agility Shipping is turned on the Integrate ASN process tab will now be visible.

B196206 - Unable to Save settings in the Shipping Freight Write-Back menu when opened from inside of SAP

B196206     7/10/2023

Unable to Save settings in the Shipping Freight Write-Back menu when opened from inside of SAP

The Wisys Packing and Shipping option, "Shipping Freight Write-Back", will not save any changes when accessed through the SAP menu. The problem is caused by the “Save” button on the pop up, which is not currently functioning. The bug exists in both SQL and Hana.

B200456 - Shipping Accounts - NEW Form field focus order

B200456     7/10/2023

Shipping Accounts - NEW Form field focus order

Symptoms: Field sequence order did not allow user to tab through fields in order. Solution: Sequence has been adjusted so users can tab through the fields in order from top to bottom.

B200542 - Foreign Freight is being calculated incorrectly when a Sales Order is Delivered

B200542     7/10/2023

Foreign Freight is being calculated incorrectly when a Sales Order is Delivered

Foreign Freight is being calculated incorrectly when a Sales Order is Delivered

B200806 - Sales Item fail when creating delivery note from Pick list

B200806     7/10/2023

Sales Item fail when creating delivery note from Pick list

Symptoms: Sales Item fail when creating delivery note from Pick list Solution:

B201772 - A blank question pops up when using if-then-else statement even if a question is not used

B201772     7/10/2023

A blank question pops up when using if-then-else statement even if a question is not used

In Agility Explorer, A blank question pops up when using if-then-else statement even if a question is not used.

B201809 - Pack Pallets/Std Cartons Order Look Up Issue

B201809     7/10/2023

Pack Pallets/Std Cartons Order Look Up Issue

The Order Field lookup on the Pack Std Carton and Pack Pallets was changed from DocEntry to DocNum

B202170 - LTL Process Failed. Ship:ProcessConfirmOrSHipDeliveryNote.Enter a Valid value in "Whse" field [Message 0-0]

B202170     7/10/2023

LTL Process Failed. Ship:ProcessConfirmOrSHipDeliveryNote.Enter a Valid value in "Whse" field [Message 0-0]

Symptoms: LTL Process Failed. Ship:ProcessConfirmOrSHipDeliveryNote.Enter a Valid value in "Whse" field [Message 0-0] When shipping From Warehouse with Mixed Case Solution:

B202455 - Load wsPkgShipPmtMapping Payment_SDK_Cd missing

B202455     7/10/2023

Load wsPkgShipPmtMapping Payment_SDK_Cd missing

Values in the Load wsPkgShipPmtMapping Payment_SDK_Cd were missing which causes errors in certain shipments.

B203565 - Shipment no is not incrementing in HANA

B203565     7/10/2023

Shipment no is not incrementing in HANA

Objects updating wsSettings_sql.LongValue where SettingName = NextTruck was silently failing instead of updating. This caused the shipment number to not increment in HANA

B203894 - Carton/Pallet Pop up screen Data Query not correct in SAP

B203894     7/10/2023

Carton/Pallet Pop up screen Data Query not correct in SAP

Updated the Carton/Pallet pop up screen query (Pkg4 Use PkgSizePicker) in SAP

B203895 - Agility Shipping Carton Weight Screen does not save height on last pacakge

B203895     7/10/2023

Agility Shipping Carton Weight Screen does not save height on last pacakge

You cannot tab or enter past the last HEIGHT entry in the Agility Shipping Carton Weight Screen to save any updated package dimensions. Users have to ALT-TAB

B204241 - Agility 360 - Device Settings Filter Returns Wrong Row

B204241     7/10/2023

Agility 360 - Device Settings Filter Returns Wrong Row

When using the search to filter a Device Settings grid such as Warehouse or Bins, the wrong row is being selected.

B204243 - Start Up Query not populating document variable

B204243     7/10/2023

Start Up Query not populating document variable

When printing documents and passing a variable such as customer number from a grid button startup query, the variable(s) were not being passed to the Print Doc Type Actions in Agility Explorer.

B205044 - Serial Lot builder and Item Validation in same Action Sequence cause a SQL Lock

B205044     7/10/2023

Serial Lot builder and Item Validation in same Action Sequence cause a SQL Lock

The Serial Lot Builder is using the Non-Transaction SQL Connection when executed from FS/AM/Agility360. The lock occurs when you use the Serial Lot Builder Seq Global option which updates the wsSettings and an item validation which checks the wsSettings table for the alternate items using a DoQuery ForBrowse. The Serial Lot Builder will now use the Transactional Connection (Agility 360 was already) and the query that returns the list of Alternate Items will no longer use a SAP DoQuery.

B205050 - Global Package Charges double when written back to SAP

B205050     7/10/2023

Global Package Charges double when written back to SAP

When using the global Packing and Shipping > Shipping > Shipping Charges to add additional charges to the freight, the amount is doubled when written back to the SAP delivery.

B206290 - PO Receipt and A/R Delivery fail with batches and serials if no base document

B206290     7/10/2023

PO Receipt and A/R Delivery fail with batches and serials if no base document

This has been tested and worked great!

B206735 - Form Studio reorder actions

B206735     7/10/2023

Form Studio reorder actions

When reordering actions in Form Studio attributes of the action may not be reordered correctly. For example, changing the sequence of the Serial Lot Builder, GeoLocation, etc... the action will lose it's mapped properties.

B206868 - Design Studio Startup Queries lose Variables and Field Mapping after being added

B206868     7/10/2023

Design Studio Startup Queries lose Variables and Field Mapping after being added

Design Studio Startup Queries lose Variables and Field Mapping after being added [Akram Mahmoud 07/28/2022 14:20 (GMT +02:00)] fixed

B208147 - Agility Shipping UPS Itemized Charges error on single package shipment

B208147     7/10/2023

Agility Shipping UPS Itemized Charges error on single package shipment

When doing a single package shipment in Agility Shipping UPS an error will occur on the itemized charges returned from the UPS API. The API response will now be properly handled by Agility Shipping

B208939 - Unable to see all form fields in DS for when working with a dekstop form.

B208939     7/10/2023

Unable to see all form fields in DS for when working with a dekstop form.

Bug fixed in Design Studio, now all available form fields are visible.

B208953 - SAP Validations Join Wisys and SAP Tables

B208953     7/10/2023

SAP Validations Join Wisys and SAP Tables

Some Form Studio Validations Join Wisys and SAP Tables which may lead to unexpected locking during a transaction. The following validations have been modified. BoBatch.PalletBuilderValidateBatch; BoBin.PalletBuilderValidateBin; BoSerial.PalletBuilderValidateSerial

B208955 - SAP Add Serial Item not passing correct bin

B208955     7/10/2023

SAP Add Serial Item not passing correct bin

When adding a serialized item in SAP Fulfillment Manager, the Stage Bin is passed to the From Bin in the Serial Lot collection screen instead of the Bin chosen on the Add Item Screen.

B208957 - Disable Add Item/Add Item(s) buttons in Fulfillment Manager unless a package is on the shipment

B208957     7/10/2023

Disable Add Item/Add Item(s) buttons in Fulfillment Manager unless a package is on the shipment

Disable Add Item/Add Item(s) buttons in Fulfillment Manager unless a package is on the shipment

B208979 - Agility Shipping - International Shipping button DBNull to type String error when opening

B208979     7/10/2023

Agility Shipping - International Shipping button DBNull to type String error when opening

Receive error when clicking the International Button in Agility Shipping LoadData: Conversion from type ‘DBNull to type 'String’ is not valid.,UPS International Form will open after that. Upon closing you will receive an Object Reference not set to an instance of an object.

B208997 - Layout selection dropdown duplicated

B208997     7/10/2023

Layout selection dropdown duplicated

The dropdown used to select layouts had a duplicated down arrow button that has now been removed

B209000 - Allow checkbox selection without focus row change not working in Design Studio

B209000     7/10/2023

Allow checkbox selection without focus row change not working in Design Studio

When Selection style is set to “Allow checkbox selection without focus row change” on a process grid, checking a selection box will no longer change the focus row.

B209007 - Package sizes grid in SAP is blank

B209007     7/10/2023

Package sizes grid in SAP is blank

The Package Size picker grid in SAP opens with the appropriate columns and records but the values are blank.

B209013 - SQLProcessor.ReturnValues RecordFound not being initialized in SAP

B209013     7/10/2023

SQLProcessor.ReturnValues RecordFound not being initialized in SAP

In an SAP environment the reference parameter RtnRecordFound is not being initialized. If the value has not been initialized in a calling method it can return an incorrect value (True/False).

B209032 - Bin lookup query in Split Pallet is incorrect

B209032     7/10/2023

Bin lookup query in Split Pallet is incorrect

Bin lookup query in Split Pallet is incorrect, it is returning duplicate records as query is looking in OIBQ

B209035 - Updates needed to Production Put Away form

B209035     7/10/2023

Updates needed to Production Put Away form

Updates to include

B209037 - Inventory Count By Item counting 0qty if stocking UOM and Counting UOM are diffrent

B209037     7/10/2023

Inventory Count By Item counting 0qty if stocking UOM and Counting UOM are diffrent

Form appears to be multiplying the Inventory QTY by 0 thus marking the line as counted but with 0 qty.

B209054 - Agility Shipping Options | Shipping Accounts should not have an option to enter by customer

B209054     7/10/2023

Agility Shipping Options | Shipping Accounts should not have an option to enter by customer

B209061 - Agility Shipping Options Capture Producer Plugin

B209061     7/10/2023

Agility Shipping Options Capture Producer Plugin

Design Studio Wisys.Options Project should be updated to include a new options screen for “Producers” or "International Producers" used when filing an international documents such as USMCA Certificate of Origin, etc.,The user control to be captured is Wisys.Options.v5.0.dll | ucAgilityShippingProducers,New WsOptionDetail record in Create WsOptionDetail.sql (Macola) and Load WsOptionDetail.sql (SAP),insert into wsOptionDetail (OptionsGroupName, ButtonName, ButtonText,SeqNo,Enabled,SecurityLvl,LicenseCode,BeginGroup,ExtraText,ProcessID),values ('AS-OPTIONS','Producers','Producers',71,1,50,null,0,null,'NEW_PROCESS_ID_HERE')

B209090 - Inventory Count Adjustment Form is passing the DocNum instead of the DocEntry

B209090     7/10/2023

Inventory Count Adjustment Form is passing the DocNum instead of the DocEntry

All @txtDocNum was changed to $DocEntry so that the form is properly using the DocEntry and not the DocNum.

B209099 - When using Standard Fullfillment and shipping consolidated order. Receive SQL error regarding docentry not found in table.

B209099     7/10/2023

When using Standard Fullfillment and shipping consolidated order. Receive SQL error regarding docentry not found in table.

SAP appears to be adding additional code to the query to obtain the document key. To mitigate this, I have removed the nolock directives (not needed) and added a primary key to the fields returned. Although I was unable to replicate this on my system, I suspect this may due to a setting in SAP for the GPDR compliance in the EU for customers records in the EU.

B209107 - When a Default Carrier is not set in the Agility Shipping Settings an unexpected error occurs

B209107     7/10/2023

When a Default Carrier is not set in the Agility Shipping Settings an unexpected error occurs

When a Default Carrier is not set in the Agility Shipping Settings an unexpected error: Failed getting starting for EDI package types is thrown. Eliminated the error message by setting the Default Carrier to an empty string if it has not been set.

B209110 - Agility Designer Format on SQL Script component throws an error that the statement can't be formatted

B209110     7/10/2023

Agility Designer Format on SQL Script component throws an error that the statement can't be formatted

The format button will no longer throw an error on SQL Scripts that cannot executed/parsed into Schema based queries that are used with Grids/Process Grids. A message will be displayed stating that it cannot be properly parsed, but will allow you to continue.

B209112 - Transfer request picking fails on the Order lookup because it uses the Doc Entry return field instead of Doc Num. Also validation being used to validated the sales order is incorrect.

B209112     7/10/2023

Transfer request picking fails on the Order lookup because it uses the Doc Entry return field instead of Doc Num. Also validation being used to validated the sales order is incorrect.

Transfer request picking fails on the Order lookup because it uses the Doc Entry return field instead of Doc Num. Also validation being used to validated the sales order is incorrect. The Validation that runs on the Sales Order should use BOInv.TransferRequestValidateOrderNumber

B209114 - Unable to Copy Components in Design Studio

B209114     7/10/2023

Unable to Copy Components in Design Studio

Error Copying View:WsProcess:CopyView: Unrecognized Guid Format when copying components in Design Studio was fixed and the Guid is now returned when copying components.

B209115 - Grid Layouts not saving properly

B209115     7/10/2023

Grid Layouts not saving properly

Column Text and Expression Columns does not save when creating a layout. This Fix corrects the issue and saves any column text or expressions columns added.

B209119 - AE Options Commodity Codes Ambiguous Column ExportCode

B209119     7/10/2023

AE Options Commodity Codes Ambiguous Column ExportCode

An ambiguous column error would occur in the AE Options Commodity Code screen when editing an existing commodity

B209125 - SAP Shipping SetDeliveryLines throwing an exception with kit items

B209125     7/10/2023

SAP Shipping SetDeliveryLines throwing an exception with kit items

When shipping kits an exception was thrown due to an invalid column name [LIN_NO]. Also, an invalid input string exception was being thrown when trying to convert a null

B209132 - Agility Shipping Location Accounts not working

B209132     7/10/2023

Agility Shipping Location Accounts not working

USPS and UPS location based shipping accounts were not being honored when creating a shipment. Location accounts were not functioning correctly when voiding a shipment for all carriers.

B209147 - User gets prompted twice for the number of copies

B209147     7/10/2023

User gets prompted twice for the number of copies

When selecting the prompt property in Document library, user gets prompted twice for the number of copies. Code to to honor the No of copies passed into the print method when bypassing the new Copies screen that was created for Desktop applications.

B209150 - Transfer Serial Number - Add Serial Validation to serial field, improve error messages

B209150     7/10/2023

Transfer Serial Number - Add Serial Validation to serial field, improve error messages

When scanning serial number it will allow you to scan any data. Only when you try to post do you get an error that serial number doesn't exist. New validations were written to improve error messaging at the time of scanning.

B209163 - Load pallets validation fails on the Item No in A360 for the BOPackingShipping.PkgValidateSalesOrderItem

B209163     7/10/2023

Load pallets validation fails on the Item No in A360 for the BOPackingShipping.PkgValidateSalesOrderItem

,Users would receive an “Index was outside the bounds of the array” error message if they entered a pallet and pressed Save without entering through the Pallet field. This action would cause issues in the processing of the transaction. The message box was relocated in the action sequence to prevent this error message.

B209169 - Pick List delivery creation does not support non-binned warehouses

B209169     7/10/2023

Pick List delivery creation does not support non-binned warehouses

When trying to create a delivery from a pick list in a non-binned warehouse, a message that the document is not found is returned.

B209176 - Cycle Count By Bin & Cycle Count By Item do NOT update Counted Qty in SAP Document when UOMCode not Manual

B209176     7/10/2023

Cycle Count By Bin & Cycle Count By Item do NOT update Counted Qty in SAP Document when UOMCode not Manual

Cycle Count By Bin & Cycle Count By Item do NOT update Counted Qty in SAP Document.

B209177 - In SAP B1 Posting the Package Count returns an error

B209177     7/10/2023

In SAP B1 Posting the Package Count returns an error

B209186 - Directed Picking form shows SQL syntax error when entering the Pick ticket number

B209186     7/10/2023

Directed Picking form shows SQL syntax error when entering the Pick ticket number

Directed Picking form shows SQL syntax error when entering the Pick ticket number in HANA environments.

B209189 - Issue Serial form lookup issues with Production Issue

B209189     7/10/2023

Issue Serial form lookup issues with Production Issue

Form is opening before parameters are set, therefore are missing from lookups. Updated the WHERE clause on the Serial lookup

B209203 - Label Reprint DocEntry Parameter is looking for String instead of Int

B209203     7/10/2023

Label Reprint DocEntry Parameter is looking for String instead of Int

Changed the PO Receiving label parameter from a String to an Integer.

B209204 - Pallet Transfer has pallet number stored in pallet lookup

B209204     7/10/2023

Pallet Transfer has pallet number stored in pallet lookup

Removed stored pallet number in filter

B209207 - Pallet Inventory Count SQL Event fails due to no FROM in the query (HANA)

B209207     7/10/2023

Pallet Inventory Count SQL Event fails due to no FROM in the query (HANA)

SQL Query was not compatible in HANA, Updated query to support SQL and HANA.

B209208 - Sales Return form View Button has Syntax Error

B209208     7/10/2023

Sales Return form View Button has Syntax Error

Form updated to pass proper value, resolving issue