Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

Below is a Code to record value in customize field on Sales order packing slip in Axapta. This code is taken form Ax 2012 version but you can try in D365 also. You need to make changes in method of InitHeader of  class SalesPackingSlipJournalCreate . Happy daxing friends. \Classes\SalesPackingSlipJournalCreate\initHeader

Below is a sample code to put filter or range for financial dimension region for any form. If you current form has default dimensions set like region and department and you want to filter only region then this sample code can help you. You need to put in init method of the form.  SysQuery::addDimensionAttributeRange(CustInvoiceJour_ds.query(),                             CustInvoiceJour_ds.name(),                             fieldStr(CustInvoiceJour, DefaultDimension),                             DimensionComponent::DimensionAttribute,                             EmployeeRegion_RangeMST1.GOD_Region,                             '...

If you are looking to create project proposal in ax 2012 by code then you need to insert record in projProposalJour table you can get table columns as below. BOLCarrierName CanceledBy CashDisc CashDiscCode CashDiscDate CostValue CurrencyId CustBankAccountId DefaultDimension DeliveryName DeliveryPostalAddress Description DiscPercent DlvMode DlvTerm DlvTransportBrand_BR DueDate EInvoiceAccountCode EInvoiceLineSpecific EndDisc exchRate ExchrateSecondary FiscalDocumentType_BR FiscalEstablishment_BR FundingSource GiroType InterCompanyPosted IntrastatAddValue_LV IntrastatDispatchId InvoiceAccount InvoiceAmount InvoiceAutoNumbering_LT InvoiceDate InvoiceRoundOff InvoiceType InvoiceType_MY LanguageId LedgerVoucher LineProperty ListCodeId NumberSequenceGroupId OnAccountAmount OrderAccount PaymDayId Payment PaymentSched Port PostingProfile ProjGroupId ProjInvoiceId ProjInvoiceProjId ProposalId PSAEndDate PSAInvoiceFormats PSAInvoiceMet...

To print customized report for Proforma invoice in ax 2012 you can try code in printJournal method in SalesInvoicejournalPrint class. I hope this will help you a lot. \Classes\SalesInvoiceJournalPrint\printJournal

To insert data in customize table during proforma invoice for sales order in axapta you can apply code in run method of FormLetterService class. I hope this small things will help you a lot . \Classes\FormletterService\run

Sometimes you may see some discrepancy in InventSum table for any item then you may need to recalculate inventsum for particular item. You can try below code to do it. static void InventSum_Recalculate(Args _args) { InventSumRecalcItem InventSumRecalcItem; InventTable _InventTable; while select * from _InventTable where _InventTable.ItemId == '61142A' { ttsBegin; InventSumRecalcItem = new InventSumRecalcItem(_InventTable.ItemId, true, checkfix::fix); InventSumRecalcItem.updatenow(); ttsCommit; } info("Done"); } This job will recalculate InventSum for specific item.

KB number Title 3152076 India/IND: Misc. charge does not affect purchase cost as described in the hotfix KB3006787 after applying the hotfix KB3070453 and the hotfix KB3072845 3132063 Brazil/BRA: "528 – Rejection: ICMS amount differs from the Item, Base amount and Tax percentage" error for a direct import NF-e with foreign currency 3118173 United States/USA: 2015 1099 changes for AX 2012 R3 3097024 Full voucher details are not displayed when changing invoice date on a purchase order 3150033 Invoice date defined in the Vendor invoice form in Invoice pool is ignored 3143685 Cannot choose approved transactions only to be included in the Aging report 3153365 Norway/NOR: No field on the sales order line when creating a sales order for the created customer and try to enter information 3165785 SEPA Direct Debit cannot select company bank account 3126123 Belgium/BEL: "AifOutboundProcessingService-processRequest\AifRequestProcessor-processOutbound" error ...