Question Status

Suggested Answer
Sam Henry asked a question on 21 Oct 2013 2:12 PM

Hello,

I've created a count journal for a warehouse.  In that count journal include some items which have been stopped.  Though I left the counted field blank as obviously there are no items, it still won't let me post the journal.  Tells me "Item 1055200/001 is on hold for transactions in Inventory."

Am I going to have to manually delete all the stopped item lines? Or can they be excluded from the report in the first place?

I'm not using counting groups...so please don't recommend that right now.

Reply
Suggested Answer
Ibrahim Salah responded on 21 Oct 2013 2:34 PM

try to user filtration query when you creating the journal and add the filter for field on hold

Best Regards,

Ibrahim Salah | Microsoft Dynamics AX Solution architect | My Blog |


Reply
Suggested Answer
Brandon Wiese responded on 22 Oct 2013 5:23 AM

You can exclude stopped items from the selection query, as suggested.  Or, perhaps you should be using "Onhand counting" instead of "Item counting".  

With onhand counting you only have to deal with items that have onhand quantity and value rather than every single item.  If you manage to find inventory not in the journal, you can easily add it later to the journal.

Finally, you do not necessarily have to stop the item for inventory transactions.  If you stop an item for sales and purchase, you are protected against its accidental use on sales and purchase orders, but then you are still able to count it as needed, though that provides an opportunity to transaction against the wrong item by mistake.

Reply
Suggested Answer
Ibrahim Salah responded on 21 Oct 2013 2:34 PM

try to user filtration query when you creating the journal and add the filter for field on hold

Best Regards,

Ibrahim Salah | Microsoft Dynamics AX Solution architect | My Blog |


Reply
Suggested Answer
Brandon Wiese responded on 22 Oct 2013 5:23 AM

You can exclude stopped items from the selection query, as suggested.  Or, perhaps you should be using "Onhand counting" instead of "Item counting".  

With onhand counting you only have to deal with items that have onhand quantity and value rather than every single item.  If you manage to find inventory not in the journal, you can easily add it later to the journal.

Finally, you do not necessarily have to stop the item for inventory transactions.  If you stop an item for sales and purchase, you are protected against its accidental use on sales and purchase orders, but then you are still able to count it as needed, though that provides an opportunity to transaction against the wrong item by mistake.

Reply