Browse By Tags

Does anyone know if there is a AR Tax Group set up report that exists so I can see what tax rates are part the group? Looked in standard reports and KnowledgeBase but have not been able to find anything.

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…

Does a profit and loss report exist in Sage 50? Web search shows it exists in new cloud versions, but I cannot find one for Sage 50 US. If not, does anyone have one I can purchase and import into Sage? I would like the report to include income, cost…

Is there a way to create a report group? When I make financial statements, I can combine multiple financial statement reports into a financial statement group and by choosing that group to print, it will print all my financial statements for the selected…

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…

I've been using the Purchase Analysis intelligence report, however I want to add the "Purchase Order No." (not JobID) in the report. Sage has to be storing it somewhere, because we fill it out on every PO we input, same with "Unit Price". It is not…

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!

Does anyone have an AP historical aging report they would be willing to share? Either in report designer or office connector. Thanks in advance, Amanda

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?

I have a Job Cost Report that I run task and it will send out to each PM but includes one report with all of their jobs. How do I change the report conditions so it will send a separate PDF report for each job that only contains information for that one…

Greetings, I am following the instructions of KB186526 to create a Date Prompt on a JC report. I am able to create the prompt fields. I can make the design formula (using Accounting Date [JC Transaction] instead of Accounting Date [GL Transaction…

I am trying to customize a standard job cost report in Report Designer. It currently details the costs by cost codes and categories. It is totaled at the bottom, where then a % is added on to account for overhead. We are now allocating some of the overhead…

Hi, i get this error when open BI Report Manager I'm on Sage 2014 PU3 "The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : - SELECT…