Difference between revisions of "Run Ticket Reconciliation"
(Created page with "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...") |
|||
| Line 1: | Line 1: | ||
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. | 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 sites product for the period you will be directed to this screen. | ||
| + | |||
| + | This section will only look at sites that have a run ticket for the period provided. | ||
| + | |||
| + | The sites and their products must have a valid purchaser in order to continue. Its recommended to pop this screen out using the controls at the top and fixing each error. You can also export this list to Excel or PDF. | ||
| + | |||
| + | 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. | ||
Revision as of 18:31, 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 sites product for the period you will be directed to this screen.
This section will only look at sites that have a run ticket for the period provided.
The sites and their products must have a valid purchaser in order to continue. Its recommended to pop this screen out using the controls at the top and fixing each error. You can also export this list to Excel or PDF.
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.