/
What report can I use to track postings to an account for a defined Set Number range?
What report can I use to track postings to an account for a defined Set Number range?
Problem
I want to run a report for an account for a defined set number range as the postings to this account are not in date order.
Solution
A working knowledge of SQL Management Studio
A working knowledge of SQL Management Studio is required to complete this task.
A new report GLINF023 - General Ledger Listing by Set No has been created and is based on General Ledger Listing with Source report.
These criteria have been removed
These criteria have been added to the new report
To implement the report
run the attached script over your database
import the report using Refresh from Files under System Settings > Report Configuration > Reports
attach it to the relevant user menus using System Settings > Menu Configuration > Menus
Related articles
, multiple selections available,
Related content
What report can I use that will give me a listing of outstanding creditor transactions with sub-totals?
What report can I use that will give me a listing of outstanding creditor transactions with sub-totals?
More like this
What report can I use to track inventory movements by warehouse?
What report can I use to track inventory movements by warehouse?
More like this
Additional Stock Take reports
Additional Stock Take reports
More like this
New report INTRN065 - Stock Take History with Categories
New report INTRN065 - Stock Take History with Categories
More like this
General Ledger Listing with Source report prints #######
General Ledger Listing with Source report prints #######
More like this
Grouping using the standard Plugin Journals Created From Sales Orders - Group by Sign and Account is incorrect where different BAS codes apply - 7.00.175
Grouping using the standard Plugin Journals Created From Sales Orders - Group by Sign and Account is incorrect where different BAS codes apply - 7.00.175
More like this