Customer Ageing - unreconciled Item

[Former Member]

Hi all,

Anyone have any idea how to handle unreconciled item in customer ageing (i.e. Journal entry, partial payment etc)? right now I'm using Journal posting tab.

Thanks in advance.

uddin

Edited by: Muhd Mahyuddin Zakaria on Jul 15, 2008 1:08 PM

[former_member187989 · Accepted solution]

muhd,

When you run your ageing report by journal entries, B1 will show you the full amount as due for all partially paid invoices & also, in another row, the actual partial payment. This is due to the 2 different reconciliation engines. You need to manually reconcile the invoices with the partial payments, then they will no longer appear in the ageing by journal entry.

To determine which payments belong to which invoice, you could run the report by marketing documents. There B1 will show you the remaining outstanding amounts only, from which you can deduct the payment(s) & then reconcile the correct documents.

As a rule, SAP recommends to only run the ageing reports by journal entry.

If you are looking for more info on reconciliation, please have a look at the IRU landing page:

http://service.sap.com/~sapidb/011000358700000380562007E

Hope it'll solve the problem.

Jeyakanthan

[Former Member · Accepted solution]

Hi

Thanks for your reply. I think it very useful. right now, i'm using version 2005 A SP01 PL 45, which reconciliation engine still remain. How to handle this using this version? The reason we do not upgrade 2007 version and remain 2005 A version because I have customize module for shipping (maybe it will effect a lot table) in system.

Can you tell me how to reconcile it? I failed to reconcile it. I'm appreciated your helps.

Thanks in advance

uddin

Edited by: Muhd Mahyuddin Zakaria on Jul 15, 2008 5:21 PM

[K_Pauquet · Accepted solution]

Hi Uddin,

you need to go to Banking -> Automatic Reconciliation -> select BP code -> select 'Internal' -> make sure the box 'Display Transactions reconciled by the system' is NOT ticked & click on 'Reconcile' -> select the appropriate transactions on the debit & credit side -> draw them into the lower matrix -> click on 'Reconcile'.

All the best,

Kerstin

[Former Member · Accepted solution]

Thanks, I did remove unreconciled item. This issue is consider resolved.