Duplicate Invoice & Supplier

%3CLINGO-SUB%20id%3D%22lingo-sub-1351904%22%20slang%3D%22en-US%22%3EDuplicate%20Invoice%20%26amp%3B%20Supplier%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1351904%22%20slang%3D%22en-US%22%3E%3CP%3EConditional%20formatting%20to%20warn%20if%20an%20invoice%20has%20already%20been%20entered%20based%20on%20multiple%20criteria%20of%20both%20the%20supplier%20code%20%26amp%3B%20the%20invoice%20number.%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3CP%3EBased%20only%20on%20the%20invoice%20number%20only%20is%20not%20a%20problem%2C%20but%20it%20needs%20to%20be%20able%20to%20accept%20the%20number%20duplicate%20if%20it%20relates%20to%20a%20different%20supplier.%3C%2FP%3E%3CP%3EExample%3A%20Supplier%201%20uses%20invoice%20%23%20002%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BSupplier%202%20uses%20invoice%20%23%20002%3C%2FP%3E%3CP%3EThese%20would%20pass%20the%20test%20as%20they%20are%20different%20suppliers%20using%20the%20same%20invoice%20number%2C%3C%2FP%3E%3CP%3EIf%20Supplier%201%20sends%20a%20duplicate%20invoice%20%23002%20I%20need%20to%20be%20alerted%20that%20this%20invoice%20has%20already%20been%20processed.%20Any%20help%20would%20be%20appreciated.%20VBA%20or%20macro%20would%20be%20OK%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1351904%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1351951%22%20slang%3D%22en-US%22%3ERe%3A%20Duplicate%20Invoice%20%26amp%3B%20Supplier%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1351951%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F58192%22%20target%3D%22_blank%22%3E%40Malcolm%20McMaster%3C%2FA%3E%26nbsp%3BAn%20easy%20way%20to%20do%20this%20would%20be%20to%20add%20one%20column%20that%20combines%20the%20supplier%20code%20and%20the%20invoice%20number%20and%20then%20apply%20standard%20conditional%20formatting%20that%20highlights%20duplicates%20in%20the%20entire%20column.%20The%20attached%20workbook%20contains%20an%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1351996%22%20slang%3D%22en-US%22%3ERe%3A%20Duplicate%20Invoice%20%26amp%3B%20Supplier%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1351996%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYep%20that%20works%20for%20me.%20I%20think%20I%20owe%20you%20a%20beer%20or%20two.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Conditional formatting to warn if an invoice has already been entered based on multiple criteria of both the supplier code & the invoice number.

Is this possible?

Based only on the invoice number only is not a problem, but it needs to be able to accept the number duplicate if it relates to a different supplier.

Example: Supplier 1 uses invoice # 002

               Supplier 2 uses invoice # 002

These would pass the test as they are different suppliers using the same invoice number,

If Supplier 1 sends a duplicate invoice #002 I need to be alerted that this invoice has already been processed. Any help would be appreciated. VBA or macro would be OK as well.

 

2 Replies
Highlighted

@Malcolm McMaster An easy way to do this would be to add one column that combines the supplier code and the invoice number and then apply standard conditional formatting that highlights duplicates in the entire column. The attached workbook contains an example.

Highlighted

@Riny_van_Eekelen 

Yep that works for me. I think I owe you a beer or two.