Cathy Wilbur
Well Known Member
What is the best way to set up our Excel spreadsheet so that we can just import the data into the batch voucher revisions screen "P0411Z1". Want to somehow set up the Excel spreadsheet so that when we import the data it pulls in the data for the F0411Z1 and the F0911Z1.
First can we just import the data for both files from a single Excel spreadsheet? Do you know of an online document to show us how to properly do this?
Currently all our A/P voucher interfaces are custom table conversion programs that updates the F0411Z1 and F0911Z1. We were wondering if we could temporarily update both files directly by importing the data directly from an Excel spreadsheet. We will eventually be writing a table conversion program to perform this function once the outside application is able to generate interface data electronically.
Going off on vacation so put question out here to give people time to respond when I come back to work.
First can we just import the data for both files from a single Excel spreadsheet? Do you know of an online document to show us how to properly do this?
Currently all our A/P voucher interfaces are custom table conversion programs that updates the F0411Z1 and F0911Z1. We were wondering if we could temporarily update both files directly by importing the data directly from an Excel spreadsheet. We will eventually be writing a table conversion program to perform this function once the outside application is able to generate interface data electronically.
Going off on vacation so put question out here to give people time to respond when I come back to work.