The information about the company's invoices can be found in the OINV table in SAP Business One. A single Invoicesent to a client is reflected by the content of each row in the table.
The OINV table stores a variety of information, including the ID of the invoice, the invoice date, the invoice amount and the customer or supplier name linked to the invoice. Other information such as the invoice currency, the associated transaction code, the invoice status and comments can also be included. All these details can be entered at the same time.
There is a close link between the OINV table and a number of other modules in SAP Business One, including the sales order module and the payment module. This simplifies the management of the accounts receivable and accounting, as each invoice can be linked to a single order or payment. The following fields, among others, are contained in the OINV table in SAP Business One:
- DocEntry: This field contains the unique ID number of the invoice.
- DocNum: The number of the invoice documentation is stored here.
- DocType: This field defines the type of invoice (e.g. sales invoice, credit note).
- CardCode: The code of the customer to whom the invoice was issued is stored here.
- DocDate: This field stores the date of the invoice.
- DocTotal: The total amount of the invoice is saved here.
- DocCur: This field is used to specify the currency in which the invoice was created.
- NumAtCard: An external reference number for the invoice can be saved here.
- PaymentGroupCode: This field is used to define whether the invoice belongs to a specific payment group.
- DocStatus: The status of the invoice is defined here (e.g. opened, paid, cancelled).
