G/L Activity By Posting Source
General Ledger Menu -> Reports
-> G/L Activity By Posting Source
This utility can be used to output the posted G/L transactions
by source within a selected date range, to a spreadsheet.
The transaction details on the spreadsheet include the transaction
number, G/L account number and description, date, dollar amount,
source, reference, details, posting source, posting reference
number, the operator code & and name associated with the posted
GL Transaction, and the system date at time of posting.
Transactions generated by an A/P posting also include the Vendor
number, name, P.O.# for the A/P Invoices and Vendor Invoice
Date.
Transactions generated by an A/R posting include the Customer
number and name.
The selection filters for the report include the following
choices:
-
- DATE POSTING FROM
- Accept the first day of the current month for a starting date
or enter a preferred starting date.
- DATE POSTING TO
- Accept the last day of the current month for an ending date or
enter a preferred ending date.
Sources to Include:
-
- REVERSE POSTED A/P CHECKS
- Check this box to include checks processed in Reverse Posted A/P Checks (Function APAC03A).
A/P DIRECT PAYMENTS
- Check this box to include invoices posted from Print Direct Payment Register and Post (Function
APAP34C).
A/P CHECKS
- Check this box to include payments posted from Print Check Register & Post (Function
APCH20C).
A/P RECURRING INVOICES
- Check this box to include invoices posted from Post Recurring Invoices (Function APRBH03G).
A/P INVOICES
- Check this box to include invoices posted from Post A/P Invoices (Function APVI10D).
A/R CUSTOMER CURRENCY EXCHANGE
- Check this box to include postings from Post Customer Currency Changes (Function
ARAR91C).
A/R BAD DEBTS COLLECTIONS
- Check this box to include postings from Post Collections (Function ARBC05C).
A/R BAD DEBTS
- Check this box to include postings from Post Bad Debts (Function ARBD05C).
A/R CUSTOMER PAYMENTS
- Check this box to include payments posted from Post Customer Payments (Function ARCP10E).
A/R FINANCE CHARGES
- Check this box to include postings from Post Finance Charges (Function ARFC10C).
A/R INVOICES
- Check this box to include invoices posted from Post A/R Invoices and on account from Daily Close 3: Post Invoices (Function ARIF10E).
Note: Cash invoices that do not post to the customer's account
are included in the Rental Journal selection
option.
G/L MANUAL CHECKS
- Check this box to include payments posted from Post G/L Manual Checks (Function GLCH10C).
G/L MISCELLANEOUS JOURNALS
- Check this box to include journals posted from Post Miscellaneous Journals (Function
GLET10C).
G/L COMPRESS TRANSACTIONS
- Check this box to include postings from Compress G/L Transactions (Function
GLGL99B).
G/L STANDARD JOURNALS
- Check this box to include journals posted from Post Standard Journals (Function GLJH10C).
G/L COMPUTER CHECKS
- Check this box to include payments posted from Post G/L Computer Checks (Function GLQH20C).
WAREHOUSE COST ADJUSTMENTS
- Check this box to include postings from Post Warehouse Cost Adjustments (Function
INWR06F).
TIME CLOCK
- Check this box to include postings generated from Time Sheets.
INVENTORY DEPRECIATION
- Check this box to include postings from Print Depreciation Report (Function RSAD10L).
AVERAGE COST CHANGES
- Check this box to include postings from Post Product Average Cost Changes (Function
RSCA20D).
INVENTORY ADJUSTMENTS
- Check this box to include postings from Post Inventory Adjustments (Function
RSIA10D).
RENTAL JOURNAL
- Check this box to include included on the Rental Journal
Transaction Report posted in the Daily
Close 3 (Function RSRJ10C).
INVENTORY TRANSFERS
- Check this box to include postings from Post Inventory Transfers (Function RSTH10H)
OTHER SOURCES
- Check this box to include postings from other sources not
identified in the above selection list such as:
GL transactions uploaded from an
import file (Function GLGL20A)
Depreciation Reversal (Function RSAD21G)
Cash Sales (Function GLIH10C)
Inventory Maintenance Adjustment (Function RSIM21D)
Post Payroll Checks (Function PRCQ10F)
Finished?
- Click the ACCEPT button to generate the spreadsheet, or CANCEL
to abort.
ACTIONS:
Additional actions provided by buttons on
the G/L Activity by Posting screen include:
Topic Keyword: GLGL60 (4106)