AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
New Item Class Tree...
 
Notifications
Clear all

Questions New Item Class Tree Structure and RLike Report Condition

 
Acumatica Report Designer
Last Post by Tim Rodman 7 years ago
1 Posts
1 Users
0 Reactions
4,630 Views
RSS
Tim Rodman
Posts: 3199
 Tim Rodman
Admin
Topic starter
October 30, 2018 11:16 am
(@timrodman)
Famed Member
Joined: 10 years ago

In Acumatica, you can now have a Tree Structure on the Item Classes like this:

 

But when you go to a report, like the Inventory Balance (IN615000) report, and click the Lookup, the list is flat without any tree structure:

 

So I was curious, how does the Inventory Balance (IN615000) report know to include FOOD-300-PKGFOODS when I run the report for the FOOD Item Class? It does which is cool, but the "how" is what I wanted to know.

Looking at the report in Report Designer, it appears that the way it knows is by using the RLike Condition:

 

Which translates into this in SQL:

[INItemClass_INItemClass].[ItemClassCD] LIKE 'FOOD %' OR 'FOOD' IS NULL

 

So, that requires every Item Class that is underneath a Parent Item Class to begin with the same characters as the Parent Item Class. Very interesting.

Then I was more curious, what happens if I change Item Class ID on an existing Child Item Class? To find out, I changed FOOD-300-PKGFOODS to FD-300-PKGFOODS.

 

When I press Save, it automatically moves out from underneath the Parent Item Class:

 

And now, when I run the Inventory Balance (IN615000) report for the FOOD Item Class, the FD-300-PKGFOODS Item Class is not included.

 

So I learned two things:

1. RLIKE is basically a Begins With condition.

2. The new Item Class Tree Structure is purely based on the leading characters of an Item Class, not a true parent/child relationship. At least that's what it looks like to me.


Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,527 Topics
  • 10.9 K Posts
  • 26 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • amassey
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×