Sage 100

I've been trying to solve this on my own for days but I've reached the point that I need to cry for help. I'm working on a VI job to update Landed Cost in selected PO Receipts (in PO Receipt of Goods Data Entry) by multiplying the nontaxable total by a run-time assigned value. Selection needs to be based on PO Receipt of Goods 'Invoice Number'. Client typically receives a dozen or more POs with the same invoice number so selecting by Receipt Number won't work. They want to be prompted for the invoice number and have only those POs landed cost updated. The VI job I started to update landed cost uses an ODBC connection to PO Receipt of Goods. I added both PO Receipt of Goods and the PO Landed Cost Entry tables and linked them based on Receipt Number. I want to use a SELECTION based on Invoice Number but none of the PO Receipt of Goods fields appear. Any thoughts or helpful hints?

Can you specify what version of Mas you are doing this for?

This is Sage 100 advanced, v5 or 2013.

You could try using a UDT where the key is the receipt number. If you write the receipt number and nontaxable amount to the UDT in PO receipt entry, then in the import populate a UDF tied to the UDT, you MAY be able to read the nontaxable amount. Otherwise you could skip the VI job and script it.