ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> It is a problem to have a location w/o a code?
http://www.istechforum.com/YaBB.pl?num=1456329111

Message started by gtladmin on 02/24/16 at 08:51:51

Title: It is a problem to have a location w/o a code?
Post by gtladmin on 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

Title: Re: It is a problem to have a location w/o a code?
Post by Lynn_Pantic on 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.

Title: Re: It is a problem to have a location w/o a code?
Post by gtladmin on 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

Title: Re: It is a problem to have a location w/o a code?
Post by gtladmin on 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

Title: Re: It is a problem to have a location w/o a code?
Post by Lynn_Pantic on 02/24/16 at 11:49:04

It is updating a bunch of files, I would suggest making a complete backup.

Title: Re: It is a problem to have a location w/o a code?
Post by gtladmin on 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

Title: Re: It is a problem to have a location w/o a code?
Post by Lynn_Pantic on 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.

Title: Re: It is a problem to have a location w/o a code?
Post by Laura Oliver on 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

Title: Re: It is a problem to have a location w/o a code?
Post by Laura Oliver on 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.

Lynn Pantic wrote:

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)

cathyh wrote:

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!

Title: Re: It is a problem to have a location w/o a code?
Post by Laura Oliver on 11/08/18 at 14:19:50

Lynn_Pantic wrote:

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

Title: Re: It is a problem to have a location w/o a code?
Post by Lynn_Pantic on 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.

Title: Re: It is a problem to have a location w/o a code?
Post by Laura Oliver on 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