From: marcin on
Hi,
Go to table and/or form properties and check Permissions. Add your
table to Permissions property.

Bye,
Marcin

PlingPHB wrote:
> I've modified the Sales Invoice Header table (112) to include a number of new
> fields, which are transfered from the Sales Header table (36) when the Sale
> is posted. I need to be able to update these new fields after the Sale has
> been posted - however trying to do so gives "You do not have permission to
> modify records in the Sales Invoice Header table." error.
>
> I only want to modify the fields I've added to the table, not the existing
> ones. I've looked at the Sales Inv.-Printed codeunit (315) but I can find no
> way to use it's permissions on another codeunit to enable editing - I still
> get the same error.
>
> Can someone suggest where I might be going wrong? I'll admit my
> understanding of Navision's use of Permissions isn't my strong point!
>
> Thanks,
> --
> !PHB

From: PlingPHB on
Looking at the codeunit you mention (391), I can't see the trigger you
mention - I'm only seeing the OnRun for the codeunit. License-wise I do have
"Application Builder" but not "Solution Developer" - I presume that's why
I'm not seeing the trigger?

--
!PHB


"Savatage" wrote:

> If you look at codeunit 391 Shipment Header - Edit
>
> SalesInvoiceHeaderEdit <- On this trigger you need to add
> SalesInvoiceHeader2."YourField" := SalesInvoiceHeader."YourField";
>
> Enjoy
>
> "PlingPHB" wrote:
>
> > I've modified the Sales Invoice Header table (112) to include a number of new
> > fields, which are transfered from the Sales Header table (36) when the Sale
> > is posted. I need to be able to update these new fields after the Sale has
> > been posted - however trying to do so gives "You do not have permission to
> > modify records in the Sales Invoice Header table." error.
> >
> > I only want to modify the fields I've added to the table, not the existing
> > ones. I've looked at the Sales Inv.-Printed codeunit (315) but I can find no
> > way to use it's permissions on another codeunit to enable editing - I still
> > get the same error.
> >
> > Can someone suggest where I might be going wrong? I'll admit my
> > understanding of Navision's use of Permissions isn't my strong point!
> >
> > Thanks,
> > --
> > !PHB
From: PlingPHB on
It appears my license may be the issue, however whilst I was aware that I
couldn't edit certain code modules or tables with the "Application Builder"
license I didn't realise that I may be able to partially edit some - which
may be adding to my confusion.

Regards,
--
!PHB


"Marlin Parisien[MSFT]" wrote:

> Hello PHB.
> I understand that you're receiving the error "You do not have permission
> to modify records in the Sales Invoice Header table." after you modified
> the Sales Invoice Header table. Is this correct?
>
> I will have to look into this and get back to you with my findings. I see
> that savatage99 has responded and poses a good point to make sure that
> you're using the developers license to do this.
>
> As mentioned I will update you with my findings.
>
> I hope this is helpful and we look forward to hearing from you!
>
> Have a great evening!
>
> Regards,
>
> Marlin Parisien
> Microsoft Online Support Engineer
> Get Secure! - www.microsoft.com/security
>
> =====================================================
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> =====================================================
>
> This posting is provided "AS IS" with no warranties, and confers no rights
From: Kamil Sacek (Kine) on
Marcin, this is not possible to do with Application builder granule. You need
to have solution developer to be able to add permissions for "protected"
tables (posted documents, entries)...

"marcin" wrote:

> Hi,
> Go to table and/or form properties and check Permissions. Add your
> table to Permissions property.
>
> Bye,
> Marcin
>
> PlingPHB wrote:
> > I've modified the Sales Invoice Header table (112) to include a number of new
> > fields, which are transfered from the Sales Header table (36) when the Sale
> > is posted. I need to be able to update these new fields after the Sale has
> > been posted - however trying to do so gives "You do not have permission to
> > modify records in the Sales Invoice Header table." error.
> >
> > I only want to modify the fields I've added to the table, not the existing
> > ones. I've looked at the Sales Inv.-Printed codeunit (315) but I can find no
> > way to use it's permissions on another codeunit to enable editing - I still
> > get the same error.
> >
> > Can someone suggest where I might be going wrong? I'll admit my
> > understanding of Navision's use of Permissions isn't my strong point!
> >
> > Thanks,
> > --
> > !PHB
>
>
From: Gottfried Mayer on
PlingPHB schrieb:
> I've modified the Sales Invoice Header table (112) to include a number of new
> fields, which are transfered from the Sales Header table (36) when the Sale
> is posted. I need to be able to update these new fields after the Sale has
> been posted - however trying to do so gives "You do not have permission to
> modify records in the Sales Invoice Header table." error.
>
> I only want to modify the fields I've added to the table, not the existing
> ones. I've looked at the Sales Inv.-Printed codeunit (315) but I can find no
> way to use it's permissions on another codeunit to enable editing - I still
> get the same error.
>
> Can someone suggest where I might be going wrong? I'll admit my
> understanding of Navision's use of Permissions isn't my strong point!
>
> Thanks,
> --
> !PHB

Hi PlingPHB,

The pointer of Savatage to CU391 is very good, but here is what I would do:

- Design Codeunit 391 and "Save As" to 50000 or whereever you have
permissions to create a new Codeunit.
- Design the new Codeunit and change the following things:
- Change the PROPERTIES of the Codeunit:
- Add Modify - Permissions to the Sales Invoice Header
- Change the TableNo to Sales Invoice Header
- Add a Global Variable "SalesInvoiceHeader" (or whatever name you
want) to the Codeunit
- Modify the OnRun Trigger (there is only this one trigger in the CU)
to transfer the Fields you want to be editable (Just take the
current code as a template.

The rest should be obvious (look at the Posted Sales Shipment Form)


HTH
Gottfried