- AFAOC Field Support – Non-DTS Travel ODL (Who Wants to be a SME?)
- AFAOC Field Support – AF/SF Airlift Debt (Blog) (Analytics)
- Funds Control Level in DEAMS Explained
- What is the Open Document Listing (ODL)?
- Forensic Analyst Dashboard
- Introduction to DEAMS Reimbursements
- How to Update Your Profile via FAMS
- Guidance on Invoice Holds & How to Clear Them
- AFAFO Adjustment Voucher Policy
- AFAOC Data Analytics – What is a Status of Funds? (38 min)
- AFAOC Field Support – Advana DAR-Q (4 min)
- AFAOC Field Support – Non-Temporary Storage and Personally Owned Vehicles (7 min)
- AFAOC MCSME – Balancing Target Loads with Funding Documents (5 min)
- DEAMS Help Desk – How do I add a new BPN to the BPN field LOV in DEAMS iProcurement? (4 min)
- DEAMS Help Desk – How do I add a DoDAAC to the Contracting Office field LOV in DEAMS iProcurement? (5 min)
- DEAMS Help Desk – How do I fix an incorrect address on an existing BPN or a printed Requisition? (5 min)
- AFAOC Legacy Help Desk – Okta: New Authentication for AFM and FMSuite (3 min)
- DFAS – Accounts Maintenance & Control DEAMS Reminders (3 min)
- New Export Option in PowerBI Services: What changed? The default option for Summarized data export is now a LIVE connection through Azure that allows up to 500,000 rows. This Live connection means that it will remain a live connection each time you open that exported file. It queries the data and brings in the most current information for the filters you exported.
- Target Loads & Initial Distribution: The Continuing Resolution has been replaced with an actual budget which means Initial Distribution (ID) is on everyone’s mind. Be ready to receive your ID by reviewing the DEAMS Users Group video blog post, Target Loads & Initial Distribution, as briefed by Roger Marchese, our AFSOC MCSME.
- Lost Questions for the DEAMS Users Group: Have you ever asked a DEAMS question in milBook and not had it answered? Chances are, the question may not be in the DEAMS Users Group. Take a look at the video Moving Questions to the DEAMS Users Group which illustrates how to move questions from other places in milBook, into the DEAMS Users Group.
- DEAMS Miscellaneous Payments Training: DEAMS Miscellaneous Payments Basic Users Training is scheduled for 15-16 March, 1000-1600 ET, and the Experienced Users Course is scheduled for 20-23 March, 1100-1300 each day, with a different topic each day. Visit the DEAMS Outreach Portal for more details!
- AFAOC Analytics PowerBI Suite Deep Dive Mr. Josh Johnson, AFAOC Data Analytics, presents a comprehensive AFAOC Analytics PowerBI Suite Deep Dive.
- Manual (Non-DTS) Travel Purchase Orders & Connecting Travel ODL to Non-DTS Travel POs AFAOC Field Support is pleased to present two videos as part of the October/November 2022 AFAOC Monthly Users Forum! First, Ms. Amanda Robbins presents Manual (Non-DTS) Travel Purchase Orders, followed by Mr. Dan Thurston presenting Connecting Travel ODL to Non-DTS Travel POs.
- DEAMS Adjustment Vouchers In this MCSME video, Lynea Stoudemire discusses DEAMS Adjustment Vouchers, the SF 1081 and the OF 1017-G (Journal Voucher).
- DEAMS Invoice Responsibilities Overview Ms. Amanda DeRussy, DEAMS Help Desk, presents DEAMS Help Desk – DEAMS Invoice Responsibilities Overview.
- What’s in a Screenshot? Discusses Best Practices for Information to Send for Your Help Desk Ticket.
- The Mystery of the Missing Quantity Box in DEAMS iProcurement What to do When the Quantity Box is Not Showing in DEAMS iProcurement During a Blue Dot Change Decrease/Cancellation.
- LeaveWeb Update Mr. Dylan Clark, AFAOC Legacy Help Desk, presents LeaveWeb Updates.
- DEAMS PTEOs and Legacy Address Builds Ms. Jessica Moirs, DFAS, presents DEAMS PTEOs and Legacy Address Builds.
- Using Microsoft Edge for DEAMS (Settings for Launching Java)
- Don’t worry if Microsoft’s Internet Explorer 11 (IE11) goes away. You can still access DEAMS by using Microsoft Edge.
- Mr. Steve Shuler, AFAOC Field Support, presents Miscellaneous Payment Program Invoices on Hold as part of the March 2022 AFAOC Monthly Users Forum.
- AFAOC DEAMS Help Desk – Common Errors when Adjusting GPC Purchase Orders
- Ms. Amanda DeRussy, AFAOC DEAMS Help Desk, presents Common Errors when Adjusting GPC Purchase Orders as part of the March 2022 AFAOC Monthly Users Forum
- DFAS – GPC Transactions
- Ethan Doody, DFAS Limestone, presents GPC Transactions as part of the March 2022 AFAOC Monthly Users Forum.
- Guide for Travel ODL Research
- The Desktop Guide for DEAMS Travel ODL Research is available to assist users clear open aged travel orders in DEAMS. This Guide contains real examples with step-by-step instructions and screen shots to walk you thru the research process.
- AFAOC MCSME – Target Loads & Initial Distribution
- Roger Marchese, the MCSME for AFSOC, covers key elements when preparing for and loading Initial Distribution. He covers target load components users need to be familiar with, common mistake areas when loading Initial Distribution and reports to pull to locate CRA/Emergency target loads
- How to search in the DEAMS Users Group
- There are different areas of responsibility in DEAMS and a great source for getting answers to your question may be as easy as searching the DEAMS Users Group. Our team of DEAMS SMEs strives to provide remarkable customer service as quick as we can, but sometimes you need an answer now.
- Balancing R60 and STH
- What reasons might there be for the R60 to be out of balance with the STH and how can we use these reports to provide more accurate budgetary projections? Are there better civilian pay reports that can be used for budget analysis and projections? Let find out…..
Category: Systems
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
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.
Who to Call for Systems Issues
GAFS
- Systems related issues can be reported to the DFAS AF Help Desk by email to: dfas.dscc.jas.mbx.cco-af-helpdesk@mail.mil or telephone 614-701-4357, DSN 791-4357
- Option 1 – Air Force systems account maintenance including access requests and resets/unlocks
- Option 2 – CASH systems account maintenance including access requests and resets/unlocks
- Option 3 – Air Force Systems job status and system availability
DEAMS
• Systems related issues (i.e. system not performing, log-in resets, documents stuck, etc.) should be reported using the Self Service Portal (https://c1snow.cce.af.mil/saffm?id=sc_home_saffm), calling the DEAMS Help Desk (DSN 787-4377; Comm: 937-257-4377) or submit an email trouble ticket to: DEAMS.HELPDESK@us.af.mil
Legacy
• Accounting System processing questions, including FRC, AFM, CRIS, FMSuite, and JOCAS II must be routed through the AFAOC Legacy Help Desk, saf.fmpaffso.customerservice@us.af.mil
Power BI Model Size Optimization
Power BI Performance Optimization – Zerbra BI
How to Reduce the Size of Power BI File in a Few Steps – Radacad
Optimizing Power BI Reports – phData
GitHub Federal Business Applications
Steve Winward doing some incredible work with Microsoft PowerApps in the Federal sector. Great resource for training, how to operate O365 within government and tools you can repurpose.
AFRC – How to Load and Distribute Funds in PBAS
FY23 2nd Quarter FM Systems Newsletter
PowerTrack/Syncada MORDs
- Reviewing PowerTrack/Syncada MORDs PowerPoint
- DEAMS Outreach Portal
- DCBS and Syncada Training folder
- FY20 Misc MORD Guidance
- TPPS-T Business Intelligence (BI) Training and Reporting
- How to gain access to Syncada
- Great 3 pager on Syncada MORDs START HERE!
- DEAMS User Forum Syncada Training
- Request TAC via Logistics Tool Suite (TLS)
- Request help at mailto:AFMC.A4RTLTSSupport@us.af.mil
- TGET Access: https://beis-web.csd.disa.mil/beis/
Commercial (Syncada, C-MORD)
Legacy – NP in 11th and 12th position in SDN. PC Code ST. Base obligates.
DEAMS – MP in the 11th and 12th position in SDN. Planned PO. Requisition (PR) Amendment will have Purpose code “0” (zero). Original PO with Purpose code P auto obligates. Approved PR Amendments must be associated to Original PO. Do not intermix EEIC/OCs on Transportation MORDS.
See Object Classes/EEICs below to use for the HHG/NTS
See below for the acceptable Object Classes/EEICs available
Processed via US Bank – Syncada, https://portal.syncada.com/USBank/Login.aspx
Training audio file and slides for Syncada BI Funds Manager reports is located in the Syncada folder at : https://usaf.dps.mil/sites/10194/Knowledge_Base/Shared_Documents/DCBS_and_Syncada_Training/
Organic (AMC/DCBS/OCONUS, G-MORD)
Legacy – MM in 11th and 12th position in SDN. PC Code G. Base Obligates
DEAMS – MM in the 11th and 12th position in SDN. Standard PO. Base manually obligates. Check IPROC to ensure the MORD is listed in the Order Column
Charges Processed by AMC via DCBS to DFAS, https://dcbs.transport.mil/. Email DCBS.Helpdesk@us.af.mil for DCBS access instructions Sign up for TAC Monitor Role on your DD 2875
See below for the acceptable Object Classes/EEICs available
Preval in the 1st 6 business days of the month. Training video for DCBS pre-val is located in the DCBS folder at :
https://usaf.dps.mil/sites/10194/Knowledge_Base/Shared_Documents/DCBS_and_Syncada_Training
- OCONUS PCS Shipment, OCONUS Cargo (Freight) require both a commercial and an organic MORD
- MTA/PAX Organic Accounting (G-MORD) must be sent to the DCBS.Helpdesk@us.af.mil. The subject line should include MTA/PAX MORD, CAER account #, and CIC.
- Freight/CARGO (Commercial/Organic) cannot use the EEIC/Objects classes designated for Commercial HHG and NTS:
- For HHG, HHG Prog Code, HC = 46200 or 220.1101, 46203 or 220.1103, 46250 or 220.1104 , 55792 or 257.2292, 55793 or 257.2293
- For NTS HHG Program Code, HS = 55791 or 257.2291
- All others OC/EEICs allowed will be coded Freight and the HHG program field should be blank
- HHG Prog Code in TGET is the driver to the Syncada Chart of Accounts (COA) for invoicing
- Commercial MP MORDS cannot use EEICs for Organic MM MORDs
- Organic MM MORDS cannot use OCs that crosswalk to EEICs that begin with 462% (those are for Commercial purposes)
- Please review OCs in the 253 category to select the best OC/EEIC
- MM MORDS need to be manually obligated at base level. Please double check to be sure both the requisition and purchase order are approved
- The Purchase Order/MORDS must be obligated for the document to flow to TGET
You must check TGET to ensure your MORD/LOA is properly loaded to TGET (this usually occurs 3-5 days after obligation):
For how to check TGET Review the audio or video files located in the DCBS or Syncada folder at: https://usaf.dps.mil/sites/10194/Knowledge_Base/Shared_Documents/DCBS_and_Syncada_Training
Misc Payments MORDS Purpose Codes
IPAC Information
IPAC is a way for Federal Program Agencies (FPAs) to transfer funds from one agency to another with standardized descriptive data.
IPAC has three components:
- IPAC
- Retirement and Insurance Transfer System (RITS)
- Treasury Receivable Accounting and Collection System (TRACS)
PPBES Replaces ABIDES
Advana Notes
Favorite DEAMS Videos
DEAMS Sandbox Info
Username and Password are located near the bottom of this page
Data Universal Numbering System (DUNS) to Unique Entity Identifier (UEI) Transition Effective 4 Apr 2022
DEAMS Users will be impacted by the transition from Data Universal Numbering System (DUNS) to Unique Entity Identifier (UEI) codes, which is currently expected to occur on 4 April 2022. Those with DEAMS Supplier Maintenance and Creation Responsibility will be most impacted.
In DEAMS, the DUNS number has been a nine-digit non-indicative numbering sequence used to identify specific vendors, assigned and managed by Dun & Bradstreet since 1962. In October 2020, the Office of Management and Budget (OMB) directed a Government-wide transition from DUNS to UEI codes to be completed by April 2022. This transition impacts Government Information Systems that use or collect Supplier information, and streamlines how an entity (anyone who does business with the government) receives their ID. UEI codes are scheduled to be activated in DEAMS on 4 April 2022.
Entities already registered in the System for Award Management (SAM) were automatically transitioned from DUNS to UEIs. Information on creating a new UEI is available on the General Services Administration website at https://www.gsa.gov/about-us/organization/federal-acquisition-service/office-of-systems-management/integrated-award-environment-iae/iae-systems-information-kit/unique-entity-identifier-update.
“If your entity is registered in SAM.gov today, your Unique Entity ID (SAM) has already been assigned and is viewable in SAM.gov. This includes inactive registrations. The Unique Entity ID is currently located below the DUNS Number on your entity registration record.”
For DEAMS Users, the biggest difference will be the number of characters in the field (9 DUNS/12 UEI). To assist Users in selecting the correct UEI site number for a vendor, DEAMS Job Aid “Supplier Record Research_SPD.docx” provides an overview of the process and references other job aids, depending on which responsibilities are being used for the actions. To help ease the transition from DUNS to UEI, a crosswalk will be made available at “go live” on the DEAMS Outreach Portal to help users identify correct vendor records in DEAMS. This crosswalk will only contain existing vendors; it will not capture new entities following the transition.
Our DFAS partners are responsible for creating and maintaining the UEI list in DEAMS, and in the event of interface errors, they may need to validate UEI codes in SAMs. The SAMs site lists the UEI for a supplier right below the corresponding DUNS, simplifying the validation process.
Questions should be addressed to users’ respective MAJCOM/CCMD SMEs, or the DEAMS Help Desk.
For any further messaging, access the DEAMS Users Group on milBook.