Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

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

Posted on 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
    Ray_H 10 on at
    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
    Krishna Pushpak 265 on at
    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans