[iTrade] - Brokerage Commission Processing related Gaps

Issue No: CT-2739
Created 12/3/2018 6:53:46 AM
Type Gap
Priority Major
Status Closed
Resolution Fixed
Fixed Version 19.1
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-221812 - invoice Cr/Dr note in i-brokerage|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-221812]     This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.     [HDTN-221804 - brokerage commission - need to understand who payes the commission - seller/gabesco?|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-221804]     This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-221809 - We need that the system create 3 different letters; one to vendor, one to customer and one to broke|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-221809]     This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-221919 - search screen on Brokerage Commission Processing|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-221919]     In iTrade migration project for Gabesco - Brkerage scenarios, below gaps are identified.     Please incorporate below points.   *A. Brokerage Contract Document Print related gaps:*   # In iDeal system Contract Document Print, add ‘To’ field having three options – (i) Buyer (ii) Seller (iii) Gab. # Add a check box named - ‘Sub Broker Commission’. # If Buyer is selected then document print entity name address will be Buyer as below. # E.g. below contract has buyer and seller as KICO and ECOM.   !http://jira.irelyserver.comfile///C:/Users/rdebnath/AppData/Local/Temp/msohtmlclip1/01/clip_image002.jpg|height=411,width=602!   5. In contract print, when Buyer is selected, Buyer name and address is selected in below highlighted area.   !pastedImage_d109045_1.png!     6. Similarly, when Seller is selected, Seller name and address will be printed.   !pastedImage_d109045_2.png!   7. When Broker will be selected, and Sub Broker Commission will be checked, as below   !pastedImage_d109045_3.png!   8. It will print as per below format.   !pastedImage_d109045_4.png!   In the above sentence "It is understood that your commission is ......and will be paid by us to you directly" - please use the word 'us' if Paid By is selected 'Company', use the word 'Seller' if Paid By is 'Seller' and use the word 'Buyer' if Paid By is 'Buyer'.   *B* . *Brokerage Price Contract Document Print related gaps:*   Like above point A, similar gap need to be filled for Price Contract document print.   Here, iDeal have two options - (i) Buyer (ii) Seller.   *!pastedImage_d109045_5.png!*   If Buyer is selected, Buyer name and address need to be printed as below (for the same price contract number).   !pastedImage_d109045_6.png!   If Seller is selected, Seller name and address need to be printed as below (for the same price contract number).   !pastedImage_d109045_7.png!   *C. Cost tab Gap:*   # In Cost tab – add Paid By drop down field having options as – (i) Buyer, (ii) Seller (iii) Company. This field is to keep track of commission amount paid by which party. # If Party is selected as Broker in grid, then only enable above drop down for that line. # Add Paid by column in Cost tab search screen as well.   !pastedImage_d109045_8.png!   *D. Add Invoice Tab (Should be visible Only if 'Brokerage' checkbox is ticked for a contract):*   # Contract Screen add one new tab Invoice of having below information. This tab is to keep track of commission amount paid by Seller to Buyer directly. # Invoice Number, (ii) Date (iii) Description (iv) Amount, (iv) Currency UOM (v) Counter Party, (vi) Remarks.   !pastedImage_d109045_9.png!   Counter Party drop down values will be - (i) Buyer, (ii) Seller, (iii) Broker (iv) Insurance.   Amount drop down will show the currencies in the system.   2. Add this Invoice No column in Detail tab search screen and keep it default hide   *E. Add Brokerage Commission Processing Detail tab in Search Screen:*   12. Add detail tab in brokerage commission processing search screen and add below fields in that tab.   !pastedImage_d109045_10.png!   (a) Contract Sequence No   (b) Contract Date   (c) Item   (d) seller   (e) seller ref   (f) Buyer   (g) Buyer ref   (g) Rate/Unit   (h) Start Date   (i) End Date   (j) Quantity   (k) UOM   -(l) estimated Amount -----   -(m) Accrued Amount ------   -(n) UOM -----   (o) Receivable check box   (p) Due Date   (q) Payment Date   (r) Requested Amount   (s) Received/paid Amount   (t) Voucher Reference (with hyperlink)   (u) Invoice Reference (with hyperlink)   (v) Batch Number - Brokerage Commission batch number   *F. Add 'Contract Date' field in Cost tab search screen.*   !null! This will enable user to have projected commission on particular contract date ranges. Default this field can be in hide mode.