Each site within a company can have its own profit center. Use the Inter-site Profitability feature on the Company/Distribution/Order 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/Distribution 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 windows 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/Distribution/Order tab, the new transactions will be created automatically. In Posting Control window, posting types must be set up for the postings used by the inter-site profitability transactions. Otherwise, the postings will contain errors. The postings created by the transactions are analyzed with a profit center report generated with the report generator in IFS/Financials. The posting control must be set up to assist the report generation of a profit center report. There is no default setup made for the inter-site profitability posting control or report generation. Typically control type Site will be used in order to differentiate the inter-site profitability postings.
Scenario:
Profit Center Report | 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 window. 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.