Add Method to Insert/Update OE Header and Line Comments
Symptoms: Add Method to Insert/Update OE Header and Line Comments. New methods have been added to the Wisys.OE.OrderEntryTables.OrderHeader and Wisys.OE.OrderEntryTables.OrderHeader.Oeordlin classes that allow you to update the associated comments. You will now be able to call the Wisys.OE.OrderEntryTables.OrderHeader.GetHeaderComments method to return the OE Header Comments into the OrderHeader.HeaderComments property. The Wisys.OE.OrderEntryTables.OrderHeader.UpdateHeaderComments allows you to insert, update, and delete the comments from the header by modifying the OrderHeader.HeaderComments property. The Oeordlin class follows the same construct.
LIke to add Wspkg to the file/options/pick pack/reference fields
Symptoms: currently only fileds from oeordhdr_sql,oeordlin_sql or the wspkgshipment tables can be added as reference fields. The customer wants to be able to add the ean18 field from wspkg table to these fields so that they can be passed to ShipRush.
Add the Confirm Billing object to Form Studio
Symptoms: A reseller would like to develop a confirm billing form on the handheld and does not have access to the confirm bill object in Form Studio. They have requested this object be added to the list of available objects in Form Studio.
EAN-13 coded UPCs with leading '0' do not find the item number on scan
Symptoms: When scanning an EAN-13 barcode that has a leading '0', the barcode is generated using the same logic as UPC-A. This causes barcode readers to ignore the leading '0' and return only 12 digits. If the full 13 digits are stored in the UPC_CD field in item master, then the validation objects are unable to match the UPC code causing the scan to fail to find the item.
Enable pointing to a server as well as a database for EDI with Data Masons
Symptoms: Wisys assumes that it and EDI (Datamasons) run on the same server. This is not our situation, nor should it be for multiple reasons. We need to have multiple database servers. In Wisys, there is a setup to connect the Macola/Wisys database to the DataMasons database in order for Wisys to generate the 856 shipping transactions automatically. That requires a setup in Wisys which specifies the specific EDI database to connect to. The Wisys setup does not allow specifying the SQL server but instead assumes the EDI database is on the same server as the Macola/Wisys database.
OE Manufactured Items and Kit Updates
Symptoms: OE MFG Items will now read the bmprdstr table directly to default corresponding values in the IMORDBLD table. Corrected issue with Progressions imordbld_sql.qty_per where it multiplies the actual value * 100 for OE MFG items. Added support for scrap factor. Added support for multi level OE MFG Item Product Structure. Added a new boolean property (AutoAddOEComponents) to the OEOrderLine Class to automatically populate Kit and OE Mfg Item components. Added a new overload to the OrderLine.Components.Add method that allows you to pass a parent item and level number to support a multi level bill if manually assigning product structure. when using our p_oOEOrderLine.Components.Add when adding an item to an order that has expected components, the qty_per field is not multiplied by 100 as it is when the same transaction is done in Macola Progression. We also do not populate the lvl_no, mfg_uom, backflush_fg, bulk_issue_fg, effective_dt as a zero and obsolete_dt as a zero as Macola Progression does in the imordbld_sql. We plan to manage this by adding a property to automatically add the imordbld_sql.
Create a new Validation Trx for PO PutAway
Symptoms: When using PO.PutAwayValidateItem the user gets prompted to select a lot for the validation even if the lot is not specified as a Return Value. A new PutAwayValidateItem validation should be created to remove the Lot number. New Validation: PO.PutAwayValidateItemByBin
Provide an incremental search option for all grids
Symptoms:Add and option to the grid and process grid settings page that allows incremental searching on any column on the grid. This option will allow users to locate records by typing the initial characters of the desired cell's display value. This enables end-users to locate the desired records quickly when Grid Views display a large amount of data.
Binned/lotted item that will go negative due to rounding issues when using fractional qty per ratio across multiple lots
Symptoms: A standard function was added to Form Studio (CalcuateQuantityRatio) so that a quantity and ratio could be passed in and use the Macola company decimal positions along with a consistent a rounding function when using multiple bins and lots per transaction
assign a user permission to Documents, to enable them to add Items
Symptoms: When assigning Agility Menu Options in agility/User setup, There is a residual title of System from previous versions these options are not assignable and are confusing to the user setup. The anticipation is that you can set these by user but actually uncheck after saving.
Search on Agility Will not return value
Symptoms: Search on Agility Will not return value To Duplicate: Setup Process Grid (Transaction Execution Style (Execute when Row Changes "Allow Addition of New Grid Rows" is checked). The First field on the grid is an Editable field. That field has a search and a validation. User Entry Parameters are as follows: Edit Control Type --"Text edit" Data Type --"Vendor" Max Lenght --15 Upper case Only --True Dialog type --Open Enabled -- True The field is also checked as "Required". There is another field on the process grid that is editable and is also required but does not have a search or validation. Behavior: If the search is used on a new row and a value is double clicked the value is not returned. If you go to the second required field and put a value in that field then return to the first field and do the search and double click on the value it is returned. In either case, there are fields that are display fields that have values assigned based on the first field and it's validation. Those display fields only get populated if a value is hand keyed and not if the search value is selected. It appears as selecting a value in the search bypasses the field validation.
Error getting pointer for file upload SQL transaction has not been started
Symptoms:User is in 3.0d as on 7/10 Attempts to load graphic imagine in shopfloor options at Agility Explorer-File-Options Shop Floor. Searches for image (duplicated using .bmp image) Upon selecting image file user gets error. Error getting pointer for file upload SQL transation has not been started. The image will not load.
Allow FS Lookups to sort results based the SQL vs the return column
Symptoms: Add a new option in Form Studio Lookups to sort the lookup results by the SQL select cause vs the return column. In form studio using any query with an order by in a lookup sql statement runs in the profiler through sql correctly, but returns a different order in the recordset on the form he following query returned exp date out of order on the screen, yet this is the query captured in the profile. any order by can be added and viewed in the profiler, however the data does not present in the sorted order. This is the case in both 561 and 562 Select imlsmst_wv.ser_lot_no As 'SerialLot', imlsmst_wv.bin_no As 'BinNo', imlsmst_wv.qty_on_hand As 'QtyonHand', imlsmst_wv.exp_dt As 'ExpDate' From imlsmst_wv Where imlsmst_wv.qty_on_hand <> 0 And imlsmst_wv.item_no = 'BIKEPP' And imlsmst_wv.loc = 'MA' Order By imlsmst_wv.exp_dt
Error checking if customer is valid for EDI
Symptoms: After a 561 update the customer was experiencing a "Error checking if customer is a valid EDI customer: Integrate ASN: Error checking for parent customer:CheckForParentCustomer:Customer Not found" when trying to ship an order. The order is a non-edi order and the customer is a non-edi customer. To work around, a generic customer_id was placed in the parent_id field.
Cycle Count issue with the unit cost for on the fly bin additions
Symptoms: When adding a binned item as an extra tag, in our Cycle/Physical Count forms, for a bin that does not exist produces a bin record with no cost upon post. The same procedure done through Macola using an extra tag uses the frozen cost from that location to produce a cost . To duplicate use demobikes and create a batch with one item 112004. Create an extra tag in Macola and count through Macola. When at the extra tag enter in 112004 as the item and then enter a new bin(one that produces the message "this bin does not exist would you like to add it?") enter the count for the new bin. After posting notice that the new bin record has a cost associate with it through IM Multi-Level Item View. Now create a second batch with the same item. Do not create any extra tags in Macola. Using the Cycle/Physical Count by Item form. Start counting the items for each bin. When done add a new record for a bin that does not exist. The program will ask if you want to add the new bin. Enter the count for the new bin. Upon posting of this batch, notice that the cost on the Bin record is zero. Also on an sql profile of the process you can see that we do obtain a frozen cost from the location record, but the record being updated to the iminvbin_sql is zero.
PP4 Backout shipment is not removing the invoice number from UDF15 field-error when trying to rebill
Symptoms: PP4 when a user backs out shipment and invoicing has been done, it writes invoice number to the wspkglin.UDF15 field. The backout shipment is not removing the invoice number form UDF15 field and when they try to rebill, they recieve an error that the invoice number is a duplicate. Part of this is because they set the number back so that it generates the same number as the original shipment. To work around this they remove the invoice number from UDF15 field and it will process.
Transaction editor -- moving steps up and down
Symptoms: When adding SQL Scripts to a transaction, if there is more than one SQL script in the transaction list, the up and down arrow buttons that allow the user to rearrange the scripts in the list are disabled. SQL Scripts are the only transaction type the buttons are disabled for.
The BOL number on the ASN from Wisys does not match the value being printed on the BOL when a Mfg ID is used.
Symptoms: When the Mfg ID is filled in Agility - File - Options - Pick Pack - General screen, we will generate a VICS compliant BOL number which is the Mfg_ID (padded with zeros to 8 characters) + the BOL # from the wspkgshipment table (padded with zeros to 9 characters) and then use that result to calculate a check digit for the 18th character. This value is only written to the ASN table in the EDI database. Because of that, we have no way to print this value on any paperwork that will most likely be printed before that value is calculated for the ASN. Please add a new field to the wsPkgShipment table called VICSBOL_No and begin to calculate and write this value to that field when the wsPkgShipment record is created.
In-Transit Create Header Object gives error Method 'Wisys.IM.Imtrnhdr.Insert' not found Requires Order_type to be blank
Symptoms: When using the In-Transit Create Header transaction object on a button in a grid, the error Method 'Wisys.IM.Imtrnhdr.Insert' not found. object not set to an instance of an object. Happens when all default parameters are associated properly. The error does not happen if a blank space is placed in the Order_type field in the Object Properties tab. The order_type field should not be required in the object.
unable to print out of agility with nicelabel 6 after 563 update
Symptoms: The 563 update was not updating the nicelabel runtime. That has been corrected however a print generic document for a nicelabel 6 label does not output a label. to duplicate create a label using Nicelabel 6. Put that label in a user defined document. Create a grid with a button. Add the Print DocType Generic and fill in all parameters needed. Try to print the document. All transacts correctly, however the label does not output.
Problems using variables in an If.Then.Else with stored Procedure
Symptoms: The project has a process grid, an SQL Script and a SQL Stored Procedure. The stored procedure has an input and an output. Whatever the input is, that is what the output is. The the SP has an INPUT Parameter of @inval and and Output Paramter @retval. The input comes from a list of orders(process grid). An is an M or some other letter. The customer wants the if else condition to say if the @retval is M the run an update(the sql script).
OE to PO Purchase order receiving / PO to OE not updating properly
Symptoms: PO Receipt Object Property - OeToPoShipGreaterThanOrdered is not pushing the amount to OE line Qty to ship if this is setup to True. If the amount is greater than the PO Qty, it is not updating back to the order when OEToPoTrxUpdateQtyToShip is also setup update.
system is formatting it with ‘$’ andcan’t seem to turn that off
Symptoms: Fields cannot be formatted in a pivot grid. All fields come across as $ fields it the word cost or price is in the field name. The customer would like to be able to format the columns on a pivot grid. to duplicate this simply create a pivot grid with column names as cost and price. Notice you cannot change the format using the formatting ICONs at the top of the screen.
Backspace Key Does Not work in Agilty Mobile Login Screen
Symptoms: When making a mistake typing the user name on the Agility Mobile Login Screen, if the backspace key is pressed to correct the mistyped character, it takes the user back to the company selection screen. If the company is reselected, the mistyped characters are still present in the login name field.
Shop Floor Labor being calculated incorrectly when using Standard Rate and Backflushing Labor
Symptoms: When reporting Shop Floor production using our object, the backflush labor is not calculated correctly. The wage amount and direct cost are being accumulated. Also, when entering labor, we are always using the current rate even if Macola is set up to use the Standard rate.
When shipping using the LTL button and a seal number is entered in the BOL screen, it is not being saved in the database
Symptoms: When the LTL button is used in Pick Pack to confirm ship an order and data is entered into the Seal # field on the BOL screen, this information is not being saved to the wspkgshipment record in the database.
Search on an edit field in a grid causes the validation not to fire
Symptoms: When an edit field is defined on a process gird and it has a lookup and validation attached to it that refreshes other columns in the grid, if the end user uses the lookup to get a value for the edit field and then does NOT tab off the field but simply clicks another row or edit field, the other fields in the grid for the new item selected are not refreshed. They will refresh if the value is manually entered into the edit field or the end user tabs off that field after using the lookup.
Zip Codes populating incorrectly in the wsPkgShipment table for LTL shipments
Symptoms: Zip Codes populating incorrectly in the wsPkgShipment table for LTL shipments. The wskgshpment.Ship_From_Zip value is NULL and the wsPkgShipment.Ship_To_Zip has the company/location Zip value in it that should be populating in the Ship_From field. This is only an issues with LTL shipments. UPS and FedEx are updating wspkgshipment.ship_from_zip and wspkgshipment.ship_to_zip properly [krussell 01/13/2015 06:59 (GMT -06:00)] Also not populating the ship_from_address fields
Options - WMS - Inventory Trx-Acct Number entry - Issue & Receipt Acct setup
Symptoms: Options - WMS - Inventory Transactions - Account Numbers - Issue & Receipt account setup - Remove button does not work - No way to edit alias once setup - lookup on cost center and cost unit do not work
ShipRushobject was not able to create any version of the Shiprush Object Cannot create Active X component Error Point 1
Symptoms:Our code for determining the ShipRush version bypasses ZRush_shipRush9.ocx . When a client is updated to 563 and they have ShipRush version 9 Pick Pack responds with ShipRush not installed.
Add an option in the Agility OE Line Create to default the Line Discount from the Order Header Discount
Symptoms: In the Agility Line Create you currently must set the line discount property for each line item that is created. Add an option in the Agility OE Line Import to default the Line Discount from the Order Header Discount
CloseWisysConnection Error - This SQLTransaction has completed; it is no longer usable
Symptoms: The error "This SQLTransaction has completed; it is no longer usable" can occur when calling the CloseWisysConnection when not in a sql stransaction. This can occur when performing a Wisys object transaction using OpenWisysConnection/CloseWisysConnection using a SQL Transaction. Then calling a Wisys object transaction not in a SQL Transaction. When calling the CloseWisysConnection(NoTransaction) a return value of -1 is returned and the error message "This SQLTransaction has completed; it is no longer usable"
unable to ship to AE Armed forced in shiprush
Symptoms: ShipRush using SmartPost does not send the state to the shiprush panel when shipping APO or FPO addresses. A military address will have an address field that is typically a PO Box and A city that is either FPO or APO, and state that is the Military country code ie. AE and a zip code. A typical FPO address may be something like City: FPO, State: AE and zip: 09609 The ship to country would be the US. These addresses have a ship to country of US. The reason for the US country code is that these shipments are sent either to California or New York and then distributed to the Military addresses. To duplicate this Create a ship to address for a customer as described above. Set a ship via code to be FedEx SmartPost and create an order using this ship via code. Ship the order through FedEx and notice that the state code is blank , and highlighted when entering the ShipRush Panel. You can then enter the AE in the state field and the shipment will ship.
back out the shipment and then ship again, the qty-to-ship for those non-inventoried items gets doubled in oeordlin_sql, which in turn messes up their billing.
Symptoms: to duplicate turn on OE to PO in OE setup. and set non-stocked non-controlled items to auto select for billing. create an order with one actual item and one non-stock non-controlled item. print the pick ticket and then go into Pick Pack and Ship and ship the actual item. notice that the lines do select as expected. Unship the shipment and then re-ship it. Notice that the qty_to_ship doubles on the non-stocked non-controlled item. This performs the same way using a non-inventory item. This does not happen unless OE to PO is turned on.
Triggering an 856 when order is in status 7
Symptoms: Pick Pack > Process > Integrate ASN will not work to show order after blank PH shipment record removed from the ASN table. Issue is the customer id is being padded in query ' 3188' passed and will not pull. if changed to '3188' pulls data
Pick Pack - Dimension Issue 3.0d on 2/26/15
Symptoms: Required Pkg Dimensions : “UPS and/or FedEx” user is not prompted for Size when adding Carton • Carton – defined without size • Sizes – multip sizes defined under carton. Add Carton to Pick Pack – Does not prompt for carton size Select UPS/FedEx shipper and receive message “There is a package on this shipment that has missing dimensions. You must correct this using the following screen before shipping will continue.”
Data Import Process for Agility changes single quotes to double
Symptoms: to duplicate create a project with an import from a spreadsheet. In one of the fields on the spreadsheet enter any text with an apostrophe(single quote) I used 1' X 1' box upon import the single apostrophe ' becomes a double apostrophe. " My example became 1" X 1" box
When Installing Wisys for the first time on a computer, Wisys administrator is not created
Symptoms: When installing Wisys for the first time on a machine, Agility is not checking to see if there is an existent Wisys User as Administrator. The wsUser table shows empty. This problem was replicated in both Progression and ES.
Calling the Material Receiving Disposition Post method in Progression results in a column does not belong to table error
Symptoms: Checkrules:validation error poinshdr read column tot_matl_rev does not belong to table When using the PO Mat Rev Disposition object in a Progression database, It trys to validate a field called tot_matl_rev in the poinshdr_sql table. The actual field name in this table is tot_mat_rev. this was duplicated using the following query in a Process grid. The grid has a button using the PO Mat Rev Disposition Transaction Object with the appropriate object properties filled in. The error produced is "error: CheckRules:Validation Error:cPoinshdr:Read:Column 'tot_matl_rev' does not belong to table."
Partial Delivery Flag - not using Exact customer flag
Symptoms: Pick Pack partial options are available as a global for hard and soft. The customer needs this for global company policy and it is working properly. But they also have some customers that they need a hard stop on for allowing Partial shipments. If they ship partials, they get find. PP4 is not using the Exact partial flag. Setup Pick pack to first look to the Exact partial flag on the ar customer record and then use the overall Wisys rules for Partial shipments.
Selling UOM Conversion not working for Package qty to the EDI tables-cause incorrect 856
Symptoms: Selling UOM conversion not working with the Package qty to convert to selling UOM down to the EDI OrderP/OrderL tables-cause incorrect 856. When OrderP/L qty being created, needs to look to the oeordlin_sql UOM conversion ratio to calculate to match the order.
The Form Studio ShipmentCreate object does not have a parameter for trailer number
Symptoms: Enforcing trailer and pro number fields required on handheld. The Form Studio ShipmentCreate object does not have a parameter for trailer number so the form cannot be modified to honor the setup flag that says trailer number is required.
parent band ctns with CTN under are not creating the OrderP/L tables correctly
Symptoms: Shipment is created with standard cartons. Cartons are then banded together for UPS. This creates a child relationship with the BND package and the original CTN package. When the OrderP/L is created it is not writing down the package records correctly (sometimes dropping lines, sometimes adding lines) but qty is never correct. it is also only writing down one of the ups tracking numbers to the packages so the ASN that are generated are all incorrect.
Error on Agility Mobile during PO Receipt of Rcvg Insp item.
Symptoms: Macola ES allows 50 characters in cicmpy for vendor name, however, POINSHDR table only allows 40 characters for vendor name when receiving an inspection item. If the vendor name is greater than 40 characters, Agility Mobile PO Receiving form returns the following error on save: "Post: POINSHDR Insert - cPoinshdr:Insert:cmdInsertFromItemVendor:ProcessSQL:String or binary data would be truncated. The statement has been terminated."
Error executing Agility transactions Processtrxposttrs failed to creat instance of transaction object Wisys Agility Win. Agility View Window
Symptoms: In System Utilities, View All Agility Components, user is unable to double click or right click to "Preview". Error is thrown "Error executing Agility transactions Processtrxposttrs failed to creat instance of transaction object Wisys Agility Win. Agility View Window"
not honoring the Exact flag that prevents partial delivery of orders
Symptoms: Partial ship check looks at the qty to ship and should look at the qty to order Partial to ship appears to be looking at the qty to ship vs qty to order. Example, qty to order = 5, qty to ship = 2. If they ship 2, no error, if they ship 1, error for partial ship notallowed based on the exact flag opens.
when adding a second item to a pallet, the process gets a SQL timeout
Symptoms: This issue was not able to be duplicated locally but could be reapted at reflectix. The switch for Prevent Multiple Shipments per Order could be shut off and the timeout did not occur. Check it and the timeout happened. John found an issue in our code and applied an immediate fix. This dev task is for purposed of documenting the issue.
Close trailer custom using the standard confirm ship object receiving "Error Getting BOL Data from Shipment table:GetBOLInfo:wsPKGShipment:RegurnRecordsByLoadCode:SQL transaction has not been started. The BOL process has been halted.
Symptoms: confirm ship object receiving "Error Getting BOL Data from Shipment table:GetBOLInfo:wsPKGShipment:RegurnRecordsByLoadCode:SQL transaction has not been started. The BOL process has been halted.