*-*-* Requires access to run SQL syntax against the database.*-*-*
Problem:
The user is attempting to remove a line from an SO but is prevented from doing so due to an error stating that the record already exist within the SalesLineDelete table.
Required Information:
- Lot ID of the SO line.
This is found by right click>> SO Line in question >> select Record Info>> select Show All Fields.
Under the inventory section you will see an ID for "Lot ID".
-SO #
SQL Syntax:
-- DELETE FROM SALESLINEDELETE WHERE SALESID = '#' and INVENTTRANSID = 'Lot ID'
Why the Lot ID. Within the SalesLineDelete table the SO may have many lines associated to it. The InventTransID (Lot ID) is the unique identifier for the line within the SO that needs to be removed.
Once completed the user can remove the line from the SO using the normal sequence within AX.
Problem:
The user is attempting to remove a line from an SO but is prevented from doing so due to an error stating that the record already exist within the SalesLineDelete table.
Required Information:
- Lot ID of the SO line.
This is found by right click>> SO Line in question >> select Record Info>> select Show All Fields.
Under the inventory section you will see an ID for "Lot ID".
-SO #
SQL Syntax:
-- DELETE FROM SALESLINEDELETE WHERE SALESID = '#' and INVENTTRANSID = 'Lot ID'
Why the Lot ID. Within the SalesLineDelete table the SO may have many lines associated to it. The InventTransID (Lot ID) is the unique identifier for the line within the SO that needs to be removed.
Once completed the user can remove the line from the SO using the normal sequence within AX.
No comments:
Post a Comment