You’re offline. This is a read only version of the page.
735
Hello all,
We have a few customers that require they receive net pricing per line on their invoices. We typically use trade discounts but unfortunately that won't work in this situation, nor will a terms discount. I know that I can achieve this by creating a custom price level, but then my distributions won't be correct. If I did that, I would then have to do a monthly correcting entry so the GL reflects the appropriate discounts, and I'd really prefer not to do that. Is there any way to have net prices on the line item and still have the distributions done correctly?
*This post is locked for comments
The prices are not impacted by the QTY order in that sales transaction. Part of our month end process is running a script that looks at everyone's sales, compares it to our discount structure, and then it updates their Customer Card & any open sales documents to reflect the new discount. This is not something that is done during each transaction.
Even standard pricing could cover the requirement of quantity ranges. Although, I still have one critical question, the actual invoice price is being considered based on the following criteria "We have a discount structure in place where the more a customer buys throughout the year". This needs to be settled precisely.
The more your customer buy throughout the year, the higher the discount and accordingly the less the price. That means, in order to calculate the current invoice price, you should consider all the sales transaction for this specific customer, not only the number of items in this specific invoice, right ?
Let's say item 012345 has a dealer price of $20. This would be the base price level. We have a discount structure in place where the more a customer buys throughout the year, the higher their discount goes. With that in mind, we do everything at the dealer price level and then apply the trade discount. In this example, that discount is 12%, bringing the total for the product down to $17.60.
Unfortunately some of these customers require that they receive invoices with net pricing on each line, meaning the line item itself must show $17.60, not $20 with a $2.40 discount applied at the bottom.
What would make you sell the same item at $ 20 and $ 17.6 ? Would you sell the same item with both prices in parallel ?
The answer of the questions above is primarily, pricing. In this essence, I would wonder, why the price list would result with a wrong distribution as you stated above.
Your feedback is highly appreciated,
For us a typical transaction would be as follows:
Item 012345 x QTY 5 @ $20 = $100
Less 12% Trade Discount -12 (this gets flagged to our discount account)
Total $88
I am trying to find a solution for the situation below.
Item 012345 x QTY 5 @ 17.60 = $88 (this does not get flagged as a discount, but I would like it to be)
Total $88
Thanks
Can you illustrate further please, through an example just to ensure your requirement is well understood.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,151
Super User 2024 Season 2
#2
Martin Dráb
229,993
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (