# 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 11.5.10.0 and later
Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.

## Goal

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