Hello Acumatica Community,
I’m trying to create a new Generic Inquiry (GI) and need to include the signEndBalance field. However, this field doesn’t exist in the database.
Our requirement is to display Debit (DR) or Credit (CR) in the Ending Balance column, depending on whether the balance is positive or negative.
Is there any way to achieve this within a GI ,perhaps by calculating or deriving the balance sign dynamically?
Any suggestions or workarounds (such as using calculated fields or custom DAC extensions) would be greatly appreciated.
Thank you!
The below I have used Debit Amt field , but I wanted to use signEndBalance
