balance forward statements

Chris Kelleher

Administrator
Staff member
Hi,

Does anyone know how to do balance forward statements (ar 4 57) with
standard MXP? If transactions 1 to 10 were done in Jan, printed on Jan's
statement, and Feb still has Jan's 7-10 outstanding transactions, then Feb
would list the balance only (o/s amount) of transactions 7 to 10, as well
as all unprinted transactions since the last January statement.

Thanks,

Marina

-----------------------------------------------------------------------

Marina Martins Phone: 514-738-6680 X 21
G.T.R Data Inc. Fax: 514-738-8538
5490 Royalmount #202 e-mail: marina@gtrdata.com
Montreal, Quebec H4P 1H7 http: //www.gtrdata.com
-----------------------------------------------------------------------
 

Chris Kelleher

Administrator
Staff member
Hi Marina,

What exactly would you want the system to do? You explained what it's doing
or what you want it to do? I will assume it is what it's doing now...

If you execute the A/R Open-Item Purge function (AR 7 4) as part of your
month-end procedures, all paid transactions will be transfered to the closed
items and will not show up on your next customer statement (the transactions
1 to 6 of your example). If your customer is set to be a 'balance forward'
account (Flag 'Open-item' set to 'no' on the first screen of Customer
Maintenance - AR 3 1), then all your unpaid transactions (7 to 10) will also
be lumped together as one balance forward amount by the same AR 7 4
function. Make sure this flag is set to 'no', run AR 7 4 AFTER printing
your customer statements every month, and you should be all set.

Hope this helps,

Pierre Bilodeau
BML Consultation Inc
(450) 963-7700
(514) 944-8252 (Cell)
(450) 963-7099 (Fax)
pbilodeau@bmlconsult.com
 

Chris Kelleher

Administrator
Staff member
Hi Pierre,

>What exactly would you want the system to do? You explained what it's doing
>or what you want it to do? I will assume it is what it's doing now...

Thanks for your help. We'll have to try your recommended actions. But for
clarity, I'd like to answer your questions. Actually, if we go back to my
Jan-Feb example, and statements are printed, all open item transactions are
being printed. What we want to do is only print the unprinted
transactions, summarizing all printed (prior statements) transactions into
one line, and this, only for some customers. My question is: how do we
allow for the following: some customers who are printing statements as
above now should be printed with balance forward, and some customers
require that their statements continue to print as above. The problem is
that I don't see the customer.open-item switch being used in the statements
program.

- Marina
 

Chris Kelleher

Administrator
Staff member
All of this is MXP 7.4...If your not on that version it may be slightly different.

The Customer Maintenance Screen has the open item flag.
The A/R Open-Item Purge is what deletes all the current transactions and creates a single balance forward option if the open-item flag is set to no. (AR 7 4, ar/openprg)

Jeremy
Programmer
Tekonsha Towing Systems
 
Top