Default Offset Bank Account Missing on Certain Centralized Payment Proposal Lines

(0) Share

Report

Posted on by howalker

1,212

My client is using 2012 R2 CU6 centralized payments to pay vendors on behalf of multiple legal entities out of one legal entity LE#1 using bank account BT. In the payment proposal that is created on LE#1’s books, the offset account type ‘bank’ populates along with the account 'BT' for all invoices posted to LE#1, LE#2, and LE#4. The account BT does NOT populate for any invoices belonging to LE#3. I have reviewed all sorts of configuration and cannot find what is causing this hole.

(1) It is not in LE#1’s APPay journal name. That has a default bank account BT set up.

(2) It is not in the method of payment. Both ACH and Check have BT specified in the default of the General FastTab, Posting group. This is consistent for both LE#1 and LE#3, but not LE#2, yet LE#3 is the problem.

(3) I see nothing wrong with intercompany accounting since all legal entities have relationships set up with each other with valid main account numbers present.

When a payment proposal is generated from within LE#1, the client has to go to each LE#3 line and insert the offset bank account of BT. Some days there are many payments to touch. Where is the hole? What am I missing?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Default Offset Bank Account Missing on Certain Centralized Payment Proposal Lines

Hi Howard,

You can check the Org hierarchy, the GL intercompany accounts and relationships in GL.

In addition make sure that they share the same address book ID.

Another typical issue is that names \Id's don't match. For details also check the following points

technet.microsoft.com/.../gg230990.aspx

Best regards

Ludwig

Was this reply helpful? Yes No
howalker 1,212 on at

Like (0)

Report

RE: Default Offset Bank Account Missing on Certain Centralized Payment Proposal Lines

Thanks for your response. I have checked all your suggestions. I haven't found anything wrong. The intercompany accounting config appears to be set up properly. I don't see anything wrong with the main accounts. The vendor records I checked are all tied to the same party ID / address book ID. The names of the vendor records I checked match each other. I had already seen the link you posted for setting up centralized payments. I don't see anything to set up there. I don't get it.

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (0)

Report

RE: Default Offset Bank Account Missing on Certain Centralized Payment Proposal Lines

Is Bridge posting checked by accident on the Method of payment in LE#3?

As a further clue, when the customer has to populate the BT bank account, is the offset account type Ledger (and must be switched to Bank) or already Bank?

Was this reply helpful? Yes No
howalker 1,212 on at

Like (0)

Report

RE: Default Offset Bank Account Missing on Certain Centralized Payment Proposal Lines

Bridge posting is not turned on in the method of payment. These are vendor transactions, not customer transactions, so I'm not populating any customer transactions in to this payment proposal. However, in this vendor payment proposal, the bank offset account type is defaulting properly.

Was this reply helpful? Yes No
Paul Crabb 105 on at

Like (0)

Report

RE: Default Offset Bank Account Missing on Certain Centralized Payment Proposal Lines

Hello Howard,

Did you find a solution to this issue? I'm seeing something similar and don't see any configuration differences.

Thanks,

Paul Crabb

Was this reply helpful? Yes No
howalker 1,212 on at

Like (0)

Report

RE: Default Offset Bank Account Missing on Certain Centralized Payment Proposal Lines

No, I never did figure out why this was happening.

Was this reply helpful? Yes No
Paul Crabb 105 on at

Like (1)

Report

RE: Default Offset Bank Account Missing on Certain Centralized Payment Proposal Lines

Howard, thanks for confirming. I'll post the solution here when we find it.

Thanks,

Paul

Was this reply helpful? Yes No
Suggested answer

Syed Fasih 2,442 on at

Like (0)

Report

RE: Default Offset Bank Account Missing on Certain Centralized Payment Proposal Lines

Paul,

My 2 cents, please make sure about the following:

1. Make sure that the Legal entity whose invoice is being paid, falls under the paying legal entity in the organization hierarchy setup with purpose centralized payments

2. Make sure that the invoice posted in the original legal entity has a method of payment specified on it. Sometimes, the invoice gets posted without a method of payment. This can result blank offset account when creating payment proposal.

Let me know if this resolves the issue.

Was this reply helpful? Yes No