Sage 100

I am looking for a method to have a VI not import duplicate AP invoices (Invoices previously posted) I know there is a option for VI to ""Skip Exiting transactions"" but that does not seem to be stopping the import of AP Invoices. I have noticed a warning on the log but it is not a failure and still imports the invoice. Has anyone come up with a creative solution. Client is on MAS200 V4.4 PU6

Perform logic?

Just about to say Perform Logic that fails the record if it finds the invoice already existing.

Talk about a small world. The very first perform logic I ever wrote was to do this and guess who gave me a few pointers on it. Jon Reiter. How close are you to his desk?

Also I posted some Perform Logic for @BrettZimmerman on this in the past.

Thanks Alnoor I'll search for it. BL. Unfortunately his was out and I was onsite. ;)

I believe it's this post https://90minds-com.socialcast.com/messages/5664955 that @AlnoorCassim is referencing.

Thanks Robert. got to love 90minds!!!

Is part of the link missing? It says not found? I have always had development do this! If I can do it, it would save the customer time & money!!! I have a AP manual check import coming up and I am sure they will want the same option.

Unfortunately his was out"" - Probably out working on getting another kung fu belt.

Amy, the link is to a 90Minds private group. I believe Jim W. is posting the information here.

Thank you!!! :) I love 90minds! Everyone is so helpful!

I've attached here both the 4.30 Perform Logic from that original post and also a 4.40 version I did for someone in January too @JimWoodhead . The .m4p files within the .zip files are in text in case you want to check it out @AmyHattensty and BTW don't try to play them in iTunes :)

Alnoor and all. , the perform logic works great!! THANK YOU

Alnoor - I tested the 4.40 file in a 4.50 SQL environment and it took care of one problem which was of course to skip the duplicates already posted in the system, so thank you for that. But I'm still having the same problem I've been fighting with since the upgrade from 3.71 and that is VI creating blank batches. Short story - client reads from a SQL database that has the same AP invoice records/batch numbers in it and is added to every day but purged of imported records until once every 2 weeks or so until invoices are approved. I have on Select tab where Batch No > Run Time Prompt, just as there was in 3.71, but it will import blank batches until it reaches a batch number that matches my critieria and then import the invoice records along with the Batch No. Hope that makes sense...is there Perform Logic I could use for Batch as well, perhaps?

@AmberStoneburg can you start a new thread and repost the question (this thread needs to die .. er .. I mean be marked complete)

Fine...making me work some more :)