VI import for PO Receipt of Invoice

Hello,

I have created a VI job to import into PO Receipt of Invoice and encountered a problem with assigning the OrderLineKey from the original purchase order. I have it working if I manually provide the order line key in the import file but need to assign it automatically.  

Has anyone else encountered this and developed a solution they are willing to share?  One thought is using perform logic to read the line key from the original purchase order using the PO number and item code; however, I have limited knowledge of writing perform logic.

Thanks

Gordon Graham

Parents Reply
  • in reply to Gordon Graham

    One thing I have done in the past is create an Access database and linked in the Purchase Order Detail file and then link in the source file and then create a query to use as the source for the VI job.  Setup the VI job to read the Access database. 

Children