1 Reply Latest reply on Feb 21, 2020 3:09 PM by Sean Kirkwood - Gaea

    Summary Payment Application rounding

    BSween_DelDOT

      We've been using a Progress Estimate Business Process along with a Summary Payment Application SOV (Both are customized to some extent and not the exact out of the box BPs) since May of 2019.  We are running up against an issue when we are finishing up paying for items, where due to rounding an item is trying to be overpaid.  Here is an example of what is happening:

       

      Estimate #Unit PriceEstimate Quantity
      Exact CalculationUnifier Calc (Rounded)Difference

      03

      $36.50373.33$13,626.545$13,626.55
      04$36.50690.14$25,190.110$25,190.11
      05$36.50428.48$15,639.520$15,639.52
      06$36.50537.69$19,625.685$19,625.69
      07$36.50441.93$16,130.445$16,130.45
      08$36.50183.51$6,698.115$6,698.12
      09$36.5050.72$1,851.280$1,851.28
      10$36.50630.00$22,995.000$22,995.00
      Total$121,756.700$121,756.72-$0.02

       

      So, in our case, we paid the item correctly on each estimate (rounding up appropriately) when we attempt to pay the 10th estimate, it's overpaying by $0.02 based on what's available on the item in SOV.

       

      I'm just trying to figure out how others that are using the Summary Pay App SOV and a Cost type Estimate BP, are getting around this issue with rounding.

       

      We are currently on V18.8.14 and On Premise.

       

      Sorry if I haven't explained everything correctly.  I am still learning how we are using Unifier for our Estimate process, so if there is something I'm leaving out that will help, please let me know.

       

      Thanks in advance

      Billy Sweeney

      Delaware DOT