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)

JustPaul
JustPaul
@justpaul
Forum Home   |   Recent Posts
Trusted Member
Follow
Profile Activity
Topics: 8 / Replies: 25
AllTopicsReplies
Reply
RE: which Generic Inquiry is it connect to?

I did try the Access page, thank you @Royce Lithgo. Evidently, Refreshed GI's do not show up in Access page. I can confirm OData does, but nothing f...

3 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
which Generic Inquiry is it connect to?
3 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 2
Views: 1082
Reply
RE: payroll adjusts

If the Paycheck is released, there is no Adjustments ability to that paycheck. You can only void, and re-do the Paycheck (as a Special since the Regul...

4 years ago
Forum
Accounting in Acumatica
Reply
RE: Cannot filter TimeCards based on EPTimeCard.TimeCardType in GI

Mark, I hope my response is helpful. a GI my team wrote for Time Cards is quite complex - so we ended up creating a customization with a view and ...

4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Format any date to 8 characters i.e. 10/5/2020 as 10052020 or 9/1/2020 as 09012020

Post by @thomas-wilk provided the missing formula. Thanks!

4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Format any date to 8 characters i.e. 10/5/2020 as 10052020 or 9/1/2020 as 09012020

I have a similar need, also in a GI, except for the AMOUNT field. The amount field must show NO commas, but always include 2 decimal places. When ...

4 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: GL Account Access - Problem

Maybe i'm just stating the obvious, but the field you are selecting is CASH ACCOUNT, not Account. Cash Account link to the Account, but they are not ...

4 years ago
Forum
Everything Else
Reply
RE: Time Card not importing into Payroll

has the time card been released? Requiring a time card means the time card must be released. if time card has been released, then the other is...

5 years ago
Forum
Everything Else
Reply
RE: Are you going to Acumatica Summit 2021 in May?

While I voted Yes, Definitely;. I am planning to attend and booked everything, but if airlines are a mess and sitting every seat. I may drive. And i...

5 years ago
Forum
Poll Questions
Reply
RE: Importing user accounts

@megan-friesen if you dont have SQL access because its hosted by Acumatica or other, it is not possible to automate when I last attempted in 2019R1....

5 years ago
Forum
Everything Else
Reply
RE: Time Zone Issue

@fred I don't believe this is a time zone issue. But looks pretty serious all the same. is the user entering time using the mobile client? I ha...

5 years ago
Forum
Everything Else
Reply
RE: Creating several Payroll Employees from Employees

Carlos @czarinan, please repost your import scenario or let us know if it still isn't working. I will be working on this same topic this week..and ...

5 years ago
Forum
Everything Else
Reply
RE: Subreport Not Displaying

I would also use caution on sub-reports if the user is ultimately taking the report to Excel. There is a known issue of dropped records in the sub-rep...

5 years ago
Forum
Acumatica Report Designer
Reply
RE: Is There "Unit Accounts" or "Non-Financial Accounts" possible in Chart of Accounts?

you have 2 options that I can immediately think of. 1) Create new range of accounts, and enable UNITS for the accounts. UNITS are + to increase or ...

5 years ago
Forum
Everything Else
Reply
RE: Credit Memo

The Credit Memo needs to be applied to an Invoice / Debit Memo so both documents can move to closed status. Preferred method: WHILE creating the C...

5 years ago
Forum
Everything Else
Reply
RE: Time Zone Issue

The work around for time zone issue is complicated, depending on what is needed by the Users. Technically, Acumatica stores the time & date in UT...

5 years ago
Forum
Everything Else
Topic
Quick filters NOT also displayed on Shared Filters
6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 1
Views: 1887
Reply
RE: Joining Row level security and users table

anyone have an update on this topic. I too am attempting a GI/Report that will provide Row Level Security group with Users who have access. its Not ...

6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Notification Template - detail records
7 years ago
Forum
Everything Else
Replies: 3
Views: 4246
Reply
RE: PO Approval - notifying users on Approved or Rejected

Good morning. I have created a PO Approval process, and notification. The email sends as expected. The need is now to add the PO transaction lines t...

7 years ago
Forum
Everything Else
Reply
RE: DAC - MY first Acumatica report from scratch

Tim & team. to continue with my reporting, I really like the idea of creating client specific DAC because they get used in many various reports. ...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Calendar Period Name in Column

Tim, well, it aint pretty, but clunky works. Thank you very much... who knew that days of yore, when Management Reporter and FRx were so 'advanced'...

8 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Calendar Period Name in Column

Tim, Thanks for responding, however that formula only produces formatted periods. ie 07-2017, 08-2017 not the financial period name: July, August

8 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Topic
Calendar Period Name in Column
8 years ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Replies: 6
Views: 4689
Topic
DAC - MY first Acumatica report from scratch
8 years ago
Forum
Acumatica Report Designer
Replies: 3
Views: 4417
Topic
Report as data source
8 years ago
Forum
Acumatica Report Designer
Replies: 2
Views: 2919
Topic
import scenario w/ transaction TYPE switch
8 years ago
Forum
Everything Else
Replies: 4
Views: 4419
Reply
RE: Formatting a number as a whole number in Acumatica Report Designer

I was thinking the same thing. But also. Is it possible to format the fields individually, then create a text box or calc field then bring all th...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Formatting a number as a whole number in Acumatica Report Designer

Tim. similar situation. I am attempting to build a flat file that will be uploaded to bank for positive pay. the dollar amount cannot show comma or ...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Flat file or text file output

My initial assumption is the export scenario is INSTEAD of printing a check. The Fedwire option is to process ACH payment. I need to print physical c...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Flat file or text file output

Output sample: 0000091074200000921826022417000XXXXXXXXXXXXX COMPANY T 0000091075200000045823022417000XXXXX T 000009107620000024360002241700...

8 years ago
Forum
Acumatica Report Designer
Reply
RE: Flat file or text file output

Is it possible to use parameters in export solution? Like date (s) or range. I'm not sure how to even get started with export solution. Could you ...

8 years ago
Forum
Acumatica Report Designer
Topic
Flat file or text file output
8 years ago
Forum
Acumatica Report Designer
Replies: 9
Views: 6015

Online Members

  • Tim Rodman
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.