Build 568.2

Enhancements 3

E158525 - Support for SOTPI ASN's

E158525     9/20/2019

Support for SOTPI ASN's

Symptoms: SOTPI ASN compliance requires the ability to create shipments with mixed cartons and pallets. Some pallets only, cartons on pallets and cartons only all as EDI packages on the same shipment. Solution: Write to the OrderP table in DataMasons for all packages where the EDI flag is turned on for the PKG Type that has items directly on it.

E161657 - Add Catch Weight Settings To Form Studio

E161657     9/20/2019

Add Catch Weight Settings To Form Studio

Symptoms: Add Catch Weight Settings To Form Studio #CatchWtRcptPO #CatchWtProdRcpt #CatchWtDelvNote

E163015 - Form Studio - Update item validations to accept lot numbers

E163015     9/20/2019

Form Studio - Update item validations to accept lot numbers

In Agility Mobile for SAP add the ability to scan a lot number as substitute to identify the item code for the following Item Validations. Inventory TransferRequestValidateItem Inventory ValidateItem Inventory ValidateItemWarehouse Packing And Shipping LoadPalletValidatePkgItem Packing And Shipping PalletBuilderValidateItem Packing And Shipping PkgValidateSalesOrderItem Production Order ProductionIssueValidateItem Production Order ProductionReturnValidateItem Purchase Order GoodsReceiptValidatePOItem Purchase Order GoodsReceiptValidatePOItemReceiving Sales Order PickListValidateSalesOrderItem Sales Order SalesOrderValidateItem

Resolved Issues 21

B89128 - Exception when right-clicking on a linked grid

B89128     9/20/2019

Exception when right-clicking on a linked grid

Symptoms: Clicking on the bottom empty space of the OE Pick Management without placing any data using filters throws and object not set to an instance of an object error. It would be easy enough to tell the customer not to right click on an empty disassociated grid but Don said write it up so here ya go. To Duplicate Open OE Pick Management Do not enter any data in the filter and click OK. On the bottom grid , in any open space under the fields right click. You will receive the error

B160286 - Cost different on GL when unconfirm shipping after changing iminvloc cost

B160286     9/20/2019

Cost different on GL when unconfirm shipping after changing iminvloc cost

Symptoms: When using OE UnConfirm Ship process and Macola OE Package Settings "Cost to Use When Posting" is set to Actual. The GL dollar amount will differ if the cost has changed between Confirm Ship and UnConfirmShip processes being run. Macola posts the same dollar amount as the original confirm ship transaction. Solution:

B161529 - add a Bin_no property to QtyAdjust Trx

B161529     9/20/2019

add a Bin_no property to QtyAdjust Trx

Symptoms: Add a bin_no property (UpdateBinNo) to QtyAdjust object. If this property is filled in, change the wspkg record to this bin number during the qtyAdjust method. Validate that the bin does exist. Solution:

B161767 - Add OITM.DocEntry to BOInv.ValidateItem

B161767     9/20/2019

Add OITM.DocEntry to BOInv.ValidateItem

Symptoms: Add the column OITM.DocEntry to the BOInv.ValidateItem validation Solution:

B162021 - Cannot span a lotted kit component across two packages

B162021     9/20/2019

Cannot span a lotted kit component across two packages

Symptom: Spanning a lotted kit component across two packages results in a duplication error upon shipping.

B162022 - Add Mfg Stage Bin and InTransit Receiving Bin to Device Settings

B162022     9/20/2019

Add Mfg Stage Bin and InTransit Receiving Bin to Device Settings

Symptoms: Add Mfg Stage Bin and InTransit Receiving Bin to the default device settings in Agility Mobile and Form Studio

B162113 - using PO number in a Lot number works in Form Studio Not in an agility grid.

B162113     9/20/2019

using PO number in a Lot number works in Form Studio Not in an agility grid.

Symptom: PO lot setup in Agility/File/Options/WMS/Serial Lot Numbers/Purchase Orders/Lots uses the Purchase order from a tablelookup poordlin_sql(or hdr) ie. Year+JulianDay+poordhdr_sql.ord_no with the ord_no being padded with zeros. Produces a proper lot number when receiving through form studio (i.e(201919900015700) However, the same PO on the PO Receipts grid in Agility, when clicking on the lot field produces 201919900000000 PO Receipts grid Lot number field fails to use the Purchase order number Resolution:Order number was not getting passed into the serial-lot builder routine. fixed code to allow passing of the order number.

B162827 - Adding users and assigning roles can cause GUID conversion error

B162827     9/20/2019

Adding users and assigning roles can cause GUID conversion error

Symptoms: When adding a new user or assigning roles in SAP B1 a GUID conversion error can occur.

B163017 - Form Studio crashes when you have invalid SQL in a SQL Event Action

B163017     9/20/2019

Form Studio crashes when you have invalid SQL in a SQL Event Action

When you have invalid SQL in a SQL Event, Lookup, Grid definition (such as an Update statement) Form Studio will crash. A warning message will now be displayed, so the application does not exit and you can remove the invalid SQL.

B163114 - A With block variable not set Error can occur when printing an Agility Label

B163114     9/20/2019

A With block variable not set Error can occur when printing an Agility Label

Symptoms: When printing a WiSys Label from From Studio an error is returned. Error reads "PrintDocuments:Object variable or With Block variable not set.: Error Point 9" Solution:

B163185 - Form Studio SQL queries with spaces in a condition can be truncated

B163185     9/20/2019

Form Studio SQL queries with spaces in a condition can be truncated

Form Studio SQL queries with spaces in the condition can be truncated. For example: Select * from [table] where [column] = ' 789' will be come Select * from [table] where [column] = ' 789'

B163212 - Remove Receiving and System Bin Restrictions from the default bins selection in Agility Mobile

B163212     9/20/2019

Remove Receiving and System Bin Restrictions from the default bins selection in Agility Mobile

The selection of a default bin requires the Bin to be a Receiving Bin and a Non System Bin. These restrictions should be removed.

B163365 - Agility Label Designer second attempt to print from Print Preview throws an exception

B163365     9/20/2019

Agility Label Designer second attempt to print from Print Preview throws an exception

Symtom: In Agility Label designer a second attempt to Print from the print preview screen results in an exception. Solution: Code was changed to allow for consecutive printing of labels.

B163423 - Form Studio - Add Terms Maintenance Options to Grids

B163423     9/20/2019

Form Studio - Add Terms Maintenance Options to Grids

Add Terms Maintenance Options to Form Studio Grids. When Right Clicking on a grid column header in Form Studio the Change Column Heading screen will be presented. This will allow you to assign a Term Code to the heading or enter a hard coded column header. The right click option is available when previewing a Form at design time from Form Studio.

B163519 - Create Form Studio PalletBuilder Bin and Batch Validations

B163519     9/20/2019

Create Form Studio PalletBuilder Bin and Batch Validations

Validations needed in order to validate the qty available for an binned and batched items on a pallet BOBin.PalletBuilderValidateBin BOBatch.PalletBuilderValidateBatch

B163597 - Material Issue can generate a Cannot insert the value NULL into column error

B163597     9/20/2019

Material Issue can generate a Cannot insert the value NULL into column error

Transactions that insert into the MCDISFIL (i.e. Material Issue) can generate a "Cannot insert the value NULL into column error" when a field was left blank and the SDK attempted to insert a NULL value in place of the empty string. dist_type,mn_no,sb_no,dp_no,job_no,ord_no,control_no,jnl_src,id_no,par_item_no

B164093 - Agility Mobile Production Bin Setting not being refreshed

B164093     9/20/2019

Agility Mobile Production Bin Setting not being refreshed

The Agility Mobile Production Bin setting was not being refreshed without exiting Agility Mobile and logging back into the application.

B164186 - Error received trying to create new dashboard

B164186     9/20/2019

Error received trying to create new dashboard

Symptoms: AD - creating new Analytic - select Data Source > Add Query - error received "Cannot connect to the database. See the details below. The ConnectionString property has not been initialized." Solution:

B164370 - Need to display date in Euro format

B164370     9/20/2019

Need to display date in Euro format

Symptom: grid Date formats shows as mm/dd/yyyy when it should be showing dd/mm/yyyy in euro format. Resolution: Code was changed in DevExpres to allow for proper reading of reginal codes.

B166146 - Error Bypassed When Confirm Shipping Component Items

B166146     9/20/2019

Error Bypassed When Confirm Shipping Component Items

Symptoms: When confirm shipping a parent item in Form Studio Shipping form and a lock is encountered on a component. The inventory transaction on the component will timeout but will continue processing additional components. This only happens if the component isn't the first one in the BOM. If the component is the first component and a timeout is encountered the entire process will stop. The inventory issue transaction doesn't not happen for the components where a timeout occurred but does for all others. This is causing inventory to be off for any component items that were locked. Solution: Transaction should be aborted and all transactions should be rolled back.

B165992 - Views for BOL and Label need to be changed

B165992     9/20/2019

Views for BOL and Label need to be changed

Symptoms: