Discussion Forums

With all the hype around AI, particularly large language models (LLMs), you may be one of those people who had their mind blown by what questions ChatGPT (or something similar) was able to answer. And being the forward thinker you are, you thought “Surely this thing could answer some Acumatica questions.” You gave it a shot, and somehow you ended up here, reading about why (according to me) the shortcut you discovered might not be as cool as you thought. There are a couple fundamental problems with using LLMs in this context:  They are “smart” or rather, they sound smart. To someone who isn’t familiar with a topic, they sound like they really know what they’re talking about – like some people I know. Even if they really have no idea, they’ll take their best guess, but rather than tell you, “My best guess is ___,” they’ll just pretend they are completely sure. I don’t know about you, but if I’m getting a “My best guess is ___” answer, I’d like to be told that.  They are trained on publ

I am building an Export Scenario using data from the Invoices and Memos screen name.I am mapping the Post Period column from the Invoice Summary Source Object which contains an example value of  "082024"I would like to use the LEFT function to only extract the "08" value for Period. Can functions be used on the “Field / Action Name” column and if so, what is the syntax for the LEFT function on the Invoice Summary / Post Period field?I have tried the following, but none have worked. I receive errors from Missing Operand to Invalid Hdr when running my Export Scenario:=LEFT(FinPeriodID, 2)=LEFT([FinPeriodID], 2)=LEFT([Post Period], 2)  

Where do I add a new shipping location?  We have a drop down of choices to pick from when entering a new Purchase Request but I need to add a new location to this list and cannot find where to do so.

Hi Acumatica People, I mostly create import scenarios from SQL data providers (better handling of data types and “one and done”). For my equipment import scenario, for the SQL data provider, I have no errors and one record loads (out of a set of 12). I looked over the trace records and no handling of an error. Next, I exported the set of records and created an Excel data provider and a new import scenario with the same mapping and attempt to execute an import scenario.Now, it throws an error: “Error, “Customer” cannot be empty.” I am exporting my Excel scenario and I’ll provide some screenshots. 

Dear All,            Upgrade 2023 R2 Version I getting this error while run report, anyone can help to solve this issue 

When i am selecting the Check boxes in Select Change Request Dialog box the following error has occured. Error: The change request cannot be added to a change order because not all the project budget key attributes are specified on the Estimation tab (Revenue Task, Revenue Account Group) and the Markups tab (Account Group, Project Task) of the change request. 

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