I hope it does.... "For the period 01/02/2016 to <invoicedate>"
If you have problems let me know
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
alternative invoice layouts
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: alternative invoice layouts
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
- User
- Posts: 81
- Joined: 15 Apr 2015, 18:14
- Sage Version: v2015 21 UK/Europe/Africa
Re: alternative invoice layouts
Hi
I Created an invoice dated 08/03/16, using the formula below it came up with 01/03/16 to 08/03/16, so how can we make it go to the end of the month?
Regards
Stephen
substring(DateTimeToString(CreateDateTime(YearFromDate(INVOICE.INVOICE_DATE), MonthFromDate(INVOICE.INVOICE_DATE),1)), 1,10) + " to " + substring(DateTimeToString(INVOICE.INVOICE_DATE),1,10)
I Created an invoice dated 08/03/16, using the formula below it came up with 01/03/16 to 08/03/16, so how can we make it go to the end of the month?
Regards
Stephen
substring(DateTimeToString(CreateDateTime(YearFromDate(INVOICE.INVOICE_DATE), MonthFromDate(INVOICE.INVOICE_DATE),1)), 1,10) + " to " + substring(DateTimeToString(INVOICE.INVOICE_DATE),1,10)
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: alternative invoice layouts
You could try setting the date to the first of next month and then taking one day away, I have not tried this but I am thinking something like this might work... I would test it over a year end as month 12 + 1 might break things, not sure, you have to try and see...
Code: Select all
substring(DateTimeToString(CreateDateTime(YearFromDate(INVOICE.INVOICE_DATE), MonthFromDate(INVOICE.INVOICE_DATE)+1,1)-1), 1,10)
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: Ahrefs [Bot] and 1 guest