AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • 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)

Tim Rodman
Tim Rodman
@timrodman
Forum Home   |   Recent Posts
Admin
Famed Member
Follow
Profile Activity
Topics: 244 / Replies: 2960
AllTopicsReplies
Reply
RE: Display Budget Amount in Item Request

This JOIN looks a little funny to me: Is that BUDGET DETAILS tab in your screenshot just pulling from the regular General Ledger budget? If so, I'm...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Grouping item QTY

Still not seeing an attachment. Make sure to click the Attach Files button after uploading the attachment.

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Multiplication in Results Grid

Shawn's way is the only way that I'm aware of as well. I would say that it would be a nice feature to have, but I'm not sure it would be that simple s...

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Audits against Enable/Disable features

I don't know for sure, but, ya, it looks that way to me too.

8 years ago
Forum
Everything Else
Reply
RE: Adding background image using database source

Ah, I see. That's a good use case. Have you tried just adding an image field over the top rather than using the background image feature?

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Import Scenario for Kit Assembly including Allocations for multiple Stock Components

You should be able to use Locations in there too. I just picked the Locations field because the first item I grabbed was not Lot or Serial tracked.

8 years ago
Forum
Everything Else
Reply
RE: Audits against Enable/Disable features

I don't even have the Audit History... option on the Enable/Disable Features (CS100000) screen. I have it on the Journal Transactions (GL301000) scr...

8 years ago
Forum
Everything Else
Reply
RE: Line Break data in Import Scenario

I tried this: But I also didn't have any luck. It imported like this:

8 years ago
Forum
Everything Else
Reply
RE: Acumatica Document/Report Rendering problems

You might be able to get Acumatica to fix it, but my impression of watching Report Designer the past few years is that Acumatica views it as "good eno...

8 years ago
Forum
Everything Else
Reply
RE: Approval maps

I'm pretty sure that my workaround would still work for multi-level approvals. For each approval level, you would assign the appropriate "dummy" emplo...

8 years ago
Forum
Everything Else
Reply
RE: Adding background image using database source

I can't think of another way unfortunately. What logic are you wanting to use to determine which background image you are going to pull from the datab...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Import Scenario for Kit Assembly including Allocations for multiple Stock Components

Hi Royce, I spent some time on this, but wasn't able to figure it out. Your best bet is probably to open an Acumatica support case. I actually think t...

8 years ago
Forum
Everything Else
Reply
RE: Line Break data in Import Scenario

What specific screen and field are you trying to import this into?

8 years ago
Forum
Everything Else
Reply
RE: Acumatica Document/Report Rendering problems

Hi Garrett, There is a lot of inconsistency between the PDF and HTML versions of reports. In general, if you want better control, go with PDF. The pro...

8 years ago
Forum
Everything Else
Reply
RE: Adding background image using database source

I just tried it too. I was only able to get it to work with a Source of Embedded.

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Restriction Groups

Your approach seems correct to me. Personally, I'd go with Type A groups. Type B groups make my head hurt.

8 years ago
Forum
Everything Else
Reply
RE: publishing GI bundle

Actually, the Generic Inquiry should have the Site Map entry in it. I was wondering if you included the Site Map entry in the Customization Project be...

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Integrating 3CX with Acumatica

You might try reaching out to Jeremy Osterhouse: He's listed together with abulger as a contributor to the Github project:

8 years ago
Forum
Everything Else
Reply
RE: Customization - Add a field from a different table

Bummer, I thought that was going to get it for you. Not sure why it's empty.

8 years ago
Forum
Everything Else
Reply
RE: Do not consider return location in Replenishment

Thanks for the feedback Troy. I hope that you're able to work through the kinks.

8 years ago
Forum
Everything Else
Reply
RE: Reversing or undoing an incorrect Kit Assembly

Agreed. Definitely not user friendly.

8 years ago
Forum
Everything Else
Reply
RE: Grouping item QTY

You have to use the File -> Save As... button to save as .rpx. Take a look at this post which discusses this more:

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Approval maps

@mikelupro - Good point. It would be more correct to say that it works its way through the true conditions until it reaches a true condition that has ...

8 years ago
Forum
Everything Else
Reply
RE: Import Scenario for Kit Assembly including Allocations for multiple Stock Components

Hi Royce, Just curious, what's the reason for the Stock Components -> Inventory ID line? Does that line already exist and you're trying to update i...

8 years ago
Forum
Everything Else
Reply
RE: Import Scenario for Kit Assembly including Allocations for multiple Stock Components

Can you include a screenshot of your import scenario definition?

8 years ago
Forum
Everything Else
Reply
RE: Do not consider return location in Replenishment

Awesome! You are over the first major hurdle, getting engineering to agree to it being a bug. Now it just needs to get fixed...

8 years ago
Forum
Everything Else
Reply
RE: Integrating 3CX with Acumatica

Are you looking to do something like this?

8 years ago
Forum
Everything Else
Reply
RE: Reversing or undoing an incorrect Kit Assembly

Hi Royce, I haven't encountered this, but the behavior that you are describing seems consistent with the "audit trail" functionality that you will fin...

8 years ago
Forum
Everything Else
Reply
RE: publishing GI bundle

Did you add both the Generic Inquiry and the Site Map entry to your Customization Project? You would know because it would look something like this in...

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Move Dashboards from one company to another

Now if they could just add the ability to package Pivot Tables in a Customization Project!

8 years ago
Forum
Acumatica Dashboards
Reply
RE: PO Accrual Account

Not that I know of unfortunately. The Purchase Receipt Accrual Summary (PO630500) and Purchase Receipt Accrual Details (PO631000) reports are not date...

8 years ago
Forum
Everything Else
Reply
RE: Formula to calculate Total line items

In the Parameters field on the Subreport in the Main report, you are passing =[SOShipment.CustomerID] like this: Try changing =[SOShipment.CustomerID...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Print Refund Check for Customer

Hi Troy, Are you using a Clearing Account on your Cash Account? I thought that's what causes things to accumulate in the Undeposited Payments report.

8 years ago
Forum
Everything Else
Reply
RE: Customization - Add a field from a different table

Did you try searching for "list" in the Data View field?

8 years ago
Forum
Everything Else
Reply
RE: Notification email status is always DRAFT.

I totally agree as well. It would be great if these separate processes were consolidated together. Taylan, can you share what the two different attach...

8 years ago
Forum
Everything Else
Reply
RE: Approval maps

Hi Grant, Do you have something set in the Pending Approval Notification column of the APPROVAL tab on the Accounts Payable Preferences (AP101000) scr...

8 years ago
Forum
Everything Else
Reply
RE: User-Role Access to Customers

Hi Ron, Have the Answers area under the Customers screen like this:

8 years ago
Forum
Everything Else
Reply
RE: Missing Dashboard Button

Ya, like one thing I'd like to see soon is the ability to package a new menu into a Customization Project.

8 years ago
Forum
Acumatica Dashboards
Reply
RE: AR Aging Summary Dashboard

You can use the Generic Inquiry that Shawn mentioned, add an Aging Bucket column, and put a Pivot Table on top. It's easier to show in a video so I re...

8 years ago
Forum
Acumatica Dashboards
Reply
RE: Formula to calculate Total line items

Did you make changes to the reports? If so can you attach the current versions?

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Missing Dashboard Button

What I'm still getting used to is that the new menu structure is completely disconnected from the old Site Map, at least as far as I can tell. The old...

8 years ago
Forum
Acumatica Dashboards
Reply
RE: Accounting for Prepayments in Foreign Currency under IFRS

Hmmm, wish I could help further on this, but my Acumatica foreign currency knowledge is limited. Have you tried a support case with Acumatica?

8 years ago
Forum
Everything Else
Reply
RE: Discounts - Generic Inquiry

Try adding DiscountID as an additional column to your second join.

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Offset Vendor and customer balances

As far as I know, you have to manually make the entries in each module (AP and AR) using some kind of GL clearing account. You might want to add your ...

8 years ago
Forum
Everything Else
Reply
RE: Grouping item QTY

Can you attach your .rpx file?

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Depreciation calculation rule

Hi Levan, Sorry, I'm not going to be much help here since I'm not that familiar yet with the Fixed Assets module. Doesn't it seem like you would need ...

8 years ago
Forum
Everything Else
Reply
RE: Do not consider return location in Replenishment

I'm no help on this one, never encountered it before. But it doesn't surprise me, the Replenishment settings are pretty basic. You might look into a c...

8 years ago
Forum
Everything Else
Reply
RE: Period 13 End Date in ARM Report

Hi John, Can you also include a screenshot of report screen before you clicked the RUN REPORT button that shows the report parameters? FYI, you might ...

8 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Sales Order Import by Scenario

Can you include a screenshot of the Import Scenario definition? I suppose you did make sure that the Inventory ID is valid?

8 years ago
Forum
Everything Else
Reply
RE: SQL View for Generic Inquiry - Debtors Day KPI Widget

I've run into the same problem before. I wish the script would just take the column names from the SQL View and not try to be so smart.

8 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Page 51 / 65 Prev Next

Online Members

 No online members at the moment

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.