on 06-30-2016 11:19 AM
Hi All,
My Client is having one requirement as mentioned regarding Pricing of PO -
They deduct brokerage amt from Main vendor and Pay to Broker Vendor.
They deduct 2% Charges from Main Vendor as they Pay them on the same day.
The calculation in Pricing they want is
Qty Price Amount
10 100 1000
Tax ded. 5% 5 50
Sub Total 1050
Discount 2% on Sub Total -21
Brokerage to Brokerage Vendor(Statistics,Delivery Cost) 10
Brokerage from Main Vendor -10
In GR Inventory to posted by 1000-21-10 969
In MIRO Vendor Payment to by 1000+50-21-10 = 1019
The Problem I am facing -
1) If I am making "Discount" and "Brokerage from Main Vendor" as Statistics then these amount I am not able to deduct from Vendor.
2) If I am making "Discount" and "Brokerage from Main Vendor" as non Statistics then I VAT Tax calculation is getting working as Net Price consider these amount is calculation.
So is their is any way I can exclude these condition from NET price calculation without making them Statistics by some routine or standard configuration.
Regards,
Siddharth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, I do not think so that you need to write a routeen .the brokarage percentage you want to pay to the other brokarage vendor . alternatively you create the condition to be as frieght and maintain the fright vendor in the PO and during MIRO post them separately and clear them for payment . However you need to have a constant look over FRIR account carefully always in this method . Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raghavendra,
This issue is not with Brokerage vendor Payment, I have made that as B-Delivery cost condition type only but the same value of Brokerage my client want to get it deducted from Main Vendor payment.
So for this requirement we have made one negative condition of Discount which will have value for 100% of brokerage condition value but this condition amount(-negative value) is getting added in net price and by which Tax is wrongly getting calculated.
So if it is possible that this negative condition value should not be included in net value calculation without making condition as statistics or accrued type.
Can the said requirement is possible in standard or we have write some routine for the same ?
Regards,
Sid
Please check the standard condition exclusion process using the following function,
Call transaction OLME --> Conditions --> Define Price determination process --> Define condition exclusion --> Assignment of condition exclusion <-> Calculation schema
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rosh,
As discount is negative condition so I can not make it condition category as B "Delivery Cost" and also I cannot make it as Statistics as ultimately this discount should get deducted from Vendor Payment.
Making it as accrual is also not correct as it should be consider at the time of final payment to Main Vendor.
Let me know if any more details required on my scenario.
Regards,
Sid
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.