Hi All.
I can see 2 entries are created on the 'SYSNominalAuditTrail' table after I revalue a stock item.
How can I determine the stock item this relates to?
Many thanks for any help.
In RepDes Join Editor:
[StockItems]
INNER JOIN [TransactionHistories] ON StockItems.ItemID = TransactionHistories.ItemID
LEFT OUTER JOIN / INNER JOIN [SYSNominalAuditTrails] ON TransactionHistories.PostingURN = SYSNominalAuditTrails.UniqueReferenceNumber
STATIC JOIN [SYSCompanies]
Thank you Geoff.
*Community Hub is the new name for Sage City