My Oracle Support Banner

How Can We Calculate The Customer Monthly Amount Spent On Sales Order Through Advance Pricing (Doc ID 1517021.1)

Last updated on NOVEMBER 13, 2019

Applies to:

Oracle Order Management - Version and later
Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.


How can we calculate the customer monthly amount spend on sales order through advance pricing
and provide a free item it a certain amount is spent on a monthly basis?

Problem Description
If in 1 month customer buys the material of amount 1Lac Taka (also it may be buy material one time of 50 k and second time of amt 50 k )
then he will get sample (free) item of amount 10k end of month. but how can we calculate customer amount end of month and how can
we give sample (free) item of amount 10 K through advance pricing (Modifier).

see the Example:-

If a customer spend 1lac Taka in 1 month he will get sample item(Free item) on 30% of 1 Lac that is 30000.
And 30000 is cost of = 5 Carton, so customer will get 5 jars on 5 Carton


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.