Discussion Forums

Hi Acumatica Community,We are going down the SSO integration path and I’d love if my import scenario could work! This is the import scenario structure:Import Scenario StructureWhen I attempt to run the import, the import succeeds with less than explanatory errors:Some of the lines are marked as processed, however, the user roles look like this:I am able to manually assign the AD groups to the user roles as required one by one, but who wants to do that! Any thoughts, questions, or advice is greatly

Hi,I'm trying to add a Business Event to add a SO Line when a Payment Method is CC (Credit Card).I have tried reading all online documentation, including a (to me) substandard video on the Acumatica learning portal itself, and other online video tutorials, but am not getting that info that I need to do this.  I would appreciate if someone could walk through the steps, and give an example.  I feel I am close, but can't get it to add the line.  In history it shows it running, but nothing is ever added.   I am sure I am missing something basic - like missing 1 step somewhere.   I wish the documentation was better.  It is pretty bare bones.I code, and do customization, but have never used the Business Events feature and trying to learn. Appreciate any feedback.I can post what I have done but I was really looking for a guide.  If there is a link that would be great but I have not found any li

We have a set of stock items, and those items are allowed to sell to only a customer.  Is there a way we can restrict so we don’t sell to other customers?

Can a Stock Item be available for sale to only one customer? We have custom products that are made specific for one customer and we don’t want these available to other customers or to be accidently sold to other customers. 

Problem Statement Attribute Adjuster Old Approach vs Attribute AdjusterHi Community,This post is dedicated to Attribute Adjuster which is a useful Acumatica helper that allows you to more elegantly adjust attribute's state in runtime. Problem Statement A lot of business logic in Acumatica is implemented in attributes. Sometimes, the state of attribute should be adjusted in runtime, for example

I am trying to build an import scenario that creates external user accounts for all of our active accounts.My desired outcome is below.  The users email address is the login name and the user record is linked to the contact record. When we use this in our external system, this is how we determine the customer that this user is associated to. I made this scenario but I can’t get it to work. I am unable to get it to link to the contact linked entity.  The mapping I am using is correct (ie: the string value for the display name matches the value in the linked entity box if I do it manually. Here is the design of my scenario: Here is the error I get w

I’m trying to set the Company/Branch field of the Load Options(Load Documents) dialog from the Payments and Applications screen to default to the whole organization as opposed to a specific branch.However, the field is configured with the OrganizationTree attribute, which doesn’t have an obvious way of overwriting the default.Since this field resolves to a the Baccount of the branch or organization, I tried appending PXDefault(1), but no dice.Anyone deal with this before? 

We have access to Kit Specifications and Kit Assembly however we are getting this error. Is this a access right or something else blocking our company from the ability to create kits in Acumatica. “Error: An error occurred during processing of the field Kit Inventory ID: Error: 'Kit Inventory ID' cannot be found in the system.”

HelloI’m trying to submit create purchase orders screen Id: PO505000 the bellow images are my endpoints structure Top-Level from CreatePurchaseOrders endpoint, screen id PO505000 and Details from Details, in order to be able to submit multiple data at a timeand the action is Process

Hi, each month when we Run Project Billings we get a handful of “Completed/Closed” projects that get pulled in because of “unbilled” transactions incurred for miscellaneous reasons.There doesn’t seem to be a default field or parameter to control this.Is there a way to exclude projects from the Run Billing process based on Status? 

I have an item we previously made in house, but are we’re now purchasing from an outside vendor. I’ve update the replenishment parameters and assigned those to our warehouse but the item is not populating on the Prepare Replenishment screen. The item is active, the Item Warehouse status is active, the replenishment method doesn’t have any launch or termination dates. I’ve tried deleting the replenishment method and adding back. I’ve tried overriding the replenishment settings  What am I missing here? What other settings would prevent this item from displaying on Prepare Replenishment? 

I would like to run a report with the data in the APTranPostBal “table”; however, it is hidden in the DAC. Has anyone used a variation of this in a GI (preferably)?  

HiI have a client who will be using ADP for payroll that plans on bringing in project related details using Project transactions.  The client has project specific rates for items and that works great for regular hours but occasionally they have overtime rates that need to be billed to the client.  What would be the best practice to accommodate the different billable rate? is it possible to have more than one rate on a rate table for the same item? One thought was to create a second non-stock item for each of their labor items to account for the overtime rate.  The client and I weren’t loving this option but were willing to explore. i’d love to hear what the community's thoughts are and what you may have done in the past? I appreciate your help in advance!

Hello all. We have built an integration to push Journal Transactions into Acumatica with the Rest API. Our transactions can have hundreds of line items, which would come over as Transaction Details. We first tried to do this within a single request. But we get this error when trying to push transactions with more than 10 details: ```[Acumatica] 414 Request-URI Too Long: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd"><HTML><HEAD><TITLE>Request URL Too Long</TITLE><META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD><BODY><h2>Request URL Too Long</h2><hr><p>HTTP Error 414. The request URL is too long.</p></BODY></HTML>``` We have since broken up the request into batches of 10. This also doesn’t work because the Journal Transaction wi

Hello,I am encountering an issue with the display of a foreign key in my Data Access Class (DAC) within Acumatica. Despite following the documentation and ensuring that the relationships and configurations are correctly set, the foreign key does not appear in the DAC UI.Brewery DAC :using System;using PX.Data;using PX.Data.ReferentialIntegrity.Attributes;using PX.Data.BQL.Fluent;namespace Assainissement{ [PXCacheName("Brewery")] public class Brewery : IBqlTable { [PXDBIdentity(IsKey = true)] public virtual int? BreweryID { get; set; } public abstract class breweryID : PX.Data.BQL.BqlInt.Field<breweryID> { } [PXDBString(50, IsUnicode = true)] [PXUIField(DisplayName = "Name")] public virtual string Name { get; set; } public abstract class name : PX.Data

I have added a new UDF field in the shipment screen, now I tried adding an workflow where it should not allow to confirm shipment without entering value in that UDF field but it not working. Can anyone help in doing this.

Hi All,The issue pertains to version 2021 R2 Build 21.212.0039.that we are using currently (planning to switch to version 2023 R2 Build 23.207.0025 next month)After completing a GI, we are facing the same issue of the Screen ID reverting back to 00000000 and disappearing from the saved list in their respective workspace (ReferNot only that, even the Save button for creating Filters is disabled. Because of the Screen ID reverting to 00000000, the GI is not available in the Access Rights screen. The error message reads "Sequence contains no elements”Does this issue persist in version 2023 R2 Build 23.207.0025?Any help/suggestion please? Manish

 Good morning all,Why is the kit line detail form always disabled,Can you help with setting this so that I can use the KIT LINE DETAIL FORMThanks

See question above This seems to be causing issues with closing SORs since we have all these comments & instructions showing on SOR as Requires Scheduling but they are marked as Complete on the underlying appointment.

Hello! Does anyone have any clients who accrue their PTO by anniversary date and not calendar date? How do you handle that? Thank you!

Has anyone figured out how you would make a manual entry to an employees PTO bank. For example, if the accrual was setup wrong, or the company decided to give them some extra time for whatever reason. I can’t figure out how I would adjust the time they have for that pto. 

We are reviewing switching from Big Commerce to Shopify.  We are stuggling with cost effectively customizing our Big Commerce store.  Is Shopify B2B a good solution that can be customized cost effectively? 

The report header section is displaying below the page header.Any ideas on how to correct this?It looks fine in the report designer window.  But when I actually run it they are in the wrong order.