Bill Line Items Level Offset

Until now, while offsetting two or more bills through an offset request, the system did not allow to consider a debit bill with a credit line item as a credit bill while offsetting. In addition, the system did not allow to add a bill with zero balance having debit and credit line items in an offset request.

Now, a new option named Bill Line Items Level Offset is available while defining an offset request type. If you select the Bill Line Items Level Offset option in an offset request type, the system allows you to do the following:

• Consider a debit bill with a credit line item as a credit bill while offsetting through an offset request

• Add a bill with zero balance having debit and credit line items in an offset request

For example, if you include a debit bill (BILL1) with the following line items in an offset request which is created using an offset request type where the Bill Line Items Level Offset option is selected:

The system allows you add BILL1 as a credit bill in the offset request. Earlier, the system used to internally offset the bill and the outstanding bill amount was then available for offsetting with another bills in an offset request. Now, if you consider a debit bill with a credit line item as a credit bill for offsetting in an offset request, the system will not internally offset the bill and the credit line items would be available for offsetting with another bills in the offset request. However, if you do not consider a debit bill with a credit line item as a credit bill for offsetting in an offset request, the system will first internally offset the bill and then outstanding amount would be available for offsetting against another bills in the offset request.

If you select the Bill Line Items Level Offset option in an offset request type, you need to ensure that Match Type Entity (Valid Values: BILL, BSEG, SA) parameter in the C1-OFST-DIST algorithm (which is attached to the Creating Adjustment status in the lifecycle of the C1-OffsetRequest business object) is set to BSEG. Otherwise, erroneous results might occur.

If you create an offset request using an offset request type where the Bill Line Items Level Offset option is selected, then:

• The following columns are additionally available in the Offset Details section while editing the offset request:

  • Debit Balance - Displays the sum of the unpaid debit line items of a bill

  • Credit Balance - Displays the sum of the open credit line items of a bill

  • Credit Bill - Used to indicate whether you want to consider a debit bill with a credit line item as a credit bill in the offset request. By default, this option is selected for a bill with the credit or zero balance and it is not editable. Note that you cannot select this option for a debit bill which no credit line item and therefore, in such case, this option is disabled.

• The default offset amount is set either to the sum of open credit balance of all credit bills in the offset request or to the sum of outstanding amount of all debit bills in the offset request whichever is less. While editing the offset amount, the system validates the following:

  • Offset amount is not greater than the outstanding amount of the debit bill

  • Offset amount is not greater than the open credit balance of the credit bill

• The Debit Balance, Credit Balance, and Credit Bill columns appear in the Selected Bills zone of the Offset Request screen.

As mentioned earlier, the system now allows you to add a bill with zero balance having debit and credit line items in an offset request. You can add a bill with zero balance from the following screens:

• Offset Request

• Account Receivable Central

While creating an offset request for a zero balance bill from the Account Receivable Central screen or while adding a zero balance bill to an offset request, the system validates the following:

• The Bill Line Items Level Offset option is selected the respective offset request type.

• The selected bill with zero balance is not fully matched.

We recommend you to add maximum 4 to 5 bills while offsetting the bills through an offset request using the Bill Line Items Level Offset feature.