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?