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