Hi
Our year end is approaching. It is normal for period 12 to be closed and draft accounts prepared. However it often happens that further adjustments are made after this. Period 12 is then re-opened and further journals posted. I am looking for a way to group these adjustments together on a FRX report to provide clarity that they were made after the draft accounts were prepared.
I thought that I could create a period 13 with the same dates as period 12 and have all the adjustments posted here once P12 is closed. I did some research and found the following posted on this site
"This is a popular trick, to set up a 13th period in your Fiscal Period setup with the same date range as the December period. You then close December, and with the 13th audit period open, transactions will post in to that audit period. Sounds brilliant right? Well, it is...as long as you never run financial reconcile (Tools>>Utilities>>Financial>>Reconcile) on that year. As it will reattribute the postings to the earliest period with the same start date (assuming both periods were closed when you ran reconcile) or all postings (including your original Dec postings) will be attributed to the open period (if the 13th is open, and the 12th is closed). Ugh. Better choice? Set up a source document code (Tools>>Setup>>Posting>>Source Document) called AJ for Adjusting Entries and select it whenever you enter an adjusting entry instead of GJ. Then use the Cross Reference by Source Document report to view your AJs for a time period (Reports>>Financial>>Cross Reference>>Source Document)."
This I can understand. The problem is that I want to get the adjustments to appear on an FRX.
Does anybody know if it is possible to code an FRX column layout to display postings from a specific Source document , i.e all adjusting entries?
*This post is locked for comments
I have the same question (0)
