ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Quotes & Bookings Changes - FYI
http://www.istechforum.com/YaBB.pl?num=1358263358

Message started by carolg on 01/15/13 at 08:22:38

Title: Quotes & Bookings Changes - FYI
Post by carolg on 01/15/13 at 08:22:38

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.