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.
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?
When Errors occur in the Sage Database, if these cannot be repaired then the only viable option is to restore to the last valid Backup. However, the users have to first Print out any Data that they have entered into Sage since the last valid Backup and…
Learn how to import transactions in to your audit trail in Sage 50 Accounts. This can be a big time saver and common uses include importing direct debits and standing orders, salary journals, expenses and month end postings.
This session has taken place…
Learn how to import customer records in to Sage 50 Accounts. This option can be used to import new records and also to update existing records.
This session has now taken place, but you can catch up with a recording >
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…
Currently we can import data into nearly any field through the import templates... this and 'Batch change' is a great way to update multiple items at once. However, there is no quick way to clear data fields in bulk... these would have to be done manually…
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…
Importing records can be a great timesaver and isn't just used for when you first set up Sage 50 Accounts. You'll learn about the benefits of importing and how you can use it to import new records or update existing ones.
This session has now taken…
Can an import option be added to allow the allocation of customer and supplier payments from an uploaded CSV which includes the transaction ID and amount to allocate?
I am about to import hundreds of bank transactions to my Nominal ledger using a Journal Import Template. (Audit Trail template)
My question is what do I put in the Type column for the bank transactions? The BP will identify the debits in the expense…
We haver to maintain a separate paper record of customer incoming orders, or more usually they are PDF docs attached to an email. Same for invoices arriving from suppliers. Our suppliers and customers are paper free, so why not Sage? We need the capability…
I think this will have already been logged as an idea but I would like to add it again as, the more requests for this feature the more likely I believe it will happen.
The ability to import price lists using functions other than fixed price would be…
I wish Sage would release an update so that the import of transactions from CSV text file does not fail if it includes non-UK Purchase Invoices under postponed vat accounting (code T18) .
The transactions should successfully be imported from the CSV…
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 have been told by HMRC that the entries for VAT on imports from the EU should only be entered when a Postponed VAT Statement is issued.
At the moment Sage does this 'magically' but it is not necessary correct for timing.
Please would you remove…
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…
It seems counter-intuitive that you're not able to import negative values in a Budget .csv file. The workaround (import positive values then manually change them in the front-end) allows for many user errors. This could easily be changed, and would save…
The SME Brexit Support Fund gives eligible small and medium-size businesses up to £2,000 to help with training or professional advice on things like completing custom declarations and managing customs processes and import and export requirements.
Find…
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…
Currently
Default country of origin is United Kingdom (GB)
Problem
1. Some companies may only sell products from 1 country which is not GB. This means changing it for every product input rather than setting the default of their chosing.
2. Some…
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…
