PO next number changes randomly GP10

Hello,
The company I currently work for has been seeing the next PO number being 
changed in the purchase order processing screen.  This occurs randomly.  To 
try to determine the cause of this, I have turned on the activity tracking as 
well as sql triggers on the pop40100 table.  Has anyone else seen this before 
or have any suggestions on how to determine what is causing this to change?  
Any help would be greatly appreciated.
 Thank you,
JC

0
jc1 (91)
1/29/2009 3:03:01 PM
greatplains 29623 articles. 6 followers. Follow

20 Replies
1096 Views

Similar Articles

[PageSpeed] 52

Hi JC

when you say it is changing what do mean?

I believe that the PO numbers will go back and fill in for PO's that have 
been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 
and the one after that will be 11. I am not 100% sure but I believe this is 
how it works.


-- 
Fliehigh


"jc" wrote:

> Hello,
> The company I currently work for has been seeing the next PO number being 
> changed in the purchase order processing screen.  This occurs randomly.  To 
> try to determine the cause of this, I have turned on the activity tracking as 
> well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> or have any suggestions on how to determine what is causing this to change?  
> Any help would be greatly appreciated.
>  Thank you,
> JC
> 
0
Fliehigh (443)
1/29/2009 3:48:01 PM
Hi Fliehigh,

I tested this and it does not work as you described below.  Ex. if I delete 
PO number 8 and try to add a new PO, it will use the po next number in the 
sequence.  It does not try to reuse a deleted PO number.  Are there specific 
steps that I need to follow to delete the PO number to make this occur?  
thanks.

"Fliehigh" wrote:

> Hi JC
> 
> when you say it is changing what do mean?
> 
> I believe that the PO numbers will go back and fill in for PO's that have 
> been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 
> and the one after that will be 11. I am not 100% sure but I believe this is 
> how it works.
> 
> 
> -- 
> Fliehigh
> 
> 
> "jc" wrote:
> 
> > Hello,
> > The company I currently work for has been seeing the next PO number being 
> > changed in the purchase order processing screen.  This occurs randomly.  To 
> > try to determine the cause of this, I have turned on the activity tracking as 
> > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > or have any suggestions on how to determine what is causing this to change?  
> > Any help would be greatly appreciated.
> >  Thank you,
> > JC
> > 
0
jc1 (91)
1/29/2009 4:01:02 PM
We have a similar problem. It used to happen fairly often, but now it only 
occurs rarely. We did turn on the feature in Professional Services Tools to 
keep this from happening, so that might be the reason why it doesn't happen 
very often now. We still haven't figured out why it does every so often, 
though.

-- 
Bud Cool
Microsoft Certified Business Management Solutions Specialist, GP 9.0 
Financials
Currently supporting: GP 9.0, SP2


"jc" wrote:

> Hi Fliehigh,
> 
> I tested this and it does not work as you described below.  Ex. if I delete 
> PO number 8 and try to add a new PO, it will use the po next number in the 
> sequence.  It does not try to reuse a deleted PO number.  Are there specific 
> steps that I need to follow to delete the PO number to make this occur?  
> thanks.
> 
> "Fliehigh" wrote:
> 
> > Hi JC
> > 
> > when you say it is changing what do mean?
> > 
> > I believe that the PO numbers will go back and fill in for PO's that have 
> > been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 
> > and the one after that will be 11. I am not 100% sure but I believe this is 
> > how it works.
> > 
> > 
> > -- 
> > Fliehigh
> > 
> > 
> > "jc" wrote:
> > 
> > > Hello,
> > > The company I currently work for has been seeing the next PO number being 
> > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > try to determine the cause of this, I have turned on the activity tracking as 
> > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > or have any suggestions on how to determine what is causing this to change?  
> > > Any help would be greatly appreciated.
> > >  Thank you,
> > > JC
> > > 
0
Bud (544)
1/29/2009 4:19:01 PM
I have a client who is experiencing the same behavior in GP9.  Thanks
Bud for the tip.  I'll check to see if they have PSTL and if so, have
them turn this feature on.

Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
blog: www.gp2themax.blogspot.com


0
fhamelly1 (1404)
1/29/2009 4:35:32 PM
Bud,

Thanks for the suggestion but I still would like to know why this happens.  
Has anyone asked Microsoft directly on this issue?

"Bud" wrote:

> We have a similar problem. It used to happen fairly often, but now it only 
> occurs rarely. We did turn on the feature in Professional Services Tools to 
> keep this from happening, so that might be the reason why it doesn't happen 
> very often now. We still haven't figured out why it does every so often, 
> though.
> 
> -- 
> Bud Cool
> Microsoft Certified Business Management Solutions Specialist, GP 9.0 
> Financials
> Currently supporting: GP 9.0, SP2
> 
> 
> "jc" wrote:
> 
> > Hi Fliehigh,
> > 
> > I tested this and it does not work as you described below.  Ex. if I delete 
> > PO number 8 and try to add a new PO, it will use the po next number in the 
> > sequence.  It does not try to reuse a deleted PO number.  Are there specific 
> > steps that I need to follow to delete the PO number to make this occur?  
> > thanks.
> > 
> > "Fliehigh" wrote:
> > 
> > > Hi JC
> > > 
> > > when you say it is changing what do mean?
> > > 
> > > I believe that the PO numbers will go back and fill in for PO's that have 
> > > been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 
> > > and the one after that will be 11. I am not 100% sure but I believe this is 
> > > how it works.
> > > 
> > > 
> > > -- 
> > > Fliehigh
> > > 
> > > 
> > > "jc" wrote:
> > > 
> > > > Hello,
> > > > The company I currently work for has been seeing the next PO number being 
> > > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > > try to determine the cause of this, I have turned on the activity tracking as 
> > > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > > or have any suggestions on how to determine what is causing this to change?  
> > > > Any help would be greatly appreciated.
> > > >  Thank you,
> > > > JC
> > > > 
0
jc1 (91)
1/29/2009 4:48:01 PM
How many people do you have entering POs? When you say 'randomly' what does 
this mean? I have seen cases in multi-user PO entry environments where, for 
example, if user A is working on PO 10, user B is working PO 11, and user C 
is working on PO 12, but user B cancels, void, or delete their PO, when user 
A attempts to enter another PO, they will still end up with 13. It will 
appear to user A that the PO numbers are being skipped randomly.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com


"jc" wrote:

> Bud,
> 
> Thanks for the suggestion but I still would like to know why this happens.  
> Has anyone asked Microsoft directly on this issue?
> 
> "Bud" wrote:
> 
> > We have a similar problem. It used to happen fairly often, but now it only 
> > occurs rarely. We did turn on the feature in Professional Services Tools to 
> > keep this from happening, so that might be the reason why it doesn't happen 
> > very often now. We still haven't figured out why it does every so often, 
> > though.
> > 
> > -- 
> > Bud Cool
> > Microsoft Certified Business Management Solutions Specialist, GP 9.0 
> > Financials
> > Currently supporting: GP 9.0, SP2
> > 
> > 
> > "jc" wrote:
> > 
> > > Hi Fliehigh,
> > > 
> > > I tested this and it does not work as you described below.  Ex. if I delete 
> > > PO number 8 and try to add a new PO, it will use the po next number in the 
> > > sequence.  It does not try to reuse a deleted PO number.  Are there specific 
> > > steps that I need to follow to delete the PO number to make this occur?  
> > > thanks.
> > > 
> > > "Fliehigh" wrote:
> > > 
> > > > Hi JC
> > > > 
> > > > when you say it is changing what do mean?
> > > > 
> > > > I believe that the PO numbers will go back and fill in for PO's that have 
> > > > been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 
> > > > and the one after that will be 11. I am not 100% sure but I believe this is 
> > > > how it works.
> > > > 
> > > > 
> > > > -- 
> > > > Fliehigh
> > > > 
> > > > 
> > > > "jc" wrote:
> > > > 
> > > > > Hello,
> > > > > The company I currently work for has been seeing the next PO number being 
> > > > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > > > try to determine the cause of this, I have turned on the activity tracking as 
> > > > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > > > or have any suggestions on how to determine what is causing this to change?  
> > > > > Any help would be greatly appreciated.
> > > > >  Thank you,
> > > > > JC
> > > > > 
0
MarianoGomez (3440)
1/29/2009 6:29:01 PM
Mariano,

There are approximately 5 people who enter POs on  a regular basis.  
Currently, the POs should start at 0008xxx but lately I've seen POs start at 
0007xxx for no apparent reason.  The only manner in which I can see this 
happen is if someone goes in manually to the POP screen to change the po next 
number value.  But I've been assured that this is not happening. When this 
issue occurs, the po next number value in the POP screen is changed from 
0008xxx to 0007xxx.  

I have been able to reproduce your scenario by myself.  Isn't GP not suppose 
to use a deleted or voided PO number?  

"Mariano Gomez" wrote:

