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.
It could be the inventory was loaded into a storeroom before the store had
its GL's set even if you set the GL later the inventory records do not get
the GL set
Rgds Ian
-------Original Message-------
From: Incomm Solutions incomm@shaw.ca [MAXIMO]
Date: 03/31/16 18:07:59
To: maximal@wanko.com [MAXIMO]; MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
Hi Chris: what's the GL credit Account on the PO Line? Is it blank?
Shannon
Sent from my wonderful BlackBerry Z30 smartphone!
Original Message
From: maximal@wanko.com [MAXIMO]
Sent: Thursday, March 31, 2016 9:45 AM
To: MAXIMO@yahoogroups.com
Reply To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
No inspection required, looks setup to receive directly into stores.
---In MAXIMO@yahoogroups.com, <ron_bryant@cargill.com> wrote :
Is it possible that there is an inspection or staged receipt location
involved?
From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
[mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com]
Sent: Thursday, March 31, 2016 10:12 AM
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
WebSphere 7, Maximo 7508, SQL Server 10 (oh look, it's not a 6.2 question!)
A user is trying to perform a material receipt for a PO. PO looks good,
vendor has GLs, storeroom has GLs, GLs are valid. Find the line from the PO
using "Selected Ordered Items", try to save in Receiving app, and I get the
error [BMXAA1185E - The debit or credit general ledger account is not
specified]
Well okay. Where do I look now?
More to the basic point, how do I (properly) set up logging in a 7.5x
environment to trap the operation? I set the SQL logging to INFO but it
doesn't seem to be as verbose as the Maximo 6.x SQL logging, which basically
teaches you how to do everything in Maximo.
Any advice is appreciated.
-C
Now this is interesting. For all inventory, 40k rows have glaccount present in the inventory table, 2500 do not. And that itemnum is one of those.
What's the correct gl to apply there, I wonder?
-C
---In MAXIMO@yahoogroups.com, <ian_wright12000@yahoo.co.uk> wrote :
It could be the inventory was loaded into a storeroom before the store had
its GL's set even if you set the GL later the inventory records do not get
the GL set
Rgds Ian
-------Original Message-------
From: Incomm Solutions incomm@shaw.ca mailto:incomm@shaw.ca [MAXIMO]
Date: 03/31/16 18:07:59
To: maximal@wanko.com mailto:maximal@wanko.com [MAXIMO]; MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
Hi Chris: what's the GL credit Account on the PO Line? Is it blank?
Shannon
Sent from my wonderful BlackBerry Z30 smartphone!
Original Message
From: maximal@wanko.com mailto:maximal@wanko.com [MAXIMO]
Sent: Thursday, March 31, 2016 9:45 AM
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Reply To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
No inspection required, looks setup to receive directly into stores.
---In MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com, <ron_bryant@cargill.com mailto:ron_bryant@cargill.com> wrote :
Is it possible that there is an inspection or staged receipt location
involved?
From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
[mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com]
Sent: Thursday, March 31, 2016 10:12 AM
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
WebSphere 7, Maximo 7508, SQL Server 10 (oh look, it's not a 6.2 question!)
A user is trying to perform a material receipt for a PO. PO looks good,
vendor has GLs, storeroom has GLs, GLs are valid. Find the line from the PO
using "Selected Ordered Items", try to save in Receiving app, and I get the
error [BMXAA1185E - The debit or credit general ledger account is not
specified]
Well okay. Where do I look now?
More to the basic point, how do I (properly) set up logging in a 7.5x
environment to trap the operation? I set the SQL logging to INFO but it
doesn't seem to be as verbose as the Maximo 6.x SQL logging, which basically
teaches you how to do everything in Maximo.
Any advice is appreciated.
-C
It's the one from the storeroom
Sent from my iPhone
> On 1 Apr 2016, at 12:50, maximal@wanko.com [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
> Now this is interesting. For all inventory, 40k rows have glaccount present in the inventory table, 2500 do not. And that itemnum is one of those.
>
> What's the correct gl to apply there, I wonder?
>
>
> -C
>
>
>
>
> ---In MAXIMO@yahoogroups.com, <ian_wright12000@yahoo.co.uk> wrote :
>
> It could be the inventory was loaded into a storeroom before the store had
> its GL's set even if you set the GL later the inventory records do not get
> the GL set
>
> Rgds Ian
>
>
>
>
> -------Original Message-------
>
> From: Incomm Solutions incomm@shaw.ca mailto:incomm@shaw.ca [MAXIMO]
> Date: 03/31/16 18:07:59
> To: maximal@wanko.com mailto:maximal@wanko.com [MAXIMO]; MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
> account is not specified
>
>
> Hi Chris: what's the GL credit Account on the PO Line? Is it blank?
>
>
> Shannon
>
> Sent from my wonderful BlackBerry Z30 smartphone!
> Original Message
> From: maximal@wanko.com mailto:maximal@wanko.com [MAXIMO]
> Sent: Thursday, March 31, 2016 9:45 AM
> To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> Reply To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> Subject: RE: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
> account is not specified
>
> No inspection required, looks setup to receive directly into stores.
>
> ---In MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com, <ron_bryant@cargill.com mailto:ron_bryant@cargill.com> wrote :
>
> Is it possible that there is an inspection or staged receipt location
> involved?
>
> From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> [mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com]
> Sent: Thursday, March 31, 2016 10:12 AM
> To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
> account is not specified
>
> WebSphere 7, Maximo 7508, SQL Server 10 (oh look, it's not a 6.2 question!)
>
> A user is trying to perform a material receipt for a PO. PO looks good,
> vendor has GLs, storeroom has GLs, GLs are valid. Find the line from the PO
> using "Selected Ordered Items", try to save in Receiving app, and I get the
> error [BMXAA1185E - The debit or credit general ledger account is not
> specified]
>
> Well okay. Where do I look now?
>
> More to the basic point, how do I (properly) set up logging in a 7.5x
> environment to trap the operation? I set the SQL logging to INFO but it
> doesn't seem to be as verbose as the Maximo 6.x SQL logging, which basically
> teaches you how to do everything in Maximo.
>
> Any advice is appreciated.
>
> -C
>
>
>
>
>
>
>
>
>
Best idea is in your test system add a new part to a store check what gets populated also check associated tables like invcost to see what accounts get populated
Ian :)
Sent from my iPhone
> On 1 Apr 2016, at 13:44, Ian Wright ian_wright12000@yahoo.co.uk [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
> It's the one from the storeroom
>
> Sent from my iPhone
>
> > On 1 Apr 2016, at 12:50, maximal@wanko.com [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
> >
> > Now this is interesting. For all inventory, 40k rows have glaccount present in the inventory table, 2500 do not. And that itemnum is one of those.
> >
> > What's the correct gl to apply there, I wonder?
> >
> >
> > -C
> >
> >
> >
> >
> > ---In MAXIMO@yahoogroups.com, <ian_wright12000@yahoo.co.uk> wrote :
> >
> > It could be the inventory was loaded into a storeroom before the store had
> > its GL's set even if you set the GL later the inventory records do not get
> > the GL set
> >
> > Rgds Ian
> >
> >
> >
> >
> > -------Original Message-------
> >
> > From: Incomm Solutions incomm@shaw.ca mailto:incomm@shaw.ca [MAXIMO]
> > Date: 03/31/16 18:07:59
> > To: maximal@wanko.com mailto:maximal@wanko.com [MAXIMO]; MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> > Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
> > account is not specified
> >
> >
> > Hi Chris: what's the GL credit Account on the PO Line? Is it blank?
> >
> >
> > Shannon
> >
> > Sent from my wonderful BlackBerry Z30 smartphone!
> > Original Message
> > From: maximal@wanko.com mailto:maximal@wanko.com [MAXIMO]
> > Sent: Thursday, March 31, 2016 9:45 AM
> > To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> > Reply To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> > Subject: RE: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
> > account is not specified
> >
> > No inspection required, looks setup to receive directly into stores.
> >
> > ---In MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com, <ron_bryant@cargill.com mailto:ron_bryant@cargill.com> wrote :
> >
> > Is it possible that there is an inspection or staged receipt location
> > involved?
> >
> > From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> > [mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com]
> > Sent: Thursday, March 31, 2016 10:12 AM
> > To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> > Subject: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
> > account is not specified
> >
> > WebSphere 7, Maximo 7508, SQL Server 10 (oh look, it's not a 6.2 question!)
> >
> > A user is trying to perform a material receipt for a PO. PO looks good,
> > vendor has GLs, storeroom has GLs, GLs are valid. Find the line from the PO
> > using "Selected Ordered Items", try to save in Receiving app, and I get the
> > error [BMXAA1185E - The debit or credit general ledger account is not
> > specified]
> >
> > Well okay. Where do I look now?
> >
> > More to the basic point, how do I (properly) set up logging in a 7.5x
> > environment to trap the operation? I set the SQL logging to INFO but it
> > doesn't seem to be as verbose as the Maximo 6.x SQL logging, which basically
> > teaches you how to do everything in Maximo.
> >
> > Any advice is appreciated.
> >
> > -C
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
GLACCOUNT on the Inventory record actually doesn’t matter much in 7.5 – they’ve moved it to the INVCOST table, and I find that’s the one that Maximo’s using these days.
The GLACCOUNT value should be the one that’s connected to the Commodity Group, whereas the CONTROLACC field should be the storeroom account.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Friday, April 1, 2016 4:51 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger account is not specified
Now this is interesting. For all inventory, 40k rows have glaccount present in the inventory table, 2500 do not. And that itemnum is one of those.
What's the correct gl to apply there, I wonder?
-C
---In MAXIMO@yahoogroups.com, <ian_wright12000@yahoo.co.uk> wrote :
It could be the inventory was loaded into a storeroom before the store had
its GL's set even if you set the GL later the inventory records do not get
the GL set
Rgds Ian
-------Original Message-------
From: Incomm Solutions incomm@shaw.ca mailto:incomm@shaw.ca [MAXIMO]
Date: 03/31/16 18:07:59
To: maximal@wanko.com mailto:maximal@wanko.com [MAXIMO]; MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
Hi Chris: what's the GL credit Account on the PO Line? Is it blank?
Shannon
Sent from my wonderful BlackBerry Z30 smartphone!
Original Message
From: maximal@wanko.com mailto:maximal@wanko.com [MAXIMO]
Sent: Thursday, March 31, 2016 9:45 AM
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Reply To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
No inspection required, looks setup to receive directly into stores.
---In MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com, <ron_bryant@cargill.com mailto:ron_bryant@cargill.com> wrote :
Is it possible that there is an inspection or staged receipt location
involved?
From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
[mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com]
Sent: Thursday, March 31, 2016 10:12 AM
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
WebSphere 7, Maximo 7508, SQL Server 10 (oh look, it's not a 6.2 question!)
A user is trying to perform a material receipt for a PO. PO looks good,
vendor has GLs, storeroom has GLs, GLs are valid. Find the line from the PO
using "Selected Ordered Items", try to save in Receiving app, and I get the
error [BMXAA1185E - The debit or credit general ledger account is not
specified]
Well okay. Where do I look now?
More to the basic point, how do I (properly) set up logging in a 7.5x
environment to trap the operation? I set the SQL logging to INFO but it
doesn't seem to be as verbose as the Maximo 6.x SQL logging, which basically
teaches you how to do everything in Maximo.
Any advice is appreciated.
-C
All right, I'm definitely going to test item adds to this storeroom in our TEST environment; and thanks for the GL lessons everyone, especially Shannon, did not know about the gl/control account precedence.
-C
---In MAXIMO@yahoogroups.com, <incomm@shaw.ca> wrote :
GLACCOUNT on the Inventory record actually doesn’t matter much in 7.5 – they’ve moved it to the INVCOST table, and I find that’s the one that Maximo’s using these days.
The GLACCOUNT value should be the one that’s connected to the Commodity Group, whereas the CONTROLACC field should be the storeroom account.
Shannon
From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com]
Sent: Friday, April 1, 2016 4:51 AM
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger account is not specified
Now this is interesting. For all inventory, 40k rows have glaccount present in the inventory table, 2500 do not. And that itemnum is one of those.
What's the correct gl to apply there, I wonder?
-C
---In MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com, <ian_wright12000@yahoo.co.uk mailto:ian_wright12000@yahoo.co.uk> wrote :
It could be the inventory was loaded into a storeroom before the store had
its GL's set even if you set the GL later the inventory records do not get
the GL set
Rgds Ian
-------Original Message-------
From: Incomm Solutions incomm@shaw.ca mailto:incomm@shaw.ca mailto:incomm@shaw.ca mailto:incomm@shaw.ca [MAXIMO]
Date: 03/31/16 18:07:59
To: maximal@wanko.com mailto:maximal@wanko.com mailto:maximal@wanko.com mailto:maximal@wanko.com [MAXIMO]; MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
Hi Chris: what's the GL credit Account on the PO Line? Is it blank?
Shannon
Sent from my wonderful BlackBerry Z30 smartphone!
Original Message
From: maximal@wanko.com mailto:maximal@wanko.com mailto:maximal@wanko.com mailto:maximal@wanko.com [MAXIMO]
Sent: Thursday, March 31, 2016 9:45 AM
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Reply To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
No inspection required, looks setup to receive directly into stores.
---In MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com, <ron_bryant@cargill.com mailto:ron_bryant@cargill.com mailto:ron_bryant@cargill.com mailto:ron_bryant@cargill.com> wrote :
Is it possible that there is an inspection or staged receipt location
involved?
From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
[mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com]
Sent: Thursday, March 31, 2016 10:12 AM
To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
Subject: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
WebSphere 7, Maximo 7508, SQL Server 10 (oh look, it's not a 6.2 question!)
A user is trying to perform a material receipt for a PO. PO looks good,
vendor has GLs, storeroom has GLs, GLs are valid. Find the line from the PO
using "Selected Ordered Items", try to save in Receiving app, and I get the
error [BMXAA1185E - The debit or credit general ledger account is not
specified]
Well okay. Where do I look now?
More to the basic point, how do I (properly) set up logging in a 7.5x
environment to trap the operation? I set the SQL logging to INFO but it
doesn't seem to be as verbose as the Maximo 6.x SQL logging, which basically
teaches you how to do everything in Maximo.
Any advice is appreciated.
-C
What matters is if you don't set the gl in the store before you load the inventory then transactions don't work it's got nothing to do with precedence
Sent from my iPhone
> On 1 Apr 2016, at 17:30, maximal@wanko.com [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
>
> All right, I'm definitely going to test item adds to this storeroom in our TEST environment; and thanks for the GL lessons everyone, especially Shannon, did not know about the gl/control account precedence.
>
>
> -C
>
>
>
>
> ---In MAXIMO@yahoogroups.com, <incomm@shaw.ca> wrote :
>
> GLACCOUNT on the Inventory record actually doesn’t matter much in 7.5 – they’ve moved it to the INVCOST table, and I find that’s the one that Maximo’s using these days.
>
> The GLACCOUNT value should be the one that’s connected to the Commodity Group, whereas the CONTROLACC field should be the storeroom account.
>
>
>
> Shannon
>
>
> From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com]
> Sent: Friday, April 1, 2016 4:51 AM
> To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger account is not specified
>
>
> Now this is interesting. For all inventory, 40k rows have glaccount present in the inventory table, 2500 do not. And that itemnum is one of those.
>
> What's the correct gl to apply there, I wonder?
>
>
> -C
>
>
>
>
> ---In MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com, <ian_wright12000@yahoo.co.uk mailto:ian_wright12000@yahoo.co.uk> wrote :
>
> It could be the inventory was loaded into a storeroom before the store had
> its GL's set even if you set the GL later the inventory records do not get
> the GL set
>
> Rgds Ian
>
>
>
>
> -------Original Message-------
>
> From: Incomm Solutions incomm@shaw.ca mailto:incomm@shaw.ca mailto:incomm@shaw.ca mailto:incomm@shaw.ca [MAXIMO]
> Date: 03/31/16 18:07:59
> To: maximal@wanko.com mailto:maximal@wanko.com mailto:maximal@wanko.com mailto:maximal@wanko.com [MAXIMO]; MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
> account is not specified
>
>
> Hi Chris: what's the GL credit Account on the PO Line? Is it blank?
>
>
> Shannon
>
> Sent from my wonderful BlackBerry Z30 smartphone!
> Original Message
> From: maximal@wanko.com mailto:maximal@wanko.com mailto:maximal@wanko.com mailto:maximal@wanko.com [MAXIMO]
> Sent: Thursday, March 31, 2016 9:45 AM
> To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> Reply To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> Subject: RE: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
> account is not specified
>
> No inspection required, looks setup to receive directly into stores.
>
> ---In MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com, <ron_bryant@cargill.com mailto:ron_bryant@cargill.com mailto:ron_bryant@cargill.com mailto:ron_bryant@cargill.com> wrote :
>
> Is it possible that there is an inspection or staged receipt location
> involved?
>
> From: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> [mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com]
> Sent: Thursday, March 31, 2016 10:12 AM
> To: MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com mailto:MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
> account is not specified
>
> WebSphere 7, Maximo 7508, SQL Server 10 (oh look, it's not a 6.2 question!)
>
> A user is trying to perform a material receipt for a PO. PO looks good,
> vendor has GLs, storeroom has GLs, GLs are valid. Find the line from the PO
> using "Selected Ordered Items", try to save in Receiving app, and I get the
> error [BMXAA1185E - The debit or credit general ledger account is not
> specified]
>
> Well okay. Where do I look now?
>
> More to the basic point, how do I (properly) set up logging in a 7.5x
> environment to trap the operation? I set the SQL logging to INFO but it
> doesn't seem to be as verbose as the Maximo 6.x SQL logging, which basically
> teaches you how to do everything in Maximo.
>
> Any advice is appreciated.
>
> -C
>
>
>
>
>
>
>
>
>
>
>
>
I still need a good way to fix items. I still get missing GLs around some inventory.
-C
Hey Chris: can you tell where the breakdown is?
Is it in the INVCOST table, or the Commodity Group mappings, or what?
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Monday, April 11, 2016 8:39 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
account is not specified
I still need a good way to fix items. I still get missing GLs around some
inventory.
-C
This needs to be fixed by scripts
Sent from my iPhone
> On 11 Apr 2016, at 22:04, 'InComm Solutions Inc.' incomm@shaw.ca [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
> Hey Chris: can you tell where the breakdown is?
>
> Is it in the INVCOST table, or the Commodity Group mappings, or what?
>
> Shannon
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
> Sent: Monday, April 11, 2016 8:39 AM
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
> account is not specified
>
> I still need a good way to fix items. I still get missing GLs around some
> inventory.
>
> -C
>
>
>
>
>
>
Just need to know where the breakdown is.
When you add the item to a storeroom, the debit account should get copied from the ACCOUNTDEFAULTS table to the INVCOST table, and in my experience, that functionality has been totally solid, except for cases where:
- there’s no commodity group on the item, OR
- The commodity group mapping has not been specified in the Chart of Accounts.
If one of those occurs, you can use one of the Update Database options in Chart of Accounts to fix the inventory records (if memory serves me), but I don’t bother – I just normally do a back-end update.
If the problem is lack of commodity groups specified on the item, then I guess the other solution is to make the commodity group required.
If the problem is lack of mappings for commodity groups, it’s really a process issue – whoever’s creating the commodity groups needs to make sure they talk to Finance and get them coded (or have rights to do it themselves, I guess) before adding their items to Inventory.
Another $.02 worth from me ...
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Tuesday, April 12, 2016 1:20 AM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger account is not specified
This needs to be fixed by scripts
Sent from my iPhone
> On 11 Apr 2016, at 22:04, 'InComm Solutions Inc.' incomm@shaw.ca [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
> Hey Chris: can you tell where the breakdown is?
>
> Is it in the INVCOST table, or the Commodity Group mappings, or what?
>
> Shannon
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
> Sent: Monday, April 11, 2016 8:39 AM
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] BMXAA1185E - The debit or credit general ledger
> account is not specified
>
> I still need a good way to fix items. I still get missing GLs around some
> inventory.
>
> -C
>
>
>
>
>
>
I'm having trouble finding the breakdown. This Maximo installation has zero gldefault values in the ACCOUNTDEFAULTS table; every single RBNIACCT value in their companies table is an invalid GL. Yet, somehow, they receive in this system except for this one item.
I've checked its invcost row, poline row, item, and inventory details. There are valid GLs everywhere. What I can't seem to do is configure logging to show the attempted insert or update when doing receiving. I've ratcheted SQL logging to INFO, that didn't do it but it sure made the logs rotate. I need to be smarter here, but I don't have the smarts for this it seems.
-C
---In MAXIMO@yahoogroups.com, <incomm@shaw.ca> wrote :
Just need to know where the breakdown is.
When you add the item to a storeroom, the debit account should get copied from the ACCOUNTDEFAULTS table to the INVCOST table, and in my experience, that functionality has been totally solid, except for cases where:
- there’s no commodity group on the item, OR
- The commodity group mapping has not been specified in the Chart of Accounts.
If one of those occurs, you can use one of the Update Database options in Chart of Accounts to fix the inventory records (if memory serves me), but I don’t bother – I just normally do a back-end update.
If the problem is lack of commodity groups specified on the item, then I guess the other solution is to make the commodity group required.
If the problem is lack of mappings for commodity groups, it’s really a process issue – whoever’s creating the commodity groups needs to make sure they talk to Finance and get them coded (or have rights to do it themselves, I guess) before adding their items to Inventory
FOUND IT.
After finding dozens of incorrect GLs in weird places, after setting GL on items in inventory, after looking everywhere and still not seeing the logfiles help me, I spotted it.
"Inspection Required?"
I was doing a receipt, again to see the log entries, and noticed the inspection status was showing up. I know this end user installation didn't inspect on receipt, so this was my clue to solve it. Sure enough, the PO line had it set. The PO line section for the PO application had that field removed instead of hidden or locked down, so I never noticed it. The PO header had it blank, but it could have easily been set then un-set after a line was added. Header flags don't cascade to existing lines (obviously)
We could have still solved this if accounting supplied GLs for the holding locations, but they declined. Which is weird and unhelpful. I could have faked a GL there but I don't mess with accounting, even if they deserve it. So, I flipped the bit in the database, and it flowed. I also flipped a bit for another PO line out there, in anticipation of someone discovering this issue again.
I need to restore that field, lock it down, and try to convince accounting to create holding GLs.
Well, I sure did learn a lot about default GL values, how GLs get copied from place to place, and why removing fields is always a bad idea.
Thanks to everyone who pitched in and gave it a look, I appreciate it.
-C
Hi Chris: BTW - there are some outstanding issues with the Inspection
Required functionality and GL accounts, if my memory serves me. They may or
may not have been fixed.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Tuesday, April 19, 2016 5:46 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: BMXAA1185E - The debit or credit general ledger
account is not specified
FOUND IT.
After finding dozens of incorrect GLs in weird places, after setting GL on
items in inventory, after looking everywhere and still not seeing the
logfiles help me, I spotted it.
"Inspection Required?"
I was doing a receipt, again to see the log entries, and noticed the
inspection status was showing up. I know this end user installation didn't
inspect on receipt, so this was my clue to solve it. Sure enough, the PO
line had it set. The PO line section for the PO application had that field
removed instead of hidden or locked down, so I never noticed it. The PO
header had it blank, but it could have easily been set then un-set after a
line was added. Header flags don't cascade to existing lines (obviously)
We could have still solved this if accounting supplied GLs for the holding
locations, but they declined. Which is weird and unhelpful. I could have
faked a GL there but I don't mess with accounting, even if they deserve it.
So, I flipped the bit in the database, and it flowed. I also flipped a bit
for another PO line out there, in anticipation of someone discovering this
issue again.
I need to restore that field, lock it down, and try to convince accounting
to create holding GLs.
Well, I sure did learn a lot about default GL values, how GLs get copied
from place to place, and why removing fields is always a bad idea.
Thanks to everyone who pitched in and gave it a look, I appreciate it.
-C
---In MAXIMO@yahoogroups.com, <incomm@shaw.ca> wrote :
Hi Chris: BTW - there are some outstanding issues with the Inspection
Required functionality and GL accounts, if my memory serves me. They may or
may not have been fixed.
I looked them up, and saw a few. They didn't really apply to us, since I eventually traced it to an end user checking "Inspection Required" on the items!
-C