Discussion Forums

I am building an Export scenario based on Invoices and Memos.I am able to successfully select and include the Item Description field in my export. I would like to use a LEFT() function to select only the left 40 characters, but I am struggling to figure out the DAC prefix for this field or I do not have the proper syntax.When I look at the SYMappingField, it shows me that the “Object” name is Transactions, but when I add that to my function, it does not validate.What is the best way to determine a field’s DAC ?OR, am I having a syntax issue?=Left( [Transactions.InventoryID!Descr], 40)  

what is the replacement for this Graph WarehouseManagementSystemGraph in 2024 R1 ?

Hello,Has anyone been able to customize the font used in the dashboards ?

 What is the problem with my code all the other with ewt is already not shown but still there is one that is showing i already fix this hahhahaha  =IIf(InStr(Trim([GLTran.TranDesc]), 'EWT') > 0 OR [GLTran.TranDesc] = 'EWT FOR 4TH QTR 2022_DAP' ,'', [GLTran.CreditAmt] - [GLTran.DebitAmt]) 

We have almost 100,000 parts and are going to retire about 30,000. I was hoping folks who may have done this type of thing might be willing to share some of their experiences accomplishing this. Some of the questions I have arewhat reports did you use to quickly identify parts with no “movement” since XX/XX/XXXX? What methods did you use to retire a part? Did you just set it to inactive? 

I have a Generic Inquiry for tracking Blanket sales orders but I need to add a function to it that allows me to track schedule compliance for the contracts in the GI. we have the start and expiration dates that I need to draw from as well as the order quantity plus unshipped order quantity. what I need is the Unshipped order quantity to be tracked in relation to the remaining months in the order.so for example in an order of 11,200 units over the course of 12 months needs to show that a minimum of 933.33 units are being shipped per month, if you get to 2 months and the total shipped is not equal to or greater than the order quantity total divided by the number of months between start and expiration date it should show it as being out of compliance.now I know this is very complicated and I am unsure if it is even possible to track this data using a GI and/or dashboard.I attached the XML of the report as well.

Wanted to make the community aware of a somewhat rare occurrence but meaningful.  We had an infrequent occurrence by our engineering team of naming a Component BOM in the Materials of a higher level BOM.  When this Component BOM was archived but NOT removed from the higher level BOM and demand elements drove the need to generate a production order, the entire MRP (inventory planning) job failed with an error “Inventory Planning Error…...specifies the BOM details…..The given key was not present in the dictionary.” In other conditions when a BOM is archived at the top level (Finished Good), MRP will complete the run and recommend a production order.  If executed, the production order will have no BOM ID in it (and thus no production content).  We have flags to identify this error.   I’m just surprised the entire MRP job fails. This seems like a problem; I’d rather the job complete with errors.  Fairly random occurrence but seems like something that should g

I am looking to implement Late Costs - costs that come in and need to be charged against a sales order often after the SO is completely closed out. Some examples of Late Costs would be Use Tax, an incoming freight charge, storage fees, credit card charges that are incurred in the field and not realized until after the SO is closed, and if we have a vendor bill that we want to reflect some or all its value to a Sales Order or specific sales order lines but the sales order line for it may already be closed (invoiced)Attached is a document that outlines the overview. Have you done this or know somewhere it has been implemented successfully?  

Why does display error in my report =ReportUDF.AmountToWords(CStr(IIf([ARPayment.CuryOrigDocAmt] <> 0,[ARPayment.CuryOrigDocAmt], '')), '')error says Invalid field name ReportUDF has been specified.other solution to convert amount to words? 

Hi Experts,Need your solution/advice on how to build a GI’s formula in Acumatica 23R1 to get base currency amount on Request’s field ([RQRequestLine.CuryEstExtCost]) or Requisition’s field ([RQRequisitionLine.CuryEstExtCost]) since the tables did not connect directly to CurrencyInfo and the transaction already closed.Relations schemaYour input are highly appreciated. Best Regards,Iko 

Hi everyoneCan someone gives us answers why the Request we made in Purchase Request Module(CST.RQ.30.10.00) cannot call/populate in the Create Requisition(CST.RQ.50.40.00) module?We are currently using Acumatica Cloud ERP 2023 R2 Build 23.211.0017 +The only Purchase Request transactions can be seen at Create Requisition(CST.RQ.50.40.00) module are dated transactions 2020Please see screenshot for your referenceAny insight will be appreciatedThank youGerbert  

Hi everyone,I'm having issue trying to configure an Import Scenario to delete all the sales prices with the same UOM.I have a huge list to delete and one by one its no efficient 

I’m adding a Tasks GI to menu which is used in a dashboard. When a task record is opened, I need it to redirect to entry screen and allow editing. The redirect is not working. Opening a task record just shows the GI fields, but it’s not the entry screen. Below is my code. If anyone could look at it and tell me what might be wrong I’d appreciate it!   

Hi there, I am facing an issue on installing Acumatica on local machine. The error message shown: The drive structure: I would appreciate it if anyone could point me to the right direction on this.

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is needed from every Community user; everyone can provide valuable input using their individual skills and interests.  When more people participate, all members benefit - - we need diverse backgrounds, cultures, experiences, opinions, values and perspectives. 

