Share
Report
10I have a client running on BC19 on-premise US and have discovered inaccuracies in some of the finance charge memo amounts calculated by the system, or at least they believe it do be inaccurate. In the below snippet, we have the two relevant entries from the detailed customer ledger entry table. Any assistance in explaining how the system gets the amount would be appreciated.
The output for the finance charge amount from the system is $108.98.
This is the piece of code I debugged in the Finance Charge Memo Lines table to figure out how the system calculates the amount.
BC does the calculates this in a strange way when compare to the MS documentation but it may make more sense to you:
1. We get this accumulated amount: difference between date of initial entry of invoice vs. May 9th 2024 (760 days) * Initial invoice entry amount $667.30 = $507,148
2. We get this accumulated amount: difference between date of application of the credit memo vs. May 9th 2024 (217 days) * Credit memo entry amount -$443.96 = -$96339.30
3. The difference between #1 and #2 outputs = $410808.70 which is then run through this calculation: ($410808.70 / 30) * (79167/100) = $108.40. BUT WE ARE STILL OFF BY $0.58. See further down.
Somehow when BC calculates the difference between the credit memo posting date and today's date it gets 212.112 days...... I have no clue how and I can see the dates in the code to confirm that the output is created by 05/10/2023 (dd/mm/yyyy) - 09/05/2024 (dd/mm/yyyy). Any assistance in explaining this is greatly appreciated.
All responses (
Answers (
