Difference between revisions of "Accounting Finance:Statements-Running Customer Statements"
Jump to navigation
Jump to search
m |
m |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==Overview== |
==Overview== |
||
| − | |||
| − | ===Statement Format=== |
||
| − | |||
*There are two types of statements that can be created. These include: Balance Forward Statements and Open Item Statements. |
*There are two types of statements that can be created. These include: Balance Forward Statements and Open Item Statements. |
||
| + | *Since EFT credits has to be done by '''12 pm'''. Running the statements are to be performed early as possible ('''preferably by 9 am''') since one of the '''Balance Open Statement''' require 1.5 hours to process, and printing the statement will also require 0.5 hour. |
||
*Balance Forward Statements provide a detailed list of all customer transactions, both current and future. Customers who receive these statements are setup in the Customer Statement Format Types extension file. |
*Balance Forward Statements provide a detailed list of all customer transactions, both current and future. Customers who receive these statements are setup in the Customer Statement Format Types extension file. |
||
*Open Item Statements provide a detailed list of all customer transactions associated with an Open Item for the statement period. Again customers who receive these statements are setup in the Customer Statement Format Types extension file. |
*Open Item Statements provide a detailed list of all customer transactions associated with an Open Item for the statement period. Again customers who receive these statements are setup in the Customer Statement Format Types extension file. |
||
| − | + | ==Statement Types== |
|
| ⚫ | |||
| − | |||
| − | * |
+ | *'''MM''' – monthly manual |
| ⚫ | |||
| − | *MM – monthly manual |
||
==Running Customer Statements== |
==Running Customer Statements== |
||
| Line 39: | Line 35: | ||
::*monthly (vendor statements at month-end only) (1st only) |
::*monthly (vendor statements at month-end only) (1st only) |
||
Do not run statements at the same time. Wait until the first is completed before starting the next. |
Do not run statements at the same time. Wait until the first is completed before starting the next. |
||
| − | :6. Scroll down and find statement type and statement period |
+ | :6. Scroll down and find statement type and statement period (BA and MM arranged separately. Go to Type and type in statement type to filter) |
:7. Enter '''RU''' next to statement period and press '''Enter''' |
:7. Enter '''RU''' next to statement period and press '''Enter''' |
||
:8. Regenerate statement data '''Y''' and press '''Enter''' |
:8. Regenerate statement data '''Y''' and press '''Enter''' |
||
| Line 59: | Line 55: | ||
[[File:RunStmt9.PNG|400px]] |
[[File:RunStmt9.PNG|400px]] |
||
| − | :14. Find run numbers (the first run is a balance forward statement and the second is an open item statement) |
+ | :14. Find run numbers (the first run is a '''balance forward statement''' and the second is an '''open item statement''') |
::*The “regular” statements have a '''P''' in the ID; the monthly ones end in '''MM''' |
::*The “regular” statements have a '''P''' in the ID; the monthly ones end in '''MM''' |
||
:15. Update statement checklist with the 2 run ID’s |
:15. Update statement checklist with the 2 run ID’s |
||
| − | :16. Go back to STM-RUN/6 to repeat the procedures for '''MM''' statements (month-end only) |
+ | :16. Go back to STM-RUN/6 to repeat the procedures for '''MM''' statements (month-end only) Enter "MM" under Type |
| − | :17. After generating the statements, proceed to [[Finance:Statements-Running List of Statements Not Balancing to ASW]] before printing statements. Make sure there are no discrepancies before printing statements. |
+ | :17. After generating the statements, proceed to [[Accounting Finance:Statements-Running List of Statements Not Balancing to ASW]] before printing statements. Make sure there are no discrepancies before printing statements by running '''RP''' for both BA and MM statements. |
[[File:RunStmt10.PNG|400px]] |
[[File:RunStmt10.PNG|400px]] |
||
Latest revision as of 23:25, 18 December 2020
Overview
- There are two types of statements that can be created. These include: Balance Forward Statements and Open Item Statements.
- Since EFT credits has to be done by 12 pm. Running the statements are to be performed early as possible (preferably by 9 am) since one of the Balance Open Statement require 1.5 hours to process, and printing the statement will also require 0.5 hour.
- Balance Forward Statements provide a detailed list of all customer transactions, both current and future. Customers who receive these statements are setup in the Customer Statement Format Types extension file.
- Open Item Statements provide a detailed list of all customer transactions associated with an Open Item for the statement period. Again customers who receive these statements are setup in the Customer Statement Format Types extension file.
Statement Types
- BA – bimonthly automatic
- MM – monthly manual
Running Customer Statements
- 1. Select 2 Start uniPharm Extensions
- 2. Select 1 VA Company (PRODUCTION)
- 3. Select 1 UWD Extensions
- 4. Select 7 STM -- Statements
- 5. Select 11 View Statement Control Periods
Run statement for:
- bi-monthly (16th and 1st)
- monthly (vendor statements at month-end only) (1st only)
Do not run statements at the same time. Wait until the first is completed before starting the next.
- 6. Scroll down and find statement type and statement period (BA and MM arranged separately. Go to Type and type in statement type to filter)
- 7. Enter RU next to statement period and press Enter
- 8. Regenerate statement data Y and press Enter
- 9. Specify Run Method – enter B for Batch. Always do Batch.
- 10. Press Enter
- 11. Press Enter to confirm
- 12. Go to Work with Jobs and make sure there are no active jobs before proceeding
- 13. Select 5 View Statement Runs
- 14. Find run numbers (the first run is a balance forward statement and the second is an open item statement)
- The “regular” statements have a P in the ID; the monthly ones end in MM
- 15. Update statement checklist with the 2 run ID’s
- 16. Go back to STM-RUN/6 to repeat the procedures for MM statements (month-end only) Enter "MM" under Type
- 17. After generating the statements, proceed to Accounting Finance:Statements-Running List of Statements Not Balancing to ASW before printing statements. Make sure there are no discrepancies before printing statements by running RP for both BA and MM statements.
