Solved

Hi Everyone, We are planning of creating custom field in our Bigcommerce and Acumatica as a Job tag for each sales order line of the Blanket sales order. Is it possible to use it in creating child orders based on that custom field? Thank you.

Hello,I have a sub report I am adding to a standard report.What is the font and size used on the standard reports so I can match it and make this look better?I don’t see this specific information on the properties of the fields on the standard reports.Thanks,Larry

Hello,I need to make my subreport have a border so it appears as a box on the main report.It seems pretty straightforward.In the Designer Window, the border shows as expected.However, when I print the report there is no border around the subreport. 

Is there functionality that allows for paperless traveler in Acumatica?

I am creating a GI that combines the SOOrder and SOLine tables.  When I use the SOOrder.OrderNbr field as a parameter, the magnifying glass to search the Order Numbers does not show any of the sales orders.  I am able to type in an Order Number in the parameter and the inquiry works but I would like to have the search functionality work properly.  Is there another table that needs to be added into the GI to make the searching work? 

Hi ,I tried Create a Tenant with the U100 Dataset, when i tried import snapshot has error message below.  Does anyone have any advice, thank you

Sorry I should have inspected the response, it contains an element `expires_in` which is 3600 seconds

In trying to Export an ACH payment using FEDWIRE Payment Method, I am receiving the following error:  - Acumatica Cloud ERP 2021 R2 Build 21.214.0034   TRACE: Error:    Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index     SendRaised At: 10/13/2022 12:46:07 AM    Screen: AP.30.50.00         Details:10/13/2022 12:46:07 AM Error:Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)   at PX.DataSync.ACHSYProvider.Export(String objectName, PXSYTable table, Boolean breakOnError, Action`1 callback)   at PX.Api.SyMappingUtils.WritePreparedDataToProvider(SYProcess graph, SYMapping mapping, SYImportOperation operation, PXSYTable preparedData)   at PX.Api.SyMappingUtils.ImportData(SYProcess graph, SYMappingActive mapping, SYImportOperation operation, SYMappingActive updated)

Good day,One day, I wish these errors were more specific.  I have an BAccount identification error on the attached import scenario.  it seems straightforward; update the general information; credit terms, currency Id and the salesperson for the Main location.  Does not seem to work.  it worked for one record.Any assistance would be greatly appreciated.Thank you@Evan G 

We have been using the “Fetch” and then “Sync” method in “Commerce / Processes”.  Using this approach we were finding that hundred of items would show as “Pending” even after we Fetched and Synced.  We were told to change our procedure and first “Fetch” in Processes, and then sync using the “Sync Status” process ( and not the “Sync” in the Processes area).  Is this method the prefered way sync?  Should we stop using the “Sync” button in the “Commerce / Processes” area?  

 Try to update Screen Appointment List to add addressline1 shows error after publish in mobile update screen FS400100 { update container "Appointments" {     fieldsToShow = 9     add field "SettingsAddress#AddressLine1"{    displayName = "Address"    selectorDisplayFormat = KeyDescription   listDisplayFormat = CaptionValue   forceIsVisible = True   }       } }

Hey everyone, Does anyone know why the Delete/Add SalesPerson on the order is grayed out?I’ve tried to look everywhere for ways to change it but I failed :( I’ve tried it with an Admin account with full access and the issue persisted regardless if the order is Open or on HoldIf you guys know how to enable this, it will be much appreciated.

Hello - I am trying to add this Financial Period Parameter to my Dashboard, but the Widgets do not appear to be updating based on the month selected. Is there something more I need to do to my GI or filter settings on the Widget? Below is how I added my Fin Period:  

{ 'client_id': "xxxxxxx@company", 'client_secret': "xxxxxxxxxx", 'grant_type': 'client_credentials', # 'grant_type': 'password', 'scope': "api", 'username': 'xxxx', 'password': 'xxxx',}This is the body I am sending, but I am getting `{'error': 'unauthorized_client'}` what am I missing?Secondly, the documentation says the grant_type must set to `password`, but if I do that, I get `invalid_grant`

Hello,I searched for this and couldn’t seem to find an exact hit.I’d like to duplicate the ‘default Sales Person’ from the Commissions tab on the sales order to the Header so that Sales Reps can see, overtly, who is being defaulted (and change it if necessary) at the header level instead of the Commissions tab.Is this achievable?Cheers,k2

What is the maximum number of Fixed Assets that can be entered in Acumatica?

Hello,I believe the below code should always disable the BasePrice field on the IN202000->PriceCost tab. But it does not.   public class NonStockItemMaint_Extension : PXGraphExtension<PX.Objects.IN.NonStockItemMaint> { #region Event Handlers protected virtual void _(Events.RowSelected < InventoryItem> e) { if (e.Row is InventoryItem row) { PXUIFieldAttribute.SetEnabled<InventoryItemCurySettings.basePrice>(e.Cache, row, false); } } } 

Hi,  Once we close and open the project balances. This Raw material values is not showing in project Level.There are Few questions. (01). What are the double entries, when Raw material(Stock Items) transfer to Project site?(02). Why Those work order Stock Items(Raw Material) transfer to Project?  

I have a field in a custom DAC and I created a SQL constraint to ensure it is unique.    [FromCustomerID] [int] NOT NULL UNIQUE,Is there a way I can setup this DAC field to enforce this constraint so that it doesn’t require the DB to be hit prior to identifying the value entered in a grid is invalid?This is my DAC field:        #region FromCustomerID        [Customer(IsKey = true)]        [PXUIField(DisplayName = "From Customer")]        [PXRestrictor(typeof(Where<BAccount.parentBAccountID, IsNull>), ICSMessages.ChildAccount)]        public virtual int? FromCustomerID { get; set; }        public abstract class fromCustomerID : PX.Data.BQL.BqlInt.Field<fromCustomerID> { }        #endregion

A customer has asked what the “Parent” field is for on the Tasks screen:I have searched through the documentation and can’t seem to find where that field is defined.Can anyone help?Thanks!

Hello,Trying to update the Lead Source Dropdown with a few additional options.I would think the two following classes would work, but I do not get any UI changes. I think I am missing something simple. public class CRLead_Existing : PXCacheExtension<PX.Objects.CR.CRLead> { public static bool IsActive() => (true); #region Source [PXRemoveBaseAttribute(typeof(CRMSourcesAttribute))] [PXMergeAttributes(Method = MergeMethod.Append)] [PXDBString(1, IsFixed = true)] [GPLeadSource] public string Source { get; set; } #endregion }  public class GPLeadSourceAttribute : CRMSourcesAttribute { public const string Email = "E"; public const string Text = "T"; public GPLeadSourceAttribute() { Array.Resize(ref _AllowedValues, _AllowedValues.Length +2); _AllowedValues[_AllowedValues.Length - 2] = Email; _AllowedValues[_AllowedValues.Length - 1] = Text;

We are getting this error doing any search on all tenants on the server and if you hit Transactions and Profiles tab or Help Topics tab we get an error. works on Menu items and Files. No matter what we Search

Using versions 2021 R2I am creating an AP Register for a custom process. I altered the AP Register to remove unneeded fields. Then added the AP Tran Table so that I can add the account and Subaccount.  It is however reporting two lines and the second line contains incorrect account and subaccount.  I know it likely has something to do with the join but I cannot figure out what elements I need to use to get this correct. I could not add the .rpx file, so here are some screenshots. 

Hi,Is there any possibility to link an already created AR invoice to a sales order, without creating AR invoice through sales order. Thanks,Dulanjana

We have a P&L report in Acumatica where we have a column that calculates the percent of budget used. This column works for all lines except totals that add/subtract more than one line. The only reason I could suspect this is happening is because the system runs the line calculation after the column? I’m not entirely sure. I have tried creating an additional line that points at the total line but unfortunately it still does not calculate. Any thoughts?