Recent Posts
Forums | Topics |

Page 1 / 2 Next

	Post Title	Forum
	RE: Acumatica Lot and Serial Number Attributes By mgraci, 9 hours ago	Everything Else
	@bnowatzky Bob, how did you do it? I'm trying to show the attributes from the receipts to carry with the item through to the invoice.
	Acumatica 2020 R2 (Cash Return) By Brent Leis, 20 hours ago	Everything Else
	We have been looking at upgrading from Acumatica 2019 R1 to version 2020 R2 but have heard there is some functionality that could be going away. Is anybody aware of them doing anything to the CR (Cas...
	RE: Freight cost not showing in order profitabilty figures By daniel, 1 day ago	Everything Else
	@kevin-ruppert Thanks for the info you gave earlier. I'm now relooking at this, its been quite busy so I hadn't gotten around to it. Would you be able to give more details as to how you created this G...
	Void Payments with application via Import Scenario By redrum, 2 days ago	Everything Else
	I created an import scenario a while ago that voided duplicate payments from an integration bug. Those payments were not applied to an invoices and voided without issue. Now we need to void about 50...
	Contract Based REST API to GET StockItem Attributes By JohnSP, 2 days ago	Everything Else
	Does anyone have experience and examples to share using the Contract Based REST API to get StockItem attribute values from an Acumatica instance? I’m able to retrieve StockItem data via the REST API b...
	Import sales orders with multiple items By Terry Y, 2 days ago	Everything Else
	For orders import scenario, I use <Line Number>=-1, then use same order number, number 7 in this example, in template to import 2 items into 1 sales order, but system always try to create 2 dif...
	RE: Update Existing Vendor Import By ne, 3 days ago	Everything Else
	@timrodman This seems to work for me, but if i have already another vendor as Default its keeping now both vendors as default
	How to have a Register Report automatically print when Release button is clicked? By Mike Baio, 4 days ago	Everything Else
	Is it possible to have the system automatically generate and print a register report when user clicks on the release button during entry?
	RE: Pulling Revenue Year to Date (YTD) figures from GLHistory for Dashboard Scorecard By AhmedBahar, 5 days ago	Acumatica Generic Inquiries
	@greg-polsky I am trying to achieve the same thing you are: show only the YTD value for the most recent financial period: Attachment:image.png I haven't had any luck though. Here are my joins and co...
	Employee Time Cards By lrains, 6 days ago	Acumatica Generic Inquiries
	I am trying to map my way from the Employee Time Card details to the ARTran table but I am loosing the "link" at project transactions The use case is as follows: Employee creates a time card Every l...
	Add Line Graph to new tab on Inventory/Stock Items Screen By b-co, 1 week ago	Everything Else
	Hello, I am wondering if it is possible to add a line graph like the below onto a new tab on a stock item, to show the last 12 months volume? Basically, it will be putting the Inventory Transaction ...
	Generic Inquiry with a Parameter for an Export Scenario By Michael Roszkowski, 1 week ago	Acumatica Generic Inquiries
	I created a Generic Inquiry that I am going to use as the screen for an Export Scenario. I have the export scenario working but now I want to limit my result set for a specific date. Any way I can d...
	Is the Parameter Schema Field Mandatory? By Damon, 1 week ago	Acumatica Generic Inquiries
	The wiki says that when setting up Parameters, selecting a Schema Field is optional: Attachment:SchemaField.png But when i try to set up a parameter without a Schema Field, i get Error: 'Schema Fi...
	RE: Filter by Current UserID By gprice, 1 week ago	Acumatica Generic Inquiries
	The easiest solution I have found is to add a hidden Parameter to your GI. Reference the parameter to the ID field that you to filter off (eg for EPApprovals it would be OwnerID) Make the default of ...
	RE: Can a customer Cross Reference for a parent account feed automatically to child accounts? By daniel, 1 week ago	Everything Else
	Just looking further into this - I think the easiest way to go about this is to add the cross-reference items as Global rather than Customer. I know that this makes it available for all customers, but...
	RE: Can a customer Cross Reference for a parent account feed automatically to child accounts? By daniel, 1 week ago	Everything Else
	Thanks a lot for letting us know as to the options here @michaelhansen. I looked into the two options suggested. Currently the child accounts are separate accounts, rather than locations. However, to ...
	RE: Shipping attention field override not reflecting on invoice form. By MichaelHansen, 2 weeks ago	Acumatica Report Designer
	@richard Fair enough my friend, it's almost like our employers want it now or something right? I find it hard to troubleshoot sometimes because of the short deadlines I am given.
	RE: Shipping attention field override not reflecting on invoice form. By Richard, 2 weeks ago	Acumatica Report Designer
	@michaelhansen thank you. I ended up just using the new report and making the changes from the old report. It was easier that way.
	RE: Can a customer Cross Reference for a parent account feed automatically to child accounts? By MichaelHansen, 2 weeks ago	Everything Else
	I thought this was the default behavior to be honest. Does your customer selector only show the child accounts? If so, you need to create a master customer with locations in your system. The locations...
	Carrier VDA Shipping Label (VDA 4994) By Ronita Hay, 2 weeks ago	Acumatica Report Designer
	Does anyone know where I can find an out of the box version or something close that I can manipulate so I don't have to build this from scratch? The specs are very intricate. Thanks in advance!
	RE: Shipping attention field override not reflecting on invoice form. By MichaelHansen, 2 weeks ago	Acumatica Report Designer
	@richard Absolutely. The Schema Builder is where you should start. Your code is referencing ShippingContact, which is shown as an alias in the schema builder for SOContact. If @ryanxbyte is correct an...
	RE: Company Tree and Approval Maps By Mari Brough, 2 weeks ago	Everything Else
	Hi! I have a puzzle to solve around the same topic. I am implementing a site who will use projects and each expense is coded to a project with a project manager being responsible for approving all pro...
	Bug in processing a Purchase Requisition By jhoannaj, 2 weeks ago	Everything Else
	Has anybody ever encountered an issue where when converting a Request to a Requisition, the extended cost disappears upon clicking Process? This only happens on select Vendors. Anybody has any clue wh...
	AP Void Question By Michael Roszkowski, 2 weeks ago	Accounting in Acumatica
	So I have a customer that does not want the AP bill re-opened when a check is voided. I know, there are GL issues that would have to be addressed. Anyone ever run into this and if so, how did you ha...
	RE: 2019.1 removal of Purchase Receipt amount related fields By Richard, 2 weeks ago	Everything Else
	@wyatt-erp Thank you for the detailed response. It might be time for a process change. I will test these scenarios.
	RE: 2019.1 removal of Purchase Receipt amount related fields By Wyatt.ERP, 2 weeks ago	Everything Else
	Hi @richard I apologize in advance for how long this became! Our PO Receipts do not worry about the price. Though, this process will be even more effective if you put the new unit price into the Rece...
	RE: What is your role at your company? By nsmith, 2 weeks ago	Accounting in Acumatica
	Hello Everyone, My role is Technology Development Manager and implementing Acumatica was my first ERP implementation (and first ERP I've ever used). I am responsible for the technology our company p...
	Split Default Warehouses By matthewjames, 2 weeks ago	Everything Else
	Hi All, we have a site that would like to have a default SO warehouse and a separate default PO warehouse. I know we can have a default shipping and receiving location but we need it at warehouse leve...
	RE: 2019.1 removal of Purchase Receipt amount related fields By Richard, 3 weeks ago	Everything Else
	Posted by: @timrodman I'm doing some testing in a 2019 R2 (19.203.0042) environment and it looks like they added the Unit Cost field back to the Purchase Receipts (PO302000) screen and I can change t...
	RE: Shipping attention field override not reflecting on invoice form. By Richard, 3 weeks ago	Acumatica Report Designer
	@ryanxbyte How do I check that? is that from the Schema builder? Attachment:SO-order.png
	RE: Appearance of Notes and Attachment action icons in query results By Wyatt.ERP, 3 weeks ago	Acumatica Generic Inquiries
	@roycelithgo Ah-ha that grouping was it, what a bother!
	RE: Appearance of Notes and Attachment action icons in query results By abrunner, 3 weeks ago	Acumatica Generic Inquiries
	@roycelithgo good find! I was digging trying to figure out the same thing. You saved me a good amount of time.
	RE: Tracking Purchase Order Changes in Acumatica By Kurt Bauer, 3 weeks ago	Everything Else
	Posted by: @timrodman You don’t want too many fields checked off or it can slow down the screen Tim, Do you know if there are any metrics or articles from Acumatica that discuss potential performanc...
	RE: Odata Feed in 2020 R1 By Hazen Metro, 3 weeks ago	Acumatica OData with Microsoft Excel and Power BI
	Combing through the help docs, just saw this: "Through OData, you can view the list of fields in exposed inquiries. The field names in the list are changed according to the OData specifications, as d...
	Odata Feed in 2020 R1 By Hazen Metro, 3 weeks ago	Acumatica OData with Microsoft Excel and Power BI
	Has anyone here upgraded to at least 2020 R1 who uses the OData feeds in things like Power Query for Excel or for Power BI? I am running into a serious problem where a few things have changed: 1) The...
	RE: Tracking Purchase Order Changes in Acumatica By KarenO, 3 weeks ago	Everything Else
	Good stuff! Thank you, Tim!
	Tracking Purchase Order Changes in Acumatica By Tim Rodman, 3 weeks ago	Everything Else
	What if you want to track changes that were made to a Purchase Order in Acumatica? Specifically, let’s say that you want to track the following on a Purchase Order Line: When a line is added. When li...
	RE: GI for Restriction Groups By kalumw, 3 weeks ago	Acumatica Generic Inquiries
	@wyatt-erp Thanks for you help. Unsure if I'm going to be able to get this one working. Imported the GI that you attached and tried it with new groups. Still no luck. Its not even displaying numbers i...
	RE: GI for Restriction Groups By Wyatt.ERP, 3 weeks ago	Acumatica Generic Inquiries
	@kalumw I tested a new group on GL Accounts by Branch Access and it worked fine for me, no changes to the column's code needed. Can you try creating a second group to see if it picks anything up with...
	RE: Bug: Unable to Preview Reports on Report Designer By Gustavo Carrasquillo, 3 weeks ago	Acumatica Report Designer
	Posted by: @mcraig I Installed 2020R2 Attachment:Program Report Designer is 72 kb.PNG It seems to be working okay. In Window 10. Just tried 2020R2, didn't work either. At least the warnin...
	Payment and Application Type - Customer Refund By tlynn, 3 weeks ago	Acumatica Generic Inquiries
	Cheers, We just upgraded to 2020R1. The results grid in Payment and Applications will not allow me to open a transaction that has a type of "CUSTOMER REFUND". The error message is: Cannot open this re...
	RE: Bug: Unable to Preview Reports on Report Designer By Gustavo Carrasquillo, 3 weeks ago	Acumatica Report Designer
	@mcraig are you able to preview reports? My Report Designer is working, it opens up and connects to the server, it's the preview function the one not working.
	Can a customer Cross Reference for a parent account feed automatically to child accounts? By daniel, 3 weeks ago	Everything Else
	Hello, We sell to a number of chain store companies, where the individual stores have their own Business Account in the system. These stores are set as child accounts of the parent account, the chain ...
	RE: GI for Restriction Groups By kalumw, 3 weeks ago	Acumatica Generic Inquiries
	@wyatt-erp I think the issue may be something to do with the fact that I am using a restriction by Branch and GL Account. Not just GL Account per group. Attachment:image.png Attachment:image.png
	RE: Bug: Unable to Preview Reports on Report Designer By mcraig, 3 weeks ago	Acumatica Report Designer
	I Installed 2020R2 Attachment:Program Report Designer is 72 kb.PNG It seems to be working okay. In Window 10.
	RE: Bug: Unable to Preview Reports on Report Designer By Gustavo Carrasquillo, 3 weeks ago	Acumatica Report Designer
	@mcraig 2019R1, I am using Windows 10.
	RE: Bug: Unable to Preview Reports on Report Designer By mcraig, 3 weeks ago	Acumatica Report Designer
	What build is your Acumatica instance? Curious what operating system are you using? I have had this problem and usually just installed the same version as the instance I am working on and the probl...
	Bug: Unable to Preview Reports on Report Designer By Gustavo Carrasquillo, 3 weeks ago	Acumatica Report Designer
	Hi there fellow Acumatica users, I am going to share with you an issue I am facing since last week, and all the procedures / steps I've taken to try and solve it (without success for now). Please let ...
	RE: Timecard reports/queries By Tricia Carlson, 3 weeks ago	Everything Else
	I have created the above GI. The issue I am having is that once a timecard is created for an employee they fall off of the report. Example - Week 2020-29 entered timecards for employees AJones and DS...
	RE: Daily Released PO Receipts Logic Question By Tim Rodman, 4 weeks ago	Acumatica Report Designer
	I'm linking to the discussion over on the Acumatica Community website: