Build 558

Enhancements 12

E40399 - APS Object to Remove Package Lines & Packages from a Shipment by Sales Order No & Shipment No

E40399     12/18/2012

APS Object to Remove Package Lines & Packages from a Shipment by Sales Order No & Shipment No

[dbeer 03/30/2012 13:53 (GMT -04:00)] The Customer APS project is in need of a new APS (PP4) object that I can use in Agility to pass the Shipment No and Order No to and have the object delete the wsPkgLin records regardless of the line_no associated with that order #. If when all of the wsPKGLin records have been deleted, the wsPKG record no longer has any associated wsPKGLin records, the wsPKG record should be deleted as well.

E41267 - Full Form Validation that allows navigation on form with Validation rules to allow lose focus on failed validation

E41267     12/18/2012

Full Form Validation that allows navigation on form with Validation rules to allow lose focus on failed validation

E41296 - POP Pick Tickets Objects added for Agility

E41296     12/18/2012

POP Pick Tickets Objects added for Agility

Mike to put wisys.wmspickmanagement.dll into source safe. Bryce can use that as a baseline for POP Allocation. [bhollinger 06/11/2012 11:25 (GMT -04:00)]

E41586 - Develop change methods for wspkgshipment, wspkg and wspkglin to change the udf’s

E41586     12/18/2012

Develop change methods for wspkgshipment, wspkg and wspkglin to change the udf’s

E41587 - Add New return Property of Pkg_id on all Pkg create methods

E41587     12/18/2012

Add New return Property of Pkg_id on all Pkg create methods

E41590 - Add Property to Add Items to Floating Pkgs to consolidate the Item if it already exists on the Pkg

E41590     12/18/2012

Add Property to Add Items to Floating Pkgs to consolidate the Item if it already exists on the Pkg

APS request. On the Itemaddtopkg object there is a consolidate flag. However that is for shipping and requires an order. We have a need for that same functionality on the floating pallets. If I add an item to a floating package that is the same item and same lot that already exists on the pallet it creates another line. It really should add to the existing line.

E44052 - When two people are concurrently logged into the same job and one of the two employees closes the operation the other record is deleted

E44052     12/18/2012

When two people are concurrently logged into the same job and one of the two employees closes the operation the other record is deleted

Symptoms: When two people are concurrently logged into the same job and one of the two employees closes the operation the other record is deleted. Please change this so that if another user is currently clocked into the same operation the operation cannot be closed until the other employee has clocked out.

E46857 - During PO receiving they would like to enter the Pack slip reference number in the Agility receiving screen

E46857     12/18/2012

During PO receiving they would like to enter the Pack slip reference number in the Agility receiving screen

Symptoms: Fields are not visible and need to be enabled for data entry

E47511 - Cut and Past Agility Process Grids when in Lock Format Mode and Grids

E47511     12/18/2012

Cut and Past Agility Process Grids when in Lock Format Mode and Grids

Symptoms: Can we copy both cells and rows. For a Process grid we could copy the row or in format mode we do get focus on a cell. Need to make a final decision on capability [bhollinger 11/01/2012 14:57 (GMT -04:00)]

E48104 - Right Mouse Click on the PP4 Tree exposes the Delete Package option which needs to be better controlled

E48104     12/18/2012

Right Mouse Click on the PP4 Tree exposes the Delete Package option which needs to be better controlled

Symptoms: Delete Package can delete all inner packs and items and very hard to reverse on user error Two new options to turn off the Delete Globaly for the site Add Warning message if the Delete Package is selected [bhollinger 11/20/2012 10:38 (GMT -05:00)]

E48105 - Right Mouse Click on the PP4 Tree exposes a menu of options that need to follow the Button Disable Rule

E48105     12/18/2012

Right Mouse Click on the PP4 Tree exposes a menu of options that need to follow the Button Disable Rule

Symptoms: Right Mouse Click on the PP4 Tree exposes a menu of options that need to follow the Button Disable Rule [bhollinger 11/20/2012 10:41 (GMT -05:00)]

E48220 - Product Updater Renew need to read proxy settings from XML instead of Windows Registry

E48220     12/18/2012

Product Updater Renew need to read proxy settings from XML instead of Windows Registry

Symptoms: Product Updater may not renew updaterrenew.exe if proxy settings are missing from the Windows Registry.

Resolved Issues 56

B35508 - RE: Resource Field in GBKMUT table empty when production is reported with shop floor

B35508     12/18/2012

RE: Resource Field in GBKMUT table empty when production is reported with shop floor

[ahayner 11/22/2011 16:39 (GMT -06:00)] the record in Gbkmut is not being populated with the resource when production is being reported.

B41256 - Develop Cycle Count Method for Pallet Counting

B41256     12/18/2012

Develop Cycle Count Method for Pallet Counting

Symptoms: Develop methods that can be used for Pallet Cycle Counting. ClearPKGTagCount, CountTagPKG, CountTagPKGAccumulateQty, CreateTagPKG, PostTagCountPKG

B41354 - Need to add Ability to call Pkg Print DLL as an overload to pass through the username

B41354     12/18/2012

Need to add Ability to call Pkg Print DLL as an overload to pass through the username

B42526 - Change Audit namespace from WiSys.Audit to Wisys.Audit

B42526     12/18/2012

Change Audit namespace from WiSys.Audit to Wisys.Audit

Symptoms: The Wisys.Audit Root namespace should be changed to be consistent with the wisys object library. Change Audit namespace from WiSys.Audit to Wisys.Audit.

B42854 - Form Studio does not prompt that an Item is in use when deleting from a form

B42854     12/18/2012

Form Studio does not prompt that an Item is in use when deleting from a form

Symptoms: Delete a field that is being referenced in a form level startup formula. You are not prompted that the field is in use. Resolution: This has been resolved in Build 558

B42947 - Pick Ticket Allocations are not managing the selling UOM for Bin and Lot Allocations

B42947     12/18/2012

Pick Ticket Allocations are not managing the selling UOM for Bin and Lot Allocations

Symptoms: Enter a Selling UOM Item on an order that that is binned or lotted. The Allocation logic does not manage the Bin and lot qty adjustment for the selling UOM. The error is a check rules error of Detail does not match the header qty. [bhollinger 06/19/2012 12:05 (GMT -04:00)]

B43352 - Product Updater on some systems keeps asking to Update

B43352     12/18/2012

Product Updater on some systems keeps asking to Update

Symptoms:

B43393 - Update Invoice Object to write Inv_no to wsPKGLin as UDF15

B43393     12/18/2012

Update Invoice Object to write Inv_no to wsPKGLin as UDF15

Symptoms: Use UDF15 to store the Inv_no - check for object wsPKGLin prior to doing the update [bhollinger 07/03/2012 12:03 (GMT -04:00)]

B43739 - the user can by pass the lot number field and by canceling and add Item to Package

B43739     12/18/2012

the user can by pass the lot number field and by canceling and add Item to Package

Symptoms: See Document

B43912 - BOL Doesn't print for UPS Shipments but does work on a reprint

B43912     12/18/2012

BOL Doesn't print for UPS Shipments but does work on a reprint

Symptoms: Check the BOL Print option using the older Doc setup and it does not print. [bhollinger 07/23/2012 15:14 (GMT -04:00)]

B43956 - Product updater icon missing on desktop shortcut and program files group

B43956     12/18/2012

Product updater icon missing on desktop shortcut and program files group

Symptoms:Product updater icon missing on desktop shortcut and program files group

B43959 - WiSys Label User password is not created correctly

B43959     12/18/2012

WiSys Label User password is not created correctly

Symptoms:WiSys Label User Password is not created correctly when updating

B44198 - POST POLINHSTINSERT-cPOordlin:InsertLineHistory:CmdInsertHistory:ProcessSQL:String or binary data would be truncated

B44198     12/18/2012

POST POLINHSTINSERT-cPOordlin:InsertLineHistory:CmdInsertHistory:ProcessSQL:String or binary data would be truncated

Symptoms: User gets the following error when trying to receive against an item using standard PO Receiving in PocketES. Error: Post: POLINHST Insert - cPoordlin:InsertLineHistory:CmdInsertHistory:ProcessSQL:String or binary data would be truncated. The statement has been terminated. Steps to Duplicate: 1. Log into PocketES with a user id greather than 10 characters (ie Administrator) 2. Try to receive against an item from an open PO. 3. Receive above error.

B44428 - WiSys User Security error after DB move or restore

B44428     12/18/2012

WiSys User Security error after DB move or restore

Symptoms: After moving a database to a new server or restoring a database to an existing server, the Update WiSys Security from the Product Updater menu does not fix the WiSys User or the WiSyslabels user.

B44654 - Receiving via fedex and shipping by truck is not updating the Ship Via in the Shipment

B44654     12/18/2012

Receiving via fedex and shipping by truck is not updating the Ship Via in the Shipment

Symptoms: Enter a Shipment and then change the Ship Via on the order. Shipment was not updating. [bhollinger 08/15/2012 15:17 (GMT -04:00)]

B44986 - Confirm Ship is Writing OE hdr Audit records for every confirm ship rather than once for the entire order

B44986     12/18/2012

Confirm Ship is Writing OE hdr Audit records for every confirm ship rather than once for the entire order

Symptoms: Add properties to bypass the Order Header Audit Begin and Change records when confirm shipping, confirm billing, and unconfirm shipping.

B44987 - APS Confirm Ship is Writing OE hdr Audit records for every confirm ship rather than once for the entire order

B44987     12/18/2012

APS Confirm Ship is Writing OE hdr Audit records for every confirm ship rather than once for the entire order

Symptoms:

B45453 - Multiple lot numbers apply incorrectly in APS Item Entry

B45453     12/18/2012

Multiple lot numbers apply incorrectly in APS Item Entry

Symptoms:

B45583 - Update to Pick Pack Message "Serial Lot will go negative" to include the Item and Serial/Lot

B45583     12/18/2012

Update to Pick Pack Message "Serial Lot will go negative" to include the Item and Serial/Lot

Symptoms: When there is not enough material in a stage bin and the material has a serial lot number, the error message includes "Serial Lot will go Negatvie". Please update this message to include the item # and serial lot # that is going to go negative. Steps to Duplicate: 1. Create an order with a serial/lot part # 2. Build a shipment for that order in pick pack (either 3 or 4) 3. Add ther serial lot item to the shipment but do not transfer the inventory into the stage bin 3. Try to confirm ship & receive message

B45658 - Package line not calulating weight properly when consolidatinig added Lines

B45658     12/18/2012

Package line not calulating weight properly when consolidatinig added Lines

Symptoms: When adding items to a package with the consolidate flag = true the weight at the PKG level does not get recalculated correctly to reflect the added weight. To duplicate add a binned, lotted item to a package on a shipment. Then add the same item, bin and lot with the consolidate flag = true. The weight on the PKG (wsPKG) will not equal the total weight of the line(s) (wsPKGLIN) on the package.

B45806 - BOM Reference Designators not being created correctly when greater than 60 characters in ES

B45806     12/18/2012

BOM Reference Designators not being created correctly when greater than 60 characters in ES

Symptoms: When adding an item to a BOM and including Reference Designators greater than 60 characters the reference designator is broken into 1 character inserts into imrefdes_sql

B45842 - difficulty printing labels to ues1aplbl1 from scanner gun wisys05

B45842     12/18/2012

difficulty printing labels to ues1aplbl1 from scanner gun wisys05

Symptoms: User reported a case where they are getting a printing error when doing PO receipts on the gun. they do a PO receipt and it sends the label to the queue. However, before that label prints, they do another PO receipt and receive this error: "Save reports to local: the process cannot accept the file 'c:\documents and settings\wisys05\appliationdata\wisys\agility\docs\recvpicpo.rpt'because it is being used by another process."

B45912 - TagCount method is updating the imlsmst_sql.Tag_Qty when performing a

B45912     12/18/2012

TagCount method is updating the imlsmst_sql.Tag_Qty when performing a

Symptoms: The imlsmst_sql.tag_qty is being updated when performing a TagCount of a lotted item. This value should not be modified as part of the TagCount

B46222 - A Validation message can incorrectly be displayed after a default button action is processed

B46222     12/18/2012

A Validation message can incorrectly be displayed after a default button action is processed

Symptoms: A Validation message can incorrectly be displayed on a field where AllowNull = false after a default button action is processed and form is refreshed.

B46391 - Agility crash if using USB scale and pressing the F5 key more than once.

