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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Inventory Integration in wish date document is worng

(0) ShareShare
ReportReport
Posted on by 25

Hi 

What can i do if i had integrate the inventory in item sheet with a wrong date.than after a period of working i found the unit cost of the item  is wrong .well the document date in item sheet is post the working date.

Please help 

Best regards 

  • Suggested answer
    TWBlaisdell Profile Picture
    Microsoft Employee on at

    Hi DJOBBI,

    Thank you for posting on the Forum.  The product shows Dynamics NAV.   However, I do not understand the term "wish date document"  or item sheet in base NAV functionality.   Would you be able to provide further detials to explain the feature you are using?

    When you reference the unit cost is wrong, I recommend looking at the Revaluation Journal. The corrective process is to record a Revaluation Journal adjustment.  In this specific case, the Revaluation Journal may need to be processed using the Applies to Entry field (Not using Calculate Inventory Value) and the adjustment must be posted for the correct cost if a back-in-time adjustment to the original Posting Date of the Positive Adjustment in order for the impact to be pushed through to the applied Sales entry.   This may require opening up the Inventory Period and updating the Allow Posting From Date in General Ledger Setup and User Setup  for the user processing the transaction to the Posting Date of the incorrectly valued Positive Adjustment entry. By backdating and posting using the Applies To Entry, the system will revalue the full original quantity and allow for the adjustment to be pushed through to applied entries with the corrected item cost when .

    RevaluationWithAppliesToEntry.png

    I hope the information helps you move forward.

    Thank you.


    Best Regards,

    Tom

  • DJOBBI Profile Picture
    25 on at

    Hi

    thanks for being interactive . the posting date is a wrong date for exemple it have to be 31/12/2020 although it is injected 31/12/7899 whish is  wrong. it is a postarious date of the working date of this year after .

    after 2 month of working i found the unit cost wish is calculated automatically  following the transactions of the item  

    the costing methods of items is average

    Best regards

  • Suggested answer
    TWBlaisdell Profile Picture
    Microsoft Employee on at

    Hi

    Wow! Very challenging issue! Especially not finding it for 2 months. The only steps I think you may try is as follows:

    1) Post Item Journal Postive Quantity and correct cost with correct date to 31/12/2020

    2) Go to Item Card - Click More Options

    3) Click Related - History - Entries - Item Application Worksheet - Select Positive Adjustment posted on 31/12/7899 - select Related > View Applied Entries. Select Remove Application for all Negative Qty (Outbound Item Ledger Entries) applied to this wrong Posting Date

    4) Click Actions > Functions > Reapply - this should now reapply these Negative entries to the 31/12/2020 correct ILE Positive Adjustment from step 1)

    5) Enter an Item Journal Negative Entry with the Posting Date on 31/12/7899 for same quantity as the Positive Adjustment posted on 31/12/7899 - Set Applies-to Entry to the Positive Adjustment ILE posted on 31/12/7899.  This should fix-apply the negative to the positive to clear the wrongly posted cost and entries on the future date completely.

    I hope the steps enable you to work through the issue, which appears to be very challenging.

    After completing above steps, please update General Ledger Setup > Allow Posting From Date and Allow Posting To Date  to better control the posting of entries going forward.   The User Setup also includes the applicable date range.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 720 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 436 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 409 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans