Hi Travis --
I have several thoughts, but I had a similar dilemma when trying to
automate a company that had a very complex pricing models. They called
it configured pricing. Their pricing manager seemed almost proud that
they had hired a consultant & he wasn't able to figure out how to
download their pricing into an EXCEL spreadsheet based upon all of their
configurations.
Their distributors would get a set discount -- example of 20%. In
addition, there might be special pricing based upon channel: DOD got
another discount, educational institutions another, etc. Then there
might be a special marketing program offer, "end of quarter get product
out the door special", etc.
My suggestion to you is:
* have your distributors/customers send their net contract price on
the PO1
To manage the other scenarios there were 2 options:
* Option 1: Create unique skus for each part number/channel (solve
most of the issues). Perhaps even create special SKU's for
programs.
* Option 2: Incorporate a Request for Credit/Response. So the
orders are placed with the contract discounted price only. Then
your distributor/customer or company places a separate request for
credit which can be incorporated in a database, reviewed, & then
the appropriate credits are issued. There are EDI transactions
for this, but you could also first implement a comma delimited
file. Then your order management/invoicing process is simple, and
you are dealing with exception processing outside of the order
management process.
Finally, you might have to work with and educate your marketing
management; that the company does not have a sophisticated system, and
their marketing/pricing plans are not in synch with their strategic
strategy of making your company easy to work with. Even though they
were able to do this at Proctor & Gamble, you are a small operation.
This gets delicate, but needs to be communicated. Frequently, companies
have quarterly reviews with their key customers & this could be broached
at this time with them. Naturally you would have to work a program
with your customers, to understand their issues, too.
Feel free to contact me offline if you wish to discuss further. It is
difficult to assess the root cause of your problem with so little
information, but this appears to be a broken business process, and not
something you should try to fix with as only an EDI mapping issue.
Good luck
Susan Stecklair, President Electronic Commerce, Inc.
<http://www.ecommerce-inc.com>
Your Leader in EDI, Web 2.0, Integration Services and Products
blog <http://www.ecommerce-inc.com/trends> on eCommerce Trends, Issues
and Outsourcing
( 408.996.7492 Business Office
[Non-text portions of this message have been removed]
...
Please use the following Message Identifiers as your subject prefix: <SALES>,
<JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
Job postings are welcome, but for job postings or requests for work: <JOBS> IS
REQUIRED in the subject line as a prefix.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/EDI-L/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/EDI-L/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
