web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Problem of capturing d...
Microsoft Dynamics NAV (Archived)

Problem of capturing data from other Page ID

(0) ShareShare
ReportReport
Posted on by Jade Ng 261

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

I have the same question (0)
  • Verified answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,600 on at

    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.

  • Jade Ng Profile Picture
    Jade Ng 261 on at

    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,600 on at

    Yes , also by Document No.

  • Jade Ng Profile Picture
    Jade Ng 261 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans