Discussion Forums

Dear Sir,I’m experiencing an issue while trying to open server-side reports using the Acumatica Report Designer tool. I can open local reports without issue, but when I try to access reports from the server, I get the following error:System.Xml.XmlException: Root element is missing.  at System.Xml.XmlTextReaderImpl.Throw(Exception e)  at ...  at PX.Reports.Design.ControlHelper.ReadConnectionHistoryFromConfigFile(...)This seems to be caused by a malformed or corrupted XML configuration file. Based on my investigation, the error relates to the file:C:\Users\<MyUsername>\AppData\Roaming\Acumatica\PX.ReportDesigner\ServerHistory.xmlI’d appreciate your assistance in either:Replacing the corrupted ServerHistory.xml with a valid one, or Confirming if the file can be safely deleted so it can be regenerated by the application.Please let me know how to proceed or if any additional configuration is required.

Hi, Trying to build out a GI and needing some help on an IF statement. Here’s the scenario.  If the Lot/Serial class is ‘LOTTED’, then the Lot/Serial Nbr. column should be ‘green’ for ‘LOTTED’ items where it is not empty and ‘red’ for ‘LOTTED’ items that are empty. If it is not LOTTED, then it should be ‘default’. If the Lot/Serial Class is ‘DEFAULT’, the QTY Remaining column should be ‘green’ if QTY Remaining > QTY on Hand and should be ‘red’ if QTY Remaining < QTY on Hand. If it is LOTTED, then it should be ‘default’ in this column. Here are my existing formulas in the respective fields:QTY Remaining:=IIf( [AMProdMatl.QtyReq] > [INSiteStatusSummary.QtyOnHand], 'bad', 'good' ) Lot/Serial Nbr:=IIf([AMProdItem.LotSerialNbr]= Null,'bad', 'good' )   

Phocas is an Integration Partner with Acumatica.Using Odata - GI and DACs to retrieve dataincrementally based on date last modified.I have a customer who has changed the InventoryID of an ItemI see that the related Sales invoices also reflect this change. (not sure if this occurs due to a trigger or if the transactions actually map to a hidden Key (other than InventoryID)Unfortunately since the transactional Sales data is load incrementally into Phocos it still contains the old InventoryID. Causing problems.The mitigation for us is to FULLY re load Transaction history but this is not ideal as it increases the server load and time to fetch information.I wonder if there is a non volitile hidden Key for Inventory that I could use Instead of a volotile (renamable) field InventoryID appears to be.Is there a way i can track inventory ID changes to handle the scenario of updating the Historical Transactions we store in Phocas   

Is there a way to narrow this error down to a specific area? I have changed all the fields I have found but says there is still an issue. It is an out of the box report from the system. but on upgrade utilized the old fields/   

I have a service order with an inventory item on an appointment, but the item did not flow through to the invoice.  I am not sure how this could happen.  Any thoughts?

Hi Acumatica,I created an Item for a Produce.There are multiple transactions and changes in Current Cost.Upon running the Cost Roll. There is a value in Pending Standard Costand click Update Pending. On the Stock Items Screen, the Pending Cost Updatedand Update Standard Costand the Current Cost is now Updated.May I ask where 1,063 came from?Thank you!

Does anyone know what happened to this on the 24R2 version? We just moved from 23R1 and its gone.   

We have a few clients who are looking for a more Robust RFQ solution than the standard Acumatica process can provide right now. The biggest issues they are facing is the volume of parts that they are trying to quote, from a variety of suppliers. To manually go through and select the RFT winner on these items is extremely difficult and time consuming. Is there anyone out there using a different solution?  We are evaluating SourceDay, but were hoping there might be a few other options out there!

Hi All, We moved to 24R2. When we search an item (first snippet) nothing is returned and need to use the magnify glass - but in the old version 23R1 we would get results to choose from (2nd Snippet). Anyone see this before and how to resolve it?  

Good day,I have been trying to get some confirmation on setting up Multi-currency report in Consolidating Reports.  So far, Velixo is no help.  I was wondering if adding our Canadian company to the current P&L Consolidated Report was as simple as adding the Acumatica Reporting Ledger to the list of ledger on the the report.  Has anyone done this?  Or have you set up the Consolidated P&L and Balance for USD reporting with other currencies.  I need to include a CAD in USD to the Velixo reports.Thank you.Evan

Hi everyone! I'm in a bit of a pickle.Goal: Take a list from a vendor of all the Drop Shipped items, make the receipts for them automatically with and Import Scenario, and then go on to the next project.Here's the rub though. Every time I run it, it will run the first line selected, but then skip the 2nd, run the 3rd, not the 4th. Etc. There's some variability if there's multiple lines, but most of ours are single ones. The error I get is:Field: Order Nbr., Value: 001325, Error: 'Order Nbr.' cannot be found in the system.The data is all coming out perfectly on the ones that do run, but I can't figure out why it's skipping like that. It claims it cant see the Order Number, but that feels like a bit of a red herring since the type and order numbers above the ones that don't run is in exactly the same format.  

Has anyone found a solution to using customer rate tables to calculate the line item billable prices?How do we create rate tables that can be attached to each customer?For example, we have some customers that always receive a 10% discount.  We have others who always receive a 25% discount.  We need to be able to attach the rate table that will be applied to each customer. We could do this in Sage CRE.  Since changing to Acumatica, we have lost this functionality, or maybe I am just missing it in Acumatica. Please let me know how if you have a solution for creating rate tables and attaching them to each customers' account.​@khowe86  

Hi Acumatica Community,I’m working on a customization for the Shipments screen (SO302000) and could use some help or insights.I’ve added a custom field under the Shipping tab that stores special notes (UsrNotes). The goal is:If this field contains a value, I want a popup message to appear when the shipment record is accessed.I’m using PopupNoteManager.Message inside the RowSelected event. It works mostly as expected. However, I noticed that when I navigate to a new blank record (e.g., using the navigation arrows or Add New), the popup still appears—even though it shouldn’t.Here’s a simplified version of my code: private bool _prompted = false; protected void SOShipment_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler) { if (InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (SOShipment)e.Row; if (row == null || _prompted || Base.IsContractBasedAPI || Base.IsImport) return

Hi,Wondering if anyone knows how I can access the fields that contain the cost data of a BOM?I would like to access the fields inside the BOM Cost Summary popup, either via a generic inquiry, API endpoint, or even just a BQL statement, to use elsewhereAny help is much appreciated!!

We are seeing this error when printing or emailing some invoices.  Not sure how to correct.We have tried clearing cache, multiple users have attempted and on different days. 

We have an item that is allocated. It is the last qty that is in stock:It is allocated to this shipment from this location:But, when we go to pick the item, we get this error. Our lot class issue method is user-enterable, so we scan the lot number when we pick the item. This is happening repeatedly. Since we are in Pick Pack Ship, we are stuck with leaving the item on back order if we want to get the order out same day, even though all our ducks seem to be in a row. Sorry about the size of the image.  

I created a new screen and I want to add a custom action to it for printing via device hub. I have done a couple of actions for device hub on existing screens as graph extensions, but i am having issues with doing it in a custom screen. Below is the code. I pretty much copied the existing ones that i had and changed the information where needed. i dont show any errors, but when i build this, the action doesnt appear on the screen. Did i miss something? I found several examples of device hub on existing screens but i cant find much on adding it into a new screen. Below is the code that i have. Thank you in advance. 

Looking for anyone that has had experience with the ADP Workforce Now/Acumatica Integration. We currently use ADP for all of our time keeping and export that data into a GL excel file that we then manipulate (that includes project ID, task and cost code) to upload Acumatica as a journal transaction. The two-way connector between ADP and Acumatica sounds promising, but it being so new, I’m curious if anyone has first hand experience and feedback on it?

Dear Team,Currently in Labor screen, if the “Qty in scrap” field is checked, then it doesn’t allow us to edit the Line details which were generated automatically. I have managed to make the fields as editable in Line details. But the problem is, i have 2 customized fields which i want to fill in the Data. After i key-in the data and save the value disappears. Please help me on this.  Regards,Ramya 

Our company is going to start implementing the CRM module on the mobile app, so I am in charge of publishing and customizising the defferent screens they feel they will be using the most often, which are Leads, Contacts, Opportunities, and Busines Accounts. However, I run into issues with all these screens.They all had screens initially in the CRM folder on Mobile, but trying to access the GI’s in the mobile app all give the same error, ‘SiteMap description doesn’t contain primary container’.CRM folder: Error when clicking on any of them: I have also tried creating separate, simple GI’s that would work as a substitute for these screens, like OpportunitiesMobile, but the same error occurs:I am at a loss on how to procees, and in the MSDL, adding ‘primary = true’ just gives a list of errors, and the only other item I’ve been able to find through the community was to delete and re-create teh SiteMaps, which I have done to no success. Any help will be appreciated.

Hi Acumatica, Is there a way in Acumatica to set the format of my password?Numeric Alphabet Alphanumeric Alphanumeric with special characterThank you!

How can I delete a Debit Adj and a Credit Adj in Payables?

Hi ALL,Profit & Loss Rolling 12 Month report (RM000030) runs incorrectly. Missing period 12. I looked at this report on Acumatica's Demo data and it ran correctly. It's possible that Acumatica's Demo data has Number of Financial Periods of 13 while our Number of Financial Periods are 12. I think Column Set on Report Definitions needs to be edited, but I don't know how to edit it correctly.  Looking forward to your support. Best Regards,NNT

Good day CommunityMy client is looking to change the life if a Class if assets from 36 months to 60 months from the end of a financial year.The challenge is they want to depreciate to remainder of the (extended) life of the asset over the remaining time (60 months - age to year-end) but depreciation now calculated as (NBV at year-end / remining life) and NOT (Orig.Cost / remaining life), e.g.Orig. Cost 07-2023        100 000.00       NBV 12-2023                   86 111.11          remaining months         55.00   New Month depr             1 565.66  (86111.11/55) Does anyone have any idea how I would set the deprecation for such a calculation please?Many thanks in advance.                     

I am trying to release a stock adjustment after stock take and get the following error. There are no details at all in the Trace. Has anyone got any ideas or seen this before?Many thanks