Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

FullPrice field on TransactionEntry table

Posted on by 135

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

  • Xiaoye Cui Profile Picture
    Xiaoye Cui 135 on at
    RE: FullPrice field on TransactionEntry table

    Thanks for your suggestion, I'll try convince them to upgrade to the latest version base on all these facts.

    Cheers,

    XiaoYe

  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: FullPrice field on TransactionEntry table

    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.

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    RE: FullPrice field on TransactionEntry table

    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!

  • Xiaoye Cui Profile Picture
    Xiaoye Cui 135 on at
    RE: FullPrice field on TransactionEntry table

    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

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    RE: FullPrice field on TransactionEntry table

    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.

  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: FullPrice field on TransactionEntry table

    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.

  • Xiaoye Cui Profile Picture
    Xiaoye Cui 135 on at
    RE: FullPrice field on TransactionEntry table

    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

  • Xiaoye Cui Profile Picture
    Xiaoye Cui 135 on at
    RE: FullPrice field on TransactionEntry table

    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

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    RE: FullPrice field on TransactionEntry table

    There are some serious pricing bugs in .0105,  I would update to the latest version, 2.0.1006. if possible.

  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: FullPrice field on TransactionEntry table

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans