I'm trying to figure out how GP calculated the journal entry for the PO receipt of many inventory items. The debit to Inventory is significantly less than the calculated amount (qty x std cost). Is there a report or query I can run to find the calculation behind the journal entry?
Screen print 1: line item details of PO receipt transaction. Shows the PO price and quantity received. Total receipt value is $40,923
Screen Print 2: Receipt Distribution entry. The credit to A/P is correct at $40,923. The inventory debit is $13,635 but the std cost of these parts is $121,428 (see screen print 3). The PPV should be $80,505 but it is only calculating $27,288.
Screen Print 3: spreadsheet listing all the parts. Purchase Price, std cost (has not changed during the period) and extended amounts.
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156