Project

General

Profile

Tasks #13629

Payment already allocated but not showing the allocation

Added by Rijas P 10 months ago. Updated 8 months ago.

Status:
Closed
Priority:
Immediate
Assignee:
Rijas P
Start date:
03/27/2024
Due date:
% Done:

0%

Estimated time:

Description

Dear Ijas,

Payment already allocated with invoices. but currently not showing the allocation details and the payments not showing in over payment area.

Files

20240327-101436-210.png (156 KB) 20240327-101436-210.png Rijas P, 03/27/2024 11:44 AM
20240327-101516-893.png (100 KB) 20240327-101516-893.png Rijas P, 03/27/2024 11:45 AM

History

#1

Updated by Shemil Ali 10 months ago

  • Assignee changed from Ijas Ahammed to Abdul Fathah
#2

Updated by Sahla T V 10 months ago

  • Assignee changed from Abdul Fathah to System Admins Team

Please run the below SQL in Euro live.

UPDATE c_payment p SET c_paymenttype_id = (SELECT pt.c_paymenttype_id FROM c_paymenttype pt WHERE pt.ad_client_id = p.ad_client_id AND pt.tendertype = p.tendertype) WHERE c_paymenttype_id IS NULL AND p.ad_client_id = 1000000;
#3

Updated by Sharil Ali 10 months ago

  • Assignee changed from System Admins Team to Ajin P

Ajin

Please do the needful.

#4

Updated by Ajin P 10 months ago

noted

#5

Updated by Ajin P 10 months ago

  • Status changed from New to In Progress
  • Assignee changed from Ajin P to System Admins Team

Done

output:-

UPDATE 47425

#6

Updated by Sharil Ali 10 months ago

  • Assignee changed from System Admins Team to Rijas P
#7

Updated by Ijas Ahammed 10 months ago

  • Status changed from In Progress to Closed
#8

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