Sage 100

 View Only
  • 1.  Check Reversal Payroll Import

    Posted 05-29-2025 19:16

    I'm trying to use VI to import Reversed checks into the Payroll Data Entry files. I have tried everything to use the one-click reversal as well as importing negative numbers. The one-click reversal tells me I need to add a "line" but the reversal should be adding that line automatically. If I add another, it duplicates the lines. I tried importing negative numbers (like in legacy versions) but the Payroll Calculation errors out with a message about negative checks. There is a KB on this but no solution. Has anyone imported payroll check reversals successfully? 



    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------


  • 2.  RE: Check Reversal Payroll Import

    Posted 05-30-2025 08:26

    I'm not sure I fully understand what's been tried and if using the including one-click reversal through the regular UI won't work.  I'm going to take a WAG ( and probably 15 people will jump in to tell me why I'm crazy) that Sage hasn't paid much attention to VI reversals of payroll checks since they added the feature in Payroll 2.x.

    How to Reverse Payroll Checks or Direct Deposits using one-click process (Payroll 2.x, version 2018 and higher)

    Again, I'm sure there's as complication as to why the manual reverse wouldn't work (or maybe you tried it and the "tells me I need to add a line" is my answer) in your situation. It's just not clear if every issue you're having is with VI or if you turned to VI after being unable to reverse out PR checks through the UI.  Just looking for more details/background.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 3.  RE: Check Reversal Payroll Import

    Posted 05-30-2025 08:54

    Wayne, basically, I'm trying to import a file that contains Reversed Payroll checks. It's hard to explain why they do it, but every month they get a file from another computer system that contains Voided (Reversed) Payroll checks. I can't seem to get it to import at all, not with the one-click option or with entering negatives (legacy way). The one-click reversal works when entered manually but not via a VI import. Entering negatives does not work at all, not manually or via an import. I hope this makes sense. 



    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------



  • 4.  RE: Check Reversal Payroll Import

    Posted 06-02-2025 11:21

    I found doing VI imports into AP for check reversals was impossible because the VI data dictionary did not include the field "do you wish to recall the invoices?" Making the import impossible.  Probably an omission of the same sort with PR reversals.  How hard can it be to add the missing fields?



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

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



  • 5.  RE: Check Reversal Payroll Import

    Posted 06-04-2025 11:50

    Jeff, at least with AP you can import all the info as negatives, and it will allow you to post. When I import the PR checks as negatives, the Payroll Tax Calculation gives me an error about the checks being a negative. There is a KB on that error but there is no resolution.



    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------