Good Morning, I have an unusual business need that I'm trying to figure out how to 'trick' GP into doing. And I'm hoping someone out there is more creative than me
Here is the situation. a customer has a receivable booked at the beginning of the year. This receivable is booked on an earned basis, so the annual amount is earned monthly throughout the year. (12 documents per customer Dr AR, Cr Rec). Payments are made randomly through the year. Occasionally the customer will need money back to fund priority obligations, but the customer still owes the funds that were paid originally. (like I said odd business model)
Here is a timeline:
| Fee Amortization |
|
|
|
|
| 12/15/2017 |
$5,000.00 |
|
|
|
|
|
Earned Monthly |
Payments |
Returns |
AR Balance |
Rev Balance |
| 1/31/2017 |
416.67 |
2,500.00 |
|
(2,083.33) |
416.67 |
| 2/28/2017 |
416.67 |
|
1,000.00 |
(666.67) |
833.33 |
| 3/31/2017 |
416.67 |
|
|
(250.00) |
1,250.00 |
| 4/30/2017 |
416.67 |
|
|
166.67 |
1,666.67 |
| 5/31/2017 |
416.67 |
|
|
583.33 |
2,083.33 |
| 6/30/2017 |
416.67 |
|
|
1,000.00 |
2,500.00 |
What I'm looking for is a way to process the return where it will add back to the balance of the customer. I can change the GL distributions in the sales module but that only corrects the GL, not the sub-ledger.
I've tried Debit memos - no go as the distributions dr cash and I'm returning cash. When I tried manually changing it it errored out.
Returns - yes it does impact checkbook correctly but it does not increase the AR balance on the customer
credit memo - does not impact checkbook
So does anyone have any thoughts? I reached out to our GP partner but they don't know.
I would really appreciate any advice you have!
Thank you
Casie
