web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Distribution account...
Microsoft Dynamics GP (Archived)

Distribution account(s) are missing or invalid

(0) ShareShare
ReportReport
Posted on by John Horner 175

I am attempting to post a batch of invoices and I continue to receive the above error message.  At this point I have basically populated every single posting account field that I know of possible with something.  Under the Posting Account setup, under the Item accounts and under the Customer accounts.  Why does this system give no indication of where the issue is stemming from, just a very vague "something is wrong message"?  Does anyone know of any utilities that can be used to determine what is actually wrong when posting this batch and receiving this error message.  This is extremely frustrating and any insight would be appreciated.

*This post is locked for comments

I have the same question (0)
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    John,

    Can you please print your Edit List before posting and check if you get any clue for your error .. !!!

     

    Thanks
    Sandip

  • K Day Profile Picture
    K Day 7,365 on at

     Why don't you print the batch edit list first and it will tell you what is missing.  The little printer icon on the batch window. 

     What are your distributions supposed to be?  Credit Sales, Debit A/R, Credit Inventory, Debit COGS.

    Is that what it says in the Distributions section of the invoices you are trying to post?  

     Are you using the Accounts from the Customer or from the Item?  This is a setup option.  Are you selling inventoried items or non-inventory items? 

     Let us know a little more information and we can help troubleshoot.

     

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Of course, the error messages are generated because the transactions being posted have missing account numbers.  You need to edit the batch and correct these to get the batch to print.  Populating the posting accounts is the proper way to prevent the message but the system copies the account numbers from the setups to the transactions.  Once the transaction is created, it holds the account numbers as they were at the time they were created.

    1.   Edit the transactions and edit their distributions to fix the batch that will not post.

    2.  Double check your setups (including account numbers in customers and items) to make sure the correct and valid accounts are listed.  BTW, if the transactions are generated in SOP, check the SOP setup to identify whether accounts are being pulled from the customer or from the item.

    For more help, I can suggest our Information Flow and Posting manual which maps each transaction and the source of its account numbers.  Check it out on our web site! www.AccoladePublications.com

     

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus on at

    hi john,

    is this still an issue after the above resolutions?

  • Community Member Profile Picture
    Community Member on at

    Hi,

    Changing the set up of posting accounts at this stage will not update existing invoices. However it will obviously be good for future invoices.

    On a SOP invoice, distributionds are at two levels...the overall Invoice level (the Distributions Button at the bottom of the SOP entry window)...but also at a line level (Click on a line, and then click on the Blue Arrow to open the Item Detail Entry window....here also GL Distributions are detailed (distributions for Inventory, COGS accouns etc.).

     I suspect that it is at this level that you are missing GL distribution accounts. It could be on all lines on every invoice, or it could be just one line on an invoice. As suggested, print the Batch Edit List to find out for sure.

    If you can find a pattern, you might be able to write a macro that will update all of the problems, otherwise you are looking at doing it manually...eah line on each invoice. Again if the problem is here, it is most likely that you are taking your distribution accounts form the Item Record...and an item / or items did not have fully completed default distributions at the time you entered the invoice.

    Best regards,

  • John Horner Profile Picture
    John Horner 175 on at

    Thanks Ian, you nailed it.  It looks like the client updated the item default distribution accounts after entering the invoices.  Fortunately there were only 9 invoices so it was easy to update.  Appreciate everyone's quick insight and thoughts on my issue.  Much appreciated.

  • Suggested answer
    Brock Gourlay Profile Picture
    Brock Gourlay 5 on at

    UPDATE SOP10200 SET XXX = YYY WHERE SOPNUMBE=ZZZ

    Notes

    Replace XXX with one of the following field names for the index field:

    INVINDX

    CSLSINDX

    SLSINDX

    MKDNINDX

    RTNSINDX

    INUSINDX

    INSRINDX

    DMGDINDX

    Replace YYY with the account index number in the GL00100 table.

    Replace ZZZ with the invoice document number.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans