Solved

Hello Everyone, We are trying to  Extended DAC Fields in the Sales Quotes header section classic to Modern UI .DAC has 4 extended fields need to display it in the modern UI Sales order screen.  tried with below code, Unable to see fields in Modern UI, below screenshot red marked field need to display it in the modern UI Sales Quotes screen header section.classic UI screen shot tried with below HTML Code but when switched to Modern UI , cannot see these fields in UI 

Hi everyone,I’d like to ask if Acumatica has a subaccount mechanism similar to other ERP software (as shown in the attached image from NetSuite).In this structure, users are not allowed to post transactions directly to the parent account, and reports querying the parent account will automatically sum the data from its subaccounts.Does Acumatica support this functionality, and if so, how can it be configured?Thanks in advance!

I have a client that would like to view all of their fixed assets and their calculated depreciation for the next 12 months in a single report. I have edited a copy of the Fixed Asset Balance report (FA630000) and I made a custom report (FA63001D) to use as a subreport that will list the financial period, calculated depreciation, and YTD calculated deprecation.  The subreport takes 2 parameters: [FixedAsset.AssetCD] and [FABookBalance.BookID]. Passing the BookID works fine but for some reason it doesn’t like how the AssetCD is passed to the subreport. If I hardcode a value for it like 1000-001, it works but I want it to run the subreport for each asset in the main report. I’ve also tried basing the subreport on [FixedAsset.AssetID] but this gives the same result. The stack trace only gives this for a SQL message:  @@DBTS, IDENT_CURRENT('WatchDog') OPTION (OPTIMIZE FOR UNKNOWN)/* */  

Hi all,I have a local instance set up for training (Build 24.112.0026), and I am seeing the following message on the Transactions and Profiles tab after performing a Universal Search:The search by a phrase or a list of keywords might not work because the Full-Text Search feature is not enabled. Contact an administrative user to enable the feature.I have run ‘Process All’ on the ‘Rebuild Full-Text Entity Index’ screen, and I have also tried the ‘Restart Full-Text Search’ option, but I am still seeing the warning.Anyone seen this before or know how to deal with it?

I am trying to add the Unit Cost, Average Cost, and a custom field Kit Unit Cost to the Sales Order Details container in the mobile app. Here is my code to do this:update screen SO301000 {  update container "Details" {    add layout "LineCostRow" {      displayName = "LineCostRow"      layout = "Inline"      add field "UnitCost"      add field "KitUnitCost"      add field "AverageCost"      placeBefore group "LinePriceGroup"    }  }}This only added my custom field Kit Unit Cost (Shown in image below): I tried simplifying my code to this:update screen SO301000 { update container "Details" { add field "UnitCost" add field "KitUnitCost" add field "AverageCost" }}And the only field displayed is my custom field as well, just at the bottom of the container. I’ve confirmed the field names using the WSDL Schema as shown in image below:Any suggestions on how to get either Average Cost or Unit Cost to show up on the details tab of the Sales Order? Am I missing something? Any help wo

HiThe aim of this topic is to identify how to add invoices with different customers to "Documents to Apply" tabThe result which I am trying to achieve look like this The Customer of the Payment is ABCVENTURE and the customers of the invoice which I added to the table are AVCSTDUDIOS and ABCVENTUREHowever, in another acumatica I can’t add invoices with different customers, for example Here Acumatica allows to add only one invoice, because only one have corresponding customerHow to add invoices with different customers ?  

Hi All,I have a GI where I am pulling the total quantity required for Materials in multiple production orders.The GI is grouped by AMProdMatl.InventoryID and the TotalQtyRequired has the aggregated function: SUM. Then I have the INSiteStatus.QtyOnHand which I have the aggregated function: AVG so that I see the actual On hand quantity and it does not technically get grouped. What I would also like to have is an expression of =IIf( ([INSiteStatus.QtyOnHand] - [AMProdMatl.TotalQtyRequired])<0, [INSiteStatus.QtyOnHand] - [AMProdMatl.TotalQtyRequired], null) Meaning if we are short QOH for what is totally required, it will show the difference. Or else its blank. For some reason I cannot get this Expression to display correctly. I am assuming it is because of the Grouping and maybe aggregated functions. Is there some way I need to do something to choose the aggregated function like this:=(AVG[INSiteStatus.QtyOnHand]) - (SUM[AMProdMatl.TotalQtyRequired])   ? I have attached my GI, a lot of

Stock item has demand and shows up in Inventory planning display.Source accurately shows as “Manufacturing”.It has an active BOM.I select the line and click the action of “Manufacture”.It looks like it is working, and the message comes up “The operation has completed”.However, the line remains in the inventory planning display grid, and not production order is created.Any thoughts why the production order is not created?Thanks!

Hello all,We are running into a potential bug with the PaceJet carrier integration. We recently updated to 24R2 in an attempt to have the following workflow without customization:Create a Sales Order with PaceJet as the Carrier for shipping.  Create a Shipment for the Sales Order from the Process Orders screen. Use the Pick, Pack and Ship screen to handle picking and, once completed, confirm the shipment. Pack the shipment in PaceJet manually. Update the Acumatica Shipment from the Process Shipments screen.The issue we encounter is that PaceJet does not receive shipment information unless a shipment has at least one package added to it before shipment confirmation in Acumatica. We have the Carrier configured with the Usage Scenario of ‘Manual Packing and Shipping in Pacejet’, which appears to mean that all packing will be done in PaceJet so the Acumatica shipment will receive all of the box information externally. Yet when a shipment without any packages is confirmed, the PaceJet Statu

Hi all, I have a prospect who uses Exaktime for time reporting and imports that data via AccountLynx into ADP for payroll, he says this “connection is unreliable.” Has anyone experienced issues with data import from Exaktime to Acumatica? Any help/feedback is greatly appreciated, thanks in advance!

Hi Guys,I have not built an import scenario before.  I need to create a scenario for importing credit card payments into our system so that we dont have to have someone key in all of the credit card payments manually.Can someone suggest where I might find good information on how to create an import scenario from scratch to accomplish this as the canned one seems to have fields in it that do not exist, so I need to modify it or create a new one.   As always, your thoughts would be greatly appreciated.

I'm currently working on SDK tests and need to interact with various Dashboards. The SDK README file provides instructions specifically for Dashboard DB000038, which is functioning correctly on my end. However, I’m unable to access any of the other Dashboards.My question is: do we need to generate wrappers for the other Dashboards? If so, what is the correct process for doing this, as the Class Generator does not generate them? Alternatively, if wrapper generation isn't required, how should I access these Dashboards?Thank you!

Hi, We are trying to create an import scenario to mimic pushing the ADD INVOICE button on RC order types. We are trying to select a certain item from a certain AR Invoice. The issue we are having is trying to select or check the Selected box on the Add Invoice Details pop-up. The pop up box is looking for the Add & Close button but that is not available as a dialog answer selection. Here is an image of the Import scenario. It is also attached.   

I created a Dashboard. But I get this error in KPI Widget. Any idea of this .The GI Works Fine BTW.  

Hello - Looking to see if anyone has an AP Aged Period Sensitive as a Generic Inquiry?

We have a number of COD customers, this means that they have payment terms stating 0 days (nothing to do with their actual payment method).  Essentially we want to create an invoice for them (showing their details) that must be paid instantly.  However, any invoice immediately goes onto credit hold, due to their credit verification being days past due.  What is the best way to manage this, that ensures:Any invoice becomes due immediately No credit hold needs to be released when creating the invoice

I was making some changes to the Project Issue report and now it is completely inaccessible. Usually if there is an issue I can go back to a previous version, but the system isn’t even allowing access to the screen where I can select an inactive version. When I click on Project Issue Form under Project Management/Reports, I get the “We’re sorry an error has occurred...” message. When I click on show trace it tells me the error is 'Element' is an invalid XmlNodeType.I also tried opening the report directly from report designer and receive an error message there stating “The designer loader did not provide a root component but has not indicated why.”How do I fix this? Any suggestions would be appreciated.Thank you! 

Hello Guys, I would like to add the proforma invoice type to this drop down. Hope you can help me :) 

We recently had a vendor change how they were selling some of their material and we wanted to update the Conversion Factor on the Stock Item to match the changes. Currently the material is on several orders and it errors saying “The unit conversion cannot be modified because it is currently in use in the following document -***”. Is there a way around this without having to remove the material from all the Purchase and Sales orders or some way to make it apply going forward or is removal the only way?

Had this issue at first, replaced the table and then got this issue after. what would be the equal to this table in acumatica? Client upgraded from 23R1 to 24R2 and started to have issues with these reports that worked before

Hi all,I was wondering if there’s any way to configure a tax code with Net/Gross amount entry on AR invoices and AP bills respectively. For example, I’d like the calculation rule to be inclusive line-level for output VAT, and exclusive line-level for input VAT. Is there any way to achieve that, other than creating 2 tax codes?Thanks! 

CASE:A purchase receipt #66 has been matched to an invoice #77, when I do the return for this purchase receipt, Acumatica generated a return #88 directly, Acumatica doesn’t require the matched invoice #77 to be reversed. So in the end, I returned the goods to the vendor through purchase return #88, but I can still pay the invoice #77 to vendor. This is very dangerous.Also if I don’t reverse invoice #77 and do the purchase return #88, GRNI account will not be correct, it has two debit amount, one from invoice #77 and the other from purchase return #88.Any comments or experience why Acumatica doesn’t force the matched AP invoice to be reversed before doing the associated purchase return? Thanks!   

Hey Team,AP Viewer role permission is set as Read-Only for Bill & Adjustments Screen. but the user is still able to perform PAY action on the screen. There are no Customizations on the site. One thing I noticed is the default workflow for the screen is disabling the PAY action only when the status is closed. Could this be the reason why the Permission set on Access by Rights Role is getting overridden by Workflow condition. 

I need to show a data field as justify not left/ center/ right. Is it possible do it 

We have a customer that overpaid, and now we would like to move that overpayment to the Customer Deposit account on the balance sheet.  We believe we need to too this via a Journal Voucher to ensure that the customer’s account will be properly hit to move that credit from their A/R account to the deposit account.We have tried this a few ways without success.  Does anyone know which module/voucher type we should use to accomplish this so the proper transaction hits the accounts in the correct way?Patrick