Now I have two report to calculate salesperson’s Sale(LCY) amount. But there is some differemce between the two result amount. Report 1: SUM (Customer.“Sales(LCY)”) Report 2: SUM ( “Item value entry”.“Amount”) when running the two report, they have the same data filter and saleperson code filter. Why? Does anyone know the difference between “value entry”.“Amount”(when source type is customer) and “Cust. ledger entry”.“sales(LCY)”? Thanks in advance
Sales(LCY) is the value which is your sales price that is fixed by you including your cost of sales and profit. Item value entry is only cost of the item loaded with the cost to purchase it. There is bound to be a difference if there is no difference then there is something wrong with your pricing