This report shows Customers, Stock On hand and Suppliers of selected product & Batch#



Input:

Following are input for this report



Product
Allow user to select a Product
Batch / Lot / Serial Number
Allow user to select a batch/lot/serial number of above selected product

 

Output:

After setting inputs described above, when you press Show button, report will refresh as per inputs, there are following output field available for this report 



Customer
Shows list of Customers against whom a SO has been issued for the selected product & batch #
Customer
Customer’s name
Phone
Customer’s Phone number
E-mail
Customer’s e-mail
Address Line1
Customer’s Line 1
Address Line2
Customer’s Line 2
Task
SO number of Sale
SKU
SKU
Quantity
Quantity in SO
Stock On Hand
Shows Stock on Hand for selected product & Batch
Location
Location of the Product
Product
Product Name
Batch/Serial No
Batch / Serial Number of the product
Expiry Date
Expiry Date of the product
On Hand
Quantity on Hand
Allocated
Quantity Allocated to Sale orders
Suppliers
Shows list of Supplier to whom a PO has been issued for the selected product & batch #
Supplier
Supplier’s name
Phone
Supplier’s Phone number
E-mail
Supplier’s e-mail
Task
PO number of Purchase
Product
Product Name
Quantity
Quantity in PO