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

(0) Share

Report

Posted on by sueconrod

337

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

I have the same question (0)

All responses (5)

Answers (1)

soma 24,410 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

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

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

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.

Was this reply helpful? Yes No