Skip to main content
Solved

What table is the Week Descriptions in?

  • 30 December 2021
  • 6 replies
  • 229 views

wfilipiak67
Captain II
Forum|alt.badge.img+3

Hi, 
I am working on a Report to print Time Cards base on the entry done in Employee Time Card Entry, Screen ID = EP305000 . 

I am prompting for the beginning & ending weeks using the view name: =Report.GetFieldSchema('EPTimeCard.WeekID')

When I use the search, I get columns, Week, Start, End, Description & WeekID. 

I cannot seem to find the table that these are stored in or defined. 

I need to print the description, or the start date of the beginning week that is selected. 

So, I need to find a way to link from the parameter to a table to get the description 

Any ideas? 

Thank you in advance!




 

Best answer by vkumar

Hi @wfilipiak67 

You can find the week description column on EPTimeCard table. Here is GI reflecting those columns. 

 

Hope this helps,

Regards,

View original
Did this topic help you find an answer to your question?

6 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • December 30, 2021

Hi @wfilipiak67  Is this the Description field you are looking for?

 


wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • 98 replies
  • December 30, 2021

@Naveen B , 

No, I am looking for the (07/25 - 07/31) that is next to the week ID

 

Bill


Forum|alt.badge.img+11
  • Acumatica Support Team
  • 783 replies
  • Answer
  • December 31, 2021

Hi @wfilipiak67 

You can find the week description column on EPTimeCard table. Here is GI reflecting those columns. 

 

Hope this helps,

Regards,


wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • 98 replies
  • January 3, 2022

@vkumar, Thank you. 

Is there a way to do a join to that table to get the description from a parameter? 

The parameter is asking for the beginning week & I want to print the description along with it. 
 


Forum|alt.badge.img
  • Freshman II
  • 11 replies
  • July 26, 2023

Hi @vkumar , 

Is there any ways for me to get the Start Date and End Date from the WeekID? I tried using fields [EPTimeCard.WeekStartDate] and [EPTimeCard.WeekEndDate] but it not showing any values,

I don’t want to use the WeekDescription, I want to show the description date as [Date: 05/06/2023 -11/06/2023]

 

Current Result: [ Date: 2023-23 (05/06 - 11/06) ]

 

 

Expected Result: [Date: 05/06/2023 -11/06/2023]

 


Forum|alt.badge.img
  • Freshman II
  • 11 replies
  • August 29, 2023
wanizaidi27 wrote:

Hi @vkumar , 

Is there any ways for me to get the Start Date and End Date from the WeekID? I tried using fields [EPTimeCard.WeekStartDate] and [EPTimeCard.WeekEndDate] but it not showing any values,

I don’t want to use the WeekDescription, I want to show the description date as [Date: 05/06/2023 -11/06/2023]

 

Current Result: [ Date: 2023-23 (05/06 - 11/06) ]

 

 

Expected Result: [Date: 05/06/2023 -11/06/2023]

 

 

Updated (29/8/2023): I have managed to get solution for the issue. The report already come out as what I expected. I am using substring of the week description to get start and end date.

 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings