Skip to main content
Answer

Using an Item Code for Subtotals

  • June 3, 2024
  • 2 replies
  • 49 views

wfilipiak67
Captain II
Forum|alt.badge.img+3

HI, I have a client who is asking for this on the Sales Order printed form, SO641010.rpx:


*T Total - Set a variable to accumulate the extended price for each line as it is processed with an initial value of 0. Increment value with the extended price for each line as lines are processed. If and when a line with Inventory ID = *T, the form should print the Transaction Description and the variable accumulated value in the extended price column. Reset the variable to 0.

I have a variable that is the subtotal of the lines. The problem I am having is printing the variable and when it is getting reset. I have tried various things to get this to work.

The Output is clearing the variable prior to the data being printed, see below. 
Here is a picture of the variable & how it is being reset. 
 




 

 

Best answer by wfilipiak67

We were able to figure this out by doing this: 
 

 


 

2 replies

wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • Answer
  • June 4, 2024

We were able to figure this out by doing this: 
 

 


 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • June 4, 2024

Thank you for sharing your solution with the community @wfilipiak67!