Get Sales Quotation by Customer ID in X++ | Dynamics 365 FO Development

Creating a Sales Quotation using X++ code in Dynamics 365 Finance and Operations involves several steps. Below is an example of how you might achieve this. Please note that you may need to adapt the code to fit your specific requirements and the structure of your solution.
 
Please replace _custAccountId, _currencyCode, _itemId, and _qty with your actual values.
 
AxSalesQuotationTable    AxSalesQttable;
AxSalesQuotationLine     AxSalesQtline;
AxSalesQttable =  new AxSalesQuotationTable();
AxSalesQttable.parmCustAccount(_custAccountId);
AxSalesQttable.parmCurrencyCode(_currencyCode);
AxSalesQttable.save();
 
AxSalesQtline =  new AxSalesQuotationLine();
AxSalesQtline.axSalesQuotationTable(AxSalesQttable);
AxSalesQtline.parmQuotationId(AxSalesQttable.parmQuotationId());
AxSalesQtline.parmItemId(_itemId);
AxSalesQtline.parmSalesQty(_qty);
AxSalesQtline.parmcurrencyCode(_currencyCode);
AxSalesQtline.save();
 

This is a basic example, and you may need to customize it based on your specific requirements. Make sure to replace placeholder values, such as customer account numbers, item numbers, and location IDs, with the appropriate values for your environment. 

Comments

Post a Comment

Popular posts from this blog

Create custom workflow in D365 X++

Image
 For the creation of Custom Workflow in Dynamics 365 F&O, Kindly follow the following steps; 1. Create a custom Enum WorkflowStatus or you can use an existing one.   2. Create a new table EmployeeLeave as defined below and add the above Enum as a field and name it LeaveStatus . 3. Create a new form EmployeeLeaveForm by using the above table as a data source.   4. Create a new Display Menu Item EmployeeLeaveForm for the above form and add to any  Module by creating an extension of the Module Menu from the application Explorer. 5. Create a new Query EmployeeLeaveQuery  and add  EmployeeLeave as a data source.                 6. Create a new Workflow Category EmployeeLeaveCategory .   7. Create a new workflow type EmployeeLeaveWorkflowType .   • Category: Select the workflow category from the previous step • Query: Select the query created for the document table • Document menu item: Sel...
Read more

Convert amount from one currency to another currency using X++

  You can use the following X++ code snippet for currency amount conversion.     CurrencyExchangeHelper currencyExchangeHelper;     AmountMst amountMST;     CurrencyCode FromCurrency =  'PKR';     AmountCur amountCur = 5000;     currencyExchangeHelper = CurrencyExchangeHelper::newExchangeDate(Ledger::current(), systemDateGet());     amountMST =  currencyExchangeHelper.calculateCurrencyToCurrency(fromCurrency, SLDFabCostSheetsCalculation.Currency,amountCur,true);        info(strFmt("%1", amountMST));
Read more

How to Create Extended Data Types (EDTs) in Finance and Operations of Dynamics 365 -- F&O Customization Part 2

Image
For Creating Extended Data Types (EDTs) in Finance and Operations of Dynamics 365 follow the following steps: Step # 1:        Right-click on the project to Add -> New Items as shown in the figure;     When you click the New Item ,  the new window is open as shown in the figure;     Select the Data Types from the Side Bar and click on the Add button as shown in the figure; Step # 2:          Now right click on the EDT and select the Properties as shown in the figure;               When you click the Properties button, the left panel is open, you can set the properties of EDT here,           mostly used properties are Label and Help Test. I have created four EDTs as shown in the figure;           You can check the EDTs in the Application Object Tree ( AOT ) as shown in the figure;          If ...
Read more