Welcome, Guest
Username: Password: Remember me

TOPIC: A/R Due Date in Crystal Report

A/R Due Date in Crystal Report #3071

  • cantercf
  • cantercf's Avatar
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
Macola Progression 7.7.900

I am trying to create a Crystal Report that lists past due A/R by customer in 10/30/60 day increments past the due date. For example:

todays date 3/20/18

Customer Due Date Past Due + 10 Past Due + 30 Past due + 60
Acme 3/1/2018 100
Jones 2/1/18 250
Smith 1/19/18 30

My thoughts are to take the due date and using either Select Case or Nested If's to add days to the Due Date to get the appropriate bucket and then group by category.

However I cannot find the due date for each A/R.

Does anyone know the table and field to use to find the due date for each A/R Invoice?

Additionally, it appears our system is storing dates as a number YYYYMMDD (20180301). Is there a formula I can use to get the result I need?

Thank you :cheer:
The administrator has disabled public write access.
Time to create page: 0.029 seconds
Powered by Kunena Forum  Protected by R Antispam