cancel
Showing results for 
Search instead for 
Did you mean: 

Copper increase

Former Member
0 Kudos

Dear SAP BO-Users,

does anybody have an idea of how to handle copper increases?

What does this mean?

In some businesses (i.e. electronic business) the sales price of a product is related to the copper notation. If the copper price goes up the sales price of the electronic product goes up as well. The copper increase is related to the percentage of the total weight of the sales product. The copper increase often has to be shown as a separate position on the invoice.

Looking forward for a lot of helpful propositions

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I think there are at least two questions here

1. How to manage current sales price of items?

2. How to manage the effect of change of copper price between dates in document life-time?

IMHO, #1 it is better to recalculate current sales prices

in Excel and update the price list using Import from

Excel or DTW. Some time ago there were issues with Import

from Excel feature: some item prices did not get updated

depending if the item was/wasn't a warehouse item and

was/wasn't used in a document (sorry, I can't remember

the exact case. SAP recommended using DTW). Therefore if

you go the Excel way then make sure that you run adequate

tests.

For #2 you may want to maintain copper prices over time.

Maybe you can add a new currency ('CU')?

For each Item you create a UDF of type 'Rate' for storing

the CopperPercentage ('U_COPPER_PERCENT')

For each Sales Invoice Line you recalculate the price

using a formatted search.

The SQL for your Formatted Search may look something like

this:

[code]

DECLARE @DeliveryDate as datetime

DECLARE @DeliveryEntry as integer

DECLARE @DeliveryRow as integer

DECLARE @DeliveryPrice as float

SET @DeliveryEntry = $[$38.45.0]

SET @DeliveryRow = $[$38.46.0]

SET @DeliveryDate = (SELECT DocDate FROM ODLN WHERE DocEntry = @DeliveryEntry)

DECLARE @OrderDate as datetime

DECLARE @OrderEntry as integer

DECLARE @OrderPrice as float

DECLARE @OrderRow as float

SET @OrderEntry = (SELECT BaseEntry FROM DLN1 WHERE DocEntry = @DeliveryEntry AND LineNum = @DeliveryRow)

SET @OrderRow = (SELECT BaseLine FROM DLN1 WHERE DocEntry = @DeliveryEntry AND LineNum = @DeliveryRow)

SET @OrderDate = (SELECT DocDate FROM ORDR WHERE DocEntry = @OrderEntry)

SET @OrderPrice = (SELECT Price FROM RDR1 WHERE DocEntry = @OrderEntry AND LineNum = @OrderRow )

DECLARE @CopperAtOrder as float

DECLARE @CopperAtDelivery as float

SET @CopperAtOrder = (SELECT Rate FROM ORTT WHERE Currency = 'CU' AND RateDate = @OrderDate)

SET @CopperAtDelivery = (SELECT Rate FROM ORTT WHERE Currency = 'CU' AND RateDate = @DeliveryDate)

DECLARE @CopperContent as float

DECLARE @ItemCode as varchar(30)

SET @ItemCode = $[$38.1.0]

SET @CopperContent = (SELECT U_COPPER_PERCENT FROM OITM WHERE ItemCode = @ItemCode)

SELECT @OrderPrice * (1 + (@CopperAtDelivery - @CopperAtOrder) / @CopperAtOrder * @CopperContent)

[/code]

To my surprise this actually gave a number that made sense.

HTH

Juha

BTW, is your 'electronic business' about manufacturing

and/or distribution of materials (for example cables)? Or

are you in electrical contracting (see www.zveh.de)?

If you are on contracting side then you might want to

check our quotation calculation tool. We manage 100.000 +

items, several suppliers and prices for each item. The

quotation calculation is extremely straightforward:

you'll be able to calculate a quotation for

electrification of appartments and complete buildings in

a couple of hours. We can also import 'electrical

symbols' from CAD drawings to further speed up the

process. If you are interested in this then check my

SDN Business Card for my contact details.

Answers (0)