VI JOB Cash Receipts Import - How do you set up the job to validate INVOICE TYPE in the user's source column/field to be either IN or PP and never blank or null?

Please help!!!  Very simple VI job has been in use since 2015, maybe earlier.   But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record errors out.  The invoice type within the batch can be IN or PP, but should never be blank.

What is the simplest way to approach this?  Can the Conditional expression in the import field properties tab be used to validate that source data is IN or PP and never blank?  I tried to set up a conditional expression and cannot get past the syntax errors --  Is there some kind of manual for VI beyond the overview that explains syntax for conditional expressions?  Thanks very much!

  • 0

    How about pulling Invoice Type from the column on your source file into a Temp field, then use 3 different L.InvoiceType fields in your import. Assign an IN if the value in Temp001 is "IN", a PP if it's "PP" and then maybe an IN if the value is blank? Something along those lines? Of course, that's assuming if they forget to put a value in there then you want it to be treated as an Invoice.

    As for a manual, not really sure what's available. I would say Sage City is a pretty good resourse, as are some of the articles in the Sage KnowledgeBase. Some of the online help may be able to steer you in the right direction. I also sometimes use the PVXPlus website for suggestions on some of the formulas/functions.