Sage 100

Welcome to the Sage 100 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.

Insert Cancel Reason Description in Open Sales Order Report

Posted By batteryman over 5 years ago

I need the Cancel Reason Description to appear on Open S/O report. I added using Database Expert I added SO_CancelReasonCode database. Put the field into the repport. Not the report ONLY displays S/O that are = HOLD and shows the Cancel Reason. If I remove the CancelReasonDescr field all open PO's show on the report. Open/Hold, etc.

What am I missing?

Top Replies

BShockley over 5 years ago +2

Did you add a table? If so, perhaps you should change the join type to left-outer, instead of using an inner join.

0 BShockley over 5 years ago

Did you add a table? If so, perhaps you should change the join type to left-outer, instead of using an inner join.
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel
0 batteryman over 5 years ago in reply to BShockley

That did it. Thank you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Insert Cancel Reason Description in Open Sales Order Report

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING