Hi and thanks for your help,
I am trying to pull information from the Lawson database that will give me a departmental expense report exactly like MM280. I am using Crystal reports to turn the information into a series of nice looking graphs. I have to use the accounting-unit to group my data.
Unfortunately, I cannot make my data pull equal what MM280 shows. My management is not too pleased about this
I am currently pulling using two tables: the POLINE table (using PURCHORDER.PODATE as the date) and using ({POLINE.QUANTITY}-{POLINE.CXL_QTY})*{POLINE.ENT_UNIT_CST} to add up the data.
For the issues I use REQLINE table using this selection query: {REQLINE.KILL_QUANTITY} <> {REQLINE.QUANTITY} and {REQLINE.R_STATUS} = 9 and //to only pull the issues {REQLINE.CREATION_DATE} in lastfullmonth
and this to add up the data: ({REQLINE.QUANTITY}-{REQLINE.KILL_QUANTITY})*{REQLINE.TRAN_UNIT_COST}
Any idea why this would return the wrong information?
Thanks, W