Skip to main content

Notifications

Microsoft Dynamics NAV forum
Answered

Problem of capturing data from other Page ID

Posted on by 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.

  • Jade Ng Profile Picture
    Jade Ng 215 on at
    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 Profile Picture
    I Gusti Made Ari 3,590 on at
    RE: Problem of capturing data from other Page ID

    Yes , also by Document No.

  • Jade Ng Profile Picture
    Jade Ng 215 on at
    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 Profile Picture
    I Gusti Made Ari 3,590 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans