web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

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

There is no open quantity which the adjustment can be allocated to.

(0) ShareShare
ReportReport
Posted on by 126

Hi 

I have done the closing and would like to adjust on-hand unit cost. but for some items I get this error.

Adjustment of on-hand inventory There is no open quantity which the adjustment can be allocated to.

My inventory model in Weighted Ave Date.  How can I adjust on-hand value?

Thank you in Advance and Regards

Hamid

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: There is no open quantity which the adjustment can be allocated to.

    Hi Hamidreza,

    You can adjust the price.

    Simply go to inventoy/periodic/closing and adjustment and run an inventory close first.

    Once this is done, you can then select adjustment/on-hand

    This opens a new form where you have to select your item first.

    Once you have made the selection you can then adjust the cost price/value/amount/etc. via the adjustment button.

    Please test this in a demo/test environment first before trying this in your live environment.

    Best regards,

    Ludwig

  • MATTGUO Profile Picture
    22,336 Moderator on at
    RE: There is no open quantity which the adjustment can be allocated to.

    Hi,

    Which financial inventory is selected in storage and tracking dimension for this item?

    What are the parameters on the filter?

  • Yadegari Profile Picture
    126 on at
    RE: There is no open quantity which the adjustment can be allocated to.

    Thank you Ludwig

    Consider this item. I would like to change unit price to 42000. It has financial amount and on-hand.

    2020_2D00_08_2D00_02_5F00_19_2D00_41_2D00_14.jpg

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: There is no open quantity which the adjustment can be allocated to.

    Hi Hamid,

    You can make adjustments only to those items where you have a financial inventory value. If there is no inventory on stock you cannot make an adjustment.

    Can you let us know what kind of adjustments you plan to record here?

    Best regards,

    Ludwig

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 775 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 634 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 622 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans