Sales value Difference In trial Balance and itemwise cost component sale report.
We have made one Sales Order through maintain sale order (tdsls4101m000) of Qty 4306 for the value of RO.3616.453 in favor of ”FACTORY CASH SALES” instated of “SHOW ROOM” (where originally should be made) We have the practice of activating SALES CONTRACT for all customers & accordingly, the value of the material is automatically generated. Whereas, for the Factory cash sales & Show room sale, no Sales Contract is made & the person making the Sale order should manually select the price for them.
In order to correct the same we made MRN against same qty and the concerned person forgot to enter the value of qty which resulted ZERO value in the MRN.
Then, So as to correct the value of SALES FIGURE we passed the SCN (sales credit note) for RO.3616.453 manually through accounts to reduce the value of SALES
but stock value is not reduced. In Sales Order History by Customer and Items session report (tdsls5401m000) and itmswise cost component on sale session report (tdsls0451m900) the value of the said qty is not effected.
As per Trial Balance(tfgld3402m000) sales values is showing RO. 54132.046. & in Sales Order History by Customer and Items session report (tdsls5401m000) the value shows RO. 57,857/195 and Itemwise Cost Component on sale session report (tdsls0451m900)
Is Showing invoice value RO.57,748.500
We are getting difference is 3616.453 in both the sessions
SALES ORDER HISTORY BY CUSTOMER & ITEM
ITEMWISE COST COMPONENT
How can we correct this difference?
For your information, We made the correct SALES ORDER in favor of SHOW ROOM to the above exact qty & value also subsequently.
Thanks in advance and looking forward to hearing help from you in this regards.