Browse By Tags

  • Profit and Loss Reporting

    Hello, I am trying to run a P & L account report on Sage 50 to include all income and expense line regardless of whether any transaction has been recorded in each nominal code or not. I just want the report to include all line items. Is there a way…
  • Journal dates being amended in the background

    I have noticed that if you are using file maintenance to amend a journal (even if it is just the details) and the normal journal entry screen is open in the background, then amended journal will also amend the date of its posting to the date of the background…
  • 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…
  • Problems Adding a User to Remote Data Access

    We have recently moved some companies on our servers This process has been straight forward for most users, but we have one user that always says they are already connected to the company when attempting to add her remote access connected to the company…
  • 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?
  • Remote Data Access is to be avoided at all costs

    Please heed this as a warning for anyone considering using Remote Data Access. If you value your data in any way, then please, for the love of everything sane DO NOT use it. Now I will say, the program itself offers some good features. I especially…
  • 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?
  • Sage City Ideas Board Drives New Features and Improvements in v28.1

    Sage 50cloud Accounts v28.1 features a large selection of features that were requested directly by customers through the Sage City Ideas Board. The Ideas Board is an online forum where you can suggest features and improvements and vote for other suggestions…
  • 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…