Skip to main content
Solved

Using an Item Code for Subtotals


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: 
 

 


 

View original
Did this topic help you find an answer to your question?

2 replies

wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • 98 replies
  • 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
  • 2621 replies
  • June 4, 2024

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings