Add a VBFORM field on the Sales Order Header Line for this RIR number.
Use a report builder report that lists the sales order number and RIR number
for this customer. Add a counter on the report that checks the RIR number
and prints when they are not in sequence. In other words someone entered an
order and did not assign the next running RIR number. (IIF(LineCounter <>
SalesHead.Numeric01),"RIR# Error!!!!","OK")
Add this report to Mike Podlin's autoreports to run each day. If you filter
for or display only the error lines the report only prints when someone
screws up. Make the title of the report "Forward to SALES another RIR Order
Error was created!!!!!". I have a 15 to 20 reports that run and check for
our own special conditions/situations like you have here. Sales order entry
needs to be locked down more I run error reports for missing sales rep, zip
code, country, split commission issues, missing group code, missing price,
the good news is I think in 6.0 or Sonoma we can make a field manditory.
Also we can move a VBFORM field like RIR# to the main screen. Hopes this
helps.
Patrick Winter
-----Original Message-----
From: Judy Stauduhar (IS) [mailto:jstauduhar@...]
Sent: Thursday, February 13, 2003 12:56 PM
To: Vantage@Yahoogroups. Com (E-mail)
Subject: [Vantage] 3 different issues- Embedding Quality Doc's in Vant age,
Multi-pl a nt part # question, and one other strange one
Hi,
One would think the PO# or SO# or the lot# that we put on the
packing slip would be enough, but this is a RIR#- which is there own vendor
specific number. I have argued every point I can think of to explain this
number means nothing, and the only way I have come up with is very manual to
include it, but I have lost the battle. They need it, and don't care. We
could use the SO# if we could have numbers in sequential order for that
customer only, but don't know of a way to do that. Any ideas? Thanks, Judy
Message: 8
Date: Thu, 13 Feb 2003 08:25:23 -0600
From: "Winter, Patrick" <pjw@...>
Subject: RE: 3 different issues- Embedding Quality Doc's in Vant age,
Multi-pla nt part # question, and one other strange one
For your customer who: We have 1 customer that wants us to include a
specific number on their shipments that is a sequential number starting at
100 on each of their manufacturing lots.
This sounds like a Purchase Order Number.
Patrick Winter
------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
128 Bit SSL Encryption!
http://us.click.yahoo.com/FpY02D/vN2EAA/xGHJAA/PhFolB/TM
---------------------------------------------------------------------~->
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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Use a report builder report that lists the sales order number and RIR number
for this customer. Add a counter on the report that checks the RIR number
and prints when they are not in sequence. In other words someone entered an
order and did not assign the next running RIR number. (IIF(LineCounter <>
SalesHead.Numeric01),"RIR# Error!!!!","OK")
Add this report to Mike Podlin's autoreports to run each day. If you filter
for or display only the error lines the report only prints when someone
screws up. Make the title of the report "Forward to SALES another RIR Order
Error was created!!!!!". I have a 15 to 20 reports that run and check for
our own special conditions/situations like you have here. Sales order entry
needs to be locked down more I run error reports for missing sales rep, zip
code, country, split commission issues, missing group code, missing price,
the good news is I think in 6.0 or Sonoma we can make a field manditory.
Also we can move a VBFORM field like RIR# to the main screen. Hopes this
helps.
Patrick Winter
-----Original Message-----
From: Judy Stauduhar (IS) [mailto:jstauduhar@...]
Sent: Thursday, February 13, 2003 12:56 PM
To: Vantage@Yahoogroups. Com (E-mail)
Subject: [Vantage] 3 different issues- Embedding Quality Doc's in Vant age,
Multi-pl a nt part # question, and one other strange one
Hi,
One would think the PO# or SO# or the lot# that we put on the
packing slip would be enough, but this is a RIR#- which is there own vendor
specific number. I have argued every point I can think of to explain this
number means nothing, and the only way I have come up with is very manual to
include it, but I have lost the battle. They need it, and don't care. We
could use the SO# if we could have numbers in sequential order for that
customer only, but don't know of a way to do that. Any ideas? Thanks, Judy
Message: 8
Date: Thu, 13 Feb 2003 08:25:23 -0600
From: "Winter, Patrick" <pjw@...>
Subject: RE: 3 different issues- Embedding Quality Doc's in Vant age,
Multi-pla nt part # question, and one other strange one
For your customer who: We have 1 customer that wants us to include a
specific number on their shipments that is a sequential number starting at
100 on each of their manufacturing lots.
This sounds like a Purchase Order Number.
Patrick Winter
------------------------ Yahoo! Groups Sponsor ---------------------~--> Get
128 Bit SSL Encryption!
http://us.click.yahoo.com/FpY02D/vN2EAA/xGHJAA/PhFolB/TM
---------------------------------------------------------------------~->
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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/