Good afternoon!We had a question about mass updating Purchase Order numbers for Invoices after they were created. We have this functionality due to a customization that I blogged about in 2021: https://www.acumatica.com/blog/vlog-changing-an-acumatica-po-number-with-a-smart-panel-and-custom-action/One of our staff said “Sure, we can write an Import Scenario off of that.” Well, it was not as easy as we thought. The smart panel is very basic. https://gist.github.com/kjrichardson/4ec5742fe1

My company has multiple warehouses.  I have added custom code in a SalesOrderEntry Extension to find the closest warehouse that has a requested item, if it isn’t available at the customer’s default warehouse.  If there isn’t enough inventory at any of our locations, a line is created to add the short quantity to the item default warehouse (where the item is manufactured).The code works if there is enough inventory to fill the item, but if there isn’t enough I get a line type error.  Our item classes are set to allow negative quantities.  I have manually entered the lines the way the code does it and it works manually.  In debug all fields are filled in, including line type.Example:Customer orders 200 widgets from location XInventory gets checked and 61 widgets are available in default warehouse YNew line is created for the 61 widgetsAnother new line is created for the remaining 139 widgetsOriginal line is deletedLine Type Error

I added the SOShippingAddress table with the Inner join type to the SOOrder parent table. this was done as I am making a copy of the report but one that tracks ship to address data for country, city and state. after doing so the report goes from loading in seconds to taking a minute or longer to load.is there a better way to do this join so it doesn’t take so long to run and parse data?  

Is there any way to turn off the "split" warehouse function on a sales order?  We use SA and SO when entering orders and this works the same in both entries.  This is very confusing, and our confirmations print out showing this line twice, which makes no sense.  It seems to split the line when there is stock in another warehouse/location.  I have flagged the warehouse to not "allow sales" and it still splits the line.  I have tried every function/flag possible (that I know of).  My other warehouses are not for resale, they are for instruments that we keep as samples for our internal reference only.  I do not want the system generating anything from our other two warehouses.  How can this be done?   Please see below example.  I would appreciate any input you can provide or if anyone handles inventory not for resale a different way in Acumatica. Hoping someone can help me understand this functionality better and provide a solution. Thank you!Maureen

Hello! I have an attribute field for call activities that is called the “CALLDURATION.” This field is alphanumeric, so I have a formula that converts it to integer when using aggregate functions. I need to calculate the total call duration of multiple call activities performed by each person and have it display in the result next to OwnerID, is there a way to calculate that in GI and what function/formula should I use?  This is the formula I use to convert the alphanumeric value to just calculate the number part.  In the Total Time Spent Column, I need a formula that would return the value of total call duration for each owner. ex: first row has made four calls, so Total Time Spent column should display the sum of all four calls made by first row owner. 

Hi,Wondering if anyone could help me with some code needed for the Inventory lookup attribute on Screen IN401000 so I can put in a lot/serial # and have the item come up as well. Default it just pulls by InventoryId of item.Or a easier way to do this?  Thanks so much everyone. Here is the default Attribute code. I need to add some code to be able to look up by Lot/Serial# as well. So you would put in a Lot/Serial# of a Inventory item[AnyInventory(typeof(Search<InventoryItem.inventoryID, Where<InventoryItem.stkItem, NotEqual<boolFalse>, And<Where<Match<Current<AccessInfo.userName>>>>>>),typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr),Required = true)]

I am attempting to create a kit BOM GI to send to our warehouse. Our warehouses uses our products alternate ID (in this case ISBN) to identify our products. Is there a way to return the alternate ID for the kit header as well as each of the components? Thanks,​​​​​

I created an action button to create a service order from the customer screen. The customization works great. The only problem is the Address Lookup seemed to stop working. Any Idea what may be causing this?using PX.Data;using PX.Objects.CR;using PX.Objects.FS;using System.Collections;using PX.SM;namespace PX.Objects.AR{ public class CustomerMaint_Extension : PXGraphExtension<PX.Objects.AR.CustomerMaint> { public class CustomerServiceOrderDac : IBqlTable{ [PXString(4, IsFixed = true, InputMask = ">AAAA")] [PXUIField(DisplayName = "Service Order Type", Required = true)] [PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)] [FSSelectorActiveSrvOrdType] public virtual string ServiceOrderType{ get; set; } public abstract class serviceOrderTyp

Hi all, I am creating a Production order using a configuration, I don’t have default warehouse nominated on my configuration lines. instead I am expecting the default issue warehouse on stock item or on item warehouse detail takes precedence of which warehouse the item should be issued from. by the look of the behavior it picks the warehouse attached to the work center instead. why is it behaving like this? we can’t ask a customer to override every line ! configurator setup item warehouse detail setup stock item setup the way it

for acumatica development, i am using a macbook (m3) running Windows 11 (ARM) VM.  on the windows VM, i’ve installed Acumatica and Visual Studio 2022 (ARM 64-bit).   i am able to build DLL’s with custom code and run Acumatica on the VM.  However, i am unable to install Acuminator.  when i download the 3.1.3 from the vstudio marketplace and attempt to install it, i get the message, “This extension is not installable on any current installed products.”are there any plans to provide an ARM-compatible version of the Acuminator, or does anyone have any workarounds for this issue?thanks   jim