Sage 200 UKI

Welcome to the Sage 200 Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

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

SUGGESTED

Posted By Bliper over 2 years ago

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 Geoff Turner over 2 years ago

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]
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Bliper over 2 years ago in reply to Geoff Turner

SUGGESTED

Thank you Geoff.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Reply

0 Bliper over 2 years ago in reply to Geoff Turner

SUGGESTED

Thank you Geoff.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Children

No Data

Sage 200 UKI

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

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING