Fara Panah posted on August 17, 2010 10:57

PSTL 2010 - Duplicate Customer PO Numbers in SOP Entry
There are several tools that are bundled under PSTL 2010 as free tools.
The following screenshot shows the main PSTL window with this application highlighted.

Click on Activate and Click on Next

This tool will check the Customer PO Number in SOP to see if it has been previously used. This tool gives you the ability to set rules based on different document types.
Here is a quick overview of what each column represents:
- Check DB: Check if this document type needs to be searched.
- Which Tables: Unposted and\or posted.
- Check on UI: When entered manually should it be checked.
- Required: Should the Customer PO Number field be made a required field in SOP Entry.
- Warning Type: Different settings
- Do Nothing
- Warn only
- Reject
- Ask for the Password.
- Message: a User defined message for SOP Type.
Once the features are set up, then the Customer PO Number field in Sales Transaction Entry and Sales Customer Detail Entry will be validated against the selected rules.
Looking at the screenshot below, we see that for a SOP Invoice for AARONFIT0001 is being entered and the user enters in Customer PO Number "A". As noted in the setup by default, this field is made required and the entered Customer PO Number was checked and at least one duplicate was found.

The user can select "Yes", "No", or "Display".
As this is a Warn and Ask prompt, the user can choose to say "Yes" to allow, "No" to try again, or "Display" to show you all the documents it was found on.