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)
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)