Sage 50 Accounts

Is there a way to report on the forecast figures that can be entered in the Advanced Budgeting tables?

Evening I have downloaded to excel a nominal ledger (around 450 lines). Once the download has been completed and the information is on a spreadsheet, I have totalled the Debit and Credit columns and the totoals do not agree to figures on the screen…

excel integrated reporting. When importing data from a report is it possible to show it in data format instead of report format?

I have the following report, I am trying to add GRN.ITEM to the join editor so I can use GRN.ITEM_DATE as a criteria filter when running the report so only view goods delivered between certain dates. I have been unable to add this successfully, when…

Hi all, I am using the Sales by Product (summary) report located under Invoices and Credits. It gives the option to add date fields but the results on the report is the total sales over say 5 years - is there a way to break down the totals by year to…

Is it possible to display a page number in a report that displays the count pertaining to each individual company within that report? i.e. Is it possible to reset the page count for the next company within the same report? For example, Company AAAA…

Hello, We have installed Sage 50 on a virtual server hosted by a third party. When we run some reports on nominal codes section, it takes 10 or 15 minutes. The same reports run with in 10 secu=onds on a locally hosted sage. We have Sage 50 29.2 version…

I need a report to show how much stock was held and its value on a particular date, is there any such report? (The Stock movement report doesn't help much as it requires alot of manual intervention). Thanks

I need a report for an export for obtaining Feefo reports that contains customer information but also some invoice information. I am currently editing "Day Books: Customer Invoices (Detailed)" and I need to add in the product code from the relevant invoice…

Hello, Does anyone know of a way to produce a report of customers that bought from a supplier in sage 50c. For example: If I have a supplier and I want to know every customer that bought anything from that supplier for a period of time, what report…

We need to start using the quotations feature. When we go to print a quotation, we're missing most of the templates including some sales order templates. We want to modify a sales order template so we made a copy of it, renamed it, but it's not appearing…

Hi, In reference to Quantity on order, is there similar variable to add this information to a report? The current orders, supplier and number? Currently I need to open each item within products and service, click the "on order" box, wait, make…

Hello, We are searching for a powerful sales analysis application that offers comprehensive reporting capabilities. We need detailed sales reports categorized by customer, country, product, and sales representatives, among other criteria. If you have…

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…

Is there any way to run a P & L for April if the year end to March hasn't been run yet? Sage 50 Accounts (not Cloud)

I would like to run an Aged Creditors Analysis report for suppliers but with all the attached invoices for suppliers included. Is this possible?

Hello, I have a "previous 12 months stock usage" report that I use to help with predicting stock reorder levels. Its set up with a pre-set date range that I have to change every so often to reflect usage of items that fall outside of the original…

I was looking for a 'Delivered Purchase order report' - basically one that had all of the Goods Received Note details on it, but it also included POP items too from the original PO. The standard GRN reports exclude things like price, etc. which is…

Hi, I have a report set up that I use to check supplier deliveries and I want to add another document to the printout so that I get the Sage report and a Word document print together. Is this possible? Regards Andy

Hi All! I'm trying to edit our purchase orders so that it works with both types of orders we do. Sometimes we don't add a code for items we're ordering in on a one off basis and we just use the S1 - Special Item code. When using STOCK.SUPPLIER_PART_NUMBER…

Does anyone know how I can run a report of all my customer e-mail addresses so that I can do an e-mail shot with a new price list?

Hi, I essentially I want to see my nominal ledger, split by department. I'm building a report in Excel that uses the connection properties and command type of SQL to extract data from the SAGE databases, but I'm not seeing any links between departments…

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…

Example Order 1 - 3x product A, 1x product B, 5x product D Order 2 - 2x product A, 3x product C, 3x product D Is there a report which can list what products are live orders, such as... 5x product A 1x product B 3x product C 8x product…

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…