Sage 100

 View Only
  • 1.  VI job for IM Transaction Entry failing on v4.5

    Posted 01-28-2025 18:46

    My VI job works perfectly in my local 2024 system, but fails in client's 4.5 system. 1. It complains that the non-numeric warehouse codes are non-numeric. 2. It doesn't seem to like the Txn Date (I've tried YYYYMMDD & M/D/Y formats).  Have tried CSV and XLSX.  I get Error 88's with the XLSX file.  Thoughts?

    image



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------


  • 2.  RE: VI job for IM Transaction Entry failing on v4.5

    Posted 01-29-2025 07:18

    did you import the job from 2024 or create it directly on v4.5



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 3.  RE: VI job for IM Transaction Entry failing on v4.5

    Posted 01-29-2025 07:19

    I wonder if this kb will help lead you in the right direction.

    Employee Number is not Numeric

    Created on  | Last modified on  Highlight Matches

    Description

    <root></root>

    Cause

    A Local Tax Code may be assigned but Payroll Options does not have "Require Local Tax Reporting" selected on Tab 2. Additional

    Resolution

    If Payroll Data Entry is in process, clear Payroll Data Entry

    1. Open Payroll/Setup/Payroll Options.
    2. Go to Tab 2 and select "Require Local Tax Reporting"
    3. Save and close
    4. Go to Payroll/Main/Employee Maintenance
    5. Select Employee that was 'not numeric' during Payroll Tax Calculation
    6. Go to Tab 4. Taxes
      1. If Local Tax Profile is listed as Default change it to the State Tax Profile
      2. Open Add/Delete Tax Profiles
      3. Delete Local Tax Profile Code by highlighting the local code and using the X button on the right.
    7. Click on "Okay" You should now see just the Federal and State Tax Groups selected.

    If you need to reselect the Tax Profile

    1. In Employee Maintenance, select the Local Tax Profile
    2. All three will be selected

    Process Payroll



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------