Restrictions in AR Excel Report

(0) Share

Report

Posted on by Katie Pieczynski

3,225

Hello,

I created a report out of Excel report builder that combines our Customer Master Summary and our Collection Notes. I would like to see if I can build a calculation or formula to basically say to only bring in customers that have a balance in the 1-30, 31-60, or the 61+. As of right now it brings in the customers who have a balance in the current bucket as well. Thanks for any help.

*This post is locked for comments

All responses (3)

Answers (0)

Katie Pieczynski 3,225 on at

Like (0)

Report

RE: Restrictions in AR Excel Report

I want balances that are 1-30 days past the due date. So if it was due 4/28 but still open on 5/29 it would be included. yes I did build it my self............
L Vail 65,271 on at

Like (0)

Report

RE: Restrictions in AR Excel Report

Hi Katie,

Seems like this should be fairly easy. Are you looking at balances that are 1-30 (etc.) past due, or 1-30 old? What I mean is are you looking at the invoice's due date to get your bucket assignment or your document date? Also, did you create the Excel Report Builder report yourself?

Kind regards,

Leslie
kpw 935 on at

Like (0)

Report

RE: Restrictions in AR Excel Report

In your setup for account receivable setup what do you have for the setup. If you have 'current' as 0-30 days

then the current amount will be included