Adding a column

Rosemarie · 2005-04-28

Hi,

I need to have a new column added to the Sales Quote Form. Is this fairly easy to do? I have tried going to Designer and then just insert, but it isn't working. Can someone tell me how to do this? It just needs to be a text column and it doesn't have to show up on the printed quote.

Thanks
Rosemarie

Savatage · 2005-04-28

add a field to the Sales Line Table

probably have to save the new field in the 50000 to 50099 range.

Example/

Field No: 50000
Field Name: Your Text
Data Type: Text
Length: 30 or whatever you need

Save & complie

Goto Sales Quote (click on the subform)
Designer
Goto Field Menu
Drag & Drop Your New Field

Save & Compile

Rosemarie · 2005-04-28

Thank you, the instructions are very simple. I did get a permission error however.
"You do not have read permission for the Service Document Register Table"
I am a super user and our license contains form designer and report designer. Do I need any other licenses to do this?

Thanks
Rosemarie

Savatage · 2005-04-28

I thought you were talking about

Sales & Recievables -> Quotes....

How did that table get involved?

Rosemarie · 2005-04-28

I don't know. That's what came up after I tried to save and compile.
It's weird because I tried your instructions on the purchase line table and I added a column without any problem, so I know it works. But I can't get it to work on the sales line table.

I don't know why this permission error is coming up and why it's coming up when all I'm trying to do is add a column to the Sales Quote form.

Savatage · 2005-04-28

note: I took a look at that Service Document Register table just to see what it was & received a permissions error too.
Mainly because we do not have the granule for that and we don't use it anyway.
But I doesn't stop me from accessing the Sales Line (Table 37 for me).

Maybe someone else will chime in with some other insight.

Rosemarie · 2005-04-28

Thanks.

I don't really understand why it is connected as we don't have the granule either. The programmers did do some customizing, so perhaps they used that table for something? I'll contact the Navision person and see what they say.

Thanks for your help and instructions!!! I know how to add a column now and have already added to our purchase order form.

Rosemarie

fb · 2005-04-28

I don't know why this permission error is coming up...

When in Design on the Sales Line table, click on Edit, Select Object, and then click View, Properties. Is the Service Document Register table listed in the 'Permissions' property?

If so, your license must have the permissions granted in this property in order for you to be able to change the table design (even though 'your' change has nothing to do with the 'other' table.)

In version 3.60, this table is listed in the Permissions property. That 'feature' was removed at v3.70.

Rosemarie · 2005-04-29

Thank you,
That is what the problem is. That table is listed there.

Thanks for your help.

Savatage · 2005-04-29

it's not part of the permissions either in 3.10 - I wonder what was the thinking in 3.6?

Have you tried removing that permission?
Will it allow you?
then do the change?

Rosemarie · 2005-04-29

No, I haven't tried to remove it. I'll try that and let you know.

Adding a column

Comments

Categories