Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Accounting distribution error in AP

(0) ShareShare
ReportReport
Posted on by 55

Our purchase ledger team match the invoice to the PO, and then submit the invoice to workflow. When submitting successfully matched invoices we are often getting this error:

"Stopped (error): The state of the source document or source document line could not be updated. One or more accounting distribution is missing a ledger account or contains a ledger account that is not valid.  Use the Accounting distribution form or the Posting profile to update the ledger account. Ledger account validated using 659000------, Record Id: 5637178356 Dimension values were validated with this account structure: P&L The combination was not validated beyond the CostCenter financial dimension. MainAccount 659000. You must select a value in the CostCenter field in combination with the following dimensions values that are valid: Journal  was not updated."

We believe that a fix is to make sure the header of the PO's financial dimensions are filled out, however we have some examples of where there are multiple lines within a purchase order pointing to different cost centres within one entity and therefore cant fill out the header as this overwrites whatever financial dimensions/cost centre is in the line. How do we raise a purchase order with different lines and different financial dimensions in each one to successfully match an invoice and post to the account without filling out the header and without getting the error above.

  • Mario Barnaba Profile Picture
    Mario Barnaba 19 on at
    Accounting distribution error in AP
    Hello,
    I am having an issue with one PO.
    I used distribution amount for this PO to different dimensions and then I posted prepayment invoice.
    then, I posted the full invoice which results in wrong voucher. (some entries are missing for ledger accounts and if I go through view accounting, it is different than the voucher).
    I tried to reverse the invoice but the invoice is reversing based on the correct invoice entry which will be different than the invoice posted.
    How to resolve this issue?
    this issue has resulted only once in this PO.
  • Suggested answer
    Prem Kumar Bachu Profile Picture
    Prem Kumar Bachu 3,410 on at
    RE: Accounting distribution error in AP

    Hi Olivia,

    Are you uploading invoices to "pending vendor invoices" form in D365? If you are using standard header data entity, you have field called "dimensiondisplayvalue" to enter the dimensions.

  • Olivia C Profile Picture
    Olivia C 55 on at
    RE: Accounting distribution error in AP

    Hi Prem, thank you for this.. this is not related to a journal this is when we upload a supplier invoice to D365 and are trying to match/process this not related to a PO. Do you know how we can fill out the financial dimensions in the header of the invoice with this scenario? Kind Regards

  • Suggested answer
    Prem Kumar Bachu Profile Picture
    Prem Kumar Bachu 3,410 on at
    RE: Accounting distribution error in AP

    I assume you are asking about journals(non-po), in the journal lines we can select financial dimensions.

    pastedimage1658153037003v1.png

    Let me know if you need help in specific non-po transactions.

  • Olivia C Profile Picture
    Olivia C 55 on at
    RE: Accounting distribution error in AP

    Thank you Prem, do you know where we can fill out the financial dimensions of the header if it doesnt pull from the PO when non-po related?

  • Suggested answer
    Prem Kumar Bachu Profile Picture
    Prem Kumar Bachu 3,410 on at
    RE: Accounting distribution error in AP

    Hi Olivia,

    We get above error if financial dimensions are not selected in the transaction or selected but dimensions are not valid as per accounts structure setup.

    So ensure you select the correct financial dimensions according to account structure configuration.

  • Olivia C Profile Picture
    Olivia C 55 on at
    RE: Accounting distribution error in AP

    Thank you very much Prem, this has appeared to work.. we have been able to put financial dimensions in the header of the PO without overwriting the FD's in each PO line and no error once the invoice is submitted to the workflow.

    Please can I ask if you are aware of how we resolve the error above when it is non-PO related?

    Kind Regards

    Olivia

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2024 Season 2 on at
    RE: Accounting distribution error in AP

    If you want the line dimensions to be considered then in GL parameters check what is the course die fined ?

    Is it document or accounting distribution.

    Try changing that as accounting distribution .

    Also note here: Header account (Supplier account will fact dimension normally from PO header)

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,811 Most Valuable Professional on at
    RE: Accounting distribution error in AP

    On AP parameters you may select not to update line information from the Po header. Select never as a selection on update parameters

  • Verified answer
    Prem Kumar Bachu Profile Picture
    Prem Kumar Bachu 3,410 on at
    RE: Accounting distribution error in AP

    Hi Olivia,

    When we update financial dimension in the PO header we get the below parameters screen, in this do not enable "Update dimension" so that system will not change PO line dimensions.

    pastedimage1657806076144v1.png

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans