My Sales anaylis by item class (SA-M) does not match by Sales Journal (GL-D).  And I am not sure why?  (Q1)
 
In my investigation I found another problem. Someone entered new customers and had those  customer default to a specific sales account.   Our inventory items are classed....not our customers.   Most of our customers are sold items with multiple classes...allowing different deptartment to credit for the sale.    I went into MAINTAIN DATA BASE and deleted the GL accts on the customers he entered.    
BUT  I need to go into invoice history and change the product class on hte the individual line items on the invoices.   What files in MAINTAIN DATA BASE should I change to get accurate gl sales.  (Q2)
 
I don't think this would be a reason for my initial problem....or could it?  (Q3)
 
Thanks,'
Laura

No the SA-M  report  is not always correct.  
SA-M is fluid and I can make it change anytime I want even on sales posted months ago.  
 
Heres why:  One can change the class on a part# in IN-B  that had been sold  months ago  and get a different Sa-M report.    
(A)    We have 5 departments that do JOURNAL REPAIR.    Most of the time it is done by dept 400, but occasionaly another dept does it)   So if dept 200 does it on June 1  we go into IN-b and change the product class to 200.   Then if dept 400 does one on June 15th  we go back into IN-B and change the class to 400.    
 
This works great on the GL side...The  sale gets posted to the correct GL account.   But the SA-M always gives the sale to the last class on the part#.  (even if you change it months later)  
 
I experimented and found that I could change the class on a part# that we shipped months ago.  It immediantly changes the SA-m report.    Of course changing the class n IN-B after the fact doesn;t effect a posted sale.....but it does effect  SA-m.    
 
DAMAGE:   no GL damage,  credit for the sale was posted correctly to the GL.   GL is correct...but...SA-M  IS WRONG
             QUESTION:  Shouldn't  SA-M reflect the class of the item at the time it was a posted sale ?  
 
(B)   SA-M always uses product class from IN-B  regardless what AR-A  has.     So when we sold item#1000abc that had the correct class of 300   to   customer  ACME that had the wrong  class of 400  there was confusion.  Credit for the sale went in two different directions:  
.    .     SA-A   got the class  from IN-B   ignoring  the class on AR-A
.    .       .               .        .&  
.    .     GL   got the class from AR-A   ignoring  the class  on IN-B      
 
DAMAGE:   As a result dept 300 got jipped of the sale in the GL.  & dept 400 got undeserved sales.  In this case  the GL is wrong. but SA-m is correct.    
 
( So I must go into Maintain data base and find the invetory items that we sold ACME and change them to the correct class  but i cant find the right files in maintain database to change. )