Need ability to map wspkgSL information to the OrderS table
Symptoms: Need ability to map wspkgSL information to the OrderS table. Under File > Options > Pick Pack> EDI Settings - add wspkgSL table and OrderS table Would like to send a Production date for a Lot No on my ASN for one Solution: The OrderS has been added and can now be selected. It will then add the macola table map to wsPkgSL and allow fields to be mapped
Created Pick Audit Dashboard metrics to utilize data from the Ship Staging Agility Mobile Application
Symptoms: Create Pick Pack metrics Agility Grid using the wsScanAudit table. A Scan Audit dashboard has been created. This is utilizing the data when turned on in the Scan Audit abilities from the Ship Staging Agility Mobile Application
Ability to Export/Import projects has been added to the Agility Design Studio. Found on the Project ribbon bar
Symptoms: Add ability to export / import project from within Agility Designer Solution: Ability to Export/Import projects has been added to the Agility Design Studio. Found on the Project ribbon bar
NEW **Analytics Dashboard Designer added
Symptoms: New Analytics Dashboard Designer hosted in Agility Designer. New ability to create dashboard applications to give visual presentations of your data. This is a new component in the existing Agility Designer and is part of the standard out of the box functionality
Agility Web Explorer (AWE) Updates
Symptoms: Add Analytical Dashboard * Add Dialog Component * Add List View Grid Component * Printing to Network Printers * Store Company Selection using cookies rather than session * Update Alert Messages * Prevent Links that open in new window/tab from generating pop up warning * Add Toast Notifications where saving/actions previously gave no indication of completion * Open Applications In Modal Mode * Add editable Boolean/Bit Checkbox to Process Grids * IOS/Android Application *
Added the option to Pre-Load Bin Serial Lots Numbers on a Transaction
Symptoms: Add the option to PreLoad Bin Serial Lots Numbers for a given transaction. The wsPreload table is available to preload Bin Serial Lot numbers by order line or item location for transactions. Supported transactions will have a UsePreloadBinLot property that can be set to route the transaction to the wsPreload table. The wsPreloadTrxType contains the transaction codes used in the wsPreload table. The Wisys.Im.WsPreload class is available to maintain the wsPreload table. The Following Transactions Are Currently Supported: IM Transfer OE Confirm Shipping PO Receiving POP Issue POP Production SF Material Issue SF Activity Transaction
Deleting layouts in the Favorites folders not working
Symptoms: When you add an Agility menu item to the favorites section and either create custom layouts from launching the item from your favorites or launching it from its original location, the custom layout can only be removed from underneath its original menu location. There is a remove choice from the custom layout version if you right click and it seems to remove but if you close and go back in, it is still there until you remove under the original Agility menu.
PO is created but only the first item on the PO has the correct cost
Symptoms: PO is created but only the first item on the PO has the correct cost To duplicate set an item to be always create po and add that item using our oe object to an order multiple times. Notice that the PO is created but that only the first item item on the po has the correct cost, all other items have a cost of zero. I use std_cost but it appears to be on all costs.
Unable to set freight or misc amount to zero in OE Billing
Symptoms: The OE Billing Transaction In design studio does not allow you to set freight to zero. You are unable to remove freight at Wisys OE Order Billing. Any number can be entered in the freight field and saved except zero. Solution: Two new methods have been added to allow you to pass in a zero dollar freight and/or miscellaneous amount. The Wisys.OETrx.PostBillingUpdates.PostFinal and Wisys.OETrx.PostBillingUpdates.Post methods now have parameters that allow you to pass in the Freight and Misc Amounts. You also have the option of setting the ClearFreightAmount or ClearMiscAmount properties to set the amounts back to 0.
The InTransit Ship and Receive validation objects are missing the Temp Location's Bin Flag
Symptoms: The InTransit Ship and Receive validation objects are missing the Temp Location's Bin Flag. Return the Temp location Bin Flag in the following Form Studio - InTransit validation transactions Solution: Added and Available InTransitReceiveValidateItemNo InTransitShipValidateItemNo InTransitUnReceiveValidateItemNo InTransitUnShipValidateItemNo
Agility Explorer Item Master Inv Loc\Can Build button
Symptoms: Same manufactured item on the BOM twice at different levels causes "Item has already been added. Key in Dictionary." If item is at same level it doesn't appear to be an issue. Solution : Corrected to work with same item at different levels. Corrected in 567 and back implemented to 566
Inventory Count – Create Extra Tag not checking history
Symptoms: Inventory Count – Create Extra Tag is not checking the tag history table, if tag numbers are present, it looks for the next gap of numbers and is timing out. It should be getting the greatest available tag no based on the imctlfil, imtagfil, and imtaghst table Solution: Next tag number on any extra tag will select from the max of imctlfil, imtagfil, and imtaghst table. Once the max number is identified, it will be updated as such in the imctlfil.
Error creating AP voucher when Profit Center or Department is Null
Symptoms: Error creating AP voucher when Profit Center or Department is Null This is an issue where the vendor type profit center and department were null This is an acceptable entry in Macola but our voucher create fails with a db null error if either the Profit Center or Dept value is null. Solution: Null values will no longer throw an unhanded exception
Item Master Update transaction not updating
Symptoms: The Agility Transaction IM Item Master Update does not update. Updated properties are overwritten with their original values. Solution: The agility/sdk transaction will no longer overwrite changed values with their original properties.
Create Purchase order does not update the PO Header for the weight of line items
Symptoms: Create Purchase order does not update the PO Header for the weight The line item weight does not carry over to the PO Header. Solution: Purch Uom x Qty * Weight = Line Weight correction updated to PO Header
Purchase Order insert is padding alternate vendor address code incorrectly
Symptoms: In a progression system, the SDK Purchase Order insert is padding alternate vendor address code incorrectly with leading zeros when alphanumeric code is supplied Solution: Progression non-Numeric alternate vendor address codes will no longer be padded with leading zeros
wsPkgShipment does not get updated
Symptoms: When adding a floating pallet to a shipment following a shipment create, the wspkgshipment table is not get updated with the appropriate ship_to Information. The wspkgshipment record remains blank except for the shipment no. RecalculateFirstOrder property needs to be added to the Add Floating Package to Shipment in Form Studio
Po receipt not updating order when oe setup has po_type and po_qty populated
Symptoms: Po receipt was not updating qty_to_ship on OE Order. Update of OE order should happen if order status is in booked (1) or picked (4.) Currently the process doesn't update the order if the order is picked status. Macola functionality does allow update if order is in "Picked" status. Solution: Modified logic to allow status '1' and status '4' sales orders
Wisys.POTrx.Release method is not honoring an existing SQL Transaction
Symptoms: The Wisys.POTrx.Release method is not honoring an existing SQL Transaction. If the method is wrapped in a composite transaction where the PO is created and the release method is called prior to a commit, a timeout error will occur.
PIkPak Ship error Problem writiing records after BOL:BolWriteBacks:SelectFroBilling
Symptoms: Version 566, Pkg Pik/Pak and Ship, after selecting LTL and clicking Print on Bill of Lading screen Following Error pops up "Problem writing records after BOL:BolWriteBacks:SelectForBilling:No Order Numbers Found for Billing. Shipment: (ShpmntNo?) Point=2" Solution:
Serial Lot Builder - Auto Increment Option
[Jim Heydinger 03/31/2017 01:34 PM (GMT -04:00)] Options > WMS > Serial Lot Numbers. When adjusting properties for a package where the Auto Increment option is available (e.g. POP Serial) and checked you are not able to make any adjustments to the Starting Position or Length. Once you uncheck Auto Increment, you are able to make adjustments to the Starting Position and length, then check the Auto Increment box and save.
SFC - Features & Options not rolling up the cost when producing
Symptoms: Standard Cost, Cost Rollup = Y When posting production through Wisys, the cost of the finished good is only the routing cost of the feature item and is not rolling up the cost of the features. When we post production through Macola, the cost rolls up correctly. The result is the sales order includes the cost of only the feature item when posting through Wisys. The balance goes to variance accounts. When posting in Macola, the cost rolls up correctly Solution:
Form Studio Arithmetic operation resulted in an overflow - PackageAddInnerPack
Symptoms: Shipment No variable type for the PackageAddInnerPack is using a Int16 which only allows up to 32767. Needs to be changed to integer. Solution: You will no longer receive an error on Shipment Numbers greater than 32767 The following functions were updated ShipmentDelete PackageAddMultiple AddWithNewPackageInnerPack PackageAddInnerPack
wsPkgAud table does not capture weight correctly.
Issue: wsPkgAud table does not capture weight correctly. Solution: as items are added to a package the weight is rolled up and the wsPkg table is updated. that update will now trigger a new "B" and "C" record to be written to the wsPkgAud table. The wsPkgAud table should reflect that changes made to the wsPkg table. The wsPkgAud values will not always match the wsPkgLinAud values. When the weight is rolled up to the wsPkg table Tare Weight is included in the weight value written to the wsPkg and wsPkgAud tables.
PO Receiving inspection does not take into account the UOM Ratio when using Bins and/or SerialLots.
Symptoms: PO Receiving inspection does not take into account the UOM Ratio when using Bins and/or SerialLots. Solution: When doing a RI transaction UOM Ratio will be calculated into the flat bin and lot
SFWCR in Admin mode throws error when closing labor transaction
Issue: SFWCR in Admin mode throws error when closing labor transaction When Logging in to Shop Floor Work center reporting in Administrator mode to close labor transaction, the user receives error: Object reference not set to an instance of an object. Solution: Issue was corrected working in 566.1 and 567
Child grid - empty grid, button not working when set to allow when empty and no row selected
Issue: Child grid with a button that needs to execute even when the child grid has no rows. The button is set to allow when empty and when no rows are selected, however, the transaction does not run when clicked. Corrected
POP Order Create is incorrectly creating a POP dependent order for SF Pull components
Symptoms: POP Order Create is incorrectly creating a dependent POP orders for SF Pull components. SF Pull items that are components of POP orders will not generate a Shop order regardless of the SF MFG item's quantity on hand. Solution: corrected 'mfg_method' error, POP order create correctly creates the POP order but does nothing with the SF child component. SF component can be seen in available to promise in Macola.
AP Voucher Discount Percent Not Calculated Correctly
Symptoms: When passing a discount amount to the APTrx object and the discount percent is auto calculated the 100x multiplier is not used. This results in 3% being stored as .03 in the database rather than 3.0 Code updated to correct
Count Tag_type not correct when creating new physical count tag
Symptoms: When adding a new tag to a Physical Count using handheld forms the tag_type is set to "C". Solution: When adding a new tag to a batch associated to a physical count, set the tag_type to "P". When adding a new tag to a batch associated to a cycle count, set the tag_type to "C"
Check box for allow if empty grid not working
Symptoms: Check box for allow if empty grid not working The out of the box "IM Bin Characteeristic Maintenance" Does not work if the wspkgbinmst is empty. The flag is correct in the project but nothing happens when you select the "Add" Button. This happens in 566.1 and 567. Solution: Corrected
Agility Shiprush Shipping Methods not working as expected
Symptoms: When FedEx 2 Day AM service is mapped to a Ship Via Code, the service is not carrying over to a shipment using the mapped Ship Via Code. Solution: Added insert statements to Create wsPkgShipPmtMapping.sql in Synergy