Recent Posts

Forums | Topics

Page 1 / 2 Next

	Post Title	Forum
	RE: Email Statements with Associated Invoices? By Tim Rodman, 1 day ago	Everything Else
	@mikelupro Ya, they moved the Feedback area to somewhere in Community.Acumatica.com but, unfortunately, I don't have access to it since it's only available to those who have a contractual relationship...
	RE: Activities (emails, messages etc.) By Richard, 2 days ago	Acumatica Generic Inquiries & Pivot Tables
	Just some general ideas: Hmm, you might be able to join activities to your PO GI screen ID: PO3010PL. (this way you could sort by a last modified date within the GI) There is a PO lastModifiedDateTime...
	Activities (emails, messages etc.) By Curtis M, 2 days ago	Acumatica Generic Inquiries & Pivot Tables
	I am trying to sort my Purchase orders from time of last activities but have had no luck searching for the activities database. We currently have 240+ open PO's due to numerous supply chain issues wi...
	RE: Acumatica Test Environment By Tim Rodman, 3 days ago	Everything Else
	Good move. Ya, I don't know of a cloud test environment that's just sitting out there to use.
	RE: Acumatica Test Environment By Changsen Wu, 4 days ago	Everything Else
	Don't worry about it. I bit the bullet and moved the other service's ports so that I can run IIS on the default port. I have now successfully managed to install Acumatica.
	Acumatica Test Environment By Changsen Wu, 5 days ago	Everything Else
	Hi I am totally new to Acumatica. Hence bear with me if I sound like a total newbie (which I am). A little bit of background about me first: I have been doing ERP systems implementations for over 20 y...
	RE: Single Stock Item from Multiple product sources By Retha, 5 days ago	Everything Else
	Will cost price per warehouse resolve this?
	RE: How to see who clicked "Approved for Payment" on an AP Bill? By Kevin Halme, 2 weeks ago	Everything Else
	You can also look in the EPApproval table. I don't have approvals turned on for payment, but EPApproval stores the Bill Approval prior to releasing.
	RE: Welcome and Introductions By Tim Rodman, 2 weeks ago	Everything Else
	@travisl Nice logo. You took "Avatar" literally 😀
	Single Stock Item from Multiple product sources By Travis L, 2 weeks ago	Everything Else
	Here's a scenario I need help developing a solution on. We're using FIFO costing. We make a Widget in our factory in the US. We also import the same Widget from another factory overseas. We sell the ...
	RE: Welcome and Introductions By Travis L, 2 weeks ago	Everything Else
	'ello! Just starting an Acumatica implementation so looking forward to it.
	RE: Welcome and Introductions By Jesse Houser, 2 weeks ago	Everything Else
	@timrodman Yes, I plan to attend the next one! Thanks
	RE: Welcome and Introductions By Tim Rodman, 2 weeks ago	Everything Else
	@jhouser Maybe I'll see you at AUG Ohio (click here) in the near future?
	RE: Welcome and Introductions By Tim Rodman, 2 weeks ago	Everything Else
	@asisk I'll see you in Atlanta at AUG Summit 2022
	RE: How to calculate weeks of supply By Royce Lithgo, 2 weeks ago	Acumatica Generic Inquiries & Pivot Tables
	I doubt you can do it in GI as it requires calculations to be applied to aggregates and GI isn't good for that. You might need to migrate the GI to Report Designer and do it there with variables.
	RE: Help to tie Freight Cost to Sales Orders when invoice arrives By alconroy, 2 weeks ago	Accounting in Acumatica
	I did something very similar for dropship orders (sorry I can share the GI at the moment) The links were SOOrder to SOOrdershipment SOOrdershipment to POreceipt POreceipt to APtran APtran to APinvoic...
	Comparison of subtotals in both a subreport and main report By LT8675309, 2 weeks ago	Acumatica Report Designer
	Hello, I have an integration with a 3rd party EDI provider into Acumatica. I need the ability to compare the incoming EDI (derived from non-standard Acumatica tables) total amount of the EDI sales ord...
	RE: Row Level Security - Project “X” not able to be restricted using Restriction Group by Project! Really? By John.Shaddix, 2 weeks ago	Everything Else
	UPVOTE -- Can you all please pass along an "UPVOTE" for this item on the Acumatica Community?
	RE: Welcome and Introductions By Jesse Houser, 2 weeks ago	Everything Else
	Hello everyone! Excited to join this form. I've been with VAR AccuNet for almost a year and am getting up to speed on Acumatica. Eager to learn...
	RE: Welcome and Introductions By Andy Sisk, 2 weeks ago	Everything Else
	My name is Andy Sisk. I am the Ops Finance/BI manager for OxBlue where I use Acumatica daily. I have been working in Acumatica for ~1.5 years.
	Row Level Security - Project “X” not able to be restricted using Restriction Group by Project! Really? By John.Shaddix, 2 weeks ago	Everything Else
	For those using PROJECTS and use a broader group to “APPROVE” individual AP Bills, of which most should not have access to ALL items in the Bills & Adjustments screen … I’ve been informed by Acum...
	How to calculate weeks of supply By Michael Ho, 3 weeks ago	Acumatica Generic Inquiries & Pivot Tables
	Does anyone have a good way to calculate the weeks of supply based on the current available inventory? I’m trying to add this to a GI and my thought was to base it on the qty sold over the past 60 day...
	Help to tie Freight Cost to Sales Orders when invoice arrives By Bryan Emerson, 3 weeks ago	Accounting in Acumatica
	Hello AUG! We are selling ice cream by the truckload to wholesalers and retailers. We have the freight booked through freight brokers and know our freight cost (manual calculation for now) and want t...
	Non-Profit Acumatica Users By Anne Lyness, 3 weeks ago	Everything Else
	Hello! I'm curious to see if there are other users out there in the non-profit sector that use Acumatica? Thanks! Anne
	RE: How to see who clicked "Approved for Payment" on an AP Bill? By Royce Lithgo, 3 weeks ago	Everything Else
	There's a tab on Bills and Adjustments page named "Approval Details" - did you look there?
	How to see who clicked "Approved for Payment" on an AP Bill? By Zsolomon, 3 weeks ago	Everything Else
	The APInvoice table has a value for Last Modified By which updates when a user clicks the checkbox to approve for payment, but Last Modified could easily be overwritten if the payment type needed to b...
	RE: How to format the Parameter List in Text Box? By pmarotta, 3 weeks ago	Acumatica Report Designer
	thanks, the switch command works and that is what I was using, but I was hoping that there was a function like in MS Report Builder. Enjoy
	RE: Is there a way to add the column and row set as a parameter? By MikeLupro, 3 weeks ago	Acumatica Analytical Report Manager (Financial Report Writer)
	@zsolomon DataSelf and Velixo are interesting options.
	RE: Email Statements with Associated Invoices? By MikeLupro, 3 weeks ago	Everything Else
	@timrodman This link no longer works
	RE: Email Statements with Associated Invoices? By MikeLupro, 3 weeks ago	Everything Else
	@timrodman This link goes to a 404 error.
	RE: General Question on SQL Knowledge and ACU By Tim Rodman, 3 weeks ago	Everything Else
	I agree with Patrick. Also, I personally find that my SQL knowledge is very helpful when creating reports in Acumatica. I'm just not sure whether it needs to be a "requirement" or just a "nice to have...
	RE: How to format the Parameter List in Text Box? By Tim Rodman, 3 weeks ago	Acumatica Report Designer
	I can't think of a way to do it other than using a SWITCH statement and converting the values manually.
	RE: Seattle Users Group By Tim Rodman, 3 weeks ago	Everything Else
	Nice! Can you take a picture and post it back here? I can add it to this page:
	Trying to create GI that shows where SOLine.BranchId does not equal SOOrder.BranchId By Lorne W., 3 weeks ago	Acumatica Generic Inquiries & Pivot Tables
	I have created a version of the Sales Orders GI that provides SOLine level data On the SO Line it shows Branch ID (SOLine.BranchID) On the Financial Tab in the order there is Branch (SOOrder.BranchID)...
	RE: Trying to subtract credit (amount) from sales dollars in a GI based on the ARTran table By Lorne W., 3 weeks ago	Acumatica Generic Inquiries & Pivot Tables
	@roycelithgo Brilliant! Thank you. One other question. do you know what I put in the schema field if I want the FinPeriodId to only filter by year? Much appreciate your suggestion
	Cannot email notifications when business event triggers By Paul R., 3 weeks ago	Everything Else
	I have a situation where I want to send an email to an employee (salesperson) when an account they are assigned to changes their status. I have a GI that pulls all the info I need together. I then u...
	RE: Trying to subtract credit (amount) from sales dollars in a GI based on the ARTran table By Royce Lithgo, 4 weeks ago	Acumatica Generic Inquiries & Pivot Tables
	How about this: =IIf([ARTran.DrCr] = 'D', -1, 1) * [ARTran.Amount]) This handles all tran types without having to specify them in the formula.
	RE: General Question on SQL Knowledge and ACU By Patrick Kohler, 4 weeks ago	Everything Else
	From my perspective as a SQL developer, I often get frustrated when working with Generic Inquiries and Report Designer because what would normally be easy in SQL requires you to jump through hoops in ...
	RE: Trying to subtract credit (amount) from sales dollars in a GI based on the ARTran table By nperez, 4 weeks ago	Acumatica Generic Inquiries & Pivot Tables
	Hi Lorne I would use something like this =IIf( [ARTran.Type] = 'CRM',[ARTran.Amount]*-1,[ARTran.Amount]) Create a group by and sum of this field The fields might not match the actual ones, but just th...
	General Question on SQL Knowledge and ACU By byates, 4 weeks ago	Everything Else
	Hello all, Somewhat off the cuff question. I am hiring for a new position in my company and one of the responsibilities will be to help the ongoing implementation of ACU and more pointedly around deve...
	Trying to subtract credit (amount) from sales dollars in a GI based on the ARTran table By Lorne W., 4 weeks ago	Acumatica Generic Inquiries & Pivot Tables
	Hi Everyone, I am trying to build a Generic Inquiry for sales by branch that will match our financials. I have determined that the best way to pull the data is from the ARTran Table using the Branch...
	How to format the Parameter List in Text Box? By pmarotta, 4 weeks ago	Acumatica Report Designer
	I have a Parameter (@Summary) that has Values ( S, P, D) with the Label ( Summary, Project , Detail). I would like to report Title to list the Label Values. Please advise on how to do. @Summary ...
	Automating Sales Order Workflow By jhuang, 4 weeks ago	Everything Else
	I have seen quite a few posts about workflows and this just might be a lack of experience on workflows and customisations. I wanted to see if it is possible to send and open Sales order to be created ...
	RE: Report Sales Orders with duplicate "Customer Order NBR." By LT8675309, 4 weeks ago	Acumatica Report Designer
	Andrew, I was able to get this working today and it is exactly what I needed!!! THANK YOU FOR TAKING THE TIME TO ANSWER!!!!
	RE: Report Sales Orders with duplicate "Customer Order NBR." By LT8675309, 4 weeks ago	Acumatica Report Designer
	Andrew, I haven't had time to try this yet but feel confident since you provided such excellent documentation. Thank You!!!! I will reply to let you know when I have been successful. I just didn't wan...
	Seattle Users Group By Kurt Keating, 4 weeks ago	Everything Else
	Hey Folks, with Acumatica's help we're launching a Seattle Area User Group. You can find and register to be a part of the community page here: Also, September 22nd my company is hosting the first ev...
	RE: Report Sales Orders with duplicate "Customer Order NBR." By Andrew Garcia, 4 weeks ago	Acumatica Report Designer
	@ltussing Oh, I understand. If it were me, I would use the GI that I described before and then create a Shared Filter where the count of the "OrderNbr" field is greater than 1. This will only show you...
	RE: Report Sales Orders with duplicate "Customer Order NBR." By LT8675309, 4 weeks ago	Acumatica Report Designer
	Andrew, Thank again for taking the time to reply! I really appreciate you! I need to identify either the "Customer Order Nbr" that is used multiple times so they can search on the Acumatica Sales Or...
	RE: Report Sales Orders with duplicate "Customer Order NBR." By Andrew Garcia, 4 weeks ago	Acumatica Report Designer
	@ltussing No problem at all. Are you looking for a count of all sales orders that share a Customer Order Nbr? Or do you need the detail of which Acumatica Sales orders share a customer number? I can t...
	RE: Report Sales Orders with duplicate "Customer Order NBR." By LT8675309, 4 weeks ago	Acumatica Report Designer
	Andrew, Thank you so much for taking the time to respond and for the detailed explanation with screen shots! This will certainly come in handy in the future. However, for this requirement, we will hav...