> How many people do you have entering POs? When you say 'randomly' what does 
> this mean? I have seen cases in multi-user PO entry environments where, for 
> example, if user A is working on PO 10, user B is working PO 11, and user C 
> is working on PO 12, but user B cancels, void, or delete their PO, when user 
> A attempts to enter another PO, they will still end up with 13. It will 
> appear to user A that the PO numbers are being skipped randomly.
> 
> Best regards,
> --
> MG.-
> Mariano Gomez, MIS, MCP, PMP
> Maximum Global Business, LLC
> http://www.maximumglobalbusiness.com
> The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> 
> 
> "jc" wrote:
> 
> > Bud,
> > 
> > Thanks for the suggestion but I still would like to know why this happens.  
> > Has anyone asked Microsoft directly on this issue?
> > 
> > "Bud" wrote:
> > 
> > > We have a similar problem. It used to happen fairly often, but now it only 
> > > occurs rarely. We did turn on the feature in Professional Services Tools to 
> > > keep this from happening, so that might be the reason why it doesn't happen 
> > > very often now. We still haven't figured out why it does every so often, 
> > > though.
> > > 
> > > -- 
> > > Bud Cool
> > > Microsoft Certified Business Management Solutions Specialist, GP 9.0 
> > > Financials
> > > Currently supporting: GP 9.0, SP2
> > > 
> > > 
> > > "jc" wrote:
> > > 
> > > > Hi Fliehigh,
> > > > 
> > > > I tested this and it does not work as you described below.  Ex. if I delete 
> > > > PO number 8 and try to add a new PO, it will use the po next number in the 
> > > > sequence.  It does not try to reuse a deleted PO number.  Are there specific 
> > > > steps that I need to follow to delete the PO number to make this occur?  
> > > > thanks.
> > > > 
> > > > "Fliehigh" wrote:
> > > > 
> > > > > Hi JC
> > > > > 
> > > > > when you say it is changing what do mean?
> > > > > 
> > > > > I believe that the PO numbers will go back and fill in for PO's that have 
> > > > > been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 
> > > > > and the one after that will be 11. I am not 100% sure but I believe this is 
> > > > > how it works.
> > > > > 
> > > > > 
> > > > > -- 
> > > > > Fliehigh
> > > > > 
> > > > > 
> > > > > "jc" wrote:
> > > > > 
> > > > > > Hello,
> > > > > > The company I currently work for has been seeing the next PO number being 
> > > > > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > > > > try to determine the cause of this, I have turned on the activity tracking as 
> > > > > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > > > > or have any suggestions on how to determine what is causing this to change?  
> > > > > > Any help would be greatly appreciated.
> > > > > >  Thank you,
> > > > > > JC
> > > > > > 
0
jc1 (91)
1/29/2009 7:05:03 PM
This is a "feature".  When one of your purchasing people types a PO number to 
change something and "fat fingers" it, GP changes the master number.  No 
matter how many times I tell them to use the LookUp they will not.  We've 
been dealing with it since V8.  The PSTL tool works.
-- 
Tim Foster


"jc" wrote:

> Hello,
> The company I currently work for has been seeing the next PO number being 
> changed in the purchase order processing screen.  This occurs randomly.  To 
> try to determine the cause of this, I have turned on the activity tracking as 
> well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> or have any suggestions on how to determine what is causing this to change?  
> Any help would be greatly appreciated.
>  Thank you,
> JC
> 
0
tfoster (136)
1/29/2009 10:50:06 PM
jc,

This explains a lot of things! Your next PO number, in principle, should be 
the maximum numeric portion of the next PO number + 1 in POP_Setup 
(POP40100). Initially, GP will read the value from the POP_Setup table. THEN 
it will ATTEMPT TO RESERVE this value, this is, making sure the next PO 
number has not been used (the next po number is not taken at 'face value', if 
you will).

In it's attempt to reserve the value, It will first search forward, up to 
MAX_DOCID_RETRIES (a constant in the code with a value of 1000). If at the 
end of this attempt to reserve a number the system is still not successful, 
it will move backwards up to MAX_DOCID_RETRIES again. This explains why your 
PO Numbers jump from 8,XXX to 7,XXX.

If the system finds and empty position, it "grabs" (as in reserves) that PO 
number, incrementing the next PO number to whatever value is next from the 
"empty" position it found. Unfortunately, this new value could have already 
been used, hence it will repeat the check the next time someone enters a PO.

To correct this issue, you will need to find the "real" next PO number:

RUN THIS IN A TEST ENVIRONMENT FIRST, WITH NO ONE IN THE SYSTEM. IF YOU ARE 
CONVINCED THAT IT WORKS, RUN IN PRODUCTION, WITH NO ONE IN THE SYSTEM:

1) Copy the two scripts from my article "How to split Dynamics GP's 
alphanumeric column values in SQL Server" at 
http://dynamicsgpblogster.blogspot.com/2008/11/how-to-split-dynamics-gps-alphanumeric.html. 
These two scripts will be your starting point and you will need to run them 
against your company database.

2) You can then use them as follow:

DECLARE @MaxPONumber INT;
DECLARE @AlphaPart   VARCHAR(10);

SELECT @AlphaPart = dbo.fGetAlpha(PONUMBER) FROM POP40100;

WITH MyPOs (PONUMBER) AS (
  SELECT PONUMBER FROM POP10100 UNION ALL SELECT PONUMBER FROM POP30100
)
SELECT @MaxPONumber = MAX(dbo.fGetNumber(PONUMBER)) + 1 FROM MyPOs;

UPDATE POP40100 SET PONUMBER = @AlphaPart + LEFT(REPLICATE('0', 
LEN(PONUMBER) - LEN(@AlphaPart)), LEN(PONUMBER) - LEN(@AlphaPart) - 
LEN(CONVERT(VARCHAR(20), @MaxPONumber))) + CONVERT(VARCHAR(20), 
@MaxPONumber);  

If you are having problems with the receipt numbers, you can follow the same 
logic. The table to update is the same.

Hope this helps,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com


"jc" wrote:

> Mariano,
> 
> There are approximately 5 people who enter POs on  a regular basis.  
> Currently, the POs should start at 0008xxx but lately I've seen POs start at 
> 0007xxx for no apparent reason.  The only manner in which I can see this 
> happen is if someone goes in manually to the POP screen to change the po next 
> number value.  But I've been assured that this is not happening. When this 
> issue occurs, the po next number value in the POP screen is changed from 
> 0008xxx to 0007xxx.  
> 
> I have been able to reproduce your scenario by myself.  Isn't GP not suppose 
> to use a deleted or voided PO number?  
> 
> "Mariano Gomez" wrote:
> 
> > How many people do you have entering POs? When you say 'randomly' what does 
> > this mean? I have seen cases in multi-user PO entry environments where, for 
> > example, if user A is working on PO 10, user B is working PO 11, and user C 
> > is working on PO 12, but user B cancels, void, or delete their PO, when user 
> > A attempts to enter another PO, they will still end up with 13. It will 
> > appear to user A that the PO numbers are being skipped randomly.
> > 
> > Best regards,
> > --
> > MG.-
> > Mariano Gomez, MIS, MCP, PMP
> > Maximum Global Business, LLC
> > http://www.maximumglobalbusiness.com
> > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > 
> > 
> > "jc" wrote:
> > 
> > > Bud,
> > > 
> > > Thanks for the suggestion but I still would like to know why this happens.  
> > > Has anyone asked Microsoft directly on this issue?
> > > 
> > > "Bud" wrote:
> > > 
> > > > We have a similar problem. It used to happen fairly often, but now it only 
> > > > occurs rarely. We did turn on the feature in Professional Services Tools to 
> > > > keep this from happening, so that might be the reason why it doesn't happen 
> > > > very often now. We still haven't figured out why it does every so often, 
> > > > though.
> > > > 
> > > > -- 
> > > > Bud Cool
> > > > Microsoft Certified Business Management Solutions Specialist, GP 9.0 
> > > > Financials
> > > > Currently supporting: GP 9.0, SP2
> > > > 
> > > > 
> > > > "jc" wrote:
> > > > 
> > > > > Hi Fliehigh,
> > > > > 
> > > > > I tested this and it does not work as you described below.  Ex. if I delete 
> > > > > PO number 8 and try to add a new PO, it will use the po next number in the 
> > > > > sequence.  It does not try to reuse a deleted PO number.  Are there specific 
> > > > > steps that I need to follow to delete the PO number to make this occur?  
> > > > > thanks.
> > > > > 
> > > > > "Fliehigh" wrote:
> > > > > 
> > > > > > Hi JC
> > > > > > 
> > > > > > when you say it is changing what do mean?
> > > > > > 
> > > > > > I believe that the PO numbers will go back and fill in for PO's that have 
> > > > > > been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 
> > > > > > and the one after that will be 11. I am not 100% sure but I believe this is 
> > > > > > how it works.
> > > > > > 
> > > > > > 
> > > > > > -- 
> > > > > > Fliehigh
> > > > > > 
> > > > > > 
> > > > > > "jc" wrote:
> > > > > > 
> > > > > > > Hello,
> > > > > > > The company I currently work for has been seeing the next PO number being 
> > > > > > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > > > > > try to determine the cause of this, I have turned on the activity tracking as 
> > > > > > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > > > > > or have any suggestions on how to determine what is causing this to change?  
> > > > > > > Any help would be greatly appreciated.
> > > > > > >  Thank you,
> > > > > > > JC
> > > > > > > 
0
MarianoGomez (3440)
1/29/2009 11:03:01 PM
my GP install with PSTL loaded doesn't seem to want to run today so i cannot 
look - but I think the PO Minimum Number feauture in PSTL is free.  Or so I 
think I recall it is anyway.

patrick
dev support

-- 
This posting is provided "AS IS" with no warranties, and confers no rights.


"Frank Hamelly, MCP-GP, MCT, MVP" <fhamelly@eastcoast-dynamics.com> wrote in 
message 
news:5de5035b-036a-4e87-b8f0-6c9db66d97ee@o40g2000prn.googlegroups.com...
>I have a client who is experiencing the same behavior in GP9.  Thanks
> Bud for the tip.  I'll check to see if they have PSTL and if so, have
> them turn this feature on.
>
> Frank Hamelly
> MCP-GP, MCT, MVP
> East Coast Dynamics
> www.eastcoast-dynamics.com
> blog: www.gp2themax.blogspot.com
>
> 


0
prot1 (1345)
1/30/2009 3:33:52 AM
One omission in the script:

SELECT @AlphaPart = ISNULL(dbo.fGetAlpha(PONUMBER), '') FROM POP40100;


You cannot always be sure that people have prefixes to their POs :-)

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com


"Mariano Gomez" wrote:

> jc,
> 
> This explains a lot of things! Your next PO number, in principle, should be 
> the maximum numeric portion of the next PO number + 1 in POP_Setup 
> (POP40100). Initially, GP will read the value from the POP_Setup table. THEN 
> it will ATTEMPT TO RESERVE this value, this is, making sure the next PO 
> number has not been used (the next po number is not taken at 'face value', if 
> you will).
> 
> In it's attempt to reserve the value, It will first search forward, up to 
> MAX_DOCID_RETRIES (a constant in the code with a value of 1000). If at the 
> end of this attempt to reserve a number the system is still not successful, 
> it will move backwards up to MAX_DOCID_RETRIES again. This explains why your 
> PO Numbers jump from 8,XXX to 7,XXX.
> 
> If the system finds and empty position, it "grabs" (as in reserves) that PO 
> number, incrementing the next PO number to whatever value is next from the 
> "empty" position it found. Unfortunately, this new value could have already 
> been used, hence it will repeat the check the next time someone enters a PO.
> 
> To correct this issue, you will need to find the "real" next PO number:
> 
> RUN THIS IN A TEST ENVIRONMENT FIRST, WITH NO ONE IN THE SYSTEM. IF YOU ARE 
> CONVINCED THAT IT WORKS, RUN IN PRODUCTION, WITH NO ONE IN THE SYSTEM:
> 
> 1) Copy the two scripts from my article "How to split Dynamics GP's 
> alphanumeric column values in SQL Server" at 
> http://dynamicsgpblogster.blogspot.com/2008/11/how-to-split-dynamics-gps-alphanumeric.html. 
> These two scripts will be your starting point and you will need to run them 
> against your company database.
> 
> 2) You can then use them as follow:
> 
> DECLARE @MaxPONumber INT;
> DECLARE @AlphaPart   VARCHAR(10);
> 
> SELECT @AlphaPart = dbo.fGetAlpha(PONUMBER) FROM POP40100;
> 
> WITH MyPOs (PONUMBER) AS (
>   SELECT PONUMBER FROM POP10100 UNION ALL SELECT PONUMBER FROM POP30100
> )
> SELECT @MaxPONumber = MAX(dbo.fGetNumber(PONUMBER)) + 1 FROM MyPOs;
> 
> UPDATE POP40100 SET PONUMBER = @AlphaPart + LEFT(REPLICATE('0', 
> LEN(PONUMBER) - LEN(@AlphaPart)), LEN(PONUMBER) - LEN(@AlphaPart) - 
> LEN(CONVERT(VARCHAR(20), @MaxPONumber))) + CONVERT(VARCHAR(20), 
> @MaxPONumber);  
> 
> If you are having problems with the receipt numbers, you can follow the same 
> logic. The table to update is the same.
> 
> Hope this helps,
> --
> MG.-
> Mariano Gomez, MIS, MCP, PMP
> Maximum Global Business, LLC
> http://www.maximumglobalbusiness.com
> The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> 
> 
> "jc" wrote:
> 
> > Mariano,
> > 
> > There are approximately 5 people who enter POs on  a regular basis.  
> > Currently, the POs should start at 0008xxx but lately I've seen POs start at 
> > 0007xxx for no apparent reason.  The only manner in which I can see this 
> > happen is if someone goes in manually to the POP screen to change the po next 
> > number value.  But I've been assured that this is not happening. When this 
> > issue occurs, the po next number value in the POP screen is changed from 
> > 0008xxx to 0007xxx.  
> > 
> > I have been able to reproduce your scenario by myself.  Isn't GP not suppose 
> > to use a deleted or voided PO number?  
> > 
> > "Mariano Gomez" wrote:
> > 
> > > How many people do you have entering POs? When you say 'randomly' what does 
> > > this mean? I have seen cases in multi-user PO entry environments where, for 
> > > example, if user A is working on PO 10, user B is working PO 11, and user C 
> > > is working on PO 12, but user B cancels, void, or delete their PO, when user 
> > > A attempts to enter another PO, they will still end up with 13. It will 
> > > appear to user A that the PO numbers are being skipped randomly.
> > > 
> > > Best regards,
> > > --
> > > MG.-
> > > Mariano Gomez, MIS, MCP, PMP
> > > Maximum Global Business, LLC
> > > http://www.maximumglobalbusiness.com
> > > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > > 
> > > 
> > > "jc" wrote:
> > > 
> > > > Bud,
> > > > 
> > > > Thanks for the suggestion but I still would like to know why this happens.  
> > > > Has anyone asked Microsoft directly on this issue?
> > > > 
> > > > "Bud" wrote:
> > > > 
> > > > > We have a similar problem. It used to happen fairly often, but now it only 
> > > > > occurs rarely. We did turn on the feature in Professional Services Tools to 
> > > > > keep this from happening, so that might be the reason why it doesn't happen 
> > > > > very often now. We still haven't figured out why it does every so often, 
> > > > > though.
> > > > > 
> > > > > -- 
> > > > > Bud Cool
> > > > > Microsoft Certified Business Management Solutions Specialist, GP 9.0 
> > > > > Financials
> > > > > Currently supporting: GP 9.0, SP2
> > > > > 
> > > > > 
> > > > > "jc" wrote:
> > > > > 
> > > > > > Hi Fliehigh,
> > > > > > 
> > > > > > I tested this and it does not work as you described below.  Ex. if I delete 
> > > > > > PO number 8 and try to add a new PO, it will use the po next number in the 
> > > > > > sequence.  It does not try to reuse a deleted PO number.  Are there specific 
> > > > > > steps that I need to follow to delete the PO number to make this occur?  
> > > > > > thanks.
> > > > > > 
> > > > > > "Fliehigh" wrote:
> > > > > > 
> > > > > > > Hi JC
> > > > > > > 
> > > > > > > when you say it is changing what do mean?
> > > > > > > 
> > > > > > > I believe that the PO numbers will go back and fill in for PO's that have 
> > > > > > > been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 
> > > > > > > and the one after that will be 11. I am not 100% sure but I believe this is 
> > > > > > > how it works.
> > > > > > > 
> > > > > > > 
> > > > > > > -- 
> > > > > > > Fliehigh
> > > > > > > 
> > > > > > > 
> > > > > > > "jc" wrote:
> > > > > > > 
> > > > > > > > Hello,
> > > > > > > > The company I currently work for has been seeing the next PO number being 
> > > > > > > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > > > > > > try to determine the cause of this, I have turned on the activity tracking as 
> > > > > > > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > > > > > > or have any suggestions on how to determine what is causing this to change?  
> > > > > > > > Any help would be greatly appreciated.
> > > > > > > >  Thank you,
> > > > > > > > JC
> > > > > > > > 
0
MarianoGomez (3440)
1/30/2009 1:10:14 PM
MG,

I appreciate the response that you wrote.  I'm new at this so I am still 
trying to digest all of it but one question that is puzzling me is why does 
the application choose to select 0007xxxx as the next PO number.  Why not 
select any other number(ie 0003xxxx)?  From checking the smart list, the PO 
numbers begin with 00080001.  There are no POs that start with 0007xxxx.

"Mariano Gomez" wrote:

> One omission in the script:
> 
> SELECT @AlphaPart = ISNULL(dbo.fGetAlpha(PONUMBER), '') FROM POP40100;
> 
> 
> You cannot always be sure that people have prefixes to their POs :-)
> 
> Best regards,
> --
> MG.-
> Mariano Gomez, MIS, MCP, PMP
> Maximum Global Business, LLC
> http://www.maximumglobalbusiness.com
> The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> 
> 
> "Mariano Gomez" wrote:
> 
> > jc,
> > 
> > This explains a lot of things! Your next PO number, in principle, should be 
> > the maximum numeric portion of the next PO number + 1 in POP_Setup 
> > (POP40100). Initially, GP will read the value from the POP_Setup table. THEN 
> > it will ATTEMPT TO RESERVE this value, this is, making sure the next PO 
> > number has not been used (the next po number is not taken at 'face value', if 
> > you will).
> > 
> > In it's attempt to reserve the value, It will first search forward, up to 
> > MAX_DOCID_RETRIES (a constant in the code with a value of 1000). If at the 
> > end of this attempt to reserve a number the system is still not successful, 
> > it will move backwards up to MAX_DOCID_RETRIES again. This explains why your 
> > PO Numbers jump from 8,XXX to 7,XXX.
> > 
> > If the system finds and empty position, it "grabs" (as in reserves) that PO 
> > number, incrementing the next PO number to whatever value is next from the 
> > "empty" position it found. Unfortunately, this new value could have already 
> > been used, hence it will repeat the check the next time someone enters a PO.
> > 
> > To correct this issue, you will need to find the "real" next PO number:
> > 
> > RUN THIS IN A TEST ENVIRONMENT FIRST, WITH NO ONE IN THE SYSTEM. IF YOU ARE 
> > CONVINCED THAT IT WORKS, RUN IN PRODUCTION, WITH NO ONE IN THE SYSTEM:
> > 
> > 1) Copy the two scripts from my article "How to split Dynamics GP's 
> > alphanumeric column values in SQL Server" at 
> > http://dynamicsgpblogster.blogspot.com/2008/11/how-to-split-dynamics-gps-alphanumeric.html. 
> > These two scripts will be your starting point and you will need to run them 
> > against your company database.
> > 
> > 2) You can then use them as follow:
> > 
> > DECLARE @MaxPONumber INT;
> > DECLARE @AlphaPart   VARCHAR(10);
> > 
> > SELECT @AlphaPart = dbo.fGetAlpha(PONUMBER) FROM POP40100;
> > 
> > WITH MyPOs (PONUMBER) AS (
> >   SELECT PONUMBER FROM POP10100 UNION ALL SELECT PONUMBER FROM POP30100
> > )
> > SELECT @MaxPONumber = MAX(dbo.fGetNumber(PONUMBER)) + 1 FROM MyPOs;
> > 
> > UPDATE POP40100 SET PONUMBER = @AlphaPart + LEFT(REPLICATE('0', 
> > LEN(PONUMBER) - LEN(@AlphaPart)), LEN(PONUMBER) - LEN(@AlphaPart) - 
> > LEN(CONVERT(VARCHAR(20), @MaxPONumber))) + CONVERT(VARCHAR(20), 
> > @MaxPONumber);  
> > 
> > If you are having problems with the receipt numbers, you can follow the same 
> > logic. The table to update is the same.
> > 
> > Hope this helps,
> > --
> > MG.-
> > Mariano Gomez, MIS, MCP, PMP
> > Maximum Global Business, LLC
> > http://www.maximumglobalbusiness.com
> > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > 
> > 
> > "jc" wrote:
> > 
> > > Mariano,
> > > 
> > > There are approximately 5 people who enter POs on  a regular basis.  
> > > Currently, the POs should start at 0008xxx but lately I've seen POs start at 
> > > 0007xxx for no apparent reason.  The only manner in which I can see this 
> > > happen is if someone goes in manually to the POP screen to change the po next 
> > > number value.  But I've been assured that this is not happening. When this 
> > > issue occurs, the po next number value in the POP screen is changed from 
> > > 0008xxx to 0007xxx.  
> > > 
> > > I have been able to reproduce your scenario by myself.  Isn't GP not suppose 
> > > to use a deleted or voided PO number?  
> > > 
> > > "Mariano Gomez" wrote:
> > > 
> > > > How many people do you have entering POs? When you say 'randomly' what does 
> > > > this mean? I have seen cases in multi-user PO entry environments where, for 
> > > > example, if user A is working on PO 10, user B is working PO 11, and user C 
> > > > is working on PO 12, but user B cancels, void, or delete their PO, when user 
> > > > A attempts to enter another PO, they will still end up with 13. It will 
> > > > appear to user A that the PO numbers are being skipped randomly.
> > > > 
> > > > Best regards,
> > > > --
> > > > MG.-
> > > > Mariano Gomez, MIS, MCP, PMP
> > > > Maximum Global Business, LLC
> > > > http://www.maximumglobalbusiness.com
> > > > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > > > 
> > > > 
> > > > "jc" wrote:
> > > > 
> > > > > Bud,
> > > > > 
> > > > > Thanks for the suggestion but I still would like to know why this happens.  
> > > > > Has anyone asked Microsoft directly on this issue?
> > > > > 
> > > > > "Bud" wrote:
> > > > > 
> > > > > > We have a similar problem. It used to happen fairly often, but now it only 
> > > > > > occurs rarely. We did turn on the feature in Professional Services Tools to 
> > > > > > keep this from happening, so that might be the reason why it doesn't happen 
> > > > > > very often now. We still haven't figured out why it does every so often, 
> > > > > > though.
> > > > > > 
> > > > > > -- 
> > > > > > Bud Cool
> > > > > > Microsoft Certified Business Management Solutions Specialist, GP 9.0 
> > > > > > Financials
> > > > > > Currently supporting: GP 9.0, SP2
> > > > > > 
> > > > > > 
> > > > > > "jc" wrote:
> > > > > > 
> > > > > > > Hi Fliehigh,
> > > > > > > 
> > > > > > > I tested this and it does not work as you described below.  Ex. if I delete 
> > > > > > > PO number 8 and try to add a new PO, it will use the po next number in the 
> > > > > > > sequence.  It does not try to reuse a deleted PO number.  Are there specific 
> > > > > > > steps that I need to follow to delete the PO number to make this occur?  
> > > > > > > thanks.
> > > > > > > 
> > > > > > > "Fliehigh" wrote:
> > > > > > > 
> > > > > > > > Hi JC
> > > > > > > > 
> > > > > > > > when you say it is changing what do mean?
> > > > > > > > 
> > > > > > > > I believe that the PO numbers will go back and fill in for PO's that have 
> > > > > > > > been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 
> > > > > > > > and the one after that will be 11. I am not 100% sure but I believe this is 
> > > > > > > > how it works.
> > > > > > > > 
> > > > > > > > 
> > > > > > > > -- 
> > > > > > > > Fliehigh
> > > > > > > > 
> > > > > > > > 
> > > > > > > > "jc" wrote:
> > > > > > > > 
> > > > > > > > > Hello,
> > > > > > > > > The company I currently work for has been seeing the next PO number being 
> > > > > > > > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > > > > > > > try to determine the cause of this, I have turned on the activity tracking as 
> > > > > > > > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > > > > > > > or have any suggestions on how to determine what is causing this to change?  
> > > > > > > > > Any help would be greatly appreciated.
> > > > > > > > >  Thank you,
> > > > > > > > > JC
> > > > > > > > > 
0
jc1 (91)
1/30/2009 2:10:00 PM
Tim,

