Jump to content


Steve @ SMI Sales's Content

There have been 2 items by Steve @ SMI Sales (Search limited from 21-May 23)


By content type

See this member's

Sort by                Order  

#1792 Purchase Order Error

Posted by Steve @ SMI Sales on 12 April 2007 - 11:41 AM in MOM & FOX Database Issues

Update:

[RANT]

I was right! Of course they never expected anyone to need more than 99 entries for a purchase order. I guess no one out there has more than 100 items that may not come in at the same time, right? (read: save the PO more than 99 times)

:angry:


And there are "currently no plans to increase the field size to 3" according to them.

So, we get to recreate the POs in smaller chunks, and start over. No telling what inventory nightmares those errors are going to cause.

You have been warned!

[/RANT]



#1791 Purchase Order Error

Posted by Steve @ SMI Sales on 12 April 2007 - 06:09 AM in MOM & FOX Database Issues

We get the dreaded Error 39 (Line number 477 in INVADJ) error when saving any changes to a specific Purchase Order. Checking the INVENTOR.DBF, we noticed the ** in the Instance field. After much research, we found the previous entry had 98 in that field. Since it is a 2 precision field, could it be caused if the Instance is being incremented and reached 100?

Waiting on MOM to get back with us with an official answer, but thought I'd toss this idea out and see if it floats (pardon the numbers pun) :blink:

Thanks!
Steve
SMI