Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Physical Inventory Journal Duplicates

(2) ShareShare
ReportReport
Posted on by 425
Hi:
 
An end user has reviewed a Physical Inventory Journal, where duplicate records appear.
 
An item will appear on one record and in another record below that.
 
The only difference is that the Dimension Value for "Products" is different between the two records.
 
I tried to advise her that, likely, transactions for the same item are being entered for separate Dimension Values.
 
But, she says that that's not possible.
 
If not, what else can be causing such duplicates?
 
Thanks!
 
John
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 76,911 Super User 2025 Season 1 on at
    Physical Inventory Journal Duplicates
    Does this item have multiple Variant Codes? If so, it will be split into multiple lines.
    More details: 
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 7,593 Super User 2025 Season 1 on at
  • Suggested answer
    Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 1,188 Super User 2025 Season 1 on at
    Physical Inventory Journal Duplicates
    Hello John,
     
    Are you sure that you do not have any modifications on the standard functionality on the phy. inventory journal?
    Are you sure that your quantity that is double-shown is right?
     
    If you run your calculations by location, It could be that you have quantity on more locations or if you have item tracking enabled then it could be lot or package.
     
    A lot of things can be cause of this issue and it is hard to give you specific answers with this provided info.
     
    Greetings 

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans