Skip to main content

Mark Customer Transaction from X++ in AX2012

Use below code to mark customers open transaction from X++.



static void MarkOpenTransaction()
{
    custInvoiceJour custInvoiceJour;
    SalesTable  salesTable;
    specTrans   specTrans;
    custTrans   custTrans;
    custTransOpen   custTransOpen;
    TaxWithholdTrans    taxWithHoldTrans;
    TaxWithhold_CustPaym taxWithhold;
    CustVendOpenTransManager manager;
    ExchangeRateHelper  exch;
    AmountCur   totalSettleAmount;
    ;
    select firstOnly custInvoiceJour where custInvoiceJour.InvoiceId == '004452';// && _custInvoiceJour.SalesId == xml_SalesID.text();

    if(custInvoiceJour)
    {
        ttsBegin;
        salesTable = salesTable::find('000330');
        specTrans.SpecRecId = salesTable.RecId;

        select * from custTrans where custTrans.AccountNum == '000001' && custTrans.Invoice == custInvoiceJour.InvoiceId;

        select RecId, dataAreaId from custTransOpen where custTransOpen.RefRecId == custTrans.RecId;
        specTrans.RefRecId = custTransOpen.RecId;
        specTrans.RefTableId = tablename2id('CustTransOpen');

        specTrans.SpecTableId = salesTable.TableId;
        specTrans.Balance01 = str2num('-300');//amount
        specTrans.LineNum = 2;
        specTrans.Code = salesTable.CurrencyCode;
        specTrans.SpecCompany = salesTable.dataAreaId;
        specTrans.RefCompany = custTransOpen.dataAreaId;

        specTrans.insert();

        ttsCommit;
       
    }
}


thanks
p.

Comments

Post a Comment

Popular posts from this blog

AX 7 - Get record marked and record selected on grid control in X++

Marked Records In AX, we often face a situation where we need to get the reference of those records which are marked on grid control. Using below code you can get those marked records in X++. Records marked can be seen in screenshot on the left. Array markedRecords = gridControl_DS.recordsMarked(); var lastMarkedRecord = markedRecords.lastIndex(); You will get a recId of last marked record in lastMarkedRecord. Using recordMarked() method of grid control data source, you can get an array of marked records which can be used for further iteration based on requirement. Selected Records At the same time, there is another operation called as Selected Records. When a grid control loads, a default first record is selected from the grid. To iterate through selected records, use below code. for (inv = gridControl_ds.getFirst(true) ? gridControl_ds.getFirst(true) : gridControl_ds.cursor(); inv; inv = gridControl_ds.getnext()) {    //logic here } gridControl_...
Post a Comment
Read more

Call javascript function on sub-grid refresh/load in Microsoft Dynamics CRM

Recently, I came across a requirement where I had to do some calculation based on records added/deleted in sub-grid on CRM form. To achieve this, I have added load event on sub-grid in javascript where I could call the method which is doing the calculations. Below piece of code will be used to add load event on sub-grid and function addEventToGridRefresh() should be registered on form load. function addEventToGridRefresh() { // retrieve the subgrid var grid = Xrm.Page.getControl('#GridControlName#'); // if the subgrid still not available we try again after 2 second if (grid == null) { setTimeout(function () { addEventToGridRefresh(); }, 2000); return; } // add the function to the onRefresh event Xrm.Page.getControl('#GridControlName#').addOnLoad(totalAssetsOfHousehold); // This is used to delay refresh by 1 second because sometimes grid takes time to load. // If you do not include below line, you may not ...
1 comment
Read more