Create a Custom Form field

Owned by DATASCOPE WMS, created
Last updated: Jun 30, 2023
4 min read

SYSPRO / DATASCOPE WMS System Setting

Occasionally a Custom Form Field, created in SYSPRO, is required to pass data over to DATASCOPE WMS.

Some examples where these Custom Form fields are required are for serial scanning and linking a COA to a Purchase order.

A simple version of serial scanning and picking is included in DATASCOPE WMS. A stock code custom form field must be available to start using serials.

All custom form fields are created in SYSPRO’s Inventory Query form screen.

If you don’t like reading, you can watch the video.

None

Try it!

  • Open SYSPRO

  • From the Program List, browse to Inventory / Inventory Query

Locate Inventory Query form from the Program List

  • The Inventory Query form screen will open

  • Add the Stock code in the Stock code field or use the lookup icon to search for a stock code.

Inventory Query screen

  • At the far right of the screen there is various TABS. Click on the Custom Form tab, to edit an existing Custom Form field or add a new field.

  • If you click on the Custom Form tab it will display all Custom Form fields that has been setup for the stock codes

  • To add or edit a Custom Form field:

    • Click on the value field of any of the Custom Form fields

    • The Custom Form Entry form will pop-up - this will allow you to set or change a value for any Custom Form field.

    • Select Save if you make any changes to an existing Custom Form field.

    • To create a new Custom Form field, select the Form Design icon on the Custom Form Entry form.

    • The Custom Form Design pop-up will open where you will be able to create a new Custom Form field.

    • Add a new Custom Form field, (example Serial Req. for serials and COA for COAs) Take note of the Field Name, as this is the value required in DATASCOPE WMS.

  • If Serials are required for that specific stock code, you can then update that Custom Form Field with either a Y(es) or N(o)

  • If the COA field is required for that specific stock code, you can then update that Custom Form Field with either a Y(es) or N(o)

  • Next, a DATASCOPE WMS System Setting must be updated in order to link the SYSPRO Custom Form Field Field Name with DATASCOPE WMS.

Link SYSPRO Custom Form Field Field name (Serial) to DATASCOPE WMS

  • Open DATASCOPE WMS

  • From the Ribbon Bar open System Settings / DISPATCH / SERIAL_CFF_NAME

  • Update the SettingValue to be the same as the Field name in the Custom Form Field created in SYSPRO.

  • When picking the stock, the software will check this setting and the Custom Form Field Field name setting in SYSPRO to confirm whether the stock require a Serial number to be entered during the picking process.

Serial length setting

Another key setting within DATASCOPE WMS is the set the length of the Serial Number.

  • From the Ribbon Bar in DATASCOPE WMS browse to System Settings / DISPATCH / SERIAL_NUMBER_LENGTH

  • This setting indicates how long the Serial number should be. If you don’t want to set a limit, change the SettingValue to -1.

When starting to pick the TrackIDs using the Sales Pick to Pickslip (HTML5) screen an additional Serial text box will be visible.

Link SYSPRO Custom Form Field Field name (COA) to DATASCOPE WMS

  • Open DATASCOPE WMS

  • From the Ribbon Bar open System Settings / RECEIVING / COA_REQUIRED_FIELD

  • Update the SettingValue to be the same as the Field name in the Custom Form Field created in SYSPRO.

  • When creating a Purchase Order and a COA (Certificate of Analysis) is required, the software will check this setting and the Custom Form Field Field name setting in SYSPRO to confirm whether the a COA must be linked with the PO.

Â