Sage 100

Trying to upload a budget file. However, when I test the upload I am getting errors where the 3rd segment of a GL account number is being left off and causing the error XXXXX-XX- is not on file. However, other GL accounts are loading just fine. Our…

Is is possible to do something in a Visual Integrator export similar to SQL LEFT(CustomerPONo,22) ? I want to truncate the field to 22 characters in my export file. I'm looking at CustomerPONo in ARInvoiceHistoryHeader