Unapplied Amount issue when applying an invoice

  • Unapplied Amount issue when applying an invoice

    Posted by Monya Maccio on January 19, 2024 at 12:11 pm

    Hi there,

    one of our users is having an issue applying an invoice.

    The invoice is there and shows for $192,083.37, when he clicks the box for that invoice it shows the “unapplied” amount go to 0.00
    but when he clicks the OK button, it changes the “unapplied amount” to
    $4,090.00. I’ve already ran file maintenance last night (Check Links/Reconcile) but the issue persists.

    This is something I have never come across before and looking for assistance if possible.

    TIA

    Monya

    Kerry Hataley replied 3 months, 3 weeks ago 2 Members · 1 Reply
  • 1 Reply
  • Kerry Hataley

    Organizer
    January 19, 2024 at 5:29 pm
    Up
    0
    Down
    ::

    So without seeing the backend SQL, the couple of things that come to mind are…

    1. Is there any payments in WORK that may have applied to this invoice also?

    2. Did you check for STUCK Batches?

    3. Do you use Multi-Currency? Functional / Operational

    Otherwise you need to check the Applied Payments Table…

    SELECT * FROM RM20201 WHERE APTODCNM = ‘INV0015755’

    SELECT * FROM RM30201 WHERE APTODCNM = ‘INV0015755’

    These will tell you if anything has been applied to these documents from another ‘broken’ process.

The discussion ‘Unapplied Amount issue when applying an invoice’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!