Create dataset with physical inventory per item and variant

(0) Share

Report

Posted on by Knofan

Hey Guys

Im trying to create a dataset to use with PowerBI that contains all variants for my items and what stock level they have. So far i have not been able to figure out what table contains this information. Need advice.

Stay safe and healthy!

Regards

Håkan

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

JAngle 119 on at

Like (0)

Report

RE: Create dataset with physical inventory per item and variant

There isn’t one table. In Power BI you could calculate the result using the item variant table and item ledger entry table. Failing that you could have a query devised that gives you the results as you have requested. That would require development though

Was this reply helpful? Yes No
Knofan 49 on at

Like (0)

Report

RE: Create dataset with physical inventory per item and variant

I will try and use the item ledger and see if i can get it to work.

Thank you Josh

Was this reply helpful? Yes No