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)

Donna Boes
Donna Boes
@bodonna
Forum Home   |   Recent Posts
Eminent Member
Follow
Profile Activity
Topics: 5 / Replies: 22
AllTopicsReplies
Reply
RE: Formatting a number as a whole number in Acumatica Report Designer

I was able to do this in the dunning letter using this formula. Format('{0:#,###.00}',Sum( IIf([ARDunningLetterDetail.Overdue], [ARDunningLetterDetai...

4 years ago
Forum
Acumatica Report Designer
Reply
RE: In a report where every row is set up the same, one row produces an odd looking result

Do you have something in the format row on the column set?

4 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Printing Lines

If you look at the Column set you probably have a row that has a height of 1 or 2 and the the background color will be black.

4 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Customer Location on Statement

I got it after adding the AR Invoice table to the report!

5 years ago
Forum
Acumatica Report Designer
Topic
Customer Location on Statement
5 years ago
Forum
Acumatica Report Designer
Replies: 2
Views: 770
Reply
RE: Type Ahead Projects

Instead of a new project you could add a new task and then complete the task when it's finished. The user would not be able to grab a completed task ...

6 years ago
Forum
Everything Else
Topic
Stack Imports
6 years ago
Forum
Everything Else
Replies: 1
Views: 2390
Reply
RE: Shifting Year Back in Title

Try this =Format( '{0: MMM d, yy}', DateAdd( Report.GetPeriodEndDate(@StartPeriod), 'm', 1))

6 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Deferred Revenue

I did find out you can not delete them but you can put all the remaining costs into an un-posted line and change the GL account.

6 years ago
Forum
Everything Else
Reply
RE: Apply a cash receipt from one customer to multiple cusetomers

You need to have the Consolidate Balance checked.

6 years ago
Forum
Everything Else
Reply
RE: Apply a cash receipt from one customer to multiple cusetomers

You can if you set up parent child relationships

6 years ago
Forum
Everything Else
Topic
Deferred Revenue
6 years ago
Forum
Everything Else
Replies: 2
Views: 2357
Reply
RE: PO Accrual Account

You need to join the AP Tran table.

7 years ago
Forum
Everything Else
Reply
RE: Understanding Consolidations

Yes please!

7 years ago
Forum
Everything Else
Reply
RE: Security on Unit Set

We have assigned the security unit to a unique report and then granted security to only that report.

7 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Percentage of Total Revenue and Percentage of Total Expenses

That was it!!!! Thanks!!!!

7 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Percentage of Total Revenue and Percentage of Total Expenses

These are the results I get.

7 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Percentage of Total Revenue and Percentage of Total Expenses

When I tried that it only calculates in one of the columns. 🙁

7 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Percentage of Total Revenue and Percentage of Total Expenses

Is it possible to do this for each column? When I tried it only calculates the first % ?

7 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: FA: Useful Life locked from Asset Class

We set up asset classes for each useful life Years. FFE-5Years FFE-7Years

7 years ago
Forum
Everything Else
Reply
RE: Fixed Asset - Depreciation Performance issue

I hate to hear this I have a client with a large number of fixed assets but they are on a smaller license. They don't want to upgrade to a bigger lic...

7 years ago
Forum
Everything Else
Reply
RE: Report P&L by department and location/segment using sub accounts

Have you tried a unit set?

7 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Topic
PO Accrual Account
8 years ago
Forum
Everything Else
Replies: 4
Views: 4235
Reply
RE: Additional Remittance Form

Yes

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Additional Remittance Form

That's what I'm trying to figure out how to do....It has some kind of restriction on it that I think is tied to the lines per stub. It will not print...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Additional Remittance Form

Instead of printing the AP 64.10.00 I would like to print the AP.64.20.00 in it's place. The actual bill payment part is done manually through the ba...

8 years ago
Forum
Acumatica Report Designer
Topic
Additional Remittance Form
8 years ago
Forum
Acumatica Report Designer
Replies: 8
Views: 4591

Online Members

  • John Doe Updated
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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