SageForum for UK versions of Sage 50- Help and support.

The filter expression given by Bruce looks for any record which does not have a value in the SALES_LEDGER.EMAIL field on the customer record, so should pick out any customers which do not have an email address recorded.

You can also use the following filter expression, which I use for my statements ...

Thanks Bruce, I decided to go with Option 2 - shifted the post code up to line 4 at the expense of county, which is pretty much entirely useless these days anyway!

Rupert

Hi Bruce,

We have a number of customers who have multiple branches, but make all payments via head office. Due to payment issues, it is considerably easier for us to set the company up with a single account and have each branch as a separate delivery address on the SALES_DEL_ADDR table. This is ...

Hi,

I was wondering if you knew if it is possible to pull information from delivery addresses set up on an account, specifically I am looking to get the contact information from the following:

http://i.imgur.com/dvwVi5C.png

Do you know the table/data field location for this information?

Thanks ...

Hi,

I was wondering if you know if there will be any changes to the way negative stock is handled in Sage 2015?

At the moment, we have the 'allow negative stock' option selected as we need to be able to allocate stock from goods that are en route to us (there can be a lengthy shipping period for ...

There are two different layouts - one for email, one for printing on our headed paper - and I have stripped out the company information. If you have any recommendations for tweaks/amendments then I would be happy to hear them :)

For reference, we are using account status 0 for customers paying from ...

I now have this working almost perfectly, the only issue is when invoices fall due on a non-working day - but this is easily circumvented by adjusting the system date before running. If you're interested, I can send you the layout files?

Hi Bruce, I'm not sure what you mean - can you give me a bit more detail please?

What I am trying to do is get a batch report set up to print the daily invoices on the following schedule:

Invoice (next day)
Invoice Reminder (due date)
First Overdue Reminder (7 days overdue)
Second Overdue Reminder (14 days overdue)
Final Overdue Reminder (21 days overdue)

So if I were to run ...

Ok, I've managed to get this working after a fashion; however, I now have to go into report editor and amend the date in the filter manually, i.e.

AUDIT_SPLIT.AGED_BALANCE <> 0.00 AND STATUS_NUMBER = 0 AND (AUDIT_HEADER.DATE + SALES_LEDGER.PAYMENT_DUE_DAYS) = "2014-05-09"

I have tried using the ...

Thanks Bruce, I have tried linking the tables, but I'm not sure which fields to join on - when I have tried I end up getting no data for the report, so I assume that I'm doing something wrong...

Hi,

We are using Sage 50 Accounts Professional 2013 (v. 19.01.11.285) with Windows 7 Professional (64-bit).

I am trying to set up reminder invoices for when they become due, I have managed to set up customer reports (amended from default Customer Invoices Overdue report) which list invoices due on ...