search-icon

This report compares stock received vs invoice. Use this report to see what has been received but not invoiced or what has been invoiced but not received, along with the order total for a selected reporting period or as of today i.e. the calendar date on which the report is run.


NOTE: Reporting period must also cover invoice date for report line to appear. The invoice can be in draft status (not yet authorised). For simple purchases, draft invoice is created automatically however for advanced purchase it needs to be raised by the user for each stock receipt.

To check stock received that has not been invoiced, check the Stock Received Not Invoiced report.


Prerequisite


Table of Contents


Data from this report can be exported in Excel, PDF or RTF format. 



Input:

ModeSelect to run report for a reporting period, or as of a specific date. 
Reporting Period(Mode: Period) Allows the user to select the reporting period from a list of options or set a custom date range. The report is filtered by stock received date.
As of date(Mode: As of date) Allows the user to compare the stock received vs invoiced as of today i.e. the calendar date and current time on which the report is run.
CurrencyAllows the user to select the currency to be used in the report.
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving a layout for potential future use.
Reset LayoutResets the layout to the default layout or selected saved layout.


Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters. 



Output:

The following output fields are available for this report. You may have to open the Configure Layout menu to add some of them to your report. 


Fields
SKUProduct SKU
ProductProduct name
PO #Purchase Order Number identifying the purchase
Invoice #Invoice Number issued by the supplier
Invoice DateDate of the invoice
Received DateDate when stock was received
SupplierSupplier name
Required ByDate when the purchase needs to be delivered
Invoice Due DateDate when the invoice is due
Invoice StatusStatus of the invoice
Stock StatusStatus of the stock received
StatusPurchase status
LocationLocation this purchase is intended for
CategoryProduct category
BrandProduct brand
Product TagsComma-separated product tags
FamilyProduct family name
UnitProduct unit of measure
Supplier Additional Attribute 1-10Values of Additional supplier attributes
Product Additional Attribute 1-10Values of Additional product attributes
Data Headers
ReceivedQuantity of the product received
InvoicedQuantity of the product invoiced
Difference in QuantityDifference between quantities of the product received and invoiced
PO TotalPurchase Order Total for the product received excluding tax.

NOTE: If you have added an Additional Attribute set to your purchase process, the attributes will appear as additional report fields. 


Scheduling report for other dates

[back to top]


When scheduling this report, you can select Period mode or As of date mode. If As of date mode is selected, you can then select either Today (the day the report is scheduled), Yesterday (day before the report was scheduled), or Date offset (X number of days before the report scheduled date). 

The report scheduled date is dictated by the Scheduled from field and Frequency field.


With this function, you can run the report to show data as of days other than the current calendar date. Date offset value can be greater than the report frequency.


Example 1:


Schedule from:  22 Feb 2023, 00:00 Frequency: Daily, As of date: Yesterday.

The first report will be generated on the 22nd of Feb 00:00, with data until the 21st of Feb 00:00. 

The second report will be generated on the 23rd of Feb 00:00, with data until the 22nd of Feb 00:00.


Example 2:


Schedule from:  30 Feb 2023, 17:00 Frequency: Weekly, As of date: Date offset 8.

The first report will be generated on the 28th of Feb 17:00, with data until the 20th of Feb 17:00. 

The second report will be generated on the 7th of Mar 17:00, with data until the 27th of Feb 17:00.

 

FAQs

[back to top]


Some transactions are indicating 0 balance or quantity even though both stock received and invoice have been authorised.

Usually, this is an issue with the date filters. Check that the reporting period covers both invoice and stock received dates. You may have to set a custom date range. Missing entries can also be caused by cache problems. Try clearing your cache and refreshing to see if the issue persists.


We need help understanding why inventory asset value is added in April for stock invoiced in April but received in May as shown on the Trial Balance and Stock Received vs Invoice Report.  

The report shows transactions as they are generated. In this case, Invoice amount was recognized on April and entry on such date is to debit Inventory account that is why it is showing on the report on the month of April. This is a result of not enabled Inventory Accrual. When inventory accrual is enabled, an invoice will generate a different transaction, replacing the asset account in invoice line with Goods Invoiced Not Received account. 


Can we use the STOCK RECEIVED VS INVOICE REPORT but from Day 1 of using DEAR? Currently it’s restricted to only 365 days.

Unfortunately, the report can only have a maximum range of 1 year. You can then run the report numerous times, if you require report for multiple years.  And since this is a transactional report, only those included in the range of date will be reflected in the report. If not in that range, then the transaction will not be reflected.


Why does PO Total show a value when Invoiced and Received quantities are the same?

This is by design. PO Total shows full total amount from the purchase order for the product. It does not account for difference or if it is fully or not fully received/invoiced. We have another report, Stock Received Not Invoiced, to check for differences. 



Still no answer to your question? Please do not hesitate to get in touch with DEAR support.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.