Retrieving and updating Lot ID from PowerApps to Dynamics365 Finance and Operations
I am working on a canvas application for creating Quotation headers and lines in D365 F&O. Currently I am using forms to update the records via Data Cards in PA that correspond to the relevant fields in D365.
I am facing one issue. Upon creating Sales Quotation lines the form requires a "LotID" to create the line. Normally, in D365, you first create a line and then that line is given a LotID automatically by the system. In this case it is reverse, as it requires the LotID before creating the line.
Question; How do I update the LotID automatically via PowerApps? I am able to access the Sales Quotation number sequence through the SequenceTable and can therefore automatically suggest the next viable Quotation number for the header - I can not find a D365 table to do a similar fetch and update of LotID.