Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Problem of capturing data from other Page ID

(0) ShareShare
ReportReport
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.

*This post is locked for comments

  • 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,594 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,594 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans