Discussion Forums

I have made a project attribute: DOCLINKS which I use to store a string (url) for documents to attach to Project Quotes.I want to update this field via the api.As far as I know, Acumatica does not have a DEFAULT end point for Project Quotes so I cannot extend the default end point.I tried to create a new web service endpoint to pull at least the quote number from the Quote Summary but am struggling to add the project attribute field to the response. I can pull the data via querying a custom GI but I need to also update and edit that field which you cannot do via the api.I tried following this But to no avail.

We are looking for a way to track how many phone calls our customer service team receives each day. We aren’t necessarily always looking to track the details of the phone call or who the phone call came from, but just how many phone calls received during the day.Right now our company is using a google sheet and phone operators are keeping track via sticky notes on their desk.

I following the instructions listed here:https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/ However, my Generic Inquiry is really large so I’d like to apply a filter.  However, since I created a Result set using the instructions above, I get an error when I want to filter on a Generic Inquiry value:    "exceptionMessage": "The parent value for a property access of a property 'InventoryID' is not a single value. Property access can only be applied to a single value.", I’m able to filter in the UI on the Generic Inquiry page when I click VIEW INQUIRY so it seems like I shouldn’t have followed the instructions above when creating my Web Service Endpoint. Question: are there a separate set of instructions to follow when using $filter with Generic Inquiry and REST? Here’s the URL I’m using:https://sandbox.acumatica.com/entity/INStockItem/22.200.001/POReceiptPackages?$expand=Result&$filter=Result/InventoryID eq '331-0470'

For the PO Error: The line cannot be deleted because one or multiple prepayment requests have been generated for this order. To proceed, delete prepayment requests first. I have tested out a few things of voiding the prepayment and removing the item on the prepayment, but is it possible to delete a PO Line with a Voided Prepayment attached? I cannot seem to have any luck. Thanks,RJ 

Hi everybody,We have added the new DAC TaxSpecialMentions to manage the notions of legal notices on ARInvoices.The link between the ARInvoice and the records of ths new DAC is done with TaxTaxTran where the new custom field SpectalMentionsID has been added.Below the data model.Objectives to be achievedWe have created a new report to display all the texts of the legal mentions for a given ARInvoice.Below, the query we have created.Issue:When the reports runs, no data are found whereas they should be present. I catched the query and I realized that one of the join criteria is not properly built : the one dealing with [SpecialMentionsID] that is used to join ARTaxTran and TaxSpecialMentions.We should have ( [ARTaxTran_TaxTran].[SpecialMentionsID] = [TaxSpecialMentions].[SpecialMentionsID])but we have( NULL = [TaxSpecialMentions].[SpecialMentionsID])Below the query with more details :SELECT [ARInvoice_ARRegister].[DocType] AS [DocType], ..., [TaxSpecialMentions].[SpecialMentionsID] AS [Spe

Are there any plans to have a virtual developer conference this year?

I'm following the Modern UI course for Acumatica and working with a SmartFix_T290 instance (version 25R1). I have followed the instructions provided in the course PDF, including: Creating the RS201000.ts and RS201000.html files in the following path:..\SmartFix_T290\FrontendSources\screen\src\screens\RS\RS201000 code is copied from Acumatica help git repository Running the npm run build-dev command inside the ..\FrontendSources\screen folder (this completed successfully without any errors) After publishing the customization and updating the site map, I’m able to switch to the Modern UI version of the RS201000 screen without any issues. However, when the screen loads, it only displays a blank white space — no UI elements, grids, or fields appear, as shown below.There are no visible errors or warnings in the UI or browser console.Could you please advise what might be missing or misconfigured?Thank you!

Can we add a wiki page with an image where we can define % of screen it have to occupy ??  [image:Graphic\Links.png|700px|Links|noclick]With such we are defining pixels and this size might not be scalable on all screens. On some small screens it looks very big.

Looking for documentation to set up kits with options.Can kits be nested together?  We would like to be able to print quotes with the Kit number with the Options listed. Also has anyone been able to use the rules as well. Thanks,  

Hello all,Can anyone guide me to setup a bi weekly statement cycle. Not of twice a month but it should be a true bi weekly.Thanks.

Hi:I’m trying to import a NACHA (ACH) file from Acumatica to my bank’s platform. However, I’m having an issue with the Company Identification field. According to the NACHA developer guide this field is 10 characters long and should be alphanumeric. ACH File Details | ACH Guide for DevelopersIt seems this field is populated by the Cash Account screen (CA202000) on the remittance settings under ACH. The field seems to be constructed from 1 character from “Company ID Type” and the rest from “Company ID”. However, the “Company ID Type” field seems restricted to numeric only and in our case we need a letter.Any advice on how can we change the Company ID Type field to accept an Alphanumeric character so I can export the NACHA files correctly from Acuamatica?Thank you!

When I have an open purchase order that has an existing prepayment applied, I am not able to cancel any line on the purchase order. Even if I void the prepayment check, which also voids the prepayment request, I am not able to modify the PO. I receive the following error. The only solution I have found is to void the prepayment and cancel the entire PO for re-entry, which is not ideal. Any other suggestions? PO Error: The line cannot be deleted because one or multiple prepayment requests have been generated for this order. To proceed, delete prepayment requests first.

When an account has a document discount and we add a nonstock processing fee line to the sales order, the document discount percent changes.   It is taking what the document discount amount was prior to nonstock item being added and changing the document discount percentage.  Is there a fix for this?

Selling to customer that requires multiple tax IDs on the Sales Order. When I add an additional Tax ID, it doubles the VAT taxable amount? 

In Acumatica, creating material returns against production orders requires users to manually select each material line, making the process time-consuming and prone to errors. Unlike the Material Issue screen, there is currently no functionality to automatically prefill relevant data when reversing issued materials. Is there any plan to introduce auto-prefill capabilities for material returns in future Acumatica releases to streamline this workflow and improve efficiency? 

We were wondering if anyone has ever had any experience with automating sales order processing in some fashion. We have a certain order type - EQ - which is a Quote document - that our sales team sends in to the Acumatica system. Whenever this order type enters the system, we would Acumatica to automatically “REMOVE HOLD” and then subsequently “EMAIL QUOTE”. Any ideas?   

Hi all, we are interested in creating a data provider that would point to an Azure SQL database living in Microsoft Fabric. The challenge here is that Fabric supports Entra ID users, service principals, and groups only. SQL or Windows authentication aren’t supported.It doesn't appear that the built in SQL data provider driver, as of 25R1, supports Entra ID authentication.  We've come up with a couple of ideas but would be very interested to hear if anyone has been able to establish this kind of integration successfully.Our thoughts:Find a middleware driver that would support Entra ID authentication through Acumatica.  Potentially CDATA? Access fabric data through a linked server query to a SQL Managed Instance in Azure Replicate the fabric data to a regular Azure SQL DatabaseThoughts welcome.  Thank you!

Hi all, I just wonder if there is a way of reversing a pick confirmation without manually scan and transfer the lines individually. Someone made an error and accidentally confirmed the pick for a shipment that hasn’t been physically picked, and the whole stock on the order has been transferred to the van lane. We managed to rectify it with investigating where the stock was auto transferred from at the pick confirmation and we managed to manually transfer each lines back to their original locations, but it would be good to have a reverse option.

Hi,I would like to know a method to reserve and request raw material inventory from the Raw Material Stores under the following two scenarios: When the Manufacturing module is not enabled When the Manufacturing module is enabled, and production orders are raised against specific Sales Orders In both cases, users are required to request raw materials from the stores for specific lot or batch numbers allocated to a particular Sales Order. Once the inventory is allocated, it must be reserved and restricted from being issued to any other order.Could you please advise whether there is a standard process or recommended method in Acumatica to handle this scenarioThank you in advance 

I am trying to add the Barcode Scan function to the Mobile App, specifically on the Inventory ID line, in the Details tab.I was able to find two posts related to this, one with an “answer” but I wasn’t able to get it to work in my customization.Related Posts:Use of barcode scanner on the mobile app for Sales Order creation which reference Barcode button in mobile appCode I believe should work:update screen SO301000 { update container "Details" { Update group "LineInventoryIdGroup"{ update field "InventoryID"{ special = BarCodeScan } } }} 

If i enter a Sales order for lets say QTY-10 of any item, mark it for PO, create a (non-dropship) purchase order, lower the QTY on the purchase order to 5. (lets say the vendor does not have the full amount)..i would think that i would see another line in the “Create Purchase Orders” screen for the remaining 5.. but nothing shows up… In order to make it show up i need to go back to the SO, Lower the QTY to 5, raise back to 10, and then i get the other 5 to show up in the CPO’s screen..Anyone know why this is? Seems like a bug.

Hey all —Before we had a solid handle on how landed costs worked in Acumatica, we used to just enter those charges (like freight, duty, etc.) directly onto AP bills as non-stock items. The issue is, that didn’t update the actual cost of the stock items.Now that we do understand how landed costs work, we’d love to go back and properly incorporate them into the cost of those items.My first thought was to create debit adjustments for those AP bills (where the fees were added as line items), then create actual landed cost docs tied to the original purchase receipts and pay them with the debit adjustments. But after testing, it doesn’t look like that method actually updates the item cost the way we need.Has anyone found a good workaround for applying landed costs to POs/bills that are already completed and paid? Would love to hear what’s worked for you. Thanks!

Hello,I'm looking for some assistance/advice. I'm fairly new to Acumatica development but I've been doing development work against the Sage accounting system for a number of years. I've followed the Acumatica development training courses and have delivered a few development solutions to our customers so far. Though they were fairly simple solutions they are seen as a big step forward for our company and we want to build on the experience and work on larger projects. However, I'm finding that development with Acumatica is proving to be very, very time consuming because when I recompile a dll in visual studio there is a long delay before the pages in Acumatica refresh. The compiling action is visual studio is very fast but the Acumatica refresh is extremely slow. I'm often waiting over 3 minutes for the pages to refresh. If I need to update an aspx page then the solution becomes worse, by the time I've applied the changes via the customization page and waited for the Acumatica pages to r

Good morning all.  I am having a moment and can't for the life of me work out what I am doing.I have payments that were taken out of our bank account last week and of course now appear in my bank feed.  The invoices are now in MYOB so I need to allocate the payment to the invoice.Do I go through the whole process to "pay the invoice" including export etc.  Or is there another way.  I really need help with this ASAP as of course it is EOM and I need to have my bank feed correct.  Just really can't remember the process it has been that long…...thanks so much in advance. E

I am trying to get Anomaly detection to work in a 25R1 sandbox and it is turned on in the enable/disables features screen as seen in the screenshot but on the generic inquiry screen there is no checkbox that says “detect anomalies” where it should be based on a video I watched from Acumatica. What am I missing here?