Posting
                
                    RS8                
                
                    Member Posts: 121                
            
                        
            
                    Hi,
While Posting the Sales Ord, the Customer Ledger entry table gets updated, now i want new field values to be updated in that table, can anyone say the exact object which is used for updation of values in Customer ledger entry table. I want to insert few values into it. :?:
                While Posting the Sales Ord, the Customer Ledger entry table gets updated, now i want new field values to be updated in that table, can anyone say the exact object which is used for updation of values in Customer ledger entry table. I want to insert few values into it. :?:
0                
            Comments
- 
            Post a sales order with the client monitor running, and you can see where the table gets inserted/updated.0
 - 
            Codeunit 12 "Gen. Jnl.-Post Line"
You will need to add your new fields to the journal line that is created in CU 80 and passed to Cu 12There are no bugs - only undocumented features.0 - 
            Create the custom fields that you require in both "Gen. Journal Line" and "Cust. Ledger Entry" and use codeunit 10201 (Transfer Custom Fields), function GenJnlLineTOCustLedgEntry to write your code to transfer values.
eg. CustLedgEntry."Custom Field" := GenJnlLine."Custom Field";
This makes the code much easier to maintain and also makes it much easier to apply any patches/updates/upgrades.0 - 
            I have created fields, but i cant able to find CU 10201, is that right? where al places i have to update code. i have done in CU 80, 12, 226. But its not updating in Cust. Ledger entry.0
 - 
            CU 10201 I believe is just in the NA version. You'll have to follow the other suggestions.0
 - 
            Oh? I wasn't aware that it was only available in the NA version. Hmm...I wonder why? It's a really simple codeunit. You just have to make sure that the calls to it are placed in the appropriate places (eg. in codeunit 12 the call is made in the PostCust function and the syntax is "XferCustomFields.GenJnlLineTOCustLedgEntry(GenJnlLine,CustLedgEntry);").0
 - 
            CU 10201 is not available in our version. can i have that code to make a customize codeunit and put the code on it.hmmm wh :-k at will be the reason why it's just available in NA version?Sendoh
be smart before being a clever.0 - 
            Because it's part of the US localization, and it hasn't made it into the W1 version. It is REALLY nice to have though, a VERY good way to implement transfering custom fields between journals and ledgers, without touching the actual posting codeunits.
If you want to know how it works, download the NA version from partnersource and check out that codeunit, and see how it is called in posting routines. It would be fairly straightforward to implement something similar in your own system or for customers that are not on the US localization.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
 - 323 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
 