I would agree with you but I am not able to reproduce this in any of the PO 
screens.  The only place that I know of that you are able to change the next 
PO number is the purchase order processing setup screen.  If you know of 
another screen where the next PO number can be changed please share this with 
me.  

"Tim Foster" wrote:

> This is a "feature".  When one of your purchasing people types a PO number to 
> change something and "fat fingers" it, GP changes the master number.  No 
> matter how many times I tell them to use the LookUp they will not.  We've 
> been dealing with it since V8.  The PSTL tool works.
> -- 
> Tim Foster
> 
> 
> "jc" wrote:
> 
> > Hello,
> > The company I currently work for has been seeing the next PO number being 
> > changed in the purchase order processing screen.  This occurs randomly.  To 
> > try to determine the cause of this, I have turned on the activity tracking as 
> > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > or have any suggestions on how to determine what is causing this to change?  
> > Any help would be greatly appreciated.
> >  Thank you,
> > JC
> > 
0
jc1 (91)
1/30/2009 2:13:01 PM
The 'next' PO Number can be changed at the PO Entry Screen.  We use numeric 
PO Numbers.  Say the next PO is 754300.  The User Types 745300 and tab.  The 
Master number will change.  The PSTL Minimum PO number tool helps prevent 
this.

-- 
Tim Foster


"jc" wrote:

> Tim,
> 
> I would agree with you but I am not able to reproduce this in any of the PO 
> screens.  The only place that I know of that you are able to change the next 
> PO number is the purchase order processing setup screen.  If you know of 
> another screen where the next PO number can be changed please share this with 
> me.  
> 
> "Tim Foster" wrote:
> 
> > This is a "feature".  When one of your purchasing people types a PO number to 
> > change something and "fat fingers" it, GP changes the master number.  No 
> > matter how many times I tell them to use the LookUp they will not.  We've 
> > been dealing with it since V8.  The PSTL tool works.
> > -- 
> > Tim Foster
> > 
> > 
> > "jc" wrote:
> > 
> > > Hello,
> > > The company I currently work for has been seeing the next PO number being 
> > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > try to determine the cause of this, I have turned on the activity tracking as 
> > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > or have any suggestions on how to determine what is causing this to change?  
> > > Any help would be greatly appreciated.
> > >  Thank you,
> > > JC
> > > 
0
tfoster (136)
1/30/2009 8:24:00 PM
Thanks for the clarification but even though I change the PO number there, it 
does not change it in the POP setup screen.  As far as I can tell, it is the 
next PO number here that will determine what the PO number will be in the PO 
entry screen.  

"Tim Foster" wrote:

> The 'next' PO Number can be changed at the PO Entry Screen.  We use numeric 
> PO Numbers.  Say the next PO is 754300.  The User Types 745300 and tab.  The 
> Master number will change.  The PSTL Minimum PO number tool helps prevent 
> this.
> 
> -- 
> Tim Foster
> 
> 
> "jc" wrote:
> 
> > Tim,
> > 
> > I would agree with you but I am not able to reproduce this in any of the PO 
> > screens.  The only place that I know of that you are able to change the next 
> > PO number is the purchase order processing setup screen.  If you know of 
> > another screen where the next PO number can be changed please share this with 
> > me.  
> > 
> > "Tim Foster" wrote:
> > 
> > > This is a "feature".  When one of your purchasing people types a PO number to 
> > > change something and "fat fingers" it, GP changes the master number.  No 
> > > matter how many times I tell them to use the LookUp they will not.  We've 
> > > been dealing with it since V8.  The PSTL tool works.
> > > -- 
> > > Tim Foster
> > > 
> > > 
> > > "jc" wrote:
> > > 
> > > > Hello,
> > > > The company I currently work for has been seeing the next PO number being 
> > > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > > try to determine the cause of this, I have turned on the activity tracking as 
> > > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > > or have any suggestions on how to determine what is causing this to change?  
> > > > Any help would be greatly appreciated.
> > > >  Thank you,
> > > > JC
> > > > 
0
jc1 (91)
1/30/2009 8:48:03 PM
It selects the 0007xxxx number series BECAUSE there are no POs with those 
numbers.  It is trying to find un-used numbers.

-- 
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at 
http://www.AccoladePublications.com



"jc" wrote:

