I created a memorized transaction (MemTx) to add inventory items from our production, to the inventory. The transaction has all our inventory items, with 0 (zero) quantity (QTY) for all items. When we want to add inventory items, we type the quantity to the corresponding item(s), all other items in the transaction remain with 0 in the QTY column. Then we record the transaction.
When I drill down on the inventory activity, I see that an activity (transaction) was recorded for all the items with 0 in the quantity column. This does not affect the inventory count or valuation, but it inflates the number of transactions when we drill into the inventory activity for each item.
Is it possible to avoid that an activity/transaction is created for the the items that have 0 quantity in the memorized transaction?
Hello Mmoshe:waving_hand:, To resolve this you can delete the transaction lines that are showing as zero, As you say it's posting a zero line on an invoice and it'll show on reports. While it may seem a time saver if you have multiple inventory items and then you may just be changing the amount on a few items, rather than having to type them all but the zeros will still get reported on, the best thing to do is delete those transaction lines.
Thank you for responding, EmmaM.
I'm afraid that deleting the other 29 lines every time I want to post a transaction for one item defies the purpose of a memorized transaction. It would, then, be easier to just start a non-memorized transaction and just add the line item I want. I was hoping for a more practical solution...
Hi Mmoshe, We can pass on your feedback to the senior desktop team, we do not have a different solution to make this easier, we'd love to be able to advise on one. There may be other Community users who have used a third-party app to help with this. This thread will be kept open and we welcome any users who have found a different way to resolve this to add to this post.:smiling_face_with_smiling_eyes: