Build 568

Enhancements 65

E100803 - Added Support for Service code items to OE CREATE LINE Object

E100803     4/10/2019

Added Support for Service code items to OE CREATE LINE Object

[Ronald Cortes 10/11/2016 14:44 (GMT -04:00)] OE CREATE LINE Object does not support service item codes. Request to add service item codes to oe order line create object

E138006 - Roles-would like to copy role

E138006     4/10/2019

Roles-would like to copy role

Symptoms: Need to be able to copy a role. Because users are unable to modify our base roles, they would like to copy our base role and then add/remove items from the roles Solution: Copy Role is now available. Users can copy a WiSys Role or any role which will then allow them to modify that role and make it unique to their company.

E145921 - FS/AM Add Option To Execute SQL Inside SAP Transaction Wrapper

E145921     4/10/2019

FS/AM Add Option To Execute SQL Inside SAP Transaction Wrapper

A new checkbox option has been added to Form Studio Advanced Query Builder screen to Execute SQL inside of an SAP Transaction Wrapper. This is used when you need to query or manipulate transactional data that has been modified by the SAP DiAPI.

E158635 - NEW: Add an Agility Mobile device option to hide the virtual keyboard

E158635     4/10/2019

NEW: Add an Agility Mobile device option to hide the virtual keyboard

Enhancement: Add an Agility Mobile device option to hide the virtual keyboard when Agility Mobile is displayed in Tablet Mode

E172498 - Am Essentials: Goods Receipt PO

E172498     4/10/2019

Am Essentials: Goods Receipt PO

Mobile Form: Goods Receipt PO

E172499 - Ad: Essentials Batch Availability Grid

E172499     4/10/2019

Ad: Essentials Batch Availability Grid

Created Batch Availability Grid

E172522 - Ad: Essentials Batch Availability with Bins

E172522     4/10/2019

Ad: Essentials Batch Availability with Bins

View grid that displays inventory batches available and which bin they are in

E172523 - Ad: Essentials Inventory Transfer Requests Grid

E172523     4/10/2019

Ad: Essentials Inventory Transfer Requests Grid

View inventory transfer requests in a grid.

E172526 - Ad: Essentials: Production Order Component PO Creation

E172526     4/10/2019

Ad: Essentials: Production Order Component PO Creation

Process grid that shows production order components that are purchased and allow the user to create purchase orders and link them, using UDFs, to the production component row. This may have to be put on the menu by a WiSys or certified consultant

E172527 - Ad: Essentials Production Order Batch Pick List Creation

E172527     4/10/2019

Ad: Essentials Production Order Batch Pick List Creation

Process grid that shows all the production order components and allows the user to create a inventory transfer request. This inventory transfer request can then be used to create a pick and pack manager pick list if desired. This document can be used for batch picking of components for multiple production orders.

E172528 - Ad: Essentials: Production Orders

E172528     4/10/2019

Ad: Essentials: Production Orders

View grid that displays all non-complete production orders. Also can act as a workspace where production orders can be accessed and created from this grid

E172529 - Ad: Essentials: Production Resources

E172529     4/10/2019

Ad: Essentials: Production Resources

View grid which shows all open production order resource components. This can function as a resource or work center dispatch report

E172530 - Ad: Essentials: Purchase Order Container Receipt

E172530     4/10/2019

Ad: Essentials: Purchase Order Container Receipt

Process grid which displays all purchase order lines for a specific warehouse (which should be your in-transit warehouse) and allows one to select the items and quantities to do a purchase order receipt and automatically create an inventory transfer request to be used when the container is actually received. This does two (2) SAP Business One transactions in one step.

E172531 - Ad: Essentials: Purchase Orders

E172531     4/10/2019

Ad: Essentials: Purchase Orders

Work space grid to view all purchase orders

E172532 - Ad: Essentials Purchase Order Receipts

E172532     4/10/2019

Ad: Essentials Purchase Order Receipts

Work space grid to view purchase order goods receipts

E172533 - Ad: Essentials: Purchase Order Returns

E172533     4/10/2019

Ad: Essentials: Purchase Order Returns

Work space view grid to look at all Purchase Order Returns

E172534 - Ad: Essentials: Purchase Order Return Requests

E172534     4/10/2019

Ad: Essentials: Purchase Order Return Requests

Work space view grid that shows all purchase order return requests

E172535 - Ad: Essentials: Purchase Requests

E172535     4/10/2019

Ad: Essentials: Purchase Requests

Work space view grid that displays purchase requests

E172536 - Ad: Essentials: Sales Delivery Orders

E172536     4/10/2019

Ad: Essentials: Sales Delivery Orders

Work space view grid that displays sales delivery orders

