Running Sage 100 v2018 and have a similar issue that was resolved about 6 months ago..."VI Export Job - Conditional export of two data fields into one column" originally posted by SO1. My situation is similar with a twist. I am looking to export data from the AP_OpenInvoice table where the CheckType is either "R" or not "R" then rename the results to either "PAID" or "VOID". The idea is that if CheckType <> "R" I want the field to populate the word "PAID". If the CheckType = "R" I want the field to populate the word "VOID".
My first attempt was to add a temp field in column 17 and populate the Default as PAID then, in the Conditional statement, I added AP_OpenInvoice01.CheckType$<>"R". Then I added a second temp field and used column 17 again but this time I populated the Default as VOID then, in the Conditional statement, I added AP_OpenInvoice01.CheckType$="R".
What I'm finding is that if the CheckType <> "R" column 17 populates the word "PAID", which is what I was hoping for. However, if the CheckType = "R", column 17 is blank and column 18 populates the word "VOID". Is there a way to force the second Temp to populate in column 17 or do I need to use a highbred solution similar to the earlier referenced post?
Thank you.