Opening Balance Formula for SEI

Question

Good Day 
 
 I am attempting to create a trial balance that includes opening and closing balances, but I can't seem to locate where those options live in SQL or in X3. Is this something I will have to make a formula for? If so does anyone have any advise?

pnightingale · Answer

Hi Chip, 
 Have you looked at the BALANA and BALANCE tables? BALANA is balances with dimensions. You can use it in conjunction with the Account balances inquiry (CONSBAL) to test your balances.

Sage X3

Opening Balance Formula for SEI

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING