Sage 50 Accounts

I have a customer who is currently running SAGE 50 accounting, when she runs the trial balance report in Excel via a plugin, she gets the following error..... Any suggestions welcome.

I am trying to export 'Data to Excel', on the 'Profit Report By Customer - Summary', but it doesn't bring through the Profit column, nor does it keep it in the same order as the report. Does 'Data to Excel' not bring through formulas? Also, it brings…

I'm trying to add "Qty_makeup" to a sales order so I have a column for the qty on the sales order, and next to it, a column stating qty I can make up from available stock. For some reason, I can not get this to work, is there anything I may be missing…

Hi All I am trying to amend the invoices and credits by customer report so that it shows the carriage charge invoiced. I have added the expression to calculate the carriage charge which it has done but i notice that if the invoice has more than…

Hello, I need a report for Customs now that we have left the EU within Sage 50 Accounts I need to add the weights per commodity codes imported to a Purchase order. I have an individual weight of a qty line shown shown as POP_ITEM.QTY_ORDER*STOCK.UNIT_WEIGHT…

So this question is based on a report I've been working on for while and just can't crack. I'm trying to create a report which is effectively a total requirement list for a Sales Order. It needs to list the sales line items together at the top (effectively…

Is it possible to receive automatic daily reports directly from sage using a scheduled time / date? So if i want a certain report to be emailed to me, or generated, it doesn't it automatically without me having to click on the report & criteria every…

I want to create a SOPS report Outstanding SOPS Grouped by Sales Order Sorted by Due Date (Sales_Order.Despatch_Date) I've tried using a standard report; however, I can't seem to change to details to allow both grouping of items by order number…

Can anyone help me with the following I'm trying to set sage 50 up for a company that gets different funding for projects, some of the funding overlaps into the difference projects. I've tried departments but this isn't working correctly. I need to…

Hi, After we updated Sage 50 Accounts from 24 to 25 we’re facing many issues with program stuck and we need to restart user session to be able to do something. Sage 50 is going slower after the update too. Is there a way to solve this problems? …

Sorry to repost this issue again but I am desperate to find a solution. I am using Sage 50c Accounts Essentials. When I create the email with my remittance attached in pdf format the Extra_Ref value does not appear even though the data field is on…

We are conducting our end of year and are looking at finding out if all invoices raised for the year are entered onto the system. Any help would be greatly appreciated!

I'm trying to find out how to add a filter expression on a report for Sage 50 Accounts, such that the report only looks at GDN_ITEM_DATE that is from the last 12 months from the CRITERIA.GDN_ITEM_DATE_TO specified when the report is run. I then need to…

I have a sales order template and the values in it were erroneous. These do not go to clients and as they are for internal use only have never been fixed however I would like to resolve this. I have changed the Net, Tax and gross figures successfully…

Can anyone advise on the best report which shows a customer's payment history please? I need to see the regularity with which a customer is paying. TIA.

Hi there. The details of my sage are as follows: Version Number: 23.1.0.143 SBD Desktop version: 14.0.54.0 Updates installed: service pack 1 Report Designer Version: 1.4.2015.05 I am trying to give a customer a 15% discount if they pay within…

Hi, I've have tried a few expressions and filters to figure this out, but I can't seem to crack it. I want the group header and footer to not show if there are no values in the details section within the group. See image below. For reference, this…

Hi, I am running a report in the Invoices and Credits section of Sage 50 Accounts Professional. This report gives me the following information: A list of the products sold for that month itemized in alphabetical order The net amount made from…

Hello all Aim: In an attempt to contact customers to offer 'special offers' or encourage more orders, I would like to be able to look through customer's previous orders, recognise the 'repeat orders' and establish a 'special offer' or at least a reminder…

We have various product categories setup within our Sage 50 stock module and I would like to be able to run a report detailing sales by category.

Greetings All, This may not even be possible, but I will do my best to articulate what I'm trying to achieve and hopefully someone is able to help. I'm using a report from the Customers tab > Agents Commission (@10%). I have modified this slightly…

Hi, One of the computers on our network running Sage 50 Accounts Pro takes a very long time to print some reports. When previewing, say, an invoice, it takes around 2 minutes for the print window to pop up. None of the other computers on the network…

Hi I have come across a situation where the products listed on quote sent from Sage 50 Accounts Professional are appearing on the Outstanding Sales Orders by Product Code report. Due to this, the shortfall is misleading as products not needed to be…

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.

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