> MG,
> 
> I appreciate the response that you wrote.  I'm new at this so I am still 
> trying to digest all of it but one question that is puzzling me is why does 
> the application choose to select 0007xxxx as the next PO number.  Why not 
> select any other number(ie 0003xxxx)?  From checking the smart list, the PO 
> numbers begin with 00080001.  There are no POs that start with 0007xxxx.
> 
> "Mariano Gomez" wrote:
> 
> > One omission in the script:
> > 
> > SELECT @AlphaPart = ISNULL(dbo.fGetAlpha(PONUMBER), '') FROM POP40100;
> > 
> > 
> > You cannot always be sure that people have prefixes to their POs :-)
> > 
> > Best regards,
> > --
> > MG.-
> > Mariano Gomez, MIS, MCP, PMP
> > Maximum Global Business, LLC
> > http://www.maximumglobalbusiness.com
> > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > 
> > 
> > "Mariano Gomez" wrote:
> > 
> > > jc,
> > > 
> > > This explains a lot of things! Your next PO number, in principle, should be 
> > > the maximum numeric portion of the next PO number + 1 in POP_Setup 
> > > (POP40100). Initially, GP will read the value from the POP_Setup table. THEN 
> > > it will ATTEMPT TO RESERVE this value, this is, making sure the next PO 
> > > number has not been used (the next po number is not taken at 'face value', if 
> > > you will).
> > > 
> > > In it's attempt to reserve the value, It will first search forward, up to 
> > > MAX_DOCID_RETRIES (a constant in the code with a value of 1000). If at the 
> > > end of this attempt to reserve a number the system is still not successful, 
> > > it will move backwards up to MAX_DOCID_RETRIES again. This explains why your 
> > > PO Numbers jump from 8,XXX to 7,XXX.
> > > 
> > > If the system finds and empty position, it "grabs" (as in reserves) that PO 
> > > number, incrementing the next PO number to whatever value is next from the 
> > > "empty" position it found. Unfortunately, this new value could have already 
> > > been used, hence it will repeat the check the next time someone enters a PO.
> > > 
> > > To correct this issue, you will need to find the "real" next PO number:
> > > 
> > > RUN THIS IN A TEST ENVIRONMENT FIRST, WITH NO ONE IN THE SYSTEM. IF YOU ARE 
> > > CONVINCED THAT IT WORKS, RUN IN PRODUCTION, WITH NO ONE IN THE SYSTEM:
> > > 
> > > 1) Copy the two scripts from my article "How to split Dynamics GP's 
> > > alphanumeric column values in SQL Server" at 
> > > http://dynamicsgpblogster.blogspot.com/2008/11/how-to-split-dynamics-gps-alphanumeric.html. 
> > > These two scripts will be your starting point and you will need to run them 
> > > against your company database.
> > > 
> > > 2) You can then use them as follow:
> > > 
> > > DECLARE @MaxPONumber INT;
> > > DECLARE @AlphaPart   VARCHAR(10);
> > > 
> > > SELECT @AlphaPart = dbo.fGetAlpha(PONUMBER) FROM POP40100;
> > > 
> > > WITH MyPOs (PONUMBER) AS (
> > >   SELECT PONUMBER FROM POP10100 UNION ALL SELECT PONUMBER FROM POP30100
> > > )
> > > SELECT @MaxPONumber = MAX(dbo.fGetNumber(PONUMBER)) + 1 FROM MyPOs;
> > > 
> > > UPDATE POP40100 SET PONUMBER = @AlphaPart + LEFT(REPLICATE('0', 
> > > LEN(PONUMBER) - LEN(@AlphaPart)), LEN(PONUMBER) - LEN(@AlphaPart) - 
> > > LEN(CONVERT(VARCHAR(20), @MaxPONumber))) + CONVERT(VARCHAR(20), 
> > > @MaxPONumber);  
> > > 
> > > If you are having problems with the receipt numbers, you can follow the same 
> > > logic. The table to update is the same.
> > > 
> > > Hope this helps,
> > > --
> > > MG.-
> > > Mariano Gomez, MIS, MCP, PMP
> > > Maximum Global Business, LLC
> > > http://www.maximumglobalbusiness.com
> > > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > > 
> > > 
> > > "jc" wrote:
> > > 
> > > > Mariano,
> > > > 
> > > > There are approximately 5 people who enter POs on  a regular basis.  
> > > > Currently, the POs should start at 0008xxx but lately I've seen POs start at 
> > > > 0007xxx for no apparent reason.  The only manner in which I can see this 
> > > > happen is if someone goes in manually to the POP screen to change the po next 
> > > > number value.  But I've been assured that this is not happening. When this 
> > > > issue occurs, the po next number value in the POP screen is changed from 
> > > > 0008xxx to 0007xxx.  
> > > > 
> > > > I have been able to reproduce your scenario by myself.  Isn't GP not suppose 
> > > > to use a deleted or voided PO number?  
> > > > 
> > > > "Mariano Gomez" wrote:
> > > > 
> > > > > How many people do you have entering POs? When you say 'randomly' what does 
> > > > > this mean? I have seen cases in multi-user PO entry environments where, for 
> > > > > example, if user A is working on PO 10, user B is working PO 11, and user C 
> > > > > is working on PO 12, but user B cancels, void, or delete their PO, when user 
> > > > > A attempts to enter another PO, they will still end up with 13. It will 
> > > > > appear to user A that the PO numbers are being skipped randomly.
> > > > > 
> > > > > Best regards,
> > > > > --
> > > > > MG.-
> > > > > Mariano Gomez, MIS, MCP, PMP
> > > > > Maximum Global Business, LLC
> > > > > http://www.maximumglobalbusiness.com
> > > > > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > > > > 
> > > > > 
> > > > > "jc" wrote:
> > > > > 
> > > > > > Bud,
> > > > > > 
> > > > > > Thanks for the suggestion but I still would like to know why this happens.  
> > > > > > Has anyone asked Microsoft directly on this issue?
> > > > > > 
> > > > > > "Bud" wrote:
> > > > > > 
> > > > > > > We have a similar problem. It used to happen fairly often, but now it only 
> > > > > > > occurs rarely. We did turn on the feature in Professional Services Tools to 
> > > > > > > keep this from happening, so that might be the reason why it doesn't happen 
> > > > > > > very often now. We still haven't figured out why it does every so often, 
> > > > > > > though.
> > > > > > > 
> > > > > > > -- 
> > > > > > > Bud Cool
> > > > > > > Microsoft Certified Business Management Solutions Specialist, GP 9.0 
> > > > > > > Financials
> > > > > > > Currently supporting: GP 9.0, SP2
> > > > > > > 
> > > > > > > 
> > > > > > > "jc" wrote:
> > > > > > > 
> > > > > > > > Hi Fliehigh,
> > > > > > > > 
> > > > > > > > I tested this and it does not work as you described below.  Ex. if I delete 
> > > > > > > > PO number 8 and try to add a new PO, it will use the po next number in the 
> > > > > > > > sequence.  It does not try to reuse a deleted PO number.  Are there specific 
> > > > > > > > steps that I need to follow to delete the PO number to make this occur?  
> > > > > > > > thanks.
> > > > > > > > 
> > > > > > > > "Fliehigh" wrote:
> > > > > > > > 
> > > > > > > > > Hi JC
> > > > > > > > > 
> > > > > > > > > when you say it is changing what do mean?
> > > > > > > > > 
> > > > > > > > > I believe that the PO numbers will go back and fill in for PO's that have 
> > > > > > > > > been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 
> > > > > > > > > and the one after that will be 11. I am not 100% sure but I believe this is 
> > > > > > > > > how it works.
> > > > > > > > > 
> > > > > > > > > 
> > > > > > > > > -- 
> > > > > > > > > Fliehigh
> > > > > > > > > 
> > > > > > > > > 
> > > > > > > > > "jc" wrote:
> > > > > > > > > 
> > > > > > > > > > Hello,
> > > > > > > > > > The company I currently work for has been seeing the next PO number being 
> > > > > > > > > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > > > > > > > > try to determine the cause of this, I have turned on the activity tracking as 
> > > > > > > > > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > > > > > > > > or have any suggestions on how to determine what is causing this to change?  
> > > > > > > > > > Any help would be greatly appreciated.
> > > > > > > > > >  Thank you,
> > > > > > > > > > JC
> > > > > > > > > > 
0
info4071 (3004)
1/31/2009 10:10:01 PM
I'm not trying to be difficult but trying to wrap my head around this issue.  
Why not select 0006xxxx or 0005xxxx etc.?

"Richard Whaley -- MVP 2006-2008" wrote:

