''ShipDtl.PackNum = Constant: NullValue
Would the 'empty', default PackNum be '0' ?
(Null Values not really useful with Integers)
Would the 'empty', default PackNum be '0' ?
(Null Values not really useful with Integers)
--- On Mon, 1/19/09, Chris Thompson <chriselectrix@...> wrote:
> From: Chris Thompson <chriselectrix@...>
> Subject: [Vantage] Vantage - BAQ Query / Help
> To: vantage@yahoogroups.com
> Date: Monday, January 19, 2009, 11:55 AM
> Hi,
>
> I’m trying to create a dashboard with the following
> information – we are almost there, but can’t get one
> part of it.
> Â
> Basically, Vantage has a Dashboard called Sales Order
> Shipment Status.
> Â
> We require a dashboard which will show us the following:
> Â
> Grid View: Sales Orders ... ALL
> Â
> ONE
> Grid View: Sales Orders ... WHERE ShipDtl.PackNum = Null
> In other words, we want to see a list of all Sales Orders
> that have not got a Pack Number allocated to them.
> Â
> TWO
> Grid View: Sales Orders .... WHERE ShipDtl.PackNum > 0
> AND ShipHead.ShipStatus <> SHIPPED
> This will display all orders that are packed (or started to
> be packed) but have not been marked as Shipped (in Customer
> Shipment Entry).
> Â
> THREE
> Grid View: Sales Orders .... WHERE ShipHead.ShipStatus =
> SHIPPED
> This will show all orders that have been marked as shipped.
> Â
> I will then put date filters on them.
> Â
> This dashboard is purely intended to be visual, therefore
> we do not want to publish and subscribe between grids.
> Â
> The problem is, we can’t quite get it to work.
> Â
> If we set up a BAQ with the following:
> Â
> OrderHed
> OrderDtl
> Customer
> ShipDtl
> Â
> We can get it to display a list of every single order on
> the system, and display a Pack Number against the order, if
> one is available.
> Â
> This satisfies ONE (above), except when we import it into a
> dashboard and try to filter the
> Â
> ShipDtl.PackNum = Constant: NullValue
> Â
> it gives us an error message telling us that ‘Invalid
> Filter: Alpha compare against Numeric Column:
> 'ShipDtl.PackNum = Constant: NullValue'.
> Â
> At this point, we are wanting to display any orders that do
> not have a PackNum. Do you have any suggestions for us to
> get this to work?
> Â
> Â
> For TWO and THREE, we need to introduce the ShipHead table
> to the above query (or a copy of the above query), and we
> want the BAQ to tell us the ShipStatus, which should show
> against all lines. The options should either be OPEN, CLOSED
> or SHIPPED. Then we need to introduce this BAQ into the
> Dashboard and filter on ShipHead.ShipStatus, where
> ShipStatus <> SHIPPED. This, alsong with the filter
> above will satisfy TWO.
> Â
> However, when I add the ShipHead to the bottom of the list
> on the BAQ, I get this error ...
> Â
> Â
> I am unable to add ShipHead to the BAQ successfully, I am
> unable to complete TWO and THREE. I realise that it is
> trying to link ShipHead.OrderNum which doesn't exiitin
> in 8.03.406a. I linked Shipdtl to ShipHead with PackNumLine.
> Â
> Â
> I would appreciate any suggestions or pointers as to where
> we are going wrong.
> Â
> We understand the concept, but we don’t know how to get
> around problems when they occur.
> Â
> Thanks,
> Â
>
>
> CHRIS
>
>
>
>
> [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/linksYahoo!
> Groups Links
>
>
>