G/L Entry Description field

aperfetti
Member Posts: 7
when you post and print a payment journal that has a check in it...the G/L Register report shows the description for the check as "Check for Vendor <XXXX>" where <XXXX> is the vendor number...
we need to replace the vendor number in that description with the vendor name for all future checks posted.
where is the best place to make that modification?
Thanks!
we need to replace the vendor number in that description with the vendor name for all future checks posted.
where is the best place to make that modification?
Thanks!
-Adam
0
Comments
-
-
i wanted to avoid modifing the posting routines for the G/L if possible...i was trying to figure out what other places there are that i could modify to accomplish this...-Adam0
-
Well, if its "only" when you are booking payments to your Vendor you can make change in Codeuint 12 I guess.
Search for the field "description" and make corrections there.
BUT if you for an excample book a Invoice with some invoicelines with same Account and diff. descriptions those descriptions will not appear in the G/L Ledger Entries.
If this dosnt help, please explain more.0 -
If I'm not mistaken the Journal Line description you are referring to is created after you run "Suggest Vendor Payments" summarize by vendor.
You might want to look at the "Suggest Vendor Payment" Report.
for me Report 393.
It might be easier to just add the vendor name to the Register report. If that's where you need it.?
I don't use the "Suggest Vendor Payments" anymore but when I run the G/L Register as you mentioned I do See "Check Payment ******" which is something I manually type in the "Description" field of the payment journal before posting.0 -
If you are going the route of simply changing the G/L Register Report.
Object Designer->Report->G/L Register (for me it's 10019)->Design
View->Sections
In G.L Entry, Body (1) you will see the "Description" Field
Right click on the "Description" field & in the SourceExpr change from
Description to Description+' '+SourceName
This should throw the Source Name (ie/ Vendor, Customer) depending on your report fiters, at the end of the descritpion field.
Note#1 on the options tab you can always select "Included Account Description" which should show you the vendor/customer name.
Note#2 if you want to combine the Description + Source name as described above you will have to slide the amount fields to the right to make enuf space.0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions