How to get an automatic future date field

Deb_9768970

Does anyone know how to get a drop down date field that will automatically put in a date that is 2 weeks time from the date of the invoice?  I want to tell my customer when their next service date is, for those on a recurring schedule, it is a nuisance to have to go into the drop down calendar and pick the date.  Can't it just know when 2 weeks time is?

Linda ABC

Best suggestion I can come up with is:  Setup a Terms item that is set for 14 days...Call it Next Service... then edit your invoice template... Tick to include the Terms on both the invoice template and the screen - edit the name to be Next Service... this will populate your 14 days as you like.  Now using the Layout Designer - add a Text Field to your invoice template to put your actual payment terms in to words - eg Net 30 days or Net 7 days etc?  would that work for you?

Deb_9768970

Hi Linda, I really appreciate your contribution, thank you so much.  Yes it probably will be the perfect answer.  Terms are a header field, and I have been writing the next service date as a nice text line in the body of the description area, but I guess I can design my invoice to drag and drop that header field somewhere that will be equally as clear to see at a glance, as my text line in the description body was.  I am quite comfortable with design layout tools - I have the BEST invoice - QuickBooks/Reckon/Intuit they were so smart getting the design features to be so user friendly - it's amazing how much pizazz you can give your forms!!)  One question though, is that I need the terms field for my invoice payment terms, so won't it scramble if I try to duplicate and use the field for something else on the same template? But if I know this programme, and its all I've used for 30 years :-)  there will be a spot that I can create it that doesn't interfere.  Would love more feedback!  Thanks again Linda

Linda ABC

I agree its not ideal as you wont be able to duplicate the terms field... what are your terms?  let me know and then we can consider what your options might be?

Deb_9768970

Deb_9768970

Linda ABC

One other thing that may help you Deb, is to change your preferences under Reports & Graphs - Company Preferences.. to age by transaction date rather than due date?   Then you would only need to remove the word Overdue from the ageing boxes at the bottom of your statement templates and when you run the AR Ageing Summary - you will be seeing the outstanding invoices by date - current, 1-30, etc...  which should make sense to you?  Another alternative would be to change your terms to 14 days as well?  not sure how far removed that is from your current terms? 

Linda ABC

Just read this after I posted!!! sorry!  - ok well I think my suggestion may help you and you could even customise your ageing reports to be in 7 day breaks which would help a bit further?  Cheers!

Deb_9768970

Excellent idea thanks Linda.  Actually I am already doing that with the ageing terms, as I preferred to see it from the transaction date.  So in fact it will be no problem to dispense with the terms box on the invoice, which means I can use it for the recurring next date purpose instead.  I am certainly going to give it a try and see what happens anyway.  If successful, if will save me a lot of time when invoicing.  Thanks again!