General Updates

• Programs are being upgraded to use the latest SYSPRO user interfaces.  This is an ongoing process and the new interfaces will be released as they are ready.
• The data export/import program has been enhanced to allow running from SYSPRO automation. Use /Link=Action(xxx):FILE(yyy):LIST(zzz) where xxx = one of Export, Import or Update, yyy = File name to read or write (on the server).  When exporting the normal file tokens can be used but use {} as the token indicators instead of <>. zzz = The path and name of a text file that contains the names of the tables to export. One file per line.  Either the 6 character CISAM name or the SQL table name can be used.  This is not case sensitive.
• The archived files program has been enhanced to allow the ability to run a purge of the archived information using SYSPRO automation. Link parameters can be lined up separated by a colon ":".  Parameters are "Check" to run file check, "Purge" to run a purge. Only one of these can be run at a time. If Purge is entered, one or more of the following must be added EDI, REPORTS, XML or ALL to specify the type of file to be purged. A purge date must be specified as DATE(CCYYMMDD). Examples: /PROG=EDIBAR /LINK=CHECK or  /PROG=EDIBAR /LINK=PURGE:REPORTS:DATE(20200101)
• The main setup and the shipping/handheld WMS setup programs were enhanced to use the latest SYSPRO user interface.
• The main menu was enhanced to add a view for import and export document maintenance.
• The system backup has been enhanced for SYSPRO 8 and received a new user interface.
• Expanded registration program license entry by hand screen for years to 2029.

• The dimensions cross-reference has been reworked to properly handle SYSPRO 7 and above A/R customer codes for lookups. This change effects both the shipping solution and EDI programs which might be reading the cross-reference. The A/R information was previously held in the cross-reference "Partner" column.  A new column and indexes has been added to separate the information. In SYSPRO 6.1 the combined column will continue to work. In SYSPRO 7 and above any records by A/R customer should be redone to store a proper SYSPRO 7 A/R customer key code in the new column.

EDI Solution Updates

IMPORTANT: Due to the enhancements to the EDIShipmentAdd table (see the notes under the Shipping Solution enhancements), the 856 has been enhanced when reading addresses from the shipment tables. If the address has NOT been parsed by the shipping solution, the address will be handled the same as an address from the sales order. If the address HAS been parsed, the logic from the 856 address record as to how to locate the name, country etc. is ignored and the information used directly from the EDIShipmentAdd table. This address handling is automatic, there is no option in the 856 needed to control the reading of addresses from the shipping table.

• All the imports and exports have been modified to separate the entry of information and the status display from the processing of the document. This new enables the imports and exports to be called from e.Net system. There is a tutorial on the website with details.
• All the imports and exports can now store the report information in a set of SQL tables. There is an option in the system setup to enable.
• Added ability to send 865 from a status 4 order.
• Enhanced CFF lookup in outgoing documents to look at the sales order record in the CFF table If the CFF doesn't exist at the invoice level.
• 846 import warehouse option expanded to 10 characters.
• The 875 import was enhanced to add and A/R account to post unknown address orders to.
• 860 import enhanced for better handling when original order used SDQ segments.
• 204 export enhanced to allow B204 to be the SYSPRO invoice number.
• 850 import enhanced to allow for reserving stock during import.
• Input sort accidentally processing sub-directories in SYSPRO 8 was corrected.
• 945 import corrected to not clear the alternate key.
• 850 processing of SDQ segments was enhanced to not require the SDQ locations to exist in the Ship To location cross-reference.
• 855 corrected to allow disabling of the PO104 price.
• SYSPRO 8 stores a carriage return in the data for hand entered comments. The export of comment lines from SYSPRO 8 orders has been enhanced to strip the carriage return from the exported field.
• The copy of a trading partner document when an existing document already exists was corrected.
• The active files viewer was enhanced with the following updates. The user interface was enhanced to latest SYSPRO standards, The view was enhanced to display the main details of the first document in the file. The selection capability was enhanced to allow the selection of multiple documents to run, delete, etc.
• 810 export of tax when a USA third party tax system is in use has been corrected and enhanced to latest SYSPRO standards.
• 850 import with SLN segments corrected when multiple PO1 segments with SLN segments are present in the document.
• 855 export document selection enhanced to allow filtering based on a sales order custom form field.
• When exporting a 855 for a cancelled order, BAK01 will be set to "01" and all ACK01 elements will be set to "IR".
• Corrected MAN 3 setup options not saving properly.
• Scripting enhanced to allow line comments in sales orders.
• Corrected an issue of lines being lost if a PO1 segment is inserted via scripting.
• Enhanced ability to export addresses from comments.
• If the option to use the first warehouse selected for all lines is enabled, the import was enhanced so that it will use the first warehouse selected on subsequent lines unless that warehouse is not a valid warehouse for a line.  In that case it will report an error.
• 943 export enhanced to lookup SCAC information in the Ship-Via to SCAC cross-reference.
• An issue with the 856 export of lots causing an infinite look has been corrected.
• New option added to lookup options on inbound documents. The option of "N" in the lookup string will cause the information to be checked against the quotation system non-stocked codes. If found a non-stocked line will be created.
• New option on the 830/862 import schedules 1 tab to better control preservation of current shipping quantities.
• The saving of addresses to comment lines in the 850 import when the main settings have a gap between the city and state has been corrected.
• Export of PER segment with an address enhanced to allow selection of the customers email address.
• 856 export corrected when setting to repeat the O level for each item enabled and the first stock code of an order is the same as the last stock code of the previous order.
• 856 export enhanced to disable the setting to create separate files for each shipment if a token allowing unique file names is not in the export file name.
• Exports upgraded to allow for exporting from a list for invoices, sales orders, dispatches or shipments depending on the source of the export. The path is the same for all file imports and defaults to the default EDI path. The file name is invoices.lst, orders.lst, dispatches.lst or shipments.lst depending on the document source. The name of the file can be changed when running from automation.
• The 860 import has been enhanced to update the detail line requested ship dates if a new date is in the header of the document. If detail dates are present those will take precedence.
• The 860 import has been enhanced to talk unit of measure conversions into account when updating a sales order line.
• The 860 import has been corrected to properly update the detail lines of a kit when the order quantity is changed.
• The reporting of orders being cancelled on the 860 import when the sales order status check fails has been removed.
• The ability to select which sales order status are OK for an 860 import update has been enhanced.
• An option to request an 860 import add lines to the order if the stock code is not found on the order has been added to the document setup.
• A issue with automation under SYSPRO 8 not allowing the program to terminate has been corrected.
• A issue with the 855 doubling quantities on the report has been corrected.
• New option to enhance selection of ship-via on 850 import has been added to the document setup.
• Option to disable the warning message regarding line number mis-matches during a 856 export has been added to the document setup.
• A issue with DTM segments at the pack level when consolidation is enabled in an 856 export has been corrected.
• Inbound 856 data checking against the purchase order line was enhanced.
• A problem sending additional addresses after an address is exported from comment lines was corrected.
• A new option has been added for a 856 export to sort the stock codes into the sequence they are on the sale order.
• When input sort is using the binary read option and the input file has carriage returns and new lines, but these are not the segment terminator, there was a small chance of a document being dropped and reported as a GS information mismatch. The issue has been corrected.
• The input sort was enhanced to handle bad files which are missing SE segments. Checks were added of the ST-SE control number, ST-SE segment count, GS-GE control number and ISA-IEA control number.  Errors will be presented if any of these mismatch.
• The order status options in the 860 import document setup has been reworked to better match the updated 850 setup.
• Corrected import crash if there are too many lines in a incoming address. Import will report dropped lines.
• The handling of values on ITD, IT1, TXI and TDS segments for credit notes as to if they should be positive or negative has been enhanced with additional options in the document setup.
• Additional options regarding storing of line numbers moved from 850 document setup to 860 document setup.
• Option added to 850 document setup to allow the purchase order to not be imported if there is any unknown code error. General 1 and General 2 tabs of document setup were rearranged to allow space for new option.
• The exports have been enhanced to allow the setting of a message severity of EDI.Skip within a script during an export. Setting a message to this level during exports will cause the document not to be exported. The document option to not export documents if there are errors and/or warnings must be enabled. Errors or warning produced by the normal processing will still be displayed. The  12/5/2019 release of support library or later is required. EDI.Message will only be reported if debug is enabled.
• The 850 export was updated to allow additional selection criteria and the selection of purchase orders based on warehouse was enhanced. The document setup field sizes for warehouse and ship via code have been corrected for SYSPRO 7/8.
• Corrected value of SN102 when SN1 output at order level but not line level and the shipment is a single item.
• 856 inbound import against purchase orders upgraded to allow script comments, date comments and other comments previously only available when importing against a sales order.
• The lookup into the customer stock code cross-reference has been expanded.  It uses the following sequence in an attempt to find a match. The customer referenced by the N1 ship to segment is used first. If there is no match and the ship to customer has a master, the cross-reference is checked using the master account. If there is no match, the trading partner master account is used to find a match. If there is still no match, the global cross-reference is checked. If there is still no match an error is reported.
• The RECADV import document has been added to the system.  A basic report will be generated of the information. There is a check of the dispatched quantity vs. the received quantity and it will report an error if they are different.
• Enhanced code setting the default CFF settings for a sales order to recognize {Blanks} as a code. Dates will only be set to zeros or {Today} at this time pending further information from SYSPRO.
• The 855 document export has been enhanced with a MSG/MTX tab added to document setup. This tab allows for setup of an export of N9/MSG or N9/MTX (depending of ANSI version) segments after the ACK segment.  The segments will be sent if the information selected to be sent is not blank. If the comment line option is selected the standard ACK XX comment line to indicate the ACK01 code is extended to ACK XX Message.
• An option has been added to page 2 of the 855 setup to "continue with orders with the same purchase order". If this option is enabled and a single order (use the lowest order number) is entered then after reading the first order the system will look for additional orders with the same purchase order number and continue processing the detail lines as if they were on the same order.
• Inbound 180 (Return Material Authorization) has been added to the system. The import at this time generates a basic report and has the ability to create an extract or add records to a SQL table. 
• nbound 211 (Motor Bill of Lading) has been added to the system. The import at this time generates a basic report and has the ability to create an extract or add records to a SQL table. 
• Tax output to TXI segments enhanced on 810 export. New option to output a separate line for each tax code (or tax-exempt vs taxable) at the summary level. New options to control output of TXI08 and TXI09 at detail and summary areas of document. New option to allow output of zero for the tax percent.
• Added ability to set PIA01 and PIA0204 in INVOIC EDIFACT document export setup.
• 830/862 document import corrected to not duplicate a line if it matches a line that has be dispatched on the sales order.
• New 860 purchase order change export from purchase orders added to system.
• Correction done for erroneous message about decimal conversion during UOM conversions on imports.
• EDIFACT INVOIC enhanced to recognize GST tax information.
• The order of the RFF and DTM segments was swapped on the EDIFACT INVOIC document.
• Additional tax options added to INVOIC document.
• The 860 import could write duplicate "CS" comment lines if the sequence number (BCH05) is present. This has been corrected and an option added to the document setup to control if the comment line is written.
• Corrected blank replacement of <COMM> token in emails from the input sort and output combine.
• Added ability to specify an EMAIL code override when running the input sort under automation.
• Issue saving pack level options on 856 MEA tab corrected.
• The XML purchase order was sorting the lines by stock code on the sales order. An option has been added to the setup to request the system leave the lines in the original XML sequence.
• Support for Quebec QST tax separation added to 810 export.
• W1201 qualifier "PR" added to list of valid qualifiers to process W12 information.
• Export of 753 document expanded with OID segments per stock line capability and additional BGN02 options.
• Corrected import of pricing with more than 2 digits after the decimal point when using the SYSPRO business objects.
• The 861 import has been enhanced with more detailed information and reporting of SAC information.
• Corrected duplicate key error when 856 export is reading shipment information and the option to export backorders is enabled and two backordered lines in succession have the same stock code.
• Corrected looping error in 856 Export when reading a shipment, the option to send backorder information is enabled and the pack level is after the item level.
• Expanded the order splitting option on 850 import to allow splitting by requested ship date.
• Enhancement to 879 export to enable selection criteria when using customer stock code cross-reference.
• Enhancement to 860 import to allow for matching of line ship dates on scheduled orders.
• Enhancement to 860 to batch the saving/reporting of address information when cancelling an existing order and creating a new one.
• Enhancement to 850 import to add allocation option of "Backorder Everything, Warn if no stock".
• If a sales order is not created from a purchase order by an import due to errors with the information, the summary totals at the bottom of the report will reflect this and a new line will be written indicating the count of orders not created due to errors.
• Corrected situation where a DTM segment at the line level of an EDIFACT ORDERS document caused the line not to be imported.
• The full allocations options on the "Details 1" tab of the 850 import document setup has been added to the 875 import setup.
• Added the option to run the Vendor Purchase Order module automatically from the 875.
• Option added to first page of 810 document setup to create a separate file for each output document. Tokens such as DATE, TIME, UNIQUE must be used in the file name to insure individual file names.
• Inbound imports such as the 945 will recognize a REF/N9 type segment marked as a Bill of Lading.
• An issue has been corrected If an 856 is run from a shipment with kits and the shipment was run with the components and the 856 is configured to swap the components for the parents and the quantity is 2 or greater for the kit and the components are in separate packs and the SN1 is consolidated. The SN1 would be 1 instead of the proper number of kits.
• For dates stored as comments or reported, the date format has been changed to use the system format.
• The 810 export has been enhanced to allow exporting of documents to separate files or a single file with separate group levels.
• An issue where a script requesting a dispatch note line level CFF would not return the proper value has been corrected.
• An issue when using a dispatch note line level CFF,  where the proper value would when used with a reference or product qualifier has been corrected.
• Added support for saving the seal number from W1004 in the 945 import.
• Added ability to send warehouse on-hand quantities in LS/REF/LE loop to satisfy Best Buy/Commerce Hub requirement.
• New options for exporting current and future production add to 852 export. Ability added to export both on-hand and monthly numbers.
• The 855 Export has been enhanced to allow the export of freight information.
• Expanded PKG segment options for 856 export.
• Serial number had been added to the list of Product Qualifier translations.

• If the N405/06 location information is sent instead of N103/04, the system will recognize the information is present and use it.

Shipping Solution Updates

IMPORTANT: The EDIShipmentAdd table has been modified to allow for the additional address line introduced in SYSPRO 7. The previous Line6 column which generally held the postal code has been renamed Line7 and a new Line6 column has been added to the table. If the option "Parse Addresses for City, State, Zip and Country" is NOT enabled on the "Address" tab of the station setup, the address lines will be moved to the Name and Line1-7 columns exactly as they are (the SYSPRO "Locality" line becomes Line4) and the City, State, Postal and Country columns will be blank. If the option IS enabled, the address will be parsed and Line1-6 will only include the street address etc. information, Line7 will be blank and the City, State, Postal and Country information will be filled in. 

IMPORTANT: The label system has been enhanced due to the change to the EDIShipmentAdd table.  Any token that references the zip/postal code will look at either Line7 or the PostalCode column and use whichever is not blank. The city, state, country tokens will only work if the address is parsed. Any label that is currently using ADD-6 for the post code will have to be updated to use ADD-Z or ADD-7. 

Please also see the note in the EDI section regarding the matching enhancement to the 856.

• The shipment viewer has been enhanced and upgraded to the latest SYSPRO user interface.
• Added correction for the shipping quantity having a problem when less lots, bins or serials are entered then the original quantity. 
• Added check for the ship selected and ship complete only allowing allocation of full pallet quantities in the lot, bin and serial entry screens if the "Leave partial pallets for operator" option is enabled. A message will be displayed to the operator that the quantity to enter is being reduced to the maximum full pallet quantity multiple.
• Added block to prevent multiple clicks of the process button on the auto quantity entry screen.
• Expanded ability to control PRO number check digit calculation.
• Shipping of stock codes on full hold blocked.
• Correction of tare weight calculation across multiple tares.
• Enhancements were done to the information stored and retrieved during a shipment pause.
• Printing of lots etc. on the packing slip for dispatch notes was corrected to only show the lots for the dispatch notes instead of all lots allocated to the order.
• Scale interface upgraded for better handling of USB interfaces.
• FSMS interface upgraded to allow the entry of a port after the server name or IP address I.E. 127.0.0.1:1999 will use port 1999 instead of the standard port 2000.
• Correction an issues when creating a dispatch with a misc. charge with zero cost that the cost on the dispatch was not zero.
• Correction problem with the label reprint not accepting the label override.
• Country code for Puerto Rico will automatically be switched from "PR" to "US" for those carriers who prefer this when using the carrier interfaces.
• Corrected an issue If only the basic freight costing options are being used and the shipment summary is asked at the start of shipment, the actual cost value would be multiplied by the number of packs.
• The document printing has been expanded to allow printing of delivery/dispatch notes and/or order acknowledgements.  The tab has been renamed to "Document Printing". Order acknowledgements will only work for sales orders a there is no equivalent document for dispatch notes.
• For the FedEx Freight interface and printing labels to a label printer, the PNG format option should be used along with the latest support library to allow for proper formatting of the labels.
• Added YRC (SCAC code RDRW) to the API interface.
• Enhanced pack value calculations to recognize line unit and total discounts.
• Endicia only allows for a single email address as a "From" or "To" address. The interface has been updated to strip additional addresses from the information sent to Endicia.
• Added shipment release eSignature to shipping solution when shipment is released.
• Corrected processing of an item move between packs when there are no tares.
• Enhanced simple serial entry to recognize WAV error sound option on errors.
• A new option for lots of "automatically assign from allocated lots" has been added to the station configuration. Using this option will allocate the lots number to the shipment line as needed from the lots allocated against the sales order. This is useful when the lot number needs to be printed on the labels or there is a desired to log it to the shipment detail.
• Corrected issue with pulling license plate information with lot traceable items and bins.
• Corrected label debug options interaction with the raw printing module to eliminate extra pop-up messages.
• When a UPC code is entered, it will first look for a UPC for the trading partner associated with the customer.  If none is found the information from the first record in the table that matches that UPC code will be used. The trading partner is determined by looking up the customer (and multiple ship to code) in the location cross-reference.
• Options added to freight tab of the station setup to control if the shipping library and/or external interface is called if the shipment is not released.  The default has been established to not call the interfaces unless the shipment is released.
• A problem with the Shipment Cancelled trigger not providing the shipment number has been corrected.
• Corrected pack counts by order when multiple orders are in the same box.
• The options to set the invoice number and/or date will now work with dispatch notes.
• Corrected issue with automatic weights from the dimension cross-reference for packs.

