Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Field's Value Iden...
Small and medium business | Business Central, N...
Suggested answer

Field's Value Identification and History Tracking

(0) ShareShare
ReportReport
Posted on by M Saravanan 138

Hi Members,

I would request you to provide me a solution to the problem that I am currently facing.

First, I am trying to link purchase line table and Reservation table, by using query who's outcome is success. I have two fields namely Reserved For and Reserved From who's value is displayed, but it's source remains hidden ( Which I am not able to find out ). Please suggest me a way to bring the data for the Reserved For and Reserved From field.

Secondly, In the sales order page once posted, the order will move to posted sales invoice and in the source table it would be deleted. I would like to know where the deleted detail would be stored so that I can track the history of the Sales Order ( Even after it get's deleted ). Please suggest me a solution for this.

Thanks and Regards,

Saravanan M

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 993 Super User 2024 Season 1 on at
    RE: Field's Value Identification and History Tracking

    Here you can see the different source types you can have for your reservations.

    case "Source Type" of
                DATABASE::"Item Ledger Entry":
                    exit("Reservation Summary Type"::"Item Ledger Entry".AsInteger());
                DATABASE::"Purchase Line":
                    exit("Reservation Summary Type"::"Purchase Quote".AsInteger() + "Source Subtype");
                DATABASE::"Requisition Line":
                    exit("Reservation Summary Type"::"Requisition Line".AsInteger());
                DATABASE::"Sales Line":
                    exit("Reservation Summary Type"::"Sales Quote".AsInteger() + "Source Subtype");
                DATABASE::"Item Journal Line":
                    exit("Reservation Summary Type"::"Item Journal Purchase".AsInteger() + "Source Subtype");
                DATABASE::"Job Journal Line":
                    exit("Reservation Summary Type"::"Job Journal Usage".AsInteger() + "Source Subtype");
                DATABASE::"Prod. Order Line":
                    exit("Reservation Summary Type"::"Simulated Production Order".AsInteger() + "Source Subtype");
                DATABASE::"Prod. Order Component":
                    exit("Reservation Summary Type"::"Simulated Prod. Order Comp.".AsInteger() + "Source Subtype");
                DATABASE::"Transfer Line":
                    exit("Reservation Summary Type"::"Transfer Shipment".AsInteger() + "Source Subtype");
                DATABASE::"Service Line":
                    exit("Reservation Summary Type"::"Service Order".AsInteger());
                DATABASE::"Assembly Header":
                    exit("Reservation Summary Type"::"Assembly Quote Header".AsInteger() + "Source Subtype");
                DATABASE::"Assembly Line":
                    exit("Reservation Summary Type"::"Assembly Quote Line".AsInteger() + "Source Subtype");
                DATABASE::"Invt. Document Line":
                    exit("Reservation Summary Type"::"Inventory Receipt".AsInteger() + "Source Subtype");
                else
                    exit(0);
            end;
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 993 Super User 2024 Season 1 on at
    RE: Field's Value Identification and History Tracking

    For your second requirement you should use the document archiving as documented here:

    docs.microsoft.com/.../across-how-to-archive-documents

    Then you can save different version of your documents and track how a sales order was changed until it got posted.  For your case i think that is way better than the change log.

    When it comes to reservation the two fields you mention are kind of context sensitive so the data there will variate depending on what data you are looking from where.

    In general reserved from will be an existing or planned incoming inventory transaction. Reserved for will be an existing or planned outgoing inventory transaction.  If you warehouse operations is not very complex most of your reserved for will be a sales order and reserved from will either be a item ledger entry or a purchase order,

    Can you tell me the exact table numbers / names you want your query to run on? There are different tables involved in the reservations.

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: Field's Value Identification and History Tracking

    Hi,

    As per my understanding, pls use change log functionality for this. In this functionality you will track data of each field.

    Regards

    Amit Sharma

    www.erpconsultors.com

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans