Batch Number With blank information. AX 2009

Hi All,

We have several batch numbers in the Batch Number screen (Inventory Management/Inquiries/Dimension/Batches) where the item have no information. It seems that the system generaed this entries because the InventSum table is not synchronized at all. How do we delete this batch numbers with blank information?

Please explain to me in detail as well…will appreciates you guys if can help me out of this.

Thank you,

Shan.

What is stopping you to delete it normally?

An infolog :

The record cannot be deleted. open transactions exist in table on-hand inventory.

Hi Shantiya,

Check the transactions. It might have open translations. Go to batch form > click on Transactions button … it will display all the transactions.

If you have plenty of batch numbers & unable to find each & every one.then run On-hand Inventory (IM>Inquiries> On-hand) it will display all the items. click on dimensions display and select Batch & Serial and run it. It will show all the empty batches & related transactions. select empty once & delete.

Sarathy

Hi Sarathy,

Thanks for your explaination but if this is a recurring problem where we already have several occassions and we keep deleting them, this is not a permanent solution.

Any permenant solution for this?.

Thank you…

Shantiya.

Your permanent solution is to look at the transaction linked to teh batch number and understand why it has been created, then train the users not to process in this manner.

can any1 gimmi the solution? thx

How to sync the InventSum table…?

Your permanent solution is to look at the transaction linked to the batch number and understand why it has been created, then train the users not to process in this manner. Until YOU find the source creation point it is difficult to say anything specifically.

Why? Are you modifying this area? Are you deleting transactions through the back door?