Landed Cost

[AKPolarBear]

I am trying to create a Crystal report that shows the landed cost for each inventory item. It will need to show the items purchase cost and all of the landed cost elements that are added to it so that the total landed cost is calculated.

In using the POLNDCST file, I find the information I need but matching it to the item in the IMINVLOC file is proving to be difficult as no joins can be created between the two.

Parsing the data and trying to match has not worked.

I thought a SQL View might work but don't see how to join the two fields together to create a single landed cost code that then could be matched to the item in the above files. I need to return the other information in that data file.

Right now I have a subreport that partially does the job but it is cumbersome at best.

Any suggestions?

 

[AKPolarBear]

Okay, maybe a simpler question.

How do I use the data in the POLNDCST table in Crystal?

 

[NEmacGuy]

CREATE VIEW dbo.zzz_custom_landed_cost_file
AS
SELECT (landed_cost_type + landed_cost_cd) AS Join_CD, dbo.POLNDCST_SQL.*
FROM dbo.POLNDCST_SQL

Hit the same issue, used following view then I could like view to the landed cost code in the item master.

 

[AKPolarBear]

I finally figured the view out shortly after my first post. This is what I used:

CREATE VIEW dbo.LandedCostDescrip
AS
SELECT landed_cost_type + landed_cost_cd AS lccode, landed_cost_desc, effective_frm_dt, effective_thru_dt, calc_meth, amt_pct
FROM dbo.POLNDCST_SQL

Which should be the same as what you suggested. By itself, I can correctly see the data.

Now the problem is that I can get it to return all the LC elements for an item and its description, but only the first one will return the cost. All the others return zero.