web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / QuantityDiscountID
Microsoft Dynamics RMS (Archived)

QuantityDiscountID

(0) ShareShare
ReportReport
Posted on by Shane O' Malley 388

Hi,

I was trying to do a report of sales where a particular Quantity Discount was used and saw that the field QuantityDiscountID was being filled out in the table TransactionEntry in HQ.  When i went to analyse the data i found that the field contained the ID held in the store for that quantity and not the HQ ID and the table QuantityDiscount did not provide mapping.

Does anyone know how i would map back to the HQ ID for that discount?

Thanks



Shane

*This post is locked for comments

I have the same question (0)
  • raelhefn Profile Picture
    raelhefn on at
    RE: QuantityDiscountID

    when TransactionsEntry uploaded to HQ it gets ID from DiscountQuantity HQ table on transactionentry so no required to match store value to HQ value.

    try to synchronize and upload data from stores from old date and check what will occur in HQ transaction.

  • Shane O' Malley Profile Picture
    Shane O' Malley 388 on at
    RE: QuantityDiscountID

    Hi Ramy,

    We did that when we set up the quantity discounts and done it since and it remains wrong.  Two stores are the same and one is not.  

    IE.  

    In two stores the local ID for the discount is 9 and it maps it to HQ ID of 11

    In one store the local ID is 12 and maps to HQ ID of 11

    In the HQ TransactionEntry table it uses the Store local ID  ( 9 or 12)

    In all stores there are only 7 discount entries.  Is i knew of a table in HQ that mapped the store produced discount ID to the HQ produced discount ID then i would be able to translate and report.

    Even if all the store held DiscountQuantity tables were identical i would still need to map them to HQ ID's to report on them. ( Need to identify all the sales where a particular discount scheme was used)

    I suspect i am missing something a bit obvious.

    Thanks

    Shane

  • Suggested answer
    raelhefn Profile Picture
    raelhefn on at
    RE: QuantityDiscountID

    You need to synchronize your store with HQ Because the discount scheme should be used uniformly by all stores. if you are run worksheet Style 202: Update Inventory - Quantity Discounts. This worksheet will mirror the discount scheme in the Headquarters database to the specified stores. Headquarters Client verifies that the store database contains all the discount schemes defined in Headquarters.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans