How Does Weekly Invoice Product Category Report Works in iDempiere

The Weekly Invoice Product Category Report provides a weekly summary of invoice transactions grouped by Product Category. It helps users analyze weekly sales performance, invoice quantities, discounts, and invoice amounts. The report is useful for Sales, Finance, and Management teams to monitor weekly business performance. Users can generate the report for a selected date range and Product Category.

Business Rules

• Retrieves data from RV_C_Invoice_ProdWeek.
• Groups records by week using Invoice Date.
• Groups records by Product Category and Organization.
• Supports Sales and Purchase transactions.
• Calculates invoiced quantity.
• Calculates Net Amount, List Amount and Discount Amount.
• Calculates Discount % and Over Limit %.
• Returns records matching selected parameters.
• Rounds values using invoice currency.
• Displays weekly summarized data.

Report Parameters

Parameter Window

The Weekly Invoice Product Category Report parameter window allows users to filter Product Category records before generating the report.

Weekly Invoice Product Category Report – Parameter Window

Report Output

• The report provides a weekly summary of invoice transactions for the selected Product Category. It displays weekly invoice quantities, amounts, discounts, and over-limit values. Users can compare weekly performance and identify sales trends. The report supports operational review and management analysis.
• Week
• Product Category
• Invoiced Quantity
• Net Amount
• Discount Amount
• Over Limit Amount
• Sales/Purchase Transaction