Description |
Found issues in SP
# dblCurrentARBalance was missing dbl0Days and improperly subtracing negative unapplied credits
## *Before:* ,dblCurrentARBalance = CAST((ISNULL(G.dbl10Days,0.0) + ISNULL(G.dbl30Days,0.0) + ISNULL(G.dbl60Days,0.0) + ISNULL(G.dbl90Days,0.0) + ISNULL(G.dbl91Days,0.0) + ISNULL(G.dblFuture,0.0) - ISNULL(G.dblUnappliedCredits,0.0)) AS NUMERIC(18,6))
## *After:* ,dblCurrentARBalance = CAST((ISNULL(G.dbl0Days,0.0) + ISNULL(G.dbl10Days,0.0) + ISNULL(G.dbl30Days,0.0) + ISNULL(G.dbl60Days,0.0) + ISNULL(G.dbl90Days,0.0) + ISNULL(G.dbl91Days,0.0) + ISNULL(G.dblFuture,0.0) ) AS NUMERIC(18,6))
# dblUnappliedCredits was missing prepament credits
## *Before: ,* dblUnappliedCredits = ISNULL(G.dblUnappliedCredits,0.0)
## *After: ,* dblUnappliedCredits = ISNULL(G.dblUnappliedCredits,0.0) + ISNULL(G.dblPrepaids,0.0)
# dblTempEstimatedBudget was improperly subtracting negative unapplied credits.
## *Before:* ,dblTempEstimatedBudget = (CASE WHEN @ysnIncludeCredits = 0 AND @ysnIncludeInvoices = 0
THEN ROUND((dblRequiredQuantity * dblPrice / @intNumberOfMonthsInBudget),0)
WHEN @ysnIncludeCredits = 1 AND @ysnIncludeInvoices = 0
THEN ROUND((((dblRequiredQuantity * dblPrice) - dblUnappliedCredits) / @intNumberOfMonthsInBudget),0)
WHEN @ysnIncludeCredits = 0 AND @ysnIncludeInvoices = 1
THEN ROUND((((dblRequiredQuantity * dblPrice) + dblCurrentARBalance) / @intNumberOfMonthsInBudget),0)
WHEN @ysnIncludeCredits = 1 AND @ysnIncludeInvoices = 1
THEN ROUND((((dblRequiredQuantity * dblPrice) + dblCurrentARBalance - dblUnappliedCredits) / @intNumberOfMonthsInBudget),0)
END)
## *After:* ,dblTempEstimatedBudget = (CASE WHEN @ysnIncludeCredits = 0 AND @ysnIncludeInvoices = 0
THEN ROUND((dblRequiredQuantity * dblPrice / @intNumberOfMonthsInBudget),0)
WHEN @ysnIncludeCredits = 1 AND @ysnIncludeInvoices = 0
THEN ROUND((((dblRequiredQuantity * dblPrice) + dblUnappliedCredits) / @intNumberOfMonthsInBudget),0)
WHEN @ysnIncludeCredits = 0 AND @ysnIncludeInvoices = 1
THEN ROUND((((dblRequiredQuantity * dblPrice) + dblCurrentARBalance) / @intNumberOfMonthsInBudget),0)
WHEN @ysnIncludeCredits = 1 AND @ysnIncludeInvoices = 1
THEN ROUND((((dblRequiredQuantity * dblPrice) + dblCurrentARBalance + dblUnappliedCredits) / @intNumberOfMonthsInBudget),0)
END)
# Grid should have a separate Columns for Invoices and Credits so users can foot across the totals based on what AR to include with the budget payment.
## !pastedImage_d73679_0.png!
## Currently just has Current AR Balance which is not clear if someone only wants to include Credits or Invoices, but not both.
## Invoices = dblCurrentARBalance
## Credits=dblUnappliedCredits
|