Sage 100

 View Only

  • 1.  Visual Integrator - Skip Source Data Truncation causing issue.

    Posted 01-14-2021 13:23
    Sage 100 v2019 Standard.  Trying to import AP invoices from csv file.  The Vendor number field in the import file includes the division and vendor number, ie "01-ACME" in the same field.  The GL account is 11 characters including the dashes 000-00-000.  Without Skip Source Data Truncation on, I can easily split the vendor number field into the two separate fields, but the GL account cuts off the last two characters.  With Skip Source Data Truncation on, VI refuses to allow me to import just the first two characters of the vendor number field as the division number.  It fails saying "01-ACME" is too many characters for the division.  I have tried creating a temp field and calculating from that, no success.  ANY HELP??

    ------------------------------
    Jon Parkinson
    Timac Business Systems
    ------------------------------


  • 2.  RE: Visual Integrator - Skip Source Data Truncation causing issue.

    Posted 01-14-2021 13:36
    Edited by Kevin Moyes 01-14-2021 13:37
    Add a text temp field, Key Assigns Only, to your column that includes the Div-VendorNo.  Then use substring calculations from the temp field to pull the two values.

    Edit: I know you mention using a temp field, but it must be set to Key Assigns Only, not Header, for it to work.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Visual Integrator - Skip Source Data Truncation causing issue.

    Posted 01-14-2021 14:29
    Thank you Kevin!

    ------------------------------
    Jon Parkinson
    Timac Business Systems
    ------------------------------

    Original Message


Related Content