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 / 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 158

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 997 Moderator 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 997 Moderator 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,027 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans