Invoice Discount Amounts

Sort:
You are not authorized to post a reply.
Author
Messages
Randall
Veteran Member
Posts: 44
Veteran Member
    Hi all,

    I'll be the first to admin I have a little bit of functional knowledge in the financial arena, but by no means an expert. I have a question that I haven't been able to track down the resolution.

    We're undertaking an initiative to take the correct discounts on our invoices based on certain scenarios. After the calculation, we're attempting to change the amount of the discount on the AP22.3 screen (from the discount button on the main tab of AP20).

    After this is done and the invoice is released, you can see the new discount amounts if you drill on the record in AP90.

    However, when we run the record(s) through AP150, the new discount amount that has been populated does not transfer over and the original discount amount (term percent * invoice amount) goes through the entire check run.

    I thought that switching the "Flexible Terms" flag would override this, but no luck. Are there any other fields that need to be populated (or cleared) for the AP150 to begin picking up the new discount amounts?

    Thanks,
    Randall
    Randall
    Veteran Member
    Posts: 44
    Veteran Member
      I believe we found the issue to our problem. The process we have in place updates these discount amounts after the invoice is released. When the invoice releases, it creates a record in the APPAYMENT table with the original discount amounts. While the process we had in place updates discount, it only updated it in the APINVOICE table, but not the APPAYMENT table. We modified the process to update in both places and it's looking good.

      Hopefully this will be helpful to someone in the future
      You are not authorized to post a reply.