web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

AR-Payments received and clearing the AR (by chartfield dimension of the invoice)

(1) ShareShare
ReportReport
Posted on by 4
As a school, we use fund accounting; our general receivable main account is 1312 and we bill customers by multiple funds (such as fund 1000, 2000, 3000 etc).... this is my example:
 
Main Account = 1312
Fund = varies
Department = 00000
Location = 1701
 
I billed Customer (TEST001) Invoice# Test111 and the accounting entries were  AR 1312-1000-00000-1701 DR $500 and CR 4899-1000-00000-1701 ($500.00)
I billed Customer (TEST002) Invoice # Test 234 and the accounting entries were AR 1312-3000-00000-1701 DR $33 and CR 4601-3000-00000-1701 ($300.00)
 
When the payment is received for the two invoices - I want to be able to select INV # Test 234 and the system to know that it should CR 1312-3000-00000-1701 for $33 and DR CASH (appropriate accounts) and a CR to 1312-1000-00000-1701 for $500 and DR CASH ---
 
If there a way to do this automatically (looking to see where the invoice was booked too) without having to manually enter my chartfield dimensions of where the invoice was booked too?
I have the same question (0)
  • Suggested answer
    BillurSamdancioglu Profile Picture
    19,501 Most Valuable Professional on at
    AR-Payments received and clearing the AR (by chartfield dimension of the invoice)
    Hi,
     
    Unfortunately this is not possible out of box.
     
     
  • Community member Profile Picture
    4 on at
    AR-Payments received and clearing the AR (by chartfield dimension of the invoice)
    @BillurSamdancioglu --- do you know if anyone has built a customization for that?
  • Suggested answer
    BillurSamdancioglu Profile Picture
    19,501 Most Valuable Professional on at
    AR-Payments received and clearing the AR (by chartfield dimension of the invoice)
    Once we have made customization with our team but not that I know of anyone that generated the perfect code. It is doable but not easy to do while there are different rules to be applied. 
     
     
  • Suggested answer
    BillurSamdancioglu Profile Picture
    19,501 Most Valuable Professional on at
    AR-Payments received and clearing the AR (by chartfield dimension of the invoice)
    As a workaround, you may select some dimensions and when you settle, system will correct the dimension if fully settled payment. But it will cause some additional transactions and voucher that are the transfer balances between dimensions. İf that doesn't fully settle than the balance will stay in incorrect dimensions. So I think it is better to go with a customization.
  • André Arnaud de Calavon Profile Picture
    300,188 Super User 2025 Season 2 on at
    AR-Payments received and clearing the AR (by chartfield dimension of the invoice)
    Hi,
     
    As per the last reply from Billur, at the time the payment customer transaction is fully settled, it will create additional transactions to clear balances on financial dimensions.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 703 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 582 Most Valuable Professional

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 542

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans