You’re offline. This is a read only version of the page.
Announcements
5
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?
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,
Ludwig
Hello Florian,
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.
Best regards,
Ludwig
Hi Ludwig,
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
Customer group
Indvidual customer
Timeframe
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
Best regards,
Florian
Hi Florian1,
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?
Best regards,
Ludwig
Hi Florian,
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?
#1
André Arnaud de Cal...
294,233
Super User 2025 Season 1
#2
Martin Dráb
232,982
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
