Minggu, 11 Oktober 2020

Get value VendTransOpen.Duedate and update LedgerJournalLines.Due with VendTransOpen.Duedate

Classes CustVendOpenTransManager
Classes VendOpenTransform

Jadi kita akan melakukan custom pada modul AP-Journal payment. terutama pada VendTransOpen.Duedate.

Skenario :
pada saat user memilih Open Settlement (VendTransOpen form), value VendTransOpen.duedate dapat dikopi dan masukan ke table LedgerjournalTrans.Due.

Caranya adalah.
custom class CustVendOpenTransManager.updateOriginatorForMarkedTrans

LedgerJournalTrans ledgerJournalTrans;
    BankThirdPartyAccountId firstVendBank;
    SalesTable salesTable;
    PurchTable purchTable;
    NoYes autoSettlement;

    // <GIN>
    LedgerJournalType           ledgerJournalType;
    TaxWithholdAuthorities_IN   taxWithholdAuthorities;
    // </GIN>

    // <GEEU>
    CustInvoiceJour custInvoiceJour;
    CustInvoiceJour_RU custInvoiceJourRU;
    // </GEEU>

    DueDate         duedateAP;//Add husna 20201011

    if (specTransManager.getSpecTransCount() > 0)
    {
        // If transactions were marked, write data back to the originating record.
        switch(originator.TableId)
        {
            case tableNum(LedgerJournalTrans):
                ledgerJournalTrans = originator;
                duedateAP = vendOpenTransForm.getDuedatesettlement();//add husna 20201011
                ledgerJournalTrans.Due = duedateAP;//add husna 20201011

lalu
di class VendOpenTransform buat sebuah method getDuedatesettlement()
public DueDate getDuedatesettlement()
{
    DueDate             duedatesettlement;
    SpecTrans               specTrans;

    if (!diffVendBankExist)
    {
        select firstOnly RecId, RefTableId, RefCompany, RefRecId from specTrans
            where specTrans.SpecRecId == originator.RecId;

        duedatesettlement = specTrans.vendTransOpen().DueDate;
    }

    return duedatesettlement;
}

Selasa, 22 September 2020

Filter datasource in form

Sample code :

Override ExecuteQuery method in datasorce and put this query before Super()

this.query().dataSourceTable(tableNum("RsPcm_EmployeeReqPaymentTable")).addRange(fieldNum(RsPcm_EmployeeReqPaymentTable,Status)).value(SysQuery::value(RsPcm_VendorActivityPaymentStatus::Draft)); 

Senin, 21 September 2020

Cannot edit a record in User to person relationship (DirPersonUser). Update on a valid time state table is not allowed without specifying a ValidTimeStateUpdateMode.

This table need update in validTimeStateUpdateMode field.
while you update the record you need to define [table].validTimeStateUpdateMode also.

sample code :

DirPersonUser           personusertable;
    ;
    
    select forUpdate personusertable
    where personusertable.RecId == 5637174578;
    ttsBegin;
        personusertable.PersonParty = 5637286583;
        personusertable.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction);
        personusertable.update();
    ttsCommit;

https://hellodax.com/2015/06/25/error-update-is-not-allowed-without-specifying-validtimestateupdatemode/

Rabu, 02 September 2020

Senin, 27 Juli 2020

How to Range or filter your Data's on your form

Example :
You have a form with datasource : Custtable.
and youwant to show only "v000001"
Override your Custtable.ExecuteQuery with your code, before Super().

CustTable_ds.query().dataSourceTable(tableNum(CustTable)).addRange(fieldNum(CustTable, CustId)).value(queryValue('v000001'));

see the detail in ":

Senin, 29 Juni 2020

Lookup based on Fromdate Todate

public void lookup()
{
   
    Query                       query = new Query();
    QueryBuildDataSource        queryBuildDataSource;
    QueryBuildRange             queryBuildRange;
    SysTableLookup              sysTableLookup = SysTableLookup::newParameters(tableNum(CustPaymFee), This);
    ;
    //2daydate  = today();
    sysTableLookup.addLookupField(fieldNum(CustPaymFee, FeeId));
    sysTableLookup.addLookupField(fieldNum(CustPaymFee, Description));
    sysTableLookup.addLookupField(fieldNum(CustPaymFee, LedgerJournalType));
   
    queryBuildDataSource = query.addDataSource(tableNum(CustPaymFee));
    queryBuildDataSource.addRange(fieldNum(CustPaymFee, PSMFromdate)).value("<"+SysQuery::value(today()));
    //queryBuildRange.value('<='+SysQuery::value(today())); <= its not working
    queryBuildDataSource.addRange(fieldNum(CustPaymFee, PSMtodate)).value(">"+SysQuery::value(today()));
    //queryBuildRange.value('>='+SysQuery::value(today())); >= its not working
   
    sysTableLookup.parmQuery(query);
    // Perform lookup
    sysTableLookup.performFormLookup();
   
}

Senin, 22 Juni 2020

How to get last Approval

static void dtGetLastApproverName(Args _args) 
 { 
    WorkflowTrackingStatusTable workflowTrackingStatus; 
    WorkflowTrackingTable workflowTrackingTable; 
    WorkflowTrackingCommentTable workflowTrackingCommentTable; 
    UserInfo userInfo; 

    select firstFast RecId, User from workflowTrackingTable 
     order by RecId desc 
     join workflowTrackingCommentTable 
    where workflowTrackingCommentTable.WorkflowTrackingTable == 
          workflowTrackingTable.RecId 
    join UserInfo where UserInfo.id == WorkflowTrackingTable.User 
    exists join workflowTrackingStatus 
    where workflowTrackingTable.WorkflowTrackingStatusTable == 
    workflowTrackingStatus.RecId 
    && workflowTrackingStatus.ContextRecId == _salesRecId //PurchRecID 
    && workflowTrackingStatus.ContextTableId == tableNum(SalesTable) //SalesTable 
    && workflowTrackingTable.TrackingType == WorkflowTrackingType::Approval; 

    if (workflowTrackingTable.RecId > 0) 
    { 
      info(strFmt(“%1 – %2 “,userInfo.name, workflowTrackingCommentTable.RecId)); 
    } 
 } 

You can get this code from : https://allaboutax.blogspot.com/2018/06/retrieve-last-approver-name-for-workflow.html?showComment=1592880782308#c5936258997657022271


Allow row version change tracking property is not supported on temp DB or in-memory table.

Error ini muncul karena konflik propertis pada table yang sedang dibuat. jika anda hendak membuat table Temporary, ubah property Allow row v...