Crystal Report field help

[CharlieBrit]

Am newbie....
Am trying to modify some existing Crystal Reports. One is a sales history report (oehdrhst) and other is Sales History detail report (oelinhst). We are Progression 76400 SQL. The user needs to get the line item cost as it is posted to G\L (and also total order cost in the non-detail report). In OELINHST, there are 2 fields,total_cost and cost_amt. Total_cost seems pretty close to getting me the cost that it was posted to G\L. I don't believe there is a similar field in the OEHDRHST..Is there a way to tie in directly to the GLTRXHST table to get the actual cost an order was posted to GL? Or is there a better way of doing this?

 

[dgillz]

Cost_amt is the field you need. Are you saying this does not tie to the GLTRXHST amount?

What cost type are you using in IM Setup? Are you using Landed Costs?

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

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[CharlieBrit]

No.. Cost_amt in many cases does not tie to GLTRXHST. We found total_cost to be much closer (I think because cost_amt is set at time of order entry??). We are using std costs, no landed costs.

 

[dgillz]

In OE Setup, what is the value of the cost to use when posting flag? If this flag is L the the cost is determined at OE time.

Are you using kit or feature items?

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

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[CharlieBrit]

Cost to use when posting is A - Actual
Yes, we use feature items

 

[dgillz]

On feature items, the cost is the rolled up cost of the selected features, regardless of the standard cost of the item. Without this, margins and inventory value would be hopelessly messed up.

The cost_amt is the amount that gets posted to the IMDISFIL_SQL table, and subsequently to the GL if you post from subledger.

You should read this cost, not the GL, as there is no guarantee that anyone actually posted from subledger. Also if the "post cost of goods sold" flag is not checked in OE Setup, the IMDISFIL_SQL records are not even created.

Link OELINHST to IMDISFIL by id_no to create this report.

If you find something that does not match between these 2 tables, then post again and we'll keep digging into it.

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

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[brutus6294]

Have a similar question. I'm trying to report header info off OEHDRHST. I think I want to use oehdrhst.tot_cost for the cost. However I need to multiply tot_cost by currency factor for EUR customers. To tie to GL (when I look at GL numbers), some orders look like I want to multiply by curr_trx_rate, others by orig_trx_rate. How do I get tot_cost at header level to tie to costs in GL? If IMDISFIL is my answer, please elaborate on how to tie it into Crystal and OEHDRHST. Thanks

 

[dgillz]

Link OELINHST to IMDISFIL by id_no to create this report."

You cannot do this by OEHDRHST as each line item could have a different cost of goods sold account, as determined by Product Category/Location maintenance in OE (Progression) or System/ Distribution/ Order Entry/ Product Category/loc account if using Macola ES.

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

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[brutus6294]

Thanks dgillz.
Any thoughts on why I am seeing the odd behavior, with sometimes multiplying by curr_trx_rate will tie to GL numbers, other times orig_tax_rate will tie?

 

[brutus6294]

dgillz,
Hope you don't mind another question. If I were to run a report using OELINHST (would be a general sales line item history report with cost as just another field), and wanted to use IMDISFIL to get the GL costs, how would I link in IMDISFIL, thru a subreport, or view, or just adding in the table and linking on id_no (would need to get only the Cost of Goods Sold entries I imagine)? Just curious on how you would go about that.