Skip to main content
Solved

Sum Function in Apps 10 (IEE)

  • May 22, 2024
  • 2 replies
  • 66 views

Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 9 replies

In Sum Query the Cancelled Operations Duration not showing as a negative value.  

Eg - Time clocked 71.50 Transaction LABOR_IND

71.50 UNLAB_IND Transaction to cancel reporting of Indirect Labour Time

When I sum the Indirect Hours it is adding 2 x 71.50 , not +71.50 and -71.50

 

Best answer by magsjay

Hi Matt

 

Thank you for your response , this was very helpful 

 

2 replies

matt.watters
Ultimate Hero (Partner)
Forum|alt.badge.img+26
  • Ultimate Hero (Partner)
  • 699 replies
  • May 22, 2024

When an Indirect Labor Time report is cancelled, the record of the LABOR_IND transaction will show the Reversed Flag = YES (selected). So the search should focus on only the LABOR_IND transactions where Reversed Flag = NO (cleared).

 


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • 9 replies
  • Answer
  • May 22, 2024

Hi Matt

 

Thank you for your response , this was very helpful