Agility 360 Add options to print to printers seen by the native device
Agility 360 - Add options to print to printers seen by the native device. A new WMS option will be available to define IP Printers. When an IP Printer is selected for printing the document will be returned to the Android device where it will send ZPL Labels directly to the device's local IP Printer.
Add Soft Warning to SAP's Pallet Count Form if pallet has already been counted.
The soft warning should warn a user that the pallet has been counted already. Counting again will add qty to already counted qty. If you are attempting to adjust to new quantity entered use the adjust button.
Form Studio Agility Objects That Contain Overloads Are Not Being Selected Properly
When selecting an Agility Object in Form Studio that contains an optional overload method the method parameters are not being returned based off of the selection. An example is the Wisys.Shipping.Ship class Pkg Ship Shipment and Pkg Ship Shipment 2. The incorrect method is selected when viewing the New Object Definition form. Also when browsing and selecting a new Agility Object Transaction, properties and parameters are appended to the existing list; existing values should be cleared.
Error when removing Additional Item Validations
Symptoms: When removing an item from Agility > Options > Additional Item Validations screen and hit OK, you receive an error "Error writing: EnforceSerialLotDate: Insert: sql syntax error: Incorrect syntax near "?" line 1 col 29 (at pos 29). Solution:
Add PickListSalesOrderLineItem Validation
Add a new PickListSalesOrderLineItem validation for Directed Sales Order Picking. The Pick No, Order, Line, and Item information will be passed to validate that the scanned item directly matches the directed pick item recommendation. The pick status must be R, P, or D and the RelQtty must be greater than 0.
Address field limit in UPS/FedEx
Symptoms: When shipping the address is being truncated to 35 characters without warning. Solution: Produce warning for address if lines exceed 35 characters and allow user to edit prior to processing shipment. Possibly prevent user from shipping until field is corrected. Wisys.AgilityShipUI.v5.0 and Wisys.AgilityShip.v5.0 have been updated.
Transfer Order Preload - Enable transfer of lines that are not using default inventory UoM
Symptoms: When the UoM is different from the inventory UoM, the line needs to use the quantity for the document UoM and the bin snb record needs to use the quantity for the inventory UoM Solution:
Agility Essentials Options - General not saving properly
The Show Batch Exp Date and Show Mfg Serial checkbox options are not being saved correctly on the options screen. If the ShowBatchExpDatePO option is turned on it is incorrectly displaying the Show MFG Serial option as turned on.
SAP Inventory Counting Objects process very slowly for larger Count Sheets
SAP Inventory Counting Objects process very slowly for larger Count Sheets when counting lines at the end of the count sheet ,Added new method that requires the line number from the counting sheet. Validations were also modified to use sql queries instead of the xml read that was slowing down the validations.
Terms Import is deleting unrelated Terms Type and System Types
When importing terms non matching Terms Type and System Type codes are being deleted preventing you from importing multiple terms xml from the Wisys Terms directory. For example, you can not import Terms_en_US_SAP.xml and Terms_en_US_SAP_Common.xml. When importing the second terms file all terms from the first file are deleted.
GoodsReceiptValidatePOItem error occurs with items that are mixed case and AllowCaseSensitiveScan is off
GoodsReceiptValidatePOItem will throw an exception when scanning a mixed case item number such as "MRP_Item1" when the AllowCaseSensitiveScan enterprise option is turned off. GoddsReceiptValidatePOItem: Object reference not set to instance of an object
ProductionReturnValidateBatch - Incorrect syntax near the keyword FOR
The SAP ProductionReturnValidateBatch validation throws an invalid syntax error. Incorrect syntax near the keyword 'FOR' The underlying SQL contained a semicolon. When using an SAP DoQuery in SQL Server, SAP appends the FOR BROWSE clause onto the end of the statement. The semicolon short circuits the statement, and has been removed.
Unable to assign Fulfillment Manager Plugin in AE Options
Unable to assign Fulfillment Manager Plugin in the Options. This goes undetected because of a suppressed error on the staging bin when saving the options. The staging bin error should be corrected and the error should not be supressed.
LTL Process Failed. Ship:ProcessConfirmOrSHipDeliveryNote.Enter a Valid value in "Whse" field [Message 0-0]
LTL Process Failed. Ship:ProcessConfirmOrSHipDeliveryNote.Enter a Valid value in "Whse" field [Message 0-0] When shipping From Warehouse with Mixed Case. Updated code in the package modules that was changing warehouse codes and item codes to upper case.
U_AGYFREIGHTPAYCODE UDF Field is not being copied to Delivery Document when default is defined in SAP
U_AGYFREIGHTPAYCODE UDF Field is not being copied to Delivery Document when default is defined in SAP. When the delivery document is created as part of shipping the selected U_AGYFREIGHTPAYCODE is not copied to the delivery document.
Labels do not update properly in Shipping Account > New
File > Options > Agility Shipping > Shipping Account > New When switching from FedEx to UPS or USPS, the label for License Number/Meter does not change. Once it becomes Meter number by selecting FedEx, the only way to get it to change is to exit and reopen the window.
Agility Shipping Zip code needs to allow extended zip
When entering a zip code with an extra zip separated by a hyphen (#####-####); you will receive Unable to ship:ProcessShipment:Input string was not in a correct format. Solution: FedEx and UPS do not allowed the 9 digits zip code. The zip is now truncation even with hyphen in both Shipping Form and Silent Mode.
Agility Shipping Account password not populating when opening saved entry
When opening a saved entry in the Agility Shipping Accounts option screen, the password field is not populated with the saved information. This will then cause a blank password to be saved if it is not re-entered.
Cannot ship kits in Hana
Symptoms: Can not ship Kits in Hana. Receive error: LTL Process failed:Ship:ProcessConfirmOrShipDeliveryNote:There was a problem with the Deliver Document Process. 1470000368 - The quantity allocated to bin locations must be positve. In this case the kit components are serialized. Solution:
Kit Lines out of order on sales order caused delivery note to fail
When an item is changed on an order that involves a Sales BOM, The LineNum was used to order the lines on the delivery rather than the VisOrder, This caused the delivery to fail in Fulfillment manger. Corrected the ordering of lines in the delivery that was causing an issue with sales kits.
Third Party Maintenance is erroring on UPS or Fedex acct entry
Symptoms: If you go into third party maintenance and you try to type in a fedex (9 char) or UPS (6 char) in the account number it is giving you an error. I recorded the proof of it and attached it to this dev task. Go into B1 and make sure there is a ship to address. Go into Third Party Maintenance and put in the customer - select fedex for example (does not matter) Then put in the account number (9 digits) and with or without the rest of the information tab off. It will show the error. This is only after an update to current code this weekend by Jim. Solution:
Update PkgValidateSalesOrderItem Validation to exclude closed sales order lines
Symptoms: Pkg Validation Sales Order Item will return closed sales order lines allowing users to pack against a closed line when using Pack Cartons, Pack Pallets or Load Pallets. This will then cause issue when attempting to ship the shipment. Solution: Valid line statuses are (O)pen/(C)losed. An error will now be returned if the LineStatus is not equal to "0"
AE Hana Fulfillment Manager can exhaust the connection pool
The AE Hana Fulfillment Manager can exhaust the connection pool when executing the various ribbon bar button options. This can be observed by watching database sessions consistently increase as new shipments are built, packages and cartons are created, and items added to the shipment.
Hana case issue with BOInv.InventoryCountValidateDocNumber
Inventory Count by Item form using BOInv.InventoryCountValidateDocNumber returns invalid column error "DOCENTRY",The original inventory count validations used the SAP xml objects which contained different column names vs the OINC and INC1 tables. The aliased columns were kept for backwards compatibility but caused an issue in Hana based on how the wsValMetaTableColumns.IsFunction option worked. A script and code change was required to properly support this option.
Agility Shipping weight and dimension rounding
Symptoms: Package weight rounding in the Agility Shipping UI is causing an overweight error when shipping USPS packages that have a 13 ounce limit. Solution: Agility Shipping UI will no longer round to the whole number but will display and pass a decimal value to the carrier APIs.
Update Serial Range Objects to support alpa chars
Several methods to update. The objects accept a string as a sFromSerial but fail during transaction,WiSys.SAPDocument.v5.0.dll,WiSys.SAPDocument.POReceipt.CreatePrelooadSerialRangebyQuantity,WiSys.SAPDocument.POReceipt.CreatePrelooadSerialRange,WiSys.SAPDocument.ProductionReceipt.CreatePreloadSerialRangeByQuantity,WiSys.SAPDocument.ProductionReceipt.CreatePreloadSerialRange,WiSys.SAPDocument.GoodsReceipt.CreatePreloadSerialRangeByQuantity,WiSys.SAPDocument.GoodsReceipt.CreatePreloadSerialRange,
When capturing an object(Plug in) on the hana server the following error is received: Error in inserting into wsObjects: cWsObjects: Insert:cmdInsert:ProcessSQL:;sql syntax error: incorrect sintax nere "[": line 1 col24(at pos 24)
When capturing an object(Plug in) on the hana server the following error is received: Error in inserting into wsObjects: cWsObjects: Insert:cmdInsert:ProcessSQL:;sql syntax error: incorrect sintax nere "[": line 1 col24(at pos 24)