• Expanded dimension table look-ups to use A/R customer, A/R master customer and trading partner. The trading partner is located using the Ship-To location cross-reference.

Handheld WMS Solution Updates

• Corrected problem with SYSPRO 8 2020 R1 and the Handheld WMS Configuration crashing when an attempt is made to modify a configuration.
• Corrected issue with shipping labels printing the wrong address.
• License Plate split enhanced to allow for warehouse and bin checks.
• Enhancements for the lot, bin, quantity validation during shipping were added.
• Error reporting options on the options 1 tab have been enhanced across all operating systems that allow for the various options.
• During a stock code change of a serialize item, all records in the inventory serial header table for the serial number will be purged instead of just the ones for the active warehouse.
• Added option to control verification of overages during job receipts.  The new option is based on the total job quantity to make. The original option to allow over runs remains and is based on quantity remaining on the job.
• Corrected issue during job receipts when the entry of license plates is enabled an erroneous error that the plate cannot be placed on itself is displayed.
• Added block during a negative job receipts with the carton license plates enabled to require a valid license plate to remove the product from.
• Options have been added to allow the system to use the local stock code, Warehouse and bin tables to automatically move a scan or entry to the correct field if it matches the information in one of the tables.
• On a negative Job receipt using license plates, the license plate will not be reprinted if the current quantity is zero.
• Tokens to allow a script  to provide non-merchandise information during a direct PO receipt have been added to the post verification scripting.
• Lots and serial entry has been added to Sales Order allocations.
• LP warehouse transfers will allow for the bulk transfer of multiple license plates.
• An option has been added to allow for merging LP detail lines during a job receipt to a license plate.
• For LP negative issues, options have been added to only allow a negative issue to a fully issued LP and to only allow a negative back to a LP that was originally issued to the same job.
• An issue with the lot/serial not disabling properly after a stock code is entered on Android units was corrected.
• LP Job Issues of a LP with only one stock code will log the stock code and quantity in the tracking.
• The error reporting in the visual receiving import has been improved.
• Filter on an inventory custom form field added to Visual Issues to allow filtering of stock codes to be issued to.
• Option added to LP Adjustments to allow adjustments of expired lots.
• Options were added to the Visual Receiving, Visual Stock Take and Visual Issues to control if license plates are allowed and checked. 
• The creation of license plates during visual receiving use a quantity and a LP count has been added to the system.
• The Job Receipts 2 and 3 screens have been reorganized to be more efficient.
• A new option to control if the license plates in job receipts are created before or after the receipt has been added.
• License plate modules for placing license plates on/off hold and changing the active status of a license plate are available.

• New modules for Shipment Loading and Shipment Release were added to the solution. Shipment Loading is for loading of trucks by scanning the SSCC information on labels produced by shipping. Shipment Release is for accepting information such as PRO Numbers etc. at the time the truck arrives and releasing the shipment (similar to the SYSPRO based shipment release program).

Advanced Order Management Updates

• The user interface has been upgraded to the latest SYSPRO specifications.
• The filters have been reworked for ease of use and new capabilities have been added to save and restore a set of filters selections. After the filters are changed, a new "Refresh" button must be used to update the sales order display. The flag on the refresh button will be green if the orders display matches the filters and red if a filter has been changed and the orders screen has not be refreshed.
• The order locator has been moved from the filters to the main toolbar.
• Information that was previously displayed at the bottom of the listviews has been moved to a "Status" view. The default location of the new view is attached to the filters.
• A new automation program has been added to allow automatic processing of all orders matching a saved filter selection. This program can be run from SYSPRO automation. A tutorial on its use has been added to the website.
• Situations where lines would be checked, but not recognized when an option to ship was selected has been corrected.
• The automation capabilities of the compilation program have been enhanced. There is a new tutorial explaining how to automate the compilation on the website.
• The compilation program user interface has been upgraded to the latest SYSPRO standards.

Shipment Import

• The element <MultShipCode> has been added to allow selection of a line multiple ship code in an order that uses line level addresses.
• Corrected issue with the expansion of license plates during the import and having the same stock code on multiple lines.

Summarized Invoices

•  Corrected handling of custom form fields when summarizing dispatch notes.

Vendor Purchase Orders

• Options added to control if orders at status 1 and/or 4 are processed.