Finance | Project Operations, Human Resources, ...

Post PO Invoice Amount Zero

(0) Share

Report

Posted on by Amol@

282

Hi all,

I need to Post PO Invoice Line amount and Gross amount as Zero if my custom field is (in PurchTable) "Yes", so for which class or method i should do extension in 365.

Please reply if anyone have idea.

Thanks in advance,

Amol

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Sumit Loya 2,230 on at

Like (0)

Report
Copy link

Link copied!

Hi Amol,

If for your custom field, the Purchase order amount should be 0, then I would suggest that you set the unit price on Purchase order line to 0 on creation or when the field is modified on Purchase order header. This way the invoice line amounts will also be 0. You can achieve this by extending PurchLineType class.

If you still wish to set this only at invoice level, then have a look at PurchFormLetterParmDataInvoice class and specifically method createParmLinesAndTable method. This is where the staging table and lines are created during invoicing process.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Amol@,

Why is it that you have to post the PO invoice line with a price of $0?

Did you get the product for free?

Was this reply helpful? Yes No
Amol@ 282 on at

Like (0)

Report
Copy link

Link copied!

Hi Sumit,

Thanks for reply,

I have tried doing COC of createParmLinesAndTable method of PurchFormLetterParmDataInvoice class, but not succeeded.

Below my coc-

protected void createParmLinesAndTable()

{

VendInvoiceInfoLine vendInvoiceInfoLine;

PurchTable purchTable;

ParmId currentParmId = this.parmId();

next createParmLinesAndTable();

select vendInvoiceInfoLine where vendInvoiceInfoLine.ParmId == currentParmId;

purchTable = PurchTable::find(vendInvoiceInfoLine.OrigPurchId);

if(purchTable.CON == NoYes::Yes)

{

if(vendInvoiceInfoLine)

{

info(strFmt("Before = %1",vendInvoiceInfoLine.LineAmount));

vendInvoiceInfoLineUp.LineAmount = 0;

info(strFmt("After = %1",vendInvoiceInfoLine.LineAmount));

}

}

}

In debugging it's triggering and getting value (Line Amount Value) in Before info and updating line amount 0 in after info but in table it is not updating zero.

let me know if any suggestion,

Thanks,

Amol

Was this reply helpful? Yes No
Suggested answer

Sumit Loya 2,230 on at

Like (0)

Report
Copy link

Link copied!

The update buffer, I see is vendInvoiceInfoLineUp but you are displaying info from vendInvoiceInfoLine also you are not calling update method. just by assigning the value is not enough.

Was this reply helpful? Yes No
Amol@ 282 on at

Like (0)

Report
Copy link

Link copied!

Hi Sumit,

Typo mistake in buffer,

Below is updated code ,

protected void createParmLinesAndTable()

{

VendInvoiceInfoLine vendInvoiceInfoLine,vendInvoiceInfoLineUpdate;

PurchTable purchTable;

ParmId currentParmId = this.parmId();

next createParmLinesAndTable(); //Next

select vendInvoiceInfoLine where vendInvoiceInfoLine.ParmId == currentParmId;

purchTable = PurchTable::find(vendInvoiceInfoLine.OrigPurchId);

if(purchTable.CON == NoYes::Yes)

{

info(strFmt("Update Before = %1",vendInvoiceInfoLine.LineAmount));

update_recordset vendInvoiceInfoLineUpdate

setting LineAmount = 0

where vendInvoiceInfoLineUpdate.OrigPurchId == vendInvoiceInfoLine.OrigPurchId &&

vendInvoiceInfoLineUpdate.ParmId == currentParmId;

info(strFmt("Update After = %1",vendInvoiceInfoLineUpdate.LineAmount));

}

}

But it's giving below error-

Kindly suggest,

Thanks in Advance,

Amol

Was this reply helpful? Yes No