Global AI and Data Science

 View Only

IBM RPA - Reconciliation Process how to (stuck)

  • 1.  IBM RPA - Reconciliation Process how to (stuck)

    Posted Mon February 05, 2024 01:36 PM

    Hello everyone, I want to ask about RPA because I'm stuck at exploring it with some use case.

    We haven't been able to do :

    1. Pull General Ledger by Vision coa 221012 of the month we want to recon. Separate based on Sharia and Convention business units, Line of business (GM, GA, OL, CL, etc).

    2. Determine which BU and LOB you want to recon

    Journal type = "GROUP" journal formation by system complete with claim number

    Journal type = "GRP/IPS" journal payment IPS system in bulk, (finance daily payment) no claim number.

    3. Open the finance payment detail data share, take the journal number GP23-XXXXX and Remarks and then search in the IPS system breakdown payment GP23-XXXXX. Login to the IPS system portal, Trace Payment, enter comments obtained from finance data into IPS, get download payment details. The downloaded detailed data will be complete with the claim number so now we can reconcile the system output data (Group) with the IPS data (details).

    4. Do it repeatedly from step 3 (breakdown payment details to get a unique claim number code so that it can be matched with the journal by system per claim number) do this for all Business Units and LOBs.

    Anyone have any idea how to do that?
    Already read the knowledgecenter, try to search in google, read fuction, but I'm still stuck.

    Please help if anyone can or have similar usecase in IBM RPA.



    ------------------------------
    Timothy Rainier Andika
    ------------------------------