[Kyle Malone, CPA]

If I’m looking @ a Sales Invoice & the cost is $100/each (FIFO), what is the best report to use to back into that cost?

The request is to be able to see all of the transaction detail behind those goods sold that provide verification on the current cost, would also need to include landed cost accruals & invoices.

If there isn’t a report to tie directly into a sales invoice, is there maybe a report somewhere that shows the running cost @ any point in time?  Would the HIVTB be the closest thing?

??

——————————
Kyle Malone, CPA
GP Admin – CGB Enterprises, Inc.
Lead Consultant/Blogger – http://ALaCarteGP.com
Chapter Leader – Louisiana (New Orleans)
——————————

[Jo deRuiter]

Hey ?

I have not tested this theory, but the SOP Line item tables – SOP30300 for history tables – holds on the the Unit Cost by Inventory Item.  If that cost amount changes (I don’t think it does), you can always back into the unit cost by using the field OREXTCST divided by the QTY.

Of course, you’ll want to look at the SOP10200 as well, if they have not moved to history

Hope this helps!

——————————
Kindest Regards,
Jo deRuiter , MCP, DCP
“That GP Red Head”
AISLING DYNAMICS CONSULTING, LLC
WEBSITE: https://aislingdynamics.com/
BLOG: https://community.dynamics.com/gp/b/gplife
GPUG Academy Instructor
Dynamics GP Credentialing Council-Vice Chair
770-906-4504 (Cell)
——————————
——————————————-