Posts

Sales Order and Purchase Order Tables and Classes

SalesOrder Classes and Tables: SalesTableType  and  SaleslineType  classes will get called while  creating the SalesOrders . SalesFormLetter_Confirm SalesFormLetter_Invoice SalesFormLetter_PackingSlip SalesFormLetter_PickingLlst classes will be used to post the sales order at various document status ( packing, invoice  etc). Tables: SalesTable  contains all SalesOrder headers regardless whether they have been  posted  or not. The  SalesParmTable  and  SalesParmLine  contains detailed information regarding posting sales headers and Lines. CustConfirmJour  and  CustConfirmTrans  tables contains all Sales  Confirmation  headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines. CustPackingSlipJour  and  CustPackingSlipTrans  tables   contains   all sales  PackingSlip  headers and Lines posted in Dynamic Ax originating from Sales Orders and Lines. Cust...

Export a copy of the standard user acceptance testing (UAT) database

 https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/dbmovement-scenario-exportuat

DYNAMICS 365 FOR FINANCE AND OPERATIONS: HOW TO CUSTOMIZE THE STANDARD EXCEL TEMPLATE

 https://www.alithya.com/en/insights/blog-posts/dynamics-365-for-finance-and-operations-customize-the-standard-excel-template

Create ledger journals in D365FO using X++ + LedgerDimensionACType

 internal final class HCL_LedgerJournalImportCSV extends RunBaseBatch {     private str         availableTypes = ".csv";     //In the class Declaration control names for OK and upload control     private const str   OkButtonName = 'OkButton';     private const str   FileUploadName = 'FileUpload';     Dialog              dialog;     str                 textFile;     QueryRun            gQueryRun;     HCL_tempLedgerJournalTransForImport tempLedgerJournalTransForImport;     #define.CurrentVersion(3)     public Object dialog()     {         DialogGroup      dialogGroup;         FormBuildControl formBuildControl;         FileUploadBuild  dialogFile...

Create Ledger Dimension for Legder journal Trans line in D365 using X++

To create a General journal header and Line using excel/CSV file(It was a client requirement , instead of using DMF). internal final class CSVLedgerJournalImportCSV extends RunBaseBatch {     private str         availableTypes = ".csv";     //In the class Declaration control names for OK and upload control     private const str   OkButtonName = 'OkButton';     private const str   FileUploadName = 'FileUpload';     Dialog              dialog;     str                 textFile;     QueryRun            gQueryRun;     HCL_tempLedgerJournalTransForImport tempLedgerJournalTransForImport;     #define.CurrentVersion(3)     public Object dialog()     {         DialogGroup      dialogGroup;   ...