Theo Verster
  • Male
  • Vereeniging
  • South Africa
Share

Theo Verster's Groups

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 posted a discussion

Importing Report

Can someone help, get the following error when trying to Import a Report.I am using SAGE EvolutionSee More
Feb 19
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…"
Feb 18
Theo Verster joined Bron Dorrofield's group
Feb 18
Theo Verster posted discussions
Feb 18
Theo Verster replied to Theo Verster's discussion Purchase Order Lines received in the group Free Reports Group
"Thank you, Colin"
Feb 18
Colin Spooner replied to Theo Verster's discussion Purchase Order Lines received in the group Free Reports Group
Feb 18
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…"
Feb 18
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…"
Feb 18
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"
Feb 18
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…"
Feb 18
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"
Feb 18
Theo Verster added a discussion to the group Free Reports Group
Thumbnail

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
Feb 18
Theo Verster joined Sage Alchemex's group
Feb 14
Theo Verster is now a member of The Sage Intelligence Community
Feb 11

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

Comment Wall

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

  • No comments yet!
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service