GP 2020 (18.3.1173)
Manufacturing (18.3.1173)
Windows Server 2012
SQL Express (15.0.2000.5)
I've finished a fresh install of GP 2020 with Manufacturing and have found that no G/L transactions are created for Inventory Adjustments (which will be used by the manufacturing module). The Item Transaction Inquiry shows that the posting to the Inv subledger worked fine.
Master Posting and Batch recovery remain empty.
Posting setup for Inventory/Transaction Entry looks OK (Post to General Ledger on, Post Through off, Allow Transaction Posting off, Include Multi Currency on.
I've created GP SQL Logs captured during the posting process (initiated by an inventory batch post). It shows the error:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PKIV10000'. Cannot insert duplicate key in object 'dbo.IV10000'. The duplicate key value is (sa , XIV_Trxent , 1, 00000000000000165).*/
So it appears there is a failure but it doesn't name G/L Transactions Work as in error, names the inv batch header.
I haven't seen any information across multiple blogs where this is occuring in other instances, so it must be unique to my configuration and settings, but I can't for the life of me figure out what.
