Financial report formulas take period 12 and ADJ as one.

jforero · Oct 10, 2003

Accpac 5.1 SM-SP3
Pervasive V8
Excel 2002-SP2

Hi, I found a problem with the formulas FRAMT("NETP&quot

and FRAMT("NETP.L1&quot

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.

rvspy · Oct 10, 2003

Jose,
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&quot

-FRAMT("NETADJ&quot

.

------------------------
rvspy@nospam.hotmai1.com
(remove nospam and change 1 to L)

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Financial report formulas take period 12 and ADJ as one.

jforero

MIS

rvspy

Technical User

Similar threads

Part and Inventory Search

Sponsor