Excel Sage (MAL)Function!

Excel Sage (MAL)Function!

Didn't find your answer?

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.

Replies (1)

Please login or register to join the discussion.

avatar
By Richard Willis
20th Jan 2012 14:45

Aha

A colleague has spotted that it is omitting, even in the BS, any account with a Cost Centre.

More digging required; I think there may be an alternative function!

Thanks (0)