Build 554

Enhancements 2

E37656 - Create Data Dictionary for PP4

E37656     3/7/2012

Create Data Dictionary for PP4

E38742 - Add additional information when a record is locked

E38742     3/7/2012

Add additional information when a record is locked

[blester 02/21/2012 14:23 (GMT -05:00)] Request to add item_no,loc, ord_no, line_no and user_name when a locked record is encountered.

Resolved Issues 25

B32527 - Commission Calculation in Order Header Create object does not support I - Item Commission method

B32527     3/7/2012

Commission Calculation in Order Header Create object does not support I - Item Commission method

Set the OE Control file to calculate commission type I - change Bolt to use Commision and then a percent - commission is zero - there are several Item level commission methods. [bhollinger 08/05/2011 18:19 (GMT -04:00)]

B33683 - Order on Credit hold for Customer on Hold or Credit Limit on Hold do not set all the fields correctly

B33683     3/7/2012

Order on Credit hold for Customer on Hold or Credit Limit on Hold do not set all the fields correctly

If I set the customer to blocked in ES or hold in Progression it sets the status to 'C' but does not set the Hold flag. If it is a credit limit check on Hold both fields are set ok. However, we do not do all the header calculations like total_dollars and Macola does. [bhollinger 09/21/2011 15:41 (GMT -04:00)]

B34835 - Order Create Object - Add Kitted Item - Cost does not role up and is set to zero

B34835     3/7/2012

Order Create Object - Add Kitted Item - Cost does not role up and is set to zero

B35068 - IM Transfer object has bug in Customer No field in Progression

B35068     3/7/2012

IM Transfer object has bug in Customer No field in Progression

[eaguirre 11/08/2011 17:58 (GMT -05:00)]If you put a Character value in the Customer field in the IM Transfer Object, it is writing it with leading zeroes...such as 00000000TEST instead of just TEST.

B35602 - Inventory Transaction Object does not write to the JobHist_sql table

B35602     3/7/2012

Inventory Transaction Object does not write to the JobHist_sql table

reviewed that object transaction and it is true we are skipping the write to the JobHist_sql table.

B35702 - An error occured adding bins with serial lots to process. Conversion from sting "^Qty" to type 'Double' is not valid.

B35702     3/7/2012

An error occured adding bins with serial lots to process. Conversion from sting "^Qty" to type 'Double' is not valid.

User gets error when shipping an order with serial lot non binned An error occured adding bins with serial lots to process. Conversion from sting "^Qty" to type 'Double' is not valid.

B35999 - Receiving cannot select printer

B35999     3/7/2012

Receiving cannot select printer

[awilson 12/08/2011 16:18 (GMT -05:00)] After our upgrade last night we are unable to select a printer when using receiving. I have confirmed this as a bug by getting on a scanner and trying to select the backdoor printer which is at the bottom of the list. I also try to select additional printers and have not been able to select any printer other than the first one on the list. Even after selecting and saving the print job will always go to the first printer on the list.

B36182 - PO Recieving trying to print a label when none exists

B36182     3/7/2012

PO Recieving trying to print a label when none exists

[dbeer 12/15/2011 12:59 (GMT -05:00)] Form Studio version of PO Receiving is prompting for a printer after every receipt even though they do not have any forms defined in Document Manager or on the handheld in Device Settings under the Doc tab. To Duplicate: 1. Go to Agility-->System-->Document Manager-->Documents -->Receiving and make sure there are no documents defined under PO Receiving OR PO Receiving Pallet 2. Go to Pocket ES Server -->System-->Device Setup--> Docs and make sure there is no document or printer defined under the Receiving section 3. Open PO Receiving under the Distribution tab in Pocket ES Server and receive a PO 4. Once the SAVE button is clicked it pops up a printer selection screen to select a printer (screen shot in attachment). With no document assigned, it should not be trying to print anything. Additional Issue: 1. Also while in the PO Receiving screen under the Distribution tab in Pocket ES Server, clicking on the printer icon in the lower right corner of the screen generates the following error: ReturnValues: Invalid column name 'processid' (screen shot of error in attachment). 2. Clicking OK on the error generated in the previos step will then open an empty box entitled 'Document Name' (screen shot also in attachment). 3. Clicking CLOSE on this screen will return you to the PO Receiving screen.

B36672 - backflush labor problem

B36672     3/7/2012

backflush labor problem

backflush labor bug

B36899 - Item Bin Drill Down is requiring lots

B36899     3/7/2012

Item Bin Drill Down is requiring lots

[asonnenschein 01/17/2012 17:28 (GMT -06:00)]Item Bin Drill down returns validation level of "no bin/lot records found for [whatever the item no is]". This happens for any binned item that is not lotted.

B37020 - Improve performance when Confirm Shipping multiple Line Items

B37020     3/7/2012

Improve performance when Confirm Shipping multiple Line Items

[blester 01/20/2012 09:37 (GMT -05:00)] Improve performance when Confirm Shipping multiple Line Items

B37060 - Data access maintenance

B37060     3/7/2012

Data access maintenance

[blester 01/20/2012 15:22 (GMT -05:00)] Update/cleanup of data access code

B37195 - Wisys_oe_V3_0.OEORDLIN.Insert Object Error

B37195     3/7/2012

Wisys_oe_V3_0.OEORDLIN.Insert Object Error

[dbeer 01/24/2012 11:14 (GMT -05:00)] When calling the object if the vendor/item combination indicates the object should create a PO for the item, the object fails with this message. Failed OE to PO Order Create Failed:cPurchaseOrders:CreateUnreleasedPurchaseOrder:PoOrdHdr:InsertNewRecord:Insert:PoOrdHdr:InsertAuditRecord:PoOrdHdr:InsertAuditRecord:CmdWriteAuditES:ProcessSQL :Line 1: Incorrect syntax near ',' The debugger tells us the call is to Wisys_oe_V3_0.OEORDLIN.Insert If the vendor/item combination does not require a PO, the object works fine. I suggested they update their DEV environment to use the latest version of 3.0 like their TEST environment. Once they are the same, test again to see if the behavior is the same. They called me back and after updating their DEV environment to be on 3.0 code (no other changes to their environment but running the WiSys updater), they get the exact same behavior as they were seeing in their TEST environment.

B37348 - DBNull Error when getting the level no

B37348     3/7/2012

DBNull Error when getting the level no

[blester 01/26/2012 10:34 (GMT -05:00)] A DBNull error can occur when executing ReturnMaxLevNo

B37349 - Tax Field Updates

B37349     3/7/2012

Tax Field Updates

[blester 01/26/2012 10:36 (GMT -05:00)] SyTaxTrx STATE – this will now be captured from the customer record similar to Progression TAXABLE_AMT – taxable amount is no longer calculated when tax is not applicable CURR_CD – The currency code will now default to the home currency OEORDHDR OEOrdHdr.TOT_TAX_COST – Updated to no longer calculate during the create order SyTaxLin is no longer written when there is no tax_amt on the tax code

B37431 - OE Object - Updates for sales discounts

B37431     3/7/2012

OE Object - Updates for sales discounts

[blester 01/27/2012 16:10 (GMT -05:00)] Update OE Objects to handle total salses discount support Default OEORDHDR discount from Customer Default OEORDLIN discount from OEORDHDR Calculate OEORDHDR.tot_sls_disc Update OEORDHDR.tot_dollars to include tot_sls_disc

B37514 - OrderValidation:This order is unposted and already on another shipment.You cannot add it to this shipment

B37514     3/7/2012

OrderValidation:This order is unposted and already on another shipment.You cannot add it to this shipment

Prevent Multiple Shipments per Order Flag: This flag should prevent a user from starting more than one shipment for the same order and that appears to work fine. But after the original shipment is shipped and the invoice posted, we should allow a new shipment for that order. Yet we get the same message OrderValidation:This order is unposted and already on another shipment.You cannot add it to this shipment 2. Suppose I have an inner pack (BAG) in an outer pack (CTN), linked to a shipment. If I remove the BAG from the CTN, the BAG should remain floating. That works, BUT we are leaving the parentID GUID of the carton in the record. That is a bug, we need to clear that field. Because, if I then DELETE the CTN, I am also deleting the BAG. That is wrong. I should be allowed to remove the BAG, delete the CTN, then add the BAG to another CTN.

B37558 - ODBC Connection not updating / being created upon login to Agility

B37558     3/7/2012

ODBC Connection not updating / being created upon login to Agility

Creating ODBC Connection: Agility is not creating an ODBC upon loging in to an Agility Company Updating ODBC Connection: When switching companies inside of Agility the ODBC driver used for Nicelabel does not change the database target. IE :login to company 001 and print a label then switch companies to 005 and check the ODBC connection. The user DSN continues to point against database 001.

B37755 - WiSys.OE.OEORDLIN - Loc should not be read-only

B37755     3/7/2012

WiSys.OE.OEORDLIN - Loc should not be read-only

[blester 02/06/2012 10:22 (GMT -05:00)] The WiSys.OE.OEORDLIN - Loc property is currently set to Read-Only

B38968 - Changing website links on all Help/About screens; Update Wisys Security Screen

B38968     3/7/2012

Changing website links on all Help/About screens; Update Wisys Security Screen

[[awilson 02/24/2012 14:48 (GMT -05:00)]The support documentation URL has changed with the new website. We need the new URL to display on the Update WiSys Security Screen and Help/About screens across all products. New URL is: support.wisys.com/documentation

B39384 - GetCustomerState - Conversion from type 'DBNull' to type 'String' is not valid.

B39384     3/7/2012

GetCustomerState - Conversion from type 'DBNull' to type 'String' is not valid.

[blester 03/04/2012 20:46 (GMT -05:00)] Error Message: GetCustomerState: Error retreiving the Customer State - Conversion from type 'DBNull' to type 'String' is not valid.

B39460 - Bill Recipeint needs to be added as an option for Collect Data Query

B39460     3/7/2012

Bill Recipeint needs to be added as an option for Collect Data Query

[eaguirre 03/06/2012 11:38 (GMT -05:00)] The data query option for passing the collect account to shiprush only works for UPS Collect, it also needs to work for FedEx Bill Recipient.

B39488 - After a PP4 Shipment ships, there is no focus on any field, makes sense to put focus on shipment number

B39488     3/7/2012

After a PP4 Shipment ships, there is no focus on any field, makes sense to put focus on shipment number

[eaguirre 03/06/2012 16:18 (GMT -05:00)]After a PP4 Shipment ships, there is no focus on any field, makes sense to put focus on shipment number

B39489 - When the focus is on the Shipment Number in PP4 and you move the wheel on mouse, it changes the Shipment number

B39489     3/7/2012

When the focus is on the Shipment Number in PP4 and you move the wheel on mouse, it changes the Shipment number

[eaguirre 03/06/2012 16:19 (GMT -05:00)]When the focus is on the Shipment Number in PP4 and you move the wheel on mouse up or down, it changes the Shipment number to a weird number.

B39521 - When using data query for email, if no email is found do not revert to getting email from Customer Master

B39521     3/7/2012

When using data query for email, if no email is found do not revert to getting email from Customer Master

[eaguirre 03/07/2012 10:37 (GMT -05:00)]When using data query for email in PP4, if no email is found do not revert to getting email from Customer Master, just leave blank.