End of Month Reports (ARFM105A)

Program Description

This program can be found on the Accounts Receivable File Maintenance End of Month menu (AR-3-6-5). It can be run at the end of the month and allows the user to print various reports automatically. The advantage of using this program is that it can be started at the end of the day and left to run overnight. Reports that are printed for this program must be defined by the user in the End of Month Reports File Maintenance program (AR-3-6-9).

See also:

• End of Month Reports to Disk Option

The report selection that must be set up in End of Month Reports File Maintenance is as follows:

1. * Not Currently Used *

2. Transaction Register

3. Invoice/Credit Memo Register

4. Cash Receipt Journal # 1 (Summary)

5. Branch-Item Sales Report

6. Adjustment Register

7. Cash Sales Register

8. Sales Tax Register #2

9. Sales Tax Allowance Report

10. AR GL Posting Report

11. * Not Currently Used *

12. * Not Currently Used *

13. Cash Receipt Journal # 1 (Detail)

14. Cash Receipt Journal # 2

15. Customer Sales Register

16. Credit Memo Register

17. A/R Aging by Account #

18. A/R Aging by Branch #

19. A/R Aging by Name

20. A/R Aging by Sales Rep

21. Daily Accounts Receivable Totals

22. Month-to-Date Sales by Sales Rep

23. Overdue Report by Customer

24. Overdue Report by Sales Rep

25. Open COA Report

26. A/R Aging by A/R Balance

27. A/R Aging by Item Type

28. * Not Currently Used *

29. * Not Currently Used *

30. * Not Currently Used *

31. Company-Item Sales Report

32. Customer-Item Sales Report

33. Customer-Product Class Sales

34. Sales Rep-Product Class-Item

35. Commission Report

36. Commission by Item Type

37. Commission by Sliding Scale

38. Year-to-Date Sales by County

39. Monthly Sales by Class of Sale

40. Sales by Branch #-Invoice #

41. President's Report by Customer

42. President's Report by County

43. President's Report by Sales Rep

44. President's Report by Branch

45. MTD & YTD Item Sales Analysis

46. * Not Currently Used *

47. * Not Currently Used *

48. * Not Currently Used *

49. * Not Currently Used *

50. * Not Currently Used *

51. * Not Currently Used *

52. * Not Currently Used *

53. * Not Currently Used *

54. * Not Currently Used *

55. * Not Currently Used *

56. * Not Currently Used *

57. Open Orders by Item

58. Open Orders by Customer

59. Open Orders by Order #

60. Back Order Kit Items

61. * Not Currently Used *

62. Variance Report

63. Pending Invoice Report

64. Pending Receipt Report

65. P.O. Stocking Report

66. Stock Activity--Inventory

67. Stock Activity--Billing

68. Inventory Valuation-Warehouse #1

69. Inventory Valuation-Warehouse #2-N

70. Inventory Valuation-Warehouse #1-N

Following is the first screen for running the EOM Reports:

Rev 13 Changes

• A global option was added to Accounts Receivable Control File Maintenance (BI-3-1-18-0) to determine if the dealer has purchased the option to print End of Month Reports to disk, printer, or both. This field is 29. End Of Month Reports To Disk Option (Y/N).

• Also, internal program changes were made to set the proper crammed characters if the global field 11. Dash Allowed In Item Numbers in Billing Control File Maintenance is equal to N for no.

Billing

Home