News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) NEW PVREC

Microsoft Dynamics SL (Archived)

NEW PVREC

(0) Share

Report

Report

Posted on by Jhenny Cox

260

When I include a new F3.

1. Insert new field with pv property : "EXE_P_Aduanas",

2. Create the StoreProcedure :

CREATE PROCEDURE EXE_P_Aduanas @parm1 char(3) AS

Select Cod_Aduana,Descr_Aduana from xAduanas

where Cod_Aduana like @Parm1 order by Cod_Aduana

3. Import the .csv to pvrec.

"EXE_P_Aduanas","","","Select Cod_Aduana,Descr_Aduana from xAduanas where Cod_Aduana like @Parm1 order by Cod_Aduana","xAduanas","xAduanas.Cod_Aduana;Codigo Aduana;0;0","xAduanas.Descr_Aduana;Descripcin;0;0"

After all, this message appears:

programming bulletproof error 10077: There are no defition in Data Dictorionary for the Table.field

Thanks for your Help!!

Leslie Cox

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: NEW PVREC

Hi Leslie Cox,

What you did with the mentioned steps are perfect. But you have to check the data type precision for the column Cod_Aduana. Whether the field having only 3 character precision or more than 3 character. Also confirm where the Mask property of the new user field having only accepts 3 digits (XXX) under the customized screen. And import the Pvrec (.csv) File once again in All Users mode.

Thanks & Regards

D.Santhosh

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans