I have a requirement from the business on clearing open item with partial payment and show only the balance left in FBL1N.
We pay a down payment of USD 100 on 01st Jul, 2014, and get an invoice on 1st Aug for USD 200 for 30 days, effectively the invoice is due on 1st sep, I apply the advance to clear invoice on 1st sep. The issue is in FBL1N the outstanding shows USD 100 with two open items (USD 100 pmt & USD 200 as Invoice) and if subtotal with inv ref, then the subtotal shows the net of both line items. I would like to know if we can show only one line item with original document with net amount due (200-100). It gives us the real picture on outstanding against each line items.