This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
If u are ordering into store the glcode will come from the inventory item. If it does not come in it is likely the item does not have the relevant gl code attached. Unless u have exposed the glcode on the inventory screen u will have to check at the database level.
If its a direct issue item the glcode will come from the work order. Check its populated there.
Peter
Sent from Samsung Mobile
dennis_belandres@denso-diam.com wrote:
Is there a place to set GLDEBITACCT information in the item level to
autofill the entry when adding a new line item through Maximo's purchase
requisition application? There are times this gets filled automatically
and there are time when not.
Any suggestions would be greatly appreciated.
Environment:
2005 SQL server
Maximo 7.1.1.5
Websphere 6.1
Regards,
Dennis
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.
To elaborate (a lot!), the recommended setup is
1. On your Locations, specify the GL Account EXCEPT for the portion that is specific to the item being bought (what the accountants usually call the account code). For the item component, put question marks
2. If you have asset-specific components in the GL string, then you will need to specify the asset-specific component of the GL string in the GL Account on the equipment record. This will over-ride anything that’s on the Location record.
3. In the Item application, set up your Commodity Groups
4. In the Chart of Accounts, go to Select Action / Resource Codes. For each commodity group set up in Step #3, specify the account (item-specific) portion of the GL string
5. For each item, specify a commodity group. The item will inherit the account code you specified in Step #4.
6. Create a work order (recommended) to carry the costs. You can do it without a work order, but you won’t be able to see the costs in Maximo – only on a report.
7. Create your PR line. Pick the item from the item list. Pick your work order from the work order list. You will see that the GL Debit Account is fully specified!
Example:
1. GL Structure = ????-?????-???. 1st component is Department, 2nd Component is Equipment type, 3rd Component is item type
2. Create location 101. For the GL Account, specify MTCE-?????-???
3. Create asset record for a conveyor, numbered CONV-100. Attach it to location 101. On the Asset record, specify ????-CONVY-???
4. In the Item application, set up a Commodity Group called BEARING.
5. In Chart of Accounts / Select Action / Resource Codes, add a new line, pick the BEARING commodity group, and specify ????-?????-123 (the account code for bearings)
6. In the Item Master, create Item 400 and specify Commodity Group BEARING. The item will inherit the commodity group’s GL account (you can’t see it on the screen, but if you look at the table level, it’s there.)
Results:
1. When the work order 45678 is created using CONV-100 as the asset, the work order’s GL account will automatically be set to MTCE-CONVY-???.
2. When the PR line is created, with Item 400 charged to work order 45678, the GL Debit Account will automatically be set to MTCE-CONVY-123.
Note: this setup is for direct issue items only – inventory stuff is different (the Storeroom setup is critical for the inventory ordering).
You can vary this procedure slightly, but this is the recommended way to do it. If you need me to explain further, just let me know. FYI: all of this is outlined in the Finance Manager’s Guide. Getting to know that document would instantly make you the “Maximo wizard” :)
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Peter Camarsh
Sent: October-06-11 2:41 PM
To: maximo@yahoogroups.com
Subject: Re: [MAXIMO List] Prline GLDEBITACCT?
If u are ordering into store the glcode will come from the inventory item. If it does not come in it is likely the item does not have the relevant gl code attached. Unless u have exposed the glcode on the inventory screen u will have to check at the database level.
If its a direct issue item the glcode will come from the work order. Check its populated there.
Peter
Sent from Samsung Mobile
dennis_belandres@denso-diam.com <mailto:dennis_belandres%40denso-diam.com> wrote:
Is there a place to set GLDEBITACCT information in the item level to
autofill the entry when adding a new line item through Maximo's purchase
requisition application? There are times this gets filled automatically
and there are time when not.
Any suggestions would be greatly appreciated.
Environment:
2005 SQL server
Maximo 7.1.1.5
Websphere 6.1
Regards,
Dennis
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.
Hi,
Shannon is right about the set up and the financial manager manual.
But we just put the entie cost center and account code in our locations since accounting just wants to track costs to those production line accounts.
You can make it simple or complex.
Depends on your process.
Dave Bone
--- In MAXIMO@yahoogroups.com, "Shannon Rotz" <shannonrotz@...> wrote:
>
> To elaborate (a lot!), the recommended setup is
>
>
>
> 1. On your Locations, specify the GL Account EXCEPT for the portion that is specific to the item being bought (what the accountants usually call the account code). For the item component, put question marks
>
> 2. If you have asset-specific components in the GL string, then you will need to specify the asset-specific component of the GL string in the GL Account on the equipment record. This will over-ride anything thatâs on the Location record.
>
> 3. In the Item application, set up your Commodity Groups
>
> 4. In the Chart of Accounts, go to Select Action / Resource Codes. For each commodity group set up in Step #3, specify the account (item-specific) portion of the GL string
>
> 5. For each item, specify a commodity group. The item will inherit the account code you specified in Step #4.
>
> 6. Create a work order (recommended) to carry the costs. You can do it without a work order, but you wonât be able to see the costs in Maximo â" only on a report.
>
> 7. Create your PR line. Pick the item from the item list. Pick your work order from the work order list. You will see that the GL Debit Account is fully specified!
>
>
>
> Example:
>
> 1. GL Structure = ????-?????-???. 1st component is Department, 2nd Component is Equipment type, 3rd Component is item type
>
> 2. Create location 101. For the GL Account, specify MTCE-?????-???
>
> 3. Create asset record for a conveyor, numbered CONV-100. Attach it to location 101. On the Asset record, specify ????-CONVY-???
>
> 4. In the Item application, set up a Commodity Group called BEARING.
>
> 5. In Chart of Accounts / Select Action / Resource Codes, add a new line, pick the BEARING commodity group, and specify ????-?????-123 (the account code for bearings)
>
> 6. In the Item Master, create Item 400 and specify Commodity Group BEARING. The item will inherit the commodity groupâs GL account (you canât see it on the screen, but if you look at the table level, itâs there.)
>
>
>
> Results:
>
> 1. When the work order 45678 is created using CONV-100 as the asset, the work orderâs GL account will automatically be set to MTCE-CONVY-???.
>
> 2. When the PR line is created, with Item 400 charged to work order 45678, the GL Debit Account will automatically be set to MTCE-CONVY-123.
>
>
>
> Note: this setup is for direct issue items only â" inventory stuff is different (the Storeroom setup is critical for the inventory ordering).
>
>
>
> You can vary this procedure slightly, but this is the recommended way to do it. If you need me to explain further, just let me know. FYI: all of this is outlined in the Finance Managerâs Guide. Getting to know that document would instantly make you the âMaximo wizardâ :)
>
>
>
>
>
>
>
> Shannon
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Peter Camarsh
> Sent: October-06-11 2:41 PM
> To: maximo@yahoogroups.com
> Subject: Re: [MAXIMO List] Prline GLDEBITACCT?
>
>
>
>
>
> If u are ordering into store the glcode will come from the inventory item. If it does not come in it is likely the item does not have the relevant gl code attached. Unless u have exposed the glcode on the inventory screen u will have to check at the database level.
>
> If its a direct issue item the glcode will come from the work order. Check its populated there.
>
> Peter
> Sent from Samsung Mobile
>
> dennis_belandres@... <mailto:dennis_belandres%40denso-diam.com> wrote:
>
> Is there a place to set GLDEBITACCT information in the item level to
> autofill the entry when adding a new line item through Maximo's purchase
> requisition application? There are times this gets filled automatically
> and there are time when not.
> Any suggestions would be greatly appreciated.
>
> Environment:
> 2005 SQL server
> Maximo 7.1.1.5
> Websphere 6.1
>
> Regards,
>
> Dennis
>
> The information contained in and transmitted with this Email may be
> privileged, proprietary, confidential and protected from disclosure. No
> privilege is hereby intended to be waived. This Email is intended only for
> the person to whom it is addressed. If you are not the intended
> recipient/addressee, any use of the Email and/or its contents, including,
> but not limited to, dissemination, distribution or copying is strictly
> prohibited and may be unlawful, and you must not take any action in
> reliance on it. If you receive this Email in error, please immediately
> notify the sender and delete the original message and any copies of it
> from your computer system. We deny any liability for damages resulting
> from the use of this Email by the unintended recipient, including the
> recipient in error.
>
>
>
>
>
>
>
>
>
>
>
Thank you for all the suggestions and directions that you guys presented.
I have the Financial Manager and will read up on it as soon as I can.
Regards,
Dennis
"in2data" <in2data@yahoo.com>
Sent by: MAXIMO@yahoogroups.com
10/07/2011 12:00 PM
Please respond to
MAXIMO@yahoogroups.com
To
MAXIMO@yahoogroups.com
cc
Subject
Re: [MAXIMO List] Prline GLDEBITACCT?
Hi,
Shannon is right about the set up and the financial manager manual.
But we just put the entie cost center and account code in our locations
since accounting just wants to track costs to those production line
accounts.
You can make it simple or complex.
Depends on your process.
Dave Bone
--- In MAXIMO@yahoogroups.com, "Shannon Rotz" <shannonrotz@...> wrote:
>
> To elaborate (a lot!), the recommended setup is
>
>
>
> 1. On your Locations, specify the GL Account EXCEPT for the portion that
is specific to the item being bought (what the accountants usually call
the account code). For the item component, put question marks
>
> 2. If you have asset-specific components in the GL string, then you will
need to specify the asset-specific component of the GL string in the GL
Account on the equipment record. This will over-ride anything that’s on
the Location record.
>
> 3. In the Item application, set up your Commodity Groups
>
> 4. In the Chart of Accounts, go to Select Action / Resource Codes. For
each commodity group set up in Step #3, specify the account
(item-specific) portion of the GL string
>
> 5. For each item, specify a commodity group. The item will inherit the
account code you specified in Step #4.
>
> 6. Create a work order (recommended) to carry the costs. You can do it
without a work order, but you won’t be able to see the costs in Maximo
â€" only on a report.
>
> 7. Create your PR line. Pick the item from the item list. Pick your work
order from the work order list. You will see that the GL Debit Account is
fully specified!
>
>
>
> Example:
>
> 1. GL Structure = ????-?????-???. 1st component is Department, 2nd
Component is Equipment type, 3rd Component is item type
>
> 2. Create location 101. For the GL Account, specify MTCE-?????-???
>
> 3. Create asset record for a conveyor, numbered CONV-100. Attach it to
location 101. On the Asset record, specify ????-CONVY-???
>
> 4. In the Item application, set up a Commodity Group called BEARING.
>
> 5. In Chart of Accounts / Select Action / Resource Codes, add a new
line, pick the BEARING commodity group, and specify ????-?????-123 (the
account code for bearings)
>
> 6. In the Item Master, create Item 400 and specify Commodity Group
BEARING. The item will inherit the commodity group’s GL account (you
can’t see it on the screen, but if you look at the table level, it’s
there.)
>
>
>
> Results:
>
> 1. When the work order 45678 is created using CONV-100 as the asset, the
work order’s GL account will automatically be set to MTCE-CONVY-???.
>
> 2. When the PR line is created, with Item 400 charged to work order
45678, the GL Debit Account will automatically be set to MTCE-CONVY-123.
>
>
>
> Note: this setup is for direct issue items only â€" inventory stuff is
different (the Storeroom setup is critical for the inventory ordering).
>
>
>
> You can vary this procedure slightly, but this is the recommended way to
do it. If you need me to explain further, just let me know. FYI: all of
this is outlined in the Finance Manager’s Guide. Getting to know that
document would instantly make you the “Maximo wizard†:)
>
>
>
>
>
>
>
> Shannon
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf
Of Peter Camarsh
> Sent: October-06-11 2:41 PM
> To: maximo@yahoogroups.com
> Subject: Re: [MAXIMO List] Prline GLDEBITACCT?
>
>
>
>
>
> If u are ordering into store the glcode will come from the inventory
item. If it does not come in it is likely the item does not have the
relevant gl code attached. Unless u have exposed the glcode on the
inventory screen u will have to check at the database level.
>
> If its a direct issue item the glcode will come from the work order.
Check its populated there.
>
> Peter
> Sent from Samsung Mobile
>
> dennis_belandres@... <mailto:dennis_belandres%40denso-diam.com> wrote:
>
> Is there a place to set GLDEBITACCT information in the item level to
> autofill the entry when adding a new line item through Maximo's purchase
> requisition application? There are times this gets filled automatically
> and there are time when not.
> Any suggestions would be greatly appreciated.
>
> Environment:
> 2005 SQL server
> Maximo 7.1.1.5
> Websphere 6.1
>
> Regards,
>
> Dennis
>
> The information contained in and transmitted with this Email may be
> privileged, proprietary, confidential and protected from disclosure. No
> privilege is hereby intended to be waived. This Email is intended only
for
> the person to whom it is addressed. If you are not the intended
> recipient/addressee, any use of the Email and/or its contents,
including,
> but not limited to, dissemination, distribution or copying is strictly
> prohibited and may be unlawful, and you must not take any action in
> reliance on it. If you receive this Email in error, please immediately
> notify the sender and delete the original message and any copies of it
> from your computer system. We deny any liability for damages resulting
> from the use of this Email by the unintended recipient, including the
> recipient in error.
>
>
>
>
>
>
>
>
>
>
>
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.