Interest document not included as an open item in invoicing
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?
Viraj Shah replied
Finally after lots of brain storming and debugging I found the cause of the problem. We have set interest frequency of 15 days in config. So, whenever, a final invoice is created within this interval of 15 days, once an interest document has posted, system does not calculate interest using FM ISU_INV_INTEREST_ACTION, so it is not included in table DBERDL. But, once the invoice is generated and posted in FICA, at the time of clearing system calculates and posts interest document which is not included in DBERDL as it is clearing document.
Special thanks to Amlan, for taking deep interest in the issue and try to give the resolution.