Sage 50 Accounts

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 there I was wondering if anyone knew a way of getting the "details" section on a custom sales order layout to always export 26 lines. For exmaple, regardless if there are 3 products / 15 products / 20 products (lines) on the sales order, the…

Hi everyone, Sorry if this is in the wrong section, I couldn't find a group for the Sage report designer. Is there a customer email field I can use or otherwise create with an expression? This is to be added to an Invoice layout underneath the customer…

We have been trying this for hours and haven't got anywhere. We have a client that uses the SALES_LEDGER.SETTLEMENT_DUE_DAYS field for setting the number of days each customer has to pay. If they enter the numbers 600 or 900 this means the client is…

Good Afternoon, I am trying to amend my standard reports in Sage50cloud Accounts Professional using Sage Report Designer. The main thing I would like to change is the cell format, so that when I export a report from Sage none of the cells merge together…

Any idea how I'd be able to run multiple p&l reports at once or even just speed up the process, because at the moment if you were to run a p&l for 2 departments, sage would automatically just combine them together into one report. What I need is for…

When creating/editing a quotation template, can i change the layout to read "Estimate" instead of quotation?

I was trying to get rid of the detail section for a report so I set the "Visible" parameter to False. But now I want it back but the detail section no longer shows so I can't select it and edit the "Visible" parameter back to True.