Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I have several weighted average lines in the inventory transaction for specific items without any origin in the invent closing table.
How can I delete it form the inventtrans table ? Because when I want delete it in the AOT show me different error .
Please share the error you getting while deleting it in the AOT
Is there the Reference field is filled?
Can you share details of those transactions?
Why do you want to delete them?
Have you checked the settlements and the settlement report that you can generate from the closing and adjustment form?
I have a problem recalculation. The system doesn't recalculate ( or closing) it and some of item.
I thought the issue was with these rows.
This is a photo of transaction list for a product that has closing problem :
and also when I wanted delete it in the AOT, Show me below error :
then I enabled a negative inventory in the warehouse, then I could remove it from the inventtrans table.
But my problem wasn't resolved and the recalculation isn't done. :(
BR \ Rahele
Recalculation is not the same as closing. Which are you using?
When you say 'remove it from the inventtranstable' do you mean that you simply deleted that recorded?
Delete records from InventTrans table it's not a good idea.
Try to run this job to recalculate InventSum:
static void InventSumRecalc(Args _args)
while select inventTable
where inventTable.ItemId == "yourItemId"
inventSumReCalcItem = new InventSumReCalcItem(inventTable.ItemId, true, CheckFix::Fix);
I did it in the test server.
I do not know why the recalculation and closing for these items is not done
Business Applications communities