Solved

Have a strange situation with shipping via UPS.  During rate shopping the rates show almost double during shipment but once the shipment is confirmed, the rate is reduced to the negotiated rate.  Has anyone experienced this before?  How can we get the negotiated rates to show up during rate shopping.  

Hello all,I have a carrier which has a sub section of Medium Flat rate box. As of now this sub section is getting calculated based on the box dimension & weight. How can I setup a fixed flat rate for this box?  

Problem:1. An inventory item “CS1455330” was ordered with the “Mark for PO” check box in the Service Order. 2. This item was received, but as the appointment was completed, we realized that this item was not needed. We would like to just keep it in stock, but no longer have it allocated to this service order.3. I have tried to “Delete the line” or “Change the line status to ‘Canceled’”. This is the message that is shown when I try to do either of those actions: 4. We could just ignore it on the service order, as we have already billed the customer for everything else on the appointment. The only problem is that this inventory item will always show as unavailable for other customers, as it is already allocated to this service order. Any ideas on how to delete this allocation and make it just be in stock and available?Thanks for the help!

By default Acumatica displays sent email as an envelope and received email as a paper airplane. Am I missing something or isn’t this the opposite of what one might expect? Or is there a way to change it? 

I have been unable to get Acumatica 24.209.0013 to work with SQL mirroring. All of our db’s including Acumatica are mirrored correctly. With mirroring off, everything works as it should. My connection string has both the Failover Partner and Initial Catalog keys defined, but something somewhere is ignoring them because I get the error: “Use of key 'Failover Partner' requires the key 'Initial Catalog' to be present.” when Acumatica tries to connect to the database. Has anyone successfully gotten this to work?

Hello,         I like Acumatica’s user defined fields feature, I can add fields without writing code.But these fileds are disabled when the shipment is completed, while I’d like to keep it being enabled.    Is there a way to do it?         I’ve found a similar question above, but as I checked, I can not find the “UDF” in automation steps. So I can not enable it.      Is there any other way to do it?

We have stock items that are now discontinued, but we still have inventory in our other warehouses. Is is possible to prevent sales in one warehouse but still allow in another? 

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? 

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? 

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