Thanks Dale,
True enough. That was one of the 4 methods we've tried so far. The
system even has a facility for something along those lines: "Misc Charge
Codes" show up basically as line items on the po.
The main problem with that method (at least for our accounting system):
Add another line item and see what happens!
PO
Item XYZ 100 @ 10.00
SAC rebate 100 @ -1.00
SAC discount 100 @ -0.50
Item ABC 100 @ 10.00
SAC rebate 100 @ -1.00
SAC discount 100 @ -0.50
Accounting system lists all ***FOUR***
Item XYZ 100 @ 10.00
Item ABC 100 @ 10.00
Item SAC-rebate 200 @ -1.00 <--unless these codes are unique
Item SAC-discount 200 @ -0.50 <--they get munged togther!
INV
IT1 Item XYZ data
IT1 Item ABC data
SAC SAC-rebate data joined
SAC SAC-discount data joined
If the system would support completely ad-hoc items, you could dynamically
generate item discount codes so they would be unique, like "Item XYZ
Discount A" but it doesn't that I am aware of. The codes must be configured.
Thanks,
Travis-
-----Original Message-----
From: Dale Marthaller [mailto:[EMAIL PROTECTED]
Sent: Friday, April 20, 2007 11:57 AM
To: Travis Truax; [email protected]
Subject: RE: [EDI-L] Complex SAC segment handling in 850 & 810
Is is possible with your accounting system to emulate SAC's with fake item
codes. Lets say that you had a PO with one item and two SAC's.
PO
Item XYZ 100 @ 10.00
SAC rebate 100 @ -1.00
SAC discount 100 @ -0.50
Accounting system list all three
Item XYZ
Item SAC-rebate
Item SAC-discount
INV
IT1 Item XYZ data
SAC SAC-rebate data
SAC SAC-discount data
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
Travis Truax
Sent: Friday, April 20, 2007 7:41 AM
To: '[email protected]'
Subject: [EDI-L] Complex SAC segment handling in 850 & 810
Please excuse the length of this post & the number of questions. I
appreciate your time reading it. :)
We have a [crappy] accounting system that has 2 serious issues with
discounts.
1. It can't handle anything except a discount percentage. No detail of what
the discount is for, no sac codes, no rates, amounts, etc.
2. I can only enter *one* discount per header or line.
As you can imagine, it's a major challenge to get 3 discrete discounts on
one line item of a po into the customer's invoice when I have to aggregate
the discount percentages of all 3 discounts into one extended discount.
Currently, I write the sac info out to an extension table to be referenced
later by the invoice.
Here's were the serious failure occurs:
This [crappy] accounting system also does not handle multiple ship to
locations on the same po (sdq/spreadsheet type order) - so I have to build
multiple orders from one spreadsheet order. How can I associate ONE set of
discounts with potentially MANY orders?
*Slice up the total discount among all the orders?
*Apply all the discounts to one of the orders?
*Give up and throw out the discounts as punishment for using sdq
segments?
*Other options...
Tangent Questions:
Do most customers require their sacs sent back just as they sent
them?
How would one handle discounts on POs that are not "directly
associated" with the PO? To elaborate - if the discounts are not requested
to be subtracted from the invoice, they would not be entered into the sales
order (at least in our [crappy] accounting system).
Thanks,
Travis-
[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/
