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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Posting Account Setup

(0) ShareShare
ReportReport
Posted on by

Is it necessary to add a distribution account for every account listed in the posting account setup window ? 

I'm currently trying to post transactions and I'm receiving the error message " Distribution account (s) are missing or invalid." 

Also, if you've setup posting at the company level, but you also have posting at the account level, which wins? Is there a setting to default to company if no information is provided on the customer account? 

Thanks!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    babubaskaran@outlook.com Profile Picture
    12 on at

    Hi,

    You haven't mention what type of transactions you are trying to post.  Based on the transactions the posting account will come from respective cards, if you are posting sales transaction the account will come from customer which depends on receivable setup.  No matter what type of transaction you are posting all transactions should have distribution account filled in otherwise you will get the above error.  Please click here to see community post.  If you post a sales invoice and financial entry not posted then receivable wont match to general ledger balance.

  • Verified answer
    soma Profile Picture
    24,410 on at

    Posting Account Setup window is used setup the default posting accounts for each module based on the transactions we are going to post in GP.

    Normally, system will check posting accounts based on the master records first, then the it will check the posting account setup window if the master accounts are empty.

    For example,

    If you are trying to post any payable transaction, we should mention the payables and purchase (expense)accounts. So, some organization they want to maintain the payables and purchasing based on each vendors (for this case we can use vendor account maintenance window to setup the posting accounts for each vendor, we no need to setup the accounts in posting accounts setup window) and some organization just want to main all payable and purchase in common account(for this case, we can use posting account setup window to setup the same).

    Hope this helps!!!

  • Verified answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    Hello Kimberly

    Designing the configuration of the posting account in your company is not one setup that is unified across different businesses. That's for one fact, different businesses have difference cases and requirements which in term implies specific type of configuration.

    Allow me to elaborate by bringing in a simple example as derived from a real-world business case study. In inventory module, items and general ledger accounts must be linked in order for transactions to be recorded on both sub ledgers and general ledgers in the correct manner. For such topic, you may wonder whether to include the inventory account on the item level (specifically related to this item) , site level (specifically related to this sites regardless of the items), or posting setup level (which is a general setup shared across all items, sites)
    The answer would simply be, how do you want to see the inventory balance on your balance sheet ? Are you a manufacturing company which has finished goods, raw materials and semi finished goods that should be reported separately on the balance sheet under an inventory category ? as shown below"


    Assets 

    ..

    ...

    Inventory

    Finished Goods

    Raw Materials

    Semi Finished Goods

    Or you are a retailer which sells the same items from different locations, which shall be reported separately on your balance sheet as shown below:

    Assets 

    ..

    ...

    Inventory

    Location A

    Location B

    Or you simply want to report all your inventory items under one simply category and want them all to be linked to one inventory account on the general ledger level ?

    Assets 

    ..

    ...

    Inventory

    In case one, item-account assignment is preferable to be done on the item level. While case two would require site-segment feature which link accounts on the site level and finally the third case would go just fine if you include your inventory account on the posting setup level for all items to be assigned.

    The same case applies to your customers (as related to the AR account, revenue ..etc) vendors (as related to the payable account, expenses ...etc), checkbooks and fixed assets.

    Therefore, when you have a clear understanding for your business and a clear view, GL accounts assignment can be made to meet your requirements in a way that data-entry is easy and errors-free.

    If you have a specific case which you are wondering about, you may kindly share and we will provide any relevant assistance accordingly.

    Furthermore, if you are willing to take an overall look at your posting setup account on all levels of the system, check the view provided on posting account - SQL Script

    Your feedback is highly appreciated,

  • Suggested answer
    Bill Campbell Profile Picture
    12 on at

    Well done on this Mahmoud, you have answered in great detail and made a very complex problem appear very straight forward.

    Bottom line, the posting looks at all levels of 'defaults' and it starts at the lowest level - ITEM - CUSTOMER Card first, then the POSTING Accounts in the Admin Setup.

    So, simple answer to your question is 'no you dont need to fill in all the accounts' but as noted if you miss an account, then you get the error.  Be careful.

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans