"Sorry, yes that would have been helpful to put in the post. Sage 100 Standard version 2013.
There are cell references for fiscal year and period.
The prior ytd references (YEAR-1). It has worked for all prior months, until the change of…"
"Agreed. Unfortunately I'm not familiar with the Sage 50 database structure. One thing you might want to try is create a graphical join container and add all tables available in the database. Assuming it's not too many, you could eliminate…"