Discussion Forums

Hello,During the purchase receipt process we sometimes update the prices because during the time of PO and Receiving prices can fluctuate a little.  Is it possible to maintain the new updated prices for future orders after updating the prices. Thanks!

 HI all, I create the connected application for Gmail Integration in my tenant, and maintain the URI followed the steps in guide book.https://acumatica-builds.s3.amazonaws.com/builds/zip/software/addon/gmail/Acumatica-Gmail-User-Guide.pdfBut how come it shows 404 error when I try to authorize access in Gmail add-on?Is there any setting steps I missed or the URI is incorrect?   (In Acumatica 22R2 version) Thanks,David Lee

I want to retrieve the values of selected detail lines to invoke an action in Acumatica. Some values from the selected detail lines should be passed as parameters to open a custom screen in a popup. How can I retrieve the selected detail line information from a grid to use in an action in Acumatica?Any detailed instructions, tips, or code snippets would be greatly appreciated. Thank you!

I am trying to use a import to update emails on Contact.  What am I missing here ?I have the Contacts ID pulled from a GI21.115.0017 

Hello,I need to use an import scenario to add contacts to existing vendors.I am only adding “LAST NAME” and “EMAIL ADDRESS” for each vendor contact.My import scenario into the Contacts screen works without error.However, only the last contact in my data provider is actually added into Acumatica.I believe this has to do with the lines at the beginning with the (-1) that Acumatica normally adds automatically when you create a new import scenario.  It did not add those lines when I created this import scenario.Again, the import scenario says it processed all records and shows no errors.  However, only the last contact shows in Acumatica. 

Hello all,I have been trying to import Customer Contacts but only my last contact is getting added out of 5 of them. Below is the import scenario:FYI, when I try to search for the Contacts (CR302000) form in the Universal Search Bar, it doesnt list the screen, due to license restrictions, as its not purchased. But still I am able to access the contacts form if I click on any of the contacts from the Customers (AR303000) screen → Contacts tab.We do have the option the create a contact on the Customers screen but how shall I build an import scneario for the same? 

Hi Acumatica experts,Hope you are doing well.I have a requirement to add an auto-complete feature to a custom column within an existing selector.For example, in the Inventory ID selector, I have added a custom column to the selector. I would like this custom column to use the auto-complete feature so that when I type text contained in this custom column, suggestions will appear without clicking on search icon, just as they currently do for Inventory ID and Description. I understand that these fields are key fields, which is why suggestions are available for them by default. I’m looking for a way to make my custom column support auto-complete suggestions as well.Your insights on this would be greatly appreciated.

I’ve build a processing screen for showing log entries and i have an action to show the details.I am not able to get details shown on double click on a grid row.  Any ideas?

Hello peeps.I have been asked to test the Smartsheet integration and just wondered is it possible to test on a trial account or do I need to sign up to a Smartsheet plan? Also the information on the integration with Smartsheet seems sparse, if anyone has any extra detailed information it would be really cool if you could share that with me.Many thanksCarl

Can a debit adjustment not be applied to a bill before it is approved?  This seems backwards for the approval process.  I’m asking a reviewer to approve a bill that they know is wrong because a debit adjustment has been issued.  They have to approve the bill and HOPE that I correctly receive, process, and apply the debit adjustment.  It seems like the reviewer should see the bill with the applied DA.Do I have something set up incorrectly or am I missing something in my thought process?Thanks.

Hi allI need to round down values in report designer. Say a customer owes $1076, we need it to show as $1000 only. Please advise

I can't find them in the attributes. How can I select the field name in my import scenario?

Hi Everyone,We are comparing data from the Account Details and the Historical Inventory Valuation Report for specific accounts, but the figures never match. In this case, the Historical Inventory Valuation Report showed a zero ending balance for the account, while the Account Details reflected a balance of 47,069.30 for the same period. Does anyone know the cause of this discrepancy and how to resolve it? 

Hoping someone can provide a way to resolve this. After DB schema changes some of the standard field names have changed. These fields are referenced in many Dashboard Widget filters. The underlying GIs have been updated, but the filters on the dashboard require someone to manually go and change to the new fields. Is there a clever way of updating these in bulk, as in if there is a field e.g. FieldName1 change to NewFieldName1. Thanks in Advance :)

This is the screen prior to the October, 2024 update of our Purchasing Receipt form. The TOTAL COST - was included and we used it to verify the invoice amount. They have since removed it from the Sandbox - does anyone have a fix.  There is no way to verify the amount of the entered invoice(receipt)- some our invoices have over 100 lines and not all the lines on the PO are included - backorders, etc... I understand why they might think that it was helpful to remove it - but for those of us who require it to balance the cost of goods it is a real problem. Any solution?

Hello all,We are running 2023R1 manufacturing and we are trying to Generate Orders for Sub Assemblies from assembly Inventory ID’s, but we are coming up multiple instances of this same error.AM Error: The following error occurred when the system tried to copy the BOM: Error: An error occurred during processing of the field Inventory ID value 32369-20030 IN Error: The inventory item is a template item.Highlighted is just one of multiple Inventory ID that this error could occur on.  We do not have any templates in our system and none of the Inventory ID are template items.  Actually Matrix Items is not enabled in our system.When we look at the BOM for say this inventory ID 32369-20030 it shows a warning that 32369-20030-1 is a template item, but again this is not a template. (see image attached)When we open the stock item screen for the assembly with the warning (32369-20030-1) add a space to the description, save the stock item the warning goes away.But this does not hold and we just mo

I am trying to follow the examples for the screen based soap api services, I am able to generate the wsdland insert it in the console app but I have no Screen Class, I cannot do apitest.Screen context = new apitest.Screen();I am using VS2022 and there are no errors, but I cannot find this Screen class,What am I missing?

Has anyone encountered the Substantiated Billing - Consolidated report (PM650050) displaying links instead of images for attached PDFs after switching external file storage to point to Amazon S3 storage? We verified that the attachment files exist in the S3 bucket, but for some reason won’t display on the report.

Trying to ship with FedEx, however, when ever we refresh rates, we get the error “Object reference not set to an instance of an object". Any idea what could be causing it and how to fix it?

Has anybody used a solution from a ISV for Electronic Driver Logs? Our current company does shorthaul which doesn’t require EDL but we are starting to see that with our trucks traveling beyond 150 miles radius that it will be required. We are hoping if it has some Acumatica intergration it could help our company with some intercompany billing. Anybody familiar with what solutions are out there and how its worked for them? 

Is Form 1096 available in Acumatica?  This form is used in conjunctions with Form 1099 filed with the IRS.  When 1099 forms is e-filed, there is no need for the 1096 because it should automatically generated.

Hello,Is there any way to not include the PO open order quantity in the available quantity on sales order ? For example, we have 2.28 CS of this item on hand, but the system shows 6.28 CS available because it included 4 CSs from open purchase orders that have not been received yet.  

Hello,I try to add the new custom field on the screen and when I create the control for new custom field it just uncheck the box I selected and not showing it added.Can someone help me with this issue ?Thank you very muchSee below for more information 

I’m importing into the Project Budget Forecast screen and I have it working except it is requiring an inventory id. If I put in an inventory id, it works. However, all of my other budget lines don’t have an inventory id on them (<NA>). Is there a way I can get this to work for the <NA> lines? Thanks in advance.Paige

Hello,I’m interested in importing our client’s Project budget by month into the Project Budget Forecast screen.  I have a lot of experience importing to Transaction screens, Profile Screens, and Preferences screens… but the Project Budget Forecast screen looks very different .The first step of designing any import is to manually enter the same transaction, and when I manually type a project and revision # in the Project Budget Forecast screen, the screen populates itself and resulting lines aren’t available for edit. The project fields are not populated to every line so I’m having trouble understanding how an import would work.Before I spend a lot of time figuring this out…. can anyone confirm if it is possible to import to the Project Budget Forecast screen??  Thank you.