Tasks #8401: Quotation print - Getting Duplicate items in print - Temp Projects - Posibolt

Tasks #8401

Quotation print - Getting Duplicate items in print

Added by Rijas P about 2 years ago. Updated 8 months ago.

Status:

Closed

Priority:

Normal

Assignee:

Rijas P

Start date:

11/25/2022

Due date:

% Done:

100%

Estimated time:

Spent time:

1.75 h

Description

Dear Muzammil,

Completed a Quotation from Mini server and took the printout. Actually 131 items entered in that quotation, but which printing quotation from Mini server some items getting duplicates and total items showing 211.

The file size is more than 5 MB, both Quotation print from Central and Mini server sent to you through WhatsApp.

Files

WhatsApp Image 2022-12-29 at 11.57.05 AM.jpeg (50.5 KB) WhatsApp Image 2022-12-29 at 11.57.05 AM.jpeg		Rijas P, 12/29/2022 01:29 PM
EuroQuotationFormat.jrxml (18.2 KB) EuroQuotationFormat.jrxml		Ashiq K, 07/19/2023 11:09 AM
EuroQuotationFormat_XLS.jrxml (19.8 KB) EuroQuotationFormat_XLS.jrxml		Ashiq K, 07/19/2023 11:09 AM

History

Updated by Mohamed Suhail about 2 years ago

Assignee changed from MUZAMMIL S to Rijas P

Rijas P wrote:

Dear Muzammil,

Completed a Quotation from Mini server and took the printout. Actually 131 items entered in that quotation, but which printing quotation from Mini server some items getting duplicates and total items showing 211.

The file size is more than 5 MB, both Quotation print from Central and Mini server sent to you through WhatsApp.

Rijas,
What is the current status?

Updated by Rijas P about 2 years ago

File WhatsApp Image 2022-12-29 at 11.57.05 AM.jpeg WhatsApp Image 2022-12-29 at 11.57.05 AM.jpeg added

Dear Muzammil,

The duplicate line items are showing with different pictures. I think the issue happens only if the items have upadted pictures multiple time. [Issue only in mini server]. PFA

Updated by Rijas P about 2 years ago

Dear Muzammil,

Reminder.

Updated by Rijas P over 1 year ago

Assignee changed from Rijas P to Peer Thanesh

Reminder..[Mimi server]

Updated by Mohamed Suhail over 1 year ago

Assignee changed from Peer Thanesh to Mohamed Suhail

Rijas P wrote:

Reminder..[Mimi server]

Updated by Mohamed Suhail over 1 year ago

Status changed from New to Resolved
Assignee changed from Mohamed Suhail to Shafeek M
% Done changed from 0 to 100

Mohamed Suhail wrote:

Rijas P wrote:

Reminder..[Mimi server]

Made the changes on central and mini server jrxml files to handle the duplicate image case

files:
EuroQuotationFormat.jrxml
EuroQuotationFormat_XLS.jrxml

diff old new

< left join ad_attachment att on (pr.m_product_id = att.record_id and att.ad_table_id = 208 and att.imagetype='CTI')
< left join ad_attachment posimage on (pr.m_product_id = posimage.record_id and posimage.ad_table_id = 208 and posimage.imagetype='POI')
---

left join lateral (select binarydata from ad_attachment where pr.m_product_id = record_id and ad_table_id = 208 and imagetype='CTI' order by created desc limit 1) as att on true
left join lateral (select binarydata from ad_attachment where pr.m_product_id = record_id and ad_table_id = 208 and imagetype='POI' order by created desc limit 1) as posimage on true

Shafeek M, please make changes in svn files