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

Invoice number display

Sage 50 general help forum - Free help and support for all general issues
Post Reply
MKH
User
User
Posts: 5
Joined: 10 May 2010, 12:05
Sage Version: v2009 15 UK/Europe/Africa

Invoice number display

Post by MKH » 21 Jul 2010, 11:50

I am running Sage 50 Accounts Professional 2010 and Windows XP (I think!).
In our invoice layouts the invoice number is displaying with a thousand separator comma which we don't want. Can we fix it?
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4677
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Invoice number display

Post by brucedenney » 21 Jul 2010, 17:01

Yes

Edit the report.

Open the field in the expression editor and change it to Cstring(tablename.fieldname)

I think the table name and field name would be invoice.invoice_number use whatever it is put the braces round it and cstring in front.
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.
Top
Post Reply

Return to “Sage 50 UK version General Help”

Who is online

Users browsing this forum: No registered users and 1 guest