E172537 - Ad: Essentials: Sales Order Batch Pick List Creation

E172537     4/10/2019

Ad: Essentials: Sales Order Batch Pick List Creation

Process grid that shows sales order lines and the user can select the lines to create an inventory transfer request to be used for batch picking of sales orders. One can also create a pick and pack manager pick list to use for directed picking on our handheld/mobile form

E172538 - Ad: Essentials: Sales Orders

E172538     4/10/2019

Ad: Essentials: Sales Orders

Work space grid which displays sales orders

E172540 - Ad: Essentials: Sales Quotations

E172540     4/10/2019

Ad: Essentials: Sales Quotations

Work space view grid that shows sales quotations

E172541 - Ad: Essentials: Sales Return Requests

E172541     4/10/2019

Ad: Essentials: Sales Return Requests

Work space view grid that displays sales return requests

E172542 - Ad: Essentials: Sales Returns

E172542     4/10/2019

Ad: Essentials: Sales Returns

Work space view grid that displays Sales Returns

E172543 - Ad: Essentials: Serial Number Availability

E172543     4/10/2019

Ad: Essentials: Serial Number Availability

Work space view grid that displays serial numbers available

E172550 - Ad: Pallets: Inventory Pallet View

E172550     4/10/2019

Ad: Pallets: Inventory Pallet View

View grid that shows open Agility Pallet containers

E172551 - Ad: Pallets: Inventory Pallets on Hold

E172551     4/10/2019

Ad: Pallets: Inventory Pallets on Hold

View grid that displays all Agility Pallet containers with an on hold status

E172552 - Ad: Pallets: Inventory Pallets vs On Hand

E172552     4/10/2019

Ad: Pallets: Inventory Pallets vs On Hand

View grid that shows pallet quantities and bin location quantity on hand problems

E172553 - Ad: Fulfillment: Fulfillment Manager

E172553     4/10/2019

Ad: Fulfillment: Fulfillment Manager

Desktop screen that builds containers (pallets and cartons) and also brings in shipments built on the mobile device forms. Printing labels, bills of ladings and LTL and small package integration is also available .

E172562 - Am: Essentials: Goods Receipt PO

E172562     4/10/2019

Am: Essentials: Goods Receipt PO

Mobile Goods Receipt PO form

E172563 - Ad: Essentials: Sales Order Delivery

E172563     4/10/2019

Ad: Essentials: Sales Order Delivery

Mobile form that creates delivery orders from sales orders. Typically is used the the sales order pick list.

E172565 - Am: Essentials: Directed Sales Order Picking

E172565     4/10/2019

Am: Essentials: Directed Sales Order Picking

Mobile form to scan a pick and pack manager pick list and create a sales order delivery order. If the pick list contains more than one sales order, multiple sales order deliveries will be created. Also, the bin that is on the pick list can be changed as needed during the picking process.

E172566 - Am: Essentials: Directed Picking

E172566     4/10/2019

Am: Essentials: Directed Picking

Mobile form that picks items on a pick and pack manager pick list. It works with any order type: production order, sales order or inventory transfer request. Since this only does the picking, someone then needs to go into SAP Business One and copy the pick list to a warehouse transfer, production component issue and/or a sales order delivery

E172567 - Am: Essentials: Directed TR Picking

E172567     4/10/2019

Am: Essentials: Directed TR Picking

Mobile for to process pick and pack manager pick list and then creates an inventory transfer request.

E172569 - Am: Essentials: Directed Prod Order Picking

E172569     4/10/2019

Am: Essentials: Directed Prod Order Picking

Mobile for to process pick and pack manager pick lists associated with production order components. Production component issues can be created from the mobile form.

E172570 - Am: Essentials: Order Picking

E172570     4/10/2019

Am: Essentials: Order Picking

Uses Pick Pack and Production Manager Pick List, typically for a non-bin tracked warehouse. A user would need to do the sales order delivery, transfer request or production component issue manually. This is similar to the Directed Picking function but without bins.

E172571 - Am: Essentials: Put Away (Distribution Tab)

E172571     4/10/2019

Am: Essentials: Put Away (Distribution Tab)

Mobile form that uses the options default receiving bin and allows the user to easily do a bin transfer for an item.

E172572 - Am: Essentials: Goods Issue

E172572     4/10/2019

Am: Essentials: Goods Issue

Mobile form that performs a Inventory Goods Issue transaction

E172573 - Am: Essentials: Inventory Goods Receipt

E172573     4/10/2019

Am: Essentials: Inventory Goods Receipt

Mobile form that performs inventory goods receipt transactions

E172575 - Am: Essentials: Warehouse Transfer

E172575     4/10/2019

Am: Essentials: Warehouse Transfer

Mobile form that creates warehouse transfer transactions

E172577 - Am: Essentials: Bin Transfer

E172577     4/10/2019

Am: Essentials: Bin Transfer

Mobile form to process bin transfer transactions

E172579 - Am: Essentials: Inventory Transfer

E172579     4/10/2019

Am: Essentials: Inventory Transfer

Mobile form that creates warehouse transfer transactions

E172582 - Am: Essentials: Inventory Count by Bin

E172582     4/10/2019

Am: Essentials: Inventory Count by Bin

Mobile form which creates inventory cycle count sheet transactions by bin

E172583 - Am: Essentials: Inventory Count by Item

E172583     4/10/2019

Am: Essentials: Inventory Count by Item

Mobile form to process inventory cycle count sheets by item transactions.

E172584 - Am: Essentials: Item View

E172584     4/10/2019

Am: Essentials: Item View

Mobile form to view all the bins and quantity in each by item.

E172587 - Am: Essentials: Batch View

E172587     4/10/2019

Am: Essentials: Batch View

Mobile form to view all of a specific item's batches and the quantity on hand of each batch, by warehouse.

E172589 - Am: Essentials: Bin Audit

E172589     4/10/2019

Am: Essentials: Bin Audit

Mobile form to look at all the items and their related quantities in a specific bin

E172590 - Am: Essentials: Pick List View

E172590     4/10/2019

Am: Essentials: Pick List View

Mobile form to view a specific pick list

E172593 - Am: Essentials: Put Away (Production Tab)

E172593     4/10/2019

Am: Essentials: Put Away (Production Tab)

Mobile form which uses the mobile options default production receipt/completion bin to allow for quick put away to a bin from production orders.

E172594 - Am: Essentials: Production Backfill

E172594     4/10/2019

Am: Essentials: Production Backfill

Mobile form that performs a composite transaction: Created production order, releases production, production completion which automatically back flushes backflush type items and then closes the production order.

E172595 - Am: Essentials: Production Issue (Components)

E172595     4/10/2019

Am: Essentials: Production Issue (Components)

Mobile form that creates production component issue transactions.

E172596 - Am: Essentials: Production Receipt

E172596     4/10/2019

Am: Essentials: Production Receipt

Mobile form than creates production order completion transactions.

E172597 - Am: Essentials: Production Return (Component)

E172597     4/10/2019

Am: Essentials: Production Return (Component)

Mobile form that creates production component return transactions.

E172598 - Am: Pallet Production

E172598     4/10/2019

Am: Pallet Production

Creates pallets during production completion transactions and creates the production completion transaction itself.

E172599 - Am: Pallet Builder

E172599     4/10/2019

Am: Pallet Builder

Mobile form to build a pallet, typically used at the receiving dock.

E172600 - Am: Pallets: Pallet Builder Multiple

E172600     4/10/2019

Am: Pallets: Pallet Builder Multiple

Mobile form to build multiple pallets for an item at one time, typically used at the receiving dock.

E172601 - Am: Pallets: Pallet Transfer

E172601     4/10/2019

Am: Pallets: Pallet Transfer

Mobile form that creates bin to bin transfer of pallets.

E172602 - Am: Pallets: Pallet Letdown

E172602     4/10/2019

Am: Pallets: Pallet Letdown

Mobile form that removes a pallet and puts all the item/quantities on that pallet into a specific bin. Typically used for replenishing a picking bin.

E172603 - Am: Pallets: Pallet View

E172603     4/10/2019

Am: Pallets: Pallet View

Mobile form that is used to view the contents of pallet: Item, Quantities, Batches and/or Serial#'s

E172604 - Am: Pallets: Print Pallet Label

E172604     4/10/2019

Am: Pallets: Print Pallet Label

Mobile form that allows one to print or reprint a pallet label

E172605 - Am: Fulfillment: Pack Cartons

E172605     4/10/2019

Am: Fulfillment: Pack Cartons

Mobile form used to pack cartons for a shipment related to a sales order. One can create a sales delivery order once all cartons have been packed on the mobile device.

E172606 - Am: Fulfillment: Unpack Cartons

E172606     4/10/2019

Am: Fulfillment: Unpack Cartons

Mobile form to unpack a previously packed carton for a shipment, typically to fix a problem.

E172607 - Am: Fulfillment: Load Pallets

E172607     4/10/2019

Am: Fulfillment: Load Pallets

Mobile form to load existing pallets to a shipment, which is related to a sales order.

E172608 - Am: Fulfillment: Unload Pallets

E172608     4/10/2019

Am: Fulfillment: Unload Pallets

Mobile form to unload a pallet that was previously loaded to a shipment.

E172609 - Am: Fulfillment: Unpack Pallets