> It selects the 0007xxxx number series BECAUSE there are no POs with those 
> numbers.  It is trying to find un-used numbers.
> 
> -- 
> Richard L. Whaley
> Author / Consultant / MVP 2006-2008
> Documentation for Software Users
> 
> Get our Free Tips and Tricks Newsletter and check out our books at 
> http://www.AccoladePublications.com
> 
> 
> 
> "jc" wrote:
> 
> > MG,
> > 
> > I appreciate the response that you wrote.  I'm new at this so I am still 
> > trying to digest all of it but one question that is puzzling me is why does 
> > the application choose to select 0007xxxx as the next PO number.  Why not 
> > select any other number(ie 0003xxxx)?  From checking the smart list, the PO 
> > numbers begin with 00080001.  There are no POs that start with 0007xxxx.
> > 
> > "Mariano Gomez" wrote:
> > 
> > > One omission in the script:
> > > 
> > > SELECT @AlphaPart = ISNULL(dbo.fGetAlpha(PONUMBER), '') FROM POP40100;
> > > 
> > > 
> > > You cannot always be sure that people have prefixes to their POs :-)
> > > 
> > > Best regards,
> > > --
> > > MG.-
> > > Mariano Gomez, MIS, MCP, PMP
> > > Maximum Global Business, LLC
> > > http://www.maximumglobalbusiness.com
> > > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > > 
> > > 
> > > "Mariano Gomez" wrote:
> > > 
> > > > jc,
> > > > 
> > > > This explains a lot of things! Your next PO number, in principle, should be 
> > > > the maximum numeric portion of the next PO number + 1 in POP_Setup 
> > > > (POP40100). Initially, GP will read the value from the POP_Setup table. THEN 
> > > > it will ATTEMPT TO RESERVE this value, this is, making sure the next PO 
> > > > number has not been used (the next po number is not taken at 'face value', if 
> > > > you will).
> > > > 
> > > > In it's attempt to reserve the value, It will first search forward, up to 
> > > > MAX_DOCID_RETRIES (a constant in the code with a value of 1000). If at the 
> > > > end of this attempt to reserve a number the system is still not successful, 
> > > > it will move backwards up to MAX_DOCID_RETRIES again. This explains why your 
> > > > PO Numbers jump from 8,XXX to 7,XXX.
> > > > 
> > > > If the system finds and empty position, it "grabs" (as in reserves) that PO 
> > > > number, incrementing the next PO number to whatever value is next from the 
> > > > "empty" position it found. Unfortunately, this new value could have already 
> > > > been used, hence it will repeat the check the next time someone enters a PO.
> > > > 
> > > > To correct this issue, you will need to find the "real" next PO number:
> > > > 
> > > > RUN THIS IN A TEST ENVIRONMENT FIRST, WITH NO ONE IN THE SYSTEM. IF YOU ARE 
> > > > CONVINCED THAT IT WORKS, RUN IN PRODUCTION, WITH NO ONE IN THE SYSTEM:
> > > > 
> > > > 1) Copy the two scripts from my article "How to split Dynamics GP's 
> > > > alphanumeric column values in SQL Server" at 
> > > > http://dynamicsgpblogster.blogspot.com/2008/11/how-to-split-dynamics-gps-alphanumeric.html. 
> > > > These two scripts will be your starting point and you will need to run them 
> > > > against your company database.
> > > > 
> > > > 2) You can then use them as follow:
> > > > 
> > > > DECLARE @MaxPONumber INT;
> > > > DECLARE @AlphaPart   VARCHAR(10);
> > > > 
> > > > SELECT @AlphaPart = dbo.fGetAlpha(PONUMBER) FROM POP40100;
> > > > 
> > > > WITH MyPOs (PONUMBER) AS (
> > > >   SELECT PONUMBER FROM POP10100 UNION ALL SELECT PONUMBER FROM POP30100
> > > > )
> > > > SELECT @MaxPONumber = MAX(dbo.fGetNumber(PONUMBER)) + 1 FROM MyPOs;
> > > > 
> > > > UPDATE POP40100 SET PONUMBER = @AlphaPart + LEFT(REPLICATE('0', 
> > > > LEN(PONUMBER) - LEN(@AlphaPart)), LEN(PONUMBER) - LEN(@AlphaPart) - 
> > > > LEN(CONVERT(VARCHAR(20), @MaxPONumber))) + CONVERT(VARCHAR(20), 
> > > > @MaxPONumber);  
> > > > 
> > > > If you are having problems with the receipt numbers, you can follow the same 
> > > > logic. The table to update is the same.
> > > > 
> > > > Hope this helps,
> > > > --
> > > > MG.-
> > > > Mariano Gomez, MIS, MCP, PMP
> > > > Maximum Global Business, LLC
> > > > http://www.maximumglobalbusiness.com
> > > > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > > > 
> > > > 
> > > > "jc" wrote:
> > > > 
> > > > > Mariano,
> > > > > 
> > > > > There are approximately 5 people who enter POs on  a regular basis.  
> > > > > Currently, the POs should start at 0008xxx but lately I've seen POs start at 
> > > > > 0007xxx for no apparent reason.  The only manner in which I can see this 
> > > > > happen is if someone goes in manually to the POP screen to change the po next 
> > > > > number value.  But I've been assured that this is not happening. When this 
> > > > > issue occurs, the po next number value in the POP screen is changed from 
> > > > > 0008xxx to 0007xxx.  
> > > > > 
> > > > > I have been able to reproduce your scenario by myself.  Isn't GP not suppose 
> > > > > to use a deleted or voided PO number?  
> > > > > 
> > > > > "Mariano Gomez" wrote:
> > > > > 
> > > > > > How many people do you have entering POs? When you say 'randomly' what does 
> > > > > > this mean? I have seen cases in multi-user PO entry environments where, for 
> > > > > > example, if user A is working on PO 10, user B is working PO 11, and user C 
> > > > > > is working on PO 12, but user B cancels, void, or delete their PO, when user 
> > > > > > A attempts to enter another PO, they will still end up with 13. It will 
> > > > > > appear to user A that the PO numbers are being skipped randomly.
> > > > > > 
> > > > > > Best regards,
> > > > > > --
> > > > > > MG.-
> > > > > > Mariano Gomez, MIS, MCP, PMP
> > > > > > Maximum Global Business, LLC
> > > > > > http://www.maximumglobalbusiness.com
> > > > > > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > > > > > 
> > > > > > 
> > > > > > "jc" wrote:
> > > > > > 
> > > > > > > Bud,
> > > > > > > 
> > > > > > > Thanks for the suggestion but I still would like to know why this happens.  
> > > > > > > Has anyone asked Microsoft directly on this issue?
> > > > > > > 
> > > > > > > "Bud" wrote:
> > > > > > > 
> > > > > > > > We have a similar problem. It used to happen fairly often, but now it only 
> > > > > > > > occurs rarely. We did turn on the feature in Professional Services Tools to 
> > > > > > > > keep this from happening, so that might be the reason why it doesn't happen 
> > > > > > > > very often now. We still haven't figured out why it does every so often, 
> > > > > > > > though.
> > > > > > > > 
> > > > > > > > -- 
> > > > > > > > Bud Cool
> > > > > > > > Microsoft Certified Business Management Solutions Specialist, GP 9.0 
> > > > > > > > Financials
> > > > > > > > Currently supporting: GP 9.0, SP2
> > > > > > > > 
> > > > > > > > 
> > > > > > > > "jc" wrote:
> > > > > > > > 
> > > > > > > > > Hi Fliehigh,
> > > > > > > > > 
> > > > > > > > > I tested this and it does not work as you described below.  Ex. if I delete 
> > > > > > > > > PO number 8 and try to add a new PO, it will use the po next number in the 
> > > > > > > > > sequence.  It does not try to reuse a deleted PO number.  Are there specific 
> > > > > > > > > steps that I need to follow to delete the PO number to make this occur?  
> > > > > > > > > thanks.
> > > > > > > > > 
> > > > > > > > > "Fliehigh" wrote:
> > > > > > > > > 
> > > > > > > > > > Hi JC
> > > > > > > > > > 
> > > > > > > > > > when you say it is changing what do mean?
> > > > > > > > > > 
> > > > > > > > > > I believe that the PO numbers will go back and fill in for PO's that have 
> > > > > > > > > > been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 
> > > > > > > > > > and the one after that will be 11. I am not 100% sure but I believe this is 
> > > > > > > > > > how it works.
> > > > > > > > > > 
> > > > > > > > > > 
> > > > > > > > > > -- 
> > > > > > > > > > Fliehigh
> > > > > > > > > > 
> > > > > > > > > > 
> > > > > > > > > > "jc" wrote:
> > > > > > > > > > 
> > > > > > > > > > > Hello,
> > > > > > > > > > > The company I currently work for has been seeing the next PO number being 
> > > > > > > > > > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > > > > > > > > > try to determine the cause of this, I have turned on the activity tracking as 
> > > > > > > > > > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > > > > > > > > > or have any suggestions on how to determine what is causing this to change?  
> > > > > > > > > > > Any help would be greatly appreciated.
> > > > > > > > > > >  Thank you,
> > > > > > > > > > > JC
> > > > > > > > > > > 
0
jc1 (91)
2/2/2009 1:27:02 PM
BECAUSE it already reserved a PO number in the 7xxx range! As well, keep in 
mind that the code only does so many attempts. I have created an article 
based on your question on this issue at 
http://dynamicsgpblogster.blogspot.com/2009/01/why-does-my-next-document-number-change.html

Hope this helps!
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com


"jc" wrote:

