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...
How to remove last ...
 
Notifications
Clear all

[Solved] How to remove last 0.00 line in detail section  

    Last Post
RSS

Gustavo Carrasquillo
Posts: 35
 Gustavo Carrasquillo
October 9, 2019 8:01 am
(@gustavo-carrasquillo)
21-50 Posts
Joined: 7 months ago
LastLineError

Hi folks,

I am trying to understand why do that 0.00 appears in my report, and how to remove it. Any ideas?

This topic was modified 1 year ago by
4 Replies
Gustavo Carrasquillo
 Gustavo Carrasquillo
(@gustavo-carrasquillo)
Joined: 7 months ago

21-50 Posts
Posts: 35
October 24, 2019 9:43 am
Reply toGustavo CarrasquilloGustavo Carrasquillo
Posted by: @gustavo-carrasquillo
LastLineError

Hi folks,

I am trying to understand why do that 0.00 appears in my report, and how to remove it. Any ideas?

Greetings folks!

For those of you facing this issue with your reports, here's the solution that worked for me:
=IIf([ARTran.InventoryID]<> Null, [ARTran.CuryTranAmt], '')

Hope this helps other people!

Reply
Royce Lithgo
Posts: 445
 Royce Lithgo
October 24, 2019 7:56 pm
(@roycelithgo)
Over 200 Posts
Joined: 10 months ago

Hi Gustavo, it's good that you solved your own problem, but seeing as you are dealing with what I am sure is a custom report, IMHO, the better way to solve this is to filter the data from the report. In other words add a condition to the Filters tab to exclude any rows with InventoryID is null.

Reply
Gustavo Carrasquillo
 Gustavo Carrasquillo
(@gustavo-carrasquillo)
Joined: 7 months ago

21-50 Posts
Posts: 35
October 28, 2019 2:26 pm
Reply toRoyce LithgoRoyce Lithgo
Posted by: @royce-lithgo

Hi Gustavo, it's good that you solved your own problem, but seeing as you are dealing with what I am sure is a custom report, IMHO, the better way to solve this is to filter the data from the report. In other words add a condition to the Filters tab to exclude any rows with InventoryID is null.

That's also a great way for solving this issue! Thanks a lot!

Reply
Tim Rodman
Posts: 2470
 Tim Rodman     ★★ All-Star ★★
December 5, 2019 7:25 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

FYI, my guess is that the extra line is for freight which gets added as the last invoice line if you're using the AR Invoice report.

Reply
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,644 Topics
7,645 Posts
1 Online
1,099 Members

Latest Post: Construction Module/Purchase Orders - Commitments Our newest member: mlaraiv 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.

‹›×

    ‹›×