Information about credit notes that the company has issued to customers is stored in the ORIN table of the SAP Business One application. The table is organised in such a way that each entry reflects a separate credit note.
In the ORIN table, information such as the number associated with the credit amount linked customer name, the credit note amount, the credit note ID and the issue date of the credit note are saved. Further information, such as the denomination of the credit note, the associated transaction code and comments, can also be included in the transaction.
The ORIN table in SAP Business One is closely linked to a number of other modules in the programme, including the module customer order and the Payments module. This makes it possible to link each credit note to a specific order or payment, which simplifies the management of receivables and their posting. Some fields that appear in the ORIN table:
- DocEntry: This field contains the unique ID number of the credit note.
- DocNum: The number of the credit note documentation is saved here.
- DocType: The type of credit note is defined in this field (e.g. customer return, discount).
- CardCode: The code of the customer to whom the credit was issued is stored here.
- DocDate: The date of the credit note is stored in this field.
- DocTotal: The total amount of the credit note is saved here.
- DocCur: This field is used to specify the currency in which the credit note was created.
- NumAtCard: An external reference number for the credit note can be saved here.
- BaseDocNum: The number of the associated order or invoice is saved in this field.
- DocStatus: The status of the credit note is defined here (e.g. opened, paid, cancelled).
