I do this in a BPM and put the number in another field that I added to
the order. We need this cumulative shipping number for a customer ASN.
It looks like this in the BPM that I wrote. It should be something you
can use in figuring out a Crystal Report. If you need any help, just
give me an email.
Define Variable iTotal as Integer.
Define Variable myOrder as integer.
Define Variable iSubTotal as Integer.
myOrder = orderNum.
iTotal = 0.
iSubTotal = 0.
This sets my field back to zero each time in order to make sure the
number is not bloated.
For Each OrderDtl WHERE OrderDtl.ordernum = myOrder:
DO:
Run lib\UpdateTableBuffer.p(input buffer
orderdtl:HANDLE,'Number02',0).
END.
End.
This piece finds the lines that have shipped for this order to date and
are ready to invoice. For us, if it is not ready to invoice then it did
not ship so I don't want that record.
For Each OrderDtl no-lock,
Each ShipDtl WHERE (OrderDtl.OrderNum = shipdtl.OrderNum
and shipdtl.ordernum = myOrder and OrderDtl.OrderLine =
shipdtl.OrderLine and shipdtl.ReadyToInvoice = TRUE)BY shipdtl.OrderNum.
Do:
iTotal = iTotal +
ShipDtl.SellingInventoryShipQty.
iSubTotal = iSubTotal + iTotal.
iTotal = 0.
END.
Run lib\UpdateTableBuffer.p(input buffer
orderdtl:HANDLE,'Number02',iSubTotal).
End.
Tim Dines
Information Technology
Steel Parts Manufacturing, Inc.
801 Berryman Pike
Tipton, IN 46072
Direct: 765-675-5201
Cell: 765-437-1402
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ross Hughes
Sent: Thursday, March 25, 2010 10:21 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Total Shipped field
In the orderrel table there are two fields.
Ourstockshippedqty and ourjobshippedqty.
Create a calculated field and add them together.
You can group and sum at the line level in crystal if you need it by
line.
Ross
On Mar 25, 2010, at 9:13 AM, "brad.ebright" <bebright@...
<mailto:bebright%40mgsmail.com> >
wrote:
the order. We need this cumulative shipping number for a customer ASN.
It looks like this in the BPM that I wrote. It should be something you
can use in figuring out a Crystal Report. If you need any help, just
give me an email.
Define Variable iTotal as Integer.
Define Variable myOrder as integer.
Define Variable iSubTotal as Integer.
myOrder = orderNum.
iTotal = 0.
iSubTotal = 0.
This sets my field back to zero each time in order to make sure the
number is not bloated.
For Each OrderDtl WHERE OrderDtl.ordernum = myOrder:
DO:
Run lib\UpdateTableBuffer.p(input buffer
orderdtl:HANDLE,'Number02',0).
END.
End.
This piece finds the lines that have shipped for this order to date and
are ready to invoice. For us, if it is not ready to invoice then it did
not ship so I don't want that record.
For Each OrderDtl no-lock,
Each ShipDtl WHERE (OrderDtl.OrderNum = shipdtl.OrderNum
and shipdtl.ordernum = myOrder and OrderDtl.OrderLine =
shipdtl.OrderLine and shipdtl.ReadyToInvoice = TRUE)BY shipdtl.OrderNum.
Do:
iTotal = iTotal +
ShipDtl.SellingInventoryShipQty.
iSubTotal = iSubTotal + iTotal.
iTotal = 0.
END.
Run lib\UpdateTableBuffer.p(input buffer
orderdtl:HANDLE,'Number02',iSubTotal).
End.
Tim Dines
Information Technology
Steel Parts Manufacturing, Inc.
801 Berryman Pike
Tipton, IN 46072
Direct: 765-675-5201
Cell: 765-437-1402
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ross Hughes
Sent: Thursday, March 25, 2010 10:21 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Total Shipped field
In the orderrel table there are two fields.
Ourstockshippedqty and ourjobshippedqty.
Create a calculated field and add them together.
You can group and sum at the line level in crystal if you need it by
line.
Ross
On Mar 25, 2010, at 9:13 AM, "brad.ebright" <bebright@...
<mailto:bebright%40mgsmail.com> >
wrote:
> I've been asked to add a total shipped field to a report that I madehttp://groups.yahoo.com/group/vantage/files/
> in Crystal Reports. We are running version 8.0. On the OrderDtl tab,
> there is a field called total shipped. This is a calculated field
> and is not available for use in a report. I was wondering what is
> the easiest way to recreate this field on a report. The only way i
> thought to do it was to pull in all related packing slips and do the
> math that way. Anyone got any other suggestions?
>
> Thanks,
> Brad
>
>
>
> ------------------------------------
>
> 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/messages
> (2) To search through old msg's goto:
> (3) To view links to Vendors that provide Vantage services goto:http://groups.yahoo.com/group/vantage/linksYahoo!
> Groups Links[Non-text portions of this message have been removed]
>
>
>