Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Georges Leduc]

Hello NAVUG,

The company I work for have just went live on NAV 2017 and they have a strange behaviour when they try to delete a Purchase Invoice in their live company.

When they do, they get that message: You do not have the following permissions on TableData Purch. Inv. Header: Insert

It’s strange because all the users have SUPER has permission in the Security, therefore they have access to everything.

The other strange part is that in a test company which is on the same DB, same SQL server, etc… they do not have that problem.

Has anyone of you encounter that behaviour before? If so, what was the solution?

I looked on Customer Source if there was anything about that and could not find something similar.

Thanks in advance for your help.

——————————
Georges Leduc
Georges Leduc ERP Consultant, S.A.
L’Ile Perrot QC
——————————

[Lewis Rosenberg]

Just a shot in the dark:  Tray recompiling the Purch. Inv. Header table (Table 122).

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Sophia Gjorgievska]

We had the same issue when we went live with a client on 2017.  What version of Codeunit 364 (PostPurch-Delete) are you running?  One of our developers found a bug with this codeunit and after we replaced it we were no longer having the issue.  The version we’re running is dated 2/23/17, but I’m sure it should be fixed in subsequent versions.

——————————
Sophia Gjorgievska
Senior Consultant
Socius
Brecksville OH
——————————
——————————————-

[Georges Leduc]

Hi Sophia,

Your suggestion is the solution.  I installed a more recent codeunit 364 and it fixed the problem.

Many thanks for your help.

——————————
Georges Leduc
Georges Leduc ERP Consultant, S.A.
L’Ile Perrot QC
——————————
——————————————-

[Val Gameiro]

in NAV you cannot delete posted documents. It’s against the GAAP, and it affects a lot of tables, including the G/L — and you can’t delete stuff off the G/L.

You have to Credit Memo it out. Use the Copy Document function which should automatically apply the purchase credit memo to the invoice.

V

——————————
Val Gameiro
Senior NAV Analyst
BPL Plasma
Austin, Texas
——————————
——————————————-

[Sophia Gjorgievska]

Val,

I don’t think Georges is talking about deleting a posted document, which I agree should never be deleted. This is a bug in 2017 where a Purchase Invoice, which hasn’t  been posted yet,  cannot be deleted.

——————————
Sophia Gjorgievska
Senior Consultant
Socius
Brecksville OH
——————————
——————————————-

[Georges Leduc]

Thank you all for your reply,

Sophia, I will take a look at that codeunit.

Lewis, I will compile that table.

Val, Sophia is right I am looking to delete a non posted document, however, for your information, you can delete a posted document.  What you cannot delete is all the ledgers that have been generated by the document.

Thanks again

Georges

——————————
Georges Leduc
Georges Leduc ERP Consultant, S.A.
L’Ile Perrot QC
——————————
——————————————-

[Sue Barrett]

We experienced an issue that prevented unposted purchase invoices from being deleted in NAV 2017.

The issue turned out to be a new “feature” with 2017 whereby the deletion of purchase invoices was not permitted if the posted invoice number series is set to the same no series.

Our NAV partner fixed this for us and was checking if this was fixed in CU2.

——————————
ES Barrett
NAV Project Manager
Sudbury
——————————
——————————————-

[Sophia Gjorgievska]

In our case, we don’t ever have the same No. Series assigned to 2 different document types.  Replacing just the codeunit with a newer version resolved the issue.

——————————
Sophia Gjorgievska
Senior Consultant
Socius
Brecksville OH
——————————
——————————————-

[Sophia Gjorgievska]

That’s great, Georges. Thanks for the update.

——————————
Sophia Gjorgievska
Senior Consultant
Socius
Brecksville OH
——————————
——————————————-