"Dunned Amount" adding to "To be Collected Amount" in Udm_Specialist

[former_member608793]

Hi All,

In the Worklist Screen of UDM_Specialist the Dunned Amount is adding to the "To Be Collected Amount" which is causing a difference in the "Open Item Amount" of the Customer from FBL5N or Process Receivables list.

Now I want to know if this is a standard SAP behavior and if not then, is there a way to prevent the Dunned Amount from adding into the To Be Collected Amount?

Example:

To Be Collected Amount is 31,715.45 and Dunned Amount is 6,113.22

While in the Process Receivables or FBL5N list, there are only two Open Invoices adding to an amount of 25,602.23:

This is because the Dunned Amount of below Invoice is adding to the To Be Collected Amount:

Please let me know if any other information is required.

Thanks,

Vaibhav.

[henk_hoogerbrug]

Hi Vaibhav,

This behavior is not triggered by the dunning status, but if the document is cleared. On the worklist (invoices tab) you will see a checkbox "cleared invoices". Activate it and you will see your missing invoice(s).

Please check when the worklist is created and when the customer payment (clearing, document 1400045226) is posted. I think the worklist is created before the customer payment has been posted.

Best Regards,

Henk

[former_member608793]

Hi Henk,

Thanks for the response.

I checked the 'Cleared Invoices' option and got the list of cleared invoices.But the point is they are cleared invoices and they should not be adding to 'To Be Collected' amount as it was already collected.

And as per your suggestion I looked into the Invoice clearing date and I observed that there are invoices that were cleared even before this invoice and they are not adding to the To Be Collected amount. Please let me know if any other suggestions.

Thanks,

Vaibhav.

[henk_hoogerbrug]

Hi Vaibhav,

Please compare the following dates and times:

1. Creation of worklist.
   First open your worklist and add the field "Run id" to the layout. This will show you under which run id the worklist has been created.
   Then open transaction UDM_PRMON and select your run id and execute the report. On the first screen you will see the start time. If you double click on this line you will get the start and end time.
2. Clearing date in the document.

I guess that in your case the creation date of the worklist is lower than the clearing date of de documents. If you regenerate the worklist I guess that the amount to be collected will be correct.

Best Regards,

Henk

[former_member608793]

Hi Henk,

I followed the procedure that you described.

On the main screen of program Udm_PRMON I gave parameters, RunID: 1811(run ID of the worklist) and in Program with parallel processing I selected "Create Worklist" from the dropdown.

Oddly it gave 05/22/2015 as start and end date.Now as almost all of the invoices are cleared before this date including the invoice added to be collected amount, I don't know what to make of this result.

Stuck here.Can you make any sense of this?

Thanks,

Vaibhav

[henk_hoogerbrug]

Hi Vaibhav,

Have you also executed transactions FDM_COLL_SEND01 and FDM_INV_MEM? (after clearing the invoices and before creating the worklist)

If yes, please check the logs of these transactions or re-run them for this particular customer (to create a small log and see what happens).

Best Regards,

Henk