How to load Job to Date Earned Revenue for Manual Revenue Recognition

Issue/Symptom/Question

How do I load Job to Date Earned Revenue for Manual Revenue Recognition 

Environment

  • Bridge Load
  • Finance & Accounting > Data Entry > Revenue Recognition > Manual Cost/Revenue Recognition Entry
  • Manual Revenue Recognition for Jobs

Resolution/Fix/Answer

If you have not been trained or do not have access to load files into PENTA please log a Service Desk ticket and reference this task.

  1.  In Excel set up the below file 
  2. Once all fields have been filled in with data,save the file as a Comma Delimited file type 
    1. Only enter This Period Earned OR Job to Date Earned Revenue - Leave || if blank
  3. Open the Comma Delimited file in Notepad
  4. Remove commas (ctrl +H, put comma in the find field, click replace all, click OK)
  5. Save the file as ACS010.bat
  6. Transfer the file via CoreFTP or FileZilla tool
  7. Access the Bridge version of PENTA and navigate to the Manual Cost Revenue Recognition Entry window to load