Update InventSum transaction

(0) Share

Report

Posted on by ALAhmed

916

Hi There,

Firstly , i create and post the inventory adjustement journal.So i have new cost price calculated for the item .

When i create new inventory adjustement journal , i need get the updated cost price from

Product information management/Common/Released products/Item001/Manage inventory/on hand inventory/On hand/ cost Price.

So to do that i edit the method setCostPrice() on the table InventJournalTrans like this

this.CostPrice          = InventSum::find(this.ItemId,this.InventDimId).costPricePcs();

The problem is i still getting the preview value of cost Price because the InventSum.PosteValue is not updated, but when clear the cach i get the correct value of cost price.

Would you please help me what is the causing for such issue, and how can it be fixed ????

Is there a way to recalculate inventSum with the updated value?

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report
Copy link

Link copied!

Hi Alex

Due to the cache issue, isn't advisable access directly to the InventSum table.

So, use the inventOnHand Class

Take a look to the inventSumUnitPrice_IN standard method of the InventTransferLine Table.

Was this reply helpful? Yes No
Verified answer

Luan Nguyen 689 on at

Like (0)

Report
Copy link

Link copied!

try recalculate inventSum:

InventSumRecalcItem InventSumRecalcItem;

;

InventSumRecalcItem = new InventSumRecalcItem("ITEM001", true, checkfix::fix);

InventSumRecalcItem.updatenow();

Was this reply helpful? Yes No