Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Payment journal posted transactions - Dimensions behavior

(0) ShareShare
ReportReport
Posted on by 92

Hi,

We noticed what seems to be a standard D365 behavior for both Vendor and Customer Payment journals and wondering if there's a way to turn this off. Basically, if the invoice selected to be paid is carrying Financial Dimensions, the payment journal will generate 4 transactions:

Group 1: Credit AR (or AP) summary account (no dimensions)

               Debit Cash account


Group 2: Credit AR (or AP) summary account with the associated financial dimensions that were on the invoice

               Debit AR summary account (no dimensions)

Here's our scenario, on the AR side.

- Created and posted an AR invoice# 202 for 1000 $:

Debit GL# 1101-D1-Division2 (1101 is account receivables, D1 is a Financial Dimension Department and Division 2 is another Financial dimension)

- Created Customer payment journal and selected Invoice #202 for payment:

CR Customer account

Debit GL# 1500 (1500 is Cash Account)

Since the selected invoice was carrying Financial Dimensions and given that the Customer Account doesn't have default dimensions, here are the transactions generated upon posting the Payment Journal:

Debit 1000$ GL# 1500 (Cash Account)

Credit 1000$ GL# 1101

Debit 1000$ GL# 1101

Credit 1000$ GL# 1101-D1-Division2 

Is there a way to turn off the AR in and out? The summary account without dimension is not making sense as the original invoice was hitting the AR summary account with dimensions. So the payment should just Credit summary account + dimensions. Why is it thinking necessary to add this in and out without financial dimensions. 

See screenshotPXL_5F00_20230420_5F00_043615659.jpg

  • Verified answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 16,620 Most Valuable Professional on at
    RE: Payment journal posted transactions - Dimensions behavior

    Unfortunately you cant but you may develop a solution to copy the dimensions on transaction for the payment journal

  • Y.K Profile Picture
    Y.K 92 on at
    RE: Payment journal posted transactions - Dimensions behavior

    It's for USA, but I don't think we want to enforce payment control. We want to get rid of the additional generated entries.

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 16,620 Most Valuable Professional on at
    RE: Payment journal posted transactions - Dimensions behavior

    It is not possible OOB. This is standard feature to balance the balance sheet accounts per dimensions. 

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2025 Season 1 on at
    RE: Payment journal posted transactions - Dimensions behavior

    HI,

    I know there is one localization feature around this , payment control with financial dimension. Is it for any specific country?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans