Share
Report
1,325Total landed cost is a column that is available for output on the Receivings Line Items Smartlist report. When the receiving “Type” specified in Receivings Transaction Entry is Shipment/Invoice the Total Landed Cost column on the Receivings Line Items Smartlist report is populated with the actual Total Landed Cost on each product line on the P.O. receipt. When the receiving type is Shipment the preliminary landed costs as defined in the landed cost maintenance form are populated on each product line on the the Smartlist report. However, the landed costs as apportioned to items during invoice matching are not populated for each associated product line on the Smartlist Report for the invoices that were matched to the shipment. All product lines for the matched invoice transaction on the Smartlist report have a zero value in the total landed cost column. There are rows for the full landed cost across all items on the Smartlist report for the matched invoices. What we need is to see on the report is how those landed costs are apportioned to the individual product lines for the matched invoice as they are when the receiving type is Shipment/Invoice.
It has been suggested by one of my colleagues that the reason why the total landed cost is not on the Smartlist report for each product line on the matched invoice transactions is that we may not have something setup or configured properly in the purchasing module to enable the population of this column under this circumstance. I’m hoping that someone can confirm or disprove this suggestion.
It would also be helpful to know which tables are used on the Receivings Line Items Smartlist report. My understanding is that the tables listed below are used on form “Match Shipments to Invoice Inquiry Zoom”. This form does include the landed cost apportionment data at the product line level. It has been suggested that we create the needed report using SQL Reporting Services over these tables. However, before we proceed with that solution I would like to know if as described above there is a setup or configuration option that we don’t have properly set to enable inclusion of the needed data on the Receivings Line Items Smartlist report.
Here are the tables used with the Match Shipments to Invoice Inquiry Zoom form.
GL00100 – Distribution Account Master
IV00103 – Item Vendor Master
POP10500 – Purchasing Receipt Line Quantities
POP10310 – Purchasing Receipt Line
POP30310 – Purchasing Receipt Line History
POP10600 – Purchasing Shipment Invoice Apply
Thank you.
*This post is locked for comments
All responses (
Answers (
