• Supplier report listing all invoices with details/order no

    I am looking to run / create a report where I can see the following information in one place: Supplier Inv No Inv Ref / PO no Inv Details Net Amt Any help would be really appreciated! :)
  • sage 50account training issue

    I am currently doing 50AUK - Sage 50 Accounts - Customer Records. Whenever I do the costumer default training in this it automatically goes to import costumer details. Can anyone please tell me how to solve this issue?
  • Retrospective Product Valuation - Transaction Date Greyed out for the TO

    Hello, In my preview the Transaction date is greyed out for the from date to be To (Inclusive). In my instance I am able to amend the from date. Can anyone tell me how to make that from date available ? Thank-you Tracy
  • Integration with Pipedrive

    We have Sage 50 Accounts Professional Version 29.2.398.0 will this sync with Pipedrive if we use a 3rd party eg Zapier?
  • Subcontractor Remittance Advise - CIS Module

    How do I create a layout which would show CIS deductions on remittances? Please don't confuse it with monthly statement.
  • Username already in use error after refreshing queue.dta on a blank dataset v28 sage50

    Hi, I have had an exporter running Version 28 of the c# Sage 50 SDK that pushes invoices into sage from our facilities management software; this has worked previously, and continues to work for other customers, but for one customer I am getting "Username…
  • Allocate Stock to all products in BOM

    Good afternoon, I would like to be able to allocate all items in a BOM when I allocate the main product in a sales order. For example I have a Master Product, which is made up of 5 parts. When I generate a sales order with 1Qty Master product and…
  • Cannot update any qtys in Sage50 using sData

    Hi I'm currently using the sData adapter found in the Sage GitHub: https://github.com/Sage/sdata-downloads I also have a trial version of Sage v28.1.404.0 Ultimatley I would like to create an interface to maintain Product and Order information between…
  • Previously deleted old invoice due to an error and how to input it again?

    Hello, I have some issues with Sage 50, and long story short, I think I need to input provously deleted invoice due to an error. In May 2020 Sage came up with an error for 2 invoices back from 2014 and 2016. I have managed to delete those and Sage…
  • Can you convert a quote to a sales order and then convert the sales order to an invoice?

    Hi Were using sage 50 cloud accounts. At the moment we only seem to be able to convert sales orders to invoices. We cant seem to be able to convert a quote into a sales order and then into an invoice. Is there a way to be able to convert both quotes…
  • Sage50c Professional API

    Hi there, I am looking to integrate Monday tasks into Sage such as Purchase Invoices. I have seen this is possible through Zapier, however, that doesn't seem to work with our current membership and requires us to have Sage Business Cloud? I have been…
  • SUPPLIER BATCH PAYMENT

    Is there any add on or plug in for sage 50 to add more filters on the batch supplier payment function. The company i work for is a contractor that pays both subcontractors and Normal suppliers and it would be very useful if we could filter between there…
  • Sage 50 Accounts ODBC query - transactions missing from audit split table

    I have a long standing (5 yrs plus) excel workbook which is an extract from the audit split table for a client via MSQuery/ODBC. The client is on V26. I noticed for the first time this morning that there is a large number of transactions missing from…
  • Where are the SDO (Sage Data Objects) logs stored?

    I'm having some difficulty Posting an Invoice via SDO, the .Post() methods just returns "false". I'm assuming there must be somewhere I can look to diagnose why I can't update the ledger, as the invoice is added fine. Cheers Adam
  • Why is the 'Use Default Tax Code for Sales' tick box greyed out?

    Hello, On a couple of my customers, the tick box for 'Use Default Tax Code for Sales' is greyed out, when T22 is selected as the Default Tax code. Does anybody know what may be causing this? I've never seen it greyed out before and don't know what could…
  • No Companies in SData Settings

    Hi, I cannot view any company in Internet Options> SData settings. Mapped drive is being used so, I have used UNC Path to the folder and provided logon rights of the SData service to the network service but to no avail. I need company's URL address…
  • Nominal Ledger Activity Data import into Microsoft Power BI

    Hi, I am a Business Intelligence Developer in my company and importing data from Sage 50 accounts database into Power BI using sage ODBC driver. Nominal Ledger table has data at month level but now, our requirement is data at the invoice level. There…
  • Product Distributor - Customer or Supplier? and how to enter their expenses into Sage 50

    Hi wonderfully helpful forum We're currently using Sage 50 and have started working with a company who are distributing a product for us. This company has paid the manufacturing costs themselves upfront, with a view to recouping this expense through ongoing…
  • Can you import invoice line items into an invoice from a spreadsheet?

    FormerMember
    FormerMember
    Hi I spoke to my guy in accounts and he assures me that it's not possible to import invoice line items into a new invoice (using sage50). I tried copying directly from a spreadsheet into the invoice but it just copies the text as multiple lines within…
  • EBITDA report

    Does sage 50 Accounts Professional have an EBITDA report, to be able to calculate a companies EBITDA at any given date? Or the current value? Hoep someone could give me an answer or help me design a report that can calculate this. Thanks.
  • Setting a Default Expiry date up on Customer Product Quotations SOP

    Is there an option within Sage 50 which allows customer quotations that are entered on the system to automatically have a date set up for expiry date? Within our company we set Customer Quotations up with a 3 month Expiry, is there a way we can implement…