How to work your DASF using excel
< Back

GCSS-Marine Corps How-To Videos

This series of videos is intended to help Marines transact in GCSS-Marine Corps
  • How to work your DASF using excel

    05/07/2014 | 02:26

    How to work your DASF using excel

    Created 05/07/2014
    00:01:54 If this redistribution was sent via a Service Request using the charges line you won't be able to process a D6T; you'll have to process a COR to close the DASF record
  • How to use the Serial Number form in GCSS-MC

    05/07/2014 | 02:53

    In this video I show you how to see all the transactions that processed against a specific serial number in your inventory

    How to use the Serial Number form in GCSS-MC

    Created 05/07/2014
    00:00:04 This will only work if the serial number is in your Inventory Org
  • How to determine if something failed the internal funds check (Lonesome Demand)

    04/28/2014 | 03:15

    How to determine if a requisition failed the internal funds check by looking for the sales order number

    How to determine if something failed the internal funds check (Lonesome Demand)

    Created 04/28/2014
    00:03:12 If you have a lonesome demand with a sales order number give it a day and you should see follow on status. Or just call the SoS. I've seen lonesome demand with a sales order and the next day the unit received the BA and AS1
  • How to fix perpetual inventory without running any reports

    04/28/2014 | 11:12

    In this video I will show you how to look for the requisition that ordered a part without using any reports

    How to fix perpetual inventory without running any reports

    Created 04/28/2014
    00:08:16 I mean "sub-inventory transfer"
    00:08:50 I'm self diagnosed with ADHD
  • How to use the FSMAO reports to clean up your perpetual inventory

    04/28/2014 | 08:25

    This video will show you how to use the reports generated by FSMAO-West to clean up your perpetual inventory.

    How to use the FSMAO reports to clean up your perpetual inventory

    Created 04/28/2014
    00:01:45 FSMAO_W_TXN history is the voucher dump and FSMAO_W_Subinventory is the perpetual inventory report
  • Changing text format for concurrent requests from RTF to PDF

    04/03/2014 | 05:20

    How to correct a problem when running a CMR or MPR and it gives you the report in a Word format vice PDF

    Changing text format for concurrent requests from RTF to PDF

    Created 04/03/2014
    00:02:27 Shout-out to Yasser AguilaTodd who taught me this cool trick
  • How to run an MVGL with the correct statement from MCO 4400.150

    03/28/2014 | 00:48

    This video is an update since MCO 4400.150 has now replaced MCO P4400.150E

    How to run an MVGL with the correct statement from MCO 4400.150

    Created 03/28/2014
  • Using my custom MAL report

    03/15/2014 | 04:20

    How to pull a custom MAL report. I'll have to share it with you in order for you to be able to pull this report. And you need access to writer to modify it.

    Using my custom MAL report

    Created 03/15/2014
  • How to pull a PEB usage report for a sub-inventory

    03/15/2014 | 13:51

    How to pull usage data for a sub-inventory

    How to pull a PEB usage report for a sub-inventory

    Created 03/15/2014
    00:00:18 Thanks to MSgt Elliott for the instructions on how to do this using the Maint Chief Role
    00:13:00 Ensure you make sure you set the pivot table to SUM the count and not to Count
    00:13:45 You shouldn't have to add the Layette and Stage to the PEB if the Marines were performing the debriefs correctly (all from PEB)
  • How to end date a user from a sub-inventory

    03/12/2014 | 02:33

    This video will show you how to end a user from a sub-inventory.

    How to end date a user from a sub-inventory

    Created 03/12/2014
  • How to end date and remove a user from a resource group

    03/12/2014 | 06:16

    This video will show you how to end date someone from your resource group and then how to properly remove them so they no longer appear in the group. This will help you clean up your groups.

    How to end date and remove a user from a resource group

    Created 03/12/2014
  • How to re-generate a DD-1348

    01/26/2014 | 04:23

    This video will show you how to re-generate a DD-1348 as a result of a sales order issue.

    How to re-generate a DD-1348

    Created 01/26/2014
  • Looking out for direct IB modifications to circumvent D9's

    12/02/2013 | 11:28

    Trouble shooting direct IB modifications

    Looking out for direct IB modifications to circumvent D9's

    Created 12/02/2013
  • Explaining why an item is Backordered during a redistribution and Singal Code M (revised 1.1)

    11/13/2013 | 06:00

    Explaining why an item is Backordered during a redistribution and Singal Code M

    Explaining why an item is Backordered during a redistribution and Singal Code M (revised 1.1)

    Created 11/13/2013
  • How to unreserve an item in perpetual inventory (Revised 1.4)

    11/13/2013 | 05:38

    This video will show you how to unreserve an item in perpetual inventory. This usually occurs when a clerk accidently transacts the move order against the wrong serial number making it unavailable to transact against.

    How to unreserve an item in perpetual inventory (Revised 1.4)

    Created 11/13/2013
  • Tech and research using the IMO

    10/31/2013 | 05:43

    Tech and research using the IMO

    Created 10/31/2013
    00:02:37 This is based on the SERIALIZED ITEM MANAGEMENT (SIM) POLICY, MCBul 4130
    00:04:19 This could also be why you have an item in perpetua inventory and cannot inventory transfer it to the install base
  • How to view all the users within a unit (UIC)

    09/29/2013 | 02:24

    How to view all the users within a unit (UIC)

    Created 09/29/2013
    00:01:48 If a Marine has a User.Name, then he has an account.
    00:02:05 Contact your MSC before attempting to contact me
  • How to run an MVGL with the correct statement.

    09/08/2013 | 03:26

    This video shows you how to fix the issue with the incorrect statement on the MVGL report by simply running my copy of their report.

    How to run an MVGL with the correct statement.

    Created 09/08/2013
  • Questions 4 and 5 of the Property Control Checklist

    05/23/2013 | 05:56

    How to analyze yourself prior to a FSMAO

    Questions 4 and 5 of the Property Control Checklist

    Created 05/23/2013
    00:01:45 You'll have to cutout all the excess to create something similiar.
    00:02:25 Which means your authorization must be dated PRIOR to the transaction date.
    00:04:19 I meant "same sample size"
  • Questions 1, 2 and 3 of the Property Control Checklist part 1

    05/23/2013 | 15:00

    How to analyze yourself prior to a FSMAO

    Questions 1, 2 and 3 of the Property Control Checklist part 1

    Created 05/23/2013
    00:10:00 Not really simplifies but amplifies & gives specific of what is required. Since the DOD Instruction is meant for all services.
    00:12:50 That would be administrative if you can point to the exact transaction which caused the error (by doc # and date)
  • Questions 1, 2 and 3 of the Property Control Checklist part 2

    05/23/2013 | 02:30

    How to analyze yourself prior to a FSMAO

    Questions 1, 2 and 3 of the Property Control Checklist part 2

    Created 05/23/2013
    00:10:00 Not really simplifies but amplifies & gives specific of what is required. Since the DOD Instruction is meant for all services.
    00:12:50 That would be administrative if you can point to the exact transaction which caused the error (by doc # and date)
  • Question 6 of the Property Contol Checklist

    05/24/2013 | 05:15

    How to analyze your own unit

    Question 6 of the Property Contol Checklist

    Created 05/24/2013
    00:03:50 For Y04, even though there are multiple errors. It only counts as one for the purpose of this question. 7 of 11 are correct
  • How to keypunch a command adjustment

    05/06/2013 | 03:30

    How to do a command adjustment

    How to keypunch a command adjustment

    Created 05/06/2013
  • How to use the CV VAL Inventory Role

    05/06/2013 | 07:04

    Explaining how to use the CV VAL Inventory Role

    How to use the CV VAL Inventory Role

    Created 05/06/2013
    00:06:50 You may not have access to all the table. This is due to the EUL (end user layer) that we have access to.
  • How to use the CV VAL Trading Community Role

    05/07/2013 | 03:58

    How to veiw the FAD for a unit, whether the unit is classified as a GCSS unit and the AAC assigned to a particular UIC.

    How to use the CV VAL Trading Community Role

    Created 05/07/2013
    00:02:25 If there is a problem with how allowances are rolling up on the MAL. It could be associated to the AAC assigned in this field. This is something to check for any UDP units.
  • How to use the CV VAL Bill of Material Role

    05/07/2013 | 03:17

    This role will help you see the allowances for any unit in the Marine Corps but you can also do this with the many other roles.

    How to use the CV VAL Bill of Material Role

    Created 05/07/2013
  • Open on DASF, Closed SRs

    05/07/2013 | 06:24

    This is similar to open in SASSY, Closed in MIMMS

    Open on DASF, Closed SRs

    Created 05/07/2013
  • How to create a parent/child relationship

    05/10/2013 | 04:05

    This video will show you how to create and expire a parent/child relationship.

    How to create a parent/child relationship

    Created 05/10/2013
    00:01:47 You could also look at the usage code which should have changed from "In Relationship" to "Out of Enterprise"
    00:02:26 This process will only work if the item is not in perpetual inventory. You will have to inventory transfer it from perpetual to the install base.
    00:03:31 You have to open a service request on the parent serial number. Then you can debrief the child from perpetual inventory, that'll create the parent/child relationship.
  • Explaining a CMR error, when the CMR AO and RO doesn't match the install base

    12/11/2012 | 02:13

    This video will explain how to fix the error when the AO and RO don't match on the CMR's and Install Base

    Explaining a CMR error, when the CMR AO and RO doesn't match the install base

    Created 12/11/2012
  • Mass Edit Error when attempting to Find Instances

    11/01/2012 | 01:46

    This video describes an error when attempting to find instances. When attempting to conduct a mass edit.

    Mass Edit Error when attempting to Find Instances

    Created 11/01/2012
  • How to clean up your DASF if you have Due Out's that were never shipped

    11/02/2012 | 05:32

    How to clean up your DASF if you have Due Out's that were never shipped

    Created 11/02/2012
    00:03:11 The Request Cancellation button will create an AC1 (request for cancellation) and the BQ status to remove the requisition from both DASF's
    00:03:38 I switched roles so that's why my screen looks different
    00:04:52 This will clean up the sending unit's Due Outs and the receiving unit's Due Ins
  • Explaining how to select an AO or RO when they are not in the list of values

    11/02/2012 | 07:17

    This video will explain how to override the contacts table when attempting to find the AO or RO for assignment within the install base parties.

    Explaining how to select an AO or RO when they are not in the list of values

    Created 11/02/2012
    00:02:30 The contact table feeds the list of values for RO's and AO's
    00:03:06 You must contact the help desk in order to update the contacts table
    00:03:46 This is a work around, you must still contact the help desk to update the contacts table
    00:04:54 This will also work if you can't select the AO
    00:06:31 You can override the contacts table but you still need to update the table. Otherwise you'll have to do this everytime, which is NO BUENO
  • How to query the Install Base to find the items that are in your perpetual inventory

    11/02/2012 | 03:57

    How to query the Install Base to find the items that are in your perpetual inventory

    Created 11/02/2012
    00:01:20 Organization Name = AAC
    00:03:42 Usage Code of "In Inventory" = Owner of HQ USMC = Perpetual Inventory = LUBF = NO BUENO!
  • How to troubleshoot items that are Out of Sync

    11/14/2012 | 11:01

    This video will show you how to troubleshoot the error you receive when you process an inventory transfer (or DAD) and it never posts to the install base. It’s a continuation of the video “Inventory transactions missing from the IB”.

    How to troubleshoot items that are Out of Sync

    Created 11/14/2012
    00:02:15 In standard Oracle, Inventory and Install Base are two seperate modules
    00:05:15 Drinking my coffee
    00:06:10 IT TOOK 6 hours for our transaction (or batch) to process
    00:06:30 Which is understandable because that's how we were taught
    00:09:45 The reason it’s important to go back into the inventory transfer form and check the batch again is because initially when the unit did the inventory transfer it appeared that it had processed correctly. So I wanted to show you that it had actually edited out (even though it didn’t give you any kind of error at that time).
    00:10:37 If this is not the error you’re receiving or if this does not resolve your problem take a screen shot of the error in the inventory transfer form and submit a trouble ticket.
  • How to work your DASF using excel
    05/07/2014 | 02:26
    How to work your DASF using excel
    02:26 >

  • How to use the Serial Number form in GCSS-MC
    05/07/2014 | 02:53
    How to use the Serial Number form in GCSS-MC
    02:53 >

  • How to determine if something failed the internal funds check (Lonesome Demand)
    04/28/2014 | 03:15
    How to determine if something failed the internal funds check (Lonesome Demand)
    03:15 >

  • How to fix perpetual inventory without running any reports
    04/28/2014 | 11:12
    How to fix perpetual inventory without running any reports
    11:12 >

  • How to use the FSMAO reports to clean up your perpetual inventory
    04/28/2014 | 08:25
    How to use the FSMAO reports to clean up your perpetual inventory
    08:25 >

  • Changing text format for concurrent requests from RTF to PDF
    04/03/2014 | 05:20
    Changing text format for concurrent requests from RTF to PDF
    05:20 >

  • How to run an MVGL with the correct statement from MCO 4400.150
    03/28/2014 | 00:48
    How to run an MVGL with the correct statement from MCO 4400.150
    00:48 >

  • Using my custom MAL report
    03/15/2014 | 04:20
    Using my custom MAL report
    04:20 >

  • How to pull a PEB usage report for a sub-inventory
    03/15/2014 | 13:51
    How to pull a PEB usage report for a sub-inventory
    13:51 >

  • How to end date a user from a sub-inventory
    03/12/2014 | 02:33
    How to end date a user from a sub-inventory
    02:33 >

  • How to end date and remove a user from a resource group
    03/12/2014 | 06:16
    How to end date and remove a user from a resource group
    06:16 >

  • How to re-generate a DD-1348
    01/26/2014 | 04:23
    How to re-generate a DD-1348
    04:23 >

  • Looking out for direct IB modifications to circumvent D9's
    12/02/2013 | 11:28
    Looking out for direct IB modifications to circumvent D9's
    11:28 >

  • Explaining why an item is Backordered during a redistribution and Singal Code M (revised 1.1)
    11/13/2013 | 06:00
    Explaining why an item is Backordered during a redistribution and Singal Code M (revised 1.1)
    06:00 >

  • How to unreserve an item in perpetual inventory (Revised 1.4)
    11/13/2013 | 05:38
    How to unreserve an item in perpetual inventory (Revised 1.4)
    05:38 >

  • Tech and research using the IMO
    10/31/2013 | 05:43
    Tech and research using the IMO
    05:43 >

  • How to view all the users within a unit (UIC)
    09/29/2013 | 02:24
    How to view all the users within a unit (UIC)
    02:24 >

  • How to run an MVGL with the correct statement.
    09/08/2013 | 03:26
    How to run an MVGL with the correct statement.
    03:26 >

  • Questions 4 and 5 of the Property Control Checklist
    05/23/2013 | 05:56
    Questions 4 and 5 of the Property Control Checklist
    05:56 >

  • Questions 1, 2 and 3 of the Property Control Checklist part 1
    05/23/2013 | 15:00
    Questions 1, 2 and 3 of the Property Control Checklist part 1
    15:00 >

  • Questions 1, 2 and 3 of the Property Control Checklist part 2
    05/23/2013 | 02:30
    Questions 1, 2 and 3 of the Property Control Checklist part 2
    02:30 >

  • Question 6 of the Property Contol Checklist
    05/24/2013 | 05:15
    Question 6 of the Property Contol Checklist
    05:15 >

  • How to keypunch a command adjustment
    05/06/2013 | 03:30
    How to keypunch a command adjustment
    03:30 >

  • How to use the CV VAL Inventory Role
    05/06/2013 | 07:04
    How to use the CV VAL Inventory Role
    07:04 >

  • How to use the CV VAL Trading Community Role
    05/07/2013 | 03:58
    How to use the CV VAL Trading Community Role
    03:58 >

  • How to use the CV VAL Bill of Material Role
    05/07/2013 | 03:17
    How to use the CV VAL Bill of Material Role
    03:17 >

  • Open on DASF, Closed SRs
    05/07/2013 | 06:24
    Open on DASF, Closed SRs
    06:24 >

  • How to create a parent/child relationship
    05/10/2013 | 04:05
    How to create a parent/child relationship
    04:05 >

  • Explaining a CMR error, when the CMR AO and RO doesn't match the install base
    12/11/2012 | 02:13
    Explaining a CMR error, when the CMR AO and RO doesn't match the install base
    02:13 >

  • Mass Edit Error when attempting to Find Instances
    11/01/2012 | 01:46
    Mass Edit Error when attempting to Find Instances
    01:46 >

  • How to clean up your DASF if you have Due Out's that were never shipped
    11/02/2012 | 05:32
    How to clean up your DASF if you have Due Out's that were never shipped
    05:32 >

  • Explaining how to select an AO or RO when they are not in the list of values
    11/02/2012 | 07:17
    Explaining how to select an AO or RO when they are not in the list of values
    07:17 >

  • How to query the Install Base to find the items that are in your perpetual inventory
    11/02/2012 | 03:57
    How to query the Install Base to find the items that are in your perpetual inventory
    03:57 >

  • How to troubleshoot items that are Out of Sync
    11/14/2012 | 11:01
    How to troubleshoot items that are Out of Sync
    11:01 >