How to extend VendInvoiceDocumentDP class

(0) Share

Report

Posted on by Ahmed Alam

In VendInvoiceDocument report I have added additional four columns and use VendInvoiceDocumentDP class for extension.

I have extended the insertVendInvoiceDocumentTmp or populateVendInvoiceDocumentTmp, it works but the reference data of first line appear in second line and I couldn't figure it out why it happened. Means the sales price of M0005 is 600 and it shows with Item Number M0006.

Sample code

public void insertVendInvoiceDocumentTmp(NoYes _purchInvoiceTransOrTaxTrans, NoYes _vendPaymSched)
{
next insertVendInvoiceDocumentTmp(_purchInvoiceTransOrTaxTrans, _vendPaymSched);
VendInvoiceDocumentTmp vendInvoiceDocumentTmp = this.vendInvoiceDocumentTmp;
real latestPurchasePrice;

ItemId _itemID;
date _invoiceDate;
AccountNum _accountNum;
real _purchPrice;
DataAreaId _areaId;

_itemID = vendInvoiceDocumentTmp.ItemId;
_invoiceDate = vendInvoiceDocumentTmp.InvoiceDate;
_accountNum = vendInvoiceDocumentTmp.InvoiceNum;
_purchPrice = vendInvoiceDocumentTmp.PurchPrice;
_areaId = vendInvoiceDocumentTmp.DataAreaId;

latestPurchasePrice = InventoryManager::getSpecificLatestPurchasePrice(_itemID, _invoiceDate);

vendInvoiceDocumentTmp.BT_AccountNum = _accountNum;
if(vendInvoiceDocumentTmp.PurchPrice != 0)
{
if(latestPurchasePrice != _purchPrice)
VendInvoiceDocumentTmp.BT_DiffPercentage = ((_purchPrice - latestPurchasePrice) / _purchPrice) * 100;
else
VendInvoiceDocumentTmp.BT_DiffPercentage = 0;
}

vendInvoiceDocumentTmp.BT_DocumentDate = _invoiceDate;
vendInvoiceDocumentTmp.BT_ItemOnHand = InventoryManager::getOnHand(_areaId, _itemID);
vendInvoiceDocumentTmp.BT_LastPurchPrice = latestPurchasePrice;
vendInvoiceDocumentTmp.BT_SalesPrice = InventTableModule::find(_itemID, ModuleInventPurchSales::Sales).Price;
}

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

It's because you extended a wrong method. You're changing the buffer after inserting, which means that your values will be used when the next record is inserted.

Was this reply helpful? Yes No
Ahmed Alam 62 on at

Like (0)

Report

@Martin Drab

Thanks for our valuable input, can you please guide which specific method i need to extend.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

If you open insertVendInvoiceDocumentTmp(), you'll see that it does two things: calls populateVendInvoiceDocumentTmp() to prepare the data and insert() to save the record to database. Therefore you should extend populateVendInvoiceDocumentTmp() - it's intended for this purpose and it's indeed call before insert().

Was this reply helpful? Yes No
Suggested answer

Ahmed Alam 62 on at

Like (0)

Report

Dear All,

I have extended the VendInvoiceDocumentTmp table method insert and it's working fine.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

There are several problems with insert(). For example, you can use only data that you have in fields of the temporary table, not all data you have in the provider class. You also make your code less discoverable but putting it at a different place than all the other code for the same purpose.

Was this reply helpful? Yes No
Ahmed Alam 62 on at

Like (0)

Report

Than what will be the best solution. Can I have sample because I have tried with either populate or insert both not worked.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report
I can't solve your problem, because I don't know what you mean by "not worked". You'd have to give us more information.

But I surely can give you a simple example:

protected void populateVendInvoiceDocumentTmp(NoYes _purchInvoiceTransOrTaxTrans, NoYes _vendPaymSched) { next populateVendInvoiceDocumentTmp(_purchInvoiceTransOrTaxTrans, _vendPaymSched); vendInvoiceDocumentTmp.MyField = vendInvoiceJour.MyField; }

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to extend VendInvoiceDocumentDP class

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to extend VendInvoiceDocumentDP class

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates