This Accounts Receivable question came up when our custom finance charge routine hit a snag with one Customer (snag explained below). This led me to do some analysis on our Receivables.
In our GP database, since the beginning of the current fiscal year, we've entered over 5,000 cash receipts. 4.3% of those receipts (221) have a DINVPDOF recorded in the RM20101 ( the RM Open File). (We don't archive our invoices and receipts... they're all in the RM20201 table.) That is, the DINVPDOF date is something other than 1900-01-01... 4.3% of the receipts. I thought at first that that date would be filled in whenever the cash receipt was fully applied... but that tiny percentage of receipts with DINVPDOF dates makes that theory suspect.
Two-thirds (66.5%) of those 221 cash receipts have a DINVPDOF which is different from the most recent GLPOSTDT of the invoices paid by that receipt. One would think: if the DINVPDOF for a cash receipt would be filled in at all in GP, then it should equal the GLPOSTDT of the last invoice paid by that receipt, yes? That is, once the receipt has been fully applied, the DINVPDOF of the receipt would equal the GLPOSTDT of the final invoice paid by the receipt. Doesn't that make sense?
But that 66.5% of the 4.3% of all cash receipts since the beginning of the fiscal year have that "anomaly". The question I have is, "What's the deal, here?"
1) Why is the DINVPDOF used at all for cash receipts... and
2) why do the majority of our receipts with DINVPDOF dates not match the latest GLPOSTDT of the invoices they've paid off?
This mystery surfaced with one Customer's finance charge computation. A group of invoices were all paid by the same cash receipt. The RM20201.ApplyFromGLPostDate is the same for all of these invoices: 12/12/2016. But half of the invoices have a DINVPDOF of 12/12/2016 and half have a DINVPDOF of 12/22/2016... which happens to be the DINVPDOF of the cash receipt itself.
Our A/R people are going, "Wait... what?" So am I. A beautiful LESLIE VAIL badge to whomever can explain this... and the two questions I've posed above.
THANK YOU! I am only an egg, as Michael Valentine Smith said.
Sincerely,
------------------------------
"Sparkly" Steve Erbach - Business Analyst & MS Dynamics Platform Administrator
WOW Logistics Company - Appleton, WI
Co-Chair, GPUG WI (Green Bay) Chapter
*This post is locked for comments