Get inspired and gain all the knowledge you need
Hello, Does anyone know if it is possible to change the sort order of an existing grid in a mobile screen?In this case I’d like to change the sort order of the grid on the Pick, Pack and Ship mobile screen (SO302020). The screen is shown below. The items are ordered by line number, but I’d like to reorder them by location code. Is this possible?ThanksSteve
Is there a way to have the Email Sales Order action in the Sales Order screen show the email for editing before sending?
We would like to be able to edit the Sales Order email before it is sent. The email is automatically sent by clicking the Action button Email Sales Order. Is there a way to have that messages displayed on screen and editable before manually sending it instead? Thanks, Phil
Hi All,In BigCommerce the sales categories are mandatory to create a new item, so that is why Acumatica-BigCommerce connector requires to have at least one category during the export. I would also recommend you to manage Sales Categories in Acumatica, this will simplify the process and allow you to have one source of truth. However, if you really need to manage sales categories in BigCommerce only, I can suggest you the following customization that will disable categories synchronization for existing items. Only new items will still require at least one sales category: Step 1: Go to Item Sales Categories screen (IN204060) and create 1 category with name “Unassigned”. Name can be anything, Unassigned was used just for example. Step 2: Go to BigCommerce Stores (BC201000) and used Unassigned category as the default Stock and Non Stock Item category. This will allow you to export a new item created in Acumatica to BigCommerce without any error. Step 3: Publish the attached customization “B
Hello,I’m configuring Landed Cost in Acumatica for the first time. (version 2022 R1)The process seems clear but the end result is $0 adjustment to my item. What am I missing?My example is applying insurance costs weighted by Cost Amount across 3 items on a PO Receipt.Purchase Order (notice, 2 non-stock items on lines 1, 3 and one Stock Item is on line 2):PO Receipt: All Items Received.Landed Cost:What I expect on Valuation: Receipt line $13.30 and Adjustment line $13.30.What I see on Valuation: Receipt line $13.30 and LC adjustment line = $0.What mistake did I make? Thank you in advance for your help!!
On the Tasks screen CR302060, when I click the lookup to select a Related Entity, the popup is so small I cannot get to the lookup icon in the popup. The only way to get to the buttons on that popup is by tabbing to them.Is there a way to make this popup bigger? Is there a “hotkey” to click the lookup icon?
Hi,In this topic I asked for possibility to store credentials for ftp server connection in Acumatica custom entityHow to do it in a right way ?When I created custom entity, it required Screen Name of the already existing entityWhat should I choose ?
Hi all,I have a problem when I create a GI for showing scan details. I get data from the audit history. The problem is the data combined with NULL. How can I replace them in the GI? Even I export it to the excel, it’s not editable. I prefer to use GI, report or in the excel. I know it can be done on database level with using sql. But I don’t have access rights. Doesn’t work
Hello,for one of our customers we created a very customized docket that can be generated using a run report action in a sales order and gets used to find parts etc. in the warehouse.We now would like to attach this report to the so line files.Here:I know i can add a parameter to the Report to filter for a individual line nbr, but we can’t figure how you would go on and generate all pdfs for all line nbrs where the article has a price > 0 and attach these to the individual corresponding so line.The Report that would be generated would only contain information from line 2 for example and should be attached to line 2, proceed to line 3 where it only contains information from line 3 etc.Is there a method we can use?greetings
Hello, For ARBalance, we have a table/DAC named “ARBalance”, it already sum the result group by customer and branch. However, for APbalance, it seems we don’t have a talbe/DAC like that. We have a DAC called “VendorSumary”, but it sum the vendor balance up regardless the branches. Do we have a DAC like “ARBalance” which I can use directly. Or I have to count per every open AP doc?
Hello, I know using View.WhereAnd<> we can ammend the where statements and add a new condition like as i.e.selectDetails.WhereAnd<Where<PMCostProjectionLine.taskID, Equal<Current<CostProjectionFilter.taskID>>>>();I was wondering is there a way to remove Where Condition(s) on the fly as well? Can we reset the Where statements added to the View Query on the fly to the default state before where statements amended?
Hello, I am looking for a way to disable SO entering just for customers which are past due or over credit limits. Currently, the system can put SO on credit hold after the solines have been placed. I am looking for a way to stop the soline entering just after customer has been chosen. I am poor of coding, so is there a way to do it without coding. I am thinking of approval workflow and I will try that. If someone could give me a better/easier way to do that, I will be appreciated.
It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, ShareJoin your local Acumatica User Group today!Acumatica Users Group SE - Calling All Developers ***Check out the below HOT KB tip***How to resolve the 'IN Error: There is non zero Quantity on Hand for this item. You can only change Cost when the Qty on Hand is equal to zero' error on a user attempt to update the item standard cost on the Stock Items form Shoutout to the following members who provided tips and assisted with unanswered questions this past week. Thank you for all your help!@Leonardo Justiniano @rhooper91 @kyle90 @Omar Ghazi @dales50 @kbeatty21 @hkabiri @kokjietan @Naveen Boga @jinin @Julia Golomidova @apickard5 @laura01 @Royc
After upgrade to 2021 R2 According to above screenshot you can see that once click on close button from action then its going to update data and then disable the button of close then its show dilogbox so once click on ok button then its display error that close button disable
I am trying to exclude cancelled items. Report works well but I do not seem to be able to exclude cancelled records. I believe I have tried everything I could think of. I tried using single quotes and double quotes around the word “canceled” and I cannot get this to work. All I can think of is that Acumatica actually stores cancelled as something other than the actual word?Anyone have any thoughts on this?Thanks!
Hi, We have a requirement to parse CustomerMessage string in mapping while importing Sales Order from BigCommerce to Acumatica. For example, we have customer Message string like this :” abc test some | PO Number : 123243 ”I need to get this value “123243” in one of my Acumatica Field.Can someone suggest how to achieve this? Thanks,Shikha
After creating a sales order and entering attribute details from the configurator demand is created in MRP. Next, from the MRP display screen, we generate the Production orders. The configuration attributes are not carrying over to the production order. How can we get the configurator details to be maintained?
A user is trying to bill a service order and getting the following error:Shipping Contact must be specified to process this item.There is a contact on the service order: But interesting that the account name has not come across (and any attempt to fill it with data gets blanked out when you tab out of the field).Acumatica 2021 R2Build 21.215.0016Has anyone experienced this?
I have been asked if the customer lookup on the sales order screen can be made to search by address line 1 by default instead of customer name. This is before opening the customer lookup, just typing straight into the Customer field.There are a couple of reasons for this:Our CR team is used to asking for the customer address and looking up the customer from that. It is more efficient to ask for an address and look up 43 Acacia Avenue for example than Kris Kristofferson. First Kris could be Kris or Chris and then there are likely to be more than one Kris, Chris etc whereas the likelihood of multiple 43 Acacia Avenues is much less.Asking the customer to spell their name is time consuming and prone to errors and makes for a worse customer experience. Many of our customers have names that are not easy to spell just from hearing the name.Is this possible with a simple customization or would it be a complicated thing we’d need to approach our partner for?We have already customized the select
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.