Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Correction of a comple...
Supply chain | Supply Chain Management, Commerce
Unanswered

Correction of a completed purchase order with a financial date in the next year

(1) ShareShare
ReportReport
Posted on by VolkerEb 31
Hello everyone,

We have a problem with huge stock values due to incorrect quantity entries.
 
What has happened?
1. the EAN code was entered in the quantity field via a mobile device and thus huge quantities were posted as product receipts.
2. another correction line with a negative quantity was entered, but not with marking, thus a separate transaction
3. the physical date of these transactions was in the old year, the invoice and therefore the financial date was in the new year
As the marking, regulation and recalculation only have an effect on the new year (financial date), we now have huge sums in the ledger accounts at the end of the year.
 
 
We currently have no idea how we can reverse this incorrect process 1:1. 1 Cent difference in the cost price has a major impact.
 
Does anyone have a suggestion ?
Inventory transac...
  • VolkerEb Profile Picture
    VolkerEb 31 on at
    Correction of a completed purchase order with a financial date in the next year
    Hello André, hello Laurens,
     
    thank you for your reply.
     
    The periods are open.
    We have LIFO.
    We have not yet made a inventory closing and canceled the recalculations.
     
    We can therefore enter and post purchase orders to clear the incorrect ones.
    Since the system evaluates the issues according to LIFO, my concern is that we do not receive exactly the same values as with the incorrect posting.
    And the smallest deviations have a big impact on these figures.
    Maybe valuate all receipts the same so that the issues of the incorrect case and the correction are the same?
     
    Best regards,
    Volker
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,998 Super User 2025 Season 1 on at
    Correction of a completed purchase order with a financial date in the next year
    Hi Volker,

    Can you tell us what inventory costing model you are using? Are you running the inventory closing and recalculation frequently? Is your accounting department allowing for reopening the period for December 2023?
  • Laurens vd Tang Profile Picture
    Laurens vd Tang 2,569 Super User 2025 Season 1 on at
    Correction of a completed purchase order with a financial date in the next year
    Hello Volker,
     
    Is your financial period closed? If yes, would not reopen the financial period?
     
    I found a link to a question in the past how to open a closed period: https://community.dynamics.com/forums/thread/details/?threadid=d0840f30-1f95-41b0-8cbd-babd6e7f2cb3
     
    Best regards,
    Laurens van der Tang

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,998 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,850 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans