Hi,
I have a problem in recognition of PO Number. Let me explain my scenario
On Invoice i have a PO Number "80642134", In database I have this PO Number as "0080642134". For all my PO Numbers, I have starting two Zero's in my database, But in the actual invoice Zero's are not present. Due to this PO Number is not getting recognized.
Is there any possibility to overcome this issue??
Comments
4 comments
Hi Sunil,
I presume that you are using PurchaseOrders dataset. Maybe the easiest way is to remove preceding zeros from PO Number in Select statement when updating dataset from database.
Best regards,
Vladimir
Hi,
How can i remove the preceding zero's while updating the Dataset, because PO dataset updates on daily basis automatically.
Hello,
This case has solution where the dataset is updated by the script. But in the frame of our forum we cannot provide this script. Please contact your regional support or Profession service.
You could try applying an Auto-correct script, either before or after Verification at field level. I guess that you are looking for something along the lines of the
string strInput = "00080642134";
strInput.TrimStart('0');
Let me know how you get on with this.
Martin
Please sign in to leave a comment.