Freight Costs

I'm not aware of a good canned add-on cost report in Lawson. I have a couple Crystal reports that I use. Do you use Crystal?

No, we don't use crystal reports but if you could give me an idea of what fields you are pulling your data from & I will have someone build a report
Thanks in advance
Kodi

No, we don't use crystal reports but if you could give me an idea of what fields you are pulling your data from & I will have someone build a report
Thanks in advance
Kodi

We have a script that we run once a week to email our AP folks. (I believe that it deals with EDI invoices that have errors due to add-on costs), but it may give you a place to start?
Here is the Oracle sql statement.
set head off
set linesize 150
set pagesize 0
set feedback off
set trimspool on
set termout off
spool /tmp/aoc_alert.txt
SELECT trim(MACINVAOC.AOC_CODE)||':'||
trim(MACINVAOC.INVOICE)||':'||
to_char(MACINVOICE.INVOICE_DTE,'YYYYMMDD')||':'||
trim(MACINVAOC.VENDOR)||':'||
trim(APVENMAST.LEGAL_NAME)||':'
FROM (LAWSON.MACINVOICE MACINVOICE INNER JOIN
LAWSON.APVENMAST APVENMAST ON
MACINVOICE.VENDOR=APVENMAST.VENDOR) INNER JOIN
LAWSON.MACINVAOC MACINVAOC ON
((MACINVOICE.COMPANY=MACINVAOC.COMPANY) AND
(MACINVOICE.INVOICE=MACINVAOC.INVOICE)) AND
(APVENMAST.VENDOR=MACINVAOC.VENDOR)
where MACINVOICE.INVOICE_DTE >= decode(to_char(sysdate,'DY'),'MON',
trunc(sysdate) -4,
trunc(sysdate) -1)
order by MACINVAOC.INVOICE
;

Thanks Greg. That should help.