I hope someone can help me understand the contents of three fields in the TransactionEntry table in RMS.
I'm trying to see if I can use data stored in these fields to correct the Price in my Item table. Two of the fields are the FullPrice and Price. It appears to me that the Price field is the price charged at the register, the FullPrice is something like the Price in Item. The PriceSource field seems to be a code that is 1 if the regular price is charged, 10 if the price is changed by the cashier and other values depending on the size of the discount applied at the register.
My hope was to use Price from the TransactionEntry table where the PriceSource is 10 to correct the Price in Item where there are errors in my system.
However, I'm not sure the fields in the TransactionEntry table contain the data I think they do.
Anyone know for sure?