Author: Matt Miller

Matt is the civilian comptroller for the 301st Fighter Wing in Fort Worth, Texas and a Reserve finance officer. He spent seven years on active duty before returning home to Texas and beginning the second chapter of his life. He is an avid maker that loves golf, reading, welding, carpentry and tinkering with electronics. An amateur at many things and master of none.

Air Force Robotic Process Automation

Robotic Process Automation (dps.mil)

DAFBOT – Home (dps.mil)

Pin properties panel on the right hand side; unpin the data manager panel

Should be working off 2022.10.14 as of 10/7/2024; available on Software Center for self-download

Manage Packets allows you to download UI Path, Microsoft and DMAS packages; don’t use underscore files under the DMAS profiles

Under advanced options switch to compatibility “Windows-Legacy”

* is used as a wildcard – *Follow Along Text File*

Packages – UiPath.PDF.Activities 3.14.1

Simulate Input Mode vice Hardware Events – Pro Tip

Joshua Gulbrandson, Joseph Harper, Philip Dicicco

UiPath Community Forum

Activities Used

  • Type Into
  • Repeat # of times
  • Set Variable
  • If / Elseif
  • Write Line
  • Switch (add multiple scenarios)
  • Message Box
  • File Exists
  • For Each File in Folder
  • Read Text File
  • Append Line
  • Get PDF Page Count
  • Read PDF Text
  • Extract Images from PDF
  • Extract PDF Page Range
  • Browse for Folder
  • Check App State
  • Use Application/Browser
  • Wait for Download
  • Extract/Unzip Files
  • Use Excel File
  • Sort Range
  • Insert Column
  • For Each Excel Row
  • Write Cell
  • Fill Range
  • Format Cells
  • Rename Sheet
  • Delete Column
  • Write DataTable to Excel
  • Duplicate Sheet
  • Filter

Email Automation Project

  • Use Excel
  • For Each Excel Row
  • If
  • Send Email

Introducing SAF/FMFO Accounting Policy & Operations

As part of a SAF/FMF reorganization, SAF/FMFC-A Air Force Accounting and Finance Office (AFAFO) and SAF/FMFS Air Force Accounting Operations Center (AFAOC) have joined forces as a NEW organization, SAF/FMFO (Accounting Policy and Operations), effective 1 Oct 2024.
This reorganization consolidates Air Force Financial Operations accounting support within a centralized organization, from policy development to implementation and sustainment across the Department of the Air Force (DAF). This merger streamlines access to process owners within a single organization and enhances the customer support already being provided to the Commands by increasing the breadth and depth of reach back support.

SAF/FMFO consists of four divisions covering the scope of work and quality products Air Force FM professionals have come to expect from AFAFO and AFAOC – now in one organization. SAF/FMFO’s divisions include Customer Support led by Mr. Bill Sanders, Field Support led by Ms. Kim Burnett, Policy led by Ms. Mick Hale, and Technical Support led by SAF/FMFO Deputy, Mr. T.J. Souza.

Our customers and FM systems users will still have access to help desk support, Subject Matter Expert (SME) knowledge, Power BI research modules, policy management, monthly users forums, dedicated fiscal year end closeout support, and so much more. With SAF/FM resources better aligned, we are looking forward to this exciting new venture and strive to deliver on our mission to provide overarching DAF FM accounting policy and customer support to strengthen user proficiency, including continuing education, targeted assistance, systems operation and monitoring, data analytics, internal controls, and strategic communications.

Organizational change is essential in today’s ever-transforming business environment and is necessary for maintaining relevance and posterity. Rest assured that our vision will always remain the same – Success through Customer Focus. We here at SAF/FMFO are thrilled to continue supporting the world’s greatest airmen and guardians.

If you have any questions or feedback, please contact SAF.DEAMS.StratComms@us.af.mil.

New Power BI DAF FM Certification Status Tool

DAF FM Team,

Drumroll, please! We are excited to present our newest innovation – the interactive DAF FM Certification Status Tool! Out with the old, clunky MACRO enabled Access Databases, and in with the new PowerBI Dashboard that streamlines FM Certification progress, with refreshes at least once a week.

What do you get with this new tool? Everything you had with the prior Metric’s Access Databases and so much MORE!

This dashboard includes overviews of Program Health including your unit’s Good Standing rating with filtering capability, Command Standings, Pending Approvals for package tracking, an expanded CET Status page including all the cycles, Individual Status to monitor progress, and a page dedicated to Supervisor Status where they can see their assigned personnel’s progress all on one place.

Looking for the historical metrics? They are still located on SharePoint if you wish to delve into past metric trends.

With the new DAF FM Certification Status Tool, staying informed has never been easier. Want to learn more about the new Status Tool? Join us as we demo via MS Teams on the following dates:

AM Morning Session: 13 Jun 2024 at 0900

PM Afternoon Session: 26 Jun 2024 at 1500

Have questions or feedback? Let us know what you think!

V/r,

SAF/FM Workforce Development

________________________________

Stay in-the-know with upcoming webinars, development opportunities, tools, and more:

myFMHub: http://www.myfmhub.hq.af.mil/ 

FM Professional Development Hub SharePoint: https://usaf.dps.mil/teams/fmhub

Facebook: https://www.facebook.com/USAFComptroller

LinkedIn: https://www.linkedin.com/company/daffm

