Hi All,
When the Item Price is set up, D365 sees the Item Price as Standard Cost, correct? When you post the PO, if the actual price in the PO is higher than the Standard Cost, D365 will debit the variance GL account. For example, if the Standard Cost for item A is $100, The actual price in the PO is $105. Then, D365 will post $5 to the Variance account.
Inventory $100
Variance $5
AP $105.
If I were to run a variance report, I would run a Trial Balance using the GL Variance account? If I want to track the variance per item, how do I do that? I'm thinking to add a segment called ITEM in the Account Structure. So that when the transaction is posted, I have the item data.. Then I can run a trial balance filter variance GL account and Item dimension. Please suggest if there is a better solution. I can't seem to find a PPV Report out of the box. Thanks so much!
