Please assist, I am trying create a report indicating Purchase Order Lines received in a specific period however I need to exclude non stock items and PO's for utilities. I only want to look at Stock Items.
Thus the GLAccountsFull must be linked, I have tried every which way but with no luck.
I want to include or exclude certain GL Accounts in the parameters.
Here is what I have now:
I suggest posting under the relevant category on the forum: http://www.sageintelligencecommunity.com/forum
You do not mention the system involved, however, in general there needs to be something that will connect to create a connection!
If you are using purchase order lines, do they contain a GL code? If so, then you will need to link that field to your "GLAccountsFull" field that contains the GL account number.
Another way would be to add an analysis field to your inventory items that flags "stock" items and then connect PO lines to the stock master file and only include items flagged as "stock" items in the query.
Thank you, Colin
Perhaps you can help me with this one, I need to see the spend per month however when I run this particular report (attached) it lists the Material number in sequence.
We are Using Sage Evolution Version 7.20.7.000
Thank you, Colin
SELECT dbo.POPORH1.PONUMBER, dbo.POPORH1.DATE, dbo.POPORL.COMPLETION, dbo.POPORL.ITEMNO, dbo.POPORL.ITEMDESC, dbo.POPORL.ITEMEXISTS, dbo.POPORL.LOCATION, dbo.ICACCT.INVACCT,
FROM dbo.ICITEM INNER JOIN
dbo.POPORH1 INNER JOIN
dbo.POPORL ON dbo.POPORH1.PORHSEQ = dbo.POPORL.PORHSEQ ON dbo.ICITEM.FMTITEMNO = dbo.POPORL.ITEMNO INNER JOIN
dbo.ICACCT ON dbo.ICITEM.CNTLACCT = dbo.ICACCT.CNTLACCT INNER JOIN
dbo.GLAMF ON dbo.ICACCT.INVACCT = dbo.GLAMF.ACCTID
WHERE (dbo.POPORL.COMPLETION > 1)