Craig
I'll jump in with my two cents worth. I work with an EDI software provider
that provides integration to back end ERP systems (we do not actually supply
the ERP systems just the EDI and integration capabilities) so this is
something that we've come across before. The issue could be with the EDI
system, although any good EDI system should be able to figure this out, and
it could be with the ERP system. There is one ERP system that we work with
that only has two or three hard coded fields for discounts such as trade
discounts, new store allowances, etc so we have to get creative when putting
the information into the ERP and then sending it back correctly to the TP.
Most systems that I have worked with, however, allow for as many allowances
or charges as are needed so it makes it much easier.
We have over 1400 different TP bundles in our Library, of which I am happy
to tell you that Big 5 is one. Of course not all of these sent 850s (i.e.
automotive TPs, etc) but many of them do. I don't think I have ever seen
anyone calculate for my client what the cost of the line or PO should
actually be for them. Usually all we ever receive is the PO1 with the qty
and unit price and if applicable an SAC at the line or header level. It is
then up to us to calculate the invoice as needed.
If you really wanted to try to appease everyone there are a few things that
you could do. One thing that I can think of is to add a second CTP loop.
Currently you are only sending the retail price, but you could send the
adjusted price as well. This segment gives you the ability to put the unit
price, qty, multiplier (i.e. 90 for a 10% discount) and then monetary
amount. You'd be pretty well writing out the whole calculation for them on
every line item. If you wanted to simply send it as a total PO calculation
you could just use the AMT segment after the CTT in Table 3 of the PO.
Jaret Caravan, Edisoft
Sr. EDI Consultant
[EMAIL PROTECTED]
phone: (416) 299 0030
fax: (416) 297 1289
www.edisoft.com
Revision to the PO Map (850).
Posted by: "Dunham Craig E." [EMAIL PROTECTED] edibig5
Tue Dec 9, 2008 8:59 am (PST)
OK, I'm seeking advice from the group...
My accounting department (ok, one guy) is saying that our vendor community
can't seem to get the concept of figuring out allowances for invoices.
Here's an example -
Cost - $10.00
Allowance - 10%
Quantity - 1000
Just using that simple concept - it's basic math - not far and above the 6th
grade... You'd set it up like this:
(C*A)*Q=Net Cost
Right? I mean, am I over simplifying this...? To all of you on the
"vendor/supplier/manufacturer" side of the coin - are your systems so ...
stupid ... that they can't do a simple calculation such as this?
But, I digress - as usual.
Instead of putting the onus of the math on the vendor side, this genius in
accounting wants us to transmit a total dollar value of the invoice (with
allowances applied) and a total number of units being ordered. His thought
process is that the vendor (i.e. you) would be able to balance the incoming
dollar amount of the PO against your sales order and also against the
invoice(s) generated by the sales order.
So, I know that I can use the AMT segment for the total dollar value of the
PO. That's kind of a given. But I can't seem to find a segment to use to
populate the total quantity being ordered. I was thinking of using the "hash
total" in the CTT segment, but that's having the translation process add up
those numbers. Our programmers have captured the total value and quantity
during the PO creation/printing process and populate some data fields that I
can then map from - a fixed number, calculated by the program - and populate
the 850 map to be sent.
So, the question is - where do I put the data...? Your suggestions? Where do
you see the data (if you receive a PO) or where do you put it (when you send
a PO)....?
Craig E. Dunham
EDI Coordinator
EYE Analyst
------------------------------------
...
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/
