I am seeking information on the process for manually inputting both opening stock quantity and cost simultaneously. Furthermore, I am looking for a method to separately input opening quantity and cost for each individual site or warehouse.
Entering costs before stock qty’s will create part transactions, but no GL transactions will be created because whatever the cost is, it will be multiplied by zero (the QOH). Then when qty’s are entered (via Qty adjustments), part transactions will be created (to maintain the QOH), and then GL transactions to increase the value of inventory.
It really doesn’t matter what order you do it in. If you did qty’s first, those part transactions would all be at a zero value, and thus no GL transactions created. The when the costs are entered, there will be part trans that create GL trans (as you now have non-zero values for qty and cost).
The reason code used during the later of the Qty Adj or Cost Adj, will dictate what GL account will be offset by the change n inventory value.
edit
Even though you said “manually”, I’d still suggest using DMT for the entries.
Depends on your costing method.
I always load the qty first, then import cost adjustments.
Thanks for the insight, however the DMT doesn’t give a template that i can use simultaneously for assigning costs to respective opening balances of Quantity.
They are two different “things” in Epicor. Even when entering the initial values manually through the Epicor windows, you will need to enter cost and quantities separately.
The two programs and DMT templates are called Cost Adjustment and Quantity Adjustment.
2 Likes
Neither does going through the UI on the client program. You can do them in either order. See my post above for what the order of transactions would be created and what effect they’d have.
The absolute, number one, most important thing to do before doing Cost or Qty adjustments (regardless of through DMT or the UI), is make sure the part’s UOM Class and IUM are correct.
Also, don’t think that you can upload all your part records, then clean up what shouldn’t have been uploaded later. I made the mistake of bringing all my parts over from our V8 system, with the idea of deleting the ones we didn’t need later. I then imported the costs (via DMT) from our old V8 system. That created part transactions for every part. And once a part transaction exists you can never delete that part record.