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
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!

Search found 4040 matches

by brucedenney
16 Oct 2018, 13:41
Forum: Sage 50 Report Designer
Topic: Make Back Orders Show on GDN
Replies: 1
Views: 17

Re: Make Back Orders Show on GDN

The GDN is a separate table to the main table, typically you would not use a GDN but a delivery note, the delivery note is based on the SOP tables so can read how many were ordered shipped etc. A GDN is a historical snapshot it knows noting of the order and what has happened to it, it is just about ...
by brucedenney
16 Oct 2018, 13:34
Forum: Sage 50 UK version General Help
Topic: Invoice
Replies: 1
Views: 23

Re: Invoice

The auditors will only care if the amount of the prepayment is material. If it is £1000 on a £100000 turnover then it doesn't matter. If it does matter eg if it is £25000 out of a £50000 turnover then they will make an accrual/prepayment for it, as long as they know. If you want to be clever, you co...
by brucedenney
03 Oct 2018, 16:24
Forum: Sage 50 UK version General Help
Topic: combining invoices
Replies: 1
Views: 177

Re: combining invoices

You could start an invoice on the first day of the month and items each day to the one invoice.
by brucedenney
04 Sep 2018, 16:53
Forum: Sage 50 UK version General Help
Topic: SOP_ITEM table issues
Replies: 4
Views: 454

Re: SOP_ITEM table issues

It doesn't do any harm. Backing up first is still a good idea.
by brucedenney
04 Sep 2018, 16:43
Forum: Sage 50 UK version General Help
Topic: Errors in addition
Replies: 3
Views: 318

Re: Errors in addition

What was the date on the journal.
by brucedenney
30 Aug 2018, 12:30
Forum: Sage 50 UK version General Help
Topic: SOP_ITEM table issues
Replies: 4
Views: 454

Re: SOP_ITEM table issues

P.S. If you reindex and compress... the records should disappear.
by brucedenney
30 Aug 2018, 12:05
Forum: Sage 50 UK version General Help
Topic: Errors in addition
Replies: 3
Views: 318

Re: Errors in addition

Have you run Check Data to check you data is okay?
by brucedenney
30 Aug 2018, 12:04
Forum: Sage 50 Report Designer
Topic: Adding information to Debtors Reports
Replies: 1
Views: 669

Re: Adding information to Debtors Reports

What you will need to do is to link the invoice to the Audit Trail, you link INVOICE.INVOICE_NUMBER to AUDIT_HEADER.INV_REF however, this needs to be a parent outer join so that when there is no matching Invoice eg a manually entered one / credit note / sales receipt etc the audit trail record is st...
by brucedenney
30 Aug 2018, 12:00
Forum: Sage 50 UK version General Help
Topic: SOP_ITEM table issues
Replies: 4
Views: 454

Re: SOP_ITEM table issues

I think this is an "issue" in Sage that you can not overcome. I have some other ways of looking at the tables and there is no "record deleted" field. I think sage is relying on the indexes to know what is deleted, indeed this may be related to a data corruption issue (in POP SOP and INV) where items...
by brucedenney
30 Aug 2018, 11:45
Forum: Sage 50 Report Designer
Topic: Sales Delivery Address Email
Replies: 1
Views: 189

Re: Sales Delivery Address Email

There is no link between the Delivery address table and the Order.

You can try and do it by matching lines of the address but that is flawed by and address changes. Essentially, you can not do it.
by brucedenney
30 Aug 2018, 11:43
Forum: Sage 50 UK version General Help
Topic: Splitting Sales Revenue
Replies: 1
Views: 208

Re: Splitting Sales Revenue

Yes you could shift income form 4000 to other nominal codes using a journal.

You would need a mechanism to establish how to apportion between the accounts.
by brucedenney
09 Aug 2018, 11:12
Forum: Sage 50 UK version General Help
Topic: Reporting on S3 Lines
Replies: 4
Views: 384

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: 384

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: 246

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: 233

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 ...