Recent Posts
Forums | Topics |

Page 1 / 3 Next

	Post Title	Forum
	Acumatica 2021 R1 Virtual Launch on February 18, 2021 By Tim Rodman, 19 mins ago	Poll Questions
	The Acumatica 2021 R1 Virtual Launch event took place on February 18, 2021. Click here to watch the recording of the event The event was recorded at LeMay – America’s Car Museum, in Seattle. During ...
	Removing Warehouse Detail From Stock Item By danielbyrum, 31 mins ago	Everything Else
	Hello all, I am trying to remove one of the warehouses from a stock item. The form toolbar has the delete button greyed out. Does anyone know how to accomplish this? i have attached a screenshot of th...
	RE: Accrual Account Based on PO Type? By fchambers, 2 hours ago	Accounting in Acumatica
	Acumatica 2020 R1Build 20.101.0032
	RE: Create shipment for sales order in import scenario By MichaelHansen, 6 hours ago	Everything Else
	I can import shipments, but how do I access the date field to set the date on the shipment? My system always pulls TODAY for the date and these are slated for not today, so I need to set the date or I...
	RE: Adding Formulas to Results Columns By jmmarasco, 3 days ago	Acumatica Generic Inquiries
	Thank you Tim!!
	RE: Add Approver to PO Form By Tim Rodman, 4 days ago	Acumatica Report Designer
	Try joining to EPApproval on POOrder.NoteID=EPApproval.RefNoteID, but be careful because there could be multiple approval records in which case the Purchase Order will get listed multiple times in you...
	RE: How to have a Register Report automatically print when Release button is clicked? By Tim Rodman, 4 days ago	Everything Else
	Hi @mike-b, It might be possible using the new Workflow Engine, but I'm not sure. I recommend posting this in the new official Acumatica Community Forums: For the foreseeable future, the Forums he...
	RE: Creating "Trade backs" on a Sales Order By Tim Rodman, 4 days ago	Everything Else
	Hi @mattd, I recommend posting this in the new official Acumatica Community Forums: For the foreseeable future, the Forums here will focus on the Reporting Tools in Acumatica (Dashboards, Generic ...
	RE: Adding Formulas to Results Columns By Tim Rodman, 4 days ago	Acumatica Generic Inquiries
	Welcome @jmmarasco. Sorry for the late reply on this. Unfortunately you can't reference a calculated column in another calculated column yet, but you could copy/paste your formulas into a new calculat...
	RE: Generic Inquiry with a Parameter for an Export Scenario By Tim Rodman, 4 days ago	Acumatica Generic Inquiries
	Wish I could help, but I haven't done much with Export Scenarios. Are you exporting the data to Excel? If so, you could use OData in Excel, including a date parameter, then use Power Update (click h...
	RE: Company Tree and Approval Maps By Tim Rodman, 4 days ago	Everything Else
	Hi @mari-brough, I recommend posting this in the new official Acumatica Community Forums: For the foreseeable future, the Forums here will focus on the Reporting Tools in Acumatica (Dashboards, Ge...
	RE: How to use @myworktree functionality in report designer? By Tim Rodman, 4 days ago	Acumatica Report Designer
	I haven't tried it personally. Maybe it only works in Generic Inquiries.
	RE: Acumatica Device Hub - should it be running on a server? By georgydas, 4 days ago	Everything Else
	@rjean99 even better! Thank you!
	RE: Acumatica Device Hub - should it be running on a server? By rjean99, 4 days ago	Everything Else
	@georgydas no problem. I just happen to be testing out devicehub myself and saw your question. I also discovered you can just download the AcumaticaTools.msi (which is much smaller) to get device hub...
	RE: Adding Contact and Address info to AP Bills and Adjustments GI By megan.friesen, 4 days ago	Acumatica Generic Inquiries
	@robcushen I was doing it in 2020R2. In both 2020R1 and 2020R2 there were some pretty major changes to the Customer/Vendors/Contacts and Leads screens compared to prior versions which makes some thin...
	RE: Adding Contact and Address info to AP Bills and Adjustments GI By Rob Cushen, 4 days ago	Acumatica Generic Inquiries
	Thanks so much for the help Megan!! I believe I am working with an older version of Acumatica. It did appear that I had to add the "bAccountId" in each join as well, but adding those 2 tables worked.
	RE: Acumatica Device Hub - should it be running on a server? By georgydas, 4 days ago	Everything Else
	@rjean99 This was so very helpful, thank you! Appreciate it!
	RE: Adding Contact and Address info to AP Bills and Adjustments GI By megan.friesen, 4 days ago	Acumatica Generic Inquiries
	Add 2 tables to your GI: PX.Objects.CR.Address & PX.Objects.CR.Contact Link these 2 tables to your Vendor table (screen shots below) Attachment:image.png Attachment:image.png This will give y...
	Import Scenario to Recalculate Prices on a Sales Order. By Michael Roszkowski, 4 days ago	Everything Else
	Hi, I am trying to write an import scenario to recalculate prices on sales orders. The Actions->Recalculate Prices function brings up a dialog box and I am not having any success in getting this t...
	RE: Acumatica Device Hub - should it be running on a server? By rjean99, 4 days ago	Everything Else
	@georgydas builds.acumatica.com I believe you can just download the ERP installer for the version you are running and uncheck everything except device hub
	RE: AR Aged Past Due By megan.friesen, 4 days ago	Acumatica Report Designer
	Attachment:ar631000.rpx Attachment:ar631500.rpx Attachment:ar631100.rpx Attachment:ar631600.rpx These are the latest versions from 2020R2 AR631000 - AR Aging AR631100 - AR Aging MC AR631500 - A...
	RE: AR Aged Past Due By John Rubidge, 5 days ago	Acumatica Report Designer
	Hi Megan Thanks for responding and getting back to me with the info and release notes. Much appreciated. We do have 2020 R1 currently. But there are report versions so someone at service providers mus...
	Adding Contact and Address info to AP Bills and Adjustments GI By Rob Cushen, 5 days ago	Acumatica Generic Inquiries
	Hi, I found adding the Contact and Address relatively easy to on the AR side Invoices and Memos GI, but the same logic does not appear to work on the AP side (unless I am missing something). AR had Co...
	Back order - automation By Fosse, 6 days ago	Everything Else
	Hi, Does anyone have any tip how we can automation the back order management. For example. We create a SO with 2 products. One of the products is'nt on stock so we need to create a purchase for this...
	RE: How to find out what the API license restrictions are? By megan.friesen, 6 days ago	Acumatica Generic Inquiries
	I am not as familiar with the MYOB set-up, but if you have the administrator role, you should be able to locate the screen in the "Access Rights by Screen" form and check what the access is and probab...
	RE: Invoice Reminder Emails By Patricia Batisti, 6 days ago	Everything Else
	@john-toney Hi John, hope you are well. Have you found a way to attach the actual invoice to the notification generated by the business event? Thanks
	RE: How to find out what the API license restrictions are? By dteirney, 6 days ago	Acumatica Generic Inquiries
	Thanks for the advice. My User account has the Administrator Role. Can't see any Acumatica Support role listed. Our deployment is MYOB Advanced - perhaps that has some different configuration to out-o...
	RE: DAC Field UI warning indicator behaving like error By tlanzer, 6 days ago	Everything Else
	I was able to get it to behave like I want by using PXUIFieldAttribute.SetWarning instead of raising an error. Maybe PXErrorLevel.Warning doesn't actually behave like a warning, not sure.
	DAC Field UI warning indicator behaving like error By tlanzer, 6 days ago	Everything Else
	I am raising a warning message on a field in its FieldUpdating event handler, but it is displaying and behaving like an error instead of a warning. In other words, red instead of yellow icon, and turn...
	Accrual Account Based on PO Type? By fchambers, 6 days ago	Accounting in Acumatica
	Attachment:2162-image.png Is there a way to set the accrual account based on PO type? i.e. We want the accrual account to be 2210 on a normal PO, but we want the accrual account to be 1250 on a drop ...
	RE: How to find out what the API license restrictions are? By megan.friesen, 6 days ago	Acumatica Generic Inquiries
	Out of the box only users with the Acumatica Support and Administrator roles can access the "License Monitoring Console" screen so check with your system administrator about your access if you need to...
	RE: AR Aged Past Due By megan.friesen, 6 days ago	Acumatica Report Designer
	Hi John, What version of Acumatica are you on? In Acumatica 2020R1 the AR aging reports were updated to be sensitive to the date put into the aging date field, but if you had previously customized th...
	RE: Kit on Pick List By Fosse, 6 days ago	Acumatica Report Designer
	Solved the problem.
	RE: Kit - Stock Items - Sales Order Quote By Fosse, 7 days ago	Acumatica Report Designer
	@garenmardirossian Thanks!
	RE: Kit - Stock Items - Sales Order Quote By Fosse, 7 days ago	Acumatica Report Designer
	@kurtybauer Thanks for the tips!
	RE: Kit - Stock Items - Sales Order Quote By Fosse, 7 days ago	Acumatica Report Designer
	@mcraig Thanks for the tips!
	Kit on Pick List By Fosse, 7 days ago	Acumatica Report Designer
	Hi, I have a new problem regarding Kits. On the Pick List on a Shipment my Kit appears several times on the form. Making it messy and difficult to se where I should pick my components. I would like to...
	RE: Attaching Notes in a Generic Inquiry By Royce Lithgo, 7 days ago	Acumatica Generic Inquiries
	Good news. Wonder if this works when you use aggregates and groups.
	RE: OData connection works, but data is empty! Returns Column Headers only. By Royce Lithgo, 7 days ago	Acumatica OData with Microsoft Excel and Power BI
	No worries at all. Glad to have helped out.
	RE: OData connection works, but data is empty! Returns Column Headers only. By Sweed, 7 days ago	Acumatica OData with Microsoft Excel and Power BI
	Hey Royce, you are a godsend. Thank you! As soon as I removed these the floodgates were opened. All systems go!
	RE: Acumatica Snapshot Export Format By Mike A, 7 days ago	Everything Else
	@sslavin Great point!
	Blank Space - Detail Lines By wpratley, 1 week ago	Acumatica Report Designer
	Hi, I have 4 detail lines in the AP Remittance info. I need to display the data in the Vendor setup for remittance settings associated with FEDWIRE payment method. No matter what I do, I get inconsist...
	RE: Kit - Stock Items - Sales Order Quote By mcraig, 1 week ago	Acumatica Report Designer
	Another option might be to write a subreport. Which would use the schema tables from the Kits and then blindly dump the contents of the kit. You can then what you want to include. A variable could be...
	RE: Kit - Stock Items - Sales Order Quote By Kurt Bauer, 1 week ago	Acumatica Report Designer
	Jonas, We have a client using the Kit Processing solution from BizTech. It provides a lot of options and allows you to explode the kit on the sales order. If you are just looking to show the items on...
	RE: Kit - Stock Items - Sales Order Quote By wpratley, 1 week ago	Acumatica Report Designer
	The kit specs are found in table InKitSpecStkDet table. I was able to list components on the SO using a subreport, attached. Good luck! Attachment:so641016.rpx
	RE: Kit - Stock Items - Sales Order Quote By Gary Mardirossian, 1 week ago	Acumatica Report Designer
	Hi Jonas, Please give me a call I have a Kit Processing solution that might help you in what you are looking to do. gary@biz-techservices.com / 818-484-5004
	Kit - Stock Items - Sales Order Quote By Fosse, 1 week ago	Acumatica Report Designer
	Hi, We have customers using Stock Items that are Kits. On the Sales Order Quote we would like to see what in depth components the Kit have. The data exist in the Kit Specifikations window IN209500 b...
	Power BI Timesheets By Nwood, 1 week ago	Everything Else
	I recently came across the article I know this one dates back several year but hoping it might help with our current transition to consultant billing based on Acumatic timesheets/activities. The link...
	RE: OData connection works, but data is empty! Returns Column Headers only. By Royce Lithgo, 1 week ago	Acumatica OData with Microsoft Excel and Power BI
	You can't use Parameters with OData: You need to design the Query to not rely on Parameters. Your current conditions will return no data if the parameters are Null, which they will be in OData (you h...
	RE: Acumatica Report Designer Download By azhar, 1 week ago	Acumatica Report Designer
	Hi... there's a quicker way to get the Report Designer ONLY. This was how I did recently (using AcumaticaERPInstall version 20.208.0031). 1. Download the full AcumaticaERPInstall.msi from partner po...