Edit Sales Shipment Header Table

LibertyMountain · 2007-07-24

We have a custom field in Sales Shipment Header called "Picking Mistakes". Initially, we had some issues populating the field. As a result, some of the records have bad data in the "Picking Mistakes" field. I want to correct the data, so we have accurate historical performance Reports. But, when I try to change the value, I'm told that I cann't edit the table.

If I try via Object Designer > Table 110 > Run > edit a "Picking Mistakes" value > I get the error: "Sales Shipment Header cannot be modified in this form."

If I try programmatically, I'm told I don't have necessary permissions.

I have SUPER access. Version is 3.71, running on Windows Server 2003.

nunomaia · 2007-07-24

Table Sales Shipment Header it's a protected table. Normal customer license can't change data in that table.

Savatage · 2007-07-24

Yes you need to be able to modify codeunit 391

smkolsoft · 2007-07-24

To correct the bad data, put your code in a function and put the function
in any codeunit.
Just call "codeunit.yourfunction" when you want to update the records.

Savatage · 2007-07-24

1) Superuser isn't gonna be able to do it.

2) 391-Codeunit-(Shipment Header - Edit) is the logical place for accessing the Shipment Header.

You need to have someone do this...

OnRun(VAR Rec : Record "Sales Shipment Header")

SalesShptHeader := Rec;
SalesShptHeader.LOCKTABLE;
SalesShptHeader.FIND;

// << Shipping Change
SalesShptHeader."Picking Mistakes" := "Picking Mistakes";

SalesShptHeader.MODIFY;
Rec := SalesShptHeader;

nunomaia · 2007-07-24

smkolsoft wrote:

To correct the bad data, put your code in a function and put the function
in any codeunit.
Just call "codeunit.yourfunction" when you want to update the records.

In some tables end user license can't modify even if there is a codeunit in customer license (50 000 – 99 999). To end customers modify those tables you must add those functions to specific code units has Alex Chow said.

Savatage · 2007-07-25

nunomaia wrote:

Alex Chow said.

:-k

I know, all us american's look alike

Alex_Chow · 2007-07-25

What?! Didn't even realized I was involved in this conversation.

Anywho, without the application builder and the solution developer license granule, you won't be able to modify codeunits. Especially codeunits that modifies data in a protected table.

nunomaia · 2007-07-25

Alex Chow wrote:

What?! Didn't even realized I was involved in this conversation.

Anywho, without the application builder and the solution developer license granule, you won't be able to modify codeunits. Especially codeunits that modifies data in a protected table.

sorry, #-o

Correction, Savatage

Edit Sales Shipment Header Table

Comments

Categories