Contracts Finalized Report

Issue No: CT-998
Created 1/19/2017 5:01:33 AM
Type Gap
Priority Minor
Status Closed
Resolution Fixed
Fixed Version 18.3
Description Business Scenario:   This report is used by the Sampling department. They take this report whenever it is required. They need to throw away the samples from their drawers. For this they check if the documents are in order, if the PO is fully delivered and fully sold, goods went in order and invoices are paid.   Requirements:   * Add Under Contract Management menu -> Reports - > require a report as “Closed Contracts Report” * In the contract sequence in the Status field in the drop down require a status as “Closed”   * In the Purchase contract sequence if the Status is selected as “Closed” then these contracts should be displayed in the report of Closed Contracts * The columns required in this Closed Contracts report are given below: ** Purchase Contract No. – Display the purchase contract number along with the sequence number ** Customer – Display the customer name of the Sales contract which is allocated to the Purchase contract ** Sales Contract No. – Display the sales contract number along with the sequence number allocated to the Purchase contract ** Purchase Contract (Qty) – Display the purchase contract quantity ** Purchase Contract (Unit) – Display the purchase contract unit ** Invoice Number – Display the sales invoice number of the Sales contract which is allocated to the Purchase contract ** Invoice Date – Display the invoice date ** Contract Adj (Qty) – Display the contract adjustment quantity of the Purchase contract ** Contract Adj (Unit) – Display the contract adjustment unit of the Purchase contract   !pastedImage_d68803_0.png!   !pastedImage_d68803_1.png!   !pastedImage_d68803_2.png!