Upgrade reconciliation

[agustin_marcoscividanes]

Hi,

I have a new question. I am finishing the upgrade reconciliation proccess in a customer and I have a scenario I do not know how to solve.

The scenario is:

- The customer recorded a BP in 2006.

- This BP has an invoice with 50.50u20AC for total.

- This invoice was paid by BP in 2006.

- The customer was consolidating in 2009, before upgrading to B12007.

- We upgraded the system to B1 2007 successfully.

- The upgrade reconciliation made two operations: one for the opening balance, and one RU for 50.50u20AC (the total of the invoice).

I cannot renconcile the RU.

How can I solve this scenario?

Kind regards.

Agustín Marcos Cividanes

[agustin_marcoscividanes]

Hi again,

the BP was consolidating after upgrading (I read the wrong date, sorry).

The inconstence type is Linked invoice to reconciled payment, but in this case SAP shows only the RU and not the invoice with the same total, as in the document provided by SAP.

Any idea?

Kind regards

Agustín Marcos Cividanes

[K_Pauquet]

Hi Agustin,

if the invoice was paid & the payment booked under the consolidating BP, then you could use the multiple BP internal reconciliation feature to reconcile the RU journal & the document. Please have your accountant look this & decide whether it could be a solution.

This wiki article shows the functionality of multiple BP internal reconciliation using the example of a BP who is simultaneously customer & supplier:

https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=69861411

All the best,

Kerstin

[agustin_marcoscividanes]

Dear Kerstin,

I tried but SAP shows always the same journal entries for the BP, and I cannot reconcile them.

Thanks for your answer.

Agustín Marcos Cividanes

[K_Pauquet]

Hi Agustin,

please have a look at pages 19-24 in the document

[How to Conduct an Internal Reconciliation Upgrade |https://websmp108.sap-ag.de/~sapidb/011000358700000411402007E.pdf]

which you can download from the landing page here:

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

Your accountant needs to decide what transaction the RU journal should be reconciled with. If there is no transaction, it needs to be determined whether this invoice actually HAS been paid or not & what transaction should be created to offset the RU journal.

B1 will show you all open transactions from all selected BPs when using the multiple BP internal reconciliation functionality.

All the best,

Kerstin

[agustin_marcoscividanes]

Dear Kerstin,

before posting the message I read the document. My doubt is:

- I open the reconciliation window for the BP (only this one).

- SAP shows two journal entries, one RU and another of opening balance.

- In the example of this upgrade reconciliation appears one journal entry for the invoice to reconcile. In my scenario, we do not have this journal entry.

- I searched all reconciliations for this BP and this invoice and this payment do not appear in a reconciliation.

What can I do?

Thanks for your attention.

Agustín Marcos Cividanes

[K_Pauquet]

Hi Agustin,

since the BP is now consolidated you ought to include both BP codes in the reconciliation & then choose the relevant transactions.

All the best,

Kerstin

[agustin_marcoscividanes]

Hi Kertsin,

I was working in this issue and I have:

- 30/12/2005: The customer recorded the BP

- 31/01/2006: The invoice was recorded.

- 24/04/2006: The invoice was paid (payment 3101).

- 24/04/2006: The BP was consolidating.

We upgraded the system, and RU (27773) journal opens the invoice in 31/01/2006.

I tried with my customer in a test database:

- create a journal entry. The doubt is which account we have to use.

- add incoming payment: we expect SAP shows the payment 3101, but it does not appear in the list to choose. If we choose the transaction 27773 SAP makes a journal entry and the invoice was paid twice. The BP balance is ok.

We tried to reconciliate both BP's, but SAP does not show the journal entries we expected.

Any idea?

Thanks for your attention

Agustín Marcos Cividanes

Edited by: Agustin Marcos Cividanes on Aug 20, 2009 12:22 PM

[agustin_marcoscividanes]

Hi all,

we solved this scenario because the wrong balance was in the account defined in the Period-End Closing as retained Earning account.

We reconciled the amount in RU journal entry with this account.

Solved.

Kind regards.

Kerstin, thanks for your time.

Agustín Marcos Cividanes