Restrict Duplicate Non Inventory Items on SOP Invoice

Like (0) Share

Report

Posted on 17 Apr 2009 16:26:27 by Goloknath

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

All responses (4)

Answers (0)

Goloknath on 25 Apr 2009 at 07:01:58

Like (0)

Report

Re: Re: Re: Restrict Duplicate Non Inventory Items on SOP Invoice

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.
Goloknath on 20 Apr 2009 at 12:50:20

Like (0)

Report

Re: Re: Restrict Duplicate Non Inventory Items on SOP Invoice

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

Kevin
Duke del Prado 320 on 17 Apr 2009 at 22:40:23

Like (0)

Report

Re: Restrict Duplicate Non Inventory Items on SOP Invoice

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.
Frank Hamelly | MVP... 46,447 Super User 2025 Season 1 on 17 Apr 2009 at 19:45:47

Like (0)

Report

Re: Restrict Duplicate Non Inventory Items on SOP Invoice

This would most definitely require a customization.