Difference between revisions of "Run Ticket Reconciliation"
| Line 18: | Line 18: | ||
---- | ---- | ||
| − | After continuing from the import screen and a purchaser is not found on a | + | After continuing from the import screen and a purchaser is not found on a ticket for the period you will be directed to this screen. |
| − | This section will only look at | + | This section will only look at tickets that have no purchaser associated with them. The tickets must have a valid purchaser or it will be excluded. |
| − | |||
| − | The | ||
After all site have the appropriate purchaser either Re-import or start the process over. | After all site have the appropriate purchaser either Re-import or start the process over. | ||
Revision as of 18:39, 14 June 2019
With this tool you will be able to import a purchaser statement directly into PRAMS. It will then automatically show how many run tickets are missing and show any high or low variances depending on the threshold set.
Import
From Monthly Processes in the menu select the Run Ticket Reconciliation. This will bring you to the first screen of the wizard, the Import.
This screen will be the parameters needed to start the process. For Period select the month that will be affected.
The Purchaser can be selected from the drop-down menu. This process will have to be done multiple times per purchaser as it can only run one at a time.
Finally select the file from the browser and select open.
Select start import to continue.
Purchaser Check
After continuing from the import screen and a purchaser is not found on a ticket for the period you will be directed to this screen.
This section will only look at tickets that have no purchaser associated with them. The tickets must have a valid purchaser or it will be excluded.
After all site have the appropriate purchaser either Re-import or start the process over.
Ticket Errors and Variances
When all the purchasers have been filled out for each site then this will be the next screen after the import.
This section will be the main part of the wizard showing any errors or variances that have occurred during the import.
Errors displayed will be separated into two grids, PRAMS and Statement errors, that can be searched. The program will look for ticket and tank numbers when searching for matches.
The PRAMS section will show any run ticket that does not have a match for the statement provided.
The Statement section will show any sites that do not have a match in the PRAMS database. An example could be a site that does not belong to the company.
All errors must be addressed as it could result in them being excluded from the final summary causing a difference from what the actual total may be.
The sites that have matching tickets and little to no variance will be displayed at the bottom showing that nothing needs to be done on them.