Topic Options
#48693 - 01/19/16 05:45 AM Error Posting Invoices
doug Offline
Doug Parrington

Registered: 07/04/05
Posts: 77
Loc: Winnipeg
I am getting the following when trying to post invoices. "distribution to receivable control are not permitted on document 365011" I get this for all invoices in batch. FYI this is the first Day End done since updating Order Entry, Receivables and Ledger to most current versions.

Doug

Top
#48695 - 01/19/16 06:22 AM Re: Error Posting Invoices [Re: doug]
Bruce Gardner Online   content
Adagio Wizard

Registered: 06/15/04
Posts: 3501
Loc: Toronto ON, Canada
Doug:

In the Receivables Company Profile there is a new setting that allows you to prevent users from posting the other side of an AR transaction to the AR control account. This is primarily a benefit with Adjustments where users would get confused and distribute to the AR control account resulting in the debit and credit both hitting the AR control account when the transaction reaches the GL.

I've seen cases where the OE Clearing account was defined to be the AR control account so that may be your situation.

To allow posting to proceed, edit the Receivables Company Profile.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#48696 - 01/19/16 06:41 AM Re: Error Posting Invoices [Re: Bruce Gardner]
doug Offline
Doug Parrington

Registered: 07/04/05
Posts: 77
Loc: Winnipeg
That was it. Thank you very much.

Doug

Top
#48697 - 01/19/16 08:40 AM Re: Error Posting Invoices [Re: doug]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
The OE clearing account should be different than the AR Control Account.
_________________________
Andrew Bates

Top
#48705 - 01/19/16 10:38 AM Re: Error Posting Invoices [Re: Retired_Guy]
doug Offline
Doug Parrington

Registered: 07/04/05
Posts: 77
Loc: Winnipeg
Andrew, our accounting person would like to know why The OE clearing account should be different than the AR Control Account.

Doug

Top
#48707 - 01/19/16 10:51 AM Re: Error Posting Invoices [Re: doug]
Bruce Gardner Online   content
Adagio Wizard

Registered: 06/15/04
Posts: 3501
Loc: Toronto ON, Canada
Doug:

The clearing account is used to ensure that both sides of the Day End process make it to the GL. The OE Day End creates a debit to the clearing account. Posting the Receivables batch (OE invoices and credit notes) creates a credit to the clearing account. The clearing account should be monitored regularly to ensure that it balances to $0.00. If it doesn't, then part of the process wasn't completed or someone edited a transaction.

If you use the AR control account rather than a separate clearing account, not only do you not have this check-and-balance, you have way too many transactions flowing through the AR control account, making subsequent reconciliations more difficult.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#48710 - 01/19/16 01:16 PM Re: Error Posting Invoices [Re: Bruce Gardner]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
Thank you Bruce.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 72 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1847 Members
5 Forums
14239 Topics
69736 Posts

Max Online: 359 @ 11/18/19 09:08 PM
May
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31