News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Help with VS Tools dev...

Finance | Project Operations, Human Resources, ...

Answered

Help with VS Tools development

(0) Share

Report

Report

Posted on by VidyaG

15

Hello,

I am working on a Payroll batch entry window to add a custom process that updates Batch Number on the transactions from current batch based on some criteria.

As part of my logic, I need to be able to set range on UprTrxBatchDetailTable (UPR10302) by Batch Number field. However there is no Key available with Batch Number field. How can I achieve this? How can I add a secondary key on UPR10302 table, that can be available in my VS Tools project?

Appreciate any help or guidance on this. New to VS Tools. Hence not sure how to go around this.

Thanks in advance.

Vidya

Categories:

Microsoft Dynamics GP

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

VidyaG 15 on at

Like (0)

Report

RE: Help with VS Tools development

David,

Thank you. Now I see it.

I got misleaded by table keys in SQL :).

Regards,

Vidya
Verified answer

David Musgrave MVP ... 13,928 Most Valuable Professional on at

Like (0)

Report

RE: Help with VS Tools development

The UPR_TRX_Batch_Detail (UPR10302) table has Batch Number as its second key.

Just clear the Computer TRX Number field for start of the range and fill it for the end of the range.

Regards

David

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans