Sales Order Invoice

Finance and Operations/AX Developer Forum
1

hi all

when i am posting the invoice of the Sales order following error is showing:

“Cannot edit a record in Sales order line - Connection - Update table (SalesParmSubLine). Parameter ID: 00426305_001, YRSC-DN-11-15158.
The record already exists.”

can anyone explain me why this error is coming while invoicing the sales order.

2

You would need to debug it, it looks like a modification issue to me.

3

actually the user changes the unit and the quantity of the item after making the sales order.

where can be the problem any idea…

4

HI All

I have resolve the above problem raised by me.Actually this error comes when our Ax system temporary went down while user was posting invoices.Solution is to delete the records from “salesparmsubline” table from database by selecting(search) by “parmid”.

5

Hi All

I have solve the above proble raised by me.Actually this problem occurs when our Ax system temporary went down while user was posting invoices.Solution is to delete the records from “salesparmsubline” table from database by selecting(search) by “parmid”

6

Could you please explain how did you delete it?

pperciate if you write the script as i’m not technical

7

Hi Gaber,

I think Imran deleted the record manually rather than using script as there was only one record.

I will suggest also to delete the record manually as using script might create problwm, if you haven’t updated the SO number properly.

Pranav…

8

Dear Imran

i have the same problem. kindly till me the steps to solve it

Note:- I’m working on AX09

Regards

Elhussieny

9

Hi Elhussieny

i got this error a long back, i think i delete the line and re-create it.