Stock Received vs Invoice Report

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. You can choose the currency in which to display the order total.


Prerequisite:


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


Input:

Time PeriodAllow user to select the time period from a list of options are set custom a custom date range.
CurrencyAllow user to select currency to be used in the report
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets 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 More Fields dropdown 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 supplier.
Invoice DateDate of the invoice.
Received DateDate when stock was received.
SupplierSupplier name.
Required ByDate when purchase needs to be delivered.
Invoice Due DateDate when Invoice is due.
Invoice StatusStatus of the invoice.
Stock StatusStatus of the stock received.
StatusPurchase status.
LocationLocation this purchase intended for.
CategoryProduct category.
BrandProduct brand.
Product TagsComma-separated product tags.
FamilyProduct family name.
UnitProduct unit of measure.
Supplier Additional Attribute 1-10
Values of Additional supplier attributes
Product Additional Attribute 1-10
Values of Additional product attributes
Data Headers
Received
Quantity of the product received.
Invoiced
Quantity of the product invoiced.
Difference in QuantityDifference between quantities of product received and invoiced. 
PO Total
Purchase 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. 

Did you find it helpful? Yes No

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