hello everyone we will be seeing a short overview on peoplesoft financial supply chain management system and we will be having a small demonstration on showing up a general ledger sample transaction and peoplesoft financials so now in people's financial management system peopleshop financial management system is basically an erp application what it does is it record our financial transactions from various peoplesoft and non-peoplesoft sources it also process our recorded data as per business logic and store the data in different logical related database objects it also report the accounting transaction in detail or summary for different business reporting requirements now further we will see what are the major features that it support so freelance peoples of financial management system it's the major supported features are multi anti-t multi-cap multi-currency multi-language multi-book inter and intra-unit accounting sut vat withholding gst fiscal and statutory reporting so these are all features being supported by fms so these are the major ones there are many a part of these now let us see in fscm application and see a quick demonstration on recording a transaction processing and reporting in peoplesoft general ledger i have logged in as a super user vp1 let us begin with entering and capturing a transaction so i entered my business unit which is defaulted here p j y p u y puig01 i'll leave the general id as next which will allocate the next available general number or opportunity we can enter a general id also and a general date is defaulted with current system date so i have chosen feb next one date and i just clicked on add i will fill the transaction with all below mentioned values as defaulted clicked on lines and i count and enter amount for 2 units now try entering a general which is unbalanced as you can see credit amount and debit amount are different over here so we entered unbalanced entry so let's say click on save and let us see if a system can validate this is an erroneous entry if i click on process it should show an erroneous entry for us i have edited the journal clicking on process i think the general basically means validating the general with respect to some predefined values it takes some time to process now if you see this generally is edited and the status is a which means errors when i click on this link it will take you to the error tab where it display what is the error so it says general is not balanced so so if you go to the totals tab you will see the total debit and total credit are having difference of 1 which means general went into an error now let us go to the links tab and make this journal balanced and attempt to edit again click on yes and again it reprocess the general entry and we'll see if it again get into an error or not now if you see the general entry it's v which means it is a valid general this valid general can be posted by selecting pause journal and click on process button and it will process the general and to click on ok and to click on yes it will take some time to reprocess it's revalidating my trans process i mean the amount that i have entered now balance the transaction so possibly it should go into success now if you see the general status again it is p which means the journal is posted now this was a simple journal entry where there were no approval in place as we can see source is cfo which doesn't require any approval now let us try entering a journal for another source where the general goes to the approver for approval and we will approve the general before the journal get posted so i am entering a similar general and with same period and a different time this date and date this time so click on add after that entering the value so i'm going to change the source to online under header tab so this is source for which we have approval setup in system click on line step now this general should go to approval once they approve the general and submit for approval i'm adding account and amount entry again click on net plus to add another entry for transaction and click on process and general is saved it will process and we'll see it again appear as valid or invalid now we appear yeah so it shows v so for submitting general it can be done by clicking on the process tab and setting selecting submit general or you can process you use the process button to process it you can use the approval button approval tab as well itself so i will select the process button from the lines tab for approval in this process it takes some time to process now if you go to the approval tab you will see that the general has been submitted for approval now it has been sent to same or more approvals it depends on the approval setup so you need to click on approval history and it will show the approval details with whom journalist painting now let us login with the approver id and try to attempt and approve this general in real time this approval will be a different person will be approving the general before entry can be processed now i have logged in as an approver in fscm i'm entering this approver id and password to which that channel has been submitted for approval now i have logged in as an approver in fscm the same approver to whom we send the general for approval after after you logged in you see a peoplesoft home page like this we are seeing employee service which is default homepage where the approver find the tile named approvals which are just clicking on it once i click on approvals tab now the painting approval work center shows all kind of painting approvals that are sent to this approver now we go to our specific general entry and we will filter and select the entry that has generated for this week now this is the entry which is was submitted for approval this is the account and the amount which we have seen now i need to validate and click on approve after adding comments it will approve my general and send status update to submitter it will say request is approved let's wait it takes some time it should show that the request has been approved yeah so the request has been approved the same login that we have done for requesting the general you need to go back to the same and refresh the page since it is not reflecting let me bring up the general again from the search page i'm entering the business unit puy01 which i have created before and i'm selecting the source online and then clicking on the approval tab now and if you see in the approval tab that the journal is already approved by the approver now this general can be posted click on lines tab and select post general and click on process this will reprocess the general just click on ok this journal is posted now let us go and see in a delivered enquiry page to see data posted by our couple of general to see the data we need to navigate to general ledger review financials and generals on this page you could add a new entry or view an existing enquiry so here i'm going to add a new enquiry let's say gp and click on add so we enter business unit and i will select the ledger for which channel was posted i will specify the fiscal fiscal year and the period and click on search now if you see we got two generals posted here which we captured as a normal entry or cfo and the other is the online which we have which we app which was approved by our approver and posted so we could pull up the data for both the generals as a summary here in the delivered inquiry page if you want detailed data for this general you could click any of the hyperlink and it will take you to the responsive respective generals like this so let us try searching one and see how it shows the detail now it is showing summarized and detailed information in general header and general lines with chart fields and amount now let us try running some reports so we have seen processing the general and capturing the data as per some delivered rules to validate now let us see how can we generate a report from the posted ledger information so all this posted information for this specific business unit or any ledger attached to this business unit is stored in back-end record that is called ledger and we have many delivered reports that can be pulled up based on this record data that is ledger record so we need to see that ledger record so let us see one popular report known as trial balance report so we navigate to general ledger general reports and trial balance as such with gp either you can use an existing run control id or you could use a new red control id to run a report now i am having an existing run control id where everything is setup and fetch data for my business unit for which i entered the generals so i specified business unit buy zero one and ledger local with fiscal year 2021 and period 2 for which i want the report i could specify the currency as well for filtering or leave it blank to show all transactions whatever chat fields i want i need to select here so i have given a range here to fetch the account for which i have entered the data now after this i need to click on run to run the report select the trial balance report i have selected the default process to generate trial balance and hit ok now if you see here is the process being scheduled and this is your process instance id230274 in process monitor i would refresh and it will show the glj edit process which was run on previous page i need to click on refresh to reflect it yeah this is the glj edit hyphen 0 process application engine which is scheduled for processing gngp is a post process for general posting and gls7012 is the report we just triggered now i go to report manager page click on administration tab and this is our trial balance report now this is the report this is a delivered report for trial balance and if it shows data from the two generals which we add containing three accounts this is the first initial account for first general and 242 is the amount for the other general and there is a total amount 342. additionally you can view your report from the query manager as well by navigating to reporting tools query and query manager select on create a new query and specify record record name as ledger and click on search this is the record ledger ledger data to which general is posted select the field for which we want to fetch the report so i am selecting few specific fields let's call here accounting period currency cd and i'll be selecting the base currency select some criteria by using this filter option and here i specify my business unit value which is pui 0 1 i click on ok here specify my ledger value which is loc al local and i will also specify the fiscal year for which we did the transaction we are doing all this to get the accurate transaction for which we entered now there now there i will add my accounting period as 0 2. now the criteria is set for all the selected fields now click on view tab to view the sql this is system generated sql this is record for which data is processed posted and restored is a criteria which is auto generated by system for our query like we use y01 which we set local zero two one and zero two now click on run tab it will show same results which we have seen in the trial balance report so either you can get process data using the delivered report or you can get the report through running query in query manager if you see it's the same report right this way peoplesoft provides multiple choice to the user in delivered report or else you can report the data in the form of query if you want to take out the output in excel file simply click on download which will download the query result into an excel file you need to click on this download excel if you see there is a excel file that has been downloaded now this is how our end result look like the result output based on the field which we have selected as criteria minded so it is showing new unsave this is because we haven't saved our query so if you want you can save your queries and you can run the report so it's just a random report i went that's why it is without being saved so it is showing new unsafe now let us see how do we import data from third-party system or day-to-day accountants do using general import peoplesoft provides some predefined spreadsheet i'm putting the general data so i am using the default credentials for peoplesoft and once i signed in okay so peoplesoft delivered two kind of templates for importing data template could be based on xml link or it can be based on integration broker so here is an example of an xml link based import template so the delivered template file comes with macro file as well so if this is a template then it has a corresponding macro file there is another version of template xls which is used in older systems let's say windows 2007 or earlier let's see a template correspond to my client system so this is a template we could do some setup before we import for example setup tab we provide address which is your url of peoplesoft system and you need to change the psc part with xml link you could provide default for business unit ledger group source usually the financials and accountant who use template for importing data they do it for specific business unit and larger group combinations a particularly source type like here the source type is cfo we click on ok this message appear when we are using url which is not secure so you can click on yes now click on new button and specify a spreadsheet name let's say i'm mentioning as xml link now for general entry sheet enter the general header and the general line state click on it and you can see all values we enter in setup is defaulted here optionally you could change the details i am changing the source if you need to provide any other detail like general reversal or exchange rate you can enter here as click ok in general lines you could enter general line data like bu you can enter ledger accounts and all click on the plus sign to add a new row it actually copies your previous row data so i only changed the accounts and the amount to make the journal balanced now click on this button it is the green button that is used to import the general directory directly once you click on the import icon it will ask you for the user credentials which has access to peoplesoft enter the credentials here and click on ok button so here you see a message that general is imported it also create a log file which you see details of entry be imported like this now let us log into the application and see if this general exists in application or not 940 is my journal id for business unit buy01 now in my application navigate to general ledger generals general entry create an update journal entry this is the same navigation which we used in our previous replication so i will enter my business unit here and the general id to find my journal my business id is voi01 and i will be entering the general id ending with 940 i click on search it shows that this general must be formatted by the general edit process before you can use it here you can use the you can edit the general using the batch mode you need to navigate to general ledger general process generals edit generals you can add a value and from here you can edit your generals you will see it later on words now let us see another method the same general details can be imported using a flat file which is generated from same spreadsheet so we will go back to the spreadsheet template and click on the home icon and copy the same entry to another sheet i am entering the ryt and click on copy so this will copy to a new spreadsheet so information is copied to general id you can see our next general id is next which is auto generated so i will make little changes to general i have like changed the amount over here instead of importing i will go back to the home and write this to a file and use same directory which i use for saving the template you could also use another directory you could keep a default name or change the file name here you have options to write multiple files but in our case we will be writing into just one file and i will click on ok after that now it has generated a flag file so if you want to open a file you can open and see i'm clicking on that general underscore right text drive it saved the data in a form of xml this xml can be used to import so i will navigate to new window and traverse to general ledger journals import generals and spreadsheet generals now this is typically done to by peoplesofadmin who has access to this navigation and same person can use the date retained in flat format by one or multiple users to import to system so i will click on add a new value i can also use an existing run control id as well there are few options like general if generally already exist or the general is invalid so i will say abort if general is invalid and same for if it is already existing so i'm going to add the file which i have generated from spreadsheet click on upload now click on the file that you have created now upload this file since the file has been uploaded i can see it here right i will i will click on run button you can ignore these other options as these are related to the integration broker clicking on run so here you see two processes one is for integration broker template and other is for xml link based template which is one we are testing it now so i'll click on ok now i will navigate to process monitor so it will take some time to execute so this is going to import a similar journal which we saw when we import directly from the spreadsheet template so the general has been imported and the process is in success and distributed distribution status is also in post state let's check the details go to message log it would say which file is used for import and how many generals are imported hit return go to view log trace by default there is another file which will provide general id which is imported like you can see it is with our general id 941 now let us go to the system and cross check if we have any other general with same with those general id so we are just cross verifying i enter my business you need voi01 and i need to enter the general id to filter it i click on search so my general id is imported and i see a default message which say general has to be edited by the general edit process before i use it basically you should not edit the generals from here you should be doing it through batch process only i mean in the batch mode itself so this completes the demonstration on how we get a legacy data from a third party application using spreadsheet template in peoplesoft this was an example of general import basically this is all about capturing transaction processing the transaction and reporting in peoplesoft this is a small demonstration video from latest peoples of fscmh on peoplesoft financial management system similar to this we have many other modules and people software for example like this we have asset management we have general ledger we have payables we have billing we have purchasing receivables generalizer examples we have already seen and there are many other modules we'll be discussing all these modules in the upcoming for the videos thank you for watching