The monthly DEAMS Top 10 list is an invaluable resource for staying on top of the latest DEAMS updates. It typically has information relevant to the current budget cycle and has tons of helpful links. It (like almost everything else) is behind the .mil domain, so I’m going to house them here so you can learn when your not connected or after hours.
Category: Systems
PBASweb Information
- PBASweb
- Training Documents
- PBASweb User Guide
- Help Desk Email
- POCs
- Rosetta Brown
- Toni Hanes
PBASweb manages the Reserve Personnel Appropriation (RPA) by offering automated allocation of funding authority and funds management control for HQ AFRC/FM and providing a real-time status of funds, as well as the mileage obligations and expenditures for Military Personnel Appropriations (MPA). Its customer base is HQ AFRC, NAFs, Wings, Commanders, Base Level FM Personnel
Checkout Our Updated Power BI Finance App
I recently added a new ADOS Plan tab to our Power BI App. This tool utilizes a Gantt chart to visualize all orders throughout the year. This view helps Commanders see various duty statuses at a glance and see when their available funding runs out and UFRs begin.
I see this tool changing the way we fund ADOS UFRs and prioritize our needs each quarter. In addition, it helps my RPA analyst forecast quarterly needs much more efficiently.
Solution for ATAAPS Issues
ATAAPS was upgraded in early March from 18.1 to 18.2.2. It appears to have caused an issue with the date for both Leave Requests and Premium Requests and dates in the Reports section.
Below is a suggested fix that clears your Temporary Internet Files and SSL State. If that does not work, try using Google Chrome.
Air-Force-IE-settings-and-SSL-ContentThe Ultimate DEAMS Resource Guide
It’s a full-time job staying on top of DEAMS updates. The first thing you should do is set up multiple SharePoint alerts. That way you’ll get the latest DEAMS news as it’s posted.
This page will be evergreen and serve as a DEAMS timeline. The most important links will always remain on top and then in descending order by date. If you find broken or dead links leave a note in the comments below.
Timeless Links
- R12 Job Aid Index (Searchable Matrix) – Searchable list of all DEAMS Job Aids, categorized by functionality
- DEAMS Outreach Portal – Central repository for all DEAMS info
- AFAOC Monthly Users Forum Searchable Guide – Search through every topic discussed in the Monthly Users Forums, including audio recordings
- DEAMS Users Group – Find answers or ask questions of other DEAMS users and SMEs
- AFAOC Systems Users Training Site – Central location for user training info
- DEAMS Answer Bank – Select the process or issue and complete the targeted questions to find your answer or Job Aid link
- Create an alert on SharePoint to get the latest DEAMS Announcements
- milBook/milSuite site
- DEAM Top 10 List Archive
April 2020
- Retrieving Data from Financial Management Data Quality Service (FMDQS)
- Fund Control Levels Changing – 2 April 2020
March 2020
- New Open Document Listing and Travel ODL Available Daily on Power BI Webpage [View Slides] [Listen to Audio]
- Cancelling GPC Release Shipment Lines
- Do I Need VPN to Access…?
- Initial Distribution Reminder
- Changes to Help Desk Access
- Welcome Back ODL and Travel ODL
- Reimbursement Program: Need to Update an Agreement Funding 1080 LOA, Customer CDS Legacy loa, or DUID?
- Check these Resources for Additional Help
- Current Software Updates
- REMINDER: Check Your General Ledger Dates
- Check “Date Time” of Status of Funds in DEAMS Reports
February 2020
1269 No Longer a Requirement in DEAMS
Per AFAFO’s memo “Defense Enterprise Accounting & Management System (DEAMS) Target Load and Adjustment Process,” there is no longer a need to create/print a hard copy 1269 and obtain wet signatures for loading or adjusting targets in DEAMS. The DEAMS system itself is the “mechanized equivalent.” DEAMS stores the target load information and may be retrieved at any time. The amount, line of accounting, creator, and approver may be validated by querying the target load document from the DEAMS entry screens. The DEAMS Budget Execution Transaction Register (BETR) report and the Target Load Accuracy Tool (TLAT) may be used as reference for validation of what is contained in DEAMS.
SAF-FMFC-AFAFO-DEAMS-1269-Memo-5-9-2019Source:
Deputy, Air Force Accounting Operations Center
Fix to CRIS Log-in Issues
Update your CRIS bookmarks/favorites to the new cloud URLs.
- CRIS – https://cris.cce.af.mil
- CRIS Access Center – https://cris.cce.af.mil/cac
- CRIS News – https://cris.cce.af.mil/#News
Auto-forwarding will cease at the end of February.
In order to get past the ACCEPT screen, you must change your compatibility settings by going to Tools > Compatibility View Settings > REMOVE af.mil, and UNCHECK “Display intranet sites in Compatibility View”.
See the screenshot below.
You may also need to Clear SSL and then close/restart Internet Explorer.
Source:
AFAOC Legacy Help Desk
Phone:937-257-3117 or DSN: 312-787-3117
saf.fmpaffso.customerservice@us.af.mil
Tracking Documents Through the Stages of Accounting in DEAMS
After pulling a Status of Funds – Near Real Time report, use the Selective Transaction History Report to research any transactions. Using the Discoverer Viewer report titled “R12 01 General Ledger Transactions STH – New_Payment Voucher Num” (STH report) returns all updates to documents in the system. By pulling the data into a pivot table (snippet of the pivot parameters provided) users can see the dates and document details as it has moved through the system.
Below are basic research details to follow:
Parameters used for the STH Report
Recommend pulling data by OE, FY and AAI (387700) to limit file size.
Insert the budget-affecting GL Account Codes (GLAC) (found at GLAC Parameter Strings (Cell A4)) to eliminate unnecessary General Ledger entries.
Update on the recent STH duplicates issue
The R12 General Ledger Transactions STH in Discoverer Viewer no longer contains duplicate lines of summary entries. Over the past month, DEAMS advised users to remove duplicate lines identified under the Je Header Id and Je Line Num fields. The STH now includes entries with more complete data. Although you may still see lines with matching Je Header Id and Je Line Num fields, those rows of information now include differences in other columns used to track documents from origination to payment. You no longer need to remove duplicates.
Power BI can handle years of STH data
In a future YouTube video I plan on demonstrating how to build an STH Tool using Power BI. I’ve pulled in every accounting transaction at my wing over the past five years and can finally harness the time intelligence functions available with DAX. You can do impressive day-over-day, week-over-week, month-over-month, or year-over-year analysis amongst other things. Chad Kukorola deserves all the credit for this idea. I had been dreaming of how to do this for years, but Excel always bogged down on me. After reviewing some of Chad’s Power Query code, I was able to make it work in Power BI. Until I get the YouTube video postd, reach out and let me know if you’re interested in seeing what the tool is capable of.
CRIS Migrating to the Cloud Soon
CRIS will be moving to the cloud on or about 10 Feb 2020. While we prepare to make our final move to the cloud, please be aware that any changes made to queries not saved to the local PC after 4 Feb 2020 will not be saved to you CRIS profile. We need approximately 4 days to migrate the data to the cloud so any changes or new queries created after 4 Feb 2020 will not be available in your cloud profile. Any new or modified queries you need after 4 Feb 2020 should be saved to your local computer for later upload to the cloud.
If all goes well, you will automatically be redirected to the cloud instance of CRIS on 10 February. You may notice some minor differences in the cloud. The biggest one will be authentication through the CCE. After ~15 minutes of inactivity, your ‘token’ will expire and you will need to log back in to CRIS (refresh your IE). Yes, you will still need to use internet explorer for several more months.
Direct questions to:
AFAOC FM Systems Help Desk
Phone: 937.257.3117 or DSN: 787.3117
Email: saf.fmpaffso.customerservice@us.af.mil
Hours: M-F 0700-1700
Source: CRIS FMO
As of Date: 4 February 2020
Senior Leader Webchat with CMSgt Kendall Briscoe
In November 2019, CMSgt Kendall Briscoe conducted a Facebook LIVE session where he gave an overarching update on a multitude of issues facing the FM Enlisted team and our Air Force. This is a must listen for both officers and enlisted.
Fast forward to about the 8 minute mark when the briefing actually begins.
Highlights
- 8 min – The FM Our Air Force needs overview
- 12 min – AFIPPS update – Go live date pushed to Jan 2022
- 14 min – Manpower study, Oct 2022
- 17 min – AFIPSS way ahead
- 19 min – Changes to tech school curriculum
- 24 min – Resource Training Center (RTC) & Finance Information Collaborative Space (FICS)
- 27 min – Silver Flag update
- 34 min – FICS
- 39 min – Culture of Training
- 43 min – Resiliency
- 45 min – Q&A from Airmen – Artificial Intelligence/Bots, Business Intelligence, Power BI