Sage 100

I am trying to create a VI export for Payroll Direct deposit to a CSV file. I need to take the Account type and export ""022"" if the account type is ""C"" and ""032"" if the account type is ""S"". Does anyone have a good way to do this? My hair brained approach was to setup two temp fields that Assign the ""022"" and ""032"" based on a conditional statement. Then a third temp filed that concatenates the output of the first two temp fields which should have resulted in either 022 or 032. I found that it doesn't clear the result between records in either of the first two temp fields, so very soon it is showing 022032 instead of just one result. Thanks.

john, I'm not sue what version your using or if it is legacy maybe but I have a check box to reset temp variable - I haven't tested it, but have you tried that?

Your logic seems sound to me (i.e. NOT hair-brained at all) if that will reset it.

Thanks for the reply. The client is on 2013 Standard but the module is Payroll. No check box. I don't know enough about the functions to know if there is a way to an if, then, else type of calculation.

john, sorry for the delay - I actually got to got out to lunch today! change it from assign to calculated and the check box to Reset on new record should show up (apparently it is not there on the assign logic) so just use ""022"" in the calculation and still set your same condition. That should work the same as a conditional assign. There probably is a way to use if/then/else but I think this is just as easy.

David, thanks for your suggestion. I went to Calculated and got the Reset on new Record check box. It does not seem to work as I am still getting both values after the first change in the Account Type field. The Calculation Only check box works and will remove the temp field output from the export. The 'Reset on new record' does not seem to have any effect. The temp field type is string and perhaps it was not designed to reset a string to null. The printed definition does not show the reset check box setting but that report has been missing stuff for a long time.

@JohnBroadfoot - back in the day, we did a couple DD exports using Access. I think one of them is still working...... LMK if this becomes an option.