| Previous | Contents | Index |
The following is an example of a user audit export file that can be loaded down to your PC.
The first record is the header record.
"username","date","time","module","data1","data2","data3" "TESTER","20030924","130748","UBC_ENTRY","UBC_ENTRY STARTED","","" "TESTER","20030924","131813","PAYMENTS & CHARGES ENTRY", "CHANGE DUES PAID THRU DATE","U24314262","FROM 03/31/2003 TO 09/30/2003" |
+------------Inquiry/Report Procedures-------------+
| |
| Membership Inquiries/Reports |
| ... |
| |
| Other Inquiries/Reports |
| BILLTRANS Billing Transaction Inquiry |
| AFFINQ Affiliate Inquiry |
| AFFROSTER Member Roster with Address |
| SUMAFFINQ Summary Affiliate Inquiry |
| OPTIONS Reports, Letters, Labels |
| MEMLTRLAB Member Letters and Labels |
| DAYBOOK Day Book Report |
| TRSTEEDB Trustee Day Book |
| CHRGPAY Charges & Payments Report |
| FUNDALLOC Dues Fund Allocation Report |
| QTRFUNDALLOC Quarterly Dues Fund Allocation |
| PERMITSINQ Traveler Inquiry |
| PRINTOBLIFORM Reprint Obligation Form |
| EMPBILL Employer Billing for Dues |
| DUESPAID Dues Paid Statement Letters |
| ESTDELEGATE Convention Delegate Estimate R |
| AFFREPLAB Affiliate Report and Labels |
| FINADJUST Financial Adjustments Report |
| 10YRSTATS 10-Year Statistics Report |
| 12MOSTATS 12-Month Active Membership |
| GROWTH Growth Reporting |
| CERTIFICATE Delegate Goodstanding Certific |
| USERAUDIT User Audit Report |
| LM2_REPORT LM2 Report |
+--------------------------------------------------+
|
The LM2_REPORT - LM2 Report menu option creates the LM2 Report.
You select which affiliates to include and the time period to report on.
General Office users can report on all locals, only US, only Canada, locals in a council or a specific local. Council users can get a summary of their own council or one of the locals in their council. A local user can only report on their local.
The report shows the total account receivable, 90-180 days past due and 180+ days past due amounts for the month and year selected. It also shows the liquidated account receivable amount for the prior 12-month period for the date selected.
75.1 Prompts and Responses
The following sections describe the prompts displayed and responses
entered when you create a LM2 report.
75.1.1 Council User Entry Screen
If you are a council user, when the LM2_REPORT menu option is selected,
the following screen is displayed:
ULTRA United Brotherhood of Carpenters and Joiners of America (date)
Arizona State District Council UBC04003
Report On:
Affiliate:
Date :
+-------------Report On--------------+
| Summary - All Locals in Council |
| Specific Local |
+------------------------------------+
<ESC>=Exit LM2 Report <F2>=Back <F1>=Help
|
You are asked for the locals that you want to report on.
+-------------Report On--------------+ | Summary - All Locals in Council | | Specific Local | +------------------------------------+ |
General Office users can report on all locals, only US, only Canada, locals in a council or a specific local.
Council users can get a summary of their own council or one of the locals in their council.
A local user can only report on their local.
If you select "Specific Local", you will be asked for the local that you want to report on.
Local ID? ________ |
Enter the ID of the local that you want to include.
You are asked for the period that you want to report on.
+-Report As Of Date-+ | Last Month End | | Historical | +-------------------+ |
If you select "Last Month End", the report will include data for the previous month.
If you select "Historical", you will be asked for the month and year that you want to report on, and the report will include data for the month and year you entered. The report month is entered as MM/YYYY.
Select one of the menu options.
You are asked if you want to proceed with creating the LM2 Report.
+Proceed-+ | Yes | | No | +--------+ |
Select "Yes" to generate the report.
Select "No" to return to the previous prompt.
If "Yes", the LM2 Report is created.
The following is an example of a LM2 report.
28-Jun-2006 United Brotherhood of Carpenters and Joiners of America
LM2 Accounts Receivable Aging Schedule
Fiscal Year Jun 2005 - May 2006
UBC01444 -- Tucson Eastside
Total Account 90-180 Days 180+ Days Liquidated Account
Receivable Past Due Past Due Receivable
(B) (C) (D) (E)
------------------ ------------------ ------------------ ------------------
$100.00 $100.00 $100.00 $120.00
|
The MASSDUES menu option is used to enter counter dues paid "en masse". If, at your local or council meetings, many members give checks, etc. for dues, you can use this process as a quick or shortcut method to enter dues payments.
When this procedure is used, you only enter the member name or ID, payment amount, and method of payment for each member paying dues. You can then post the payments and, optionally, print receipts.
To enter multiple dues payments, select the MASSDUES menu option on the local processing menu.
+-----------Other Charges / Remittances------------+
| MASSDUES Mass Monthly Dues Entry |
| MASSCHARGE Mass Charges Entry |
| REMIT Employer Dues Remittance Entry |
| PRINTRCPT Print Receipts |
| WORKCARD Print Work Cards |
| |
| Other Financial Transactions |
| OTHERFIN Other Financial Entries |
| WRKPERMIT Traveler Set-up |
| |
| Financial Inquiry |
| EMPDUES Employer Dues Remit Inquiry |
+--------------------------------------------------+
|
This chapter explains how to enter multiple member dues payments.
76.1 Mass counter dues payments Input Screen
After MASSDUES is selected from the menu, the mass counter dues
payments entry screen is displayed.
ULTRA United Brotherhood of Carpenters and Joiners of America (date)
Tucson Local UBC01444
Member Name ID Amount Method Payment Method ID#
+Print Receipts+
| Yes |
| No |
+--------------+
<ESC>=Exit MASS COUNTER DUES ENTRY <F2>=Back <F1>=Help
|
76.2 Prompts and Responses
The following sections describe the prompts used when entering,
reviewing, and posting mass counter dues payments.
76.2.1 Which Day Book
If you are NOT a local user, you are asked which day book the
transactions should be recorded in.
+---Record Transactions in---+ | Member's Local Day Book | | Council Day Book | +----------------------------+ |
Select "Member's Local Day Book" to record the payment transactions in the day book of the local the member belongs to.
Select "Council Day Book" to record the payment transactions in the council's day book.
76.2.2 Print Receipts
You are asked if you want to print receipts.
+Print Receipts+ | Yes | | No | +--------------+ |
Select "Yes" if you want to print receipts for the member dues payments.
Select "No" if you do not want receipts.
76.2.3 Entering Payments
The following prompts are displayed when you enter a payment.
You are asked for the member name or member ID.
Member name or ID? ____________________________________________________________ |
Enter a member name or ID.
After a member name or ID is entered, the member's name and ID are displayed at the top of the screen.
You are asked for the dues payment amount.
Dues paid? 0______ |
Enter the dollar amount of the dues payment.
You are asked for the method of payment - cash, check, etc.
+----Payment Method-----+ | Cash | | Check | | Credit Card | | Electronic Payment | | Fund | | Money Order | | Other Pay Method | +-----------------------+ |
Select one of the payment methods from the displayed menu.
If the payment method is other than "Cash", you are asked for the check number, credit card number, etc.
Enter the appropriate number or ID.
As you complete dues payment entries for members, the total number of entries and total dollar amounts are accumulated, and displayed at the bottom of the screen. For example:
Press <F12> when finished entering payments - Count: 3 Total: 92.00
|
You can enter as many payments as you wish.
After you have finished entering payments, press [F12] to exit payment entry.
76.2.4 Options
After you exit payment entry, you are asked what you want to do next. A
menu bar at the bottom of the screen displays the options. For example:
ULTRA United Brotherhood of Carpenters and Joiners of America (date)
Tucson Local UBC01444
Member Name ID Amount Method Payment Method ID#
Turn, Alex U-5688-6679 27.00 MON_ORDER
Cook, Sandy U-4688-6519 25.00 CREDIT 1234-4321-5678-8765
Thomas, Tommy U-6688-6840 25.00 CHECK 396
+-----------------------------------Options------------------------------------+
| Add Review Post Exit |
+------------------------------------------------------------------------------+
Count: 3 Total: 77.00
<ESC>=Exit MASS COUNTER DUES ENTRY - Receipts: Y <F2>=Back <F1>=Help
|
The options are:
| Add | select ADD if you want to enter more dues payments | |
| Review | select REVIEW if you want to change or delete any of the payment entries | |
| Post | select POST when you have completed all entries and want to post the entered payments | |
| Exit | select EXIT to abandon the payment entries |
If you have entered dues payments, and select "Exit" to abandon the entries, you are asked if you actually want to abandon the payment entries.
+Really Abandon These Payments?+ | No | | Yes | +------------------------------+ |
Select "No" to return to the menu bar and continue on.
Select "Yes" to abandon the payment entries. If "Yes", no entries will be processed.
76.2.5 Reviewing Payment Entries
After you select "Review", the entries are displayed. For example:
+-----------------------------------Review-----------------------------------+ | Finished Review | | Turn, Alex U-5688-6679 27.00 MON_ORDER | | Cook, Sandy U-4688-6519 25.00 CREDIT 1234-4321-5678-8765 | | Thomas, Tommy U-6688-6840 25.00 CHECK 396 | +----------------------------------------------------------------------------+ |
You can change the payment amount, payment method, and check or credit card numbers for one or more entries. You can also delete entries.
After you select an entry from the menu, you are asked what you want to do with the entry.
+Review Options for Turn, Alex + | Change | | Delete | +------------------------------+ |
Select "Change" to make changes to the entry.
Select "Delete" to delete the entry.
If you select the "Delete" option, you are asked if you actually want to delete this entry.
+Really Delete Entry for Turn, Alex ?+ | No | | Yes | +------------------------------------+ |
Select "No" to save the entry.
Select "Yes" to actually delete the entry.
Select "Finished Review" when you have completed all changes, and the menu bar options will again be displayed.
76.2.6 Posting Payment Entries
When you select the "Post" option, you are asked if you actually want
to post the entered dues payments.
+Really Post These Payments?+ | No | | Yes | +---------------------------+ |
Select "No" if you do NOT want to post the payments.
Select "Yes" to post the payments.
If "Yes", payment transactions are created for each entry.
If you need to charge all of the members in your local a common charge, you do not have to enter a charge transaction for each member. You can have the system post a charge to all or selected members of the local.
As an example, you might want to post a $.25 charity donation charge to each member. You could post this charge monthly, quarterly, yearly, etc.
To do an automatic posting of a charge, set up the charge in the affiliate finance codes file (see Chapter 121, FINMAINT - Finance Code Maintenance), and then run the MASSCHARGE - Mass Charges Entry menu option. Charge transactions will be created and posted to all the members you specify.
To do mass charges, select MASSCHARGE from the local processing menu.
+-----------Other Charges / Remittances------------+
| MASSDUES Mass Monthly Dues Entry |
| MASSCHARGE Mass Charges Entry |
| REMIT Employer Dues Remittance Entry |
| PRINTRCPT Print Receipts |
| WORKCARD Print Work Cards |
| |
| Other Financial Transactions |
| OTHERFIN Other Financial Entries |
| WRKPERMIT Traveler Set-up |
| |
| Financial Inquiry |
| EMPDUES Employer Dues Remit Inquiry |
+--------------------------------------------------+
|
This chapter explains how to post mass charges to the local membership.
77.1 Mass Charges Input Screen
After MASSCHARGE is selected from the menu, the mass charges input
screen is displayed.
ULTRA United Brotherhood of Carpenters and Joiners of America (date)
Tucson Local UBC01444
Affiliate ID: UBC01444 -- Tucson Local
Status :
Branch ID :
Class :
Craft :
Dues Code :
Skill Code :
Employer ID :
Meeting Chrg:
Meeting Date:
Finance Code:
Note :
+Charge All Active Roster+
| No |
| Yes |
+------------------------+
<ESC>=Exit Mass Charges Entry <F2>=Back <F1>=Help
|
77.2 Mass Charges Input Prompts
The following sections describe the prompts displayed when entering
mass charges.
You are asked for the affiliate ID.
Note: If you are a local affiliate user, the affiliate ID and name are displayed, and this prompt is skipped.
Affiliate ID? ________ |
If a default affiliate ID is provided and it is correct, you can press [Enter] to accept the default. Otherwise, enter the appropriate affiliate ID.
The affiliate ID is required. The affiliate must be active, and exist in the affiliate file.
You can enter the affiliate number which is a number from 1 to 99999, or enter the entire affiliate ID.
After the affiliate ID is entered, the affiliate name is displayed.
You are asked if you want to post a charge to all the active members.
+Charge All Active Roster+ | No | | Yes | +------------------------+ |
Select "No" if you want to post this charge only to specific member groups by class, craft, etc.
Select "Yes" if you want to post this charge to all the active members regardless of class, craft, etc..
If "Yes", you will NOT be asked for the class, craft, etc. selections, and the next prompt will be for finance code selection.
If the affiliate has branches, you are asked for the branch ID.
+----------------Branch ID----------------+ | all | |-----------------------------------------| | NOTUCSON North Tucson | | SOTUCSON South Tucson | | MAIN_OFF Tucson Local - Main Office | +-----------------------------------------+ |
Select "all" to include members in all branches.
Select one of the branch IDs from the menu, to include only members of that branch.
A list of class codes is displayed, and you are asked for the codes to be included in this mass charge.
+--------------Select Class Codes---------------+ | all | |-----------------------------------------------| | AGENCY Agency Shop | | APPLICANT Membership Applicant | | APPRENTIC1 Apprentice level 1 | | . . . . . . | | APPRENTIC8 Apprentice level 8 | | APPRENTICE Apprentice | | BECK Beck Objector | | CONTRACTOR Contractor Member | | DISABLED Disabled Member | | EARLYRET Early Retired | | HONORARY 50 Yr Honorary Member | | INSERVICE Called Military Service | | LIFE Life Member | | MEMBER Member - Regular | | PREAPPREN Pre-apprentice | | RETIRED Retired Member | | WALKAPP Walkin Apprentice - non member | | WALKIN Walkin Journeyman - non member | +-----------------------------------------------+ |
You can select one, several or all class codes.
Select "all" to include all class codes, or select the specific codes you want to include.
Your selections are displayed in the top portion of the screen.
| Previous | Next | Contents | Index |