Sage 50 Accounts

I am importing invoices using the template and I keep getting the error: The tax goods analysis total does not match transaction net value. What causes this issue?

Can you use the 'Fax' field on Sage 50 Customers Details record to import other information other than a Fax number or any number?

Hello all, hope you are enjoying this lovely sunshine? I bought a new desktop, yesterday. Everything is peachy, except that the fresh install of the full Sage 50 program wont export to PDF, or export/import to Excel. It will crash and close when I try…

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…

Hi all, Is there a way in Sage50Cloud to automatically create sales invoices based on a spreadsheet/csv file? I want to be able to use import/macros/python etc to produce a physical invoice via Customers->Invoices and Credits (not simply importing…

I can see from various forums that this topic has been around for literally years! I understand that this is not possible today from standard Sage, but I have been informed it is possible through 3rd party developers. So why has Sage not integrated…

We have three companies in Sage 50cloud Accounts Professional. Two were set up some time ago, and the third one in the last year. We import purchase invoices from a third party programme called Synergist which also has three companies to match Sage, and…

Hi, I just downloaded postponed VAT statement from HMRC, but I've already posted trade supplier invoices with T0 before statement received. What adjustments need to be done in this case please? Should I just batch new supplier invoice with T18 , leave…

Hello, I am new to sage and our external payroll process is extremely manual and time consuming with room for lots of human error. our process is once our invoices have been transferred to Sage we would move the the invoices and credit, filtering…

Hi All, I am using SDO (Sage Data Object) to import sales orders in Sage 50 UK. I would like to import Sales Order with the currency USD. I came to know that for that I need to use a specific customer who has USD currency allocated. I am using currency…

Hi, I am in the process of setting up a new company in Sage 50 Pro. I am struggling to work out how i can import open purchase order lines, open supplier invoice and open customer invoices. I have over one hundred open po lines which i obviously want…

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…

Hi All, I am using SDO (Sage Data Object) to import invoices in Sage 50 UK. I would like to pass a multiline text in the details(Text) field. I tried many ways but unable to set value in that field. I tried to pass simple text but the value does not…

I am looking for a software that can import sales invoices from pdf into sage 50. I have found several out there but so far none have been able to import line items including product code, product description and net VAT gross. Does anyone know…

We are importing Product Invoices and Credits into the latest Sage 50 Cloud version using E2S. This works well with one exception, VAT only credits. When creating a VAT only credit in Sage we are able to create credit lines with zero item value and…

Hi, We currently use an excel template to upload our sales invoices. However, a single invoice will often contain a mix of zero rated and standard rated VAT, which means we are uploading these as 2 lines, so that the net sales figure is appearing…

Hi I have started importing invoices but every time I have to manually map the correct columns its starting to get a bit annoying, does anyone know how to create a map? TIA

I have some unfixable errors on my data so am setting up a new company. I want to transfer customers and suppliers products. Have exported the various reports, set up new shell company and have imported customers csv file. Customers have imported fine…

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…

Hi All, I am using SDO (Sage Data Object) to import Project by programming, In SDO v 22. I am able to import a new project. I also would like to update budget values but unable to find the property of an object to set budget values. Can anyone help…

I have a potential client who uses ICR Touch Software in their outlets. I hope to link this to their new Sage 50 cloud system which was specified by their accountant. At the time Sage was specified the idea of linking to the sales system had not been…

Hi All, I am using SDO to import Invoices by programming, In SDO v 24. I would like to import invoice without line items and also would like to set an Amount for that invoice. Is it possible? Can anyone please help me. Thank you in advance …

Hi, We'd like to import our purchase invoices, but many of these are multi line and will have different departments/tax codes per one invoice. I have tested the import in the Practice company and it looks like Sage 50 desktop will keep each line separate…

We are trying to find a way to import bank payments from Excel into Sage50 Essentials (Version 24). Each single bank payment represents several sources of income and need to be split into several nominal codes. If we use the standard input form we have…

Dear All is there any easy way how to import opening balances to new company in Sage 50 Accounts? Thank you for help Petr