1 / 39

Masterpiece Special Topics

Masterpiece Special Topics. Facilitator: Paul Lamberts Panel Members: Malcolm Parsons, Shared Services SA Eddie Mallen, Shared Services SA Steve Wood, SWOOD Paul Johnson, PJR Tom Fox, Infor. Barbara Nunan, Shared Services SA. Can you please demonstrate the AR860 screen?. EM.

lynda
Download Presentation

Masterpiece Special Topics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Masterpiece Special Topics Facilitator: Paul Lamberts Panel Members: Malcolm Parsons, Shared Services SA Eddie Mallen, Shared Services SA Steve Wood, SWOOD Paul Johnson, PJR Tom Fox, Infor

  2. Barbara Nunan, Shared Services SA Can you please demonstrate the AR860 screen? EM

  3. G/L Account Transaction Inquiry Filter AR860 Panel • The G/L Account Transaction Inquiry Filter AR860 panel allows you to select a range of customers, dates, obligations, and remittances to view the GL account transactions. EM

  4. G/L Account Transaction Inquiry Filter AR860 Panel EM

  5. G/L Account Transaction Inquiry Filter AR860 Panel EM

  6. G/L Account Transaction Inquiry Filter AR860 Panel EM

  7. G/L Account Transaction Inquiry Filter AR860 Panel EM

  8. G/L Account Transaction Inquiry Filter AR860 Panel EM

  9. The End! EM

  10. Ian Smith, DPC • Can we have a demonstration on how to search across multiple PDF documents? • FAST recommends that clients receive Masterpiece reports, Vendor Audit reports, etc. as a PDF attachment to an automatically-generated email (from SYS1). • The PDFs should be saved to an appropriate directory and stored on the network. MP

  11. Ian Smith, DPC • Can we have a demonstration on how to search across multiple PDF documents? • Benefits of storing related PDFs in a suitable network directory. • Available to all users that have access to that directory • Very easy to search across all of those PDFs • “Demonstration”. MP

  12. Searching multiple PDFs • Open Adobe Reader (DPC is currently using version 11.0.6). • Under the Edit menu, select Advanced Search. • Under Where would you like to search?, select All PDF Documents in • Using the drop down list, select Browse for Location… MP

  13. Searching multiple PDFs • Navigate to the directory where your reports are stored. • Enter the text you wish to search for e.g. a Journal Number. • Click on Search. MP

  14. MP

  15. MP

  16. Searching multiple PDFs • By clicking on the + sign next to a document, the instances of the text will be displayed. • Click on the instance that you want to examine, and the PDF will be opened to that page and the instance will be highlighted. MP

  17. MP

  18. The End! MP

  19. Kym Beckman, CAA • With the expanded use of Data Warehouses for storage of historic data, is this considered the appropriate medium for an archive record of purged MP records EM/MP

  20. Kym Beckman, CAA • With the expanded use of Data Warehouses for storage of historic data, is this considered the appropriate medium for an archive record of purged MP records • It is the recommended option. • However, the designer of the Data Warehouse would need to have a good appreciation of the Masterpiece tables being purged and how they inter-relate. EM/MP

  21. Kym Beckman, CAA • The Data Warehouse would need to have appropriate tables and fields defined to store the relevant Masterpiece data. Or do you just extract all fields from all tables being purged? • The hardest thing to determine is whether the Data Warehouse has the right data to be able to answer future queries and provide relevant reports, if required EM/MP

  22. Kym Beckman, CAA • In the past, some agencies used the SALMAT (formerly HPA) Computer Output on Laser Disk (COLD) process to store and access their archive reports. • This technology is quite old now and I am not sure if the software works on Windows 7. Another reason not to use it in the future is that SALMAT’s tape drive is broken so it is harder to get the data to them for processing. EM/MP

  23. Kym Beckman, CAA • An simple alternative to both COLD and Data Warehousing is to create a report data set when running an archive job (SYS1). This report data set can then be FTP’d to the network and burnt to a CD/DVD for posterity. • Whilst this option doesn’t provide indexing like the COLD software does, modern search engines can usually find what you want relatively easily. EM/MP

  24. Kym Beckman, CAA • Another alternative is to create a report data set (on SYS1) and request FAST IT to email it to you as a PDF attachment. • Searching can be performed across multiple PDFs stored in the same directory. EM/MP

  25. The End!

  26. Jon Adamou, SSSA • Could the process in which BASWARE validates an account code pleased be explained? SW/MP

  27. Overnight • Nightly extract from Masterpiece to BASWARE • Vendors • Payments • Account components (AVD table) • e.g. Cost Centres, Fund Codes, Object Codes, etc. • Specific sub-tables within the AVD table for BASWARE • e.g. ID_ABLK_SUFF = 'BW' • Account numbers (AMF table) • All active posting level accounts MP

  28. Software Development Kit • Software Development Kit (SDK) • Microsoft Visual Studio • All Masterpiece applications • Works on all hardware platforms SW

  29. General Ledger • General Ledger account validation • Calls MP Account Server (API) • Checks valid account • Checks AMF • Return code for cause of error SW

  30. Job Cost • Job Cost code validation • Calls various Visual Basic functions • Checks valid components • Project • Project/Task combination • Cost Code • Derives GL account • Validates GL account SW

  31. The End!

  32. Greg Gray, SSSA • How does the journal summarisation function GL323 work, does it summarise all accounts if no mask is included in GL323C? TF

  33. GL321B Journal with 3 sets of duplicate accounts NL-TES-T1 N-LT-EST3 N-LT-EST6 Prior to posting summarise these accounts using Journal Sumarization. TF

  34. GL323A From GL323, select range of Journals to summarize. Note that GL323 can also be used to change the journal period if the wrong period was entered to previously TF

  35. GL323B These are the journal header output options available within GL323. Different Journal ids, period etc. TF

  36. GL323C Select range of accounts to Summarize or not to Summarize. Can also use Account Masking feature. The option shown will summarize all accounts except for NLTEST1 – Omit is set to “Y”. Accounts can either be selected by account type code, account number, or both. All accounts are selected if no range. TF

  37. GL353A Select batches and Schedule Journal Summarization process. Same as Scheduling journals using GL350. TF

  38. GL321B Same Journal with accounts summarized, except NL-TES-T1. N-LT-EST3 N-LT-EST6 are now summarized and N-LT-EST7 remains the same. TF

  39. The End! TF

More Related