I would like to get a clarification regarding inventory transaction data in Acumatica.
We are currently trying to identify whether there is a single table or a recommended data source that can be used to retrieve all types of inventory transactions, such as inventory issues, receipts, transfers, and adjustments, in a unified manner.
From our understanding, tables like INTran, INRegister, and INTranSplit are involved in storing inventory-related data. However, we would like to confirm the following:
- Is INTran the correct and complete source to capture all inventory movements (issues, receipts, transfers, adjustments)?
- Are there any additional tables or views that should be considered to ensure no transactions are missed?
- Is there a recommended approach (or standard Generic Inquiry structure) to retrieve all inventory transactions accurately for reporting purposes?
- Are there any specific conditions, flags, or transaction types we should consider when filtering this data?
Additionally, we have a few specific data requirements:
- We need to include Lot/Serial Number details along with the transactions. Is INTranSplit the correct table to join for this requirement?
- We need to capture the exact unit cost for each transaction. Could you please advise which field/table should be used to get the most accurate cost (e.g., unit cost vs. valuation cost)?
- For date-based reporting, we need the exact transaction date/time (date stamp). Which field would be most appropriate to use (e.g., TranDate, CreatedDateTime, etc.)?
It would be very helpful if you could guide us on the best practice for extracting complete and accurate inventory transaction details, including the above requirements.
Thanks.
