One of my client has problems with discount amount which is showing on the discount report and receipt. When I look into it, it seems the Fullprice field on TransactionEntry table is not populated correctly, it happens when there is a discount for the item.
This is an example on a store database, the Price field on item table for Item A is 4.99, the FullPrice field is 5838.19, Price is 0, Quantity is 1 and DiscountReasonCodeId is 37 on the TransactionEntry table.
From what I'm understanding, RMS should populate FullPrice field with the Price field on item table when transactions happen.
I will be really appreciated if someone explain how RMS populates FullPrice field on TransactionEntry? or is this a known bug for RMS Version 2.0.0105?
Thanks & regards,
XiaoYe
*This post is locked for comments
Thanks for your suggestion, I'll try convince them to upgrade to the latest version base on all these facts.
Cheers,
XiaoYe
Agree with Jeff.
Xiaoye, if You want to convince the customer or to take yourself out of doubts, try this next, install customer RMS implementation but with the latests hotfix version on a separate machine and restore one of the store databases where You have the TEntry table problem. Then do some example sales with the Items you've identified and check if the problem is still there?? Surely, You will know what to do after you have the results...
Regards, A.
Hmm, so a company with 50+ stores, doing millions of dollars a year in sales cannot afford to keep their POS program up to date for $.53 per day, per lane for the least expensive Maintenance offering?
Don't forget that its even more expensive if they let their Maintenance lapse!
Hi Antonijo & Jeff,
Thanks for your replies.
I have checked the query which inserts the record to TransactionEntry table using the SQL profiler at the beginning, the query is using the actual value as parameter, so I'm not able to track down the source. I'm pretty sure there is no customization on that part of RMS.
For this client, we have 5 customization add-ons on HQ and store, like customize report library, customize purchase order application, mail order application and customize EFTPOS application. They have 50+ stores and some add-ons from other company as well. The cost of upgrade RMS could be really expansive for the client.
We have suggested them to upgrade to the latest version of RMS, not only because all the bugs with current version and that version is not compatible with Windows 7, as they want to move from Windows XP to Windows 7. They are currently reviewing the cost of upgrade.
Regards,
XiaoYe
Let me give you a reason to update from .0105, going from memory; open an item, note the price and/or cost and OK it.
Now open another item with a different price and/or cost, note it and click OK. Now the price and/or cost of the second item, is the same price and/or cost as the first item.
The only what to stop this with .0105 is to click cancel or the red X, which most people don't remember to do.
Understand that they are almost 70 hotfixes behind.. This 2.0.0105 version was released almost 7 years ago, Nov 2006.
Hi there.
If you can't update as Jeff suggested, before doing a trigger, I would investigate more on those Items and the stores where this is happening.
You are mentioning there are a lot of add-ons, maybe some of the add-ons is provoking this. Another idea, I would definitly put some SQL Profiler over the database and see all the SQL queries that are ejecuted over the TransactionEntry table, just to make sure it's not something outside standard RMS... What add-ons are You using?
Regards, A.
Hi Jeff,
Thanks for your reply.
After I go through everything again, I guess you r right, it could be a RMS bug. Since update is not an option for this client, I may create a trigger on that table to fix the data.
Regards,
XiaoYe
Hi Antonijo,
I really appreciate your detailed explanation.
I go through the database and item detail again, it seems everything is normal and it only happens for few items on particular stores, I guess like Jeff said it could be a bug on that version.
Since there are lots of add-ons for this client, update to latest version of RMS is not an option, I'm thinking I may create a trigger on the table to manually adjust the FullPrice field if its necessary.
Regards,
XiaoYe
There are some serious pricing bugs in .0105, I would update to the latest version, 2.0.1006. if possible.
Hi Xiao.
First, about how the TransactionEntry fields are filled up when a sale is performed on the POS - You should look at these next fields in the TransactionEntry; FullPrice, Price, SalesTax, Quantity and PriceSource:
- FullPrice is the full price of the Item without a discount, in the moment of Sale (not necessarly it's equal to the amount of the Price field from the Item table, remeber this master data can be changed, modified after the transaction have been executed!!)
- Price is the price of the Item in the moment of sale, that the customer is paying, after applying all the discounts or price change in the POS session
- Sales tax, obviously, is the tax ammount aplied (calculated) in the moment of sale (this value is a result of tax multiplied by the quantity sold)
- Quantity of the transaction line
- Price Source - this field, is telling You when and why the Price have been changed in the moment of sale, there are many reasons, these are the options
1 'Regular Price'
2 (If TransactionEntry.QuantityDiscountID <> 0
THEN QuantityDiscount.Description ELSE 'Quantity
Discount')
3 'Buydown Discount'
4 'Price Level Disc.'
5 'Sale Price'
6 'Disc. from Reg. Price'
7 'Disc. from Cur. Price'
8 'Cost Markup Disc.'
9 'Profit Margin Disc.'
10 'Cashier Set'
11 'Component'
12 'Price Level A Disc.'
13 'Price Level B Disc.'
14 'Price Level C Disc.'
15 'Disc. from Reg. Price'
16 'Disc. from Cur. Price'
17 'Cost Markup Disc.'
18 'Profit Margin Disc.'
ELSE 'Unknown'
Now, on your case, it looks strange indeed. If I was You, I would check on the tax for the item, then all the discounts, price levels or price limits defined over that particular Item and try to reproduce the transaction...
Hope this helps, Regards, A.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156