Generate CAR report d365fo

 


Commands 

Cd

C:\ K:

C:\cd K:\AosService\PackagesLocalDirectory\bin


xppbp.exe -metadata=K:\AosService\PackagesLocalDirectory -all -model=EDF -xmlLog=C:\BPCheckLogcd.xml -module=EDF -car=c:\temp\CAReport.xlsx


Comments

Post a Comment

Popular posts from this blog

Get voucher transactions,settlement , and other details from customer , invocie other posted transactions via GJentry and subledger entry

   //From here the code is common for all posted transactions if Project invoice one then we need to join with projinvoicejour instead of vendinvoicejour like this way GeneralJournalAccountEntry accEntry; SubledgerVoucherGeneralJournalEntry subGjEntry ;  LedgerDimensionPreviewTmp   ledgerDimensionPreviewTmpLocal; while select maxof(GeneralJournalEntry) from  subGjEntry                         where subGjEntry.AccountingDate == vendInvoiceJour.InvoiceDate                         &&     subGjEntry.Voucher ==  vendInvoiceJour.LedgerVoucher                          join sum(TransactionCurrencyAmount),LedgerDimension,maxof(Text),maxof(IsCredit) from   accEntry group by accEntry.LedgerDimension                         where accEntry.GeneralJournalEntry  == subGjEntry.GeneralJournalEntry                         &&  accEntry.PostingType != LedgerPostingType::VendBalance                         &&  accEntry.PostingType != LedgerPostingType::InterunitCredit              
Read more

Logistics address, postal address, address phone fax contact information

// Find primary address by roles  LogisticsPostalAddress postalAddr;  postalAddr = DirParty::findPostalAddressByRole(DirPartyTable::find(companyInfo::find().PartyNumber).RecId,LogisticsLocationRoleType::Invoice); Get Description/ name of location LogisticsLocation::find(postalAddrInvoice.Location).Description // Find contact information (Generic one) DirPartyContactInfoView contactInfoView; contactInfoView = DirPartyContactInfoView::find(partyRecId, _location); // Find primary address by roles regardless primary or not public  LogisticsPostalAddress getPostalAddressByType(DirPartyRecId _party, LogisticsLocationRoleType _type)     {         DirPartyLocation        partyLocation;         DirPartyLocationRole    partyLocationRole;         LogisticsLocation       location;         LogisticsLocationRole   locationRole;         LogisticsPostalAddress  postalAddress;         select firstonly postalAddress         exists join location             where location.RecId == postalAddress.Location
Read more

Cheque report changes our custom design, ACH , NACHA classes, And file name changes with DateTime

// Cheque Controller   [ExtensionOf(Classstr(ChequeController))] Final class CMCChequeController1_Extension {     protected str determineReportMenuOutput(ChequeFormType _chequeFormType, BankChequeLayout _bankChequeLayout)     {         SrsCatalogItemName chequeReport = next determineReportMenuOutput( _chequeFormType, _bankChequeLayout);         if (chequeReport && _chequeFormType == ChequeFormType::USStyle)         {             chequeReport = ssrsReportStr(CMCCheque_US, Report);         }         return chequeReport;     } } // Cheque DP [ExtensionOf(Classstr(ChequeDP))] final class CMCChequeDP_Extension {     protected void populateChequeTmp()     {         next populateChequeTmp();         chequeTmp.DateStr    = date2str(tmpChequePrintout.MaturityDate, 213, DateDay::Digits2,             DateSeparator::Slash, // separator1         DateMonth::Digits2,         DateSeparator::Slash, // separator2         DateYear::Digits4);     } } // Cheque text calculator to change cheque stub
Read more