B46391     12/18/2012

Agility crash if using USB scale and pressing the F5 key more than once.

Symptoms:

B46401 - If I put the same line item on 2 separate cartons for a serialized item, the detail qty is doubling upe line item on 2 separate cartons for a serialized item, the detail qty is doubling up

B46401     12/18/2012

If I put the same line item on 2 separate cartons for a serialized item, the detail qty is doubling upe line item on 2 separate cartons for a serialized item, the detail qty is doubling up

Symptoms:. If I put the same line item on 2 separate cartons for a serialized item, the detail qty is doubling up and causes the confirm ship to fail.

B46410 - Out of Memory Exception Error causing Pick tickets not to clear & line items to drop off

B46410     12/18/2012

Out of Memory Exception Error causing Pick tickets not to clear & line items to drop off

Symptoms: When loading prior to the CR engine rendering the print job the error message "Update:oUpdateForChange:UpdateHeaderTotalsForOrderCreate:iBilling:PostBillingUpdates:cOerdhdr Read:GetDetailRecords:ReturnValues :Exception of type 'System.OutOfMemoryException' was thrown. The error in the past happened after printing. The memory error can seen be seen when Reprinting a large number of picktickets multiple times.

B46568 - IM Quantity Adjustment gives Serial Lot Numbers required message

B46568     12/18/2012

IM Quantity Adjustment gives Serial Lot Numbers required message

Symptoms: IM Quantity Adjustment gives the CheckRules message Serial or Lot Numbes Required for this Transaction, none were included. Serial and Lot Numbers are not included on a Qty Adjustment.

B46627 - Validaiton Message is displayed when adding a component to a BOM with a Qty Per Parent = 0 / BulkIssue Flag prevented on OE MFG item

B46627     12/18/2012

Validaiton Message is displayed when adding a component to a BOM with a Qty Per Parent = 0 / BulkIssue Flag prevented on OE MFG item

Symptoms: When adding a component to a BOM Product Structure you will receive a validation message if the Qty per Parent is = 0 Bulk Issue Flag should be available for OE Mfg items (Macola Documentation states that this is not valid; however, they do allow it)

B46687 - Add connection property to Create Item Location to allow it to be called from Agility

B46687     12/18/2012

Add connection property to Create Item Location to allow it to be called from Agility

Symptoms: Add connection property to Create Item Location to allow it to be called from Agility. Also need a public UserName property exposed.

B46692 - COD amt does not include tax

B46692     12/18/2012

COD amt does not include tax

Symptoms: When shipping an order COD, sales tax does not carry through to the total in ShipRush Steps to Duplicate: 1. Add an Order in Macola and add sales tax to the amount. 2. Set the Ship Via code to UPS 3. Make sure the terms used on the order is set up in the terms code mapping for COD 4. Print the pick ticket 5. Build a shipment and add the item to the order 6. Click the UPS button to ship the order 7. Select the 'special shipment' button to bring up the Ship Rush interface 8. View the COD Amount field does not include sales tax

B46695 - Setup Management for 9190 Has been Created and Field Deployed

B46695     12/18/2012

Setup Management for 9190 Has been Created and Field Deployed

Symptoms: Control Setup for 9190 for initial setup and cold reboot [bhollinger 10/08/2012 10:21 (GMT -04:00)] Symptoms: Cold boot resetting date Wireless network is disabled on setup Data Wedge set to no sound Data Wedge speed needs to be set The interlacing speed is set to the lowest setting we cannot send over 50-100 characters. This would eliminate the support of 2d bar code labels.

B46711 - if the cus_alt_adr_cd is blank in the ARALTADR_SQL table code is adding cus_name to oeordhdr table

B46711     12/18/2012

if the cus_alt_adr_cd is blank in the ARALTADR_SQL table code is adding cus_name to oeordhdr table

