Sage 100

Does anyone know how one can filter a Purchase Order V/I import to by a product line parameter? It seems the product line field in the PO tables for V/I was a casualty of the new BO platform.

It appears that product line was left out because it is a read-only field. The solution is to modify the data dictionary providex.dde to include this field. You will need to find the PO Detail key in the ProvideX.DDF file and use that key to index the ProvideX.DDE file. Then continue down to the product line record and change the 20th field starting 6 for 10 from ReadOnly=1 to ReadOnly=0.

Wow, interesting solution.

More 4.40 issues in this import: After adding the read-only product line field to the detail portion of the target PO table(s) and using it in the selection critera along with ORDER NUMBER, it turns out that the AND boolean used to connect these two criteria never allows eligible records to import. Only after changing the boolean to NONE does it work like AND used to (and should). Additionaly, I have verified that using a LIST type relationship for a single item fails whereas using an EQUAL relationship for the same item works. Are others having 4.40 VI issues like these or am I just lucky?

You are on a roll. Time to buy that Powerball ticket!

I'm just trying to better your recent run...

As far as I've observed VI is one area Sage now has hidden issues with (no ability to upgrade the import of time to payroll ) which sadly nobody seems to be fixing .