Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GL Posting Error: Splitting A/P accounting into 3 distributions

Posted on by 335

Accounting has decided that they want A/P to be split up to reflect our 3 lines of business.  So, when creating an entry into A/P they list the db to the expenses but also break out the credits to the LOB as well as it hits the 3 separate A/P accounts.  This has been working and when the check is cut it should also db out the same way which has been working.  

Recently had a check cut that instead of hitting the 3 A/P accounts for the following:

1000-10-0000     Cash                                                      781,538.59

2000-10-0000     Pay                         101,600.02

2000-70-0000     Pay                         508,000.08

2000-80-0000     Pay                         171,938.49

Hit it instead as below:

1000-10-0000     Cash                                                      781,538.59

2000-10-0000     Pay                                                        570,365.04                        

2000-70-0000     Pay                      1,010,042.94

2000-80-0000     Pay                         341,860.69

Although it balances, this does not at all equal the voucher. which is below.

2305-10-0000     PURCH                  101,600.02                                  

2000-10-0000     Pay                                                          101,600.02

2305-70-0000     PURCH                  508,000.08

2000-70-0000     Pay                                                          508,000.08

2305-80-0000     PURCH                  171,938.49

2000-80-0000     Pay                                                          171,938.49

Is there anyone else out there that is using more than one A/P account running into this issue.  

On other postings it works perfectly, and Accounting is saying that no one went into the distribution and made any changes.  And there were no interruptions on the posting.

*This post is locked for comments

  • soma Profile Picture
    soma 24,406 on at
    RE: GL Posting Error: Splitting A/P accounting into 3 distributions

    Hi Lessie,

    If I'm reading your points as right, we are not said "we didn't change the distributions on the payment". We have mentioned, no automatic distribution accounts allocation available for 3 line of AP accounts. We can change the distributions on the payment with 3 line of AP accounts with a manual distribution entry process.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: GL Posting Error: Splitting A/P accounting into 3 distributions

    Hi Susan,

    If I'm reading this right, everything was OK with the original entry - the debit accounts were fine and the credit accounts went to multiple AP accounts. When you printed the check for the payment, things got out of whack. Is this right? Everyone swears they didn't change the distributions on the payment, but it is wrong.

    I cannot make this happen. When I pay the invoice, it removes the amounts from whichever AP account I used on the original posting.

    Kind regards,

    Leslie

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GL Posting Error: Splitting A/P accounting into 3 distributions

    If the split is based on percentages and is always the same you could set up an AP allocation account. Otherwise, as Soma, says a customization would be required.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: GL Posting Error: Splitting A/P accounting into 3 distributions

    This has to be done manually. There is no configuration in Dynamics GP which will provide three distribution lines for an AP account.

    Unless you have customization

  • soma Profile Picture
    soma 24,406 on at
    RE: GL Posting Error: Splitting A/P accounting into 3 distributions

    I think, this should be manual distribution entry process made by the user. Without manual process, this will never happens in GP.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans