Subject: Quote and Booking changes indistinguishable from one another in ISARCHG
 
Description:
We are having an issue with EVO. When we try to pull changes in bookings for reporting purposes, we sometimes get changes on quotes whose quote #s overlap with SO #s. In other words, if changes are made to a quote, the change is stored in ISARCHG, however Booking changes are also stored in this table and we have found it difficult to discern between the 2 if both a quote and booking exist with the same #.
 
The query we are using is as follows:
SELECT BKARINV.BKAR_INV_CUSCOD as Customer,  
     sum((ISAR_CHG_BOOQTY * ISAR_CHG_BPRICE) - (ISAR_CHG_AOOQTY * ISAR_CHG_APRICE)) as Change  
    from ISARCHG  
     inner join BKARINV on ISARCHG.ISAR_CHG_SONUM = BKARINV.BKAR_INV_SONUM  
    WHERE ISARCHG.ISAR_CHG_SONUM > 0 and ISAR_CHG_CDATE between ... and ...  
 
We have resolved the problem by changing the start numbers for our sales order to be farther in the future; as we do not have a large amount of daily quotes. But above is an FYI.