Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : ZLjHFpkCXZvEUvRUu5XEw2
Finance | Project Operations, Human Resources, ...
Answered

Item batch tracking - Inventory dimension Batch number must be specified error

Like (1) ShareShare
ReportReport
Posted on 1 Nov 2021 01:51:27 by 10

Hi Experts,

one user created new Item without batch tracking and qty 75000 was received by PO without batch number, current PO status is "open order" but item line status is received.

Later batch tracking was enabled by the user and transactions(sales orders, counting journals) were done. we want to adjust initial quantity (without batch number) and it is giving below error.

Below is the error appearing when adjusting the qty.

pastedimage1635729706493v1.png

I've checked some tables in backend to update the batch number but it seems I need to update INVENTDIMID as well and I am skeptical about the this route.

How can I safely adjust/remove this qty from AX without doing changes in the tables? 

below are some of the tables that I've checked.

I've basic understanding of finance. 

pastedimage1635730386279v2.png

PO:

pastedimage1635731450703v1.png

we are using AX 2012 with below versions.

kernel version : 6.0.1108.6798

Application version: 6.0.1108.670.

  • Suggested answer
    Ray_H Profile Picture
    10 on 17 Nov 2021 at 02:44:19
    RE: Item batch tracking - Inventory dimension Batch number must be specified error

    Hi Krishna,

    Thanks for reply, I've cancelled the product receipt and balanced the inventory by the adjustment journal.

    Another way I've found is to update InventDIMId on purchline table.

  • Verified answer
    Krishna Pushpak Profile Picture
    265 on 01 Nov 2021 at 14:01:42
    RE: Item batch tracking - Inventory dimension Batch number must be specified error

    Hi Ray ,

    Did you check PO>>Actionpane>>General >> Line Quantity ??  if all looks ok

    Did you try cancel the Product receipt of PO and receive again ??

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,435 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,567 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans
Loading complete