The application was replaced by BW RTR - FI Working Capital for Solvay Group (WBP) /!\ Obsolete /!\ |
This page provides all the technical and detailed documentation concerning the "FIWC" (Finance Working Capital) application in BW, including :
This page is only for technical or non-end-user information. |
It is equal to the sum of:
It excludes:
In Magnitude (FC)/Sesame:
Every month, persons in each company will get the values from RCS/BW for each account and enter it manually in Magnitude.
In finance, every document is posted to a General Ledger Account (G/L Account). This GL account depends on the kind of document (stocks will have a set of accounts, AP another set, AR another etc…)
Not all accounts must be taken for the working capital calculation
Most documents are created automatically by the system but some accounts only have manual documents.
Example of an automatic document:
Each time there is an invoice created a document will be created in a G/L account and amount = A
When the invoice is cleared, another document will be created with amount = - A
Example of a manual document:
At the month there may be some “Work In Progress” materials. These are not in the stocks so we don’t have a stock value but still need to be valuated so a manual document will be created to make sure we don’t forget that valuation.
+The working Capital value corresponds to the value of all the open documents in a list of G/L Accounts.
We can split the Working Capital in 3 main components, which separates in sub-components. Each is a list of G/L Accounts:
!Attachment Library^WCAppli_html_4a762ba3.gif|height="411" !
Where to find it:
!Attachment Library^WCAppli_html_m55f566b3.gif|height="358" !
+G/L Accounts restitution:
!Attachment Library^WCAppli_html_339e1905.gif|height="35" !
For definition of each field and list of values check the public definition of |GL Account >BW - Business Warehouse.GL Account Master Data]* master data.*
The management of G/L Accounts for Working Capital is done manually by the BW Team.
To filter out Intraco and Interco for Payables and Receivables we use the Status of the Trading Partner of the supplier/customer/partner.
In the report we display customers/vendors which corresponding trading partner has a status different from 1.
Note about deleted partners: If an integrated supplier/customer is deleted in RCS, they will remove the status. If the customer/supplier still has an open balance up until 11 months ago then it will be considered external and displayed as working capital. To prevent this, do not delete partners which have an open balance. |
In BW, we filter out all Intra and Inter company sales/purchases (Intraco, Interco)
Note: he master data team (MAGDA) is responsible for maintaining the partner and customer status value in RCS
To filter out the legal entities (Company) which are obsolete or not fully integrated, we will also use the Status of the Trading Partner but this time of the Company. 
In the report we only display data for legal entities for which the corresponding trading status is equal to 1.
Note about obsolete companies: the day a company is tagged as obsolete it will completely disappear of the reports! Even from the historical data
Note about companies partially integrated (Butachimie): BW updates manually a list with a coefficient for each company. Normal companies will have 100%. Partial companies can have a lower percent. In 2010, Butachimie has 50%.
In BW, we filter out all Obsolete / Non Integrated companies
There is 2 cases:
Ex: 3894 - ZZZZ exBluestar Silica Fra
Ex: 1892 - GIE Chimie Salindres
Note: he master data team (MAGDA) is responsible for maintaining the partner status value in RCS
To remove all investments from the account payables, we use the Cap Goods Indicator (Or Invest.ID in RCS)
This indicator, found on the invoice, will be checked (X) if it is an investment. In the report we only show amounts from documents with indicator different from X.
Example of invoice:
Note The indicator is only used for FIAP (Invoices) data. For provisions, the difference between investment/non investment is done by GL Account. There aren't investments in the Stocks and FIAR.
In BW, we filter out the CAPEX / Capitalized goods
For data coming from FIGL, FIAP and MM, the base of the business assignment is the Profit Center. From the profit center we then use the Industral Axis to define the business structure.
For data coming from FIAR, the base is the IECRA. From the IECRA we then use the Market Axis to define the business structure.
Example of the profit center hierarchy that is used to define the Industrial Axis.
+On MM (Stock data):
+On FIAP/FIGL data:
+On FIAR data:
+Non assigned in Single-Business unit company :
If you have non-assigned values for companies which should be 100% assigned to a single business unit, contact the BW team: it is possible to set a default BU by company.
The BW working capital reports are all based on amounts in Local Currency Those amounts come directly from RCS.
If user selects a currency in the prompt the query will convert, otherwise it will return the values in local currency.
This conversion is based on the ZRHO rate (coming from RCS).
The current available rate s applied to ALL data (even past data) independently of the date.
For base amount we use the Debit/Credit Amount 0DEB_CRE_LC or FIGL/FIAR/FIAP data and the Stock Value for IM data.
We then apply conversion type ZRH2 for Working Capital - CTK_ZRHWC :
For the BW Working Capital we use 4 sources of data:
Vocabulary:
FIGL: General Ledger
FIAP: Account Payable
FIAR: Account Receivable
Technical dataflow:
Those 2 multiproviders are identical. The only difference is the authorization objects. They should have some providers in source, same key figures and same navigational attributes
In MPR_WC02 the authorisation objectif is only the GBU. This is because the target population is usually zone-wide or world-wide on 1 single business. Idea is to allow them to run the report on their perimeter without having to enter all the companies (in some cases dozens).
Im MPR_WC01 the authorisation access is only by company. This is because the target population (Accounting/site controlling) is usually GBU-wide on a single company. Specially these users need to be able to see the data that is not assigned to any GBU.
+0COMP_CODE – Company code:
+0GL_ACCOUNT – GL Account:
+C_GLBFILT – Global filter: