Project

General

Profile

Tasks #11291

Showing Wrong Cost in Sales report

Added by Rijas P over 1 year ago. Updated 8 months ago.

Status:
Closed
Priority:
Immediate
Assignee:
Rijas P
Start date:
08/04/2023
Due date:
% Done:

50%

Estimated time:
Spent time:
0.50 h

Description

Dear Ijaz,

Showing Wrong cost for some invoices in Sales report

I assume this issue only occurs when an order is returned through the delivery app and delivered again. In this case 3 shipments entries will come Voided, revised and completed Documents. In sales report the total cost is calculated from all the 3 documents. Please check.

Files

WhatsApp Image 2023-07-29 at 11.45.44 AM (1).jpeg (152 KB) WhatsApp Image 2023-07-29 at 11.45.44 AM (1).jpeg Rijas P, 08/04/2023 01:28 PM
WhatsApp Image 2023-07-29 at 11.55.47 AM.jpeg (136 KB) WhatsApp Image 2023-07-29 at 11.55.47 AM.jpeg Rijas P, 08/04/2023 01:28 PM

History

#1

Updated by Ijas Ahammed over 1 year ago

  • Status changed from New to Bugzilla Created
  • Assignee changed from Ijas Ahammed to Dev User

It is already reported, Will let you know once it's fixed.

[[https://bugzilla.posibolt.com/show_bug.cgi?id=9812
]]

#2

Updated by Rijas P over 1 year ago

  • Priority changed from Urgent to Immediate

Dear Ijaz,

Please resolve this immediately, we have to submit the Sales report to mgt.

#3

Updated by Rijas P over 1 year ago

  • Assignee changed from Dev User to Peer Thanesh

This is an important issue... Please update in Live immediately.

#4

Updated by Peer Thanesh over 1 year ago

  • Assignee changed from Peer Thanesh to Dev User
#5

Updated by Rijas P over 1 year ago

  • Assignee changed from Dev User to Peer Thanesh

Still issue exist. Please resolve immediately.

#6

Updated by Mohamed Suhail over 1 year ago

  • % Done changed from 0 to 50

Rijas P wrote:

Still issue exist. Please resolve immediately.

Rijas,
We need to update the server with version 8.3.8 for a permanent fix
For now, I have run a query to perform a temporary fix for the existing transactions so that the report will show the correct profit. Please check

#7

Updated by Mohamed Suhail over 1 year ago

Mohamed Suhail wrote:

Rijas P wrote:

Still issue exist. Please resolve immediately.

Rijas,
We need to update the server with version 8.3.8 for a permanent fix
For now, I have run a query to perform a temporary fix for the existing transactions so that the report will show the correct profit. Please check

euro=# update m_costdetail set amt=amt*-1 where m_inoutline_id in (select m_inoutline_id from m_inoutline where m_inout_id in (select mi.m_inout_id from m_inout mi join c_order co  on mi.c_order_id=co.c_order_id join c_invoice ci on ci.c_order_id=co.c_order_id where mi.docstatus in ('RE') and ci.docstatus in ('CO','CL') and ci.issotrx='Y' and mi.created >= '2023-05-30' order by ci.created desc)) ;;
UPDATE 3161
#8

Updated by Peer Thanesh over 1 year ago

  • Assignee changed from Peer Thanesh to Dev User
#9

Updated by Noufal K over 1 year ago

  • Status changed from Bugzilla Created to Resolved
  • Assignee changed from Dev User to Ijas Ahammed
#10

Updated by Ijas Ahammed over 1 year ago

  • Assignee changed from Ijas Ahammed to Rijas P

Dear Rijas,

Please check with the testing server.

#11

Updated by Rijas P about 1 year ago

  • Status changed from Resolved to Closed

Found fixed in latest update

#12

Updated by SHAIJAL EDAVANA 8 months ago

  • Tracker changed from Bug to Tasks
  • Project changed from Euro Novelties to Temp Projects
  • Category deleted (Others)

Also available in: Atom PDF