Sage 100

Is there a way in a VI import to change a value read from the source file from positive to negative as it imports?

Can you import it as a temporary field, then write a conditional calculated field?

That's a good idea, I'll check that out. Thanks.

That's what I usually do.

Wish it worked, but it errored, probably left out a step. I was just going to import adjustments for invoices exported to another company code, realized it would be easier (ha, ha, ha) to import to manual check with bank code cash account set to a clearing acct The manual check import errors on ""next"" check number, ""check number is greater than 6 characters"". File layout says it's 10, so why the fuss with greater than six.

changed to incr assign check number, substring 6 max 6.