Tuesday 9 October 2018

Import WBS lines in request for quotation lines in D365 through X++ code

Recently I have a requirement of importing the work breakdown structure lines on request for quotation lines as per associated project. So for achieving the requirement I have develop a job that can get the WBS lines and import those line on RFQ using AxPurchRFQCaseLine class. Please see below screenshots.

Work break down structure lines which needs to be imported:















Source code of a method which breakdown in three images:

Image 1.1:

Explanation of below source code image:
  • Initialize tables, class and edt buffers.
  • Get RFQ. (Here I have hardcoded RFQ Id)



















Image 1.2:

Explanation of below source code image:
  • Query to iterate smmActivityParentLinkTable table that contains the references to entities which are associated with an activity.
  • Sub query to iterate PSAActivityEstimates table that contains project quotation estimates.
  • Declaration of AxPurchRFQCaseLine class.
  • Set OOTB Parm methods of the class that can handle the given values.
















Image 1.3:

Explanation of below source code image:
  • Save method of AxPurchRFQCaseLine class that inserts the records also runs all the possible validations for request for quotation lines.













Result:


No comments:

Post a Comment

Key Updates in Dynamics 365 F&O for Version 10.0.39

Here’s a concise summary of the  platform updates  in  Microsoft Dynamics 365 Finance & Operations version 10.0.39 (March 2024) : 1- Add...