Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue

Discounts on Sage products & subscriptions. Discounted subscriptions for customer using pay-as-you-go support or who are self-supporting.

Want web hosting, email, your own domain name, a shop, sage integration we can do it, from £12 a year!

Search found 4029 matches

by brucedenney
09 Aug 2018, 11:12
Forum: Sage 50 UK version General Help
Topic: Reporting on S3 Lines
Replies: 4
Views: 52

Re: Reporting on S3 Lines

You have the filter set to

Code: Select all

INVOICE_ITEM.STOCK_CODE NOT LIKE "S3"
Remove that and you should be making progress.
by brucedenney
08 Aug 2018, 13:37
Forum: Sage 50 UK version General Help
Topic: Reporting on S3 Lines
Replies: 4
Views: 52

Re: Reporting on S3 Lines

The Answer lies in the join type between the tables. When the S3 code is found, it trys to look it up in the Stock table, but, it doesn't exist, so it returns no data. You need to change the join type between the invoice item table and the stock table into a "ParentOuter" this will always include th...
by brucedenney
07 Aug 2018, 14:35
Forum: Sage 50 UK version General Help
Topic: Sage 50 UK query
Replies: 1
Views: 24

Re: Sage 50 UK query

Hi Karen There is no easy solution. You can not offset them against each other. I suggest you create a "contra" bank account in each currency Receive payment from their customer account for the Sales invoices Transfer the Money from currency1 contra bank account to currency2 contra account Use curre...
by brucedenney
07 Aug 2018, 14:34
Forum: Sage 50 UK version General Help
Topic: Sage 50 UK version
Replies: 1
Views: 17

Re: Sage 50 UK version

There is no easy solution. You can not offset them against each other. I suggest you create a "contra" bank account in each currency Receive payment from their customer account for the Sales invoices Transfer the Money from currency1 contra bank account to currency2 contra account Use currecy2 bank ...
by brucedenney
02 Aug 2018, 16:51
Forum: Sage 50 UK version General Help
Topic: Sage 50 nominal Code report help ?
Replies: 1
Views: 26

Re: Sage 50 nominal Code report help ?

You can view the company based on your chart of accounts. There are also lots of reports that would print the p&l in a number of ways, for example reporting against budget or the previous year. You can make a chart of accounts that groups things as you want. You can have multiple charts of accounts ...
by brucedenney
25 Jul 2018, 15:18
Forum: Sage 50 UK version General Help
Topic: Transaction email
Replies: 1
Views: 25

Re: Transaction email

I don't have access to tmail in V12 but I suspect you can defeat it by setting the email password to something that is invalid.

You could also try renaming the file TMAIL.INI in the Accdata\Tmail directory as that should contain the config for tmail.

Hope this helps

Bruce
by brucedenney
23 Jul 2018, 10:27
Forum: Sage 50 UK version General Help
Topic: Difference between QTY_ON_ORDER and QTY_REORDER
Replies: 1
Views: 21

Re: Difference between QTY_ON_ORDER and QTY_REORDER

The QTY_ON_ORDER is the number of items that are outstanding on purchase orders right now.

The QTY_REORDER is the number that we should re-order when our stock level goes below the threshold set.
by brucedenney
23 Jul 2018, 10:25
Forum: Sage 50 UK version General Help
Topic: Sage closes with no errors after Network Company Set-up - RESOLVED
Replies: 5
Views: 81

Re: Sage closes with no eerrors after Network Company Set-up

I think the best thing would be to set it up as a local install with a local blank empty new database and then, once you have that done, you can see if the version is correct etc.

Then you can reconfigure it to look at the server.
by brucedenney
16 Jul 2018, 10:28
Forum: Sage 50 UK version General Help
Topic: Sage closes with no errors after Network Company Set-up - RESOLVED
Replies: 5
Views: 81

Re: Sage closes with no eerrors after Network Company Set-up

Does the network server hosting the data have the same version of Sage50 installed on it?
by brucedenney
16 Jul 2018, 10:27
Forum: Sage 50 UK version General Help
Topic: Data Service Manager
Replies: 3
Views: 47

Re: Data Service Manager

The X in the top right box of what application?

Are you saying when you close Sage the service stops working?

Can you do a screenshot?
by brucedenney
11 Jul 2018, 14:00
Forum: Sage 50 UK version General Help
Topic: Data Service Manager
Replies: 3
Views: 47

Re: Data Service Manager

You should not need to amend the Sage Data service, it determines where the DataService is from the UNC pathname you provide it when you set up the workstations. "everytime I x the box it disconnects the data service" ??? What do you mean when you say you X the box? What box? The data service should...
by brucedenney
11 Jul 2018, 13:54
Forum: Sage 50 Report Designer
Topic: GDN prints on several pages
Replies: 3
Views: 67

Re: GDN prints on several pages

Hi There are a number of issues with the layout, however to directly address the issue you post about. There is a hidden GDN_NUMBER header section in your report. That section has the property Behaviour>Page Beak Before>True So before that section prints there is a page break. The section may be hid...
by brucedenney
11 Jul 2018, 13:33
Forum: Sage 50 Report Designer
Topic: Remittances Extra Ref-Batch Invoice(showing) vs Update Ledger(not showing)
Replies: 1
Views: 24

Re: Remittances Extra Ref-Batch Invoice(showing) vs Update Ledger(not showing)

I am not sure what report you are doing but... The remittance table is a special table that only exists for doing remittance advices. I am guessing that you want to do a report that currently runs on the AUDIT_HEADER table but you want to include data from the AUDIT_SPLIT table (for the Extra Ref Fi...
by brucedenney
06 Jul 2018, 14:21
Forum: Sage 50 UK version General Help
Topic: Dump files
Replies: 20
Views: 402

Re: Dump files

I have had a look and found that I have this happening on one of our Windows 10 PC's

I can't seem to find a reason for it.. I will be digging around when I have some spare time.
by brucedenney
06 Jul 2018, 09:12
Forum: Sage 50 UK version General Help
Topic: Dump files
Replies: 20
Views: 402

Re: Dump files

Does the windows 10 machine have the dump files?

Typically the root of c: is not writable by users... I wonder if it is the service that is doing it?