Inventory close settlement records orphaned (AX 2009)

[Justin Biggs]

Hello,

We've recently run an inventory close for the month of June 2010 and
something's gone quite wrong with it.

Looking from the front end of things, there are no settlement records, and
no ledger transactions associated with the closing voucher. Looking in the
database however, there are over 10,000 transactions in InventSettlement with
the appropriate closing voucher, but have an incorrect reference to the
InventTrans record being settled.

For instance, the InventTrans record identified by the InventTransId has a
RecId of 5638915128, but the InventSettlement record has a TransRecId value
of 13511159664346168. I've no clue as to the discrepancy between these
values, but it's causing a great deal of trouble trying to reconcile
inventory values. The GL received no LedgerTrans records associated with
this Settlement Voucher, however, so that's off as well. Any ideas or
direction would be appreciated.

Thanks.
--
Best Regards,
Justin

[AQL]

Hi,

Are you using weighted average cost? Have you ever canceled any inventory
closing? If both true, that is the root cause of the orphaned records and
they belong to WAC inventory transactions that have been deleted.

Otherwise, I have no idea :D

--
AQL

[anh_ma...@hotmail.com]

Hi,

I got the same issue with WAC. And I found out that the invent trans records are missed somehow as you said.

Do you have any solution for this issues or any comment.

Thank you

Vào 05:29:03 UTC+7 Thứ sáu, ngày 06 tháng tám năm 2010, AQL đã viết: