How to add pack charges in purchaseorder total amount befor BED Calculation

[Former Member]

Dear All,

My supplier will also charge packing charges for raw material

It should be add with the total amount

For Ex,

Quantity = 10

Unit Price = 1000

Packing Charge = 300

Total = (Quantity*Unit price)+Packing charge

Total after packing = 10300

Then i want to calculate the BED for the total after packing 10300 amount

How can i add these packing charge with total amount

Regrads,

Vijay

Edited by: Vijay Guru on Oct 14, 2008 7:32 AM

[Former Member · Accepted solution]

Hi Vijay,

Freight has broad meaning in B1. You can use this for your packaging for sure. Something more can be categorized to freight too such as hanlding.

Thanks,

Gordon

[Former Member · Accepted solution]

Thank u Gordon but my P&F Amount is changable

Following solution may suitable for this problem

*What we do as a workaround is create a UDF called 'Packing & Forwarding Charges' in Rowlevel and Write a Formatted Search Query to Add this value of 'Packing & Forwarding Charges' with unitprice * Quantity and assign this to Assessble Value of an Item.*

*Assessable Value = unitprice * Quantity + Packing & Forwarding Charges*

Now calculate the BED, CEss, CEHH HE, VAT for this Assable value.

But how can i create the formatted search for adding the value of pack& forward with assessable value

Help me out

Regads,

Vijay

[Former Member · Accepted solution]

Use this FMS in the Assesable Value Field

SELECT $[$38.14.Number] * $[por1.quantity] + $[por1.u_packcharges]

$[$38.14.Number] means UnitPrice
The UDF for packing Charges is named as u_packcharges. Change this as per your 
Variable name

[Former Member · Accepted solution]

Thank u Sridharan

U r right

But one small issue

when am giving quantity 10 and price 72.50 U_Packing Price 50

it gives exact value

but if am giving quantty as 100 it shows internal error

[Former Member · Accepted solution]

This error might be due to some datatype conversion. Try out

SELECT Cast($[$38.14.Number] * $[por1.quantity] + $[por1.u_packcharges] as numeric(14,2))

[Former Member · Accepted solution]

Sridharan

Thank u for ur reply

But it shows the same error

Plz Help Me out

[Former Member · Accepted solution]

Try to attempt this FMS

declare @uprice as numeric(14,2)
declare @qty as numeric(14,2)
declare @pprice as numeric(14,2)

set @uprice = Cast($[$38.14.Number] as numeric(14,2))
set @qty = Cast($[por1.quantity]  as numeric(14,2))
set @pprice = Cast($[por1.u_packcharges]  as numeric(14,2))


SELECT (@uprice * @qty + @pprice)

[Former Member · Accepted solution]

Thank u Sri

Now the above query was working fine

and the tax amount also am calculating based on this assessable value

so its calculated correctly

the problem is

when Quantiy = 10

Unit price = 100

Total = 1000

Packing charges = 100

Assessable value = 1100

BED = 209 based on Assessable Value

But in bottom of the Purchase order tansaction it shows the total amount due is 1209(Total+Tax)

But i want to display total amount due is 1309(Assessable Value+Tax)

How its Possible

Plz Help me our Sri

[Former Member · Accepted solution]

Use the Same FMS in 'Row Total' to get the proper output.

[former_member187989]

Check this thread

Jeyakanthan

[Former Member]

Thank u Jeyakanthan

But in above thread they are mainly talking about only freight charges

not more info about Packing and forwarding

where can i enter the Packing and forwarding charges it should affect with total before calculating BED

is it possible to use freight charges field for Packing & Forwarding Charges

Edited by: Vijay Guru on Oct 14, 2008 9:03 AM