Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Distribution accounts missing or invalid for an AR invoice

(0) ShareShare
ReportReport
Posted on by

I have been having issue posting an AR invoice. The error I got from the "edit list" is "Distribution account(s) are missing or invalid." I am creating an USD invoice and have input the exchange rate to so that the invoice reflected as in Canadian dollars. I should the account no and account in the distribution so not sure what is missing and how to fix. 

Any help is greatly appreciated.

Thanks,

Louise

*This post is locked for comments

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    10 on at
    RE: Distribution accounts missing or invalid for an AR invoice

    Once the invoice is posted status is moved to history.  Not sure which window you are referring to.  But if you cant find it on transaction by document it will be there on sales document.  Please verify the answer when you get a chance.

  • Community Member Profile Picture
    on at
    RE: Distribution accounts missing or invalid for an AR invoice

    Thanks and I am able to post now.

    However, why when I try to locate the invoice in the Receivables Transaction Inquiry Document window, it said "This document has been removed from Sales Order processing history." What is this mean?

  • Verified answer
    babubaskaran@outlook.com Profile Picture
    10 on at
    RE: Distribution accounts missing or invalid for an AR invoice

    Hi Louise,

    I think you are doing Sales Order processing invoice, please select the item number and go to item detail entry window and press distribution on that.  There might be missing accounts on that window.

  • Community Member Profile Picture
    on at
    RE: Distribution accounts missing or invalid for an AR invoice

    Sales-posting-error.JPG

    Can you view?

  • Community Member Profile Picture
    on at
    RE: Distribution accounts missing or invalid for an AR invoice

    I tried to but not sure now.

  • babubaskaran@outlook.com Profile Picture
    10 on at
    RE: Distribution accounts missing or invalid for an AR invoice

    can you share the screen shot of the transaction.

  • Community Member Profile Picture
    on at
    RE: Distribution accounts missing or invalid for an AR invoice

  • Community Member Profile Picture
    on at
    RE: Distribution accounts missing or invalid for an AR invoice

    yes, both distribution debit and credit filled are filled.

  • babubaskaran@outlook.com Profile Picture
    10 on at
    RE: Distribution accounts missing or invalid for an AR invoice

    Louise,

    Are you saying the distribution debit and credit filled and still you are getting this error.  Can you please share the screen shot of AR and the distribution of this transaction. 

  • Peter Muchira Profile Picture
    1,912 on at
    RE: Distribution accounts missing or invalid for an AR invoice

    Hello,

    The error points to missing mapping of accounts - probably at the Customer/Customer class level on the one hand and the item level on the other. Basic posting accounts should be mapped for :

    Sales

    Receivables

    COGS(Cost of Sales)

    Once you confirm that the mapping is complete, you may have to recapture the invoice; GP does not necessarily refresh the distributions of the transactions captured before the mapping was done.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans