|
Posted by Jason on June 27, 2008, 8:48 am
Please log in for more thread options
It sounds like you have it right, but are you sure you want to trust your
cashier's manual entry as the "correct" prices?
In theory you could have the database automatically change Item.Price
whenever TransactionEntry.Price is entered where
TransactionEntry.PriceSource = 10.
>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?
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap