[Amber Bell]

I have a client that is starting to use Landed Cost. I have been looking for the right table to return the Landed Cost items that have been part of a receiving transaction (Match is checked) but have not been matched.

The “Received/Not Invoiced” Report pulls this data and includes under the PO that was received. I just want the Landed Cost items vs. the regular inventory. I opened the “Received/Not Invoiced Report” using Report Writer to see the table and it is based on a “Temp” table.

Anyone have any ideas?

——————————
Amber Bell
Training Dynamo LLC
Email: amber@trainingdynamo.com
Website: http://www.trainingdynamo.com
Twitter: @trainingdynamo
——————————

[Joseph C. Markovich]

Hi Amber-

I believe it is POP30700? In my testing of revising our RNI report in SSRS for us implementing landed cost, that is the table I found that was storing the status and details of all the unmatched landed costs.

I hope this helps.

Thanks.
-Joe

——————————
Joseph Markovich
IT Manager
Okaya Electric America
Valparaiso IN
——————————
——————————————-

[Amber Bell]

Hi Joe,

Thank you for the info. After I posted and before I saw your reply, I found 2 tables related to landed cost by using the “Table Finder” from SmartList Builder.

The POP10700 shows the landed cost items from unposted Receiving transactions
The POP30700 shows the landed cost items from posted Receiving transactions.

The issue I am running into is calculating the “RNI” (Received Not Invoiced) quantity for those Landed Cost items. I added all columns and none seem to update when I match them to a Landed Cost Invoice.

If anyone has any suggestions, please let me know!! I am thinking I might be able to calculate if I connect the Receivings Line Item table but it might be tricky. If I come up with a solution, I will update this post.

——————————
Amber Bell
Training Dynamo LLC
Email: amber@trainingdynamo.com
Website: http://www.trainingdynamo.com
Twitter: @trainingdynamo
——————————
——————————————-