Sage 100

Sage 100 v4.4 Advanced. Need a way for VI to reject an invoice if the number is a duplicate. Client uploaded invoices in December not realizing the vendor invoice was truncated at 7 and again today for the same truncated number. MAS assumed it was an adjustment and handled accordingly. Do I insert th H Adjustment line assigned as a N so that a duplicate is rejected? That seems too simple for Sage.. LMK Thanks in advance.

Check the box ""Skip over existing records"" in the VI configuration screen.

Thanks Doug. Made the change but the client doesn't want to test....................

@DougHiggs - Unfortunately, no cigar on this one. When I activated the skip over existing records, it skips importing the next 20 lines of the AP voucher instead of checking for existing records in AP history. I also have the adjustment field assigned to No which I thought would reject the record. It appears that I need some perform logic to check the AP history table for the existence of a record. BTW, client is on v4.3, not v4.4 as I had posted above.

@jeffSchwenk https://90minds-com.socialcast.com/messages/10804012

@RobertWood - Looks like the ticket to paradise...... Thanks to you and to @AlnoorCassim

@JeffSchwenk - looks like you have a solution... that's great....