Has anyone ever come across a good way to restrict dupliate non inventory items from being entered on a SOP Invoice? For example if I enter 12345 as the non inventory item number on an invoice and post that I don't ever want to be able to enter 12345 again.
Kevin
*This post is locked for comments
Hi Kevin,
We can achieve this thru' VBA, provided, you are OK with any form of Customizations.
Dex approach is apt, only if the scope of Customization runs into several Forms or Reports, require new forms which tightly integrate with GP Forms or Reports or Processes.
This one is pretty easy with VBA. I will upload the solution package in a day and send in the link from where you can download it.
UPDATE (27APR2009): Check my article with a link to download the package: VBA & ADO - Restricting Non-IV Repetition on SOP Documents.
Thanks for the info. That is what I thought, but I just wanted to be sure I wasn't missing something.
Kevin
There's no setup in GP that can restrict this and I haven't seen any ISV or GP partner that have done this. Like Frank said this is a dex customization.
This would most definitely require a customization.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (