Question

Generic Inquiry Formula for Budget Variance

  • 7 June 2023
  • 0 replies
  • 37 views
G
Rank

Hi There,

I’m trying to create a field using a formula that takes GL Actuals - GL Budget. Here is my formula but its not giving me the right numbers...

=IIf( ( [Account.Type] = 'I' and [glhistory.balancetype] = 'A' ), [GLHistory.CuryFinPtdCredit] - [GLHistory.CuryFinPtdDebit],0) - IIf( ( [Account.Type] = 'I' and [glhistory.balancetype] = 'B' ), [GLHistory.CuryFinPtdCredit] - [GLHistory.CuryFinPtdDebit],  0 )

 

I also want to nest in for account.type = ’E’ when debits and credits are reversed but was trying to get this to work first. All my other numbers are fine...just this variance field that is off.

0 replies

Be the first to reply!

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved