Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 305 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
there is no customer ledger entry within the filter
mpeguk
Member Posts: 17
Hello
Would anybody be able to help me out here...Nav 2009 R2 Version 6.0 R2 (6.00.33597)
Prepayment sales order fully shipped but not a sausage can I post the invoice...the error
"There is no customer ledger entry within the filter.
Filter Document No.: IN_0012247, Customer No.:222537, Document Type: Invoice Open: Yes"
I'm not a dev...but any advice would be very much appreciated.
cheers
Mike
Would anybody be able to help me out here...Nav 2009 R2 Version 6.0 R2 (6.00.33597)
Prepayment sales order fully shipped but not a sausage can I post the invoice...the error
"There is no customer ledger entry within the filter.
Filter Document No.: IN_0012247, Customer No.:222537, Document Type: Invoice Open: Yes"
I'm not a dev...but any advice would be very much appreciated.
cheers
Mike
0
Comments
Question: Do you have the "Apply-to Document No." field filled with this no. ?
with best regards
Jens
No, the "applies-to..." field is blank, when I click the drop down it takes me to a the purchase receipt for this item.
Should I try selecting this...then posting the invoices again?
Regards
Mike
Jens I tried to post this, but it came back with the same error.
I see there are fixes for this but they are for the old versions...:-(
Regards
Mike
this seems to be a different problem. The "Applies-to Document No." field should be blank. With prepayment, at least part of the amount should be already paid and applied to the prepayment invoice. Looks a like this has gone wrong somehow... I tried this in a test database and got some other disturbing result, but not your error:
- created a sales order, prepayment 100%
- posted the prepayment invoice
- shipped the order... shouldn't be possible, the prepayment isn't registered as paid
- posted the invoice - posted ok, too, cleared against the prepayment invoice... that's ok, but why is there no check that the prepayment invoice actually has been paid?
Time for some documentation reading I guess... :-k
But wait a second...
Purchase receipt? Doesn't sound like the right field. It should be in the Sales Header. But I'm afraid I can't really help... best would be to contact your NAV partner, or an inhouse developer to have a look.
with best regards
Jens
Thanks for your assistance...the problem does not appear on every sales order, it is very intermittent - think the user could be doing some process that causes it but I don't know what.
Back to the drawing board :-)