• Monitoring and reporting fixed asset expenditure against budget

    We have a healthy annual fixed asset budget which requires regular monitoring and the preparation of reports appropriate to the level of management. We use advances departments in depth and the system allows for budgets to be applied to the fixed asset…
  • ETSY help with showing on Sage!!

    Please does anyone have a clue with how I enter Etsy transactions onto Sage?! It's a nightmare as the payments received have VAT already excluded (or the other way around) and then theres the fees which are either with or without VAT. I just want a…
  • Messing up indices in 28.1

    Since we've upgraded to 28.1 an issue regarding the indexing of customers has arisen. Today, after tidying up accounts, batch changing some (to Inactive), I now find that we have 1341 accounts with 459 inactive, which obvious leaves 991 when I remove…
  • breakdown of my sales figures (turnover) for the last year

    Hello, I need to do a breakdown of my sales figures so I can see my turnover for the last 12 months. This would be by 4000, 4001,40011, 4002,4003,4004 nominal codes. Is there a way of doing this and producing a simple chart? I need to show the following…
  • Extract details from combined INVOICE field - Sage line 50 report designer

    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…
  • Import Project Transactions - Net Billings

    Hello, I'm in the process of completing my data import into Sage 50 Cloud Accounts. I've been testing in the practice data file and I cannot figure out how to import the net billings to a project from my previous software. The costs are easy enough…
  • Re-Indexing every week.

    We have over the last few weeks started to get issues with Sage needing to be reindexed every week. The data is on a dedicated server PC running Windows 11 with a SSD We only have around 15 users. None use the cloud option, all work directly from our…
  • Disputed invoice with no "d" alongside it when get partially paid

    When invoice is placed in dispute, normally "d" appears alongside it, however for some my customers and suppliers it disappear when invoice is partially paid. It should show "dp" , however it only shows "p". When I go to disputes, the reason is there…
  • Bank feeds, Rules, supplier payments and other gripes

    I'm new to Bank feeds, as I have just been forced to upgrade from a perpetual licence, and Bank feeds was one of the things I thought would sweeten the pill. I set up a few Rules so my direct debit payments can be posted automatically. What a great…
  • CSV sales order export with headers

    Hi, We need to export our sales orders to import to our warehouse system, but the new system requires CSV files to have the first row of headers. However I would try to create headers - they would only appear on excel forma, but not CSV. Please…
  • Transaction not viewable in Customer Ledger

    I am trying to view transaction in a customer ledger going back several years. But I am only able to see the latest transaction from 2020. There are invoices/credits posted to their account dating to previous years but on the ledger they are not visible…
  • Automatic reminders to customers

    Both Quickbooks and Xero send automatic overdue invoice reminders to customers, but I can't find anywhere in Sage that does this Does it exist, and if not are there any plans to introduce it? Many years ago, when I first started using Sage there used…
  • Display of Payment terms

    Hello, Is there any report within Sage which displays Payment terms with customers/suppliers? I have set the Payment terms in the Credit Control area within the Customer/Supplier Record. However, I have not managed to find any report which…
  • ODBC Connection to MS Access fails after Upgrading to Sage V28.0

    Hi all, Previously I was successful in upgrading the connection from V25 to V26 to V27. Now, I have upgraded to V28.0, but I cannot refresh my Access database using ODBC connection. This time I was again able to create a System DSN named SageLine50v28…
  • Work off-line, and why didn't it work with todays Sage Identity outage?

    So Sage Identity had a global outage today. Starting Sage popped up an Authenticating box that was blank, closed this box and then presented with the choice to work off-line. Great I thought, until I clicked it, and was put back into the Authenticating…
  • Sage 50 Cloud accounts how to find unposted invoices

    Hi all, I am writing a basic system to automate chasing of invoice payments from customers so they get an email prompting them to pay outstanding invoices. I am struggling with v28 SDO to collect invoices that have not been posted Can anyone give…
  • Report showing stocked products with zero sales

    I'm looking to create a report, or (preferably!!) doctor an existing report, that will show me products that have had ZERO sales within a specified time period. Any ideas?
  • Using back up manager to backup to a mapped drive

    Is it possible to use backup manager to schedule the backup to a mapped drive on our network?
  • Access rights to different Personal

    Since version 21 I have continually contact support and the software writers about the question I raised with you. Personally the new read Only user defeats the object in that many businesses have several users on the software at the same time and all…
  • Inclusive Autoentry and Suppler Payments - discount if not using them?

    Whilst it is always nice to have something included, neither of these services I'm now paying for within the subscription is of much use to me. I've tried the AutoEntry, in case it helped, but it is slower than doing things manually plus it can't cope…
  • Budget figures not reporting

    Using standard budgeting in Sage 50C Prof. I've entered budgets for the first time, and they show fine in budgeting, but any report that I run returns either 'no data found' (if budget only) or zero in the budget column of actuals vs budget type reports…
  • Anyone Interested In A CRM For Sage 50cloud (also known as Sage 50c)

    Having used Line 50 as our 'back-office' system for 18 years we tried to find a CRM that would seamlessly integrate with it and endded-up creating our own. We having been using our system for over 18 months and, as well as standard CRM functionality,…
  • bulk entry under the BIRDS scheme

    Hello, Does anyone know how to account for VAT under the bulk entry BIRDS scheme? In January I imported a low-value package from an Italian supplier (B2B). I did this on my own Fed Ex account and produced the commercial invoice myself and had the goods…
  • Is there any way to unactivate foreign trader?

    We activated the add on previously but will now no longer need it, how can we turn it off and return to a traditional view of bank accounts etc? Without base balance etc etc Thanks. James
  • Why has emailing (or printing) a supplier remittance advice now got several more steps with V 28.0.226.0?

    What happened over the festive break?! Before Christmas, when making a supplier payment, selecting the button to 'Create a Remittance Advice' immediately brought up the remittance advice note. It was then simply a case of sending to email, printing or…