Accounting date cannot be updated on PO

  • Accounting date cannot be updated on PO

    Posted by Wendy Shen on May 8, 2023 at 2:12 pm

    Hi,

    I’ve come across an issue where I am trying to confirm a PO, and I receive the following error message “Accounting date cannot be updated. no ledger calendar period between the document’s current accounting date 2021-07-07 and max allowed date 2025-04-01 allows posting. check the ledger calendar setup or update the document date to be within the allowed posting date range.”

    I have tried the following solutions suggested in other discussions:

    1. Changing the accounting date

    2. Purchase order distribution reset, and then trying to change the accounting date

    But in both cases above, I am unable to update the accounting date and another error message appeared, which states “You cannot change the date because reversing distributions that have not yet been journalized still exist. Confirm the current changes before you change the accounting date.”


    This PO has multiple lines, where some have been invoiced and also contains newly added lines which have yet to be invoiced. I’ve also tried looking into the “Distribute amount” for the new lines, but I am unable to open it unless I trigger a “Purchase Order Distribution Reset”. I tried to reset the lines but the same error about the accounting date shows up.

    Has anyone ever come across this issue ?

    Thank you in advance for your help!

    Wendy

    Dave Phillips replied 4 months, 2 weeks ago 2 Members · 1 Reply
  • 1 Reply
  • Dave Phillips

    Member
    May 8, 2023 at 2:39 pm

    Hi Wendy –

    Try this in TEST….

    Resetting the purchase order accounting distributions using “Purchase Order Distribution Reset” (Procure and Sourcing > Periodic Task > Clean up > Purchase Order Distribution Reset) allowed to confirm the purchase order.

    1. Navigate to Procurement and sourcing > Periodic tasks > Clean up > Purchase order distribution reset and select the desired purchase order then click ‘Ok’.

    2. Navigate to Procurement and sourcing > Purchase orders > All purchase orders and select the desired order then under the ‘Purchase’ tab click ‘Confirm’ to proceed with the PO confirmation.

    3. Go to the PO header and Change the accounting date to today’s date.

    4. Back to the PO lines and from the ‘Financials’ drop-down menu in the PO lines grid select ‘Distribute amounts’ and click ‘Correct’ so new accounting distribution records will be created.

    Very old Purchase Orders can be a special case. Also, there may be some new code to help alleviate the problem in 10.0.33.

    Thanks….FargoDave

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!