D365FFO - Salvare un file excel nel print archive

 Questo post è interessante perchè mostra come salvare un file nel print archive:

https://www.linkedin.com/pulse/excel-reports-d365-finance-operations-sohan-prasad-kanti/

Possiamo usare questa logica per scrivere una classe (anche batch) per generare un file excel ed effettuare il salvataggio nel print archive:

 private void LIL_GenerateFileAndSaveToPrintArchive()  
 {  
   SalesTable salesTable;  
   
   System.IO.Stream workbookStream = new System.IO.MemoryStream();  
   System.IO.MemoryStream memoryStream = new System.IO.MemoryStream();  
       
   using(var package = new OfficeOpenXml.ExcelPackage(memoryStream))  
   {  
     var worksheets = package.get_Workbook().get_Worksheets();  
     var worksheet = worksheets.Add("Sheet1");  
     var cells = worksheet.get_Cells();  
         
     var currentRow=1 ;  
   
     var cell = cells.get_Item(currentRow,1);  
     cell.set_Value("SalesId");  
   
     while select firstonly10 salesTable  
     {  
       currentRow++;  
       cell= cells.get_Item(currentRow, 1);  
       cell.set_Value(salesTable.SalesId);  
     }  
   
     package.Save();  
   }  
   
   memoryStream.Seek(0,System.IO.SeekOrigin::Begin);  
   
   //salvataggio nel print archive  
   SRSPrintArchiveContract printArchiveContract;  
   
   printArchiveContract = SRSPrintArchiveContract::construct();  
   printArchiveContract.parmExecutionDate(DateTimeUtil::getSystemDate(DateTimeUtil::getUserPreferredTimeZone()));  
   printArchiveContract.parmExecutionTime(DateTimeUtil::getTimeNow(DateTimeUtil::getUserPreferredTimeZone()));  
   printArchiveContract.parmFileName("test.xlsx");  
   printArchiveContract.parmJobDescription("test 01");  
   printArchiveContract.savePrintArchiveDetails(Binary::constructFromMemoryStream(memoryStream).getContainer());  
 }  

AX2012 - D365: remittance address transaction line does not match the remittance address on the payment journal line. TRICKY MESSAGE EASY SOLUTION

In Microsoft Dynamics AX2012 (or in case D365 Dynamics 365 for Finance) , in settlement payment sometime we face to this message (full text): 

"The remittance address on the selected transaction line does not match the remittance address on the selected payment journal line. Change one of the addresses to mark the lines for settlement. Error message while marking transactions for settlement."

 

The message seems high-sounding ! 

Checking in deep transactions data, the main couse is the missmatch between address on the LedgerJounralTrans vs VendTransOpen. It is related to data inheritance. Below the issue loop: 

I) Create a General Journal ; 

II) Add a Vendor/ supplier; 

III) Use the function settlement 

IV) Try to mark a settle open transaction: 

 -> get the error

SOLUTION: To be align the data. The Address / Location between General Journal need to be the same to Open Settlement transaction. 

 Area of focus: We need to includ/add the field "Remittance location" into the form. Using the same address location, we are able to select /mark the transaction.

TECH Details: 

Form:VendOpenTrans 

Table: VendTransOpen 

Form:LedgerJournalTransDaily 

Table: LedgerJournalTrans 

LabelID: @SYS152832 

Field: VendTrans.RemittanceLocation; 

Class: CustVendOpenTransManager - Method: checkRemittanceTransCanBeMarked

Comment: We can face to this issue in Microsoft Dynamics 365 Finance too. 

Enjoy!

AX 2012 - Associare un contatto ad un indirizzo

Con questo job possiamo associare un contatto ad un qualsiasi indirizzo:

static void LIL_CreateAddressContact(Args _args)  
{  
    DirPartyContactInfoView          dirPartyContactInfoView;  
    LogisticsContactInfoView         logisticsContactInfoView;  
    LogisticsElectronicAddress       logisticsElectronicAddress;  
    dirPartypostalAddressView        dirPartypostalAddressView;  
    logisticsLocation                logisticsLocation;  
    CustTable              custTable;  
   
    //identificare l'indirizzo a cui associare il contatto  
    select firstOnly dirPartypostalAddressView  
        join CustTable  
        where CustTable.Party == dirPartypostalAddressView.Party  
        && CustTable.AccountNum == "US-002"  
        && dirPartypostalAddressView.LocationName == "TEST03"  
        && dirpartypostalAddressView.ValidFrom <= DateTimeUtil::utcNow()  
        && dirpartypostalAddressView.ValidTo >= DateTimeUtil::utcNow();  
    
    if(dirPartypostalAddressView)  
    {  
        select firstOnly logisticsLocation  
        where logisticsLocation.ParentLocation == dirPartypostalAddressView.Location;  
       
        if(!logisticsLocation)
        {
            logisticsLocation.clear();
            logisticsLocation.initValue();
            logisticsLocation.ParentLocation = LogisticsLocation::find (dirPartypostalAddressView.Location).RecId;
            logisticsLocation.IsPostalAddress = NoYes::No;

            logisticsLocation.insert();
        }
   
        dirPartyContactInfoView.LocationName  = "contatto mail";  
        dirPartyContactInfoView.Locator     = "somarisuax@mail.com";  
        dirPartyContactInfoView.Type      = LogisticsElectronicAddressMethodType::Email;  
        dirPartyContactInfoView.IsPrimary    = NoYes::No;  
        dirPartyContactInfoView.Location    = logisticsLocation.RecId;  
   
        logisticsElectronicAddress.initValue();  
        logisticsContactInfoView.initFromPartyContactInfoView(dirPartyContactInfoView);  
        logisticsElectronicAddress = LogisticsElectronicAddressEntity::initFromLogisticsContactInfoView(logisticsContactInfoView, logisticsElectronicAddress);  
   
        if (logisticsElectronicAddress.validateWrite())  
        {  
            logisticsElectronicAddress.insert();  
   
            info("Contatto creato!");  
        }  
    }  
    else  
    {  
        warning("Indirizzo non trovato!");  
    }  
}  

il risultato sarà il seguente:

AX 2012 - Minefield game

In questo post ho provato a riscrivere il gioco "mine field" presente su windows usando l' X++.

L'idea è nata dalla possibilità di poter costruire una form dinamicamente gestendo gli eventi.

Mi sono basato sull'idea di questo post:

https://somarisuax.blogspot.com/2024/04/ax-2012-d365ffo-aggiungere-controlli-ad.html

e di questo per la gestione delle matrici:

https://somarisuax.blogspot.com/2021/01/ax-2012-matrici.html

"L'esperimento" (che lascia il tempo che trova.. :) ) può essere interessante perchè mostra come poter costruire tutto il design via codice.

Il risultato è il seguente:

L'xpo della form da importare può essere scaricato da quì:

https://drive.google.com/file/d/1BhoToxtStJH6TkGR6rbgVus90zJ49mAr/view?usp=sharing

AX 2012 - Lettura file di un certificato e stampa proprietà

 Questo semplice job mostra come leggere un file di un certificato e stampare le varie proprietà:

 static void LIL_CertificateInfo(Args _args)  
 {  
   int                               version;  
   utcDateTime                           NotBefore,NotAfter;  
   System.Security.Cryptography.X509Certificates.X509Certificate2 cert;  
   System.Security.Cryptography.X509Certificates.PublicKey     publicKey;  
   System.Security.Cryptography.Oid                oid;  
   System.Security.Cryptography.AsnEncodedData           asnEncodeddata;  
   System.Security.Cryptography.AsymmetricAlgorithm        AsymmetricAlgorithm;  
   
   cert = new System.Security.Cryptography.X509Certificates.X509Certificate2(System.IO.File::ReadAllBytes(@'C:\Temp\bob.crt'));  
        
   //oppure   
   //cert = new System.Security.Cryptography.X509Certificates.X509Certificate2();  
   //cert.Import(@'C:\Temp\myCert.pfx', 'password', System.Security.Cryptography.X509Certificates.X509KeyStorageFlags::DefaultKeySet);  
   
   version       = cert.get_Version();  
   NotBefore      = cert.get_NotBefore();  
   NotAfter      = cert.get_NotAfter();  
   publicKey      = cert.get_PublicKey();  
   oid         = publicKey.get_Oid();  
   asnEncodeddata   = publicKey.get_EncodedKeyValue();  
   AsymmetricAlgorithm = publicKey.get_Key();  
   
   info(cert.get_Subject());  
   info(cert.get_Issuer());  
   info(strFmt("%1",version));  
   info(strfmt("%1",NotBefore));  
   info(strfmt("%1",NotAfter));  
   info(cert.get_Thumbprint());  
   info(cert.get_SerialNumber());  
   info(oid.get_FriendlyName());  
   info(asnEncodeddata.Format(true));  
   info(cert.ToString(true));  
   info(AsymmetricAlgorithm.ToXmlString(false));  
 }  

How to check/add Cust/Vend Journal transactions to Sales Tax (Italy) report

In AX2012 and D365 there is a specific Italian report "Sales Tax (Italy) report" named "Libro IVA", it contain all transactions about VAT/Sales tax.

By my point of view, an helpful checkpoint, is to veify for each Sales Tax transactions the Posting-parameters.
I'm meaning: Purchase->Invoice Journals; Sales ledger-> Payment Journal and others.
In case we are facing to some transations missing in SalesTax (Italy) Report, the first check is to verify these TaxTrans data:

mandatory fields

The fields are: TaxTrans. TaxBook and TaxTrans.TaxBookSection.
These fields create the link between transactions and Tax Report.

table fields

Report Example

AX 2012 - Fixed default dimension

 Con questo job possiamo ottenere i valori "fixed" sulla default dimension di un conto:

 static void GetFixedDefaultDimension(Args _args)  
 {  
   Map           map;  
   MainAccountLegalEntity MainAccountLegalEntity;  
   MainAccount       mainAccount;  
   MapEnumerator      enumerator;  
   DimensionStorageSegment DimensionStorageSegment;  
   DimensionAttribute   DimensionAttribute;  
   CompanyInfo       companyInfo;  
     
   companyInfo = CompanyInfo::find();  
     
   select firstOnly MainAccountLegalEntity  
     join mainAccount  
     where mainAccount.RecId == MainAccountLegalEntity.MainAccount  
     && mainAccount.MainAccountId == "200100"  
     && MainAccountLegalEntity.LegalEntity == companyInfo.RecId;  
     
   map = DimensionDefaultingService::getFixedDimensionsForMainAccount(MainAccountLegalEntity.MainAccount,MainAccountLegalEntity.LegalEntity);  
     
   enumerator = Map.getEnumerator();  
     
   while (enumerator.moveNext())  
   {  
     DimensionStorageSegment = enumerator.currentValue();    
     DimensionAttribute = DimensionAttribute::find(enumerator.currentKey());  
       
     info(strFmt("%1:%2 -- %3",DimensionAttribute.Name  
                  ,DimensionStorageSegment.parmDisplayValue()  
                  ,DimensionStorageSegment.getName()));  
   }  
 }