Skip to main content

Discussion Forums

Get inspired and gain all the knowledge you need

16302 Topics
A
Varsity I
ashleybVarsity I
asked in Financials
How to add Period Parameter to Dashboard

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:  

1151
BenjaminCrisman
Acumatica Employee
2 years ago
J
Jr Varsity I
jameslJr Varsity I
asked in Develop Integrations with Web Services | APIs
unauthorized_client when getting token using resource owner password credentials flow

{ '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`

5672
J
Jr Varsity I
2 years ago
K2a
Jr Varsity III
K2aJr Varsity III
asked in Distribution
Duplicate Field to Header

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

641
Dioris Aguilar
Jr Varsity I
2 years ago
J
Freshman I
JRygielski77Freshman I
asked in Financials
Maximum number of Fixed Assets

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

432
J
Freshman I
2 years ago
L
Varsity I
LeifVarsity I
asked in Develop Customizations
Trouble Disabling Field from RowSelected Event

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); } } } 

2586
Fernando Amadoz
Jr Varsity I
2 years ago
D
Freshman I
david7Freshman I
asked in ISV Solutions
Sendgrid Tracking with Bulk Emails

We want to use the SendGrid integration to track opens, clicks, etc. for emails from Acumatica. This includes emails sent: From the Mass Emails screen.  Through Notifications, e.g. sales order notifications, invoice notifications, etc. I configured a system email account to integrate with SendGrid and set it to track opens, etc. by default. When I create an individual email from a business account, those settings populate through to the email, but when I created emails via the mass emails screen and the Print Statements screen, the settings to track opens and clicks (“Track Email Opens” and “Track Clicks in Email”) were not checked on the email activity. Do we need to do something more with our configuration, or does the SendGrid tracking not work for mass emails and notifications?

5289
A
Freshman I
2 years ago
NAthukorala47
Jr Varsity III
NAthukorala47Jr Varsity III
asked in Construction
Work Order Material Cost Not transferring to Project.

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?  

703
Heidi Dempsey
Community Manager
2 years ago
Joe Schmucker
Captain II
Joe SchmuckerCaptain II
asked in Develop Customizations
UNIQUE constraint on DAC column

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

1362
Joe Schmucker
Captain II
2 years ago
simonliang91
Acumatica Employee
simonliang91Acumatica Employee
posted in Retail
How-To: Update external shipping info during Order Import Using Shopify Connector

The current Acumatica Shopify Connector doesn’t process the shipping information during Sales Order Import. But in some cases, Shopify Order will be fulfilled by other 3rd party service, and you want to import the shipping information into Acumatica Order if the order has been fulfilled. This request can be resolved by using customization project:namespace PX.Commerce.Shopify{ public class SPSalesOrderProcessor_Extension : PXGraphExtension<SPSalesOrderProcessor> { public delegate void SaveBucketImportDelegate(SPSalesOrderBucket bucket, IMappedEntity existing, String operation); [PXOverride] public virtual void SaveBucketImport(SPSalesOrderBucket bucket, IMappedEntity existing, String operation, SaveBucketImportDelegate baseMethod) { //Local is the API Object from Acumatica SalesOrder localOrder = bucket.Order.Local; //Extern is the API Object from Shopify OrderData externOrder = bucket.Order.Extern; //You can check FulfillmentStatus and Fulfillments object to ensure

2361
apretorius62
Freshman I
2 years ago
D
Varsity I
donnadeskins55Varsity I
asked in Everything Else
Parent field on the task screen

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!

472
Kandy Beatty
Captain II
2 years ago
L
Varsity I
LeifVarsity I
asked in Develop Customizations
Trouble Appending Dropdown Values

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;

1233
L
Varsity I
2 years ago
M
Freshman II
mgrovergeigerFreshman II
asked in Everything Else
Error Message - {"Message":"An error has occurred."}

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

4073
Manikanta Dhulipudi
Captain II
2 years ago
B
Freshman I
bdobsonFreshman I
asked in Reports and Generic Inquires
Altering the AP Register Report- Duplicate Lines

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. 

622
BenjaminCrisman
Acumatica Employee
2 years ago
D
Jr Varsity III
dsenevirathne54Jr Varsity III
asked in Distribution
Link invoices to Sales Orders

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

931
Manikanta Dhulipudi
Captain II
2 years ago
R
Freshman II
rebeckamckinney53Freshman II
asked in Financials
ARM Report Column Calculation not applying to Total Rows

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? 

5245
M
Freshman II
2 years ago
Joe Schmucker
Captain II
Joe SchmuckerCaptain II
asked in Develop Customizations
PXProcessing dialog shows Remaining until all records are processed

I have a processing page to “mass delete” empty customer records.  On the processing dialog, it shows the Remaining count as the total count of the records being processed until ALL items have been completed.  Then, the Processed count shows all 3 items processed successfully after they are ALL complete.I’m being a bit picky here, but I want the Processed count incremented and the Remaining count decremented after each record is processed.When you click the PROCESS ALL button, this is where it starts out After processing is complete for all 3 records, it shows this: This is an example of my code: public static void DoIt(List<ICSMCCustomersToProcess> custList, bool? deleteCustomer) { foreach (ICSMCCustomersToProcess cust in custList) { try { bool? customerNotDeleted; string errorMessage; var graph = PXGraph.CreateInstance<DeleteCustomers>(); graph.Clear(); graph.DeleteCustomer(cust, out customerNotDeleted, out errorMessage, deleteCustomer, tru

1864
Joe Schmucker
Captain II
2 years ago
C
Semi-Pro I
ChandraMSemi-Pro I
asked in Develop Customizations
Capturing Business card details - Do we need to have this Feature licensed for adding the feature?

To capture the business card details through the Mobile Apps, do we need to have the feature added to the license? 

1173
C
Semi-Pro I
2 years ago
S
Freshman I
scalhoon40Freshman I
asked in Financials
Setting Shipping Address on a Purchase Order

Our client has a specific requirement to set the Shipping Address to the Branch Address for Purchase Orders that are of the Type = Project Drop Ship.  Currently, users are manually overriding the Ship To Address for these types of Orders and they have asked us to code it such that if the type of the Purchase Order is Project Drop Ship, then to set the Ship To Address equal to the Branch Address from the OTHER tab of the PO.  The following code does what we need it do; however, upon clicking save an error is generated.  The error is:Error: Inserting ‘PO Shipping Address’ record raised at least one error.  Please review the errors.  Error: ‘RevisionID’ cannot be empty.The following code does what it needs to do, but for the error when saving:protected void POOrder_ProjectID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler){  if(InvokeBaseHandler != null)    InvokeBaseHandler(cache, e);  var row = (POOrder)e.Row;  var po_branchID = row.BranchID;  var

3203
S
Freshman I
2 years ago
K
Jr Varsity III
ketillerJr Varsity III
asked in Financials
DAC - ARRegisterAlias Access

Hi,  I was wondering if it’s possible to access the DAC “ARRegiserAlias”. I can preview the Source Data but cannot access the table when creating a GI.  Thank you,KT

1006
K
Jr Varsity III
2 years ago
R
Freshman II
rebeckamckinney53Freshman II
asked in Reports and Generic Inquires
Generating multiple reports and Exporting to PDF

One of our clients wishes to mass create different versions of the same report in Acumatica, and then have those versions saved in pdf format on their local machine. For example, under Bank Rec, they would like the Reconciliation Statement report to be able to generate the last reconciliation statement for each bank account and then have that file saved to a pdf to their workstation. I did some review and I’m not sure if this is possible without some type of customization. The automation schedules seem to be more focused towards posting transactions than creating reports. Any ideas or 3rd parties that anyone knows that could do this?

3666
R
Freshman II
2 years ago
C
Jr Varsity II
ckwiat46Jr Varsity II
asked in Configuration and Installation
Need help in creating snapshot

Hello, recently we upgraded from 2020 R2 Build 20.208.0031 to 2022 R1 Build 22.109.0023, so in this process we had some custom tables with fields without USR prefix, so we created new fields with USR prefix and published the package, we are able to successfully overcome that issue, we actually followed this link https://www.sprinterra.com/blog/users-fields-in-acumatica-erp-blog-sprinterra/. Now when we are  trying to create snapshot we are getting “An error occurred while importing data into the 'AuditHistory' table.” error.Please have a look at below trace. Error:    An error occurred while importing data into the 'AuditHistory' table.     SendRaised At: 10/1/2022 2:02:14 AM    Screen: SM.20.35.20         Details:10/1/2022 2:02:14 AM Error:An error occurred while importing data into the 'AuditHistory' table.System.IO.IOException: Stream was too long.   at System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count)   at System.IO.BufferedStream.Flush()   at PX.DbServices.Poi

7464
Manikanta Dhulipudi
Captain II
2 years ago
A
Freshman II
aaronthomas82Freshman II
asked in Reports and Generic Inquires
Sales Order Invoice profit margin

Is there a way to view profit margin on a per sales order invoice?  It seems Acumatica generate 2 distinct transactions upon release.  1) record the AR/sales side of the transaction 2) the Inventory/COGS side of the transaction.  Any way to put these two together on 1 report?Thanks,

4273
Kandy Beatty
Captain II
2 years ago
C
Varsity I
charithalakshan49Varsity I
asked in Reports and Generic Inquires
How to show headers of a sub report in main report?

I want to show headers of a sub report which placed inside detailSection1 of the main report. Any idea about this? Thanks

1775
L
Captain II
2 years ago
Connor Morse
Jr Varsity III
Connor MorseJr Varsity III
asked in Develop Customizations
Manually enter Allocation Amounts for Landed Cost

We are looking to manually enter (ideally import/upload) allocation amounts for a Landed Cost entry. Does anyone know if this is possible?We have been unable to identify a method to enable the field through a Customization Project, or utilize an import scenario to bring in the externally calculated allocation amounts.  

1835
S
Freshman I
2 years ago
J
Freshman I
jcox43Freshman I
asked in Financials
Trial balance inventory accounts not at $0 after removing inventory

I’m working on converting our costing method and testing the results in a test system, but I’m running into interesting results. So I’m looking for some recommendations on what we should do or what could be causing these issues?I have issued out 100% of our inventory so that our inventory balance and valuation are 0 on both reports. But our trial balance is showing values in multiple inventory accounts.I have closed/cancelled out all production orders that were in a  “In Process” status. I would expect this to bring all WIP accounts to $0, but again multiple accounts are showing values in there. Since I believe all of these accounts should be at $0 now should I clean these up and bring them down to $0 or am I missing something? I can’t tell exactly when these accounts stopped matching and I’m wondering if they were never tied out correctly from our go live.  Thanks for any help.

721
Laura02
Captain II
2 years ago

Badge winners

Show all badges
Terms & ConditionsCookie settings