Knowledge Base‎ > ‎

Resource Adjustments & Accruals

Resource Adjustments

Instructions:

Resource Adjustment Upload for Practice/Testing:

Use the following template and macro for practicing the Resource Adjustment upload process. This is a downloadable zip file. Be sure to EXTRACT the zipped files, save them to a folder on your computer, and follow the FMS Upload Templates Instructions posted above before using them. Make sure you delete the old template and macro files from your computer.

Resource Adjustment Upload for Production:

Use the following template and macro for practicing the Resource Adjustment upload process. This is a downloadable zip file. Be sure to EXTRACT the zipped files, save them to a folder on your computer, and follow the FMS Upload Templates Instructions posted above before using them. Make sure you delete the old template and macro files from your computer.

Training:




Accruals


Template A Instructions:

Template A Accrual Upload for Testing:

Use the following template and macro for practicing Template A accrual upload process. This is a downloadable zip file. Be sure to EXTRACT the zipped files, save them to a folder on your computer, and follow the FMS Upload Templates Instructions posted above before using them. Make sure you delete the old template and macro files from your computer.

Template A Accrual Upload for Production:

Use the following template and macro for practicing the Service Accrual upload process. This is a downloadable zip file. Be sure to EXTRACT the zipped files, save them to a folder on your computer, and follow the FMS Upload Templates Instructions posted above before using them. Make sure you delete the old template and macro files from your computer.

Template A Accrual Query: Troubleshooting 
  • Why do you not see your PO in Template A accrual query?
    1. PO was not set up correctly with the right item category (Goods vs. Services)
    2. PO was not flagged correctly (Receiving required vs. optional)
    3. PO line is fully ‘received” i.e. accrual already processed
    4. Uncertified voucher accrual already processed for PO

Template B & C Instructions:




Year End Accrual Survival Toolkit

Year End Accrual Reference Materials (link to Google Folder)


Help

  • Contact David Huynh at 510.495.2868 or DHuynh@lbl.gov for questions related to downloading the templates and/or macro errors.