Solved

I'm working in Acumatica Report Designer and building a report that joins ARTran with ARTax. The issue I'm facing is that when a transaction line has multiple tax records (i.e., multiple ARTax rows per ARTran), the detail section repeats the same ARTran line for each tax row.I only want to show one line per transaction (ARTran), and conditionally add the tax amount only when the TaxCategoryID is 'OTP'. Additionally, the ARTax.TaxID can vary by state (e.g., MSOTP, AROTP, TNOTP66SALES, etc.).I’ve used this expression in the detail section:=$DrCrSign * ( [ARTran.CuryTranAmt] + IIF(InStr([ARTax.TaxID], 'OTP') > 0, [ARTax.TaxAmt], 0) ) Please guide thanks

Is there a way or can it be added to see the Operation Description on the Clock Entry Screen (mobile app) instead of just a number..? We are using the clock entry on the mobile app for the employees in our shop, however since they just see Operation ID 10, 20, 30, etc. and not a description it is causing quite a bit of extra work on our managers to make sure their time is coded to the correct ID. Any suggestions welcome. 

I can find a lot of information about gateways, but not any about hardware. Anyone have advice? 

Our system is set up to send the buyers a copy of the approved PO once the approval route has been completed. It is a regular occurrence that the PO received from Acumatica will be blank. There does not seem to be any reason, it fixes itself, and then happens again. Is there any way to keep this from happening?

For some reason, the “Add Link” function is no longer working for me. I use this to pull the attachments/Files from the requisition to the Purchase Order. It is no longer giving me access to the requisitions when I click on it. When clicked, it takes me to “Approvals”. See screenshot.

