web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 242

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

I have the same question (0)
  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,037 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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,065 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
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,065 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;

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,267

#2
Sumit Singh Profile Picture

Sumit Singh 2,098

#3
YUN ZHU Profile Picture

YUN ZHU 1,766 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans