AR Statement modifications?

[dbant2003]

I am in the process of modifying our AR statement and need some help as to get all transactions in the currrent month for which the statement is being ran for. In the past our customers have enjoyed the benefit of seeing all transactions in the current month with the applied details with it. In order to do this the statement was ran and then a vb program was ran in order to strip out the old fully paid transactions out of the statement. It only showed the current month transactions whether it was an invoice or or payment. In trying to limit the documents to current ones we would lose some of the documents (prepayments would not show on statement). What would be the best way to show the current documents on the statement along with the applied details. If I don't make the changes to the statement for some customers will be many pages long where it could be only 1 page of transactions. Any help will be greatly appreciated.


Inappropriate post

 

[jayconverse]

Use Conditional Formatting on the Detail section.

Jay Converse
IT Director
Systemlink, Inc.

 

[dbant2003]

What would that look like I have tried some different things but can not get desired results.

 

[jayconverse]

Something like:

DateDiff ("d",{@DocDate} , pwformatdate({ARSTCUS.STMTDATE})) < = 30

Jay Converse
IT Director
Systemlink, Inc.