Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / TRXQTY vs. Overhead_Un...
Finance | Project Operations, Human Resources, ...
Unanswered

TRXQTY vs. Overhead_Units_1 in Key2Act

(0) ShareShare
ReportReport
Posted on by Nusc 70

Hi everyone,

 

For Time Track History (WS30702) there was an issue of what is defined as Hours/Units. We initially thought it was  TRXQTY.

 

For jobs that are Service  and labour, TRXQTY would have no value where OverHead_Units_1 would have a value.

Open Service Calls (SV000810)

Time track History (WS30702)

I have scripts that use SV000810 and are not pulling the correct QTY. What table do you advise that I use to get the proper QTY amount?

 

If I pull WS30702, it is a massive table and does not necessarily match the record in SV000810.

Categories:
Microsoft Dynamics GP
  • Nusc Profile Picture
    Nusc 70 on at
    RE: TRXQTY vs. Overhead_Units_1 in Key2Act

    Do you know any users here that use Key2Act? Do I need to use proper has tags for this thread?

  • Angela Eckman Ebensteiner Profile Picture
    Angela Eckman Ebens... 1,216 on at
    RE: TRXQTY vs. Overhead_Units_1 in Key2Act

    Hi,

    Can you tell me what version is listed next to: Microsoft Dynamics GP in the Help window of GP?   Go to Help > About Microsoft Dynamics GP from any window within GP.    You can also get there by clicking the little question mark in a circle in the upper right-hand corner of the main menu.

    Also, can you please list out the product you see (or grab a screenshot) of the products under Microsoft Dynamics GP > Tools > Customize > Customization Status.   That will help me see what you have listed.

    I don't have these tables listed in SQL in GP2018.  

    Are you using Microsoft GP or are you using Dynamics 365?  Maybe that is where the discrepancy is.  Those are two different product lines.   This forums area is for Microsoft Dynamics GP.  

    Warmest Regards,

    Angela

  • Kerluke Profile Picture
    Kerluke 20 on at
    RE: TRXQTY vs. Overhead_Units_1 in Key2Act

    so sorry but i m not sure about that.

    Increase your proficiency with the Dynamics ReadyPayOnline Login 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.

  • Angela Eckman Ebensteiner Profile Picture
    Angela Eckman Ebens... 1,216 on at
    RE: TRXQTY vs. Overhead_Units_1 in Key2Act

    Hi Nusc,

    This is Angela; I'm going to let the community try to help you with this one.  These tables (SVC00810/WS30702) don't appear to be Microsoft Dynamics GP tables and seem to be more 3rd party.   Hopefully someone in the community is able to assist.

    Warmest Regards,

    Angela Ebensteiner

    Sr Technical Engineer 

    Microsoft Support

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans