Payment Wizard not selecting Cash Discount Invoices
One of our clients are running B1 8.8 , PL11. Here is the scenario:
A/P Invoice was posted on 06/18/2010 with 2P10Net30 Payment Terms ( Meaning the company gets 2 % discount if this invoice is paid with 10 days of Invoice, the invoice has a duedate of 07/19/2010).
In the step 4 of Payment Wizard ( Document Parameters), if we select priority as duedate and enter 07/02/10 in Due Date To field.
Upon confirming the payment methods in next screen, On Recommendation Report the the Invoice that is eligible for 2 % discount does not show in the wizard.
The payment terms are defined as follows:
Payment Terms Code :2P10Net30
DueDate based on: Posting Date
Days : 30
Cash Discount Name : 2P10 ( 10 days after positng date , discount % 2 on CDC1 table)
It was working fine in earlier version (SAP Business One 2007A) and now it is not. Can you please let me know if there any setting in 8.8 that is not selecting discount eligible invoices.
Note : If i change the due date to field to the 07/19/2010 which is the duedate of the invoice then the Invoice with discount show up.
I looked into all possbile ways but cannot figure out the issue. At this point i guess this is a bug, please guide me.