Discussion Forums

Does anyone know if there is a way to create a calculated field in a pivot table GI within Acumatica? Am trying to sum totals sales / costs / margin and margin % by various objects.  My GI has each of these at the row level, but when summing in a pivot table, margin % is obviously not correct.  Pivot function seems to support % of row / column, but not % of a specific column (ideally would just sum margin / price for %margin). Any suggestions, greatly appreciated.Thanks,Dave

Hi everyone - Files downloads from community discussion posts are not currently working. It’s an escalated issue with Gainsight (community platform vendor). If you want to share information privately with another member, you could email the file directly. I will update this post when the issue has been resolved. Apologies for the inconvenience! 

We have a generic inquiry that lists blanket purchase orders information. Unlike Blanket SOs, Blanket POs do not have a Child Orders tab- making it tricky to track child POs tied to them.  SOOrder table has QtyOnOrders field, however POOrder table does not. How can I calculate Qty on Child POs and have it display on the GI?The GI is not line specific it is only header specific. When I added POLine table, it replicates all the information which is not required.The below snapshot is one from Blanket SO Gi, we would like to display something similar for the POs. How can we achieve this?@lauraj46 - any ideas from you would be helpful as well! Thank you in advance! 

When we look at our projects under cost budget under actuals it shows 0 for labor hours. Why is it not showing our actual hours? 

I have Kits that contain many common items. currently I stock them as their own SKU instead of being a Kit. the problem is that those components don’t necessarily show up as available to purchase by customers since they are contained in the “kit”. the reverse is true as well for my inventory, If I have all of the components of a Kit, The Kit will not show as available to purchase by customers.Has anyone run into this problem before, do you have any ideas for how to configure the stock items so that they are both visible?

Hello,       Still in 2021R2, I don’t know if latest version still having this issue.The datatime manipulating functions like DateDiff( 'd', [DateFrom],[DateTo]) can work perfectly when put in data field like below. But when you put it in styles, it would run with error “mismatch type”       It probably due to Acumatica did not handle it in style columns.Luckily, we can handle this ourself.  Like below:(DateDiff( 'd', CDate( Replace( [DateFrom],' 12:00:00 AM', '') ),CDate( Replace( [DateTo],' 12:00:00 AM', '') ))     Firstly, you have to replace the ' 12:00:00 AM' with empty, note, a space is in front of 12:00:00    Secondly, you use Cdate to forcely convert the type.Then, you can use Datediff function as usual, no errors anymore.

You may already be aware that when trying to style a GI column that contains a formula, you need to use an ugly version of the field name (something like this: INSiteStatus_FormulaB77428C87C3A4F5D9777A8999A0D8E43) that can be found in a variety of confusing ways. You may also need this ugly name if you are basing an Import / Export Scenario on a GI provider.I devised an easier way of finding this name by building a GI of GIs 😎Just choose your GI with the parameter and you’ll get a list of all the field’s ugly names: You are welcome to use it as well!

I am creating orders from a mobile application when they are sent to Acumatica and I want to complete the Shipment I get this error message:order does not contain any items planned for shipment on.Is it some field that I am not sending? Best regards,

Hello all,I have been trying to create a PO from SO. I have defined the following parameters:But the option to create PO is still inactive. What is it that I am missing here?

I need to display the dollar amount of Debit Adjustment(s) applied to a payment on the Check Remittance.  How would I do that or is there an existing report that shows this information that can be sent to a vendor.  This data is needed to inform the vendor why the payment is less than the invoice.

For Appointment screen (Screen ID: FS300200) we added two fields in details tab.This is working fine on web.I wants to add it it in mobile app (next to Target Equipment ID).I tried various code but none of this working (no error - new field not visible)update screen FS300200 { update container "Details"{ update group "TargetEquipmentGroup"{ update layout "EquipmentLine" { add field "UsrBuilding" { displayName = "Target Equipment Building" placeAfter field "TargetEquipmentID" } add field "UsrFloor" { displayName = "Target Equipment Floor" placeAfter field "TargetEquipmentID" } } } }}andupdate screen FS300200 { update container "Details"{ update group "TargetEquipmentGroup"{ add layout "EquipmentDetails" { displayName = "EquipmentDetails" layout = "Inline" add field "UsrBuilding" { displayName = "Target Equipment Building" } add field "UsrFloor" { displayName = "Target Equipment Floor" } } } }}FSAppointmentDet DAC extend for U

For AP Document Recognition, there’s a screen called “Delete Outdated Recognition Results”. Help documentation recommends periodically deleting records to save space, but doesn’t say how long records should be kept (if at all). I’m wondering if the historical records are used to improve future recognition results. Or does the machine learn without referencing historical results? Should I keep 6 months (for example) of history or delete everything up to the current date?Appreciate any insight!

When I extend business account into a customer, it adopts the numbering sequence of business account, instead of the next customer ID in sequence.  Is there a way to address this? 

I am trying to create an import scenario that will create purchase orders from production orders.  I need to have a separate PO for each production order.  

I have Items pertaining to Different Item Class which i need to use diff GL account while Issuing  Item . There is Already an Issue REASON CODE thats is getting used default whenever i make an Issue  . How to stop using reason Code and use COGS Account  from Posting class while Issuing the Item 

Hi Team,Assume we have a NGO which we are going to pitch Acumatica.. Since it is an NGO they are currently practicing projects and they are doing project budgets and all other related to project transactions. They are not raising any direct invoices from the order management module. Additionally they have the procurement process related to projects and administration transactions.I would like to know are we able to record the projects and revenue with using project module in Acumatica without purchasing the Order Management module in Acumatica..Appreciate if anyone can provide me an answer.Thanks/ Yashodha

Hi,If I use the Upload File button and choose an CSV, it gives an error saying “CA Error: This file format is not supported for the bank statement import. You must create an import scenario for this file extension prior uploading it.” since the button only allows some fixed file types but not SCV or excel.If I use the Load from file button, it requires mapping my bank file with the system fields and upload each and every time. I rather prefer creating an import scenario and use the Upload File button as instructs by the error message. Will this work If I create an import scenario for the import bank transactions screen? Do you have any samples/import scenarios done for this? Thank you,Dulanjana  

I’ve been asked to provide an estimate for a new customization.  I’ve done several advance things in Acumatica but this one I’m wondering if a) is this possible? and/or b) should it even be attempted?They want to use Matrix Items with 8 attributes in a template.   They want to be able to add cost/labor to each attribute value and have the price calculated during entry and saved directly to AR prices when item is createdAdd custom fields to Attribute values: Use these values to calculate a price during matrix entry: This does not look like traditional graph extension with overrides.  I’ve tracked down some code PX.Objects\IN\Matrix\GraphExtensions\HeaderAndAttributesExt.cs which looks like where the fieldupdating event is being hooked up to each attribute value but I can’t see a way to sub-class or extend this abstract class.I guess I’m at the point where I just need to hear if this is a fools errand and/or if there is some other possible way to accomplish this.  Customer does not want/

The quick question: Is there a list of the Transaction Type 3-character codes for inventory transactions (INTranDetail DAC) or, more generally, a way to view a field’s value before it is translated to the display version? As part of a larger Generic Inquiry that brings together a variety of inventory-related statistics, I am attempting to create a ‘Most Recent X Date’ column for several of the different transaction types, such as Most Recent Receipt Date and Most Recent Transfer Date. However, I am unable to filter to the desired transaction type in a formula without knowing the codes. [INTransfer.TranType] = 'Transfer' Doesn’t work, as the DAC Schema shows that the field is only 3 characters, but gives no list of what those codes are. I had to do something similar with Cross Reference codes and thankfully another post exposed a list of constants for those. I am also curious about how these smaller, stored values are transformed into the displayed values. It feels like I’m missing or f

We have a large landscaping client who is migrating from General Edition to Construction Edition. Implementation has been paused, however, because the client is disappointed in the lack of functionality of estimating. We are now vetting ISVs. ProEst is a possibility. RedTeam is only serving commercial contractors. Does anyone have any other suggestions for an ISV? One function our client needs is the ability to drop estimates into projects (not sales orders).

I am trying to add report to the Acumaca customer portal and having error as follows. Any help appreciated Server Error in '/AcumaticaERPPortal' Application.Error: You don't have enough rights on 'CR632072.rpx'.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: PX.Data.PXException: Error: You don't have enough rights on 'CR632072.rpx'.Source Error:  Line 317: }Line 318:Line 319: var pars = PXReportRedirectParameters.UnwrapParameters(passed);Line 320: passed = PXReportRedirectParameters.UnwrapSet(passed);Line 321: Source File: C:\Program Files\Acumatica ERP\AcumaticaERPPortal\Frames\ReportLauncher.aspx.cs    Line: 319Stack Trace:  [PXException: Error: You don't have enough rights on 'CR632072.rpx'.] Pages_ReportLauncher.viewer_ReportLoaded(Object sender, EventArgs e) in C:\Program Files\Acumatica ERP\Acu

We are trying to install the self service portal and cannot seem to do so on our instance.  It continually gives the error that it cannot copy the files if I try to name the instance “Portal”:Or it gives the error that it cannot find the files if I try to name it ANYTHING else even if I change the installation file path. If I create a brand new database and instance on this same server, all works fine. For a period of time it would not even run the configuration wizard.  This is on my self hosted NFR instance on Azure. We have a ticket open with Acumatica, but I thought I'd try here as well since we haven’t been able to make any headway.

I Create a new screen called material request note. I need to add a numbering sequence to its ref Number field.Firstly’ a numbering sequence was created as bellow.Then add a field to Inventory preferences and set its value to required numbering sequence ID // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active public class INSetupExt : PXCacheExtension<PX.Objects.IN.INSetup> { #region UsrCustomField [PXDBString(15, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Material Request Note Num Sequence", Required = true)] [PXSelector(typeof(Numbering.numberingID), DescriptionField = typeof(Numbering.descr))] public virtual string UsrMaterialRequestRefNbr{ get; set; } public abstract class usrMaterialRequestRefNbr: PX.Data.BQL.BqlString.Field<usrMaterialRequestRefNbr> { } #endregion } Finally, modify the  RefNbr field in the DAC as bellow. public class MRMaterialRequest : IBqlTabl

Customers are being alerted by FedEx that the development for the FedEx Web Services (SOAP) integration has been discontinued in preparation for its retirement.  FedEx is suggesting to modernize the integration by using the FedEx API (REST) solution.  Does Acumatica have a schedule for the conversion of the FedEx plugin to use the FedEx Rest API services?

I’ve created a sales order with one line and a production order by Rest-API. I would like to link these orders by API. PUTing "SOLineNbr", "SOOrderNbr", "SOOrderType" into production order object doesn’t work. These fields stay null. The other way i get an error: "An error occurred during processing of the field AMProdOrdID: A numbering sequence for the order type is not configured.." Which is wrong.Any ideas?