topic Re: Interest document not included as an open item in invoicing in SAP for Utilities Discussions

Interest document not included as an open item in invoicing

shah_viraj — Mon, 02 Nov 2015 11:30:42 GMT

Hi,

An interest document is posted while invoicing but it was not included in open item in DBERDL table. I checked in ERDB table where it shows the document type of this document is clearing document. Ideally document type in ERDB of this document should be "Print with invoice". The main sub of interest document is maintained in the configuration node of "Item selection in invoicing". Then also it does not included in DBERDL. what could be the reason?

Thanks

Viraj

Re: Interest document not included as an open item in invoicing

AmlanBanerjee — Mon, 02 Nov 2015 20:42:13 GMT

Hi Viraj,

I think the interest document was cleared by any outstanding payment on account/credit in the account maintenance run during invoicing.

Are you finding any anomalies out there in the account maintenance run?

Thanks,

Amlan

Re: Interest document not included as an open item in invoicing

shah_viraj — Tue, 03 Nov 2015 04:26:19 GMT

I appreciate your reply Amlan, but unfortunately this is not the case here. The interest document generated during invoicing is still open and not clear.

However, to my wonder, the interest document is generated as a clearing document to other open items. So, I think due to this it is not considered in print line items in invoicing. But if I want it to be considered in print line items then what to do? And how to avoid the interest document being generated as a clearing document for other open items?

Re: Interest document not included as an open item in invoicing

Former Member — Thu, 05 Nov 2015 15:58:32 GMT

Hi Viraj,

Are you doing account maintenance as part of invoicing ?

thanks,

Vikram

Re: Interest document not included as an open item in invoicing

shah_viraj — Thu, 05 Nov 2015 16:02:06 GMT

Yes Vikram, account maitenance is done during invoicing

Thanks

Viraj

Re: Interest document not included as an open item in invoicing

AmlanBanerjee — Fri, 06 Nov 2015 15:33:28 GMT

Hi Viraj,

Is zero clearing happened for the interest document?

You can check that, if you take the interest document and go to DFKKOP, you will find two line items against the document number. One with clearing status with blank containing the full amount and another with clearing status as 9 with the amount field as 0.00

Also can you send me the screenshot for the Config. node 'Item Selection in Account Maintenance/ Define Sub-Items' where in you have maintained the main/sub tr for the interest document.

Thanks,

Amlan

Re: Interest document not included as an open item in invoicing

shah_viraj — Sat, 07 Nov 2015 05:36:06 GMT

Thanks Amlan for your interest in my solving my issue.

I checked in DFKKOP, there is only one record in DFKKOP when I passed interest document number in DFKKOP-OPBEL which is a non zero item with clearing status not equal to 9. Also, when I passed interest document number in DFKKOP-AUGBL, I get more than one records which are cleared.

Please find attached screenshots.

Thanks

Viraj.

Re: Interest document not included as an open item in invoicing

AmlanBanerjee — Mon, 09 Nov 2015 12:06:12 GMT

Hi Viraj,

Checked your screenshots and so if the Interest document that is getting generated during invoicing is clearing some of the Open credits (even if its partial), then it should have a clearing document type as C in ERDB table.

In table DBERDL,I think you will have this document under the line item type 'ACCMNT' and the field 'Line Item posting relevant' will be blank.

Please revert back if your thoughts differ.

Thanks,

Amlan

Re: Interest document not included as an open item in invoicing

shah_viraj — Mon, 09 Nov 2015 15:22:46 GMT

Hi Amlan,

Here interest document is not clearing open credits, it is actually being passed as account maintenance document. If you look at the screenshot that I have attached once again here, it has both credit and debit document which are being cleared when I pass interest document in DFKKOP-AUGBL.

Moreover, Yes it is having document type C in ERDB.

But, when I passed interest document number in DBERDL-CA_OPBEL, I did not get any entry in table DBERDL.

Re: Interest document not included as an open item in invoicing

AmlanBanerjee — Tue, 10 Nov 2015 20:36:05 GMT

Hi Viraj,

Is the genuine interest document getting posted during invoicing in the first place?

If there is an interest document getting posted during invoicing as per standard functionality, then you will have a new line item type INTDEB. Is it happening?

Moreover, have you maintained the following configuration-

IMG--> SAP Utilities --> Invoicing --> Invoice Processing --> Item Selection in Invoicing --> Item Selection in Account Maintenance/ Define Sub-Items

In the part "Item Selection for Bill Printout (Subitems)" you'll find the field "Int".

This needs to be ticked for combination of Clearing type, Clearing category, Main Tr. and Sub Tr. as well for calculating interest during invoicing

The interest functionality during invoicing happens in the FM,ISU_INV_INTEREST_ACTION.

If the processing of the FM is working fine, then it should generate a interest document with line item type INTDEB.

Hope it helps...

Thanks,

Amlan

Re: Interest document not included as an open item in invoicing

shah_viraj — Sat, 14 Nov 2015 04:56:32 GMT

Hi Amlan,

I checked the configuration, int field is ticked. But as you said I couldn't find any line item posted with line item type INTDB.

Thanks

Viraj

Re: Interest document not included as an open item in invoicing

AmlanBanerjee — Mon, 16 Nov 2015 10:47:03 GMT

Hi Viraj,

Have you checked whether the FM, ISU_INV_INTEREST_ACTION, is getting triggerred during the invoicing run?

You can put a breakpoint and check of the same during the generation of Invoice through EASIBI.

FM,ISU_INV_INTEREST_ACTION, does all the checks and then posts the interest document by calling the FM, FKK_OPENITEM_POST_INTEREST_DOC.

I think you will be able to find it out by debugging this FM.

Thanks,

Amlan

Re: Interest document not included as an open item in invoicing

shah_viraj — Tue, 17 Nov 2015 05:06:57 GMT

Hi Amlan,

The case which I have posted here is of Production server. Some how, this issue does not come up every time, so I am not able to re-generate the scenario in Quality server to debug the FM.

Thanks

Viraj.

Re: Interest document not included as an open item in invoicing

shah_viraj — Tue, 17 Nov 2015 07:13:39 GMT

Moreover, I found that interest document has origin key R4(Invoicing) instead of 29(Interest Posting). So, I think it is not posted with FM ISU_INV_INTEREST_ACTION.

Thanks

Viraj

Re: Interest document not included as an open item in invoicing

AmlanBanerjee — Tue, 17 Nov 2015 13:21:20 GMT

Hi Viraj,

As per my knowledge goes, if any document is posted during invoicing, it will have an origin key R4.

This applies for posting interest document through standard Configuration or through enhancement in event R402.

The issue that you are facing,is it a one-off issue? or there are quite a lot of accounts which are having this same scenario.

Moreover, if you are not able to replicate the same in QA, I would recommend you to raise an OSS for SAP team to check .

Thanks,

Amlan

Re: Interest document not included as an open item in invoicing

shah_viraj — Wed, 18 Nov 2015 04:29:01 GMT

Hi Amlan,

Other interest documents which are posted with invoicing and not having this issue is having origin key 29.

Yes this issue comes in mostly final move-out invoicing only. I have raised parallel to SAP also.

Thanks

Viraj

Re: Interest document not included as an open item in invoicing

shah_viraj — Wed, 18 Nov 2015 04:35:39 GMT

Also, Amlan if you check code of FM ISU_INV_INTEREST_ACTION, in CALL FUNCTION FKK_OPENITEM_POST_INTEREST_DOC , I_HERKF is passed as '29' constant. So, document posted with ISU_INV_INTEREST_ACTION must have origin key 29 only.

Thanks

Viraj

Re: Interest document not included as an open item in invoicing

shah_viraj — Mon, 30 Nov 2015 14:09:05 GMT

Hi Amlan,

I raised OSS, but SAP replied me that there is no issue with standard program

Thanks

Viraj

Re: Interest document not included as an open item in invoicing

AmlanBanerjee — Mon, 30 Nov 2015 20:58:18 GMT

Hi Viraj,

Have you checked if there are any implicit enhancements which have been developed previously are responsible for the issue.

I think, you have to replicate the issue in QA first and then take it from there.

Thanks,

Amlan

Re: Interest document not included as an open item in invoicing

shah_viraj — Fri, 04 Dec 2015 05:13:42 GMT

Hi Amlan,

I tried to reproduce the case in QA system, but I failed. Every time I generate a final move-out invoice, it calculates interest and post it in DBERDL table also, but in production it does not happen.

Thanks

Viraj.