AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Courses
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Report Designer: Se...
 
Notifications
Clear all

Report Designer: Separate Sum by Total Cases and Total Units in Picking Slip  

    Last Post
RSS

Gustavo Carrasquillo
Posts: 35
 Gustavo Carrasquillo
June 17, 2020 11:41 am
(@gustavo-carrasquillo)
21-50 Posts
Joined: 7 months ago

Hi to all,

I was wondering if there's a way of creating a variable for separating cases amount and single units amount. I am attaching a picture to explain myself better.

Screen Shot 2020 06 17 at 11.35.21 AM

 In this example, I have 1 case, and 18 single units of different items. But the totals the report bring up are 22 pieces (18 single units, plus the 4 units inside the case) and 19 cartons (the case plus the 18 single units). Is there a way of separating the sum depending on the UOM in the original order? I tried 'IIf(([SOShipLine.OrderUOM]<>'CASE'),'0',sum([SOShipLine.Qty]))' and also tried IIf(([SOShipLine.OrderUOM]='CASE'), sum([SOShipLine.Qty]), '0') but none of them work. I do not know a way of configuring a variable to get the expected results. Thanks in advance for your help! 

Topic Tags
variable report designer Reports
2 Replies
Tim Rodman
Posts: 2468
 Tim Rodman     ★★ All-Star ★★
July 4, 2020 2:36 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

Does it work if you remove the single quotes from around your zeros like this?

IIf(([SOShipLine.OrderUOM]<>'CASE'),0,sum([SOShipLine.Qty]))
IIf(([SOShipLine.OrderUOM]='CASE'), sum([SOShipLine.Qty]), 0)
Reply
Gustavo Carrasquillo liked
Gustavo Carrasquillo
 Gustavo Carrasquillo
(@gustavo-carrasquillo)
Joined: 7 months ago

21-50 Posts
Posts: 35
July 8, 2020 6:13 pm
Reply toTim RodmanTim Rodman
Posted by: @timrodman

Does it work if you remove the single quotes from around your zeros like this?

IIf(([SOShipLine.OrderUOM]<>'CASE'),0,sum([SOShipLine.Qty]))
IIf(([SOShipLine.OrderUOM]='CASE'), sum([SOShipLine.Qty]), 0)

Yes indeed Tim,

What I ended up doing was assigning the following formula to the variable $Cases =$Cases+IIf([SOShipLine.OrderUOM]<>[InventoryItem.BaseUnit] , [SOShipLine.Qty],0) and the corresponding formula for the variable $Units. It worked like a charm! Thanks! 

Reply
Tim Rodman liked
  All forum topics
  Previous Topic
Next Topic  
Related Topics
  • Alternate ID Issue
    3 months ago
  • Lot Numbers beside the Item Code
    3 months ago
  • Report from Inquiry Screen
    3 months ago
  • Customizing AP Checks
    3 months ago
  • Sub Report Issue (Hiding A Line That Has No Data)
    4 months ago
Topic Tags:  variable (2), report designer (34), Reports (6),
  Forum Statistics
11 Forums
1,645 Topics
7,641 Posts
2 Online
1,100 Members

Latest Post: Adding bill description on check stub Our newest member: thanh thuy Recent Posts Unread Posts

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×