Each site within a company can have its own profit center. Use the Inter-site Profitability feature on the Company/Supply Chain Information/Sales tab to perform the profitability analysis on all the sites within a company. By ordering profit center reports, the financial managers or site managers can study profit/loss performance at site level.
The inter-site profitability analysis is based on internal customer orders delivered to the other sites that belong to the same company as the supplying site, If the Inter-Site Profitability option on the Company/Supply Chain Information/Sales tab has been selected, the transactions and posting types dedicated only to inter-site profitability will be triggered when internal customer orders are delivered. Parts moved to another site belonging to the same company using the Transport Task or Move Inventory Part pages will not generate inter-site price postings.
A prerequisite to analyzing sites as profit centers is that internal prices
must have been used and controlled on the supplying sites. The normal price
search used on customer orders will be used to find an internal price. The sales
price on the internal customer order line will be used to post internal revenue
on the supply site and the internal revenue received on the demand site. The
inventory part value on the supply site will be used when posting internal cost
of sale on the supply site and also when posting the internal cost of sale received
on the demand site.
Therefore, it is the delivery of the customer order
on the supply site that triggers the inter-site profitability transactions on
both the supply site and the demand site. You do not wait for the goods to be
received on the demand site for the internal purchase to be registered, i.e.,
as soon as something is sold, it is also purchased by the other site. This follows
how the inventory value is transferred to the demand site as soon as the delivery
is made from supply site.
You can indicate whether to use the inter-site profitability feature for a company. By default, it is not used for new companies. Regardless of whether it is used, the inventory valuation is not affected in any way. Inventory valuation and the movement of inventory values between sites are executed in the same way regardless of inter-site profitability usage.
System Event | Description | Debit | Credit |
INTREV | Internal revenue generated from sales price on internal CO delivered to a site within the same company | M160 - Internal Customer Claims | M159 - Internal Sales Revenue |
INTREVR | Internal revenue received from sales price on internal CO delivered from a site within the same company | M162 - Internal Purchase Expenses | M161 - Internal Purchase Debts |
INTCOS | Internal cost of sale generated by internal CO delivered to a site within the same company | M163 - Internal Cost of Sales | M164 - Internal Cost of Sales Contra |
INTCOSR | Internal cost of sale received from internal CO delivered from a site within the same company | M166 - Internal Cost of Sales Received from Other Sites Contra | M165 - Internal Cost of Sales Received from Other Sites |
It is important to pay attention as to when the use of this feature is started. Starting it on in the middle of a period does not give the user any valuable information about the inter-site profitability of that period. Preferably it should be started between periods, e.g. at month-end or year-end.
If the Inter-site Profitability function has been selected on the Company/Supply Chain Information/Sales tab, the new transactions will be created automatically. In Posting Control page, posting types must be set up for the postings used by the inter-site profitability transactions. Otherwise, the postings will contain errors. There is no default setup made for the inter-site profitability posting control. Typically control type Site will be used in order to differentiate the inter-site profitability postings.
Scenario:
Site X | Site Y | Total for Company |
Comments | |
Sales | ||||
External Sales | -10 | -10 | ||
Internal Sales | -9 | -9 | Posted by INTREV transaction. | |
Total Sales | -9 | -10 | -19 | |
Cost of Sales | ||||
External Cost of Sales | 5 | 5 | ||
Internal Cost of Sales | 3 | 3 | Posted by INTCOS transaction. | |
Internal Purchase Expenses | 9 | 9 | Posted by INTREVR transaction. | |
Internal Cost of Sales Received from Other Sites | -3 | -3 | Posted by INTCOSR transaction. | |
Total Cost of Sales | 3 | 11 | 14 | |
Gross Profit | -6 | 1 | -5 | |
Cost Difference | -2 | -2 | Posted by ORDTREVAL transaction (independent of whether inter-site profitability is used). | |
Net Profit | -6 | -1 | -7 |
There is also a simplified report available in Order Report, called the Inter-site Profitability report. When using the simplified report, only one site's profitability is displayed. The simplified report is based on the inventory transaction history, which means that a high volume of inventory transactions could make this report slow to order. If there is a high volume of inventory transactions, the simplified report should not be used. Furthermore, the simplified report will not consider date changes that are done with the Modify Date Applied option available in the Inventory Transactions History page Therefore, a Profit Center report generated with the report generator in IFS/Financials is the recommended report to use for thorough analysis.
Scenario is the same as in the previous example. The report is ordered for site X.
Profit Center Report | Site X |
Sales | |
External Sales | |
Internal Sales | -9 |
Total Sales | -9 |
Cost of Sales | |
External Cost of Sales | |
Internal Cost of Sales | 3 |
Internal Purchase Expenses | |
Internal Cost of Sales Received from Other Sites | |
Total Cost of Sales | 3 |
Gross Profit | -6 |
Cost Difference | |
Net Profit | -6 |
In the above example, a transit delivery was made to site Y. Also direct deliveries registered for internal customers belonging to the same company as the supply will generate inter-site profitability transactions.
Non-inventory parts will not generate any inter-site price postings. The reason for this is that purchase prices for non-inventory parts have no correlation to the non-inventory sales part cost, and no cost differences are booked.
All eight inter-site profitability postings occur
at the same time (when an internal customer order is delivered), but the transactions
and corresponding system events belong to different sites. The INTREV and INTCOS
transactions are posted on the supply site. The INTREVR and INTCOSR transactions
are posted on the demand site. INTREVR and INTCOSR belong to the demand site,
but they are created and marked by an order reference existing on the supply
site. The control type is identified by the site on the transaction; and not
by the site to which the order reference belongs.
The following
example explains this further:
On the supply site, a CO1 internal customer
order will be registered for the demand site of inventory part X. Part X belongs
to the product family A on the supply site, and the product family B on the
demand site. The inter-site postings should be controlled using the control
type Product Family. When the delivery is made for CO1, postings will
be made on both the demand and supply sites. The postings on the supply site
will get the control type A. The postings on the demand site will get the control
type B.
Control types that are not available on both the demand and supply sites cannot be used as control types for the inter-site postings. For example, the Sales Group control type is not available because the sales group can only be found on the supply site and not on the demand site.
If the price on an internal customer order line was not correct at the time of the delivery, it is possible to adjust the inter-site postings afterwards. By using the Create Corrective Inter-site Postings operation on the customer order line, it is possible to increase or decrease the internal revenue generated for a customer order line.
To create corrective inter-site price postings, a weighted average price is calculated for all previously booked inter-site price postings for the customer order line. The weighted average price is compared with the entered correct price, which gives the price difference to be posted. If the price difference is positive, both the inter-site revenue on the supply site and the internal purchase debts on the demand site will be increased. If the price difference is negative, both the inter-site revenue on the supply site and the internal purchase debts on the demand site will be decreased.
System Event | Description | Debit | Credit |
INTREV+ | Increased internal revenue generated from corrective inter-site price postings | M160 - Internal Customer Claims | M159 - Internal Sales Revenue |
INTREVR+ | Increased internal revenue received, generated from corrective inter-site price postings | M162 - Internal Purchase Expenses | M161 - Internal Purchase Debts |
INTREV- | Decreased internal revenue generated from corrective inter-site price postings | M159 - Internal Sales Revenue | M160 - Internal Customer Claims |
INTREVR- | Decreased internal revenue received generated from corrective inter-site price postings | M161 - Internal Purchase Debts | M162 - Internal Purchase Expenses |
When calculating the weighted average price, it is done per inventory unit
and all previously booked inter-site price postings are considered. The weighted
average price is calculated as: [(INTREV1 quantity*price) + (INTREV2
quantity *price) + (INTREVn quantity *price) + (INTREV+1
quantity*price) + (INTREV+2 quantity *price) + (INTREV+o
quantity *price) – (INTREV-1 quantity*price) – (INTREV-2
quantity *price) – (INTREV-p quantity *price)] / (the
total delivered quantity on CO line).
n is the number of INTREV
transactions, o is the number of INTREV+ transactions, and p is
the number of INTREV- transactions created for the customer order line.
When return for rework is done on the demand site, those parts are later received on a return material authorization on the supply site. After the parts have been reworked, they can be delivered again to the demand site on a new internal customer order. If corrective inter-site postings are not applied manually, the reworked parts will get inter-site price bookings posted twice (first for the original delivery and second when delivering the reworked parts).
If the rework should be paid for by the supply site or the demand site is often an open discussion. The demand site might have to pay for all the rework because they had not communicated their demands on the part design well enough; or it could be that the supply site should pay for the rework because they have delivered poor quality goods. Therefore, generating internal profit (which is the case if the internal revenue is greater than the internal cost of sale) on returned order lines might not always be considered correct. Therefore, the Create Corrective Inter-site Price Postings function is also available on return material authorization lines. To use this function, the return material authorization line must be credit approved and connected to a customer order line. By using corrective inter-site price postings, it is possible to ensure that each return is considered as appropriate by the profit center analysis. The internal revenue can be adjusted so that the returned order lines give the correct internal profit. The internal cost of sale cannot be adjusted.