Welcome, Guest. Please Login.
05/10/25 at 16:39:03
News:
Home Help Search Login


Pages: 1
Send Topic Print
UGH ... been using wrong part type for 21 years. (Read 1048 times)
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
UGH ... been using wrong part type for 21 years.
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  
 
 
 
Quote from lmk223a on 08/16/07 at 06:05:51:

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.

Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: UGH ... been using wrong part type for 21 year
Reply #1 - 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
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: UGH ... been using wrong part type for 21 year
Reply #2 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print