85
Hi all
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 .
*This post is locked for comments
Hi Rahele!
Delete records from InventTrans table it's not a good idea.
Try to run this job to recalculate InventSum:
Share
Report
All responses (
Answers (
static void InventSumRecalc(Args _args)
{
InventTable inventTable;
InventSumReCalcItem inventSumReCalcItem;
ttsbegin;
while select inventTable
where inventTable.ItemId == "yourItemId"
{
inventSumReCalcItem = new InventSumReCalcItem(inventTable.ItemId, true, CheckFix::Fix);
inventSumReCalcItem.updateNow();
}
ttscommit;
info("done");
}
Hi Rahele,
When you say 'remove it from the inventtranstable' do you mean that you simply deleted that recorded?
Best regards,
Ludwig
Hi guys
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
Hi,
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?
Best regards
Ludwig
Is there the Reference field is filled?
Please share the error you getting while deleting it in the AOT
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156