Importing Report
Can someone help, get the following error when trying to Import a Report.I am using SAGE EvolutionSee More
Theo Verster's Discussions
Importing Report
Can someone help, get the following error when trying to Import a Report.I am using SAGE EvolutionContinue
Started Feb 19
Manufactured Items Cost Comparison 2017 vs 2018
Forum,Urgently need your help.During 2018 we made changes to our Bill of Materials, we added Labour Recovery Rate.I am dumped in the deep end and need a Report, help in the right direction, before…Continue
Started Feb 18
Purchase Order Lines Received
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…Continue
Started Feb 18
Theo Verster's Page
Latest Activity
Theo Verster replied to Matthew Anthony's discussion Inventory Valuation Trend
"Dear Craig,
Getting the following error, I am using Sage Evolution
Description : Invalid sql query near SE WHEN "IM_PeriodPostingHistory"."FiscalCalYear" = CAST( AS CHAR) THEN…"
Theo Verster posted discussions
Theo Verster replied to Theo Verster's discussion Purchase Order Lines received in the group Free Reports Group
"Thank you, Colin"
Colin Spooner replied to Theo Verster's discussion Purchase Order Lines received in the group Free Reports Group
Colin Spooner replied to Theo Verster's discussion Purchase Order Lines received in the group Free Reports Group
"Hi Theo
You are welcome.
I would add an excel formula to your query to calculate the values out - currently your data has a price per unit and a quantity but no sales value for each line. I see that some of the UOM fields are populated with…"
Cliff van der Poll replied to Theo Verster's discussion Purchase Order Lines received in the group Free Reports Group
"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, dbo.GLAMF.ACCTDESCFROM dbo.ICITEM INNER JOIN dbo.POPORH1 INNER JOIN…"
Theo Verster replied to Theo Verster's discussion Purchase Order Lines received in the group Free Reports Group
"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"
Colin Spooner replied to Theo Verster's discussion Purchase Order Lines received in the group Free Reports Group
"Hi Theo
You do not mention the system involved, however, in general there needs to be someting 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…"
Peter Scully replied to Theo Verster's discussion Purchase Order Lines received in the group Free Reports Group
"Hi Theo.
I suggest posting under the relevant category on the forum: http://www.sageintelligencecommunity.com/forum"
Theo Verster added a discussion to the group Free Reports Group
Purchase Order Lines received
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:Kindly RequestedTheo VersterSee More
Profile Information
- Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
- Sage Pastel Intelligence Reporting (Formerly BIC), Excel On Steroids
- How long have you been using the above solution?
- 2 Years
- Where did you hear about us?
- Search Engine
This Weeks Top Content
The Sage Intelligence Blog
Like Sage Intelligence?
Follow @SageSupport
© 2019 Created by Sage Alchemex.
Powered by
