Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Lot numbering physical inventory order/ Journal

(0) ShareShare
ReportReport
Posted on by 90

Good day everyone,

With regards to the physical inventory order/ journal, my understanding is that the physical inventory order is a more advanced feature that encompasses the mobile device scanning. I am facing an issue towards allocating a positive/ negative adjustments to a particular item and lot number.

For instance,

Expected quantity 100 cans of peas

LOT2 - 55 Cans

LOT51 - 45 Cans 

After a stock count is performed:

Physical quantity: 110 cans of peas

LOT2 - 50 KG

LOT51 - 50 KG

I want to be able to do a positive/ negative adjustment of 5kg of carrots each to both LOT 51 and 2, but i dont see any fields that would allow me to do so in the physical inventory order/ recording page. 

Steps I would do it,

1. calculate lines

2. make recording

3. create lines based on stock counted, in this scenario, 5

pastedimage1627383257143v2.png

assuming I have done the actual stock take, with both lots having 50 cans each. As such, there would be a negative adjustment from Lot 2 of 5 cans, and positive adjustment from LOT51 for 5 cans. 

4. Finish recording

5. Finish inventory order

6. Post order

 My item tracking lines are empty, unlike the physical inventory journal, i can assign the surplus/ different to the different lots. 

pastedimage1627383429001v3.png(Physical Inventory Order)

pastedimage1627383542361v4.png(Physical Inventory Journal) -> i want to achieve this in the physical inventory order but am unable to do so.

Would appreciate assistance towards this. 

Thank you so much,

ZJ

  • Suggested answer
    Andy Sather Profile Picture
    on at
    RE: Lot numbering physical inventory order/ Journal

    Hello,

    If you don't get further responses to this issue, you may want to raise a support request to Microsoft support via your CSP / Partner.

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 Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
YUN ZHU Profile Picture

YUN ZHU 628 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 495

#3
Sagar Dangar, MCP Profile Picture

Sagar Dangar, MCP 395

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans