Project

General

Profile

Tasks #9786

Stock adjustment void - Showing 2 revised entry for Single Doc

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

Status:
Closed
Priority:
Immediate
Assignee:
Dev User
Start date:
03/04/2023
Due date:
% Done:

100%

Estimated time:
Spent time:
0.25 h

Description

Muzammil,

Please see the attached Stock adjustment document which we voided and showing multiple revised entry. Doc#634517

History

#1

Updated by MUZAMMIL S almost 2 years ago

  • Assignee changed from MUZAMMIL S to Noufal K

This issue happened second time.

#2

Updated by Mohamed Suhail almost 2 years ago

  • Status changed from New to Resolved
  • Assignee changed from Noufal K to MUZAMMIL S
  • % Done changed from 0 to 100

MUZAMMIL S wrote:

This issue happened second time.

Deleted

euro=# delete from m_costdetail where m_inventoryline_id in (select m_inventoryline_id from m_inventoryline where m_inventory_id =1014555);
DELETE 102
euro=# delete from m_transaction where m_inventoryline_id in (select m_inventoryline_id from m_inventoryline where m_inventory_id =1014555);
DELETE 102
euro=# delete from m_inventoryline where m_inventoryline_id in (select m_inventoryline_id from m_inventoryline where m_inventory_id =1014555);
DELETE 102
euro=# delete from m_inventory where m_inventory_id =1014555;
DELETE 1

posiboltdb=# delete from m_costdetail where m_inventoryline_id in (select m_inventoryline_id from m_inventoryline where m_inventory_id =1014555);
DELETE 0
posiboltdb=# delete from m_transaction where m_inventoryline_id in (select m_inventoryline_id from m_inventoryline where m_inventory_id =1014555);
DELETE 102
posiboltdb=# delete from m_inventoryline where m_inventoryline_id in (select m_inventoryline_id from m_inventoryline where m_inventory_id =1014555);
DELETE 102
posiboltdb=# delete from m_inventory where m_inventory_id =1014555;
DELETE 1

eurobackup=# delete from m_costdetail where m_inventoryline_id in (select m_inventoryline_id from m_inventoryline where m_inventory_id =1014555);
DELETE 102
eurobackup=# delete from m_transaction where m_inventoryline_id in (select m_inventoryline_id from m_inventoryline where m_inventory_id =1014555);
DELETE 102
eurobackup=# delete from m_inventoryline where m_inventoryline_id in (select m_inventoryline_id from m_inventoryline where m_inventory_id =1014555);
DELETE 102
eurobackup=# delete from m_inventory where m_inventory_id =1014555;
DELETE 1

eurobackup=# delete from fact_acct where ad_table_id=321 and record_id=1014555
;
DELETE 204

euro=# delete from fact_acct where ad_table_id=321 and record_id=1014555
;
DELETE 204

#3

Updated by MUZAMMIL S almost 2 years ago

  • Assignee changed from MUZAMMIL S to Rijas P

Rijas ,
Please check

#4

Updated by MUZAMMIL S almost 2 years ago

  • Assignee changed from Rijas P to Savad Ibrahim

Please try to replicate this issue.

#5

Updated by Muhammed Akther almost 2 years ago

  • Status changed from Resolved to In Progress
#6

Updated by Muhammed Akther almost 2 years ago

  • Status changed from In Progress to Bugzilla Created
  • Assignee changed from Savad Ibrahim to Dev User
#7

Updated by Rijas P almost 2 years ago

  • Status changed from Bugzilla Created to Closed

Bugzilla ticket raised and hope will fix soon.

#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