RL05 report - issues

R
Rodel Marasigan 👤 Member for 19 years 7 months

F is for Fiscal Period. You can change that to normal calendar if you wish.



To change Goto Report. Select the report you wanted to modify. Click the wand or Wizard button and click Next until you reached Date Option. Click Timescale and under Date Format tick calendar instead of Fiscal then click Ok. Click Next until you reached to Finish. Click Save Report then click Finish then run the report again.

D
David Blades 👤 Member for 22 years 2 months

Rodel



Many thanks.... this appears to ahve done the trick.



Only thing I have noticed is that the dates are as follows-



F2/1/2010 F2/8/2010 F2/15/2010 F2/22/2010 F3/1/2010 F3/8/2010 F3/15/2010



Do you know what the ’F’ prefix is for and can I remove it??



Thank you again

David

R
Rodel Marasigan 👤 Member for 19 years 7 months

David,

Check your currency settings under Edit-> Users Preferences then click currency tab. Make sure that Show currency symbol is tick and Show decimal digits is tick.

When running the report using ASCII Text File make sure that Field Delimiter is comma (,) and Text Qualifier is double quote (“) and tick view file when done. Also make sure that the extension of file is CSV

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts