Each first working day of the year, updates have to be done to launch the year :
MFS165 : Internal Invoice Series
Update each invoice series for the new year. The number is build followig the pattern : YY + Number serie + 00000
ex 2025 :
| N s | Year | Inv | Div | Name | Start no | Final no | Last no |
| 2 | 2025 | MB | FACTURES RECH GARANTIE FACT | 251700000 | 251799999 | 251700000 | |
| 4 | 2025 | MB | Multi echeances | 16xxxxx | 1699999 | 16xxxxx | |
| A | 2025 | MB | FACTURES RECHANGES | 251600000 | 251699999 | 251600000 | |
| B | 2025 | MB | Factures MOTEURS | 251100000 | 251199999 | 251100000 | |
| C | 2025 | MB | Acomptes MOTEURS | 251500000 | 251599999 | 251500000 | |
| D | 2025 | MB | Avoirs MOTEURS | 251300000 | 251399999 | 251300000 | |
| E | 2025 | MB | Avoirs RECHANGES | 251400000 | 251499999 | 251400000 | |
| F | 2025 | MB | Facture Préliminaire | 259900000 | 259999999 | 259900000 | |
| G | 2025 | MB | Prestations | 251800000 | 251899999 | 251800000 | |
| U | 2025 | MB | Factures Marketing | 251900000 | 251999999 | 251900000 |
CRS055 : Currency
Change rate 01 has to be updated with the change date of the day recorded in 04 for the following currencies :
AED : UAE Dirham
AUD : Australian Dollar
CAD : Canadian Dollar
CHF : Franc Suisse
DIN : Dinars Tunisien (use the XE or Oanda change rate of the day / Need Finance validation)
GBP : British Pound
NOK : Norwegian Kroner (use Banque de France daily change rate https://www.banque-france.fr/fr/statistiques/taux-et-cours/taux-de-change-parites-quotidiennes-2025-01-17)
PLN : Polish Zoly
RMB : Yuan Renminbi
SGD : Singapore Dollar
USD : US Dollar
Yen : Japanese Yen (use Banque de France daily change rate https://www.banque-france.fr/fr/statistiques/taux-et-cours/taux-de-change-parites-quotidiennes-2025-01-17)
Notes : 01 - Banking / 02 - Fixed rate invoicing / 03 - Tresorerie / 04- Daily rate BCE (calc) / 50 - Fixed rate price list
SHS010 : Schedule jobs
Connect with MSRVADM user ([email protected])
SHS060 : Create a new year with all the days
Jobs using Calendar : RPS999, PDS910
On RPS999 : run a new job with new calendar.
On SHS010 : find the job just launched, Change
Select / check the new calendar : and click on next until the page SHS231
Type 3 - Calendar + Cal Prog trav = 20
Check on SHS010 the next schedule job (should be tomorrow)
MDM Service Workspace : annual PRI
To update the PRI with the new annual price the personalized list has to be updated with the new price.
1 / Get the date of the new price :
In OIS017, sorting order 1-Price List : search for Prl = R1 and get the last Valide from date
2/ Update the field :
In CMS010, find the list called MB_MITBAL. Crtl+11 --> get the linked tables CMS011
In CMS011, find the field OPBRAS and modify it changing the valide from date with the new one.
Save and refresh.
Statistic in MDM Service
CMS010 – Information Browser Category. Open
Master Table : MB_MITSTA / related : Sorting Order (CTRL+23)
-> CRS022 - Sorting Order
Sorting : 90 - EDM MDM Stat par année
1/ Change the line 90 /E
2 / Change the sorting order from U1 to 00 (in order to modify U1)
3/ Reach U1 ( F4/F4 on field Sorting option)
--> CRS010 - M3 File. Create Sorting Options
1/ Change /F
Change each line to add the new year at the top and the so on.
Then, activate the sorting option U1 (status 15 to 20)
Change the sorting option into Sorting order 90 (CRS022)
Validate