SQL Explorer Query Error

system · October 30, 2008, 9:00am

I'm hashing out a report and I'm doing some test in SQL Explorer with the
following query

SELECT left(Customer.Name,10), InvcHead.InvoiceNum, InvcDtl.InvoiceLine,
left(ShipTo.State,10), InvcHead.InvoiceDate, InvcDtl.ExtPrice,
InvcMisc.MiscAmt

FROM (((PUB.Customer INNER JOIN PUB.InvcHead ON
Customer.CustNum=InvcHead.CustNum) INNER JOIN PUB.InvcDtl ON
InvcHead.InvoiceNum=InvcDtl.InvoiceNum) LEFT OUTER JOIN PUB.InvcMisc ON
(InvcDtl.InvoiceNum=InvcMisc.InvoiceNum) AND
(InvcDtl.InvoiceLine=InvcMisc.InvoiceLine)) INNER JOIN PUB.ShipTo ON
((InvcDtl.ShipToNum=ShipTo.ShipToNum) AND
(InvcDtl.ShipViaCode=ShipTo.ShipViaCode)) AND
(InvcDtl.CustNum=ShipTo.CustNum)

I keep getting the following error:

=== SQL Exception 1 ===

SQLState=HY000

ErrorCode=-20152

[JDBC OpenEdge Driver]:Character string is too long (8184)

Any thoughts of what is actually going on here.

As you can see I went through and chopped all the string types down to 10
characters. I wasn't sure however if the left function is a sever side
function or done by SQL Explorer after it gets the data back. I assumed
server side but maybe not.

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.8.4/1751 - Release Date: 10/29/2008
7:45 AM

[Non-text portions of this message have been removed]

system · October 29, 2008, 1:50pm

We are currently on Vantage 8.03.403 progress and we are using the
Standard Costing Method for ALL parts in our system. Upper
management is tossing around the idea to go to the Average Costing
Method. We understand the implications of doing this on the
accounting/financial side of things but what all has to be done in
Vantage for this to work?

I realize that you cannot change the costing method of a part unless
you zero out the inventory first. Is there a utility that you can
use to do this?

Is there an "easy" way to change this? Other than on the company
setup and the part is there anywhere else in the system that has to
be changed to Average. Are there any Manufacturing companies out
there that are on Vantage 8.03.4xx that are using the Average Cost
Method that could give us some pro's and con's to doing costing this
way in Vantage?

Any help would be appreciated. Thanks

Robert Nupp
Laclede Chain Manufacturing Co.
636-680-2333
St. Louis, MO

system · October 29, 2008, 2:21pm

I know there are other opinions out there, and I respect those opinions, however, I am a big believer in average costing. For direct costs, at least, you have a truer picture of what it actually cost you to make something. If you need to have some sort of variance reporting, look at what it has cost you in the past to make something and compare to what it most recently cost. Standards usually end up being adjusted to fit history anyway, so, you are basically going through a lot of work to set standards that does not have much real payoff.

I could go on about this for quite awhile, but I'm converting from legacy systems to 8.03.403 this weekend, so you only get the quick version of my opinion (which many would consider a blessing - that they get the short version and not the long).

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
F 425 491-8200
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of robert.nupp
Sent: Wednesday, October 29, 2008 10:50 AM
To: vantage@yahoogroups.com
Subject: {Disarmed} [Vantage] Changing the Costing Method for all parts

We are currently on Vantage 8.03.403 progress and we are using the
Standard Costing Method for ALL parts in our system. Upper
management is tossing around the idea to go to the Average Costing
Method. We understand the implications of doing this on the
accounting/financial side of things but what all has to be done in
Vantage for this to work?

I realize that you cannot change the costing method of a part unless
you zero out the inventory first. Is there a utility that you can
use to do this?

Is there an "easy" way to change this? Other than on the company
setup and the part is there anywhere else in the system that has to
be changed to Average. Are there any Manufacturing companies out
there that are on Vantage 8.03.4xx that are using the Average Cost
Method that could give us some pro's and con's to doing costing this
way in Vantage?

Any help would be appreciated. Thanks

Robert Nupp
Laclede Chain Manufacturing Co.
636-680-2333
St. Louis, MO

[Non-text portions of this message have been removed]

system · October 29, 2008, 5:59pm

Don't quote me on this but one of the sessions at Perspectives this was
discussed and If I remember correctly they did a full physical inventory
to zero out their inventory. They then switched the parts to average
costing and then reloaded the inventory. They didn't go into specifics
but If you have service connect I am sure you could use that to update
your part costing methods. Then you could grab the entries form the
physical inventory posting and run those through service connect to put
the parts back into inventory.

Jim

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of robert.nupp
Sent: Wednesday, October 29, 2008 12:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Changing the Costing Method for all parts

We are currently on Vantage 8.03.403 progress and we are using the
Standard Costing Method for ALL parts in our system. Upper
management is tossing around the idea to go to the Average Costing
Method. We understand the implications of doing this on the
accounting/financial side of things but what all has to be done in
Vantage for this to work?

I realize that you cannot change the costing method of a part unless
you zero out the inventory first. Is there a utility that you can
use to do this?

Is there an "easy" way to change this? Other than on the company
setup and the part is there anywhere else in the system that has to
be changed to Average. Are there any Manufacturing companies out
there that are on Vantage 8.03.4xx that are using the Average Cost
Method that could give us some pro's and con's to doing costing this
way in Vantage?

Any help would be appreciated. Thanks

Robert Nupp
Laclede Chain Manufacturing Co.
636-680-2333
St. Louis, MO

[Non-text portions of this message have been removed]

system · October 30, 2008, 8:43am

> Don't quote me on this but one of the sessions at Perspectives this was
> discussed and If I remember correctly they did a full physical inventory
> to zero out their inventory. They then switched the parts to average
> costing and then reloaded the inventory. They didn't go into specifics
> but If you have service connect I am sure you could use that to update
> your part costing methods. Then you could grab the entries form the
> physical inventory posting and run those through service connect to put
> the parts back into inventory.

Also, I noticed that E9 brings a new costing method: FIFO Lot costing. Still
investigating...

Mark W.