E172609     4/10/2019

Am: Fulfillment: Unpack Pallets

Mobile form to unpack a pallet that was packed for a shipment. Typically used to fix an error.

Resolved Issues 13

B84356 - Form Studio ForceFieldStop does not work if value is assigned by a SQL Event

B84356     4/10/2019

Form Studio ForceFieldStop does not work if value is assigned by a SQL Event

Symptoms: The Form Studio ForceFieldStop property does not stop on the field if the value is set by a SQL Event or Validation Trx. It will only work if the value is set by a Formula.

B86835 - doesn’t seem to update the OEORDHDR_SQL table with zero for frt_amt

B86835     4/10/2019

doesn’t seem to update the OEORDHDR_SQL table with zero for frt_amt

Symptoms: Agility Billing object update on frt amount and misc amount will not update if there is a value there and the user wants to reset to 0 and enters 0. The billing proceeds and it appears it works, but the frt amt and/or misc amount is not updated to 0. Wisys.OETrx.PostBillingUpdates now includes two properties ClearFreightAmount and ClearMiscAmount. When billing you can set these properties to True to clear the Freight and/or Misc amounts on the order header.

B88491 - Add support for leading spaces in the Bin No

B88491     4/10/2019

Add support for leading spaces in the Bin No

Symptoms: When using a bin number with preceding spaces the system will retain the spaces when creating the bin but not when transferring

B88567 - Package Qty Adjust does not allow the removal of a kit component

B88567     4/10/2019

Package Qty Adjust does not allow the removal of a kit component

Symptoms: Package Qty Adjust does not allow the removal of a kit component. It throws an error about parent being unbalanced

B89794 - Ship stagging qty remaining does not change as processing order

B89794     4/10/2019

Ship stagging qty remaining does not change as processing order

Symptoms: Ship Staging form does not reduce the "Remaining" qty. The "Staging" transaction object for the inventory transfer is not writing the doc_ord_no or the line_no to allow the transfer to be associated to the order number and line that it was processed for and reduce the remaining Solution: New Validation added for Staging to look at what has been staged vs shipped - StageValidateOrderItem. Standard Ship Staging application has been updated t use this new validation.

B105600 - Add Kit Component pallet to a shipment

B105600     4/10/2019

Add Kit Component pallet to a shipment

Symptoms: Component of a kit is on a floating pallet by itself. It needs to be added to the shipment. Business object returns an error saying that it is not on the order. Solution:

B121551 - PS.PalletBuilderValidateItem Validation should exclude wspkglin records that are confirm shipped

B121551     4/10/2019

PS.PalletBuilderValidateItem Validation should exclude wspkglin records that are confirm shipped

The PS.PalletBuilderValidateItem does not excludes the pallets that have been shipped confirmed (Status 'S' or 'C') when calculating the QtyUnpacked value that is returned from the validation. If the pallets that where shipped are not excluded it uses the pallet line qty in the calculation which results in a negative qty.

B147001 - issue with not validating current user connection ID in HANA

B147001     4/10/2019

issue with not validating current user connection ID in HANA

Symptoms: this is only a HANA problem. Go into Form Studio, while in also go into Agility Designer. look at the wisysconcurrency table and you will not see 2 entries like there should be. Solution:

B151804 - Add SAP support for SQL Server 2016

B151804     4/10/2019

Add SAP support for SQL Server 2016

Symptoms: When running Agility Mobile against a SAP Business One 2016 SQL Server database a ReadLicense error occurs. Solution:

B153290 - Crystal Report connection failed on HANA server

B153290     4/10/2019

Crystal Report connection failed on HANA server

Symptoms: When migrating a Crystal report from one Hana server to another the ODBC RDO connection is not being updated. Solution:

B153487 - Agility Web Role setup - button security - Add all button to select all child buttons

B153487     4/10/2019

Agility Web Role setup - button security - Add all button to select all child buttons

Symptoms: Agility Web Role setup - button security - Add all button to select all child buttons Solution: A "Select All" item highlighted in blue as been added to the top of the "Non-Menu Applications section for the Agility Web > Components that grants security for the buttons attached to applications.

B153640 - Form doesn't allow additional actions if a Close Action has already been defined on the button

B153640     4/10/2019

Form doesn't allow additional actions if a Close Action has already been defined on the button

Symptoms: Form studio doesn't allow additional action to be added if last action is close action. Step must be removed and added back in after additional action is added. Additional Actions can now be added if a Close action already exists in the Action sequence. Solution:

B155296 - AM Exception when moving forms running in Tablet Mode

B155296     4/10/2019

AM Exception when moving forms running in Tablet Mode

A System.InvalidOperationException can be thrown when forms are moving if the collection of open forms changes.