Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I need to apologize for what is maybe a basic question as I am completely new to MS Dynamics AX 2009. We have goods on stock at average CoS. Our Product Management agrees that we will receive rebates on products when we sell those. Rebates may be conditional and/or limited. As an example, the vendor/supplier will agree to grant us extra 20.- rebate per unit for a certain period (say from May 1st to May 30th) for max 1 000 units of SKU 123 In the standard process when we sell SKU 123 the system will book average CoS. This triggers all kind of issues: a) the system margin is incorrect b) admin will have to manually record sales with such rebates and then charge those to the vendor/supplier. Is there any process / flags that can be used / set to automatically trigger the CoS override at order level?
What is the exact costing valuation setup on the item model group? What exactly do you want to achieve? Do you want to directly relate sales margins to fully reduce the vendor rebate?
What you describe sounds related to the vendor rebate feature that was introduced in AX2012.
Please see: mbs.microsoft.com/.../Vendor_rebates.pdf
Can you tell us more about the nature of this rebate and whether it really impacts your COGS that you can assign to a specific product?
As an example, if you sell a specific product in June, will you still get the $20 rebate if you bought the product in May from the vendor?
How can you vendor control how much he owes you if he does not have insights into your sales?
thank you for yor answer.
The nature of the rebate:
The rebate will always be applied after we have the goods on stock.
The rebate may be limited by the following dimensions (and / or conditions):
Maximum quantity in units
Maximum total rebate amount
As an example the Vendor grant you the following (highest complexity level):
I will grant you $20 on SKU 1234 sold to Customer Group XYZ in the period from May 1st to June 30th with a total maximum amount allowed of $ 20.000
To answer your questions:
Indeed COGS are impated (lowered) on a sepcific SKU (product)
We will receive (claim) $ 20 in June when we bought (and received) the product in May
The Vendor will receive Sales Out Reports as a proof that we send with the claim / debit note
Many thanks for the feedback.
I don't see a standard functionality in the 'old' AX2009 system that could handle your requirement.
In the newer AX2012 / D365FO systems there are some standard functionalities - such as the vendor rebate feature - that can handle a part of your requirement. What will, however, also be a challenge there is the adjustment of the COGS.
If you need this process fully automated, I only see the way of making a system modification.
thank you for your answer
I take that we need to make system adjustments
I will o and see my IT boys
Good morning Florian,
Thanks for the update.
Please let us know if there is something else the community can do for you or whether we can verify and complete this thread.
Many thanks and best regards,
Business Applications communities