How to Check Duplicate BP Ref. No.?

Our business partners. They are the backbone of any business activity. This is why adding the customer or vendor reference number to our sales or purchasing documents is so common. While we define ourselves the company numbering series per document and/or user and can back it up with respective authorizations, the customer or vendor reference numbers are received from external source. Depends on the business and local practice, you might need to validate whether the customer or vendor reference number in sales or purchasing document is duplicated or not. SAP Business One introduces enhanced BP reference number check, allowing you to set the policy that fits best your business: 

When selecting either "Warning Only" or "Block Release / Receipt" radio buttons, additional sensitivity levels are added. You can select whether to check duplicated vendor reference number against the given vendor, or against all vendors. Same options are added to sales documents, where customer reference numbers are handled. In addition, the new checkbox "Check for Duplicate in Current Fiscal Year Only" enables you to limit the validation to the current fiscal year – this can be helpful when working with the same company database for long time.

Available in SAP Business One 10.0 FP 2011 and SAP Business One 10.0 FP 2011, version for SAP HANA. This tip and all the other tips are available on SAP Community. You can also visit the Implementation Arena for useful implementation tips.