Welcome to the Sage 50 Accounts UKI Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Currently
'headers' don't match.
When sending data to Excel e.g. Product Codes, the headers are not the same as the headers needed to import data back in (small section listed here for ease with the name Sage wants to use for import purposes in [brackets…
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…
Many businesses trade in different currencies. In Sage 50 Accounts, the Foreign Trader option makes this easy. You can set up customers, suppliers and bank records to use other currencies, meaning you can enter payments and receipts in those currencies…
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…
If you have a large amount of data to enter into Sage 50cloud Accounts or you want to make changes to multiple records you can save lots of time by importing the information. This brings all the data into your software in one go, rather than manually…
When using an import tool for the purchase invoice transactions I have found my transaction details are replacing the invoice header details as per the explanation given from Adept below:-
Unfortunately this is a foible of the Sage Activity window…
We have a client who creates an import file for different types of things e.g. prepayments, accruals, depreciation etc - it would be nice to have the ability to import more than one of the same import file type i.e. Audit Trail Transactions and the user…
Problem: Sage Line 50 Accounts is not international trade friendly. Other than Commodity Codes and the allowance to add trade contacts from outside of the company's 'home country', there seems to be little else which makes international trade handling…
It would be really useful to be able to import sales and purchase invoices from excel. We currently have a supplier who invoices us 100+ invoices a month which get downloaded into one excel report. It would take too long to add these individually on to…
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…
Can the 'Due Date' field be added as an option/field when importing data from excel. It is not currently possible to import the 'Due Date' field. Thanks!
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…
