Sage 500

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

Comment

Posted By JRoberts over 15 years ago

How are comments stored in MAS500? I am trying to added Sales Order Header comments to to Packing List and can not find the table that holds these comments.

Any advice is greatly appreciated.

Regards,

Justin Roberts

DFeller over 15 years ago

Are these free-form comments or comment codes? They are stored in the same tables, but would be referenced differently.

Dawn
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
LouDavis over 15 years ago

The short header comment (50 characters) that you type in on the Enter Sales order form is saved to tsoSalesOrder. The extended comments that can be entered by selecting the Comment button are saved to the table tciExtCmntUsed and tciExtCmntUsedDetl depending if you are using a pre-defined comment or a freeform comment. The DocOwnerKey in tciExtCmntUsed is the SOKey related to your sales order. The schema browser has more information on these tables.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Sage 500

Comment

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING