Flowing the data from purch inv. line to purch. rcpt. line

(0) Share

Report

Posted on by Sulav Thapaliya

Hello All,

I have added two fields in purch. rcpt. line,purch inv. line,its header tables and other related tables.The added field values are inserted in the purchase order while invoicing only.So,I have to pass that value to their corresponding purch. rcpt. line which has been already posted.I wrote the following code but cannot figure it out where to put it exactly.

PurchRcptLine.SETRANGE("Document No.","Document No.");
IF PurchRcptLine.FINDFIRST THEN BEGIN
ItemLedgEntry.SETRANGE("Document No.",PurchRcptLine."Document No.");
IF ItemLedgEntry.FINDFIRST THEN REPEAT
IF ItemLedgEntry."Document Type" = ItemLedgEntry."Document Type"::"Purchase Receipt" THEN BEGIN
ValueEntry.SETRANGE("Item Ledger Entry No.",ItemLedgEntry."Entry No.");
IF ValueEntry.FINDFIRST THEN BEGIN
IF ValueEntry."Document Type" = ValueEntry."Document Type"::"Purchase Invoice" THEN BEGIN
RcptLinePragyapan := ValueEntry.PragyapanPatra;
RcptLineLC := ValueEntry."Letter of Credit/Telex Trans.";
PurchRcptLine.SETRANGE("Document No.",ValueEntry."Document No.");
IF PurchRcptLine.FINDSET THEN REPEAT
PurchRcptLine.PragyapanPatra := RcptLinePragyapan;
PurchRcptLine."Letter of Credit/Telex Trans." := RcptLineLC;
PurchRcptLine.MODIFY;
UNTIL PurchRcptLine.NEXT = 0;
END;
END;
END;
UNTIL ItemLedgEntry.NEXT = 0;
END;

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (1)

Report
Copy link

Link copied!

Hi,

If you are only calling this when the Invoicing only, then check Codeunit 91 Purch.-Post (Yes/No), function Code(). In there the logic behind Invoicing only is visible.

In Codeunit 90 Purch.-Post, in OnRun() function, the PurchRcptLine is getting in line 806 (Or search with PurchRcptLine.INSERT; in the object).

You can apply your code after this line of code.

Please understand there can be other conflicts with Item Ledger Entries and Value Entries to be solved. Do test well.

Hope it helps.

Was this reply helpful? Yes No
Sulav Thapaliya 12 on at

Like (0)

Report
Copy link

Link copied!

The process is something like this:

Client will first receive the goods where they do not put the values of newly added fields.

At the time of invoicing only they insert the values of those newly added fields and post it.Now,I have to flow that value to their corresponding purch. rcpt. line after invoicing

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Exactly. Codeunit 91, will check whether it is a GRN or Invoice or both. If you follow the trace, after creating the PurchRcptLine, in Codeunit 90, update your fields. Your code seems fine. What is the exact problem are you facing now?

Was this reply helpful? Yes No
Sulav Thapaliya 12 on at

Like (0)

Report
Copy link

Link copied!

I am confused on where to put these code.So, that values will be flowed properly.I tried putting these codes in GetPurchRcptLines() function of purch inv line table.But its not working

Was this reply helpful? Yes No
Verified answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can either put this code when it is Invoicing Only post, which you have to do changes in codeunit 90 and 91 as I explained on my previous replies.

Or, you can put up an Action button on the Page Posted Purchase Receipt (136).

Hope it helps.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 9,158 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Sulav,

As you said, While Invoicing you want some field to get that updated in Purchase Receipt.

Why you want that field to get updated during Invoicing because Ideally it should get updated while receipt only. Now further to your question you said the reason behind this is you get that particular field while Invoicing only so here my question is why dint you get that field during receipt, it is something a loophole in the system or the customization is like this - Pardon me but I am really curious to know this. Now if you are getting that field while Invoicing why you want it to get that updated in Receipt?

If you follow the standard rule and protocols then it's never recommended to update forcefully something on Receipt if you are doing an Invoicing. if you have followed the standard business logic then it was just a 2 minute job for you as you just need to simply put a field in Purchase Header and the same field with the same ID on Receipt and Invoice and you are done. If you get it populated during Order it should have automatically carry forwarded till Invoice posting.

If its something that is supposed to be done only once and it's just a simple field to be updated then too you can go ahed and do but if you are planning it to be handled each and every time the user is doing an Invoice then I am quiet afraid of the code and the Process that you are trying to achieve.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,280 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Sulav,

There are couple of things i want to ask, not sure why you looking at ledger entries to get values, as you mentioned in your post they will enter those values on the order before invoicing and then do invoicing those values will be transferred from order to Invoice.

Regarding where to add your code, what do you want to do if there are multiple receipts for an order, do you want to update all the lines or only the last receipt ?

In Codeunit 90 there is a function called InsertInvoiceOrCreditMemo, after the PurchInvLine.INSERT, Add the code to find all the Receipt Lines for that Order and Line No. and Update the field Values.

Thanks

Suresh

Was this reply helpful? Yes No
Sulav Thapaliya 12 on at

Like (0)

Report
Copy link

Link copied!

The field I have added in all the related tables are "Pragyapanpatra" and "Letter of Credit".

So,When client receive the goods,they are unknown about these values,so they just receive it.They will come to know these values when their physical invoice arrives to them.Now,when they invoice that released order,at that time they put their values and post it.After that,They will create a new order where they apply item charge.While getting the purchase receipt lines,their should be the value of pragyapanpatra and letter of credit from their corresponding invoice line.I have to do that modification.All the lines will have same pragyapan and letter of credit values for the individual header.I can get their values from value entries and assign it to those receipt lines.Only problem is where do I write the code.Hope you have understand the requirement.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

Why not to create flowfield or lookup field in rcptline to display the field or If that data is just for reporting purpose then better to write program on onaftergetrecord of page and display the data using variables.

Was this reply helpful? Yes No