This report compares stock received vs invoice. User can see what has been received but not invoiced or what has been invoiced but not received.



Input:

Following are input for this report


From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.



SKU

 Product SKU.

Product

 Product name.

PO #

 Purchase Order Number identifying the purchase.

Invoice #

 Invoice Number issued by supplier.
Invoice Date
 Date of the invoice.

Received Date

 Date when stock was received.

Supplier

 Supplier name.

Received

 Quantity of the product received.

Invoiced

 Quantity of the product invoiced.

PO Total

 Purchase Order Total for the product received excluding tax.
Required By
 Date when purchase needs to be delivered.

Invoice Due Date

 Date when Invoice is due.

Invoice Status

 Status of the invoice.

Stock Status

 Status of the stock received.

Status

 Purchase status.

Location

 Location this purchase intended for.

Category

 Product category.

Brand

 Product brand.

Product Tags

 Comma-separated product tags.

Family

 Product family name.

Unit

 Product unit of measure.