Consider going to standard costing system it is what we did and I am
extremely happy with the results.
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: Keith Mailloux [mailto:keith.mailloux@...]
Sent: Tuesday, March 01, 2005 11:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Gross Margin Errors
If you have run into this problem and have a fix I'd love to hear from
you:
When a shipment is made from a job an Invoice Detail (Invdtl) record is
created to handle the billing aspect of the transaction. This record also
contains the unit costs of the product shipped at that point in time. We
occasionally have errors in our data entry and as a result the unit costs
are inaccurate, sometimes grossly inaccurate. We can go back and correct the
job information but the invoice detail record does not get changed. This is
a big problem when we go to run sales gross margin reports as this (Invdtl)
is the table the data is pulled from. Once an error is made the Sales Gross
Margin report is garbage for eternity...
I contacted support and no fix program is available. We are planning to
create our own unless someone has already found a way to deal with this or
can show me an error in my ways (maybe there is a way to correct it I have
overlooked). If you have a fix or workaround please let me know (this has
Todd, Aaron or Mike written all over it :-) ).
Thanks for listening,
Keith Mailloux
Ferguson Perforating
(401)941-8876
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
extremely happy with the results.
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: Keith Mailloux [mailto:keith.mailloux@...]
Sent: Tuesday, March 01, 2005 11:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Gross Margin Errors
If you have run into this problem and have a fix I'd love to hear from
you:
When a shipment is made from a job an Invoice Detail (Invdtl) record is
created to handle the billing aspect of the transaction. This record also
contains the unit costs of the product shipped at that point in time. We
occasionally have errors in our data entry and as a result the unit costs
are inaccurate, sometimes grossly inaccurate. We can go back and correct the
job information but the invoice detail record does not get changed. This is
a big problem when we go to run sales gross margin reports as this (Invdtl)
is the table the data is pulled from. Once an error is made the Sales Gross
Margin report is garbage for eternity...
I contacted support and no fix program is available. We are planning to
create our own unless someone has already found a way to deal with this or
can show me an error in my ways (maybe there is a way to correct it I have
overlooked). If you have a fix or workaround please let me know (this has
Todd, Aaron or Mike written all over it :-) ).
Thanks for listening,
Keith Mailloux
Ferguson Perforating
(401)941-8876
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).