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

Cheque Layout - Numeric values in words

Report design issues and solutions.
Post Reply
eranda.pre@gmail.com
User
User
Posts: 5
Joined: 21 May 2013, 09:58
Sage Version: v2010 16 UK/Europe/Africa

Cheque Layout - Numeric values in words

Post by eranda.pre@gmail.com » 21 May 2013, 10:13

When i am printing cheques using cheque layout total values in words print all caps and no space between words. After that I have changed in property window case-Lowercase and tick display space between words (in preview window shows correctly) and save and reprint but changes never apply.
Please help me to solve this problem,
Thanks

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Cheque Layout - Numeric values in words

Post by brucedenney » 21 May 2013, 10:21

Can you attach the layout to a post so we can see it?
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.

eranda.pre@gmail.com
User
User
Posts: 5
Joined: 21 May 2013, 09:58
Sage Version: v2010 16 UK/Europe/Africa

Re: Cheque Layout - Numeric values in words

Post by eranda.pre@gmail.com » 21 May 2013, 10:33

brucedenney wrote:Can you attach the layout to a post so we can see it?
Login to access the files attached to this post.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Cheque Layout - Numeric values in words

Post by brucedenney » 21 May 2013, 10:44

I just added the field back in

I select the field go to properties>

go to sign
set to reversed

got to formating>numeric>
set Part to Whole
set Case to Proper
Tick the box "Display spaces between words"
Tick the box "Show as currency"
Login to access the files attached to this post.
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.

eranda.pre@gmail.com
User
User
Posts: 5
Joined: 21 May 2013, 09:58
Sage Version: v2010 16 UK/Europe/Africa

Re: Cheque Layout - Numeric values in words

Post by eranda.pre@gmail.com » 21 May 2013, 10:54

Thanks Sir... that file is working

eranda.pre@gmail.com
User
User
Posts: 5
Joined: 21 May 2013, 09:58
Sage Version: v2010 16 UK/Europe/Africa

Re: Cheque Layout - Numeric values in words

Post by eranda.pre@gmail.com » 22 May 2013, 06:14

Dear Sir, How can I add only to end of the text value (Ex. One thousand two hundred only) to above sample cheque format.

Thank you.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Cheque Layout - Numeric values in words

Post by brucedenney » 22 May 2013, 08:59

Right align the text and then place the text "only" to the right of the field.
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.

eranda.pre@gmail.com
User
User
Posts: 5
Joined: 21 May 2013, 09:58
Sage Version: v2010 16 UK/Europe/Africa

Re: Cheque Layout - Numeric values in words

Post by eranda.pre@gmail.com » 22 May 2013, 10:04

Thanks for reply me, I tried this method but sometimes "only label" not align, because value in the text little bit bigger and when the amount is bigger it will go upto two lines.
Thank you

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Cheque Layout - Numeric values in words

Post by brucedenney » 22 May 2013, 12:10

I assume you just want to prevent anyone adding somethign on to the description, the easy way would be to fill the remainder of the text space with *'s
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.

Post Reply

Who is online

Users browsing this forum: No registered users and 14 guests