| Hide If | ||
|---|---|---|
| ||
Tasks to be completed when documenting an operation (from creation to publication)1. Enter the Title of the operation / page2. Add the following Labels :
3. Fill in all fields as described above4. Name the title of each section using OPD methodology naming convention - Infinitive verb without the “to”, mainly action verb...something) - " I do something..."5. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow |
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
| Domain: |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Responsibility area: |
Table of contents
| Table of Contents | ||
|---|---|---|
|
| Panel | ||
|---|---|---|
| ||
ScopeERPPI2 WP2 PF2 Frequency
ReferencesFormsAttachments
<<
|
1. Objective and Scope
1.1. Objective of this Operation
Every quarter a report is sent to GAR with the denetted positions for trade payables and receivables. (D5)
1.2. Scope
For all Legal Active entities
PF1PF2
WP1WP2
PI1PI2
2. Definitions
See Finance Glossary:
3. Tasks description
The implementation of F101 in WP1 WP2 will allow us to see these balances in specific accounts in the balance sheet, however the report to GAR still needs to be prepared, either using these 2 transactions or with other transactions to report account balances.
3.1. Create the template
I use the Templates of before quarterly closing as example.
3.2. Update the template
Update both files (Payables and Receivables)
1 - Update the GAR list.
2 - Update the exchange rates based in the file sent by BFC Admin.
3.3. I run the reports
1- Extract all company codes from GAR list F FINANCE LEGAL ENTITIES MANAGEMENT - SCo
2- Exclude all the companies that are not Fully Consolidated (IG) on the "Consolidation Method" column
32- Update variants with company codes by system
34- Export to excel
Transaction:
S_alr_87012082 vendors balances in local currencies (Payables)
PF1 PF2 variant: DEBIT BALANCES
WP1 variant: VENDORS DEBIT
DEB BAL SCOPF
WP2 variant: DEB BAL SCOWP1
PI1 variant: VENDORS DB BAL PI2 variant: DEB BAL SCOPI1
S_ALR_87012172 customers balances in local currencies (Receivables)
PF1 PF2 variant: CREDIT BALANCE
WP1 variant: CREDIT BALANCE
CRED BAL SCOPF
WP2 variant: CRED BAL SCOWP
PI1 variant: CUSTOMERS CRDTPI2 variant: CRED BAL SCOPI
** Period
1 to closing quarterly closing
After run the transaction, in the end of the report will be the data that you need, export the data to excel;
** Period
1 to closing quarterly closing
1- Extract all company codes from GAR list
2- Update variants with company codes by system
3- Export to excel
4- Update the exchange rate bases in the file sent by BFC Admin.
3.2. I create the template
I use the Template of before quarterly closing as example.
I update the exchange rate bases in the file sent by BFC Admin and check if the formulas are ok.
If so, I send it according below:
To:
After running the transaction, the requires data will appear at the end of the report.
Export the data to Excel by selecting List → Save/Send → File → Text with tabs
The required data will be located in the last rows of the Excel file. Adjust the number format, then paste it into the Google Sheets file (Payables or Receivables).
A good way to verify if the report was generated correctly is to compare the number of companies in the current report with those from the previous quarter and check if they are similar
3.4. I Consolidate data into the Final File
1 - Copy the data from the individual files (Payables and Receivables) to the consolidated file (Denetted Trade Payables and Receivables)
2 - Verify if the formulas are working correctly.
If everything is correct, you can send it via email to the recipients listed below:
Jean-philippe Terrasa <jean-philippe.terrasa@syensqo.com> Nicolas Bourgois <nicolas.bourgois@syensqo.com> SCo-$BFC-conso <bfc-conso@syensqo.com> |
In CC:
João Saramago <joao.saramago@syensqo.com> |
End of document.
| Viewtracker | ||
|---|---|---|
|