Recent Posts

Forums | Topics

Page 1 / 2 Next

	Post Title	Forum
	RE: Percentage in KPI Widget from GI By Mark O’Meara, 6 hours ago	Acumatica Dashboards
	@timrodman There appears to be no way to link the dashboard parameters to GI parameters. If there was it would be ideal. Thanks for your response though.
	RE: Linking to Descriptions of a Multi Select Attribute By Tim Rodman, 10 hours ago	Acumatica Report Designer
	You want a comma-delimited list of the descriptions rather than the values?
	RE: Percentage in KPI Widget from GI By Tim Rodman, 10 hours ago	Acumatica Dashboards
	I can't think of a way to do this off the top of my head. Maybe submit a feature request for the ability to pass a Dashboard Parameter to a Generic Inquiry Parameter since it sounds like you tried tha...
	Percentage in KPI Widget from GI By Mark O’Meara, 11 hours ago	Acumatica Dashboards
	Hello I have a dashboard with a set of parameters (Start and End date) to allow the user to select different time periods for the data displayed. Imagine a simple dataset of a TimeCard: 10/10/2021, U...
	RE: Question on RD Formatting By KimM, 2 days ago	Acumatica Report Designer
	Under Format for the field ='#,##0.00'
	RE: Non-Stock Kit Stock Availability By busyfritz, 3 days ago	Acumatica Generic Inquiries
	Did you ever get an answer to this? I needing the same thing.
	RE: Can't print SO in shipping or backorder status By Wyatt.ERP, 6 days ago	Everything Else
	It depends on your version. I think SO was moved into the workflow system in 2020R2, or 2021R1. If it's in the Workflow engine, you can control what actions are enabled/disabled through customizatio...
	RE: Stock Items not updating cost upon receipt By shawn328, 7 days ago	Everything Else
	Avaladez - Did you find a resolution to this problem? I am experiencing it with one of my clients.
	Parent Child Sales/Service Orders? By matthewjames, 1 week ago	Everything Else
	hi All, a long one i'm afraid. Not sure if this is possible and going to put it in the discussion forums as well, i can't think of a way of doing this without development. Currently the customer send...
	RE: Check-In / Check-Out functionality, does it exist or has anyone come up with a solution?? By matthewjames, 1 week ago	Everything Else
	if the item is serial traceable, you could potentially use warehouse buildings, each of the areas are warehouses within that building, you use the transfer option to move the stock around the warehous...
	RE: Import Multiple SO only importing last record By matthewjames, 1 week ago	Everything Else
	I had this issue with importing contacts, it was not saving, closing out and creating a new record each time it was just overwriting the same record. The only way i got around this was adding addition...
	RE: Velixo: An error occurred while refreshing data from ******. The data that was previously cached will be used. By Gabriel Michaud, 1 week ago	Velixo Reports for Excel and Acumatica (Financial Report Writer)
	Hi Debbie, This is an issue that we have reported to Acumatica in the past (Acumatica case #147464); you can see a similar error if you use a web browser to retrieve the inquiry using OData. I just fo...
	Gross margin commissions By Mike Collins, 1 week ago	Accounting in Acumatica
	Hi, Did anyone come across an easy way of calculating commissions based on Sales Order / Invoice gross margin (price minus cost)? All out-of-the-box commission calculation percentages (invoice/payme...
	Velixo: An error occurred while refreshing data from ******. The data that was previously cached will be used. By Debbie Katzeff, 1 week ago	Velixo Reports for Excel and Acumatica (Financial Report Writer)
	Has anyone this error before? And, have they worked out what causes it/how to fix it? Attachment : Capture.JPG I had a GI and it worked one day and started erroring with the above the next. ...
	RE: Creating a live dashboard on PowerBI or Excel Online By Tim Rodman, 1 week ago	Acumatica OData with Microsoft Excel and Power BI
	@daniel-currie Let's do it. Taking this conversation offline to email so we can arrange taking it back online via the Podcast episode 😀
	Can't print SO in shipping or backorder status By Andrew Smith, 1 week ago	Everything Else
	Anyone know why or a work around to Acuamtica locking down the ability to print/email the SO Confirmation when the SO is in a shipping or backordered status?
	RE: Creating a live dashboard on PowerBI or Excel Online By Daniel Currie, 1 week ago	Acumatica OData with Microsoft Excel and Power BI
	@timrodman I feel a bit of a newbie to the Advanced/Acumatica world and am probably covering topics well covered in previous. That said, I'd certainly be glad to get your input on how to build live (w...
	RE: Creating a live dashboard on PowerBI or Excel Online By Tim Rodman, 1 week ago	Acumatica OData with Microsoft Excel and Power BI
	@daniel-currie Live data in Power BI huh? Hmmm, I have some theories about that which I'd like to run by you. Would you be up for coming on my Acumatica Podcast to talk about it? You can see more deta...
	RE: Creating a live dashboard on PowerBI or Excel Online By Daniel Currie, 1 week ago	Acumatica OData with Microsoft Excel and Power BI
	We've used an odata fed excel production schedule for a couple of years and I want to get away from having to constantly open on the desktop and hit refresh all
	RE: Creating a live dashboard on PowerBI or Excel Online By Daniel Currie, 1 week ago	Acumatica OData with Microsoft Excel and Power BI
	@timrodman power update as in the 3rd party add-on? Happy to try that. I'm a long time powerbi user however I want to find a workaround that allows live data in reports. Unfortunately with odata as th...
	RE: Creating a live dashboard on PowerBI or Excel Online By Tim Rodman, 1 week ago	Acumatica OData with Microsoft Excel and Power BI
	@daniel-currie I haven't tried this method in years, but it wouldn't surprise me if it doesn't work anymore since Microsoft now wants you to use Power BI for refreshing. But Power Update would still...
	RE: Creating a live dashboard on PowerBI or Excel Online By Daniel Currie, 2 weeks ago	Acumatica OData with Microsoft Excel and Power BI
	@timrodman It seems like you cannot tick the "save password" now? Attachment : Capture.GIF It seems greyed out. I have several production schedules that i want to improve (currently running o...
	Linking to Descriptions of a Multi Select Attribute By Cdiangelo, 2 weeks ago	Acumatica Report Designer
	Hi All, In Acumatica, the Multi Select Attribute stores it's values in one field separated by commas. Is it possible to connect the value field to the CSAttributeDetail to display the Description of t...
	RE: Historical Goods in Transit? By byates, 2 weeks ago	Acumatica Generic Inquiries
	@Steen did you ever find a way to show historical data? I too struggle with this as we are always evaluating post month end and the data is not helpful.
	RE: EDI Solutions By Steve_Peeler, 2 weeks ago	Acumatica Generic Inquiries
	@garenmardirossian Thanks for the response. My distribution warehouse is using SPS Commerce, I may need to stick with that as they have had some success with connecting to Acumatica on that platform.
	RE: Pulling information on the report designer using iff statement. By Teckla Kapuenene, 2 weeks ago	Acumatica Report Designer
	Thank you KimM It worked.
	RE: Offset Vendor and customer balances By Carl Brooks, 2 weeks ago	Everything Else
	Hi @shawn-p-slavin I think you mind is playing tricks on you, when I worked for Exact their Globe solution had this feature, as Tim said the idea has been posted to Acumatica, I don't think they would...
	Check-In / Check-Out functionality, does it exist or has anyone come up with a solution?? By RKerby, 2 weeks ago	Everything Else
	I am looking for some assistance in finding a solution for my company to track who has a unit that they are working on or testing internally. We have QA and R&D departments and the owners would l...
	RE: Stock Item description in Reports in html By joeyjay.guinto, 2 weeks ago	Acumatica Report Designer
	Has this feature been updated with the recent versions?
	RE: Product Photos on Quotations By joeyjay.guinto, 2 weeks ago	Everything Else
	Or anyone who was able to call image file of the stock items to the report like Quote report/form pls. Thank you
	RE: Pulling information on the report designer using iff statement. By KimM, 2 weeks ago	Acumatica Report Designer
	You have to nest your IIFs. =IIf([APAdjust.LMTransactionCode]='80','Grant',IIF([APAdjust.LMTransactionCode]='60','Loan','0')) Not sure if I have that nested exactly right or not but it will get yo...
	RE: 2021 R2 - Video on Project Specific Inventory Tracking - Well done, Tim! By Tim Rodman, 2 weeks ago	Everything Else
	Regarding the idea to put the Inventory account in an Account Group, it's been a while since I looked at it, but I think it worked something like this: PO Receipt:Dr. Inventory (Increase Cost on Proje...
	RE: Location Field on Requests Screen By Tim Rodman, 2 weeks ago	Everything Else
	You can use the Activate License (SM201510) screen to see all available features. If the Activated column isn't checked next to a feature, then it's not available under your current Acumatica license ...
	RE: Add an Image of invoiced Inventory item to the Invoice By Tim Rodman, 2 weeks ago	Acumatica Report Designer
	I think you need to move your ARTran -> InventoryItem join above your InventoryItem -> NoteDoc join because you're currently trying to use InventoryItem in a join to NoteDoc before it's availabl...
	SQL Behind Customers (AR3030PL) Screen By Tim Rodman, 2 weeks ago	Acumatica Generic Inquiries
	How can you find the SQL Query or Database Source behind the Customers (AR3030PL) screen? I got this question via a private message so I'm posting my response here in case anyone else has the same que...
	RE: 2021 R2 - Video on Project Specific Inventory Tracking - Well done, Tim! By John.Shaddix, 2 weeks ago	Everything Else
	Tim and Forum - It was some issue on the Acumatica end, which they fixed and the license was assigned and check-boxed the next day. "Inventory account in an Account Group" --> This is interesting!...
	RE: Phone Mask by Country By Tim Rodman, 2 weeks ago	Everything Else
	@andrew-smith thanks for the new link. They rolled ideas into the new Acumatica Community website and I don't have access to that area since I'm no longer a VAR so I'll take your word for it 😀
	RE: 2021 R2 - Video on Project Specific Inventory Tracking - Well done, Tim! By Tim Rodman, 2 weeks ago	Everything Else
	Try the Apply Updates screen. Is the feature listed there? It might be that you aren't licensed for it. I'm not sure that this new feature is going to help you. You might be able to accomplish what yo...
	Pulling information on the report designer using iff statement. By Teckla Kapuenene, 2 weeks ago	Acumatica Report Designer
	Hi Tim Here is my scenario i want to pull information on the report designer using the iff statement as follow =IIf([APAdjust.LMTransactionCode]='80','Grant','0') and it works fine and i have a range ...
	RE: Mobile App Warehouse Management > Scan and Transfer - Add Quantity into Entry flow By mcraig, 3 weeks ago	Everything Else
	It is Paperless Picking is available in the new WMS engine only. That is how you tell you are in the new wms engine. You do not see it otherwise. This customization you would also use to change a c...
	RE: Mobile App Warehouse Management > Scan and Transfer - Add Quantity into Entry flow By mcraig, 3 weeks ago	Everything Else
	Attachment : image (80).png Attachment : image (78).png Attachment : image (79).png Attachment : image (77).png Attachment : image (76).png Sharing this information. A...
	RE: Mobile App Warehouse Management > Scan and Transfer - Add Quantity into Entry flow By mcraig, 3 weeks ago	Everything Else
	@timrodman Opened a case with Acumatica. Here is the customization, and the instructions haven't tried it yet Step-by-step guideHow to switch the legacy WMS engine back off:publish the LegacyWMSSw...
	RE: Mobile App Warehouse Management > Scan and Transfer - Add Quantity into Entry flow By Tim Rodman, 3 weeks ago	Everything Else
	@mcraig This is very interesting. I think it's a great sign that the WMS is substantial, with more investment than I thought. I hope they keep improving.
	RE: Mobile App Warehouse Management > Scan and Transfer - Add Quantity into Entry flow By mcraig, 3 weeks ago	Everything Else
	@timrodman This was announced a while back and I understood it to be WorkFlow engine. But after closer examination like you said it isn't clear what it is. What I do know is that going forward in 21R...
	Deleting a detail line using import scenarios By Alicia Calvillo, 3 weeks ago	Everything Else
	I am trying to delete a particular line in my import scenario using the below mapping. Basically i am looking for the inventory item using the @@ command and trying to delete the line using the -2 on...
	APInvoice_refNbr isn't shown on email notification from business event By Chris M, 3 weeks ago	Acumatica Generic Inquiries
	Hi everyone, I created a copy of Bills and Adjustments screen AP3010PL, and filtered it to only show rejected bills. The new GI is tied to a business event with a "Record Inserted" trigger and "Email ...
	RE: Mobile App Warehouse Management > Scan and Transfer - Add Quantity into Entry flow By Tim Rodman, 3 weeks ago	Everything Else
	@mcraig Ah, I didn't know about this. This looks like a similar concept to the new Workflow Engine, but it has a different name so it seems like something different. I'd love to learn more about this....
	RE: Mobile App Warehouse Management > Scan and Transfer - Add Quantity into Entry flow By mcraig, 3 weeks ago	Everything Else
	@timrodman Activating New Operations WMS engine Attachment : 21R1- Turn on new workflow engine.pdf Sorry I thought it was related to workflows. Basically, if you have an existing customer u...
	Import Multiple SO only importing last record By ne, 3 weeks ago	Everything Else
	Hello, Im trying to import multiple SO from excel where its include just the customer info and some UDF feilds however its only importing the last record and it dosnt not give me any erorr, please see...
	RE: Mobile App Warehouse Management > Scan and Transfer - Add Quantity into Entry flow By Tim Rodman, 3 weeks ago	Everything Else
	@mcraig Not sure what you mean by "customization for flipping". If you're looking for documentation on how to use the new Workflow Engine, here are two things for you: 1. W150 Workflows Course (click ...