AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Analytica...
Trying to display f...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

#AcumaticaTnT Trying to display for example "August" instead of fiscal period "08" in Journal Transactions window (GL633000)

Acumatica Analytical Report Manager (Financial Report Writer)
Last Post by Alec Axelblom 1 year ago
3 Posts
2 Users
1 Likes
737 Views
RSS
Alec Axelblom
Posts: 12
 Alec Axelblom
Topic starter
September 2, 2021 1:57 pm
(@alec-axelblom)
Member
Joined: 1 year ago

Hello,

I have been trying to use the formula below to show a fiscal period by displaying the month with letters, for example "August", instead of for example the period 08-2020. I can get the below formula to show "August" etc in the balance sheet, but I can not get anything to work in journal transactions (GL633000).
=Report.GetPeriodDescription(@StartPeriod)
I have also tried using this formula for the same reason without result:
=Format( '{0: MMM yyyy}', Report.GetPeriodEndDate(@StartPeriod))

To sum it up: When I am running a journal transaction report if I select the starting period 01-2020 and end period 12-2020, I would like to have January and December show up in the journal transaction report in the top/header section. 

Small disclaimer: I am using Visma.net, which is a product built on Acumatica for the Nordic market. I have found a lot of well built formulas on this forum that has helped me with other issues, but the above issue I can not solve. I apologize for any grammatical mistakes or unclear vocabolary due to me not working in English. 

2 Replies
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
September 3, 2021 2:53 pm
(@timrodman)
Member
Joined: 7 years ago

I think you're missing the first Parameter in the GetPeriodEndDate formula.

Here's a formula from the DPLP Column Set in the SalesDemo database:

='As of  ' + IIf(@UseMasterCalendar OR Len(@Organization)=0,  Format('{0: MMMM d, yyyy}', Report.GetPeriodEndDate(0, @StartPeriod) ),  Format( '{0: MMMM d, yyyy}', Report.GetPeriodEndDate(@Organization, @StartPeriod) ) )
image
Reply
Alec Axelblom
Posts: 12
 Alec Axelblom
Topic starter
September 6, 2021 3:47 am
(@alec-axelblom)
Member
Joined: 1 year ago

I appreciate you trying to help me. Like I mentioned in my other thread I believe due to me working in a very old version this formula is not working. For example @UseMasterCalendar does not work as a reference in this window. 

The parameters I can find in the Visma.net report designer database in journal transactions (GL633000) is a very short list, and I find that existing reports use formulas and references that don't exist in the expression database in Visma.net report designer, which basically means that the list of formulas and references I can see is incomplete. This makes it hard to build more complicated formulas cause I have to test what works and what doesn't. 

 

Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,236 Topics
  • 9,868 Posts
  • 8 Online
  • 1,812 Members
Our newest member: Heather Jones
Latest Post: Sales Order Comment Lines / Memo / Note Lines
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×