How to carry value from a field in purchase order to item ledger entry in NAV 2017 at blogs.anandnavconsultant.com

Requirement :-

Today I had a requirement to update Item ledger entry from Purchase header. To complete this requirement we need to understand the flow of header to ILE.

For Reference :-

So the above screen shows a basic architecture of flow from Purchase Header To ILE in NAV 2017.

Step 1.

(a.)

Add a field in Table 38 Purchase Header with a unique ID that must be used in whole process.

(b.)

Then Add a Field in Item Jnl Line. Accordingly Add it in Purchase Header Page also.

(c.)

Add the same field in ILE also.

For Reference see the screen,

In all I had added Field Narration Test on Id 50000 to all the tables required.

Step 2. Now add code to Table 83 thats all you dont need to code in Codeunit 90 for data flow.

Step 3. Now add the code in codeunit 22 for posting in ILE.

Step4. Now just run the Purchase invoice or Purchase Order Process,you will get your desired result in ILE.

Thanks.

I hope this blog will help you to upgrade your skills in NAV if you like it then please share and subscribe our blog to get our latest post notification .

You can also check these websites.

Goto this Blog

How to add a field in Purchase Header and flow it in G/L Entry in NAV 2017?

To Flow a Field in NAV 2017 Purchase Header - > GL Entry

Flow is From

Purchase Header ---------------> Gen. Jnl. Line ------------------> GL Entry

In the below Eg. I had added a Narration Field on Header and Flow in To GL Entry.

Step 1. Add your Field on Purchase header , G/L ENTRY and Gen. Journal Lines table. as shown in figure also please Check all the fields added must have a same Id.

Step 2. Add your code to Gen Journal Table 81 inside Function CopyFromPurchaseHeader.

Step 3. Add your code to G/L Entry table 17 inside Function CopyFromGnlJnlLine.
Step 4.Add your Code to Codeunit 90 inside Function InsertICGnlJnlLine



Post your Purchase Order.

Your Result is shown below :-

Please Note :- This Field is Valid in NAV 2017 only due to function changes although the method is same in previous version also.

I had used Demo DB so Please be aware about your Database. I hope this will be fruitful for all my juniors in Nav. Keep in touch and subscribe via Email below so our team will intimate you once we get our next Post.

You can also Download these objects From Here :- Click Here