jomarelectric
IS-IT--Management
cr10
hello, all -
i have a monthly commissions report to run where the commission is based on cash and account sales. the account sales is where i'm having the issue.
the customer (account) purchases $30,000.00 over the month and say the customer only pays $1,500.00 towards that by months end - the commission is based on that $1,500.00 and the balance is carried over.
i need to keep a running total w/ an hardcoded date of april 1/07 to keep track of account payments being made.
my record selection is:
here is what i've tried so far:
the above is my running total formula for summing up the invoice payment history (this did not work). it returned the same total as the entered start and end date of my parameter.
in short, i need a running total that uses the ?end date of the parameter and an hardcoded start date. i'm i barking up the wrong tree?
//frank
hello, all -
i have a monthly commissions report to run where the commission is based on cash and account sales. the account sales is where i'm having the issue.
the customer (account) purchases $30,000.00 over the month and say the customer only pays $1,500.00 towards that by months end - the commission is based on that $1,500.00 and the balance is carried over.
i need to keep a running total w/ an hardcoded date of april 1/07 to keep track of account payments being made.
my record selection is:
Code:
{INIH.SALREP} = {?rep} and
{INIH.INVCDAT} in {?start} to {?end} and
{INIH.ARTOT} <> 0.00 and
(
not(isnull({INIH.OUTVAL}))
or
{INIH.OUTVAL} <> 0
)here is what i've tried so far:
Code:
{INIH.INVCDAT} in [(Date(2007, 4, 1)) to {?end}]the above is my running total formula for summing up the invoice payment history (this did not work). it returned the same total as the entered start and end date of my parameter.
in short, i need a running total that uses the ?end date of the parameter and an hardcoded start date. i'm i barking up the wrong tree?
//frank