I want to write a job where i have to update E-Invoicing status from None to IRN Generated

(0) Share

Report

Posted on by ax.tech

Hi Experts,

I want to write a job where I have to update E-Invoicing status from None to IRN Generated. I have also tried please let me know where I'm wrong.

Thanks & Regards

static void vtsUpdateEInvoicingStatus()
{
    CustInvoiceJour custInvoiceJour;


    ttsBegin;

    while select forUpdate custInvoiceJour
        where custInvoiceJour.AcxEInvoicingStatus == "None"
    {
        custInvoiceJour.AcxEInvoicingStatus = custInvoiceJour.IRNGenerated();
        custInvoiceJour.update();

    }
    //update_recordSet
    ttsCommit;

    info("DONE");
}

I have the same question (0)

All responses (16)

Answers (1)

GirishS 27,825 Moderator on at

Like (0)

Report

RE: I want to write a job where i have to update E-Invoicing status from None to IRN Generated

Hi ax.tech,

Is AcxEInvoicingStatus is your custom field?

What is the data type for that field?

Thanks,

Girish S.

Was this reply helpful? Yes No
ax.tech 86 on at

Like (0)

Report

RE: I want to write a job where i have to update E-Invoicing status from None to IRN Generated

Hi Girish,

Thanks for replying. Yes it is a custom field with type enum.

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: I want to write a job where i have to update E-Invoicing status from None to IRN Generated

Try the below code.

What is the logic added in this method custInvoiceJour.IRNGenerated()?

Thanks,

Girish S.

Was this reply helpful? Yes No
ax.tech 86 on at

Like (0)

Report

RE: I want to write a job where i have to update E-Invoicing status from None to IRN Generated

I think this is where I'm wrong can you please help and correct this ?

Thanks in advance

Was this reply helpful? Yes No
Verified answer

GirishS 27,825 Moderator on at

Like (0)

Report
RE: I want to write a job where i have to update E-Invoicing status from None to IRN Generated

So you want to update all the record which are having none status to IR Genrated.

Try the below code. Replace "YourEnumName" with your custom enum name.

static void vtsUpdateEInvoicingStatus() { CustInvoiceJour custInvoiceJour; ttsBegin; while select forUpdate custInvoiceJour where custInvoiceJour.AcxEInvoicingStatus == YourEnumName::None { custInvoiceJour.AcxEInvoicingStatus = YourEnumName::IRNGenrated; custInvoiceJour.update(); } //update_recordSet ttsCommit; info("DONE"); }

Thanks,

Girish S.

Was this reply helpful? Yes No
ax.tech 86 on at

Like (0)

Report

RE: I want to write a job where i have to update E-Invoicing status from None to IRN Generated

Hi Girish,

Getting this error.

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: I want to write a job where i have to update E-Invoicing status from None to IRN Generated

Can you show me the screenshot of the error?

Screenshot is not showing if you have attached in the previous replies.

Thanks,

Girish S.

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: I want to write a job where i have to update E-Invoicing status from None to IRN Generated

Hi ax.tech,

Error may be due to some validation written on the "CustInoviceJour" table update method.

So try to change the code from custInvoiceJour.update() to custInvoiceJour.doUpdate().

Thanks,

Girish S.

Was this reply helpful? Yes No
ax.tech 86 on at

Like (1)

Report

RE: I want to write a job where i have to update E-Invoicing status from None to IRN Generated

Hi Girish,

It is working fine now. Thank you so much for your valuable and support means a lot.

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (1)

Report

RE: I want to write a job where i have to update E-Invoicing status from None to IRN Generated

Hi ax.tech,

Please mark it as verified( Yes ) if its solved your issue.

Thanks,

Girish S.

Was this reply helpful? Yes No