As regular readers will know I have just started to use Sage 200. I am in the process of automating our accouts pack and have investigated the =SgAccNominalLedgerActual($A13,$C$1,C$2) Where A13 contains the G/L A/C, C1 the year, and C2 the period. I have a table of all account numbers and descriptions with the months as columns numbered 1-12.
All is well in the BS, however all P&L accounts are returning NIL, even though the formula conforms.
Does anyone have any idea or has anyone come across this before? Any help acknowledged and thanks.