Importing Inventory Transactions - Template Assistance / Confirmation on import process

Account name - Tauranga City Council (TCC)
Region - APAC
Client version (Enterprise)- 25.2202507280
Description of the issue - Customer is unable to import inventory transaction batches in the system using standard template as an error occurs
- What does the client want to do? Why do they want to do this?
  - TCC is uploading inventory transactions directly in Enterprise to reflect the updated inventory on items. They are able to do this manually in the system but not through the import process.
What you've already tried or suggested. Why does this not work?
- I've tested it myself on a local copy using the standard template available and have encountered same issue as customer.
- I've also reviewed the template available and data model to review
Business impact if not resolved
- Unable to update inventory items quantity in bulk through import process result
Attach relevant files (such as screenshots)
- Standard Template
- Error & template below
Links to articles where you've looked for solutions and also other steps you've taken to research the issue.
- Inventory Transactions
- Import Inventory Items and Inventory Transactions
  - Referred to transactions import template - Standard

Questions:

Is “Transaction Description” column required as part of import process? - My Assumption is No, but it does exist in “standard template"
What is the reason behind import error: Entry not imported. There is an invalid value in a field specified as a numeric. Field in error: CC321_AMOUNT/C321_QUANTITY

Martin Wooding / Pieter Du Plooy - Any suggestions here!

Official comment

August 27, 2025 14:00

Please just send this back as a ticket. There appears to be an issue with importing negative numbers. Inventory transactions generally are positive units (Issue transactions are positive units but due to transaction type have a negative impact on the balance) - but it should be supported to allow for negative adjustment transactions.

Minor update and we will take care of it.

Given what the customer is trying to achieve (based on the file they are only impacting the quantity but not the amount or unit cost) - they should be able use an issue (ISS) transaction type with positive values in the short term. But we'll have this addressed in 25.2 pretty quickly.