You’re offline. This is a read only version of the page.
Announcements
200
i need a report print from due date to cutoff date?.
i was setup a AP setup window :
1. Current 0 to 30 days
2. 31 - 60 Days
3.61 - 90 Days
4.Over 90 Days.
my invoice date is: 09/30/2016.
my due date is 30/10/2016,
Print/Age as of is 12/31/2016
now i will print a report with option, the printing report is document date (09/30/2016.) to Print/Age as of date (12/31/2016),but i need a report is due date(30/10/2016) to Print/Age as of(12/31/2016) can you help me.how to do this?
*This post is locked for comments
thanks for your reply. please check a screen shot
Can you do a screen shot of the report option you are printing with the data filled in? Then we can comment fully on what you should be getting.
Cheers
Heather
In payable module setup window (AP):
Document date :
current period showing
0 to 30 days,
30 to 60 days,
60 to 90 days.
over 90 days.
but
Due date:
current period was showing :
0 to 0 days,
1 to 30 days,
30 to 60 days,
61 and over
my question is:
my invoice date is 09/30/2016
my due date is 10/30/2016
my cutoff date is 12/31/2016
if am print a report with due date then it will show in which aging bucket?, 1 to 30 days aging column or
current period aging column ? and why ? please tell me.
Hi Tim,
Thanks for your reply,and i have some questions? can you clarify me please!
please share a same setup window in AP module, i think this is a AR setup window
Hi
It sounds like you are trying to do the Aging based on Due Date rather than document date. But you have your Aging Method as set to Document Date in your setup window.
So based on Document Date, it should be sitting in around about 90 days old.
If you are aging based on Due Date, then it would sit in about 60 days overdue.
So you just need to reset your aging options in Receivables Setup as below. Note: This changes it for the system overall - so all aging - statements, trial balance reports etc for receivables will all be based on Due Date.
Hi Rajamoahmmed,
I think the question you are asking has no answer and it's likely due to a miss understanding of how the historical aging report works.
There is no relationship between due date and 'as of date' as far as what records will pull onto the report. Document Date or GL Post Date on the Invoice is measured against 'Print as of/ Aging date' factoring Date Paid Off to decide what records are on the report. Due Date is then evaluated to decide what bucket the amount should sit in.
Using your parameters:
my invoice date is: 09/30/2016.
my due date is 30/10/2016,
my Print/Age as of date is 12/31/2016
Assuming you did not pay this invoice on or before 12/31/2016 you would have that value in bucket 3 (61 - 90) when you run the report as the Due Date of 10/30 is 61 days over due when measured on 12/31/2016.
If you ran the same report with a as of date of 10/31/2016 then that amount would bucket in Current as it would be 1 day overdue.
Aged TB allows you to do a 'what it was then' look at your AP open balance as if you were running the report that day. It's a look at all open invoices 'as of' that date and the start date is the oldest unpaid invoice you have. It's a moment in time look, not a range related report.
Due Date is only used to determine the bucket. Aging Date vs. Invoice Date/GL Post Date factoring Date Paid Off determine what's on the report, Due Date just sets the bucket amount.
Maybe a simple SmartList adding date paid off as a column and ranging Due Date need is an easier way to get what you want. The ask though seems incorrect, I'm not envisioning the value of a partial as of aging and I think that's why responses to your ask are minimal.
Best
Tim
please help me anyone!
Thanks for your reply Leslie,
i was setup a AP setup window :
1. Current 0 to 30 days
2. 31 - 60 Days
3.61 - 90 Days
4.Over 90 Days.
my invoice date is: 09/30/2016.
my due date is 30/10/2016,
my Print/Age as of date is 12/31/2016
now i will print a report with option, the printing reporting is document date (09/30/2016.) to Print/Age as of date (12/31/2016) ,but i need a report is due date(30/10/2016) to Print/Age as of date(12/31/2016) can you help me.how to do this?
Hi,
I don't think I exactly understand. The due date of an AP voucher is based on the payment terms assigned to the invoice. You can set up default payment terms against the vendor and then the default due date will calculate based on those payment terms. I don't understand what you mean by due date to as of till date. Could you give an example using some representative dates?
Kind regards,
Leslie
#1
André Arnaud de Cal...
293,309
Super User 2025 Season 1
#2
Martin Dráb
232,162
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
