Statetement designer - not updating current year figures

Question

Hello, 
 
 I am trying to run a an IS through the statement designer function in Sage 300 ACCPAC. August would be period 1 of FY2022, however when I select this period, all the figures that come back are 0. If I select period 12 FY2021, everything runs as normal up to July 2021. 
 
 The formula in the statement is below, and it ties to the way the templates from previous years is set up, so it must work.

Does anyone have any ideas on what I may be missing?

dingosoft · Accepted Answer

FRAMTA("NETP.N1") would give you the net changes for August in FY2023 (as the .N1 means 1 year in the future.) Have you created the 2023 year? Is there anything posted to that period? FRAMTA("NET12P") should work. Try running a Trial Balance report for August and see what that shows.

Terry Gair · Answer

NETnP is going to give you result for Period n of the current year. Your case NET12P would be Jul 2022. If you wanted it to be July 2021 (per 12 last year), I would suggest NET12P.L1 instead. 
 NETP.N1 will give you result for current period NEXT year. Your case - Aug 2022.

Sage 300

Statetement designer - not updating current year figures

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING