x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 521 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
4
replies
General Discussion
1k
topics
2k
replies
Bliper

'Revalue Stock Item'. SYSNominalAuditTrail - Stock Item relation.

SUGGESTED
Posted By

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.

Parents
  • 0

    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]

Reply
  • 0

    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]

Children

*Community Hub is the new name for Sage City