Same document number in Batch Number Transactions Report

[Former Member]

Dear all experts,

i faced a serious problem for the batch management

i don't know why there is many cases that have the duplicated Document number in the Batch Number Transactions Report

for example the document number will appear twice as ST 5650

i have checked the type ST means for Inventory Update

i tired to simulate to create the same case, but unsuccessful, no duplicated document number is generated, i tried it via the "Initial Quantities, Inventory Tracking, and Stock Posting", i can generate ST type JE document, but cannot generate duplicated Document number in the Batch Number Transactions Report

Please kindly help....

Many thanks!!!

[Former Member · Accepted solution]

Dear all experts,

i have some more finding, each of the JE also has two pairs of transaction, it means it totally have 4 transactions (the same pair x 2 times)

all of them are also Auto Posting JE, it means it is not manually created by users.

Please help.

thank you.

Edited by: tac wong on Aug 16, 2011 6:15 AM

[Former Member · Accepted solution]

Hi Tac,

Could you tell what is the direction and quantity for each ST type transaction in the batch number transactions report?

Best Regards,

Hendry Wijaya

[Former Member · Accepted solution]

Dear Hendry Wijaya,

Thank you for your reply

the direction is 'IN' and the quantity is the same with the 2 transactions, for example both of them are Qty 19

Thanks alot!!

[jitin_chawla · Accepted solution]

Hi,

Can you also confirm what dates posting are these. Are these old version transactions?

Alos, please check the select query in Note No. : 1022965 and see whether the issue reported by you is related to incorrect batch allocation.

Let us know.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Dear Jitin,

Thank you for your reply, the posting date of the both transactions are at the same date, for example 15.02.2011

just checked the database by using the scripts provided in note 1022965, no problem is found.

Thank you.

Edited by: tac wong on Aug 18, 2011 3:35 AM

[jitin_chawla · Accepted solution]

Hi,

You can check the Note No. : 1250867 and 1241506 if the same helps.

There are queries in both the Notes which deals with the missing documents and incnsistency in the batches/serial numbers.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Dear Jitin,

thank you for your help, the notes is helpful even my problem yet cannot be solved but i got more information.

thanks.