Client Updater enhancement Add the ability to view current Macola product and server connection via new menu bar and smarter files installation
Symptoms: Client Updater needs the ability to view current Macola product and server connection via new menu bar. Also make Client Updater smater about were to install files (ES/Progression) based on the column LicenseType at table WisysLicense from database MSLLOCKDB.
QA for Batch 561
Symptoms: QA run the Agility and PikPak test suites against 561 batch. Support to new skin change. Support tests on VGA or SVGA with 1024 x 768 minimum resolution as in http://support.wisys.com/documentation/ -> Welcome -> Installing and Updating your WiSys Products -> System Requirements. Support for ShipRush v10.
Product Updater enhancement Add ability to delete a row from MSLLOCKDB.dbo.wsProductUpdater using a file entry from the File Cleanup xml
Symptoms: Product Updater enhancement Add ability to delete a row from MSLLOCKDB.dbo.wsProductUpdater using a file entry from the File Cleanup xml
Product Updater enhancement Add logic to only enable Debug Flags if AllSystem build version is equal or greater than 561
Symptoms: Product Updater enhancement Add logic to only enable Debug Flags if AllSystem build version is equal or greater than 561 which is the first version to support the feature.
Return the ImInvTrx ID from an Inventory Tranfer transaction
Symptoms: Request to expose the Extra_8 and Extra_9 fields in the iminvtrx_sql table when using the IM Transfer Object in Form Studio. The ID of the Last Invtrx transfer level 1 will be returned so the iminvtrx record can be updated.
SQL Events don't like variables with a space
If you define a variable with a space in it ($Format Order) and try to use that variable in a SQL event, you get an error stating the 2nd part of the variable (Order) hasn't been defined. Resolution: Spaces are no longer a valid character when creating variables, contants, and parameters.
An incorrect error message is dipslayed during Shop Floor Material Issue
Symptoms: When doing a material issue in Shop Floor from the handheld, if a invalid bin is entered, the error message "Bin Does not Exist. Do you want to add it?. An issue transaction should not prompt to add a bin.
Forms with lookup fields are clearing back to previous field when clicking the elipse to do a lookup in PocketES
Symptoms: Forms with lookup fields are clearing back to previous field when clicking the elipse to do a lookup in PocketES Steps to Duplicate: 1. Open a form in PocketES that has multiple fields with lookups 2. Click the elipse to do a lookup and the form will clear back to the previous field instead of performing the lookup 3. A workaround is to use the right arrow key to initiate the lookup as this method performs the lookup correctly
system appears to use the purchasing unit of measure cost to move the stocking unit of measure into the final stock
Symptoms: PO Receiving Form is passing the converted cost to the receiving object when an item has a purchasing unit of measure Steps to duplicate: 1. Create a PO in Macola for an item with a purchasing unit of measure 2. Do a PO Receipt for the item using the legacy PO Receiving form in PocketES 3. Observe the converted cost is passed
OE - Add support for updating the Alternate Address Code on the Order Header
Symptoms: Add support for changing the Alternate Address Code OrderEntryTables.OrderHeader.SetAlternateAddressValues(...) can be used to default order header properties linked to the alternate delivery address values. Passing an empty string will remove the alternate address and default the header properties associated to the primary address.
Credit Memo Error when the Qty On Hand is 0 and the Qty Received is 0
Symptoms:OE Credit Memo when the Qty On Hand is 0 and the Qty Received is 0 the following error will be thrown. Oeordlin:Insert:Insert Failed:ReceiveItem: ReceiptTransaction: Post: ChangeQtyAndCostFieldsForCreditMemo: cIminvloc:ChangeQtyAndCostFieldsForCreditMemo:ProcessSQL :Failed to convert parameter value from a Double to a Decimal.
PO receipt error Conversion from type ‘DBNULL’ to type ‘String’ is not valid.
Symptoms: When doing a PO Receipt in the new PO Receiving form (release 560), unless the PO in Macola has a value for the Move to Loc field on the PO Order Line, the following error occurs: "Conversion from type 'DBNULL' to type 'String' is not valid" Steps to Duplicate: 1. Create a PO in Macola and do not enter a value for the Move to Loc on the PO Order Line 2. Open PocketES and then the PO Receiving form (new not legacy) 3. Enter/lookup the PO # 4. Enter/lookup the item # and after selecting the item, observe above message
Agility - Options - WMS - Device License does not show licenses
Symptoms: When you open Agility - Options - WMS - Device Licenses, it does not display any licenses. If you open legacy WMS Setup and go to Device License, they appear and they also appear in Agility - System - Security - Device License. Steps to duplicate: 1. Log into PocketES and give the device a name. 2. Open Agility - Options - WMS - Device Licenses and notice none are present. 3. Open Agility - System - Security - Device License and see the license does exist. 4. Remove device license 5. Repeat steps 1 & 2 and device license still does not appear.
Validation error received when filtering the results using a filter row at the top.
Symptoms: Validation error is received when filtering the results using the filter row at top. Process grid is validating the filter row as an edit field when an alert exists. Steps to Duplicate: 1. Create a Process grid 2. Add a query to return data "select ord_no, status, cus_no from oeordhdr_sql" 3. Add an alert on status. 4. Preview the grid and type into the filter row above status and tab out to receive the error.
Progression - A type conversion error could occur when reading the iminvbin or imlsmst
Symptoms: The message ... "IMINVBIN - Read cIminvbin:ReadRecord:AssignClassProperties Conversion from string "" to type 'Integer' is not valid" could be thrown when reading the iminvbin_sql record. This could occur when a value greater than zero exists in the iminvbin_sql.frz_tm field.
Validation error received when filtering the results using a filter row at the top.
Symptoms: Validation error is received when filtering the results using the filter row at top. Process grid is validating the filter row as an edit field when an alert exists. Steps to Duplicate: 1. Create a Process grid 2. Add a query to return data "select ord_no, status, cus_no from oeordhdr_sql" 3. Add an alert on status. 4. Preview the grid and type into the filter row above status and tab out to receive the error.
Pass e-mail address to ShipRush for E-mailing Tracking Numbers
Symptoms: Customer wants to use notifications feature in ShipRush to e-mail tracking numbers to customers. The e-mail address from Macola currently is not being passed to ShipRush and needs to be in order for this feature to work.
Product Updater regression Unable to install runtimes if it is the only file pending for update
Symptoms: Product Updater regression Unable to install runtimes if it is the only type of file missing Steps: Update until you get no more new files available for you contract then proceed to remove a runtime (like Crystal Reports Runtime) then try to update. You should receive a message saying 0 files to download but a runtime is available however instead you will get a message saying that no new files are available.
Pocket ES - Transfer of a serial/lot item is not adding serial lot number to collection
Symptoms: Pocket ES - When doing a transfer of a lotted only item the serial lot number is not being added to the object collection correctly. The error message "Serial Lot numbers required for this transaction. None were included" will be displayed.
indirect labor issue
Symptoms: Clock in to an indirect Job at any time Set day to next day on your computer User Admin mode to close out indirect Time will not set and you will be 24 hrs plus or minus of time on clock out screen This works fine for a clock in Job - only indirect [bhollinger 08/30/2013 14:58 (GMT -04:00)]
transfer using scanner changes frozen cost
Symptoms: Customer generates cycle count and sets a freeze date and then does an inventory transfer on that item and it is updating the frz_cost during the transfer with the average cost and the customer is using standard cost. Steps to Duplicate: 1. Make sure Macola ES set to use Standard Cost. 2. Create cycle count batch 3. Do inventory transfer using Agility WMS on same day as freeze date 4. Observe incorrect frz_cost being set.
Cancel Pick Ticket deleting Posted imlstrx and imbintrx records
Symptoms: When you are using allocations for bins and lots and you enter a partial order and post. Then print a pick ticket for final order and then cancel the pick ticket. The imlstrx and imbintrx records are deleted for the posted order. The allocations in the bin and ls master are also over adjusted. [bhollinger 09/16/2013 14:40 (GMT -04:00)]
Editable field validation on process grid does not work when adding a row
Symptoms: process grid that has an editable field. I am allowing additions of new rows. The validation is not working for the field if the field is on a new row. If I try to change a value on an existing row then the validation kicks in.
Form Studio throws a unhandled exception when accessing a SQL Event with complexity
Symptoms:Form Studio throws a unhandled exception when accessing a SQL Event with complexity. The Sql event is as follows: Select ph.ord_no As '@txtOrder', Left(ph.ord_no, 6) As '$PONo', Right(ph.ord_no, 2) As '$PORelNo', ph.ord_status As '$OrdStatus', Case When ph.ap_terms_cd = '01' Then 1 Else 0 End As '$Donation', ph.po_type, IsNull((Select Count(pl.line_no) From poordlin_wv pl Where pl.ord_no = ph.ord_no Group By pl.ord_no), 0) As '$Lines', ph.vend_no As '@txtVen', apvenfil_wv.vend_name As '@txtVenName' From poordhdr_wv ph Inner Join apvenfil_wv On ph.vend_no = apvenfil_wv.vend_no Where ph.ord_no = '@txtOrder'
ASN's failing because tracking information missing from arshthst_sql table
Symptoms: Customer is getting an error when transmitting an ASN for a collect EDI Shipment to Amazon because the tracking numbers are missing from the arshtfil_sql table. We do not write to this table if the payment code is 3rd party or collect. Please update the system to always write to the arshtfil_sql table for all payment types including 3rd Party and Collect shipments. They should be processed the same as the no freight option which is already writing to this table with a zero dollar shipment value.
Serial Lot Builder Stops working after POP Lot/Serial is Built in 561c
Symptoms: Agility - File - Options - WMS - Serial Lot Numbers. After configuring a serial setup for POP and a lot setup for POP , one can no longer go into the serial lot setup and add new configurations for other modules. It always brings up POP and the module selection is grayed out. Steps to Duplicate: 1. Agility - File - Options - WMS - Serial Lot Numbers 2. Add a configuration for POP - Serial 3. Add another configuration for POP - Lot 4. Try adding a configuration for any other module and you cannot as it only brings up POP and the ability to select another module is grayed out.
It is possible to drive location quantity negative with bin transfer
Symptoms: It is possible to transfer from a bin that has a quantity greater than the location quantity the bin is in and drive the location quantity negative. Steps to Duplicate: 1. Set location quantity for an item = 10 2. Set bin quantity for a bin in the location from step 1 = 15 3. Do a bin transfer from that location/bin = 15 and observe location quantity go to -5
It is possible to do a Bin transfer without a From Bin
Symptoms: It is possible to create a transfer in which the from bin is wiped out and the object does not catch that it is missing. Steps to duplicate: 1. Make an object call using our test spreadsheet and exclude the From bin 2. Observe the object will allow this transaction to go through
Form Studio/Agility WMS forms do not scroll properly
Symptoms: Form Studio/Agility WMS is not allowing the form to scroll when enough fields are added to a form to require it to do so. Steps to Duplicate: 1. Create a form in Form Studio and add 10 text fields to the form. 2. Run the form and see that the form does not scroll.