Item XXXX in warehouse XXX already added to document

[pvinod_kumar]

Dear Experts

when i trying to Add OB of Inventory with batch details he below error block me

Either i couldn't Preview the JE or Add the document

Error:-

Item XXXX in warehouse XXX already added to document

Am using SAP Business One 9.3 version for SAP HANA (9.30.160) PL: 06 (32-bit)

Regards

Vinod

[JesperB1]

Hello,

Please check, if there is any open inventory counting document for this item and warehouse. If so, please close it first and try to add the new inventory posting.
You can use this query to find all inventory counting rows containing the item and warehouse:

select * from INC1 where itemcode ='XXXX' and WhsCode = 'YYYY'

Jesper

[tlnpt]

I also have a problem related to this error but when I see the query results the row status of the item is still open while the doc is closed, is there a bug? please help with the solution, thank you.

[former_member681242]

Hi Kumar,

that sounds like the item is twice or more in your list. Or there is another document, which is not posted yet.

Please double check.

Kind regards

Tobias

[pvinod_kumar]

Yes the some item will repeating 3-4 time as it has different batch

Regards

Vinod

[former_member681242]

Hi Kumar,

the Item should be only once in the "header" here InventoryOpeningBalance, the addional Batch / SN should be within the other file for e.g. InventoryOpeningBalanceBatchNumbers

Kind regards

Tobias