> I'm not trying to be difficult but trying to wrap my head around this issue.  
> Why not select 0006xxxx or 0005xxxx etc.?
> 
> "Richard Whaley -- MVP 2006-2008" wrote:
> 
> > It selects the 0007xxxx number series BECAUSE there are no POs with those 
> > numbers.  It is trying to find un-used numbers.
> > 
> > -- 
> > Richard L. Whaley
> > Author / Consultant / MVP 2006-2008
> > Documentation for Software Users
> > 
> > Get our Free Tips and Tricks Newsletter and check out our books at 
> > http://www.AccoladePublications.com
> > 
> > 
> > 
> > "jc" wrote:
> > 
> > > MG,
> > > 
> > > I appreciate the response that you wrote.  I'm new at this so I am still 
> > > trying to digest all of it but one question that is puzzling me is why does 
> > > the application choose to select 0007xxxx as the next PO number.  Why not 
> > > select any other number(ie 0003xxxx)?  From checking the smart list, the PO 
> > > numbers begin with 00080001.  There are no POs that start with 0007xxxx.
> > > 
> > > "Mariano Gomez" wrote:
> > > 
> > > > One omission in the script:
> > > > 
> > > > SELECT @AlphaPart = ISNULL(dbo.fGetAlpha(PONUMBER), '') FROM POP40100;
> > > > 
> > > > 
> > > > You cannot always be sure that people have prefixes to their POs :-)
> > > > 
> > > > Best regards,
> > > > --
> > > > MG.-
> > > > Mariano Gomez, MIS, MCP, PMP
> > > > Maximum Global Business, LLC
> > > > http://www.maximumglobalbusiness.com
> > > > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > > > 
> > > > 
> > > > "Mariano Gomez" wrote:
> > > > 
> > > > > jc,
> > > > > 
> > > > > This explains a lot of things! Your next PO number, in principle, should be 
> > > > > the maximum numeric portion of the next PO number + 1 in POP_Setup 
> > > > > (POP40100). Initially, GP will read the value from the POP_Setup table. THEN 
> > > > > it will ATTEMPT TO RESERVE this value, this is, making sure the next PO 
> > > > > number has not been used (the next po number is not taken at 'face value', if 
> > > > > you will).
> > > > > 
> > > > > In it's attempt to reserve the value, It will first search forward, up to 
> > > > > MAX_DOCID_RETRIES (a constant in the code with a value of 1000). If at the 
> > > > > end of this attempt to reserve a number the system is still not successful, 
> > > > > it will move backwards up to MAX_DOCID_RETRIES again. This explains why your 
> > > > > PO Numbers jump from 8,XXX to 7,XXX.
> > > > > 
> > > > > If the system finds and empty position, it "grabs" (as in reserves) that PO 
> > > > > number, incrementing the next PO number to whatever value is next from the 
> > > > > "empty" position it found. Unfortunately, this new value could have already 
> > > > > been used, hence it will repeat the check the next time someone enters a PO.
> > > > > 
> > > > > To correct this issue, you will need to find the "real" next PO number:
> > > > > 
> > > > > RUN THIS IN A TEST ENVIRONMENT FIRST, WITH NO ONE IN THE SYSTEM. IF YOU ARE 
> > > > > CONVINCED THAT IT WORKS, RUN IN PRODUCTION, WITH NO ONE IN THE SYSTEM:
> > > > > 
> > > > > 1) Copy the two scripts from my article "How to split Dynamics GP's 
> > > > > alphanumeric column values in SQL Server" at 
> > > > > http://dynamicsgpblogster.blogspot.com/2008/11/how-to-split-dynamics-gps-alphanumeric.html. 
> > > > > These two scripts will be your starting point and you will need to run them 
> > > > > against your company database.
> > > > > 
> > > > > 2) You can then use them as follow:
> > > > > 
> > > > > DECLARE @MaxPONumber INT;
> > > > > DECLARE @AlphaPart   VARCHAR(10);
> > > > > 
> > > > > SELECT @AlphaPart = dbo.fGetAlpha(PONUMBER) FROM POP40100;
> > > > > 
> > > > > WITH MyPOs (PONUMBER) AS (
> > > > >   SELECT PONUMBER FROM POP10100 UNION ALL SELECT PONUMBER FROM POP30100
> > > > > )
> > > > > SELECT @MaxPONumber = MAX(dbo.fGetNumber(PONUMBER)) + 1 FROM MyPOs;
> > > > > 
> > > > > UPDATE POP40100 SET PONUMBER = @AlphaPart + LEFT(REPLICATE('0', 
> > > > > LEN(PONUMBER) - LEN(@AlphaPart)), LEN(PONUMBER) - LEN(@AlphaPart) - 
> > > > > LEN(CONVERT(VARCHAR(20), @MaxPONumber))) + CONVERT(VARCHAR(20), 
> > > > > @MaxPONumber);  
> > > > > 
> > > > > If you are having problems with the receipt numbers, you can follow the same 
> > > > > logic. The table to update is the same.
> > > > > 
> > > > > Hope this helps,
> > > > > --
> > > > > MG.-
> > > > > Mariano Gomez, MIS, MCP, PMP
> > > > > Maximum Global Business, LLC
> > > > > http://www.maximumglobalbusiness.com
> > > > > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > > > > 
> > > > > 
> > > > > "jc" wrote:
> > > > > 
> > > > > > Mariano,
> > > > > > 
> > > > > > There are approximately 5 people who enter POs on  a regular basis.  
> > > > > > Currently, the POs should start at 0008xxx but lately I've seen POs start at 
> > > > > > 0007xxx for no apparent reason.  The only manner in which I can see this 
> > > > > > happen is if someone goes in manually to the POP screen to change the po next 
> > > > > > number value.  But I've been assured that this is not happening. When this 
> > > > > > issue occurs, the po next number value in the POP screen is changed from 
> > > > > > 0008xxx to 0007xxx.  
> > > > > > 
> > > > > > I have been able to reproduce your scenario by myself.  Isn't GP not suppose 
> > > > > > to use a deleted or voided PO number?  
> > > > > > 
> > > > > > "Mariano Gomez" wrote:
> > > > > > 
> > > > > > > How many people do you have entering POs? When you say 'randomly' what does 
> > > > > > > this mean? I have seen cases in multi-user PO entry environments where, for 
> > > > > > > example, if user A is working on PO 10, user B is working PO 11, and user C 
> > > > > > > is working on PO 12, but user B cancels, void, or delete their PO, when user 
> > > > > > > A attempts to enter another PO, they will still end up with 13. It will 
> > > > > > > appear to user A that the PO numbers are being skipped randomly.
> > > > > > > 
> > > > > > > Best regards,
> > > > > > > --
> > > > > > > MG.-
> > > > > > > Mariano Gomez, MIS, MCP, PMP
> > > > > > > Maximum Global Business, LLC
> > > > > > > http://www.maximumglobalbusiness.com
> > > > > > > The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> > > > > > > 
> > > > > > > 
> > > > > > > "jc" wrote:
> > > > > > > 
> > > > > > > > Bud,
> > > > > > > > 
> > > > > > > > Thanks for the suggestion but I still would like to know why this happens.  
> > > > > > > > Has anyone asked Microsoft directly on this issue?
> > > > > > > > 
> > > > > > > > "Bud" wrote:
> > > > > > > > 
> > > > > > > > > We have a similar problem. It used to happen fairly often, but now it only 
> > > > > > > > > occurs rarely. We did turn on the feature in Professional Services Tools to 
> > > > > > > > > keep this from happening, so that might be the reason why it doesn't happen 
> > > > > > > > > very often now. We still haven't figured out why it does every so often, 
> > > > > > > > > though.
> > > > > > > > > 
> > > > > > > > > -- 
> > > > > > > > > Bud Cool
> > > > > > > > > Microsoft Certified Business Management Solutions Specialist, GP 9.0 
> > > > > > > > > Financials
> > > > > > > > > Currently supporting: GP 9.0, SP2
> > > > > > > > > 
> > > > > > > > > 
> > > > > > > > > "jc" wrote:
> > > > > > > > > 
> > > > > > > > > > Hi Fliehigh,
> > > > > > > > > > 
> > > > > > > > > > I tested this and it does not work as you described below.  Ex. if I delete 
> > > > > > > > > > PO number 8 and try to add a new PO, it will use the po next number in the 
> > > > > > > > > > sequence.  It does not try to reuse a deleted PO number.  Are there specific 
> > > > > > > > > > steps that I need to follow to delete the PO number to make this occur?  
> > > > > > > > > > thanks.
> > > > > > > > > > 
> > > > > > > > > > "Fliehigh" wrote:
> > > > > > > > > > 
> > > > > > > > > > > Hi JC
> > > > > > > > > > > 
> > > > > > > > > > > when you say it is changing what do mean?
> > > > > > > > > > > 
> > > > > > > > > > > I believe that the PO numbers will go back and fill in for PO's that have 
> > > > > > > > > > > been deleted. I.E. if you PO's 1-10 and delete 8 then the next PO will be 8 
> > > > > > > > > > > and the one after that will be 11. I am not 100% sure but I believe this is 
> > > > > > > > > > > how it works.
> > > > > > > > > > > 
> > > > > > > > > > > 
> > > > > > > > > > > -- 
> > > > > > > > > > > Fliehigh
> > > > > > > > > > > 
> > > > > > > > > > > 
> > > > > > > > > > > "jc" wrote:
> > > > > > > > > > > 
> > > > > > > > > > > > Hello,
> > > > > > > > > > > > The company I currently work for has been seeing the next PO number being 
> > > > > > > > > > > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > > > > > > > > > > try to determine the cause of this, I have turned on the activity tracking as 
> > > > > > > > > > > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > > > > > > > > > > or have any suggestions on how to determine what is causing this to change?  
> > > > > > > > > > > > Any help would be greatly appreciated.
> > > > > > > > > > > >  Thank you,
> > > > > > > > > > > > JC
> > > > > > > > > > > > 
0
MarianoGomez (3440)
2/2/2009 3:20:01 PM
I just want to thank everyone for their help on this issue and wanted to 
share some additional findings that may help others.  I was able to reproduce 
this issue by using the steps below.
1.  Enter in an invalid PO number in the PO entry screen 
2.  click tab 
3.  Click on actions > delete 
4.  Check the next PO number in the POP setup screen 
5.  You should see the next PO number to be the same as the invalid PO 
number that was entered in step 1

I was able to reproduce this using the sample company, Fabrikam, and 
reported this to MS support and waiting on feedback from them.

"jc" wrote:

> Thanks for the clarification but even though I change the PO number there, it 
> does not change it in the POP setup screen.  As far as I can tell, it is the 
> next PO number here that will determine what the PO number will be in the PO 
> entry screen.  
> 
> "Tim Foster" wrote:
> 
> > The 'next' PO Number can be changed at the PO Entry Screen.  We use numeric 
> > PO Numbers.  Say the next PO is 754300.  The User Types 745300 and tab.  The 
> > Master number will change.  The PSTL Minimum PO number tool helps prevent 
> > this.
> > 
> > -- 
> > Tim Foster
> > 
> > 
> > "jc" wrote:
> > 
> > > Tim,
> > > 
> > > I would agree with you but I am not able to reproduce this in any of the PO 
> > > screens.  The only place that I know of that you are able to change the next 
> > > PO number is the purchase order processing setup screen.  If you know of 
> > > another screen where the next PO number can be changed please share this with 
> > > me.  
> > > 
> > > "Tim Foster" wrote:
> > > 
> > > > This is a "feature".  When one of your purchasing people types a PO number to 
> > > > change something and "fat fingers" it, GP changes the master number.  No 
> > > > matter how many times I tell them to use the LookUp they will not.  We've 
> > > > been dealing with it since V8.  The PSTL tool works.
> > > > -- 
> > > > Tim Foster
> > > > 
> > > > 
> > > > "jc" wrote:
> > > > 
> > > > > Hello,
> > > > > The company I currently work for has been seeing the next PO number being 
> > > > > changed in the purchase order processing screen.  This occurs randomly.  To 
> > > > > try to determine the cause of this, I have turned on the activity tracking as 
> > > > > well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> > > > > or have any suggestions on how to determine what is causing this to change?  
> > > > > Any help would be greatly appreciated.
> > > > >  Thank you,
> > > > > JC
> > > > > 
0
jc1 (91)
2/12/2009 3:34:52 PM
We actually had the same problem, it is caused by a user that incorrectly 
enters a Po number in the Po number field and that resets the numbering 
sequence. The only way we found to stop this bug is to put field level 
security on the Po number field and forcing the users to use the look up to 
recall existing POs, since then no more troubles.

"jc" wrote:

> Hello,
> The company I currently work for has been seeing the next PO number being 
> changed in the purchase order processing screen.  This occurs randomly.  To 
> try to determine the cause of this, I have turned on the activity tracking as 
> well as sql triggers on the pop40100 table.  Has anyone else seen this before 
> or have any suggestions on how to determine what is causing this to change?  
> Any help would be greatly appreciated.
>  Thank you,
> JC
> 
0
9/25/2009 7:38:01 PM
Reply:

Similar Artilces:

How do I retrieve changes to an unsaved excel document
I closed a excel document without saving changes. Is there a way to retrieve my old worksheet which would have the changes I made. I'm using excel 2000 which is part of my Microsoft Office 2000 program. No it's not possible -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Jim" <Jim@discussions.microsoft.com> wrote in message news:4FABAC1F-A402-4C87-BCDA-1124E072D9D3@microsoft.com... >I closed a excel document without saving changes. Is there a way to >retrieve > my ...

Red "O" next to Component Item on Assembly Entry
We are having an issue where we post an Assmebly and it shows updated qty for the FG and the components, but the Assembly Entry remains. The odd thing about it is that one of the components now had a red 'O' at the far right of the component item field. I can't find any info on this 'O', though. So, my guess is this posting issue (which has happened on two assmeblies in the last two days) is somehow related to this 'O' character. Also, when we posted the trx again (when it happened the first time) the assembly entry went away, btu everything posted again. ...

Auto number items
I am looking to put a number in a all of the different types of boxes on my diagram. I have been creating a text box with a number and dragging it to the box. I was in hopes that there might be an automated process. Thanks Chip Asmus Have you tried Tools/Addons/Visio Extras/Number Shapes... "Chip Asmus" <Chip@lawlershallmark.com> wrote in message news:eaZ0rwfYHHA.1244@TK2MSFTNGP04.phx.gbl... >I am looking to put a number in a all of the different types of boxes on my >diagram. I have been creating a text box with a number and dragging it to >the box. I ...

