Microsoft Dynamics NAV (Archived)

Problem of capturing data from other Page ID

(0) Share

Report

Posted on by Jade Ng

215

Hi everyone,

Can anyone give me some suggestions on how to capture the data from other document type such as from other page ID?

My condition now is ^Source Name column in Item Ledger Entries are captured directly from the Customer Card/Vendor card. But now my problem is how can I change the data from customer card/vendor card to other document type such as (capture the data (Sell-to customer name) Column from Sales Return Receipt? Remark: the Sales Return Receipt is from other page ID. I want to based on below page ID to captured the data.(Picture 1) to replace the data in the Customer/vendor card

See the picture below for reference:

Picture 1: Document type that want to replace the customer card/vendor card's data

6327.Capture5.PNG

Picture 2: Expected outcome that I wish to have

6327.Capture6.PNG

The picture 2 is the expected outcome, which already change the customer/vendor card to other document type which I had screenshot above.

Here is the original code i have:

6327.Capture3.PNG

The source type is all based on customer and vendor. But I don't know how to capture the data from other document type in order to replace the data from the customer/vendor card.

Can anyone guide me on the above issues?

Thanks.

*This post is locked for comments

All responses (4)

Answers (2)

Jade Ng 215 on at

Like (0)

Report

RE: Problem of capturing data from other Page ID

Hi,

I just want to make double confirm about the below document type, and I want to capture the data which is Order No.

Purchase Return Shipment : Check Document Type is "Purchase Return Shipment" and then Get from table Purchase Return Shipment , linked by Document No.

Purchase Receipt : Check Document Type is "Purchase Receipt" and then Get from table Purch. Rcpt. Header, linked by Document No

Sales Shipment : Check Document Type is "Sales Shipment" and then Get from table Sales Shipment Header, linked by Document No

Sales Return Receipt : Check Document Type is "Sales Return Receipt" and then Get from table Return Receipt Header, linked by Document No

But I have faced one issue which is is it the order no is same as return order no? Since for Purchase Return Receipt and Sales Return Receipt, I cannot find Order No in the table, only have Return Order No

Hope anyone can help me about this.

Many Thanks Here.
Verified answer

I Gusti Made Ari 3,594 on at

Like (0)

Report

RE: Problem of capturing data from other Page ID

Yes , also by Document No.
Jade Ng 215 on at

Like (0)

Report

RE: Problem of capturing data from other Page ID

Hi,

Thanks for reply.

I had solve the above document types as mentioned above.

Between one more question, is it Purchase invoice, Purchase Receipt and Purchase Credit Memo also linked by document No??

Thanks.
Verified answer

I Gusti Made Ari 3,594 on at

Like (0)

Report

RE: Problem of capturing data from other Page ID

Sales Credit Memo : Check Document Type is "Sales Credit Memo" and then Get from table Sales Cr.Memo Header , linked by Document No.

Sales Invoice : Check Document Type is "Sales Invoice" and then Get from table Sales Invoice Header , linked by Document No.

Sales Return Receipt : Check Document Type is "Sales Return Receipt" and then Get from table Return Receipt Header , linked by Document No.

Sales Shipment : Check Document Type is "Sales Shipment" and then Get from table Sales Shipment Header , linked by Document No.