Report Generator

With the use of SentezXL Apparel Manufacturing Management System, we can make reports according to the information and the design we choose, apart from the reports prepared by the program itself.

Inventory Report Generator

The Inventory Report Generator is a section that includes all the entries done in the inventory receipts and shipments [section] and the defined special fields.

In the Report File Name field, a file name must be given to follow up the report that will be prepared.

In the Report Name field, the name of the report that will be prepared must be defined.

Filter

Figure 1 Inventory Report Generator / Filter

Inventory Code
in this field, we can see the Inventory Cards list using the F9 key. We can also take reports by imposing restrictions in accordance with the inventory codes that are stated in this field.

Inventory Name
It displays the inventory names in the inventory cards. We can impose restrictions according to the inventory names.

Variant 1-2
It displays the variant in the inventory entry and shipment receipts. It works in connection with the Inventory Code and the Inventory Name. In this field, we can impose color restrictions according to the color we want to see the inventory code and inventory name in.

Warehouse Based
It displays the warehouses entered in the inventory receipt-shipment receipts. Reports can be taken by entering the code for the desired warehouse.

Sorting
We can take reports in the desired sequence by sorting its inventory code, inventory name and barcode.

Special Fields
We can take reports by bringing restrictions in the special fields (shelf number, width, length) at the inventory receipts and inventory shipments.

Date
We can take reports of the inventory receipts and shipments for any desired date by bringing date restrictions in this field.

Receipt Type
We can bring restrictions according to the receipt types entered at inventory receipts and inventory shipments.

Receipt No
Restrictions based on receipt numbers can be made also. Restrictions can be applied to required (previous entered) receipt numbers.

For example, Receipt No 1 is a Purchase Dispatch. We want to see the receipts No 56-58 that belong to the Purchase Dispatch. If we write 1 in the Receipt Type field, and 56-58 in the Receipt No field, we can take the report for the parameters we have defined.

Current Accounts
Restrictions could be applied according to the current accounts entered in the inventory receipts.

Party No
Restrictions to the inventory shipped on party basis in the Knitting and Dyeing receipts could be applied.

Inventory Status
We can take the inventories that are received and shipped in the main group.

In the All field, we can see the status of all the inventories; in the Available field, we can see the status of the inventories left from entries and shipments; in the Processed field, we can see the status of the inventories that are processed at the entries and shipments; and in the passive field, we can see the status of the inventories that are not processed at the entries and shipments.

Cumulative
Inventories that are received and shipped cumulatively could be displayed.

Cost Type
Cost can be taken in 4 main groups (OBF Entry, OBF on Hand, FIFO, LIFO).

Logic Fields


Figure 2 Inventory Report Generator / Logic Fields

We can implement logic operations in the field definitions of any report that has been prepared.

Example:

A78 (Quantity Received in Field Descriptions) >= Greater than and Equal to

FIELD-1                      OPERATION                        FIELD-2

A78                           > Greater and Equal               5000

(If the A78 Quantity Received that is in the Field descriptions is equal to or greater than 5000), it will bring the receipts of 5000 or greater than 5000 on the screen and can do the operations in the alphanumerical [section].

General


Figure 3 Inventory Report Generator / General

Printer Mode
Report can be taken by adjusting its fonts (uppercase - lowercase) in the desired printer’s mode.

Page Length
The page length can be stated according to information it contains. Like 66 - 128.

Table Format
If No is selected, it brings the field descriptions that are entered without sketching. If Yes is selected, lines will be drawn for columns and lines.

Table Format (With Line)
If No is selected, it will generate the report without lines. If Yes is selected, it will draw lines for the columns.

Each Page Captioned
In multi paged reports, if we want to have information like the file name of the report, the company name and date appear on the following pages as well, we define them in this field.

Subtotal Basis
It takes the total for the desired line.

Subtotal
It takes the total on line by line basis.

User Name
The name of the personnel who writes the report must be written.

Field Definitions


Figure 4 Inventory Report Generator / Field Descriptions

The definitions of all the fields that exist in the inventory receipts and shipments are here. When first opened as the report is being prepared, all of them appear as Excluded. When the desired field is made Included, this will enable the report to be generated.

What must be paid attention at in here is that the same field number must not be given to the fields that are desired to appear it the same report. This operation is automatically done by the program.

Formulas


Figure 5 Inventory Report Generator / Formulas

In the field definitions, you can do mathematical operations in the report that is written by making up formulas.

Example:

A78-A80

The remaining quantity will be found by subtracting the shipment quantity from the total quantity received.

Our Inventory Status Report will be as follows in accordance with the defined fields.

Figure 6 Inventory Report Generator / Formulas