@Beth Bowers I heard back from Elliott who answered you question. Before I post that, Sage needs us to specify our preference - please vote option A or B
@Jeff Fiddelman @Bill Pfahnl @Andrew Hagenbach @Madeline Stefanou
A) Automatically fix PaymentsToday flag to what is currently in Cash Receipts (and AP from AR Clearing)
--OR-
B) Prompt the user with something that states something like: "Current posted amounts in Cash Receipts does not match records payments today in the Open Invoices table. Do you wish to recalculate?"
If B) Do you think a security event would be necessary so that this prompt only occurs for certain roles?
Here's the answer to why is there a Payments Today Flag:
• The purpose of the PaymentsToday field in the AR Open Invoice table is to keep track of payments that are currently being applied in Cash Receipts, but have not been updated. This will include Payments being made where the cash receipt has not yet been accepted either. Meaning that the entry is still being worked on, and the detail is still in memory, but we commit the amount in the PaymentsToday. Remember, that while you are entering Cash Receipts (or any of our data entries), that the detail lines are not physically written to a table until the "Accept" button is pressed. Until that point they are only in memory, but we record the payment in the PaymentsToday so that if a subsequent entry is made for the invoice, it will have the up to date balance.
• We realize that this flag is getting out of sync with actual entries against the invoice, and we have done a lot of research to try to resolve this, but could not find a program logic issue, but there are outside influences that could cause this. (ex – DFDM, Reinitialize Files, some sort of session drop of a workstation, customizations, custom modifications, etc.)
• It is our policy to not remove fields from tables, primarily because we have a flexible solution and do not know who is relying on the amount being updated in the A/R Open Invoice table. Customers/Partners could be using the field for reporting or customizations that we aren't aware of, so we will retain this field.
**Note: Keep in mind that there are scenarios that exist where we won't be able to 100% accurately accumulate current payments in cash receipts, due to the fact that some of the entries may be in memory still while cash receipts is in use, so won't be accessible to outside tasks. I would think these scenarios are very low occurrence, but could happen.------------------------------
Moira Goggin
Executive Director
90 Minds, Inc.
------------------------------
Original Message:
Sent: 04-20-2020 13:25
From: Moira Goggin
Subject: ARWAR4 - Sage Feedback please comment today, thanks.
That is an excellent question. Why is there a 'payments today' flag in AR?
------------------------------
Moira Goggin
Executive Director
90 Minds, Inc.
------------------------------
Original Message:
Sent: 04-17-2020 16:11
From: Beth Bowers
Subject: ARWAR4 - Sage Feedback please comment today, thanks.
So taking a step back - what exactly is the purpose of the Paid Today field? Yes, it can tell you if you're paying something twice in the same session IF you've already accepted the first entry, but if two people are entering at the same time it does you no good anyway, so.... Is there a really huge requirement I'm missing? If you didn't even use the field, would the sky fall? Would there be human sacrifices, dogs and cats living together, mass hysteria?
------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625