Sales Pick List

I have a baq report for our picking and delivery pick lists which
displays this. Below is the BAQ query phrase. We lose the fancy calc
address display but I might add it one day with your ideas from this
thread. Note we added job prod and job mtl as we ship our configured
parts in bits (so perhaps all the uprights (a job mtl) for a frame (the
part) but not the bracings).


for each OrderHed no-lock , each OrderDtl where ( OrderDtl.VoidLine =
false) and (OrderHed.Company = OrderDtl.Company and OrderHed.OrderNum =
OrderDtl.OrderNum) no-lock , each Part outer-join where
(OrderDtl.Company = Part.Company and OrderDtl.PartNum = Part.PartNum)
no-lock , each OrderRel where (OrderDtl.Company = OrderRel.Company and
OrderDtl.OrderNum = OrderRel.OrderNum and OrderDtl.OrderLine =
OrderRel.OrderLine) no-lock , each JobProd outer-join where
(OrderRel.Company = JobProd.Company and OrderRel.OrderNum =
JobProd.OrderNum and OrderRel.OrderLine = JobProd.OrderLine and
OrderRel.OrderRelNum = JobProd.OrderRelNum) no-lock , each ShipTo where
( ShipTo.Company = OrderRel.Company AND ShipTo.ShipToNum =
OrderRel.ShipToNum) and (OrderHed.Company = ShipTo.Company and
OrderHed.CustNum = ShipTo.CustNum) no-lock , each Customer where
(OrderHed.Company = Customer.Company and OrderHed.CustNum =
Customer.CustNum) no-lock , each JobMtl outer-join where
(JobProd.Company = JobMtl.Company and JobProd.JobNum = JobMtl.JobNum)
no-lock .

kind regards

Debbie Stokes
Vantage Administrator
Hilo-PSS Group
01793 647136

*******************************************************************************************************************************************************************************************************************************************************************************
This email is intended for the addressee only and may contain information that is privileged and confidential. If you are not the intended recipient, you must not copy, distribute or take any
action in reliance on it. If this email has been sent to you in error, please notify us immediately by telephone.
This has been transmitted by -

Hilo-PSS Group
Murdock Road
Dorcan Industrial Estate
Swindon

SN3 5HY

Company Registration No: 01028915.

The views within this email are those of the author and not
necessarily those of Planned Storage Systems Ltd.

** This email has been scanned for viruses, vandals and malicious content **
************************************************************************************************************************************************************************************************



[Non-text portions of this message have been removed]
Anyone figured out how to add the ship to address to the Sales Order
Pick List? We've tried and our consultant tried saying there was not
an index between CustNum and ShipToNum, or some crap like that.

I want my proceedural programming language back!
I have put the Ship to Address on our SO Pick List.

In Crystal in the orderrel table there is a field called
orderrel.Calc_ShipToAddr. You are going to create formulas (ShipTo_Addr1,
ShipTo_Addr2, etc...) for each of the 7 fields of the address using this
formula

Split({orderrel.Calc_ShipToAddr},"~") [1]

Increasing the [1] to [2] then [3] and so on to [7]

Then place that each formula on the pick list where you want it.

Scott Litzau, MCP
Olympus Flag & Banner
Information Systems Manager
scott.litzau@...
P: 414-365-9732
F: 414-355-1931


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike Barnard
Sent: Wednesday, June 18, 2008 11:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Pick List

Anyone figured out how to add the ship to address to the Sales Order
Pick List? We've tried and our consultant tried saying there was not
an index between CustNum and ShipToNum, or some crap like that.

I want my proceedural programming language back!


------------------------------------

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
thats on my to-do list of vantage customizations! :)

will share once i get it done!!


Thanks,
Kunal



----- Original Message ----
From: Mike Barnard <mbarnard@...>
To: vantage@yahoogroups.com
Sent: Wednesday, June 18, 2008 11:59:17 AM
Subject: [Vantage] Sales Pick List


Anyone figured out how to add the ship to address to the Sales Order
Pick List? We've tried and our consultant tried saying there was not
an index between CustNum and ShipToNum, or some crap like that.

I want my proceedural programming language back!






[Non-text portions of this message have been removed]
My A/R clerk is telling me that on previous versions, when she would issue a credit for a multi-line RMA, she could enter all of the lines on the same credit invoice.
However, on this version, it is forcing her to create a different one for every line on the RMA being credited.

Has anyone else noticed this and able to provide suggestion, or is this a magical new "feature" of 404?

Thanks
Carey
_________________________________________________________________
Need to know now? Get instant answers with Windows Live Messenger.
http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Refresh_messenger_062008

[Non-text portions of this message have been removed]
I have not noticed this problem but I have found that in the 400 release an
RMA credit does not get the commissions from the sales order any longer. It
goes back to the customer file and gets the default setup for the
commissions so if you have changed rep or commission amount the RMA will
credit the incorrect amount.



Steve



-----Original Message-----
From: Carey S [mailto:rotary1@...]
Sent: June 18, 2008 2:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 803.404 RMA credits



My A/R clerk is telling me that on previous versions, when she would issue a
credit for a multi-line RMA, she could enter all of the lines on the same
credit invoice.
However, on this version, it is forcing her to create a different one for
every line on the RMA being credited.

Has anyone else noticed this and able to provide suggestion, or is this a
magical new "feature" of 404?

Thanks
Carey
__________________________________________________________
Need to know now? Get instant answers with Windows Live Messenger.
http://www.windowsl
<http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_W
L_Refresh_messenger_062008>
ive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Refresh_messenger_
062008

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





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