Open items appear on the standard screen for line item display. If a duplicata has been issued for these items, the field bill of exchange payment request is filled and the corresponding bill of exchange request appears on the same screen through the display of the special G/L transactions. The bill of exchange request contains the information on the selected bank and payment method.

Due date analysis is possible through standard R/3 reports on open items.

A report on issued duplicatas in the form of a SAP Query is part of the localization for Brazil. This specific SAP Query is called DU. It is linked to the functional area /SAPQUERY/J1B1 and the user group /SAPQUERY/XX.

This report covers the legal requirements for the 'Registro de Duplicatas a receber' such as reporting due date, duplicata issue date, gross amount, customer name/street and amount. The list is sorted by due date. You can select via customer, company code, due date, issue date and document number (internal or seu numero).

In addition, specific Brazilian business needs are covered:

• Display bank ID where duplicata is presented
• Display rebate assigned to a duplicata through credit notes
• Display instruction code
• Display bank duplicata number
• Subtotals per bank
• Select bank ID
• Select instruction code
• Select bank dupl nr. This field is only filled if the duplicata is confirmed by the bank. Therefore, you can select either confirmed or not confirmed duplicatas.

An additional feature enables you to also select the open items where no duplicata has been created by selecting Issue date = space.

The query can be included in the relevant reporting tree. For more details, see the standard documentation on SAP Query.