ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> UGH ... been using wrong part type for 21 years.
http://www.istechforum.com/YaBB.pl?num=1544649607

Message started by Laura Oliver on 12/12/18 at 14:20:07

Title: UGH ... been using wrong part type for 21 years.
Post by Laura Oliver on 12/12/18 at 14:20:07

part type R versus part type N

Paper towels, copy paper, screw drivers, inserts, brooms ….ANYTHING we bought I put as a part TYPE "R" because I thought purchased part meant purchased part. However after reading the forum I think I should have been using part TYPE "R" for only raw material or items being sold to a customer.

I literally have thousands and thousands of part number that are type R that I think should be part type N. In my quest to get item classes to put the GL on a PO i discovered this and now want to change all those part numbers from item type R to item type N. What are the ramifications if I just manually changed all the R types to type to N thru IN-B?

I am hoping changing these bought parts to an N Type will allow item classes to get on the Purchase Order rather that my WIP inventory account. Maybe the fact that the part type is an R does not allow the item class to override the default.

Thanks
Laura

lmk223a wrote:

We use this IN-F report to reconcile our general ledger to inventory: Raw material (type R) and Finished goods (type A & F), and usually do not have much unexplainable variation.
If you change classes on part numbers this would explain some general ledger variation, as the dollar investment changed from one class to another. An adjusting journal entry would need to be performed to move the dollars in the general ledger.

Title: Re: UGH ... been using wrong part type for 21 year
Post by Laura Oliver on 12/12/18 at 16:18:58

I created a few new part numbers with TYPE N, and made sure the item classes were correct in SM-D. Then I created POs and received them in and paid them and the GL account from the item class is still not overriding the default account from AD-A.

Since using a Part type N didnt help the item class override the default account I will just leave the shop supplies, and other stuff we buy for our on consumption as a type R part.

If anyone has any idea what my problem could be I would appreciate hearing any suggestions.

Thanks
Laur a

Title: Re: UGH ... been using wrong part type for 21 year
Post by Lynn_Pantic on 12/13/18 at 14:09:42

Do you have the AD-A setting to use Item Class for GL Postings turned on? You said they GL posting was going to WIP. You should NOT be putting any Work Order number on these PO lines for supplies.

Also, the GL Posting is based on both the Item class of the line item being purchased and the Warehouse Location associated with the order so you need to populate the SM-C Item Classes per warehouse location.