Line and Header comments 1

[ultrav]

Progression SQL 7.6.3 Crystal 8.5

I am writing a crystal report about order history. I cannot find where the line and order header comments are stored. I used OECMTHST but the comments only went up to 2002 for me.

HELP!

Celeste

 

[dgillz]

For open orders, both the line and header comments are in OELINCMT_SQL. The two are distinguished by the field cmt_type and this is an "L" for line comments and an "H" for header comments.

After the invoice is posted, these records move to the OECMTHST_SQL table with essentially the same table structure.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

 

[ultrav]

I only have "I"(I assume invoice type comments) and "L" type showing and they only go up to 2002. If I go into recent order history I see the header comments and line comments. Why would they not be in that file and what can I do about it?

We have Starship - would this affect anything? They write to header comments - that is why I mention it.

I am really confused!

 

[dgillz]

What file are you looking in?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

 

[ultrav]

OECMTHST_SQL - I ran a crystal showing all records and I also ran a SQL query in Enterprise Manager looking for H type comments - came up empty

Celeste

 

[dgillz]

I stand corrected. My header comments are also type L, but the line_seq_no is zero.

I do not have any type I records.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

 

[ultrav]

Does anyone know why I would not be able to see any comments past 2002? I viewed the comments in order number order and the highest order numbers were from 2002. When I view order history I can see comments in recent orders.

Celeste

 

[kscheeler]

You said earlier that you can go into recent order history see the header comments and line comments. If it's order history, it's reading the OECMTHST_SQL table. If they are open orders, it's reading the OELINCMT_SQL table. In either case, for the recent order history you see in Macola with comments, you should be able to browse the table and see the same information externally.

It looks like you are missing a batch of comments inbetween.


Kevin Scheeler

 

[ultrav]

I think I found out what my issue is. I was linking to order number but it looks like I should link to real_ord_no. I think ord_no may represent invoice number - because our invoice numbers are running about what the order numbers were in 2002. That explains why I was seeing the info in Macola and not in the table.

Celeste

 

[kscheeler]

You're correct. The ord_no in the OECMTHST_SQL table represents the invoice number though it's formatted as a character field vs. numeric as the invoice number usually is. The real_ord_no field is the original order number.

Kevin Scheeler