Discussion Forums

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.  

I am trying to pull the total quantity from the invoice screen (via Report Designer) when it is under the sales order tab (so not released yet), as some customers need the invoice prior to our Financial Director releasing the invoices. Anyone know a way to do this? I have to do the below within report designer, but the system seems to get confused when there is more than one sales orders on the invoice.  Value used in Report DesignerThe value the report gives me (should be 15,234 units for this example)Pulling from this page (Sales orders → Invoices) 

We opted to use branches because we are technically a two branch company internally, however, as far as our customers are concerned we are one company, one branch. Because we opted for branches, the default customer statement (consolidated included) form wants to group AR documents by branch but this confuses our customers who expect all their documents in order by document date. This in spite of the AR Preferences consolidation setting set as below:  I attempted to remove the Branch group in the report designer, and while this fixed the sort order, the “...AgeBalance00-05” fields started calculating as though only for the first branch.Further testing suggests the report was using the groupOrganization footer which does use the OrganizationAgeBalance00-05 fields rather than the customer equivalents, but both customer and organization are higher level groups than branch, so I don’t know why they would be recalculating as though per branch. Does anyone know how to keep branch configurati

Customer has a legitimate reason to have production order qty exactly 1. I have tried setting Min Order Qty and Max Order Qty to 1 on the manufacturing tab, but when I create a production order from a sales order line with a quantity greater than 1, I still get that quantity in a single production order, rather than multiple production orders being created with a quantity of 1.Has anyone been successful getting MFG Max Order qty to work for this scenario? No success on 24R1 nor on 23R2. 

Please help to solve this error:“Error: An error occurred during processing of the field Amount value 6500 The document is out of the balance.”   

hi i just want to ask can i get the trans tax amount per transaction because i can only get the total[APInvoice.CuryTaxAmt] i have the solution but im having problems because if it has more than one taxid it duplicate its record based on how many tax ID it has  

I have 2 fields declared in DAC. Here is the part of codeAccount(DisplayName = "Offset Account", AvoidControlAccounts = true)]public virtual int? OffsetAccountID { get; set; }SubAccount(typeof(ARPaymentChargeTran.accountID), DisplayName = "Offset Subaccount")]public virtual int? OffsetSubAccountID { get; set; } As a result I have this.When I use [Account] attribute on both of fields, I am able to see the lookup, of course both are of Account data. The main problem is, that I have the correctly working lookup in another test Acumatica instance. The same package has different behavior in different instances. Both instances have the same options enabled on Enable/Disable Features screen, including the Finance - Advanced Financials - Subaccounts, both are of version 23.202.0026. Note, that the correctly working one was upgraded from 23.105.0016 and had a snapshot restored. If the problem is based on version, version upgrade, then we can do nothing, but if is based on snapshot, then I just

Hello,I’m creating SDK tests, and I need to know how can I use the "select all" option in a grid?Thanks