Thank you for your post.
In your spool file, you can write a script that grabs the the VendNum, InvoNum, InvoDate and InvoAmt information, stores them to variables. Then, when reading the following records, if those fields are empty, you can replace the fields with the variables. Here is a sample script:
Go to Layout [ <layout where spool fields are located> ]
Go to Record/Request/Page [ First ]
If [ not IsEmpty (VendNum) ]
Set Variable [ $vend ; VendNum ]
Set Variable [ $invo ; InvoNum ]
Set Variable [ $date ; InvoDate ]
Set Variable [ $amt ; InvoAmt ]
Set Field [ VendNum ; $vend ]
Set Field [ InvoNum ; $invo ]
Set Field [ InvoDate ; $date ]
Set Field [ InvoAmt ; $amt ]
Go to Record/Request/Page [ Next ; Exit after last ]
In essence, the script first goes to the layout where the spool file information is located. Then, we go to the first record and enter the loop. We evaluate and check to see if the VendNum field is not empty. If so, then we store the VendNum, InvoNum, InvoDate, and InvoAmt fields to variables. Else (if the VendNum field is empty), then we replace the fields with the values of the variables. Then, we go to the next record and evaluate again. Once we reach the last record and try to go to the next record, we exit the loop.
If you need clarification for any of the above steps, please let me know.
Thanks. That helps a lot. I am so going to impress my boss :smileyhappy: