- Portability
- Posted by CVegas on February 9th, 2004
I have a fairly complex quote module programed in Access 2 K that is working
great. I would like to know if this same type of quotation process can be
ported to MSCRM or be programed into MSCRM.
I will give example of 1 function of the program. If this can be
accomplished then the other two steps to calculate our [TotalExpectedCost]
should work also.
Based on where the customer wants us to pick up their shipment and where
they want us to deliver their shipment we do the following. IE: pick up in
Airport Code = BOS [OriginAPCode] and deliver in LAX [DestAPCode]
We search our sql table of [LineHaulCarriers] to determine which Line Haul
Carrier's service that city pair.
[OriginAPCode]="BOS" and [DestAPCode] = "LAX"
Depending on the estimated weight the customer will be shipping we calculate
our costs for each line haul carrier that meets the criteria.
Our present system displays all the line haul carriers charges, highlights
the lowest cost line haul carrier, and then saves the lowest cost carrier's
charges in a variable which we use to calculate our [TotalExpectedCost]
The other two parts of the equation are the Pick up charges and the delivery
charges. They basically do the same thing as above. We just add all the
variables together and put our mark up on the order. [TotalExpectedCost] =
([PUChg]+[LHCChg]+[DelChg])*1.2 This is the number we would quote to the
prospect.
Possible?
TIA
- Posted by John O'Donnell on February 9th, 2004
At first glance yes it is possible. Of course needs custom code written but
definately possible
"CVegas" <csanto@chadeen.com> wrote in message
news:2pRVb.38041$fD.22843@fed1read02...
- Posted by CVegas on February 9th, 2004
Thank you for your response. It gets me closer to making my decision to
standardize on MSCRM
"John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in
message news:OZtNA407DHA.2392@TK2MSFTNGP11.phx.gbl...