I need to send a report on a Schedule in 2022 R2.I was told that the Send Reports screen should not be used anymore.  (Although the referenced article says Automation Notifications have been changed to Business Events: https://help-2020r2.acumatica.com/(W(2))/Help?ScreenId=ShowWiki&pageid=59d32d60-ccc5-471e-bb6a-b03ef60a3318)This report just needs to be emailed to a person (or various people) on a scheduled basis.  The Business Event screen requires a Generic Inquiry to create a schedule but all I want to do is email the report to an email address that may not be set up in Acumatica).  This was being done with a Template on the report and then scheduling it with the Automation Schedule screen using the Send Reports screen.  Can someone confirm whether or not this is still supported as it has been working but we are upgrading them to 2022 R2 and I don’t want to run into issues that I can’t get support for.Thanks for any information!

Hi Everyone! I’m trying to create a Generic Inquiry that shows the Shipment Quantity, Price, FX rate with reference to the customer as well.  I have created the attached but it doesn't load. Is there something I’m doing wrong?

Hello - I'm struggling to figure out why the “Pick List” report is printing with the huge space underneath data, then will have a page 2 with more of the data. Any thoughts on what I am missing? to condense it all to one page?  

Requirement is something like we need to read files from given SFTP credential and path. (Need to read files 4 times per day)After reading file we need to create stock item in Acumatica.I try to search this type of requirement but cannot get success.I found some help from various blog / question. According to that we need scheduler process and custom data provider.But I don’t know flow. Can anyone explain me steps? 

Hey Everyone, I recently created my account using my company email but for some reason I can’t access the product ideas section on here. Everything else is fine but when it comes to this area of the community I get the following message:   Have anyone experienced this before or could give me a hint on how to get access to the product Ideas? I shared this message with some of my colleagues here that also have access to the portal and they don’t recall going through this error. Thanks y’ll in advance!Brian 

I have a rather strange situation that may or may not have an answer. I’ve reached out to the Report Design community before and while there have been some very good responses, none of them are working for what we are trying to accomplish. We have International and Domestic Invoices. One in a while the International invoices will have a free item (Item A) on it along with an associated LotSerialNbr. If there is a similar item (Item A) that is also on the invoice that is a purchased item(s), then the LotSerialNbr of the purchased item and free item are listed together (which we are pulling from a subreport), and the free item will also show the paid item LotSerialNbr along with it’s own. I’ve tried using two different subreports, using a condition, ARTran.IsFree = True for the free item, or ARTran.IsFree = False. I have tried ARTran LEFT with SOShipLine and so far have not been very successful. I am attaching the main (SO643000.rpx) and the two subreports (SO6430C8Sub.rpx, SO6430C9Sub.r

I’m trying to put together a SQL View on CRM Quote data.  In the DAC, CRQuote has an OpportunityID field that ties it back to CROpportunity.  It turns out that field isn’t in the database.  I looked at CRRelation (since I know that ties CRQuote back to SOOrder), but I can’t find a common thread in there either.  I picked an opportunity with multiple quotes and tried to find every NoteID field on the Opp on every NoteID field in CRRelation with no luck.This isn’t an end of the world thing--I can just go back to doing what I’m trying to do with a GI.  But at this point it’s more of a quest--I know that those two tables are somehow related because they get related in the DAC, and I’m really hoping to find out how they are related.

Is there a function in Acumatica similar to C# where I can return the total number of days in a month for a GI Column?For example, I want to return the number of days for May of 2018.  Using C# I can use the statement below to do that.  Is there a function in Acumatica that I can do the same in a GI? This function returns the value of 31.int days = DateTime.DaysInMonth(2018,05); Would also be great if I could also determine the weeks in a month returned as an INT.  But I really need the days.

Hey there, The access rights for various forms, such as the Wiki form is showing numbers instead of "Granted” or “Edit” for example.  Here you can see that numbers should not be showing up. Thanks!

Has anyone experienced an issue with using notification templates attached to a report (via report designer) when sending emails? In 23R1 I attached the notification template to a report, which when the report was emailed it would include the notification from the template. In 24R2 this does not include the notification from the template and is blank as shown below.  I cannot seem to find any difference in setup and wondering if it is a bug.  

Hello everyone,I want to customize the ship date by adding a new field from the SOShipment and transfer its content to the Invoice.Does anyone know how I can link the SOShipment and Invoice screens to include this field from the Shipment note in the invoice?I tried to connect the screens using this formula.  Best regards,Pantea 

Hello.We would like to know if it is possible to import sales orders via Excel that contain multiple rows per order and use the automatic numbering feature. We have found several topics on this in the community, but none of them have worked for us yet.Any help would be appreciated.Thank you.

Hi,I am trying to use the “Quick Process” in an import scenario.   The SO already exists in Advanced.  The import contains only the Sales Order Nbr.   The SO has he “Quick Process” actions to “Ship” and “Invoice”.  The Import Scenario comes up with an Error “View: Name Document”.Import Scenario is very basic.  It is attached.I would really appreciate any assistance.  A Sales Order just needs to exist in MYOB. Add the Sales Order no. i the Import Scenario .  And the quick action turned on in the SO Type. Regards,Laura 

Trying to show debit adjustments as negative values in my existing GI but I can’t figure out how to target them specifically. Below are the formulas I am attempting to use: =IIF([APInvoice.DocType] = 'DebitAdj', -[APTran.CuryLineAmt], [APTran.CuryLineAmt]) =IIF([APInvoice.DocType] = 'Debit Adj.', -[APTran.CuryLineAmt], [APTran.CuryLineAmt])Thanks

I'm trying to implement a custom feature switch in the Enable/Disable Features screen (CS101000). In my extension library, I added the following code to a new file named FeaturesSetExt.cs:namespace PX.Objects.CS{    public class FeaturesSetExt : PXCacheExtension<PX.Objects.CS.FeaturesSet>    {        #region UsrCustomSwitch        [PXDefault(false, PersistingCheck = PXPersistingCheck.Nothing)]        [Feature(false, DisplayName = "Custom Feature")]        public bool? UsrCustomSwitch { get; set; }        public abstract class usrCustomSwitch : PX.Data.BQL.BqlBool.Field<usrCustomSwitch> { }        #endregion    }}I also added a new Features.xml file with the following content:<?xml version="1.0" encoding="utf-8"?><Features Type="MyExtLibrary.FeaturesSetExt" Key="0">    <Feature Name="UsrCustomSwitch">        <Access ScreenID="SA101000"/>        <Access ScreenID="SA201000"/>        <Access ScreenID="SA401000"/>        <Access ScreenID="S

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?