Printing the Inventory Ledger by Amounts (R76P6545)
The Inventory Ledger by Amounts report layout is in the format prescribed by Peruvian legal reporting requirements. See an example of the report layout at the end of this section. The following table lists the column numbers and description of the reporting fields in the report layout examples.
Column Name |
Explanation |
---|---|
Date |
GL Date field, retrieved from the F76H611 table. |
Type |
Retrieved from UDC table 76P/DT. |
Serial |
The first digits of the Invoice Number field. In the case of purchases, the system retrieves this value from the F0411 table. In the case of sales, the system retrieves it from the F03B11 table. In the case of operation cardex, the serial is blank. |
Number |
Invoice Number field (without the serial) from the F0411 or F03B11 table. In the case of Cardex operations, the system retrieves this number from the F76H611 table. |
Operation Type |
Retrieved from UDC table 76P/OT. |
Input |
In the case of purchases, quantity, unit cost and extended cost, retrieved from the F76H611 table. |
Output |
In the case of sales, quantity, unit cost and extended cost, retrieved from the F76H611 table. |
Final Balance |
Initial balance plus the quantity, unit cost and extended cost of order. |