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…

I have been asked to print out reports for meetings. This report specifically is for SOPS - printing out an itemised quote list. I usually enter an "M" Message line on the first line of every quote which I input the customer's enquiry reference. I sometimes…

Can anybody suggest how to design the invoice form to include amounts in words in sage 50 UK.

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…

Hi All So I am trying to find or create a report to show all overdue customers however I dont want to include the customers who have promised payment. Is there a report already or would I have to create this? TIA

Since upgrading to version 25 I am unable to print statements, email them or save them as a PDF, it goes to do it but gets stuck on step 4 of 6 saying export to PDF. I have to close the computer down as I am unable to get off the screen. Help!

Hi I am Michael, I work on the Digital Contact Team here at Sage, I also used to run the Premium health-checks for Sage 50 Accounts before moving to this team. When doing these i was flabbergasted at how many people had no idea about this amazing…

We need to provide managers within our company a detailed breakdown of income and expenditure relating to their areas each month & quarterly. We are currently using the nominal activity report and selecting line by line the relevant nominals' that they…

Hi, Can anybody help with an issue I'm having in report designer? I recently updated our layouts with some new company branding. We use some layouts to generate certificates for each item/product line in the sales order, however the REPORT.PAGE expression…

Hi, I am writing a report to show outstanding items left on an order, so I am using the order confirmation report layout we have, and added SOP_ITEM.QTY_DELIVERED in the ITEM_NUMBER Header. Then added an expression to that line as follows:- If SOP_ITEM…

Hi, I have added a REMITTANCE.EXTRA_REF variable in the REMITPLAINA4.LAYOUT file for Remittance Advice expecting the Ex Ref records to populate this field but it remains blank when the Remittances are generated. Why does this happen and is there any…

Our business is driven around using the Project Module within Sage. What I cant seem to do is find any report within Report Designer that enables me to simply print my Cost Code Budgets (Set pre start of Project) against the actual Spend figures. It…

Hi, Is it possible to create a report which will export the data in the following columns? Order Date / Order Number / Account Ref / Account Name / Product Code / Product Description / Quantity / Price £ / Net £ / Trying to do this without…

After ungrading to v24 some of our reports are not as they were. Specifically, the Remittance Advice to Suppliers does not have the correct wording in the body and when the email is produced it is addressed to PURCHASE_LEDGER.EMAIL instead of the supplier…

I want a "Profit and Loss (Monthly Breakdown)" [Filename PNL_MTH] - BUT, for the previous Financial Year. Is there one available?