Sage 50 Accounts

To give you a quick rundown, our business runs different programs in several different counties. With that being said, we categorize expenses for each county with jobs (established this calendar year so it is new). This has been working great, but the…

Hello, Does anyone know how I clear a sterling balance of (0.01p) on a customer account when the foreign balance (€) is zero. We use a flat rate for our €, so it never changes. I have 15 customers that have not ordered for a decade so I would like…

We raise invoices daily for our customers directly from the Invoice Module and experience no issues with stock adjustments. However today I've noticed that invoices generated from a Sales Order (normally raised from quotes issued), and where we later…

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…

Hi Everyone We have developed a few apps to help automate capturing into SAGE Pastel Partner in South Africa. We have been approached by a few UK companies using SAGE 50 to look at the same products. I have been trying to research whether the sdk connector…

Hi. I'm wanting to extract the product details however most of our product codes start with varying numbers of zero's and some without zero's at all. I need to retain the zero's but after extracting the data I have lost all the leading zero's. Is there…

as above

Hello Team, Could you provide a link to the source where I can download the trial version of Sage 50 (UK)? I want to install the trial version so get familiar with the functionality. Thank you!

Hello, On a couple of my customers, the tick box for 'Use Default Tax Code for Sales' is greyed out, when T22 is selected as the Default Tax code. Does anybody know what may be causing this? I've never seen it greyed out before and don't know what could…

Problem We have several users who look after sales and purchasing who are in different offices. Often, one user will input e.g. a sale; however, other users cannot see this sale immediately which can result in the sale being input again by another user…

I have set up a custom statement to show the customer PO on our statements. This has been done by a local join from: FROM INVOICE_NUMBER to INV_REF_NUMERIC - Parent Outer However this works and shows the order number as planned... However when there…

Hi Sorry if this has been asked before - I have had a look through the previous questions but can't find what I'm looking for. I'm not trained in accounts, I use Sage for our family-run business so apologies if I'm asking silly things :) When reconciling…

Can anybody suggest how to design the invoice form to include amounts in words in sage 50 UK.

Hi, I've just started converting quotations to invoices. If I amend the invoice it comes up with a warning: "This invoice was created from a quote. Any amendments made will be shown on both the quote and the invoice." Is there a way to deactivate…

Afternoon I was reconciling Jan to March VAT . (Sage50) i had calculated the vat return and was trying to print when my machine crashed me out of Sage It does not now seem I can reprint the return in order to send to head office who then consolidate…

Hi I'm looking to create a conditional formatting expression where if a stock code is more than x characters (lets say 10) long, then enable word wrap. I know how to enable word wrap, it is the 'if' part of the expression I am struggling with. Does…

I am trying to import customer and supplier records - most of which are overseas - there is no where in the sample file for country - is there a reason for this. This means we have to manually amend each supplier or customer - is this correct ?

Does anyone else have issues using the Sage 50 quick search box where it boots you out of the program? We have 3 clients that have an issue with v26 doing this, not all have multi users. Any ideas to why?? Thanks in advance.

Hi Extracted Sage Invoice items to JSON and I am seeing some duplicated invoice lines in the data that do not appear in Sage50 view. I have noticed these items have duplicated indexes so I have 2 invoice items but Sage only displays 1, cannot find…

Hi When configuring the email settings for a report and attempting to change the Filename (as standard is set to REPORT.DESCRIPTION), an error comes up saying "You must enter an expression that returns a 'System.String' value. What does this mean…

I have had the following error message when trying to run the @Sales by product (detailed)@ report in invoices on sage 50....... "The report could not be generated. Arithmetic operation resulted in an overflow." Has anyone had this before and…

Hi Can anyone assist please. I have an invoice from the repair company that repaired the company vehicle. The invoice is for the VAT Element of the insurance repair and the excess as follows: VAT Element of insurance repair £2639.60 Vat 20% Amount…

Making Tax Digital (MTD) has graced our presence for the best part of a year, coming into fruition for most businesses since April 2019. By now the world and his dog should be aware of MTD! However, for those of you who are still wondering what it's all…

Hi, Is it possible to re-build my data excluding invoices and corresponding bank receipts only? Thanks

My developers require a test environment to ensure the integration with Sage is complete before linking to our live Sage data. Does anyone know the process for this and what should be done so I can clearly direct both the web developers and IT company…