You’re offline. This is a read only version of the page.
15
I have a sale process setup where the order processing team can integrate Sales orders by entering the PO number (PONO) of that order. That PONO gets stored into the "Customer PO Number" field in the Sales Transaction Entry window (Transactions >> Sales >> Sales Transaction Entry). However, if the same order is attempted by another user, it gets integrated with the same PONO but a different document number.
My question is: Is there a way I can prevent duplicate integrations by validating on that PONO field so that is another member tries to integrate something that's already integrated it will fail ? How can I do a validation on that Customer PO Number field ? Is there any script of some kind I could use ?
Hi,
May be you should try write trigger on SOP10100 and check PO Number, if already exist then throw error.
Share
Report
All responses (
Answers (
RAISERROR('PO Number ' + inserted.CSTPONBR + ' is already exist'),-1,-1);
Thanks
Bharat
We integrate orders using the Integration Manager. However, there is no provision to do any specific setup regarding preventing duplicates on that field.
I have a script setup that asks for the PONO before integration. I am wondering if there is any script we could use to check GP for the PONO as well at that point ?
This all depends on how do you integrate your sales orders data into GP.
This is indeed something that GPPT (GP PowerTools) could handle with the developer module, as you could check for previous identical Customer PO # before validating the entry..
The other way as suggested by Almas would be to use a pre-script from your integration tool (like Scribe or SmartConnect to run the validation about pre-existing Customer PO #'s in Work and History tables.. then deny it if found an existing entry.
No easy way to tackle it, and definitely nothing in GP out-of-the-box
You would need to use your preferred programming tool to perform this PO number check.. VBA or C# or Dexterity. Perhaps GP Power Tools could do this as well.
There is no out of the box solution for that. You can verify you PONumber value before sending to you integration via SQL if not exist in SOP10100 customer po number field. what's your integration tool?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156