ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> N parts to R parts
http://www.istechforum.com/YaBB.pl?num=1126107859

Message started by Lenette on 09/07/05 at 07:44:19

Title: N parts to R parts
Post by Lenette on 09/07/05 at 07:44:19

We purchased items under our "prodsupply" part number and have decided to make them a R part type. (of course this was done over several months)

What all do I need to do to accurately move the inventory?

Title: Re: N parts to R parts
Post by David Waldmann on 09/08/05 at 04:22:52

I'm assuming that you're going to give them a new, unique part number.

I would do it through IN-C. The only complication I can think of is that the Average Cost on the original part number may not accurately reflect the real cost (if you have a bunch of different parts with the same part number). In that case, first go into IN-K and change the Average Cost. Go back after you're done and change it to what the new Average should be without the parts you just took out.

Title: Re: N parts to R parts
Post by Lenette on 09/08/05 at 07:06:21

Yes, each will be given it's own unique part number. The original part is a N part.

Adding via IN-C would be only one step (I assume). Wouldn't I need to transfer the the cost from our Production Supply & Expense GL account into Raw Inventory? What about parts used in the interim? Etc.

Title: Re: N parts to R parts
Post by lmk223a on 09/08/05 at 08:09:27

If you are adding inventory through IN-C, the General Ledger transaction should be a plus$ to "R" type inventory account and a minus $ to your Production Supply Expense account, however, you will probably need to edit the GL account for these IN-C transactions to your Production Supply Expense account in GL-P, because DBA has a default account for all transactions processed via IN-C, which is usually to Cost of Goods Sold.

Title: Re: N parts to R parts
Post by timgolds on 02/21/06 at 13:39:10

Can you change the default GL account when using IN-C? We don't want it going to cost of goods sold but to another account of our choosing. Like to an adjustments clearing account or the "other transactions" account.

Title: Re: N parts to R parts
Post by cathyh on 02/21/06 at 14:16:06

The GL account that is expensed ( as well as the asset account that is debited) is controlled by the class code for the item. The item type doesn't matter. An N type can be debited to an asset account when purchased if it has that in its class code. This can create havoc if you are comparing your GL asset total to your Inventory value which doesn't give N types any value.
When you make your new part number, give it a new class code or temporarily change the class code you want to use -- change the COGS account to the expense account you have been using for the N type. When you do an adjustment to the new part, DBA will credit the expense account and debit your RM asset account. Then change the COGS for the class code back to what it should be for RM.

PS YOu don't need to do anything to the N type since DBA doesn't keep track of how many there are or what the average cost is. All N type parts have presumably been expensed and don't count and so you don't count them either!