Hi Nelson,

I see the problem. The items where there is more than one for the same date and amount, only the first one is being included. It is omitting the second 10/10/2021 for $33292.88, three of the 10/18/2021 for $200 ($600 total), and the second 10/18/2021 for $400.

I attempted to recreate this scenario in our sample data but the report totaled correctly. I believe it may have something to do with the Withdrawal Type that is missing on those transactions. I'm not sure how you were able to leave that field blank as it wouldn't allow me to do so.

If you edit those entries that have no Withdrawal Type and assign a Withdrawal Type, does that correct the problem? In CM Tasks > Edit Register, go to the entry, click the ...> button to open the detail window, in the Type field assign a withdrawal type.

If you want to create additional Withdrawal Types to choose from, you can do that in Custom Descriptions (from Sage Desktop > Common Tasks > File > Company Settings > Custom Descriptions). Scroll down to CM Withdrawal Type, click in the description field, then click the Customize List button. Here you can Add more types as desired.

Let me know if entering a Withdrawal Type on those entries corrects the problem or not.

April

April, I believe you have spotted the pattern and now the question is "Why does it not include the multiple entries with the same date and amount?"

  This problem has been there for a long time.  At least a year and a half.  See another sample below.  All of these transactions have "Electronic" in the withdrawal type description field, but the total is short by $1,400. The entries with the same date and amount are not included in the total. 

The report selects transactions that are

1. within the date range selected on the Print Selection window,

2. have "WDL" in the Type field, and

3. are also cleared if that box is selected on the Print Selection window.

So, I don't think the withdrawal type description field comes into play here.  Every transaction selected should be included in the total.

 As to your question regarding the absence of a withdrawal type description:  These entries are recuring invoices generated monthly in AP but our bank account is drafted for them .  We had been removing them from the outstanding invoices by selecting them for payment and printing the checks to a file, but recently started using the Generate Electronic Payments task which generates a NACHA file that we delete.  When we made that change the Withdrawal Type in CM was blank. I'm sure there is a better way to handle bank drafts.  Perhaps someone can enlighten me.

Gotcha, so the ones missing the Withdrawal Type are AP electronic payment withdrawals.

And based on the history you described, it doesn't appear to be related to a missing Withdrawal Type.

Would you be willing to call Support to open a case so we can look into this? We may need to request a copy of your data to be able to replicate the issue in order to figure out how to fix this.

We do not subscribe to telephone support.  Will Sage open a case for customers with that subscription?

Hi Nelson,

I emailed you directly.

Hi Nelson,

I emailed you directly.