Consolidate Outstanding (with Groupby)

Here are the steps to view Consolidate Outstanding (with Groupby) Report. To learn more, you can also watch this RADIX Online tutorial video:

Consolidate Outstanding (with Groupby) Report

To view Consolidate Outstanding (with Groupby) Report in Radix, first select the desired company.

1. Go to Reports > Textile Trading > Outstanding > Stock at Process (To Receive) > Consolidate Outstanding (with Groupby).

2. Consolidate Outstanding (with Groupby) Report Criteria form will open. Set all the details here such as:

Companies - Press F4 button and select the companies for which you want to view the report.

Company Group - To print Company Detail and Address from group, tick here.

Issue Date - Set the date of issues for which you want to view the report.

Received Date - Set the date of receipts for which you want to view the report.

Day-book - To view report for all the day-books, select All option, otherwise to view report for any particular day-book, select Equal To option and then select the day-book.

Challan No - To view report for all the challans, select All option, otherwise to view report for any particular challan, select Equal To option and then enter the challan number.

Group - To view report for all the general ledger groups, select All option, otherwise to view report for any particular general ledger group, select Equal To option and then select the general ledger group.

Status - Select the status here from the list of options displayed.

All - Select this option to view all the invoices in the report.

Part Pending - Select this option to view those invoices, which have received only some part of the payment against their respective invoices.

Full Pending - Select this option to view those invoices, which have not received full payment against their respective invoices.

All Pending - Select this option to view all those invoices included in the above two options i.e. Part Pending and Full Pending.

Clear - Select this option to view those invoices, which are clear and have been adjusted against their invoices.

Used Quantity on - Select from Quantity 1, 2, 3 for which you want to view the report.

3. Click on '2. Master' and select other criteria such as:

Account (Mill) - To view report for all the mill accounts, select All option, otherwise to view report for any particular account, select Equal To option and then select the account.

Account Group - To view report for all the party groups, select All option, otherwise to view report for any particular party group, select Equal To option and then select the party group.

Weaver (Supplier) - To view report for all the weavers, select All option, otherwise to view report for any particular weaver, select Equal To option and then select the weaver.

Weaver Group (Supplier) - To view report for all the weaver groups, select All option, otherwise to view report for any particular group, select Equal To option and then select the weaver group.

Broker - To view report for all the brokers, select All option, otherwise to view report for any particular broker, select Equal To option and then select the broker.

Broker Group - To view report for all the broker groups, select All option, otherwise to view report for any particular group, select Equal To option and then select the broker group.

Broker From - Select Broker From Party Master option to fetch broker details from Party Master. To fetch broker details from Transactions, select Broker From Transactions option.

Items - To view report for all the items, select All option, otherwise to view report for any particular item, select Equal To option and then select the item.

Items Group - To view report for all the item groups, select All option, otherwise to view report for any particular item group, select Equal To option and then select the item group.

Screen - To view report for all the item screens, select All option, otherwise to view report for any particular screen, select Equal To option and then select the item screen.

Work - To view report for all the works, select All option, otherwise to view report for any particular work, select Equal To option and then select the work.

Style - To view report for all the styles, select All option, otherwise to view report for any particular style, select Equal To option and then select the style.

4. Click on '2. Group By' and select other criteria such as:

Group By 1/2/3/4 - Here, select the group by wise you want to view the report, from the list of options displayed.

(For eg: To view Date wise + Broker wise + Party wise report, select Date wise option in Group By 1 field,

select Broker wise option in Group By 2 field and select Party wise option in Group By 3 field.)

Address and Phone? - Tick here to view/print party's address and phone number in the report.

Report Show By - To view detailed report, select Detail option. To view summary report, select Summary option.

5. Click on '4. Option' and select other criteria such as:

Gray Rate - To view report for all the gray rates, select All option, otherwise to view report for any particular gray rate, select Equal To option and then enter the gray rate.

Job Rate - To view report for all the job rates, select All option, otherwise to view report for any particular job rate, select Equal To option and then enter the job rate.

Balance Quantity Range - To view report for all the balance quantity ranges, select All option, otherwise to view report for any particular balance quantity range, select Equal To option and then enter the balance quantity range.

Notes - To view report for all the notes, select All option, otherwise to view report for any particular note, select Equal To option and then select the note.

Lot Number - To view report for all the lot numbers, select All option, otherwise to view report for any particular lot number, select Equal To option and then enter the lot number.

LR No - To view report for all the LR numbers, select All option, otherwise to view report for any particular LR number, select Equal To option and then enter the LR number.

Transport - To view report for all the transports, select All option, otherwise to view report for any particular transport, select Equal To option and then select the transport.

Vehicle - To view report for all the vehicles, select All option, otherwise to view report for any particular vehicle, select Equal To option and then select the vehicle.

Print Date? - To print today's date in the report, tick here.

Please Note: To set all these criteria for future, you can tick on Save Criteria option.

6. After entering all the details, click on Show button. Report will open according to the selected criteria.

7. Here, you can click on Customize button to Customize the Report.

8. You can also print the report by clicking on Print icon on the top left corner of the page or press CTRL+P shortcut key.