Summary Reports versus Listing Reports

1. Introduction

This article will aim to illustrate the difference between the reports especially when Stores are set to Weighted Average.

Differences between the Summary and Listing reports are expected when cost price changes occur within the same stock period.

When a store creates and confirms a reduction at a cost price (R10.90 as shown in this example), the cost price will reflect on the Reduction Listing Report. 

If a delivery is subsequently captured and confirmed, and the cost price changes to R11.65, the Delivery and Delivery Listing Reports will reflect the updated cost price, as shown below.

This scenario occurs within the same stock period, with the stock movement taking place in a store that uses the Weighted Average Cost method.

As a result of the weighted average calculation, the new cost price becomes R11.05.

The Store Summary Report and Stock Movement Report will then reflect the new weighted average cost price of R11.05 (11.05 x 24 = 265.20), as these reports are dynamic and display the current cost price for the item.

This demonstrates why the Listing Reports are considered a snapshot of the cost price at the specific point in time when each transaction occurred and, therefore, cannot be directly compared to the Summary and Stock Movement Reports.

The summary and movement reports are an aggregation of all snapshots throughout the stock period and reflect the resulting weighted average cost.

In other words, the reports are designed to answer different questions. The Listing Reports show what the cost price was when each transaction occurred, while the Summary Reports show the weighted average cost after all transactions for the period have been taken into account. For this reason, differences between the reports are expected and do not indicate an error.  

• Related Articles

• Booking Summary - Property/Source or Source/Property Report

  1. Booking Summary by Property / Source Description: The report provides booking statistics (for booking date range) by property and source code in summary or detailed format. Typical Uses Used as a reservation count. To evaluate bookings by source ...

• How do I calculate Weighted Average Cost?

  The Weighted Average costs calculation now considers the quantity that was delivered or issued into the store when calculating the historical average. 1. Calculation Formula If I deliver 24 units of Coke at R6 and then another 20 units at R7 then the ...

• How do I Reprint Apex End of Day Reports?

  1. Apex Repview To Reprint End of Day reports: Go to Apex RepView Shortcut on the Desktop (If do not have this shortcut refer to the article to Add ApexRepView shortcut). Go to the date need to print the reports. On top left select the report you ...

• How do I save a report from Apex Repview without it being blank?

  When End of Day is run Apex will save the End Of Day reports in 3 different formats namely PDF, QRP and CSV. When attempting to save the report from Repview, as PDF or in Excel the report will be blank as it has already been saved in the format ...

• Where can I find Cancellation Reports on Apex?

  1. Cancellation Report The Cancellation Report can be accessed by clicking on Reports -> Reservation Reports -> Lost Business Listing Report. This report will display cancelled reservations and group them by Cancellation code over the date range ...