Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error when posting an ...
Microsoft Dynamics GP (Archived)

Error when posting an invoice: Distribution Accounts are missing or invalid

(0) ShareShare
ReportReport
Posted on by kuroneko1313 2,119

Hello,

I built a new fresh install of GP (version 9.0 SP4) in our development server to test its integration with our Microsoft CRM 3.0. I transferred the GP database from our production environment and so far everything is working fine.

 However I had problems posting my first invoices; I always get the error message on my line item numbers that "Distribution accounts are missing or invalid". I have checked that the accounts used for the line item's distribution are listed under "Accounts" (from View > Financial Lists > Accounts). I also made sure that the Accounts appear on the line item description.

 Is there anything else I can check that's preventing me from posting invoices? The invoices are actually created from orders, that are integrated from Microsoft CRM 3.0.

 Any help is greatly appreciated. Thanks in advanced!!

 

-Elizabeth K.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Error when posting an invoice: Distribution Accounts are missing or invalid

    Hi Elizabeth,

    Just out of interest, how are you transfrring data from CRM to GP? Do you use eConnect?

    Best regards,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Error when posting an invoice: Distribution Accounts are missing or invalid

    Thank you so much , now i can post it

     

  • kuroneko1313 Profile Picture
    kuroneko1313 2,119 on at
    Re: Re: Error when posting an invoice: Distribution Accounts are missing or invalid

     Ian and callen, thank you very much for your reply!

     I've checked that all the distribution and posting setting are correct... however this problem is actually caused by some error placements of product orders from the CRM. For some reason the prodcuts from CRM were not transferred correctly to GP. I worked around this problem, and now I can post invoices just fine.

     Thank you very much for all your help!

     

    -Elizabeth K.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Error when posting an invoice: Distribution Accounts are missing or invalid

    Hi,

    You need to make sure that each item has distribution accounts added. (Cards >> Inventory >> Item..and click the accounts button).

    The required Line account distributions for a SOP invoice are generally Inventory, Cost of Sales, Sales, and Markdown. But if you can assign acounts to all distribution types listed in the above window, you should not get any error messages.

     

    Best regards,

  • callen Profile Picture
    callen 4,595 on at
    Re: Error when posting an invoice: Distribution Accounts are missing or invalid

    1. Verify your SOP setup is set to use Items as the source of the accounts, assuming that's what you really want. Go to Tools >> Setup >> Sales >> Sales Order Processing. The option is on the right side of the window.

    2. Verify the line items have entries for Sales, Cost of Goods Sold, and Inventory.

    3. Click the Distribution button on the Sales Transaction Entry window to see what distribution lines are missing the accounts.

     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans