# Set a supplier invoice to be paid in 30/60/90 days **URL:** \ **Category:** Uncategorized\ **Created:** [January 13, 2016, 2:05am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454 "2016-01-13T02:05:09Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [January 14, 2016, 1:33am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/21 "2016-01-14T01:33:19Z")
Sounds great - as I don’t use Supplier/Purchase TABS I was unware of the clone feature. The only question now: how is the future dated payments displayed on the AP Summary Report. I am assuming that the Total Column will show the total value as the invoices have the same issue date and that the “Current” column (if that’s it’s title) would display either a) the value of the earliest payment only - payments due between 0 and 30 days, or b) the total of all payments - payments due between any future date and 30 days. If a) then the line item and the report totals would not cross balance If b) then the cash flow management benefits are lost compared to entering future dated sub-invoices I am limit here as I don’t know how the entering of “different due dates” functions though out Manager’s reporting but perhaps the solution is to modify the report - as it appears that the existing system can handle the variable input requirements - by adding a column called “deferred payments” - this would total any payments due less then 0 days (i.e. dates greater then the reports requested/specified date) It looks as though a solution could be achieved, it just depends on Manager’s priorities. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [January 14, 2016, 1:47am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/22 "2016-01-14T01:47:00Z")
> [@Brucanna](#): > > The only question now: how is the future dated payments displayed on the AP Summary Report. There is no AP Summary Report in the sense of a report showing what is coming due in, say, 7, 30, 60, and 90 days. The Aged Payables report lists everything upcoming as “coming due.” Beyond that, the report lists categories of reports overdue up to 30, 60, 90, and 90+ days. So there would be no negative effect on any existing reports in Manager. Having said that, I can see the benefit of a report that is more prospective, helping one to plan cash flow. But for now, we have only the retrospective Aged Payables report helping us feel guilty about overdue payments. 😉 ---
**Author:** ![Carlos\_O\_Neill](https://avatars.discourse-cdn.com/v4/letter/c/46a35a/32.png) [@Carlos\_O\_Neill](https://forum.manager.io/u/Carlos_O_Neill)\ **Post date:** [January 14, 2016, 3:56am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/23 "2016-01-14T03:56:04Z")
you have been all amazing guys @Tut @Brucanna I am going to try and split the invoice in 3 as for solution #2 and give you an update on the cashflow report thank you again ---
**Author:** ![Carlos\_O\_Neill](https://avatars.discourse-cdn.com/v4/letter/c/46a35a/32.png) [@Carlos\_O\_Neill](https://forum.manager.io/u/Carlos_O_Neill)\ **Post date:** [January 14, 2016, 4:10am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/24 "2016-01-14T04:10:31Z")
OK Boys I have implemeted #2 solution suggested by @Tut ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/8/897652815148898b6f5f097780cc4fb9d78767ae.png) This is how it looks now. its ok for me. just one think thou. Is there a way to see my outstanding payments scheduled by weeks without the need of using excel? I rather not start to export data as it could easily lead in mistakes. you know what I mean Thank you in advance @Brucanna @Tut @Abeiku ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [January 14, 2016, 2:29pm UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/25 "2016-01-14T14:29:35Z")
Not by week. But in the Purchase Invoices tab, if you click on the Status heading, you can change the sort order so invoices appear in order of due date. ---
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [January 14, 2016, 4:34pm UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/26 "2016-01-14T16:34:54Z")
This is probably a bit academic now as it appears that the invoice cloning and sorting by age has just about resolved this topic, but An Aged Payables report was what I was referring to and the money columns would be: Col 1 Total AP - Total Amount owed to a Creditor Col 2 Coming due - Payable this month Col 3 30 day - Was payable last month Col 4 60 day - Was payable 2 mths back Col 5 90 day - Was payable 3 mths back Col 6 90+ day - Was payable 4+ mths back Col 7 Deferred - Not yet coming due Q1 - Based on your cloned invoiced solution would an invoice with a due date greater then 30 days, would it be considered as “coming due” or ignored due to the reports parameters. If it was included in the “coming due” then cash flow planning would be affected. Q2 - On re-reading your response it could be interrupted that Manager has individual aged reports rather than a single all aged report True/False If Q2 is True and Q1 is ignored then a single Deferred column on the Coming Due report could provide beneficial payment analysis, and in Carlos’s case - the Deferred being monthly aged . Could be a useful management tool, but without a lot of demand. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [January 14, 2016, 5:18pm UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/28 "2016-01-14T17:18:07Z")
> [@Brucanna](#): > > Q1 - Based on your cloned invoiced solution would an invoice with a due date greater then 30 days, would it be considered as “coming due” or ignored I haven’t experimented exhaustively, but I think everything due in the future will be lumped into the coming due category. > [@Brucanna](#): > > Q2 - On re-reading your response it could be interrupted that Manager has individual aged reports rather than a single all aged report True/False I’m not exactly sure I understand your question, but you can create as many reports as you wish. You specify the “as-of” date for each report and whether it will be sorted by total or customer name. All can be saved for future review (or recreated at need). So, I think: False. Personally, I think you could get all the management information you might need from the Purchase Invoices tab listing, on which you can perform sorts by any column and searches for any string of text. You can also export it. So you could search for any invoice with a given customer’s name, sort the result by due date, and export. Or you could search for a given month (exact string to enter will depend on your date format preferences), sort by amount due, and export. ---
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [January 15, 2016, 2:01pm UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/30 "2016-01-15T14:01:20Z")
Understand, my past has always been defined formatted reports. Custom designed reporting will be a whole new playground. ---
**Author:** ![Carlos\_O\_Neill](https://avatars.discourse-cdn.com/v4/letter/c/46a35a/32.png) [@Carlos\_O\_Neill](https://forum.manager.io/u/Carlos_O_Neill)\ **Post date:** [January 15, 2016, 11:13pm UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/31 "2016-01-15T23:13:57Z")
Thank you for your help I am already a step closer to my goal so I am really happy see you in Bali 😄 @Brucanna @Tut ---
**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\ **Post date:** [January 21, 2016, 1:10pm UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/32 "2016-01-21T13:10:12Z")
Hey the ability to show custom field as a column under “Purchase Invoices” tab has been added 🙂 ---
**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\ **Post date:** [January 21, 2016, 1:17pm UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/33 "2016-01-21T13:17:36Z")
So now you can create a custom field as “Next Due Date” and type in the date. @lubos this brings me the idea of having the ability to make a custom field a date field. That way when you are entering the date, a calendar pops up guiding you in the process. ---
**Author:** ![Carlos\_O\_Neill](https://avatars.discourse-cdn.com/v4/letter/c/46a35a/32.png) [@Carlos\_O\_Neill](https://forum.manager.io/u/Carlos_O_Neill)\ **Post date:** [January 27, 2016, 3:13am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/34 "2016-01-27T03:13:14Z")
this sounds great. do I need to update the software or something? thank you so much for looking into this C ---
**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\ **Post date:** [January 27, 2016, 6:00am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/35 "2016-01-27T06:00:18Z")
Yes update please . if you face problems drop it here we can help ---
**Author:** ![Carlos\_O\_Neill](https://avatars.discourse-cdn.com/v4/letter/c/46a35a/32.png) [@Carlos\_O\_Neill](https://forum.manager.io/u/Carlos_O_Neill)\ **Post date:** [February 4, 2016, 12:22am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/36 "2016-02-04T00:22:06Z")
sorry @Abeiku late reply where do I update the desktop software? or are still new feature only for the cloud users? ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [February 4, 2016, 12:54am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/37 "2016-02-04T00:54:02Z")
Download and install exactly like you did the earlier version. ---
**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\ **Post date:** [February 4, 2016, 8:17am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/38 "2016-02-04T08:17:08Z")
yes exactly what Tut said ---
**Author:** ![Carlos\_O\_Neill](https://avatars.discourse-cdn.com/v4/letter/c/46a35a/32.png) [@Carlos\_O\_Neill](https://forum.manager.io/u/Carlos_O_Neill)\ **Post date:** [February 5, 2016, 3:58am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/39 "2016-02-05T03:58:26Z")
is this the latest? Manager 16.1.84 how can I create the custom field you have mentioned? ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/8/8110d1c17ef84bb657882af9f4adadedac1d5341.png) ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [February 5, 2016, 5:16am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/40 "2016-02-05T05:16:09Z")
Always read the Guides first. They often have answers to your questions. In this case, see [Manager Cloud](http://guides.manager.io/businesses/settings/custom-fields). ---
**Author:** ![Carlos\_O\_Neill](https://avatars.discourse-cdn.com/v4/letter/c/46a35a/32.png) [@Carlos\_O\_Neill](https://forum.manager.io/u/Carlos_O_Neill)\ **Post date:** [February 5, 2016, 7:15am UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/41 "2016-02-05T07:15:28Z")
I will for sure thank you C ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [January 18, 2023, 3:35pm UTC](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454/42 "2023-01-18T15:35:02Z")
[Previous page](https://forum.manager.io/t/set-a-supplier-invoice-to-be-paid-in-30-60-90-days/4454.md?page=1)