Welcome, Guest. Please Login.
05/10/25 at 22:43:57
News:
Home Help Search Login


Pages: 1
Send Topic Print
It is a problem to have a location w/o a code? (Read 3838 times)
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
It is a problem to have a location w/o a code?
02/24/16 at 08:51:51
 
Our default locations for both companies have names, but no codes. Is that a problem?  I am wondering since in certain circumstances we have problems transferring certain types of parts to the default location, or even tagging multiple locations when the first one we select is the default location. These were not issues we had in the old version of Evo we were running, and the locations were the same.
 
Just trying to eliminate things in determining a cause.
 
Thanks.
 
Val
 
Back to top
 
 

Val Feehan
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: It is a problem to have a location w/o a code?
Reply #1 - 02/24/16 at 08:55:09
 
We have STRONGLY recommended for many years that you do NOT use a blank location code because of issues with binary zeroes.  I suspect that is your problem.  Run UT-K-I on the BKICLOC file and then UT-K-E to change the blank location code to a named location.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: It is a problem to have a location w/o a code?
Reply #2 - 02/24/16 at 10:45:27
 
Thanks (as I suspected.  Way back in time our default locations used to be blank names, and I passed along this no blank "rule" at that time and the names were added, but no codes. Not sure why they didn't put in a code as there is a code for all other locations).  Will schedule downtime for that. We've got about 45,000 records in BKICLOC in one company and around 19,000 in the other, so this will take a while to run on each.
 
Kind regards,
 
Val
Back to top
 
 

Val Feehan
  IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: It is a problem to have a location w/o a code?
Reply #3 - 02/24/16 at 11:14:55
 
Another question:  I need to run manual backups on the tables affected by this fix. What are all the tables this touches?  If I run int in our od company, it says it will be processing 23 files.....what are they, and are there more in the 2015 version?  I checked in the help, nothinglisted in there.  
 
Thanks,
 
Val
Back to top
 
 

Val Feehan
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: It is a problem to have a location w/o a code?
Reply #4 - 02/24/16 at 11:49:04
 
It is updating a bunch of files, I would suggest making a complete backup.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: It is a problem to have a location w/o a code?
Reply #5 - 02/24/16 at 15:41:07
 
UT-K-E is Consolidate Inventory Locations, that tells me to tag all the ones I want to keep, which I did, then clicked GO.  It goes to the next screen which gives me the "Warning! Danger Will Robinson" messages and asks me to confirm that I am about to delete the ,blank, locations, do I want to Continue?  Yes.  Then I am to enter a New master location code to use, and a box to enter "Use the Item Class GLs of this EXISTING Location for the Item Class GLS of the NEW location.  Not sure what I put in there or where I find what it is currently?  None of the item classes I see are just "inventory".  Should I just be letting this use a default for inventory.
 
Also, while we have a blank code for the default location, we do have a name for the location, so Walter will have to go back into IN-L-B and put in his location Name he was using before..?  
 
Also, does Holly have to do anything on the GL side after this?
 
Val
Back to top
 
 

Val Feehan
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: It is a problem to have a location w/o a code?
Reply #6 - 02/24/16 at 15:52:52
 
The Item Class of EXISTING Location should be the blank, that is the GL mappings you want the new default location to retain.  And yes, you will need to go back to IN-L-B to enter the name when it is all done.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: It is a problem to have a location w/o a code?
Reply #7 - 11/07/18 at 13:05:45
 
I still can not get SM-C item classes to put the GL Account on the Purchase Order.   We have to go into EVO and hand add the GL-Account.    
 
 
Each inventory item has an item class.  (confirmed in IN-B)  
Each Item class has a GL account assigned in SM-C.      I do not use locations so we have blank locations.   Could blank locations be preventing the  item class from putting a GL account on the PO?
 
Thanks
,
Laura
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: It is a problem to have a location w/o a code?
Reply #8 - 11/07/18 at 14:59:19
 
Or maybe the reason is we are using part type R  for things like office supplies and plant supplies and we should be using part type N.
 
 
Quote from Lynn Pantic on 09/19/06 at 06:33:21:
The only GL Account that really matters for expense items such as supplies is the first one.  They are going to be type N (Non-Inventory) items expensed at the time of receipt and never sold or used in work orders so the other accounts on the Item Class screen do not matter.

Items that are part of what are being produced are NOT expenses. they should be going to the Raw Material Inventory Asset account.  The COGS account for components is the account what will be posted to when adjustments are made during physical count and the Sales accounts would be hit if you ever sold a component (as if for a spare part or something)

 
Quote from 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!

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: It is a problem to have a location w/o a code?
Reply #9 - 11/08/18 at 14:19:50
 
Quote from Lynn_Pantic on 01/16/12 at 15:16:33:
GL Posting is based on both the Item Class and hte Location of the order.  You need the SM-C GL entry for the Class/Location combination that matches the orders.

 
We do not use location.  Is that why we don't get posting to the General Ledger?  We have to go EVO and hand enter GL accounts.  If we do not hand enter GL Accounts the PO will have the WO WIP Inventory  account.  
iI would think that if all locations are blank... then blank matches blank, but maybe not
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: It is a problem to have a location w/o a code?
Reply #10 - 11/09/18 at 08:47:48
 
You ARE using Location, that is the way the program works.  Your Location code may be blank but it is still what is being used to drive the GL posting.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: It is a problem to have a location w/o a code?
Reply #11 - 11/09/18 at 10:47:52
 
Thanks Lynn,
That is what I always thought.   I guess I am grasping at straws trying to figure why the item class are not putting the GL on the purchase Order
Laura
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
Pages: 1
Send Topic Print