Discussion Forums

I have a GI that connects InventoryItem to NoteDoc and then to UploadFile.  I would like to display the attached image in the generic inquiry so that it can be used on the mobile app.  Is there any way to do this?

Hi,In the Sales Orders screen, a client is wanting to search for a customer in the Customer box using the Ext Ref Nbr as well as the Customer ID, as they have migrated some customer data across from another system which could be looked up via both an ID and a reference number.I have added the Ext Ref Nbr column to the selector, as shown below, but I am unsure how to include this column in the filtering function.The code below is how I attempted to do it, but this just made the Customer selector return no results at all when you first click on the magnifying glass icon of the selector.Do you have any recommendations for how I could implement this?Let me know if I can provide any other information.Kind regards,Andrew [PXDefault][Customer( typeof(Search<BAccountR.bAccountID Where2< Where<BAccountR.acctCD, Like<Current<SOOrder.customerID>>, // Search by Customer ID Or<BAccountR.acctName, Like<Current<SOOrder.customerID>>,

How can i convert a report into GI. “Inventory Analysis”1. That Report Contains Subreport2. These Fields were displayed in the reportSubreport Contains parameter - InventoryItem.InventoryCD Please help, Thanks in Advance

An employee has a checking and savings account that is split with a regular paycheck. He received a bonus and wants the full amount to go into his checking account only. Is this possible without changing the payroll settings?

Some of my technicians have complained of some differing amounts from the Service Order to the Appointment, and it has boiled down to taxes. I’ve seen it pop up a few times, and its always a Special Tax issue.The  address was validated at the Customer level, and not overridden on either the Service Order or Appointment.Has anyone experienced this issue? Appointment, with the extra line of taxesService Order, lacking the extra tax Acumatica 2022R2 Build 23.212.0024

Hi Everyone,Can you please help me to resolve the below issue?  

Hello Team,I Got Some Error during customization on Acumatica 2024 R1, the codes works fine on Acumatica 2021 R2, but when upgrading to Acumatica 2024 R1 it throw error A data corruption state has been detected here simple customization code. protected virtual void _(Events.FieldUpdated<RQRequisition,RQRequisition.vendorID> e){ if (e.NewValue != null) { int? vendorID = Convert.ToInt16(e.NewValue); foreach (var line in Base.Lines.Cache.Cached.RowCast<RQRequisitionLine>()) { var vendorPrice = GetVendorPrice(vendorID, line.InventoryID, line.SiteID, line.PromisedDate); decimal lastPrice = vendorPrice == null ? 0m : vendorPrice.SalesPrice ?? 0m; Base.Lines.Cache.SetValueExt<RQRequisitionLine.curyEstUnitCost>(line, lastPrice); Base.Lines.Cache.RaiseExceptionHandling<RQRequisitionLine.curyEstUnitCost>(line, null, null); } }} 

Hi,I would like to ask for some insight on this API request error, if there is any available work around or fix. Create Bill causes error Subaccount cannot be empty. Inserting  'AP Transactions' record raised at least one error. Please review the errors. Customization: noneversion 23R1endpoint: Default/18.200.001{    "message": "An error has occurred.",    "exceptionMessage": "Bill.Details[0].Account: Account is inactive.\nBill.Details[0].Subaccount: 'Subaccount' cannot be empty.\nInserting  'AP Transactions' record raised at least one error. Please review the errors.",    "exceptionType": "PX.Api.ContractBased.OutcomeEntityHasErrorsException",    "stackTrace": "   at PX.Api.ContractBased.EntityService.GetOperationResult(EntityImpl entity, EntityExportContextBuilder entityExportContextBuilder, PXSYTable exportedKeys, PXOuterException contextError, Boolean throwOnError, Boolean addCancelCommand) in C:\\build\\code_repo\\NetTools\\PX.Api.ContractBased\\EntityService.cs:line 724\r\n   at

Hello Acumatica Community,  Hope all is well. Has anyone had any luck receiving in non-stock items that require receipt through WMS? I’m using Receive and Put Away. I get that non-stock items are not tracked in inventory and there is no inventory controls but the receiving part should still be allowed to tell the AP department to bill for the item being received in.  Thank you

Hi guys I am trying to make a report based on today’date, payment method and status open. This is going to be on payment screen. Any one please guide me with any reference. When we select these fields in parameters It should return all the payments with customers in report. It will have customer relation with payemtns . Any one please guide me on how to start 

Hi All, I want to add a related Item to SOLine in a sales order programmatically. I tried to find a relationship between SOLine DAC and RelatedItem DAC. But I was unable to find a clue to proceed with this requirement. Any help would be much appreciated. Thanks

Hey everyone, I have looked at all of the online help regarding planning buckets and I still don’t have a good grasp as to what a planning bucket actually is and how I should set them up. Can anyone help further explain what they are for? Thanks!

On different forms related to UPS carrier integration users might see error "Access keys are no longer available. Please reconnect account number using OAuth". To resolve it follow https://help.shipengine.com/hc/en-us/articles/27535412505115-How-to-Reauthorize-Your-UPS-Account

Hello!Documents need to be approved is updated in the dashboard and inquiry for the dashboard is taken from the Approvals form. We want to show the project ID of the document to the dashboard but unfortunately Project ID is not in the Approvals form. Hence we create another inquiry joining Approvals form and the document but it seems not accurate. Is there any possibility to join the Approvals (EP503010) form and the Bills and Adjustments (AP301000), if so please assist me. Regards Amanda 

Is there a report that totals prepayments by purchase order?  I am only looking for amounts that have actually been paid, not in process.

Hi Community!I have created a pivot table that counts Orders and Lines per day. How can I then add a column that averages the two totals in the pivot table or is this something that can only be done using Velixo?  

Hello,On Acumatica Cloud 2024 R1I’m using the end point Default/23.200.001/Payment (also tried with Default/22.200.001/Payment) After creating a SaleOrder, I’m trying to add a Payment for it using the web service, but I’m stuck in error returning from the API with this message:{ "message": "The request is invalid.", "modelState": { "": [ "An exception occurred during input parsing" ] }}I’m not sure what is invalid, I’m using the same JSON format I used to create the sales order, here is my payment POST request: { "Type": { "value": "Payment" }, "CustomerID": { "value": "1047204" }, "ApplicationDate": { "value": "2024-10-18T11:00:51" }, "PaymentAmount": { "value": "439.22" }, "PaymentMethod": { "value": "ONLINE" }, "PaymentRef": { "value": "86561" }, "CashAccount": { "value": "11140_____" }, "AppliedToDocuments": [ { "Type": { "value": "SO" }, "ReferenceNbr": { "value": "86561" },

Hello Acumatica Community,We have developed a customization that requires storing an API Key, but we need to ensure that generic users cannot access it. Our initial approach was to save it as a password field in the database. However, we noticed that this method still allows the key to be read as base64 from snapshot files, which can then be converted back to the actual key.Our customers are mostly using SaaS instances from Haufe, so we're unable to modify snapshot configuration files directly. Therefore, we're looking for solutions to either:Hide or secure the key in a way that prevents it from being exposed via snapshots, or Exclude the custom table that stores the key from being included in snapshots through a customization project.If these options aren't feasible, is there a way to manage the key externally or implement a similar secure solution like dynamic encription?Any suggestions or insights would be greatly appreciated. Thank you!

Is there a way to configure the system or the web browser which allows you to preview/ view attachments, without downloading them?  If I just want to reference them, I don’t necessarily need to download them.

hi, All. We have one screen name bank deposits. I am trying to put data in ths screen using API. I have extended the endpoint and add this screen in webservices. But when I am calling put method it returns an error.Can any one please guide me on this 

We have a customer in the medical manufacturing field. They need to transfer approximately 12 years of transactional data to Acumatica from a legacy system. We know this is not the norm - but being in the medical industry they need to be able to track any medical equipment manufactured by lot number sold to their customers. Backward and forward tracking.What would be the best approach to import this data? Anyone with similar requirements?

Recently our Acumatica site was down for a full day of work. We are service based and have techs out in the field all day. With the site down we were unable to access appointments and eventually we had to send all techs home.This triggered us to realize we need a Disaster Recovery Plan. I wanted to see what others have done to make sure you can still function if your Acumatica site goes down?

Hi,  I have a requirement to create a journal voucher by import scenario and via a business event. The voucher needs to be created to the end of previous month always. Example : If the business event triggers in October the voucher needs to be created to the date 31st of SeptemberCan you please help me with setting this up in the import scenario? Thank you,Dulanjana

Hey All…. I’ve used MYOB V18 desktop version for 20 years, well last week I started a new job and they are using MYOB Acumatica! HELP! 🤣So…How do I do a monthly revenue report? So i can see all the months!Also a monthly profit and loss report, showing each month.Thank you 😖🤣 

Meet Dipak Nilkanth our Acumatica Community Featured Member for October 2024. It’s great to have you as part of the Acumatica Community @Dipak Nilkanth! I’m Dipak Nilkanth, an Acumatica Developer at Tayana Solutions with over 3+ years of experience in the Acumatica ecosystem. I am passionate about exploring the platform, enhancing my skills, and sharing knowledge with the community. Being active on the Acumatica community site has given me the opportunity to learn from others while contributing by helping fellow members solve problems. The Acumatica community has been a great space for me to not only share knowledge but also to learn from other professionals.When I’m not deep into Acumatica, you can find me enjoying a game of cricket, spending quality time with my friends. One of my greatest joys is hanging out with my nieces and nephews—my brother’s daughter, Veera, and my sister’s son, Kiyansh  who always keep me on my toes!. Watching them grow and being part of their lives brings a