Count and display number of items
Hi there, I have one column of telephone numbers, please can someone help me with a formula to create another column showing how many occurrences there are of each number. Thanks! Andy. Andy, A pivot table can do just that. Set the data function to COUNT, if not already. To identify the duplicates, you can sort your table on the telephone number column, and put in a helper column: =if(A3=A2, "Dup","") Copy down. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Andy" <wiltshireguyuk@yahoo.co.uk&...

Charting with concatenated numbers and text
I am scatter charting from columns of data (text and numbers) that I concatanate into a long string so that I can use the validate drop down list feature in Excel, which only supports one column. I use Mid, Left and Right functions to then pick the relevant charting data from the string. Unfortunately although the numbers look good, Excel does not treat them the same way that it does with directly entered numbers - and my charts do not display accurately. Any ideas to to fix this problem or suggest a modified workflow. I am not an advanced user but would like to use the drop down li...

Change color for each serie?
Hi all, Is it possible to to change the color in a chart where 3 dataseries is represented? Eg. one color representing one region I have tried to create 3 series in the chart unsuccesfully. It seems that excel dosent allow it although I only have about +60 data in each serie... The data is also sorted (by size and not by region), so it is not possible just to select the data and assign them a specific value representing one color.. Hope that my question is clear. :) Christian ...

How do I sum numbers up to an certain threshold in Excel?
I'm sure the answer is easy, but I can't figure it out. I'm trying to sum one column up to a preset threshold (like 60) and then want to sum up corresponding entries, but I only want the entries that coresspond to the entries that don't exceed 60. So far I've create a GPA calculator where you place credit hours in one column, a letter grade in another, and then it uses a vlookup function to find out how many points that letter grade is worth, and then uses sum functions to sum up the points and the credit hours. It then divides the two to get a GPA. I'm stuck...

Error Number: 0x800ccc0e when I try to get messages
Hello, I am a postmaster of our network and I am having some problems with Outlook 2000 and our pop3 server. The problem is that randomly, Outlook's users can not download their mail because they get the error number 0x800ccc0e when they try to send amd receive mail. We are using Microsoft Outlook 2000 SP-3 (9.0.0.6627) and our server is a Linux Debian running a 2.4.27 kernel. I have tried with ipop3d and in.qpopper as a pop3 daemons and with both I get the error. There is no firewall between them and this is the tcpdump capture from the server (our pop3 server runs at port 40110, bu...

Suppress printing of Subreport on the next page of the same group?
I am trying to print a summary page (subreport) followed by details. When it overflow to the next page, I do not want the summary page to appear again for the same group. How can I suppress printing of this report following a page break? I am pretty new to programming and I guess I need more details. Thanks Put the subreport in its own group section. -- John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County .. "Kevin T" <KevinT@discussions.microsoft.com> wrote in message news:57CCBC43-E...

Remove Duplicate
I used OCR software to read the Names and addresses off ~500k images. For each image we received ID and Account Number combinations that correspond to a Name and Address. Within the data set there are several examples of each ID, Account, Name and Address combination. We are interested in removing the duplicates and only having the distinct records. The software is not 100% accurate so the Names and Addresses can be different from result to result for the same ID/Account. My thought was to use a majority voting approach. Below is a link to an example of the results. ...

In RMS PO add Level Pricing A, B or C for customization
Hi, Currently we are not able to add level price A, B or C in the PO template. If there is a need to be able to use any of the item level pricing it should be made available for customization purposes. Thanks, Mihir Shah Diviasoft, Inc. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in...

Why does a drop ship PO need a Site ID for the line items?
What line item Site ID would I use on drop ship POs? On a normal PO, the Site ID is where the product will be inventoried; for a drop ship, it will never come into our warehouse so I'm confused why I would need to enter something here. The address to which the vendor ships the product is put into the Shipping Address ID (which makes sense)....I just don't get why you need a Site ID. -- Bud Cool, Accounting System Manager HDA, Inc. Hazelwood, MO GP 9.0, SP2 Bud, The Site ID is a required field and you will be asked to enter one, even when entering a drop-ship PO. Best rega...

Select only even or odd number records
Hi, I have a table with among other things has on number field. I want two reports, one that select only records with even number in the number field and the second report that selects only records with odd numbers in the number field. I'm on the query builder screen and can't figure out the correct code to place in the criteria section for each report. Your help would be appreciated. Thanks in advance. You can take you unnamed number field and use /2 or the Mod operator to create a column in the query/record source: OddEven: [UnnamedNumericField] Mod 2 In the c...

Total number of pages
I would like to include total # of pages in the footer of my Publisher 2003 document (Master page). How do I do this? Do you mean something like: Page 10 of 20? Simply type of 20 after the # -- Mary Sauer http://msauer.mvps.org/ "Lynn" <Lynn@discussions.microsoft.com> wrote in message news:DAFBED91-A28F-42CC-B621-1C355476F79E@microsoft.com... >I would like to include total # of pages in the footer of my Publisher 2003 > document (Master page). How do I do this? ...

Put a single quotation mark in front of numbers in selected cells
Dear Expert: I need to convert numbers to text and put a tick (') mark/single quotation mark in front of every one of them. I would like to have a macro solution and the macro should work ONLY on selected cells. Help is much appreciated. Thank you very much in advance. Regards, Andreas This does exactly what you asked for... Sub AddApostrophe() Dim C As Range For Each C In Selection C.Replace C.Value, "'" & C.Value Next End Sub However, you do not need to put an apostrophe in front of each number to convert it to text, you can use th...

Emails randomly being tracked
Hi All, We are experiencing a very frustrating problem with our CRM 3 installation. We have the CRM for Outlook client (v3) installed on all of the pc's used by our CRM users. All users are set to track email one way (the setting to make only one task for mail between users). We are tracking only CRM token emails by default. We have the outlook rule freshly deployed to all users after checking the correct operation and config of the client. However, every so often (about one in every few hundred emails) an email will be automatically tracked in crm for absolutely no apparent reason...

Change font size based on value of a cell
If the value of A1>0, I need the font size in a merged cell to change from the default 10 to 16. It needs to return to the default size when A1 returns to a value of 0. Can someone help with this? Thanks. Michael Here's a little macro that will do it....... Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Range("a1").Value = 0 Then Range("B1:E3").Font.Size = 10 Else Range("B1:E3").Font.Size = 16 End If Range("B1").Select End Sub Vaya con Dios, Chuck, CABGx3 "MichaelRLanier@gmail.com" wrote: > ...

Chart Value Changes in VBA
When you have say a bar chart and drag the bar downwards this will change the value in the reference source cell. Is there a way through VBA to identify the source and the cell changed by when dragging the bar. That is, when you drag the bar in the chart let me know the cell that ahs changed! Any help would be appreciated. Thanks in advance. Howard John, If your objective is to prevent the cell changes via the chart, you can protect the worksheet (Tools - Protection). The cells should be locked (Format - Cells - Protection). Or you can use the Chart_SeriesChange event macro for the cha...

Change font color for row
If A1 is numbered 1 thru 4, representing Black, blue, green and red, is there a way to change the font color for an entire row based on this? i.e. if I place a 2 in cell A1, I would like the entire row of numbers and statements to change to a blue font. Thanks in Advance Mac "Mac" <Mac@discussions.microsoft.com> wrote in message news:12170EBC-BF99-4759-9171-C8B319364690@microsoft.com... > If A1 is numbered 1 thru 4, representing Black, blue, green and red, is > there > a way to change the font color for an entire row based on this? i.e. if I > place a ...

how can I fix the size of frame? once I fixed ,the user cannot changed its size
handle WM_GETMINMAXINFO see http://www.codeguru.com/forum/showthread.php?t=318933 "msnews.microsoft.com" <on_lixing@163.com> д���ʼ� news:OgxZDM45FHA.472@TK2MSFTNGP15.phx.gbl... > > Handle CFrameWnd::OnGetMinMaxInfo and specify whatever size you want for your frame to be. -- Ajay Kalra [MVP - VC++] ajaykalra@yahoo.com "msnews.microsoft.com" <on_lixing@163.com> wrote in message news:OgxZDM45FHA.472@TK2MSFTNGP15.phx.gbl... > > ...

GP10 Manufacturing Tables
Hola Familia I need a list of all the manufacturing tables for GP 10. I am trying to create several Crystal Reports. -- LOS Whats up Carlos, aqui tambien hablamos espanol you have all the tables for manufacturing in the resources within GP or you can get them as well on the SDK is there something in specific you need? dejame saber, no dudes!!! Frankie Hola Francisco Que gusto me da saber que también puedo buscar información en español .. I am doing great, I found that Manufacturing tables that I was looking for, thank you very much for all your help. -- LOS "...

Files opening with a number appended
Hi all, Hope you can help. I have a Macro in an excel file that looks for and opens another named excel file based on some variables. For example a new spreadsheet is opened today called 100305 (based on the date), the macro will then look for a file from the previous week (030305), open it, look for a certain value and copy it into the new sheet. However from time to time I'm finding that when the macro opens the previous file it appends a '1' to the end of the name (eg 0303051) and therefore my macro fails as it can't reference the file properly in order to find the requi...

how to create item numbers column in a Query
Is there anyway to place a column (Item#) in a query, which will show the item numbers of the results. Say that, if query result has 13 items, Item# values will be sequentially 1,2,3...11,12,13. I have a feeling that it might be solved by usind DCOUNT function. Thanks ...

Change base language
Hi I need to change the base language of CRM 4.0 I think I have to uninstall CRM and delete the CRM databases and then install again in the other language, it's not a big problem because there is no data in CRM but what about the registration would there be any problems registering the same server again ? /Jack There will be no problem in registeration .Never seen it . ------ Aamir Blog = http://mscrmsupport.wordpress.com/ No it all went well, uninstalled and deleted the databases and a new registration with same information and we are up running the right base language :) /J...

How do I print a select number of address records from Access
I'm trying to print just a select number of records for a mailing that I'm doing. I can't seem to figure out how to do this. Thanks. On Thu, 8 Nov 2007 12:23:04 -0800, robbie6 <robbie6@discussions.microsoft.com> wrote: >I'm trying to print just a select number of records for a mailing that I'm >doing. I can't seem to figure out how to do this. Thanks. Create a Query based on the table containing the addresses (and perhaps other tables). View the query's Properties (with the View menu item, or rightclick the background behind the table icons and sele...