AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Acumatica Generic I...
Default Values for ...
 
Notifications
Clear all

Questions Default Values for Dates in GI

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Wyatt.ERP 7 years ago
8 Posts
4 Users
3 Reactions
6,069 Views
RSS
Alisann Crough
Posts: 28
 Alisann Crough
Topic starter
November 28, 2018 12:49 pm
(@alisann-crough)
Eminent Member
Joined: 8 years ago

Is there anyway to change what the default days are for @WeekStart and @WeekEnd? We start our week on Saturday not Sunday.


7 Replies
Shawn P Slavin
Posts: 196
 Shawn P Slavin
November 28, 2018 1:02 pm
(@shawn-p-slavin)
Estimable Member
Joined: 6 years ago

I believe the @WeekStart is driven by the local settings in Acumatica.  See the article on the Acumatica website: Acumatica Help Article

The Time and Expense Preferences screen provides the ability to customize the start date of a week. I don't know if that will affect the results of the @WeekStart and @WeekEnd system variables but you can try in a test company and see if it works for you. Form: EP101000.


Reply
Alisann Crough
 Alisann Crough
(@alisann-crough)
Joined: 8 years ago

Eminent Member
Posts: 28
November 28, 2018 1:48 pm
Reply toShawn P SlavinShawn P Slavin

Unfortunately, @StartWeek day doesn't match the First Day of the week in the Time and Expense Preferences (EP101000). Thanks


Reply
Shawn P Slavin
Posts: 196
 Shawn P Slavin
November 28, 2018 1:52 pm
(@shawn-p-slavin)
Estimable Member
Joined: 6 years ago

I thought that might be the case. The next option is to use the @StartWeek variable within a function that adds a -1 to the date returned by the variable.

This won't always be possible. For example, if you are using the variable on the conditions tab of a GI. 


Reply
Tim Rodman reacted
Alisann Crough
 Alisann Crough
(@alisann-crough)
Joined: 8 years ago

Eminent Member
Posts: 28
September 16, 2019 5:29 pm
Reply toShawn P SlavinShawn P Slavin

@shawn-slavin

Functions seem to be available in Conditions but not in Parameters. So I am able to use =(DateAdd( [Date], ‘D’, -1))  in my conditions but not in the default value of my Parameter. Any other suggestions? I can't believe every company using Acumatica is happy using Sunday - Saturday as their starting and ending days for their week.


Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
October 16, 2019 11:24 pm
(@timrodman)
Famed Member
Joined: 11 years ago

Good point Alisaan. I just created a feedback idea for this. Would you might adding both a Vote and a Comment to it?

https://feedback.acumatica.com/ideas/ACU-I-2534


Reply
Alisann Crough
 Alisann Crough
(@alisann-crough)
Joined: 8 years ago

Eminent Member
Posts: 28
October 24, 2019 9:33 pm
Reply toTim RodmanTim Rodman

@timrodman

Thanks Tim for posting this in Ideas for Acumatica.


Reply
Tim Rodman reacted
Wyatt.ERP
Posts: 128
 Wyatt.ERP
October 25, 2019 10:51 am
(@wyatt-erp)
Estimable Member
Joined: 6 years ago

I voted for this.  I don't run into it often, but it is frustrating when I do.


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 48 Online
  • 2,437 Members
Our newest member: Matt Butler
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×