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 :
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 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 ?
I have the same question (0)
  • Laurens vd Tang Profile Picture
    3,656 Super User 2025 Season 2 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
  • André Arnaud de Calavon Profile Picture
    299,576 Super User 2025 Season 2 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?
  • VolkerEb Profile Picture
    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
     

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 413

#2
Sagar Suman Profile Picture

Sagar Suman 198 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans