Discussion Forums

After an upgrade to 25R1, ShopifyxAcumatica connector is now failing to sync payments with this error that seems to be a permission access for the Shopify app.  

I’m using GI as a datasource.   The datasource GI uses INKitRegister to group by site and date to create a total kit by day.  Then I’m trying to join to individual kit assembly to understand percentage of total for day.  I’m getting a multi-part identifier could could not be bound.  _INKitRegister.DocType.  I added DocType to the results and tried to adjust the joins.  Any assistance is appreciated.

Dear Team,Im following the instruction for disposing asset from doc Disposing Fixed Asset: Process Activites As Step 1, on the disposal table, when I click on OK, the system show the error message “Unreconciled asset can not be disposed” On Reconciliation Tab, I have some transactions havent reconciled yet. However it’s not related to this FA. And before that I am successfully perform the Disposal already for another item.

Hi guys,A customer wants to create variants, but their item names are very long because they use the Description Segment Setting and include many attributes, which should also appear in the item names.Currently, the allowed length for the item description is too short and needs to be extended.Hope you can help me with this 

Site is 2024.114.301.3686 [24.114.0020]The error is occurring on printing a purchase order.I have opened the report in Report Designer but have been unable to find the field that needs to amended.I have been advised that the field that has changed is OwnerId. I cannot find OwnerId or EmployeeId on the fields used on the form template or in any of the relations. Can anyone advise where else I can look to identify this on the form template or perhaps has specific information about what has changed in this version of Acumatica Purchase Orders on the database fields. 

I have a processing screen that calls an action on the Sales Order screen (SO301000), which is intended to combine the custom Work Order report (PS652000) into a single PDF.The action having the following code  public PXAction<SOOrder> printworkorder;[PXUIField(DisplayName = "Print Job Order", MapEnableRights = PXCacheRights.Select)][PXButton(DisplayOnMainToolbar = false)]protected virtual IEnumerable printWorkorder(PXAdapter adapter){    PSConfigReportMapping mapping = PXSelect<PSConfigReportMapping, Where<PSConfigReportMapping.jobType, Equal<Required<PSConfigReportMapping.jobType>>>>.Select(Base, "S");    PSConfig crow = PXSelect<PSConfig>.Select(Base);    string reportID = "PS652000";    List<SOOrder> list = adapter.Get<SOOrder>().ToList();    if (list.Count > 0)    {        Base.Save.Press();        Dictionary<string, string>

Hi all,I’ve set up multiple Pivots in Acumatica and shared them with several users. One issue I’m running into is that when a user applies filters, those temporary filters affect everyone. Each user then has to manually remove them before adding their own.Is there a way to share the Pivots but have them reset when someone else accesses the same Pivot  or navigates away and back? The goal is to make sure filters reset automatically so users don’t have to clear them manually each time. Thanks  

How can I correct this error? A staff member ran a payment with the wrong cash branch and invoices. We did not purchase the inter-branch transaction feature. This is zero impact entry.  

Hello Community,I am looking for the ability to have a company with multiple branches have the transactions created in said branches roll up into the main company ledger. Is this something that can be setup by default with intercompany\branch functions or another way? I understand we could accomplish something like this with ARM reports, but really, we are looking for journal entries to be created in the parent company for bank consolidation purposes. Does anyone know of an existing configuration that would allow this? Thanks in advance!

Hi All, @Naveen B ,is it possible to find a Shipment and update the lines and then confirm it in one Import Scenario?I have the attached import scenario but not successful.Cheers,Laura 

Hi Team,We're running into an error it I believe is related to the inter-branch mapping. See screen shot below. We are not able to transfer beer from BLBREW to BLREST. This is a critical process in our operation that needs to be rectified ASAP.

We have been testing the BigCommerce B2B customization on Acumatica 23R1 ahead of launching our BigC store, and we have seen a lot of issues with it. I was wondering if others have run into these problems and have a way of dealing with it or even just a better way of thinking about these problems so that we can live with them.We find it confusing that the main contact rather than the primary contact (except for the primary contact name) is used as the first admin info in BigC and don’t know how to treat the primary contact in Acumatica to make this less confusing. We also find it confusing that the 2nd rather than the 1st main contact phone number is synced to BigC. We don’t know how to handle the possibility of a customer deleting the first admin in their company in BigCommerce B2B since that is how the connector is connecting the customer in Acumatica to the company in BigC. We have noticed many, many issues with modifying existing customer d

Hi all,My company I work for is looking for an Acumatica guru that knows a lot of technical details/knowledge around the system. From coding to Velixo to Generic Inquiries, we need someone who is super knowledgeable about these technical details to come in to help mentor me and my teammate on some more of the technical aspect. Any takers? This person would be there strictly to mentor and teach us the deeper technical aspects of Acumatica. 

I’d like to embed a report into an email.  After my set up, the report is attached as an html form to the email.  What am I missing?In the Report Designer, I’ve set the Mail Setting format to HTML: In the Email Template: In preferences of Receivables, Customer Class and Customer:  

 Hi,I am trying to create a Gi where I need Projects in progress with Project Balance. Condition is Projects that has purchase orders and Project Transactions. I dont want to diaplay Purchase Orders or Project transactions under the project. When I inner join PMProject.ContractId and POline.ProjectId and PMtran.ProjectId I am getting duplicate records and the Project Balance are summimg up based on number of POs and transactions. Please help to find a condition similar to SQl query > Select PMProject.ContractId, PMProject.Description , PMTaskTotal.CurryIncome, PMTaskTotal.CurryExpense Where PMProject.ContractId in (Select ProjectId from POLine) and PMProject.ContractId in (Select ProjectId from PMtrans)…. ThanksSR

Hi Acumatica Community,May I ask if there is a way to change the Void Bank Deposit Date?Here’s my scenario.Deposit Date When I click Void. The Deposit Date is not editable.Is there a way to make it editable?Thank you!

Has anyone been able to get a Project Name/Description in an ARM report of the PM type?I’ve tried a few different things using @StartProject in the column set, but so far, I haven’t had any success.

I am trying to add one custom field in Purchase receipt Line details dialogue 's split grid but that field is not visible on screenbelow is the dacpublic class TSPOReceiptLineSplitExt:PXCacheExtension<PX.Objects.PO.POReceiptLineSplit>{#region UsrTSLineKitNumber [PXDBString(100)][PXUIField(DisplayName = "KitNumber")]public virtual string UsrTSLineKitNumber { get; set; }public abstract class usrTSLineKitNumber : PX.Data.BQL.BqlString.Field<usrTSLineKitNumber> { } #endregion}  

Acumatica Outlook plug-in tool is not presenting when clicked.   Reinstall is not working…..  what is the issue and how do I resolve it.    

The API I’m trying to use:Custom API, Entity representing the “Employee” screen (EP203000), an Action mapped to the “GenerateTimeCards” action.The Request I’m using:A “POST request using this JSON:{ "entity": { "EmployeeID": { "value": "A real employee ID" } }, "parameters": {}}The Error:HTTP 500, with the words “PX.Data.PXInvalidOperationException” in the stack trace.The Question:If I try to use this action from the UI, I am indeed presented with a dialog box.  I’d love to be able to figure out a way to tell the API to accept the dialog box with no changes, like I just clicked “OK” in the UI. I can’t seem to find any reference to this on the internet.  Does anybody know if this is even possible?  Thanks if you can help!

We added a new branch and certain documents, such as Purchase Orders, are sending from the system email account instead of the user’s email account.   This causes issues with the buyer not receiving replies back from the vendor.   We have two other branches where this is not the case.   I cannot find a difference between the branches that are working and this one that is not.   Email settings and templates appear identical.Working example: Non-Working example: What am I missing??? Thanks,Brett 

Hello Experts, I am facing one issue in business event i need to trigger mail from labor or move screen once create and edit inspection datasheet button is pressed.1.Have taken type as trigger by action, but unable to trigger mail from this event .2.Create and Edit Inspection datasheet button is QC user defined custom button. 

A parent BOM has been configured with input material which has a separate BOM both BOMs are active but when I create orders for subassembly, the orders are not generating. Currently using Acumatica build version 24.104.0008.

Hello All , Is there any way to highlight only certain words inside a grid cell as shown in the screenshot .I have tried putting direct html <strong style=\"background:yellow\">DANIEL</strong> like this.But it did not work . And all other ways it changes the whole cell background colour or font colour . Not for specific word .Any help would be appreciated .Thank you 

I have a GI and want to include the adjdLineNbr field from the APAdjust table, however the column won’t show on the GI. It does have the exclamation point over the field and says “This field will not be displayed for the current user because the user has insufficient access rights or the required feature is disabled.” But I am logged in with the admin account. I’ve taken a snapshot of their tenant and imported it into a local test environment and I am able to add and see the field in a GI even though that error message remains.Can anyone think of any reason why it wouldn’t work in the Acumatica hosted instance?