I’m hoping for someone to help with best practice in this situation
Background: We are a small company. Most of our work is on a fixed-price one-off project basis. We buy most of the parts for our projects as Non-Inventory Items and point the COGS/Expense account for these items to our Direct Material Income Statement account. We satisfy the Matching Principle by adjusting our Revenue using the Earned Value methodology.
Once the project is designed, our engineers issue a BOM and our purchasing person buys most of the Non-Inventory Items and the costs go directly to the Income Statement.
HOWEVER: There are a few parts that are used on almost every project and therefore we buy these parts as inventory items that point to an Inventory account on our Balance Sheet with no project assignment. Let’s use an example of a standard box. We buy 1000 boxes at a time to inventory.
Once the project BOM comes out, our Purchaser wants to transfer, for example, 100 boxes
FROM: Our Inventory account on our Balance Sheet
TO: Our Direct Material account on our Income Statement
And therein lies the question that I cannot find a SuiteAnswer or Community Answer to
One would think that the logical choice is TRANSACTIONS>INVENTORY>ADJUST INVENTORY
- Choose Subsidiary
- Choose the Customer/Project that the Inventory Items will be charged to
- As the ADJUSTMENT ACCOUNT use the Direct Material Account on our Income Statement
- Enter the date/Memo/Department/Class/etc
- In the Item Submenu, chose the Inventory Item for the box
- In the ADJUST QTY BY field enter <100>
- The other fields populate automatically
- Click SAVE
- The GL Impact for the Inventory Adjustment seems to indicate
- DB Direct Material Account on Income Statement
- CR Inventory Account on Balance Sheet
- This is good
- But the G/L impact also displays the Project in the Name field of both the DB & CR
- That may not be good
- The Inventory Count of the boxes is reduced by 100. This is good
But here comes the problems
11. Unfortunately, on the Project-side, the results are confusing
- Go to the Project, the PROJECT INFORMATION>PROJECT EXPENSES subtask displays the Inventory Adjustment as a negative cost to the project
- Clicking to the P&L submenu, the Inventory Adjustment shows as a Cost also, but it is displayed on the Asset Line. We thought the Inventory Adjustment removed our boxes from the Asset side of the Balance Sheet?
- If I run the standard Project Report named Project Cost Budget vs. Actual, the Inventory Adjustment does not appear at all under the Project.
I apologize for the length of this question. Hopefully, I have provided enough information to help someone explain what we are doing wrong.
Thanks