How to get data for GL with Invoice

[former_member544612]

HI Experts,

I have a requirement.

My client was posted theamount into the wrong GL in the year of 2012, now they have corrected the correct GL.

Hence they want to cancell all the G/L whcih wasa posted in the wrong GL and need to recreate new credit memo to pdate into the correct GL.

I have the list of return orders ( 1700 ), but one return order may have multiple creditmemo and need to find out the correct one which was posted the wrong GL.

I ama trying to get the daata from BKPF & BSEG, but unable to get the daata. I am giving the inputs like company code, document, fiscal year. but result like no data. but while executing simply it is giveing some data and I am able to see the docuemnt.

Please help.

Regards

Raja

[Lakshmipathi · Accepted solution]

It is really surprising that your client found 2012 posting issue only now. Ideally, after financial year end closing, when the internal audit taken place, this should have come to their notice and I wonder how come, it has been missed all these years.

Coming to your issue, why you want to validate FI tables. From SD side itself, you can correlate the billing document. You need to understand the root cause of your issue is from VKOA assignment. Hence, first check for which combination in VKOA, that G/L Account assignment is made. In standard, it starts with tables like C001, C002, C003 etc., Once you identified this, table join with VBRK and VBRP so that you will get all the billing documents / credit memo. I am not sure whether system would allow you to open 2012 now. Better discuss with your FI consultant, try to open the period in DEV and update here what is the outcome. Also have a brainstorming session with Client Finance team once you find the outcome from DEV landscape. If you want to cross check from FI tables, have a look from BSID and BSAD tables

[former_member544612 · Accepted solution]

Thanks.

My client changed the G/L account and removed that old GL hence they are changing the posting value now.

Regards

Raja

[former_member544612]

Thanks for the detail.. will contact FI.

Regards

Raja

[sanilbhandari]

Hi raja.manickam

Reversal of billing documents and creation of new billing doc/credit notes in the previous years would be a nightmare both for the consulting team and the customer. There are multiple reasons for the same:

1. Your invoices would have been paid in the bank or would have been adjusted against credit notes.

2. Your SD Data would have also flown into COPA , in case you are using some

3. The net of P&L would have been brought into current liabilities in the retained earnings.

4. In case you are in India, there would be additional tax related issues since there was a cutover from excise to GST and all reporting complications.

I believe you should consult your finance team if they really want to do this. I would suggest to pass adjustments in GL JV only for current fiscal and also update your SD GL Assignments. Additionally if you are using IFRS 15 for revenue recognition, make the required changes in BRF+ as well for revenue recoginition and posting of deferrals.

Regards

Sanil Bhandari

[NancyWang]

Hi Raja,

I think you may consider to compare the value in KONV-SAKN1 for credit memo
and analysis of account determination in credit memo further.
Then I think you may be able to find the credit memo which has incorrect GL account.

Best regards,
Nancy