I do have a task to create a report containing informaction from GeneralJournalAccountEntry and InventTrans and InventSettlement, I do use InventTransPosting and InventTransOrigin for relation.
Is there a way to identify what itemId is linked to Mainaccount or GeneralJournalAccountEntry.recid? RIght now I have a ton of duplicates for every row number that is related to inventtrans. The worste it goes when I want to get InvenSettlement data where I can have 300 rows to one inventtransId.
The AccounClosing is the worst since one closingId is like 500 GeneralJournalAccountEntry rows and with like 100k inventtrans it goes insane when creating a view with it.