Financial report formulas take period 12 and ADJ as one.
Financial report formulas take period 12 and ADJ as one.
(OP)
Accpac 5.1 SM-SP3
Pervasive V8
Excel 2002-SP2
Hi, I found a problem with the formulas FRAMT("NETP") and FRAMT("NETP.L1") in my P&L financial report.
They work fine for any period from 1 to 11. When I do period 12, they accumulate amounts from period 12 and period ADJ.
Is the formula supposed to work that way?
If yes how can I make the formula to take the amount from period 12 only?
Any suggestion appreciated.
Thanks, Jose.
Pervasive V8
Excel 2002-SP2
Hi, I found a problem with the formulas FRAMT("NETP") and FRAMT("NETP.L1") in my P&L financial report.
They work fine for any period from 1 to 11. When I do period 12, they accumulate amounts from period 12 and period ADJ.
Is the formula supposed to work that way?
If yes how can I make the formula to take the amount from period 12 only?
Any suggestion appreciated.
Thanks, Jose.
RE: Financial report formulas take period 12 and ADJ as one.
This is the correct behavior of the formulae. They both include numbers from period 14, or the adjustment period, if printing final period of the year. Check out NETADJ which gives you the amount from period 14. To print the last period without the adjustment, use FRAMT("NETP")-FRAMT("NETADJ").
------------------------
rvspy@nospam.hotmai1.com
(remove nospam and change 1 to L)