Edit Sales Shipment Header Table

LibertyMountain

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

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

Savatage

Yes you need to be able to modify codeunit 391

smkolsoft

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

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

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

nunomaia wrote:

Alex Chow said.

:-k

I know, all us american's look alike

Alex_Chow

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

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