Finance | Project Operations, Human Resources, ...

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

(1) Share

Report

Posted on by Community member

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?

All responses (5)

Answers (0)

André Arnaud de Cal... 293,311 Super User 2025 Season 1 on at

Like (0)

Report

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.
Suggested answer

BillurSamdancioglu 17,153 Most Valuable Professional on at

Like (1)

Report

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.
Suggested answer

BillurSamdancioglu 17,153 Most Valuable Professional on at

Like (0)

Report

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.
Community member 4 on at

Like (0)

Report

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 17,153 Most Valuable Professional on at

Like (0)

Report

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

Hi,

Unfortunately this is not possible out of box.

Community site session details

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

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates