Get inspired and gain all the knowledge you need
While Saving custom screen getting error like "Another Process has Added the TableName.Your changes will lost"
Hi,I developed one new Screen Consist of OrderNbr and RevisionNbr fields as two Primary Keys(Same as Kit Assembly/Specification revision Functionality).For first time I am able to save the data with OrderNbr -0001 and RevisionNbr-1.If I change the RevisionNbr as 2,Then I am Inserting Data of RevNbr-1 to RevNbr-2.But When I am saving OrderNbr -0001 and revisionNbr-2 error is getting ”Another Process has Added To TableName,Your changes will lost”.This error is Getting only in 20R2, But Its working in 19R2.Could you pls provide any solution to resolve this ?ThanksGiri.
We are currently using the Landed Cost feature to accurately cost our inventory. The inventory valuation report shows the updated average cost of the item, but we would prefer a report that displays the total cost of each PO receipt, with the cost per item shown. This is particularly important because our costs shift each time we receive inventory.Any tips on creating this report?
Acumatica 2020 R1, Build 20.101.0032, Screen ID: SO301000 Is there any way to overwrite the customer tax zone field based on order type? We have an external selling channel that collects sales tax on our behalf. We create these orders in Acumatica for fulfillment and inventory allocation purposes, but we don’t need sales tax to be reflected since it’s collected by the third party. Open to any suggestions that could eliminate the need for manually overwriting and changing the tax zone - as that could be an easily missed step.
Hopefully this isn’t a repeat of something but… is there a way to add multiple Activities to a Sales Order’s Detail Line?In this particular case, I’d be inserting the data via an API so I’d have access to information not normally attainable by a user, like the actual id of the line and not just the sort or row number.It would be grand to be able to see/access this information by clicking on a custom icon per Detail Line but it would also be acceptable if the records were simply accessible by the Activity feature at the top of the SO screen. Thoughts? Has anyone already done something like this? ;-)
Good morning.We are currently in the process of changing from our existing ERP to Acumatica, and have access through the web portal to create daily field reports. When we log in to the mobile applicaiton using the same log in rights, we do not appear to have access to Daily Field Reports to create new etc. Is there a permissions setting we are missing somewhere that requires special permission on the mobile application above and beyond granting access through the regular web login? Thanks,Paul
Hi,We currently have 2 sets of Purchase Orders (i.e. 4 purchase orders in total) which have the same OrderNbr. Fortunately, this isn’t causing any issues in the database, since the 2 sets of PO’s have different types, i.e. 1 Drop-Ship and 1 regular PO, and luckily this has only happened twice in more than 2 years, but I don’t think this is normal behaviour, is it? Note that we are using MySQL as database.We’re using the numbering sequences with auto incremental values, so technically these 4 POs should all have had different reference numbers, right? Is there perhaps something we can do to enforce that this doesn’t happen? It is causing a little bit of confusion in our operations department when they see 2 POs with the same reference number.
I’d like to lockdown accounts being used for integration purposes via IP Filter. I’ve done this successfully already but have run into a bit of a blip. I do a lot of my testing through postman.co and can’t seem to figure out the IP or range they’re using so I can add them to the IP Filter within the User. I then had a thought… it might be a solid idea to be able to report user’s activity including the originating IP. This would be a sort of du diligence in my mind. To be fair, we are considering 2fa via MS365 but I think there’s still merit to this. Thoughts? Does something already exist that I might not be aware of? Thanks in advance ;-)
Hello,How do I customize the behavior of Role and Type under Relation tab of Business Account? I add new role via Automation Steps below but how can I default a Type based on Role selected? For example if IT Consultant is selected in Role the default Type is Prospect.
I’m not sure if this is a glitch in Acumatica or a setup issue on our end. Bank reconciliation is showing the direct deposit batch total as one line on the bank rec (which is how we have it setup in the bank and what we want) and no individual pay stubs; but once the bank rec is released, the individual pay stubs show in bank transaction details as cleared but not reconciled. In next reconciliation the individual pay checks show up for some reason as ready to be reconciled with the cleared box checked. Users cannot reconcile the individual pay stubs because they have already reconciled the whole direct deposit batch in the previous reconciliation. It is like a flip gets switched once the direct deposit batch is reconciled and released that marks the pay stubs as cleared but not reconciled and then allows individual the pay stubs to then show up in the bank rec. I can’t figure out why the individual pay stubs are 1-not being marked reconciled when the full batch is reconciled, and 2-why
I am trying to create an approval map where if an employee belongs to a Purchase Approval Group then the PO is automatically approved by the Owner of the PO document. I thought the way this worked was fairly simple; but apparently Acumatica does NOT work this way. So I am looking for help to understand how to make this work. Below is the logic in the Rule for the Condition I have set.Step Conditions: If No Approver Found: Reject Document Execute Step: If No Approvers Found at Previous StepsRule Condition: EMPLOYEE Workgroup Equals Purchasing Approval GroupRule Actions: Approver: EMPLOYEE FROM DOCUMENT Employee: ((Document.EmployeeID.Selected)) On Approval : Complete StepAgain, what I WANT to happen is to reject all PO's that reach this step, except for the ones created by an employee in the workgroup Purchase Approval Group.But this does not appear to be the way that Acumatica works.What am I missing?Thank you in advance
Hello, I like Acumatica’s user defined fields feature, I can add fields without writing code.But these fileds are disabled when the shipment is completed, while I’d like to keep it being enabled. Is there a way to do it? I’ve found a similar question above, but as I checked, I can not find the “UDF” in automation steps. So I can not enable it. Is there any other way to do it?
Hello, We are not using the scanner and mobile warehouse mangement service to fulfill shipment.The users who enter the shipment on screen are not the ones who pick the goods. we have a need to record the pickers of the shipment. I say pickers, because it could be 1 picker or 2 pickers at most. So I am intending to use 2 single selectors with non required setting. The pickers might not have the user account in system. But I am thinking I can put them into system as employees and under a “picker group” of “company tree”. Can anyone give me some suggestions on the below needs:1, How to add the “employee selector” on shipment screen,2, The data source of the selector better be restricted to “pickers” only.3, The information can be persisted to DB, and can do further reporting later.4, The selector better be edited at any shipment status (even completed or invoiced), this is because someone might put wrong picker, so we have the need to correct. Thank you in advan
I have created a screen to change items in a sales order using a processing screenThe top of the form has two fields, the “From” item and the “To” item.When you kick off the PROCESS ALL, I need to have the values in those fields available to the process delegate. Since the UpdateOrders delegate is static, I don’t know how to get the from and to item numbers. I’ve tried creating public properties and setting the values of the properties on the rowselected event. But when UpdateOrders fires, and ultimately fires the UpdateOrder method, the properties are null. In the code below, I hard coded the inventoryID’s just to verify the code actually changes the sales order and it works great. I just don’t know how to access the values in the top of the screen in the code. ItemNumberToChangeFilter filterValues = Filter.Select(); returns nulls. Other than that, I’m almost done! :-) public PXFilter<ItemNumberToChangeFilter> Filter; public PXFilteredProcessingJoin<SOOrd
I went through the process of creating the customization project and then added AP.APAdjust. I clicked on Selector Columns and then added APAdjust__vendorID and APPayment__extRefNbr.I saved the changes and published the customization but when viewing the selector within the detail grid of AP503000 I did not see the columns that I added.Just in case, I also replaced the attributes of the APAdjust VendorID column from[Vendor(Visibility = PXUIVisibility.Visible, Visible = false)][PXDBDefault(typeof(APPayment.vendorID))]to[Vendor(Visibility = PXUIVisibility.Visible, Visible = true)][PXDBDefault(typeof(APPayment.vendorID))]but that didn’t have the desired effect.What did I miss?
Hello Everyone,We have specific requirement to increase the TaxZoneID length from size 10 to 30 from TaxZone table.Since, this field is having dependency with many table fields, unable to modify the length and giving SQL error is ALTER TABLE ALTER COLUMN taxzoneid failed because one or more objects access this column.. I know that we can drop the Foreign Key relationships and make it work but I don’t think this proper way of doing in Acumatica database. Hence posting this question here and seeking for help.Can you please help me with this?
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.