Crystal Reports Invoice

Yahoo Archive
1
I am linking InvcMsc to InvcHead. I am the getting the correct records. I can match Certain Months but some months I cannot. My feeling is that there is a charge or something I am missing.
Â
Thanks,
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699


--- On Wed, 7/22/09, Dale Schuerman <dale.schuerman@...> wrote:


From: Dale Schuerman <dale.schuerman@...>
Subject: RE: [Vantage] Crystal Reports Invoice
To: vantage@yahoogroups.com
Date: Wednesday, July 22, 2009, 3:58 PM


Â



Check you linkages.

If you are linking InvcMsc to InvcDtl (or something like that) and
totaling the InvcDtl. DocExtPrice.

If there are 3 InvcMsc records you are also getting three InvcDtl
records and your subtotaled DocExtPrice will be multiplied by three
times. Etc....

If this is the case Invoice lines with one or zero InvcMsc records
should be correct.

Hope this helps

Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner

RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@ ramsys.com
<BLOCKED::blocked: :mailto:dale.schuerman@ ramsys.com> (email)

http://www.ramsys com <BLOCKED::blocked: :http://www.ramsys com/>
(website)

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Jonathan Lang
Sent: Wednesday, July 22, 2009 3:34 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Crystal Reports Invoice

Bill,

I don't want to edit ARForm. I want to create a report that shows the
Invoice Totals per Month, and Year. The problem is my amounts are not
correct.

Tables I am using:
InvcHead, Customer, InvcDtl, and InvcMsc.I have an Outerjoin on InvcMsc.

Thanks,
Jonathan Lang
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699

--- On Wed, 7/22/09, Bill King <bking@jandbindustri al.com
<mailto:bking% 40jandbindustria l.com> > wrote:

From: Bill King <bking@jandbindustri al.com
<mailto:bking% 40jandbindustria l.com> >
Subject: RE: [Vantage] Crystal Reports Invoice
To: "'vantage@yahoogroup s.com <mailto:%27vantage% 40yahoogroups. com> '"
<vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> >
Date: Wednesday, July 22, 2009, 3:19 PM

we have done a ton of edits on this form to customize for our business
needs. in regards to your issue, i put running totals for line charges,
line misc charges, surcharges, and order misc charges to be reset at
change of group header #1 (invoice number). as a check i added a water
mark to read components of invoice and invoice total do not match if
they don't, suppressed if they do. this gives us the flexibility to
itemized the charge type and still maintain the docinvamt that matches
the system so paper and screen agree.

BILL R. KING
J&B Industrial Services
(806).776.4409 Office
(254).592.4397 Cell

____________ _________ _________ __
From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf Of Jonathan Lang
Sent: Wednesday, July 22, 2009 3:05 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Crystal Reports Invoice

Good afternoon,

I am having a huge problem getting the correct Invoice amount.
What I am trying to do is get the Amount from each line of every
Invoice. This has to match the Invoices we print out from Invoice Entry,
under Payment Schedule at the bottom of the ARForm, Amount.

I thought I could get this information from Invdtl.DocExtPrice, but to
no avail. I also added in with Invdtl.DocExtPrice a MiscCharge that does
add to the Amount but also to no avail.

I would appreciate any help.

Thank you,
Jonathan Lang
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699

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

____________ _________ _________ __
The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This
message and its contents may contain confidential or privileged
information. If you are not the intended recipient, you are hereby
notified that any disclosure or distribution, or taking any action in
reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any
attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.

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

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

############ ######### ######### ######### ######### ######### ######### ######
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys com
############ ######### ######### ######### ######### ######### ######### ######

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



















[Non-text portions of this message have been removed]
2
Good afternoon,
Â
I am having a huge problem getting the correct Invoice amount.
What I am trying to do is get the Amount from each line of every Invoice. This has to match the Invoices we print out from Invoice Entry, under Payment Schedule at the bottom of the ARForm, Amount.
Â
I thought I could get this information from Invdtl.DocExtPrice, but to no avail. I also added in with Invdtl.DocExtPrice a MiscCharge that does add to the Amount but also to no avail.
Â
I would appreciate any help.
Â
Thank you,
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699
Â




[Non-text portions of this message have been removed]
3
we have done a ton of edits on this form to customize for our business needs. in regards to your issue, i put running totals for line charges, line misc charges, surcharges, and order misc charges to be reset at change of group header #1 (invoice number). as a check i added a water mark to read components of invoice and invoice total do not match if they don't, suppressed if they do. this gives us the flexibility to itemized the charge type and still maintain the docinvamt that matches the system so paper and screen agree.


BILL R. KING
J&B Industrial Services
(806).776.4409 Office
(254).592.4397 Cell



________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jonathan Lang
Sent: Wednesday, July 22, 2009 3:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Invoice



Good afternoon,

I am having a huge problem getting the correct Invoice amount.
What I am trying to do is get the Amount from each line of every Invoice. This has to match the Invoices we print out from Invoice Entry, under Payment Schedule at the bottom of the ARForm, Amount.

I thought I could get this information from Invdtl.DocExtPrice, but to no avail. I also added in with Invdtl.DocExtPrice a MiscCharge that does add to the Amount but also to no avail.

I would appreciate any help.

Thank you,
Jonathan Lang
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699


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




________________________________
The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.


[Non-text portions of this message have been removed]
4
Are you taking into account DiscountPercent?

I know I had some problems relating totals in the invcdtl table to what you see on the Invoice. The headache is because you have a extprice, a mischarge, and a discountpercent just on the line items. Then there is a separate InvcMisc table that can apply to both the InvcHead and/or InvcDtl and there is a InvcTax table relating to each invcdtl line.

On a somewhat related note, we have seen in 408 where a misc charge on a Sale Order header gets added in twice even though there is only one line item. We can correct this by changing the misc charge from each to first, but its got me concerned.



________________________________
From: Jonathan Lang <lsbestinc@...>
To: vantage@yahoogroups.com
Sent: Wednesday, July 22, 2009 4:05:14 PM
Subject: [Vantage] Crystal Reports Invoice

Â
Good afternoon,
Â
I am having a huge problem getting the correct Invoice amount.
What I am trying to do is get the Amount from each line of every Invoice. This has to match the Invoices we print out from Invoice Entry, under Payment Schedule at the bottom of the ARForm, Amount.
Â
I thought I could get this information from Invdtl.DocExtPrice, but to no avail. I also added in with Invdtl.DocExtPrice a MiscCharge that does add to the Amount but also to no avail.
Â
I would appreciate any help.
Â
Thank you,
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699
Â

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







[Non-text portions of this message have been removed]
5
Right, I have all of the tables included except for the Tax table. I do not want to include taxes, just the ExtPrice and one Misc Charge called "MIN". Do I have to include the tax table as well? I am not sure why that would matter.
Â
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699


--- On Wed, 7/22/09, Steven Gotschall <sgotschall@...> wrote:


From: Steven Gotschall <sgotschall@...>
Subject: Re: [Vantage] Crystal Reports Invoice
To: vantage@yahoogroups.com
Date: Wednesday, July 22, 2009, 3:22 PM


Â



Are you taking into account DiscountPercent?

I know I had some problems relating totals in the invcdtl table to what you see on the Invoice. The headache is because you have a extprice, a mischarge, and a discountpercent just on the line items. Then there is a separate InvcMisc table that can apply to both the InvcHead and/or InvcDtl and there is a InvcTax table relating to each invcdtl line.

On a somewhat related note, we have seen in 408 where a misc charge on a Sale Order header gets added in twice even though there is only one line item. We can correct this by changing the misc charge from each to first, but its got me concerned.

____________ _________ _________ __
From: Jonathan Lang <lsbestinc@yahoo. com>
To: vantage@yahoogroups .com
Sent: Wednesday, July 22, 2009 4:05:14 PM
Subject: [Vantage] Crystal Reports Invoice

Â
Good afternoon,
Â
I am having a huge problem getting the correct Invoice amount.
What I am trying to do is get the Amount from each line of every Invoice. This has to match the Invoices we print out from Invoice Entry, under Payment Schedule at the bottom of the ARForm, Amount.
Â
I thought I could get this information from Invdtl.DocExtPrice, but to no avail. I also added in with Invdtl.DocExtPrice a MiscCharge that does add to the Amount but also to no avail.
Â
I would appreciate any help.
Â
Thank you,
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699
Â

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

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



















[Non-text portions of this message have been removed]
6
Bill,
Â
I don't want to edit ARForm. I want to create a report that shows the Invoice Totals per Month, and Year. The problem is my amounts are not correct.
Â
Tables I am using:
InvcHead, Customer, InvcDtl, and InvcMsc.I have an Outerjoin on InvcMsc.
Â
Thanks,
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699

--- On Wed, 7/22/09, Bill King <bking@...> wrote:


From: Bill King <bking@...>
Subject: RE: [Vantage] Crystal Reports Invoice
To: "'vantage@yahoogroups.com'" <vantage@yahoogroups.com>
Date: Wednesday, July 22, 2009, 3:19 PM


Â



we have done a ton of edits on this form to customize for our business needs. in regards to your issue, i put running totals for line charges, line misc charges, surcharges, and order misc charges to be reset at change of group header #1 (invoice number). as a check i added a water mark to read components of invoice and invoice total do not match if they don't, suppressed if they do. this gives us the flexibility to itemized the charge type and still maintain the docinvamt that matches the system so paper and screen agree.

BILL R. KING
J&B Industrial Services
(806).776.4409 Office
(254).592.4397 Cell

____________ _________ _________ __
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Jonathan Lang
Sent: Wednesday, July 22, 2009 3:05 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Crystal Reports Invoice

Good afternoon,

I am having a huge problem getting the correct Invoice amount.
What I am trying to do is get the Amount from each line of every Invoice. This has to match the Invoices we print out from Invoice Entry, under Payment Schedule at the bottom of the ARForm, Amount.

I thought I could get this information from Invdtl.DocExtPrice, but to no avail. I also added in with Invdtl.DocExtPrice a MiscCharge that does add to the Amount but also to no avail.

I would appreciate any help.

Thank you,
Jonathan Lang
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699

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

____________ _________ _________ __
The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.

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



















[Non-text portions of this message have been removed]
7
Check you linkages.



If you are linking InvcMsc to InvcDtl (or something like that) and
totaling the InvcDtl. DocExtPrice.



If there are 3 InvcMsc records you are also getting three InvcDtl
records and your subtotaled DocExtPrice will be multiplied by three
times. Etc....



If this is the case Invoice lines with one or zero InvcMsc records
should be correct.



Hope this helps



Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner



RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@...
<BLOCKED::blocked::mailto:dale.schuerman@...> (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
(website)





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jonathan Lang
Sent: Wednesday, July 22, 2009 3:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Invoice





Bill,

I don't want to edit ARForm. I want to create a report that shows the
Invoice Totals per Month, and Year. The problem is my amounts are not
correct.

Tables I am using:
InvcHead, Customer, InvcDtl, and InvcMsc.I have an Outerjoin on InvcMsc.

Thanks,
Jonathan Lang
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699

--- On Wed, 7/22/09, Bill King <bking@...
<mailto:bking%40jandbindustrial.com> > wrote:

From: Bill King <bking@...
<mailto:bking%40jandbindustrial.com> >
Subject: RE: [Vantage] Crystal Reports Invoice
To: "'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com> '"
<vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Date: Wednesday, July 22, 2009, 3:19 PM



we have done a ton of edits on this form to customize for our business
needs. in regards to your issue, i put running totals for line charges,
line misc charges, surcharges, and order misc charges to be reset at
change of group header #1 (invoice number). as a check i added a water
mark to read components of invoice and invoice total do not match if
they don't, suppressed if they do. this gives us the flexibility to
itemized the charge type and still maintain the docinvamt that matches
the system so paper and screen agree.

BILL R. KING
J&B Industrial Services
(806).776.4409 Office
(254).592.4397 Cell

____________ _________ _________ __
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf Of Jonathan Lang
Sent: Wednesday, July 22, 2009 3:05 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Crystal Reports Invoice

Good afternoon,

I am having a huge problem getting the correct Invoice amount.
What I am trying to do is get the Amount from each line of every
Invoice. This has to match the Invoices we print out from Invoice Entry,
under Payment Schedule at the bottom of the ARForm, Amount.

I thought I could get this information from Invdtl.DocExtPrice, but to
no avail. I also added in with Invdtl.DocExtPrice a MiscCharge that does
add to the Amount but also to no avail.

I would appreciate any help.

Thank you,
Jonathan Lang
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699

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

____________ _________ _________ __
The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This
message and its contents may contain confidential or privileged
information. If you are not the intended recipient, you are hereby
notified that any disclosure or distribution, or taking any action in
reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any
attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.

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

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




########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


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