Symptoms: [jnicol 10/08/2012 13:03 (GMT -04:00)]in Progression if the cus_alt_adr_cd in the ARALTADR_SQL is blank (the OE object will use the cus_name value as the cus_atl_adr_cd in the OEORDHDR table when creating a new order. It should be left blank and so the OEORDHDR table is written with a null for ARALTADR_SQL.

B46737 - Each Package type should have their own seq range as they are added with the PKG object method

B46737     12/18/2012

Each Package type should have their own seq range as they are added with the PKG object method

Symptoms:

B46738 - When PP4 cannot find the xml file or a default printer it would be more efficient to pop up a printer list and set the Printer Options on the fly

B46738     12/18/2012

When PP4 cannot find the xml file or a default printer it would be more efficient to pop up a printer list and set the Printer Options on the fly

Symptoms:

B46953 - when Using a display field and flagging it as User Entered Default assignation does not work

B46953     12/18/2012

when Using a display field and flagging it as User Entered Default assignation does not work

Symptoms:[asonnenschein 10/16/2012 08:13 (GMT -05:00)]Flag Display field as user entered. Go to the default and see that you can select variable. However, after selecting variable you can not pick the variable to use.

B47005 - Error combining cartons

B47005     12/18/2012

Error combining cartons

Symptoms:At the PP4 terminal when we try to drag an item from one carton to another, for banding cartons, we receive the error below. "EDI errors cannot be moved"

B47098 - PO Receipt RI/MRB not defaulting to IMCTILFIL accounts if IMTYPLOC has not been setup

B47098     12/18/2012

PO Receipt RI/MRB not defaulting to IMCTILFIL accounts if IMTYPLOC has not been setup

Symptoms: PO Receipt RI/MRB not defaulting to IMCTILFIL accounts if IMTYPLOC has not been setup.

B47176 - Audit Trail for Macola ES POP Orders stores 10 characters of the user name instead of 20

B47176     12/18/2012

Audit Trail for Macola ES POP Orders stores 10 characters of the user name instead of 20

Symptoms: Macola ES POP Audit Username is being limited to 10 characters when the column supports 20 characters. This also occurs from the Bill of Material Product Structure audit.

B47190 - Cycle Count Updates - Tag Post before Macola Tags and Updates to wsSerialTagFil and wsSerialTagHst

B47190     12/18/2012

Cycle Count Updates - Tag Post before Macola Tags and Updates to wsSerialTagFil and wsSerialTagHst

Symptoms: Cycle Count Updates - Tag Post before Macola Tags and Updates to wsSerialTagFil and wsSerialTagHst

B47250 - Issue with PO Receiving when doing a negative receipt

B47250     12/18/2012

Issue with PO Receiving when doing a negative receipt

Symptoms: When doing a negative PO Receipt against a Purchase order with a negative quantity ordered the qty remaining is calculating as a positive number instead of remaining at zero which affects MRP. Steps to duplicate: 1. Add a PO with a negative quantity 2. Do a negative PO Receipt against the line that has the negative quantity. 3. The calculation for the qty remaining will be a positive number and should remain at zero.

B47488 - Process Grid Not Populating Default Value

B47488     12/18/2012

Process Grid Not Populating Default Value

Symptoms: If you create a process grid which has user entered fields with a control type of MEMO and have a defaul value source from a view. The memo fields do not populate with the default value as they should. If you change this value to string they populate correctly. Please adjust this so the memo field will accept the default value like the text edit. [jlenkey 31-10-2012 16:24 (GMT -04:00)]

B47506 - Can't export custom report data in AE, works in Designer

B47506     12/18/2012

Can't export custom report data in AE, works in Designer

Symptoms: This issue should be investigad again with the new Runtime and method change to fix Default Printer Page Size. For now all MDI launched report screens will allow export. [bhollinger 11/01/2012 13:56 (GMT -04:00)]

B47522 - PO number assigned skips a number

B47522     12/18/2012

PO number assigned skips a number

Symptoms: Creating a new PO increments the poctlfil_sql.starting_po_no by 2. Does not reset the value if a rollback occurs. Item Weight is not defaulted from the item master

B47577 - Client reports that the checkbox on pivot grids to disable the graph is no longer available

B47577     12/18/2012

Client reports that the checkbox on pivot grids to disable the graph is no longer available

Symptoms:All pivot grids now have graphs - client wants to be able to control the presenation of the graph as he used to be able to do

B47743 - Pick ticket history prints to wrong printer

B47743     12/18/2012

Pick ticket history prints to wrong printer

Symptoms: Pick Ticket History always prints to the windows default printer. Steps to Duplicate: 1. Set default printer in Windows to printer 'A' 2. Under Agility --> System --> System Manager --> Printer Definition, set the Pick Ticket to use 'Printer B' 3. Print a Pick Ticket using Agility WMS Pick Management - output should come out on Printer B 4. Open Agility WMS Pick Ticket History and select the order printed in step 3 and select the REPRINT button. - output will come out on the windows default printer 'A' instead of the printer defined for the pick ticket

B47812 - Update Files - Could not load file or assembly 'Interop.IWshRuntimeLibrary'

B47812     12/18/2012

Update Files - Could not load file or assembly 'Interop.IWshRuntimeLibrary'

Symptoms: Update Files - Could not load file or assembly 'Interop.IWshRuntimeLibrary, Version=1.0.0.0, Culture=neutral, PublicToken=null' or one of its dependencies. The system cannot find the file specified. at wsProdUpd.frmMain.CreateShortCut(String sShorcutCopy, String sShortcutCreate) at wsProdUpd.frmMain.GetShortcutFromServer(DataRow row, String& sRtnErr) Method: GetShortcutFromServer

B47937 - PO Create Object in Agility was failing on Line Create for Receiving Inspection Items

B47937     12/18/2012

PO Create Object in Agility was failing on Line Create for Receiving Inspection Items

Symptoms: When using Agility PO Header Create II and PO Line Create II Objects to create PO's from sales orders in Agility, it doesn't handle receiving inspection items.

B47946 - Account numbers on shipment getting set to 0000-000 for 2nd shipment of an order

B47946     12/18/2012

Account numbers on shipment getting set to 0000-000 for 2nd shipment of an order

Symptoms: When a partial shipment is done, Macola resets the account fields to zero instead of Null and therefore the object views the zeros as a valid account number and doesn't set the correct account number as a result.

B48014 - Unable to add a Non Inventory Item to a PO in Printed Status

B48014     12/18/2012

Unable to add a Non Inventory Item to a PO in Printed Status

Symptoms: Adding a non inventory item to a PO that is in a Printed status returns PoOrdHdr:AddLineItem set OnOrder:Post :ChangeQtyFields - cIminvloc:ChangeQtyFields:Record Not Found

B48103 - On a Form either as a Form Trx or as a Button the last field does not get Validated

B48103     12/18/2012

On a Form either as a Form Trx or as a Button the last field does not get Validated

Symptoms:

B48257 - PKG Object Bug in Form Studio - AddItemToPackage

B48257     12/18/2012

PKG Object Bug in Form Studio - AddItemToPackage

Symptoms:When using this object to add a binned/Lotted item to a package I am getting an error: The total quantity of lot numbers does not match the quantity packed. Please review your transaction.

B48481 - Customer Insert fails with "cCustomer:Insert:New Customer was not added" and a -1 return code.

B48481     12/18/2012

Customer Insert fails with "cCustomer:Insert:New Customer was not added" and a -1 return code.

Symptoms: Internal logic was looking for a single record inserted returned by from the SQLDataClient. If a Trigger exists, for audit purposes for example, it's possible that more than 1 record can be inserted.

B48588 - Inventory Location Qty Backorderd being updated for non OE Pulled Orders

B48588     12/18/2012

Inventory Location Qty Backorderd being updated for non OE Pulled Orders

Symptoms: iminvloc_sql.qty_bkord is being updated during report production for non OE POP Pulled items.

B48606 - APS - PP4 - EDI Integration - Every shipment is integrating to Exact EDI even if it is not an EDI customer.

B48606     12/18/2012

APS - PP4 - EDI Integration - Every shipment is integrating to Exact EDI even if it is not an EDI customer.

Symptoms: When a customer ships a shipment using the APS (PP4) Shipping Tree in Agility, every shipment is integrating to Exact EDI even if it is not an EDI customer.

B48668 - Print Pick Tickets - Order Line Cleanup

B48668     12/18/2012

Print Pick Tickets - Order Line Cleanup

Symptoms: If an error occurs during the PrintPicktickets method call, a cleanup routine will be executed to try and remove any allocations created, clear the extra_6/filler_0004 field, and clear the picked_dt on the selected lines. If an error occurs during the ReprintPickTickets method call, a cleanup routine will be executed to clear the extra_6/filler_0004 from the marked lines.