Bill-Party wise Outstandings Report

• Include Post-Dated Transactions: Post-dated transactions are those with voucher dates beyond the end date of the period of display.

On setting this option to Yes, the amount of post dated transactions will be listed in the Post-Dated Amount column.

• Show Bills in Foreign Exchange: If this option is set to Yes, the Bills Outstanding report will show only those bills raised in foreign currency. The bills raised in base currency will be excluded.

• Show Opening Amount: If this option is set to Yes, the Bills Outstanding report will show the opening balance amount column.

• Show overdue using Bill Date: On setting this option to Yes, the invoice date will be considered for calculation of overdue days, instead of due date.

Here, due date refers to the date mentioned in the Bill-wise details screen.

Note: While calculating the overdue, the outstanding days (Age of Bills in Days) are calculated from the due date to the end date of report. If you use Bill date for calculating Overdue, then the credit days are ignored and delay days are calculated from the bill date to the end date of report.

• Range of Bills to show: By default, the Bills Outstanding report will display only the Pending bills. Select Overdue Bills in the field Range of Bills to show to view only the overdue bills for a definite period.

Note:

Based on the selection of range of bills, the report for all Pending or Overdue bills as on date specified for the Report can be viewed.

 

1. Pending Bills : This will display the bills which are pending as on a particular date.

 

2. Overdue Bills : This will display the bills which are not paid or due beyond their credit period or days.

• Show Qty info in Detailed Format? Set this option to Yes to display the item quantity details for each transaction.

• Appearance of Names: Select the required option from the list to view the party ledger names as per the name style chosen i.e., Name only, Alias only, Name (Alias) or Alias (Name).

• Party Sorting Method: Select either of the sorting methods Party (Decreasing) or Party (Increasing) to sort the report based on ascending or descending order of the party ledger name.

• Bill Sorting Method: Select one of the sorting methods from the list  to sort the report based on Amount (Decreasing or Increasing), Currency (Decreasing or Increasing), Date (Decreasing or Increasing), Due Date (Decreasing or Increasing) and Ref No. (Decreasing or Increasing).

• Include Post-Dated Transactions? Post-dated transactions are those with voucher dates beyond the end date of the period of display.

On setting this option to Yes, the amount of post dated transactions will be listed in the Post-Dated Amount column.

• Show overdue using Bill Date: On setting this option to Yes, the invoice date will be considered for calculation of overdue days, instead of due date.

Here, due date refers to the date mentioned in the Bill-wise details screen.

Note: While calculating the overdue, the outstanding days (Age of Bills in Days) are calculated from the due date to the end date of report. If you use Bill date for calculating Overdue, then the credit days are ignored and delay days are calculated from the bill date to the end date of report.

• Range of Bills to show: By default, the Bills Outstanding report will display only the Pending bills. Select Overdue Bills in the field Range of Bills to show to view only the overdue bills for a definite period.

Note:

Based on the selection of range of bills, the report for all Pending or Overdue bills as on date specified for the Report can be viewed.

 

1. Pending Bills : This will display the bills which are pending as on a particular date.

 

2. Overdue Bills : This will display the bills which are not paid or due beyond their credit period or days.

• Show Qty info in Detailed Format: Set this option to Yes to display the item quantity details for each transaction.

• Show Bills of the following type: Select the required option from the list of filter the report based on the balance of the party ledger i.e., whether credit or debit balance.

• Show Bills in Foreign Exchange? If this option is set to Yes, the Bills Outstanding report will show only those bills raised in foreign currency. The bills raised in base currency will be excluded.

• Appearance of Names: Select the required option from the list to view the party ledger names as per the name style chosen i.e., Name only, Alias only, Name (Alias) or Alias (Name).

• Scale factor for Values: Select the required option from the list to view the amounts as per Scale Factor chosen i.e., hundreds, thousands, lakhs, millions, ten lakhs, ten thousand, ten million, crores or any user- defined scale factor mentioned.

• Party Sorting Method: Select either of the sorting methods Party (Decreasing) or Party (Increasing) to sort the report based on ascending or descending order of the party ledger name.

• Bill Sorting Method: Select one of the sorting methods from the list  to sort the report based on Amount (Decreasing or Increasing), Currency (Decreasing or Increasing), Date (Decreasing or Increasing), Due Date (Decreasing or Increasing) and Ref No. (Decreasing or Increasing).

• Expand all levels in detailed format: Set this option to Yes to view the Group Outstandings report in detailed mode.