Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
customer statements
zacin_c
Member Posts: 9
Dear all
I'm having problems getting customer (debtor) statements to print properly (I print them via recievables > reports > statement).
Two things are happening which I do not know how to change:
1. Customer statements with no balance are printing off; by this I mean just the address details with nothing else (the 'include al customers with a balance' option is checked on);
2. If a client has unallocated credit notes or payments on their ledger, these do not show. So if I see a balance of £70,000 which includes a a £10,000 unallocated payment, the £10K won't show on the statement - the statement will print with a total balance of £80,000.
Assistance would be much appreciated!
I'm having problems getting customer (debtor) statements to print properly (I print them via recievables > reports > statement).
Two things are happening which I do not know how to change:
1. Customer statements with no balance are printing off; by this I mean just the address details with nothing else (the 'include al customers with a balance' option is checked on);
2. If a client has unallocated credit notes or payments on their ledger, these do not show. So if I see a balance of £70,000 which includes a a £10,000 unallocated payment, the £10K won't show on the statement - the statement will print with a total balance of £80,000.
Assistance would be much appreciated!
0
Comments
What version are you running?
Is this report modified? Or is it report 116 unmodified?
In 4 (?) you have a selection to include unappliec entries, is this selected?
On the blank customers do they have unapplied entries or open entries? Is the balnce really 0 at the end of the period?
Errr not sure what you mean by '...report modified' and 'report 116' (sorry, still trying to familiarse myself with Navision!).
On blank customers - it transpires that there are actually balances on those accounts.
However all that appears on the statement is the client address, and the column headers under which the figures would be (date, our ref, your ref, amount, etc) then there is just nothing underneath.
About the 'unapplied entries' - there is no option for this where I'm looking...
](*,)
Modified means has any changes been made to the report to fit your company better.
Easiest way is to go to Tools->Object designer->Reports
Scroll around until you find your report. On the right there are some version columns and also a modified column. Does it have a checked box?
What he's asking by this, if I may guess, is take a look at your printed report. Pick a customer that you think should not be on the report. go to the customer card. drill in the balance and see if any of the entries are 'OPEN'
Also be aware of your dates here. If you pick Jan 31 and the payments n such are posted with a date after then - it will not show beacuse you asked for it that way with your date choice.
http://www.BiloBeauty.com
http://www.autismspeaks.org
On the options tab beneath the tick box for "include all customers with a balance" you have another called "Include unapplied entries". I am running a 5 client and I cannot tell you when this tick box came in!
Also when you press the print of the report it brings up your filter, if you then select tools and designer it will tell you the report name and number. If you then go to Tools and Object designer you can find this report (if it is 116) and look at the version (assuming if a modification has been done this has been altered).
Most statement reports in the UK I know are re-written to meet the needs of the business, it just depends to what extent yours has been re-written!
Report 116 is in receivables > documents > customer statement (statement printed from here is beyond comprehension, I think whoever tried modifying this must've been on crack).
Statements we use are in receivables > reports > statement.
Upon checking in the object designer folder, it transpires that we're using report 50006, and a "new" version, 50032, has appeared for statements. At a guess, it looks like these have been specifically created (and not very well) for us.
Which would probably explain why there's no "include applied entries" option.
Re: the dates, I remain baffled as to what it's trying to do. I'm printing statements as at 31.01, yet it would seem that it's these clients whose statements are appearing as blank.
Is it safe to assume that whoever messed around with this, did exactly this - messed it up?
http://www.BiloBeauty.com
http://www.autismspeaks.org
I clicked on the 'design' button, but all I get is a table of some sort... is there a way of bringing up the template and shifting all the fields around physically?
Also best to design on a test database, test it then apply to live, in this way you do not get issues with the objects in live as you currently have.