Ben Baum
  • Male
  • Pittsburgh, PA
  • United States
Share

Ben Baum's Discussions

Container SQL Query Row Limit
1 Reply

Hello,I have written a bunch of code into a custom container.  My current code is 3998 rows long.  Everything works well inside of the container, but once I hit 'OK' and reopen the container the code…Continue

Started this discussion. Last reply by Ben Baum Nov 28, 2018.

Items Received Today Report
1 Reply

Hello,I am trying to write a report that will tell me all items received today.  I can get a record of this using the JrnlRow.dat file and this query:SELECT * FROM JrnlRow WHERE Journal = 4 AND…Continue

Started this discussion. Last reply by Ben Baum Nov 27, 2018.

Quantity Available Field
1 Reply

Hello,We are trying to write a report that will use the Quantity Available Field.  We are using Sage 50 US Edition and our Qty Available Field is calculated as Qty_on_Hand + Qty_on_PO - Qty_on_SO -…Continue

Tags: Tickets, Work, Available, Quantity

Started this discussion. Last reply by Ben Baum Nov 27, 2018.

 

Ben Baum's Page

Latest Activity

Ben Baum replied to Ben Baum's discussion Container SQL Query Row Limit
"The solution is to make the code a little less readable by combining things into one row instead of stacked on top of each other.  For example, replace: SELECT * FROM Worktkt WHERE Closed = 0 with SELECT * FROM Worktkt WHERE Closed = 0"
Nov 28, 2018
Ben Baum posted discussions
Nov 28, 2018
vanessa Herbert left a comment for Ben Baum
"hi nice to meet you my name is Vanessa i am from Germany i want you to contact me back i have a documentation for you vanessaherbert1872@gmail.com"
Nov 28, 2018
Ben Baum replied to Ben Baum's discussion Items Received Today Report
"Got it working with the help of some old forum posts I found. SELECT "LineItem"."ItemID", "LineItem"."ItemDescription", "LineItem"."Location",…"
Nov 27, 2018
Ben Baum replied to Ben Baum's discussion Quantity Available Field
"Partially Solved!  I was able to write some SQL code and combine it in with the Inventory Analysis container to make a new report that shows Qty on WT which allows me to calculate Qty Available.  I've attached the code for the…"
Nov 27, 2018
Ben Baum posted a discussion

Quantity Available Field

Hello,We are trying to write a report that will use the Quantity Available Field.  We are using Sage 50 US Edition and our Qty Available Field is calculated as Qty_on_Hand + Qty_on_PO - Qty_on_SO - Qty_on_WorkTickets.  The first three variables of that equation are available for use in Sage Intelligence.  However, I cannot find Qty on Work Tickets or Qty Available.  The Available field can be used in normal Sage reports.  The only idea I have for now is to write an SQL query on the WORKTKT.DAT…See More
Nov 21, 2018
Ben Baum is now a member of The Sage Intelligence Community
Nov 21, 2018

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 50-U.S. Edition Intelligence Reporting (Formerly Peachtree)
How long have you been using the above solution?
19 Years
Where did you hear about us?
Sage Intelligence website

Comment Wall (2 comments)

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

Join The Sage Intelligence Community

At 10:00am on January 9, 2019, Ahmed Maris said…
Good Day,
How is everything with you, I picked interest on you after going through your short profile and deemed it necessary to write you immediately. I have something very vital to disclose to you, but I found it difficult to express myself here, since it's a public site.Could you please get back to me on:( mrsstellakhalil5888@gmail.com ) for the full details.

Have a nice day
Thanks God bless.
Stella.
At 1:43am on November 28, 2018, vanessa Herbert said…

hi nice to meet you my name is Vanessa i am from Germany i want you to contact me back i have a documentation for you

vanessaherbert1872@gmail.com

 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service