SF Material Issue and Receipt Transactions will expose the IMINVTRX_SQL.ID written. The Comment Fields will also be exposed.
Symptoms: The SF Material Issue Transaction and SF Material Return Transaction should expose the IMINVTRX.ID that is written back to the object. Added Comment1 and Comment2 properties which can be used to populate the values on the iminvtrx_sql table.
Product updater still has places using Windows Authentication instead of SQL login credentials
[dbeer 07/26/2011 14:03 (GMT -04:00)] Was running product updater today and IT person had logged in as the local Administrator on the Terminal Server instead of the Domain Administrator and as a result I received several errors during product updater where it must have been trying to use the local admin rights to get to the SQL server. One error was "Error in connection string Login failed for user ''. The user is not associated with a Trusted SQL server connection." I also received this exact same message when running PocketESConfig when I clicked the button with the green plus sign to add a company. The error was "Fill Companies: Login failed for user ''. The user is not associated with a Trusted SQL server connection."
unable to open the shiprush window after a shipment has been processed after last update
[mhollinger 03/14/2012 12:51 (GMT -04:00)] Steps to duplicate 1. Open Pick Pack 2. Pack and ship a shipment via UPS 3. In the menu click Process -> ShipRush Shipment -> UPS In step 3 the shiprush gui does not appear. It looks like nothing is happening. If you close out of Pick Pack and go back in then it works again.
Fill Backorders in WMS Pickticket will not work if a qty exists in the qty to ship field
[asonnenschein 04/03/2012 10:49 (GMT -05:00)]This is a bug. How to duplicate: Enter an order for an item that has a qty ordered greater than the available stock (i.e. qty ordered 50, available inventory 1 (which fills the qty to ship field as 1). Receive inventory for the item greater than the qty on order. Inside of es go to WMS Pickticket and try to fill the backorder. The fill backorder doesn't do anything.
Error for incorrect zipcode does not appear
[awilson 04/18/2012 13:59 (GMT -04:00)]User processes order in Fedex with invalid zipcode. No error is displayed within WiSys ShipRush. User processes order from blank FedEx form and error is displayed. User can complete order once zip code is corrected.
IM Reorder Advice filter does not return correct results for Item / Vendors in a Macola ES environment
Symptoms: IM Reorder Advice filter does not return correct results for Item / Vendors in a Macola ES environment. The APVENFIL_WV view is using the sycdefil to determine the AP_TERMS_DESC in place of the betcd table.
Agility SF Shop Order Master with contains filter does not show first record in operational detail
[awilson 05/31/2012 09:05 (GMT -04:00)]In Agility SF Shop Order Master List when searching shop order with "Contains" filter-if you highlight the first order returned in the grid, the operational detail does NOT appear in the Operational detail. Highlighting any other line will populate in operational detail. Returning to line 1 after selecting another line will make it populate however.
ES Customer Insert - potential for a duplicate key value error when a customer number is not provided
Symptoms: ES Customer Insert - potential for a duplicate key value error when a customer number is not provided. When the cmp_code field is left justified obtaining the next customer by selecting the max(cmp_code) may result in a non max value.
Issues backing out shipments following update
Symptoms: When removing a pallet from a shipment the status field in the wspkg table is retaining a 'S'. This field should return to Null or 'N' To Duplicate -- Using APS Shipping Tree, Create a new shipment and add several pallets to the shipment. Highlight a pallet then click on the "Remove Pallet" button. Finally look at the wspkg table for the pallet # that you removed. The shipment_no is set to 0 but the status is still at 'S' Shipped. Resolution
Instantiating a new instance of the OrderEntryTables objects was not clearing underlying object
Symptoms: When creating a new instance of the Wisys.OE.OrderEntryTables object the underlying objects were not being cleared. This issue is evident, for example, when creating multiple orders and creating a new instance of the OrderEntryTables for each order. Remnants of the previous order may remain in the supporting objects that this class creates and references.
Order Entry Object - Updates for Selling UOM
Symptoms: Updates to the Order Entry objects when the Selling UOM is not equal to the stocking UOM 1. When the Selling UOM of an item is not 1, the bin and seriallot qty should be calculated when using a Flat Bin or Flat SerialLot. 2. The OEORDLIN is not being populated with the item's Selling UOM. 3. OEORDLIN Tot_Qty_Ordered and Qty_Allocated do not take into account the Selling UOM
Order Entry Confirm Bill and Confirm Ship Validations
Symptoms: When calling the Confirm Ship or Confirm Bill objects the OE Control Files ship_bill_post_cd should be validated. In a Confirm Bill environment, the Bin collection is not being validated which allows an item to be billed with no Bins attached.
Reprint of BOL using 2 out of 3 available options does not work - the initial print does work
Symptoms: -Reprint from file menu Prints a blank BOL and only prints the first document -Reprint using the left pannel BOL icon after initial print prints a blank BOL - Reprint using the right mouse click on the shipment does print correctly - On edit Printers I could not set the printer to screen for Pallets and Cartons - looks like it does but after save edit it again and they are set back to Printer [bhollinger 06/26/2012 15:14 (GMT -04:00)]
iBilling:PostBillingUpdates:cOeordhdr:Read:AssignClassProperties:Conversion from type 'DBNull' to type 'Double' is not valid.
Symptoms: iBilling:PostBillingUpdates:cOeordhdr:Read:AssignClassProperties:Conversion from type 'DBNull' to type 'Double' is not valid. This error can occur if you have a null value in the oeordhdr_sql.tot_dollars column.
AdvanceToOrderInvoice may not correctly return a failed status if the next invoice number can not be obtained
Symptoms: Wisys.Oe.OrderEntryTables.AdvanceToOrderInvoice may not correctly return a failed status if the next invoice number can not be obtained. The order will be updated with a status of 9 and contain an invoice date, but have an invoice number of 0.
When receiving a non inventory item on a PO the imrechst_sql.packing_no, imrechst_sql.carrier_cd, and imrechst_sql.bill_no are not being written.
Symptoms: When receiving a non inventory item on a PO the imrechst_sql.packing_no, imrechst_sql.carrier_cd, and imrechst_sql.bill_no are not being written.
SetHeaderLinePickedPrinted: Invalid header status for this process. Must be 1 or 4 :9
Symptoms: Having issues printing pick tickets where extra_6 is getting updated but the order status is staying at status 1. Today we are getting the following message. SetHeaderLinePickedPrinted: Invalid header status for this process. Must be 1 or 4 :9 Pickings sent will appear as booked.
DBNull error can occur during a Cycle Count
Symptoms: DBNull error can occur during a Cycle Count when a date field is null in Progression. iInventoryCount: Tag Count: ImTagfil: Update: CheckRules: cIminvbin: REad: AssignClassProperties: Operator '=' is not defined for type 'DBNull' and type 'Integer'.