Restrict Duplicate Non Inventory Items on SOP Invoice

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

This would most definitely require a customization.

Was this reply helpful? Yes No
Duke del Prado 320 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the info. That is what I thought, but I just wanted to be sure I wasn't missing something.

Kevin

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No