Help with total sales report

Yahoo Archive
1
Well how about that, isn't it always the user? I knew someone out there
would be able to help, thank you Patrick.

Looking back at the data dictionary those fields will work and also
invoice prefix. Wonder why I didn't see them before, just proves how
narrow our vision is when we see what we want to see.
Muchas Gracias!!!!

Patty Cioffi (chofee)
Accounting Department
EFS Aerospace, Inc.
A Triumph Group Company
voice 661-295-1015 x101
fax 661-295-1058
e-mail <mailto:patty.cioffi@...> patty.cioffi@...

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Monday, January 12, 2004 10:00 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] help with total sales report

Don't the InvcHead.UnappliedCash (Logical) and CreditMemo (Logical)
fields
do this for you in a filter?

Patrick Winter


-----Original Message-----
From: patty.cioffi [mailto:patty.cioffi@...]
Sent: Monday, January 12, 2004 11:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] help with total sales report


Once again I am turning to the list while tech support figures out how
to
help me. Vantage 5.10.135

I am trying to pull over the total sales for the month, Crystal and or
RB. I
am using the InvcHead and InvcDtl tables. Maybe that is not the correct
place to start. Here is what I think the problem is: all invoice numbers
come over and when you enter unapplied cash in cash receipts it creates
an
invoice number (weird enough). I have tried to filter out these invoice
numbers with the trantype field, but it only contains Mis, Shp, and Adv,
Dep
types. Mis includes credit memo's and unapplied cash. I want credit
memos,
but certainly not unapplied cash.

Either I am approaching this entirely backwards or this is really crazy
logic. What am I doing wrong?

How would you go about creating a report that gives you total sales for
the
month? What I really want to end up with is sales by country, which is a
simple filter, once you get the correct net sales number.

Thank you in advance for your help!
Patty
EFS Aerospace


[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/.
<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

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/



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/.
<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
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.


[Non-text portions of this message have been removed]
2
We are wondering if anyone on Vantage 6.0 (post 514 patch) are having
problems with the Invoice Line item order not matching the Packing Slip
line item order. For us this is a big deal, since we often have
Invoices with 50+ line items, and our customers need to be able to take
their Packing slip and match it up with their Invoice.

Epicor claims that Index has been changed. In 5.2, it processed the
shipdtl data in ordernum, packnum, shipdate, order line order. The 6.0
rewritten version processes shipdtl data in plant, co, custid, ordernum,
packnum order.

1. Notice that the new order doesn't take into account the "order
line order". Why would you NOT want to match your packing slip detail
lines with your Invoice detail lines??????????? What are they
thinking??
2. We didn't have this problem till the 514 patch!

Britt Moelling
M&M Manufacturing



[Non-text portions of this message have been removed]
3
Once again I am turning to the list while tech support figures out how
to help me. Vantage 5.10.135

I am trying to pull over the total sales for the month, Crystal and or
RB. I am using the InvcHead and InvcDtl tables. Maybe that is not the
correct place to start. Here is what I think the problem is: all invoice
numbers come over and when you enter unapplied cash in cash receipts it
creates an invoice number (weird enough). I have tried to filter out
these invoice numbers with the trantype field, but it only contains Mis,
Shp, and Adv, Dep types. Mis includes credit memo's and unapplied cash.
I want credit memos, but certainly not unapplied cash.

Either I am approaching this entirely backwards or this is really crazy
logic. What am I doing wrong?

How would you go about creating a report that gives you total sales for
the month? What I really want to end up with is sales by country, which
is a simple filter, once you get the correct net sales number.

Thank you in advance for your help!
Patty
EFS Aerospace


[Non-text portions of this message have been removed]
4
Don't the InvcHead.UnappliedCash (Logical) and CreditMemo (Logical) fields
do this for you in a filter?

Patrick Winter


-----Original Message-----
From: patty.cioffi [mailto:patty.cioffi@...]
Sent: Monday, January 12, 2004 11:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] help with total sales report


Once again I am turning to the list while tech support figures out how to
help me. Vantage 5.10.135

I am trying to pull over the total sales for the month, Crystal and or RB. I
am using the InvcHead and InvcDtl tables. Maybe that is not the correct
place to start. Here is what I think the problem is: all invoice numbers
come over and when you enter unapplied cash in cash receipts it creates an
invoice number (weird enough). I have tried to filter out these invoice
numbers with the trantype field, but it only contains Mis, Shp, and Adv, Dep
types. Mis includes credit memo's and unapplied cash. I want credit memos,
but certainly not unapplied cash.

Either I am approaching this entirely backwards or this is really crazy
logic. What am I doing wrong?

How would you go about creating a report that gives you total sales for the
month? What I really want to end up with is sales by country, which is a
simple filter, once you get the correct net sales number.

Thank you in advance for your help!
Patty
EFS Aerospace


[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

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/