Form InvoiceReports

Unit name: Forms.InvoiceReports
Form name: InvoiceReportsForm
Old form name: unit41, Form41

Synopsis

Form to print out invoicing reports.

Functionalities

This form allows to choose one of several reports:

Delivery report (File: Deliveries, Type: rptDeliveries)
Delivery report 2 (Jamberry) (File: DeliveriesJamberry, Type: rptDeliveriesyJamberry)
Delivery report 3 (File: Deliveries3, Type: rptDeliveries3)
Reception report (File: Receptions, Type: rptReceptions)
Reception report 2 (under consideration) (File: Receptions2, Type: rptReceptions2)
Return report (File: Deliveries, Type: rptReturnReport)
Warehouse volumes per week (File: WarehouseVolumesWeekly, Type: rptWarehouseVolumesWeekly)
GR - Invoices, rows, qty Weight (File: PackingInvoices, Type: rptPackingInvoices)
Delivered articles and qty (File: DeliveredArticles, Type: rptDeliveredArticles)

For each of the reports, some options can be given. When a report is selected, the possible options for this report are shown.

A button 'Print' executes the PrintInvoiceReport action.

Actions.

PrintInvoiceReport

Only active when a report is selected.
This action prepare the selected report using the appropriate server call, and print the report.

Filters

Data filter:

For some reports, the form allows to set up a filter on the following fields/expressions: 1. D.ArtCode 1. D.ExpiryDate 1. D.LotNo 1. D.StockCode 1. D.SUPPLIER 1. D.LOCATION 1. LEFT(D.LOCATION, 1) 1. RIGHT(D.LOCATION, 1)

With the following operators: 1. = 1. >= 1. <= 1. > 1. < 1. <> 1. LIKE**

And an arbitrary value, which may be selected from a dropdown or date edit depending on the fieldname.

The dropdown is shown and populated with data based on the chosen fieldname:
D.Supplier Fills the dropdown with the list of suppliers, name field.
D.StockCode Fills the dropdown with the list of stock codes, Stockcode field.
D.Location Fills the dropdown with the list of locations.
LEFT(D.LOCATION, 1) Fills the dropdown with a list of unique first letters of locations.
RIGHT(D.LOCATION, 1) Fills the dropdown with a list of unique last letters of locations.
When the D.ExpiryDate is chose, a TDateTime edit is show, with default date today.
When D.Artcode is selected, a check is done whether the article exists.

Delivery report

The following options/filters are shown: 1. Data filter (as explained above) (Param: customfilter) 2. Checkbox: "Show articles" (Param: showarticles) 3. Version 1/Version 2 4. Start date (Param: StartDate) 5. End Date (Param: EndDate) 6. CategoryID (Param: Category)

Delivery report Jamberry

The following options/filters are shown: 1. Data filter (as explained above) (Param: customfilter) 4. Start date (Param: StartDate) 5. End Date (Param: EndDate)

Delivery report 3

The following options/filters are shown: 1. Data filter (as explained above) (Param: customfilter) 2. Checkbox: "Show articles" (Param: showarticles) 3. Checkbox: "Only interface orders" (Param: OnlyInterfaceOrders) 4. Start date (Param: StartDate) 5. End Date (Param: EndDate) 6. CategoryID (Param: Category)

Reception report

The following options/filters are shown: 1. Data filter (as explained above) (Param: customfilter) 2. Checkbox: "Include returns" (Param: IncludeReturns) 3. Checkbox: "include items (article codes)" (Param: IncludeArticle) 4. Start date (Param: StartDate) 5. End Date (Param: EndDate)

Reception report 2

The following options/filters are shown: 1. Data filter (as explained above) (Param: customfilter) 2. Checkbox: "Include returns" (Param: IncludeReturns) 3. Start date (Param: StartDate) 4. End Date (Param: EndDate)

Return report

The following options/filters are shown: 1. Data filter (as explained above) (Param: customfilter) 2. Checkbox: "Only returns" (Param: OnlyReturns) 3. Start date (Param: StartDate) 4. End Date (Param: EndDate)

Weekly warehouse volume

The following options/filters are shown: 1. Data filter (as explained above) (Param: customfilter) 2. Start date (Param: StartDate) 3. End Date (Param: EndDate) 4. Checkbox "Show Only Totals+SubTotals" (Param: OnlyTotals)

GR - Invoices, rows, qty, weight

The following options/filters are shown: 1. Subcategory: Dropdown with categories) (Param: CustomFilter) 2. Start date (Param: StartDate) 3. End Date (Param: EndDate)

Delivered articles and Qty.

The following options/filters are shown: 1. Data filter (as explained above) (Param: customfilter) 2. Start date (Param: StartDate) 3. End Date (Param: EndDate)