Replica: CAS-W-SQLSV server database ODS_BI


 Clear link to connect M3 :  

 https://mingle-portal.eu1.inforcloudsuite.com/v2/FAUKM4N9K4YG8UTN_PRD 

Change the Login is connecting issues.

 

Tips:

  • To go from one division to another, press CTRL+R plus CMP +CONO number (e.g. 700MB. White Society: "700" with 2 spaces)  ( CONO = Div+Sty )
  • Do CTRL+R: LNG +FR or GB depending on the language you want
  • For F > 12 functions: Press shift and the F is the clock time {am} (-12).  Ex: F13 = Shift + F1
  • Extourner / Reverse = Undo a status change. Does not exist on all functions
  • SES200 = see where the field appears in which program



Unlocking Orders: 

In the Enterprise Collaboration Administrator, filter on failed, identify the problem with "show" then fix the problem and click on "redetect" to restart the job.



Settings: 

MNS100: all divisions on M3. Div = cono 700 / company = MB

MNS150: Associate authorization of divisions and companies: Division 700 "white" company for all companies (for transactions and the need to have a company)

MNS260 : MBM Initiator Open Output : where jobs from outsite come in

OIS010: Order Type

PPS095: Purchase Order Type

OIS180 : Print invoices

OIS680 : Reprint Invoices

OIS150 : Preliminary invoice


For some settings, it is necessary to restart the jobs (MNS051) to do F20 finish everything and then F19 start everything

 

Vigils / Routines:

  • CMS970: List of updates infor à CMS975 details by update. Mandatory changes to the MEP date. To be tested before.
  • CRS165: List of counters à Check that they do not reach the maximum because of the risk of blockage
  • MFS165: List of Meters Bills = Annualized Meters
  • CRS400 : Annual Journal number serie
  • SHS010 : Schedule jobs entries
  • SHS030 : Schedule jobs programs
  • MMS920 : automatic allocation. Check the number of records column to see if there are any pending rows
  • MNS051 : runtime job = all jobs that are running. Check if everything is okay
  • CMS911 : automatic jobs


Data management : 

Field Audit Trail = Business Engine Field Audit Trail if the field is enabled on the page concerned press F9 to get the different values (field audit)

Business Engine data management: allows you to create a row, correct the tables (e.g. problem the header of the order in pps 200 has disappeared but not the rows in pps 220)



Desktop publishing:

In document management there are all the templates.

In CRS027 there is the list of documents by document number and depending on the program.

In CRS028 there is the name of the matrix. 

In CMS005 and sort order 3, there are the print files, which allows you to sort the tables by matrix. 

In MNS 270 there is the list of editions. Associating show see in the hot job XML with all the feed, just display the status of the job, it's not interesting.



CMS006: XML structure = different versions of editing files 

MNS 205: Exit of doc mail

<UF01> : Variables in desktop publishing that adapt to all docs.

 

Data Update:

MRS001: List of APIs. Have an import template associated/generated

Business Engine files à MVX files transfer -> Retrieve import template file à complete columns save in CSV -> upload to Business Engine Files -> EVS100 importing data from csv and generates a response with dates à download and check error codes

 

Copy a table: 

To copy a workflow, you can make a copy, import it and export it, but you will have to redo all the UID key assignments because they are different between PRD and the test database.

CMS010: Information Search Category

CMS015: List of Activated IM Programs

The CMS010 and CMS015 pages are to be filled in by hand when copying.


Pin code locking

If a page is locked by a Pin code request, use MNS110 Function. Open to find the program locked, change the parameter Pin code check : untick the box.