question?
I have a big problem ... I have a diference between inventtrans and inventsum for some items ...
I want to say that the qty in invetsum is not equal to the sum of qty in inventrans.
What can i do to solve this problem without trying to have a job to correct that.
reply as below :
1 floor
The tools to Check and Fix the problem are in Basic/Periodic/Consistency check.
2 floor
with the class InventSumRecalcItem you can do a recalculation of the
inventsum based on the inventtrans data.
But befor you run this, please take a backup of db.
Sample script to recalc the inventsum
Hope this helps you.
--------------------------------------------------------------------
You can rebuild InventSum.
Very simple example for a particular ItemId in InventTable:
void clicked() //from button in InventTable Form
{
InventSumReCalcItem inventSumReCalcItem;
;
super();
ttsbegin;
inventSumReCalcItem = new InventSumReCalcItem(inventTable.ItemId, false,CheckFix::Fix);
inventSumReCalcItem.updateNow();
}