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)

Travis
Travis
@travisl
Forum Home   |   Recent Posts
Trusted Member
Follow
Profile Activity
Topics: 11 / Replies: 29
AllTopicsReplies
Reply
RE: Does Acumatica have a standard functionality that can import Invoices from 'SPS Commerce EDI' ?

You have to have the SPS Commerce integration in order to do this unless you do something custom made. I recommend if you're currently using SPS Comm...

4 months ago
Forum
Everything Else
Reply
RE: Import scenario to update Default Customer Payment Method

@susank17 In an import scenario -1 means create a new line. -2 is delete. Here's a good tutorial on import scenarios: /p>

4 months ago
Forum
Everything Else
Reply
RE: What Happens If the “Create Bill” Checkbox Is Left Unchecked in a Purchase Receipt?

@alconroy I tried to use that create bill option with my old company. The flow was the person doing the receipts (was a purchasing person doing it ma...

4 months ago
Forum
Everything Else
Reply
RE: What Happens If the “Create Bill” Checkbox Is Left Unchecked in a Purchase Receipt?

You can set up the credit card as a cash account since you don't have CC reconciliation. This is the guide I use. If you don't have an Acumatic...

4 months ago
Forum
Everything Else
Reply
RE: Equivalent to Excel Post-Special, "transpose"

@dboulle That was my first go to. I did the pivot table but didn't see a way to do the concatenation on the pivot table data.

11 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Equivalent to Excel Post-Special, "transpose"

@dboulle Product configurator. I think I got it. I had to make a GI for each "feature" I wanted then a GI to with all those individual GI's as data ...

11 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Equivalent to Excel Post-Special, "transpose"

@anne-r-trockman Correct me if I'm wrong. The PMBudget DAC table for each ProjectID has the [PMBudget.CuryActualAmount] and [PMBudget.CuryRevisedAmou...

11 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Equivalent to Excel Post-Special, "transpose"

@anne-r-trockman You can't do it this way that I know of. Figure 1 is how the results look in the GI. Figured 2 is how I want it to look. The resul...

11 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Equivalent to Excel Post-Special, "transpose"

@dboulle thanks Dominic. I know I can do the concat to get the combined datafield. My issue is how can I take the individual lines in the first phot...

11 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Equivalent to Excel Post-Special, "transpose"
11 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 10
Views: 551
Reply
RE: GI to compare FIFO last cost to stock item last cost

I think I have it. I forgot to round the 2nd condition for LastCost by 4 digits so it was not matching. The math was going out to 6 or 7 digits so i...

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
GI to compare FIFO last cost to stock item last cost
1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 1
Views: 673
Reply
RE: Import Scenario AP Invoice

I believe your Type needs to be where Invoice Number is and <Cancel> that. It has to select the document type first before we put in the number...

1 year ago
Forum
Everything Else
Reply
RE: Conditional row font color

@nangel yes. For example let’s do 2 companies. Row 1 for Company 1: create all your text boxes. For Visible set to FALSE. For Visible Expr you wou...

1 year ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Reply
RE: Business Event Triggering from Scheduled GI not updating via Import Scenario

@afriedman Figured it out. It was the import scenario. I was missing "Order Type". That needed to be specified with the order reference number as w...

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Business Event Triggering from Scheduled GI not updating via Import Scenario

@afriedman Changed it. Same thing. It's running 7 times and the GI has 7 records so it's definitely "processing" them. I wonder if something in the...

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Conditional row font color

@nangel I think you would have to create two of the same fields and overlap them. Then use the Visible/VisibleExpr based on the criteria. Set one to...

1 year ago
Forum
Acumatica Analytical Report Manager (Financial Report Writer)
Topic
Business Event Triggering from Scheduled GI not updating via Import Scenario
1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 4
Views: 714
Reply
RE: What would be the value of unlimited address verifications for a fixed price each year?

For us we would prefer a per address fee. Initially we would verify all addresses in the system which is a large up front cost. After that our month...

1 year ago
Forum
Poll Questions
Reply
RE: Exporting a Report to Excel

For those that may have missed it the first time, like me, the row settings are per section. With a new section the rows start back over at 1. I was...

1 year ago
Forum
Acumatica Report Designer
Reply
RE: Coverting attribute to decimal and doing math - wrong result

@jmck I did actually change the formula to be =(cDec([InventoryItem.SPA_Attributes])/100) * cdec([ARTran.Qty]) afterwards. It's not really "resolved"...

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Coverting attribute to decimal and doing math - wrong result

@jmck Thanks for the response. Here's the results. SPA Rate is the attribute and SPA Payment is the cDec. Interesting that cDec is turning it fr...

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Coverting attribute to decimal and doing math - wrong result

@jmck Actually I also have a 0.75 in that value on others. It simply represents a dollar amount. The attribute is an attribute I set up for inventor...

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Add Payment amount to SO Invoice Form

Created a subreport using ARAdjust2 table. Parameters I used was string of RefNbr. Filter is ARAdjust2.AdjdRefNbr = @RefNbr. On the detailSect...

1 year ago
Forum
Acumatica Report Designer
Topic
Coverting attribute to decimal and doing math - wrong result
1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 7
Views: 842
Reply
RE: Show Credit Memos as Negative Amounts

@timrodman Nice! Didn't know that! I've used the filters to filter the report the way I want it then use trace to see the SQL which shows the value.

1 year ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: AR Locations Email adress

It's 2023, someone figured this out yet 🙂 I'm having this issue also.

1 year ago
Forum
Everything Else
Topic
Subreport based on conditional statement
2 years ago
Forum
Acumatica Report Designer
Replies: 0
Views: 699
Topic
Last Subreport value not adding to Variable
2 years ago
Forum
Acumatica Report Designer
Replies: 0
Views: 621
Topic
Pick List report suddenly not splitting on Shipment
2 years ago
Forum
Acumatica Report Designer
Replies: 1
Views: 465
Reply
RE: Pay an AP bill with a Credit Card

@shawn-p-slavin Helped me out 3 years later! Worked perfectly and made the CFO happy.

2 years ago
Forum
Everything Else
Reply
RE: Static notes for customer transferring to sales order

@mcraig Great, we'll try that. Sounds reasonable and easier than a customization.

2 years ago
Forum
Acumatica Dashboards
Topic
Static notes for customer transferring to sales order
2 years ago
Forum
Acumatica Dashboards
Replies: 4
Views: 886
Reply
RE: Accounting Journals that show specific debits/credits

Thank you sir. Good example. I keep forgetting about Pivot Tables as well. We're simple - single ledger, single branch so worked out perfect.

2 years ago
Forum
Accounting in Acumatica
Topic
Accounting Journals that show specific debits/credits
2 years ago
Forum
Accounting in Acumatica
Replies: 3
Views: 762
Reply
RE: Short Payment

Any resolution to this? I'm looking for this same solution.

2 years ago
Forum
Everything Else
Topic
Import scenario - delete stock item conversion with IIF statement
3 years ago
Forum
Everything Else
Replies: 1
Views: 1464
Reply
RE: Single Stock Item from Multiple product sources

@retha Possibly. That makes sense.

3 years ago
Forum
Everything Else
Topic
Single Stock Item from Multiple product sources
3 years ago
Forum
Everything Else
Replies: 2
Views: 808
Reply
RE: Welcome and Introductions

'ello! Just starting an Acumatica implementation so looking forward to it.

3 years ago
Forum
Everything Else

Online Members

  • Nathan Deardorff
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.