Avoid Syncing Future Invoice and is Pending Invoices

ISSUE : 

Future Invoices and the pending invoices should not be synced from Quickbooks to Salesforce

SOLUTION :

Go to ‘Invoice to Asset’ process in DBSync and in the validate row add the below mappings and save

{

String isPend = VALUE("IsPending");

String dt = (java.time.LocalDate.now()).toString();

java.util.Date txnDate = new java.text.SimpleDateFormat("yyyy-MM-dd").parse(VALUE("TxnDate"));

java.util.Date decDate = new java.text.SimpleDateFormat("yyyy-MM-dd").parse(dt);

LOG(dt);

System.out.print(dt);

if(txnDate.after(decDate) && (isPend.equalsIgnoreCase("true") ))

{

return "false";

}

return "true";

}