Best of DEAMS Weekly Messages

AFIPPS Resources and Updates

UPDATED as of 8/6/2021

You are receiving this email notifying you to claim your Air Force Integrated Personnel and Pay (AFIPPS) account.  This will only take a few minutes of your time.

Use the following link:  https://milpds-prod.csd.disa.mil/

o     Using your CAC, select your “Authentication” certificate and Agree to the DoD consent
o     Enter your EDIPI number (10 digit number on the back of your CAC) plus the letter corresponding to your component (“V” for Reserve)
o     Select ‘US Air Force Employee Self-Service’ role
o     View your read-only record in each of the 5 tabs
o     Verify your own information for accuracy
o     If any information is incorrect, please visit your MPF or local Finance office for updates (you may print the page from the system to share with your local HR/FM professional)

It is imperative you review your personal information for accuracy prior to AFIPPS Go-Live targeted for Summer 2022.  This data directly impacts your pay…not just entitlements and allowances (BAH, OHA, bonuses, etc), but leave as well.  You will need to have claimed an AFIPPS account prior to taking leave once the system goes live regardless of military category (TR, ART, AGR, etc).

Here are some additional resources available to you:
–      AFIPPS Account Claim User Guide: Detailed guide with system screenshots and step by step directions to assist the user in claiming their account
–     AFIPPS Correcting Inaccurate Information  Reference sheet for correcting personal information
–    Video Demo https://usaf.dps.mil/sites/AFIPPSProgramHub/ProgramDocs/MilPDS%20Self%20Service%20Demo.mp4

The Air Force is quickly approaching the initial phases of the Air Force Integrated Personnel and Pay System (AFIPPS) rollout. AFIPPS will enable accurate and prompt pay to our Airmen, which is an integral part of taking care of our Total Force. System development and strategies for testing and training are in full swing and soon AFPC will send more details on training and AFIPPS account creation. Before this can happen, the AFIPPS Organizational Change Management (OCM) team intends to equip all Force Support Squadron and Comptroller Squadron locations with essential AFIPPS materials.

The OCM team is sending out AFIPPS educational material packages to every FSS to share with their CPTS counterparts. Each package contains a letter from Colonel E. Jonelle Eychner, Chief, AFIPPS Functional Management Office, and Mr. Eric Cuebas, Director, Air Force Accounting and Finance, to explain the intent of the materials and how to display them. Materials include: AFIPPS business cards, AFIPPS posters, and brochures that provide detail on “Why AFIPPS?” and how it will affect the future of personnel and pay. It is important to communicate with the field that not only will AFIPPS improve the 50,000 pay problems reported annually, but it will address the manual work-arounds and pay timeliness issues.

So far, the OCM team has sent out 113 of 266 packages to various Air Force Reserve Command, Air National Guard, and Regular Air Force locations and plan to be complete within the next few months. Their team is working diligently to get the materials printed, assembled, and taken to the local BITC office. If your location has not already received a box of materials, it should be arriving soon. Let them know if you need more of the materials.

For real time access to educational materials, messaging, and updates, visit the AFIPPS Portal page. Informational videos and webcasts are also available on the AFIPPS YouTube playlist. Please keep an eye out on your component’s respective Facebook page for additional AFIPPS related information and visit the AFIPPS page on the AFPC website. The OCM team is available for questions, comments, or concerns at their org box, afpoa.afipps.ocm@us.af.mil.

Resources

AFIPPS Air Force Portal Page

AFPC AFIPPS YouTube Playlist

AFIPPS Data Cleansing

AFPC Facebook Page

AFIPPS Website

OCM Email Org Box

DAFI 65-301 Internal Audit Services

This publication implements Air Force Policy Directive 65-3, Audit Services. It provides guidance on the use of internal audits and other related services to improve programs; make financial reporting more accurate; and ensure public resources are used legally, efficiently, and effectively throughout the Department of the Air Force (DAF). This publication also provides guidance on follow-up policies and responsibilities for monitoring and closing findings and recommendations in internal reports.

SOURCE: AIR FORCE E-PUBLISHING

VERSION: 1 March 2023

AFI 65-202 Administration of Base FM Quality Assurance Program

The instruction implements the Air Force Policy Directive (AFPD) 65-2, Managers’ Internal Control Program. This instruction provides general guidance for the Quality Assurance Manager (QA Manager) to administer the Quality Assurance Program (QAP) in base level financial management (FM) operations. It applies to all civilian and uniformed members of the Regular Air Force, Air Force Reserve (AFR) and Air National Guard (ANG).

SOURCE: AIR FORCE E-PUBLISHING

VERSION: 19 March 2022

Solving the DEAMS PTP Puzzle

Dive into this comprehensive guide where the Command SME team assembles the pieces of the Accounts Payable puzzle. The AFAOC CSME – Solving the PTP Puzzle video will provide you with: 

  • A clear understanding of the Accounts Payable or Procure to Pay (PTP) process in DEAMS. 
  • Insight into the five key components of the process: Purchase Requisition, Purchase Order, Receipt, Invoice, and Payment. 
  • A walkthrough of different payment methods used in DEAMS. 
  • An exploration of various scenarios you may encounter in your work center. 

Whether you’re new to DEAMS or looking to enhance your knowledge, this video is a must-watch. Equip yourself with the tools to navigate the PTP process smoothly and efficiently.