Hello Dear Community [:)]
I have a question:
For the service items used in the BOM’s, i want to know how much they have been used in a certain time. We know that we could use the “transaction” option, but i have to do it item by item.
Does a report or a function exist in Axapta for that??
You can look into the Inventory Transactions report in Inventory Management by selecting only the service items.
I hope it may fulfill your requirement.
In that add a new range by clicking select.
The values are range should be
Table - Inventory Transactions
field - reference
Criteria - production line
you can even select the physical/financial dates…
The inventory transaction report filtered by item type and transaction type should work.
Do you mean in Stock Management – Reports – Stock transactions? If you mean that report i have a problem because i need a field (Item Type) and i can’t select it.
Please see in the Picture i have send it with my posting
You can modify the query…
Click select
In the structure Right click on Inventory Transactions - then n:1 → Item (Item Number).(you are forming a relation here)
Now create a new range with Items table , Field - Item Type , criteria - service
now it open only the service item transactions…
