Inventory transaction line without reference in Invent closing

(0) Share

Report

Posted on by Modiseh

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

I have the same question (0)

All responses (8)

Answers (0)

Raheel-Khan 1,371 on at

Like (0)

Report

Please share the error you getting while deleting it in the AOT

Was this reply helpful? Yes No
Rustem Galiamov 8,072 on at

Like (0)

Report

Is there the Reference field is filled?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Modiseh 85 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

Recalculation is not the same as closing. Which are you using?

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Rahele,

When you say 'remove it from the inventtranstable' do you mean that you simply deleted that recorded?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Hi Rahele!

Delete records from InventTrans table it's not a good idea.

Try to run this job to recalculate InventSum:

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"); }

Was this reply helpful? Yes No
Modiseh 85 on at

Like (0)

Report

Hi Ludwig

I did it in the test server.

I do not know why the recalculation and closing for these items is not done

Best Regards

Was this reply helpful? Yes No