Description |
When undoing a cycle count in work order screen, cost adjustment transaction is not undoing correctly.
BEGIN TRANSACTION
GO
EXEC sp_executesql N'uspMFUnpostCycleCount @strXML'
,N'@strXML nvarchar(73)'
,@strXML = N'2561'
GO
SELECT *
FROM tblGLDetail
WHERE strTransactionId = 'WO-256'
AND ysnIsUnposted = 0
AND strTransactionType = 'Cost Adjustment'
SELECT *
FROM tblICInventoryTransaction
WHERE strTransactionId = 'WO-256'
AND ysnIsUnposted = 0
AND intTransactionTypeId = 26
GO
ROLLBACK TRANSACTION
Passing Amount with negative sign.
!pastedImage_d109850_0.png! Not reflected correctly in GL Detail
!pastedImage_d109850_1.png! Not reflected in IC table.
!pastedImage_d109850_2.png!
Steps:
1. Go to MFG--> Work order management and reopen any closed work order
2. Go to Cycle count tab and unpost the cycle count adjustment
3. Go to General Ledger --> GL Detail screen --> Transactions Tab
4. Apply filter Transaction id is equal to
Expectation: Application should reverse all GL transactions.
|