Welcome to the Sage 50 Accounts UKI Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hi,
I'm looking to write a report in Report Designer which gives me information on the products that we supply to our customers.
I think there may already be a standard report that shows this but as far as I can see it lists sales to the customer…
Hello,
Where do I get a, " "previous 12 months stock usage" report that I use to help with predicting stock reorder levels"? I am working on an inventory project and part of what the consultant is asking me for is a usage report that will show me…
Backgound on the challenge I am facing:
A vendor sends us an import file that combines three customer data fields into one, separated by a ‘/’. (These are Unit No / Account No / Order Reference)
This combined field is imported into our Sage Line…
Hi,
To import orders to our new warehouse system we need to export them from sage as CSV files with headers. CSV file headers have to be exact and some of these include a space. In the report designer I can choose to Generate Header Row and headers…
Hi
I'm looking to create a conditional formatting expression where if a stock code is more than x characters (lets say 10) long, then enable word wrap. I know how to enable word wrap, it is the 'if' part of the expression I am struggling with. Does…
Hi
When configuring the email settings for a report and attempting to change the Filename (as standard is set to REPORT.DESCRIPTION), an error comes up saying "You must enter an expression that returns a 'System.String' value. What does this mean…
Can anybody advise on how to stop zero balance letters being generated? I am using report designer to create a Dunning Letter but I cannot stop a letter being produced when the 'Grand Total' field shows zero. I have looked at adjusting the report filters…