Missing Customer Statements Sage Instant 2014

Missing Customer Statements Sage Instant 2014

Didn't find your answer?

I have an issue with Sage Instant Accounts 2014 for a client and I wonder if anybody would be good enough to help me please.

When I run customer statements for all customers it only brings back statements for less than a third of the ones it should do at that date. If I highlight a specific customer I want the statement for it says 'no data available' for the majority of them other than the ones that appeared on the 'full' statement run. There is definitely data available.

Any ideas? I know it'll be something silly but I can't see it for looking.

Thanks in advance

Jon

Replies (14)

Please login or register to join the discussion.

avatar
By johndon68
08th Sep 2014 11:29

Filter

If you Edit the layout and go to Reports -> Filter, is there anything there?

John

Thanks (0)
Replying to hannahaston:
avatar
By bidefordjon
08th Sep 2014 15:18

Filter

Hi John

Thanks for your help.  I've never been in there before but it says this.  I'm reading that it's only selecting customers that have a balance and have communication letter type ID of 4.  What does that mean as it seems to be restricting the customers that get returned?

Thanks (0)
By The Highlander
08th Sep 2014 14:08

Exclude later payments?

If you are wanting to run a statement for a date in the past that includes invoices that have since been paid you must remember to click the exclude later payments box.  That's the only thing I can think of.

Is it specifically the statements you are needing or are you just wanting a debtor list at a specific date? If it's the latter I would use the aged debtors report.

Thanks (0)
Replying to Balancing:
avatar
By bidefordjon
08th Sep 2014 15:18

Hi Highlander

I've tried the tickbox for excluding later payments but that doesn't work.

It is specifically statements that we need to produce to send to the clients customers.

Thanks for your help.

Thanks (0)
avatar
By bidefordjon
08th Sep 2014 15:27

Based on something Highlander said.

When I run an aged debtors report I can see all customers with balances at that date.  However, when I run statements it seems to be being selective for some reason.

Thanks (0)
avatar
By johndon68
08th Sep 2014 15:47

Filter

Go to Advanced Filter and remove the part about Letter Type.

John

 

Thanks (0)
Replying to Chris.Mann:
avatar
By bidefordjon
08th Sep 2014 15:56

Thanks John

Did that but still comes back with the same message.

Thanks (0)
avatar
By johndon68
08th Sep 2014 16:02

Layouts

Does the same apply if you use a different statement layout?

John

Thanks (0)
Replying to davidwinch:
avatar
By bidefordjon
08th Sep 2014 16:10

Unfortunately yes

Thanks (0)
Replying to davidwinch:
avatar
By bidefordjon
08th Sep 2014 16:20

I just tried deleting all filters and running statements for all customers as without the <>0.00 filter I would expect one for each.

Out of 986 customers I only got 83 statements......................grrrrrrrr!!

Thanks (0)
avatar
By johndon68
08th Sep 2014 16:52

Statements

There should be a series of layouts starting either 2008 or 2009, if you edit one of those and remove the filter (if it is there) do they work?

John

 

Thanks (0)
avatar
By bidefordjon
08th Sep 2014 17:05

Aha!!  Now we're talking, if

Aha!!  Now we're talking, if I remove the bit about letter type 4 from the 2008 statement filter it works.

How frustrating!

Still don't understand why the others won't work but this one does.

Thanks John.  You am the man!!

Thanks (0)
Replying to DJKL:
avatar
By johndon68
08th Sep 2014 17:14

Layouts

bidefordjon wrote:

Still don't understand why the others won't work but this one does.

Thanks John.  You am the man!!

You are welcome :)

The 2008 layouts have fewer joins between tables and not only solve this problem but should also run faster as a bonus...

John

 

Thanks (0)
avatar
By beckyb
04th Aug 2015 22:29

By removing the filter, the statement now doubles all of the invoice totals. 

Thanks (0)