1 / 21

F9 Advanced Topics

F9 Advanced Topics. This Class Covers. New Functions Budget Write Back Advanced Tools Advanced Report Wizard. Additional Functions. GLTRAN – for retrieving transactional level totals Helpful to get information for non-period ranges JCTRAN – For retrieving Job Cost Transactions

lundeen
Download Presentation

F9 Advanced 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. F9 Advanced Topics

  2. This Class Covers • New Functions • Budget Write Back • Advanced Tools • Advanced Report Wizard

  3. Additional Functions • GLTRAN – for retrieving transactional level totals Helpful to get information for non-period ranges • JCTRAN – For retrieving Job Cost Transactions • GTTRAN – For retrieving Grant Tracking transactions • CODATA – returns additional information about a company • WGL – writes totals to the budgets

  4. GLTRAN • gltran(“account”, “start date”, “end date”, “company”, “type”) • Account – GL account number, can use BSPEC function • From Date – Date in MMDDYY format • To Date – Date in MMDDYY format • Company – CYMA Company Code • Type – “DR” for Debits, “CR” for Credits, leave blank for all

  5. JCTRAN • jctran(“account”, “start date”, “end date”, “company”, “type”, “Job”, “Cost Type”, “Cost Code”) • Account – GL account number, can use BSPEC function • From Date – date in MMDDYYYY format • To Date – date in MMDDYYYY format • Company – CYMA Company Code

  6. JCTRAN • Type – “DR” for Debits, “CR” for Credits, leave blank for all • Job – CYMA Job ID, leave blank for all • Cost Type – • 0=Blank, leave blank for all • 1=Direct Labor • 2=Direct Material • 3=Other Direct Costs • 4=Subcontract Costs • 5=Other Costs • 6=Overhead • 7=Retainage • Cost Code – CYMA Cost Code ID, Leave Blank for All.

  7. GTTRAN • gttran(“account”, “start date”, “end date”, “company”, “type”, “Grant”, “COE”, “Fund Source”, “Program”, “Activity) • Account – GL account number, can use BSPEC function • From Date – Date in MMDDYYYY format • To Date – Date in MMDDYYYY format • Company – CYMAIV Company Code

  8. GTTRAN • Type – “DR” for Debits, “CR” for Credits, leave blank for all • Grant – CYMAIV Grant ID • COE – CYMAIV COE ID. Only used for expense transactions. Leave blank for all. • Fund Source – CYMAIV Fund Source ID. Only used for revenue transactions. Leave blank for all. • Program – CYMAIV Program ID. Leave blank for all. • Activity – CYMAIV Activity ID. Leave blank for all.

  9. CODATA • =codata(“Data”, “Company”) • Data can be the following values • Name – The Company name from Maintain Company • Period - the current fiscal period • F9Period - the fiscal period set in F9 Setup • Year - the current fiscal year • Main - the segment number of the natural account code • Segments - the number of segments in the account code structure • StartN - the start date of fiscal period N • EndN - the end date of fiscal period N • Company – CYMAIV company code

  10. Budget Write Back(WGL) • The WGL function is used for writing budget amounts outside of the budget write back feature. • =wgl(“amount”, “account”, “period”, “Company”, “Year”, “Type”) • Amount – value to write to file • Account – account number, can use BSPEC but cannot use ranges or wildcards • Period – period to write to • Company – CYMAIV company code • Year – Year to write to • Type – “Budget” or “Revised”

  11. Additional F9 Menu Items • Set-Up • Drill Down • Chart • DLL Help • Period Wizard • Enquire • Budget Write-Back • Analyze • To Viewer/Email

  12. F9 Set-Up Menu • Used to test connection between CYMAIV GL and Spreadsheet • Point to location of the CYMAIV Program Files • Used to set period and year defaults

  13. F9 Drill Down • Allows you to see the underlying transactions that comprise any GL figure • Drill by account segment or transaction • Copy and paste results

  14. F9 Period Wizard • Helps You Build The Period Specifier Syntax You Need

  15. F9 Chart Menu • Used to return lists from the CYMAIV GL that can be pasted into spreadsheet • Use as starting point • Also used with Budget Write Back Feature

  16. F9 Budget Write-Back • A great tool for annual budget preparation • Extract data from CYMAIV , prepare budgets in Excel • Use BWB to re-populate the CYMAIV Budget files • Live Demo

  17. Enquire • Get Balance • To Chart • To Drill

  18. To Viewer/Email • Used to send a spreadsheet to others without F9 • Removes all formulas and leaves the values • Adds a note to the cell that contains the formula that was removed

  19. Analyze • Use to determine if you are missing accounts • F9 "takes notes" as to what accounts are being accessed. • Creates a new spreadsheet

  20. DLL Help • Help on Functions

  21. Report Wizard • Using Ranges • Edit Descriptions

More Related