Skip to main content
Answer

What table is the Week Descriptions in?

  • December 30, 2021
  • 6 replies
  • 266 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,

    6 replies

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

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

     

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    wfilipiak67
    Captain II
    Forum|alt.badge.img+3
    • wfilipiak67
    • Author
    • Captain II
    • December 30, 2021

    @Naveen B , 

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

     

    Bill

    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • 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,

    1 Attachments
    VijayKumarU
    Chris Hackett
    wfilipiak67
    Captain II
    Forum|alt.badge.img+3
    • wfilipiak67
    • Author
    • Captain II
    • 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. 
     

    W
    Freshman II
    Forum|alt.badge.img
    • wanizaidi27
    • Freshman II
    • 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]

     

    W
    Freshman II
    Forum|alt.badge.img
    • wanizaidi27
    • Freshman II
    • August 29, 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]

     

     

    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.

     

     

     

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved