Solved

I want to show the description of a stock item in a column of another screen. But when I was trying to set it in the normal way, it just gives the html code(see the below screenshot),not the actual description sentences. Following is the code that I tried, InventoryItem item = new PXSelect<InventoryItem, Where<InventoryItem.inventoryID,     Equal<Required<InventoryItem.inventoryID>>>>(Base).Select(row.InventoryID);            if(item != null)            {                rowExt.UsrItemDescription = item.Body;            } How can I show the actual description of that item in my custom column instead of showing html code.Any help?

I am trying to press RemoveFromHold button on APInvoiceEntry from a Generic Graph Extension but I’m receiving the below error. Can someone help please? The error is “System.Data.SqlClient.SqlException: 'Invalid object name 'PXMappedCacheExtension'.'” For the sake of claification, when I press this button from inside the APInvoiceEntry Extension it works. But since this is repeating for 7 screens, I’m converting some of the logics of these extensions to GGE to prevent from repeating.  

Good day,I have the attached GI created.  I am unable to show for “on-hold” check/payments the unapplied amount for these transactions.  I check that correct column/field is curyUnappliedBal based on the inspection tool.Any ideas why the unapplied balance field is empty.  I have a number records on-hold that have an unapplied balance.Please advise on if this my issue or an ACM issue.Thank youEvan

Any one ever convert the [AMProdOper.RunUnitTime]  into minutes for a GI? 

I am trying to add an Action to the top of my custom form, but I cannot get it to show.In the screen editor, it shows the actionMy goal is to run a process when the action is clicked.Here is my graph:namespace QTCAuditReporting{ public class QTCAuditReportV3 : PXGraph<QTCAuditReportV3> { public PXFilter<QTCAuditHistoryReportFilter> Filter; public SelectFrom<QTCAuditHistoryReportView>.View RecordsToAdd; public SelectFrom<QTCAuditHistoryParameters>.View Parameters; [Serializable] [PXHidden] public class QTCAuditHistoryReportFilter : IBqlTable { #region ScreenID [PXString(8, IsFixed = true, InputMask = "")] [PXDefault] [PXUIField(DisplayName = "Screen ID", Required = true)] [PXSelector(typeof(Search5<AUAuditTable.screenID, InnerJoin<SiteMap, On<SiteMap.screenID, Equal<AUAuditTable.screenID>>>, Where<AUAuditTable.isActive, Equal<True>>, Aggregate<GroupBy<AUAuditTable.screenID>>>), typeof(AU

I have a modified Shipment Confirmation report SO642000 that is printing a extra blank page.I am unable to find the causeCould someone take a quick look ?

Hi All,I have created a new generic inquiry, I  joined  tables and I want to show project ID in one column. But currently I only can show 2 columns, because project ID appears in 2 screens ( Invoice & Memos) and (Payment & Application) I have tried  to use iff function for ar invoice, if project id is null, it’s will show project ID in payment, but it’s not work.  Pls help me if you have any idea to show project ID in one column.Thanks in advanced.   

Hi all,Has anyone seen this error? Thank you,KT  

What are best practices for closing financial periods? I went to “processes » close financial periods”  but  we were able to still post in 2021.  Having an issue with too many transaction still slipping through the cracks in periods that need to be closed and just wondering what a best practice is to cut this off? 

Hello,Our customer imports employee credit card purchases from a corporate credit card vendor into the AP Bill screen.  Each purchase/expense line needs to be imported with a Project, a Service Order Number, or project X with a GL expense account.I’m struggling to Link the Service Order Lines to their respective Service Orders.  I see the fields I need in the Details tab, but they are not editable when manually typing in a Bill.  The AP Bill Help indicates these field should be editable.  What am I missing? I tried the “Link Line” button too, but nothing happens: Link Line only works for POs, PO Receipts, and Landed Cost (not Service Orders).If I create the AP Bill from the Service Order, Details tab, then the two highlighted AP Bill fields above are populated with the Service Order Type and Service Order number.  However, we do not want to open many Service Orders and manually create many individual AP Bills. We want to import and link from the AP Bill screen to existing Service Order

I need to look for a sales order that MAY exist or MAY NOT exist in an import scenario and the order may be accessed multiple times across different imports. If the order doesn’t exist, I need the import to start a new order.The import file has a customer reference number. This is a unique field and is my index to look for. If no match is found, I need a new order created. I thought the following commands were what I needed (ignore the highlighted line, it’s not active):   I get two types of errors: If the commit box is checked on the line:Order Nbr → Customer Order NbrWhen I run the import: I get the first row to process, everything says success, but all rows are skipped except the first row. In my 5 rows of test data the PurchaseOrderNumber field alternates between Test1 and Test2. So if I run it, I get a new order with Test1 and ONE item on it (should have 3). The two rows of Test2 get ignored as do the other Test1 Rows. If I run it AGAIN, a new Sales Line is added to the order with

Hi All,I need to join more table in Inventory transaction summary screen ( CST.IN.40.60.00), in particular InventoryItem and CSAnswers table, but in  CST.IN.40.60.00 screen dont have GI, so I dont know how to join table.  Pls advice me if you have any idea.Thank you in advanced.

Browsing the Forums, it seems many people have Easypost working with Acumatica to generate their Customs Documentation automatically from Acumatica.  I’ve installed the Easypost customization and have Fedex and UPS working, but I can’t determine which fields on the shipment I’m supposed to enter the required Customs information (Commodity type, Customs Value, Harmonized Code, etc.) to generate the commercial Invoice.It seems easy enough to create the Customs Object for the Easypost API, but I can’t find any documentation on the Easypost customization project (that I believe Acumatica maintains) that shows what fields map to what.  The project does add some extra fields to the shipment.   thanks!

Hi all,I want to bring project ID in Customer details GIIf I dont use the formular it shows the project ID in text. But if I use Isnull formular it shows the result in INT, the formular I use is “ =IsNull([ARInvoice.ProjectID], [ARPayment.ProjectID] )”Does any one know the reason why when using isnull formular the result is different. My aim is bringing project ID from Arinvoice & ARpayment table into 1 column. Thanks in advance!

When sending a quote to a customer is it possible to have the email sent from the owner of the quote?I know you can do this by clicking ‘print’, then sending the email from the this screen and changing the ‘from’ email, but is it possible to set this as standard for when you click ‘send’ from the actions menu?Thank you

Hello,We have multiple warehouses each of which is managed by a different user.****We want to limit the users at each warehouse to only see and alter data for their individual warehouse.****I created a restriction group for warehouse 100 and assigned a user to this.My expectation was that they would not be able to see or do anything in the system for anything other than their assigned warehouse.However, as a test, I logged in as the restricted user and was able to alter sales orders lines assigned to other warehouses.Have I set something up wrong or are my expectations out of line with what restriction groups do?Again, I am attempting to limit a user to warehouse 100 only for every screen in Acumatica for user 3PL.Only warehouse 100 is checked in the images below. 

In attempting to import discounts with a Discount Type of “Line” and Applicable to “Customer Price Class and Item Price Class” I’m unable to get the import scenario to create separate sequences for all my combinations (i.e. Customer Price Class = 1, Item Price Class = ABC, and a single Break Point of 0 with a specific discount percentage).  Each row of my source file contains just those three values.  I’m hard-coding the Discount Code and hardcoding ‘<NEW>’ for the Sequence.  If I activate 1 row at a time and import it, I get the desired result, which is a new sequence number for each row of my source file.  But if I activate all rows in the Import by Scenario screen, the all import into a single discount sequence record.  I’ll attach the Import job if anyone could take a look, but I’m guessing I’m missing something basic.  Thanks for any help!

Where can I see our Acumatica “usage”.  My understanding is our Acumatica license cost is based on usage.  So, I want to monitor our usage so I can compare  our usage to what our license allows or what we are paying for.  Thank you for any help you may give us. 

Hello,We have a quote with material on the operations.  We want to update all of the material costs used on the quote with the current material’s costs.  There does not seem to be a button or anything that says “update costs” or “refresh costs”.  It seems the only option is to manually research the current costs and manually enter them, or delete the material and re-add it to the quote. Am I missing something?  (Probably a big red button in the middle of the screen I am not seeing!) 

Is there anyway when setting parameters for ROP to NOT include production orders?  For purchased component parts, I do not want the calculation to include production orders as that qty should be “allocated” to that production order, therefore shouldn’t count as available inventory.

We would like to have a sales order type such that when selected to start a new sales order the ship-to address and ship-via for pickup will always be the same address/SHIPVIA and override the customer’s and/or customer class ship-to address/SHIPVIA.  Is this possible?

I mentioned a problem that we were having in crediting and reinvoicing a service order in another thread, and then I discovered that this was the problem.We have restricted all users access to cancel invoices (we have specific users who need to create credit memos in specific ways, so we don’t want them to use this shortcut).  As a result of this, the ability to “Add Return Line” has also automatically been restricted.  See below.  The orange should be restricted, the green should be allowed:@Anacarina Calvo  you mentioned that I should log a case to see why the “Add Return Line” was not allowed, would you agree that the Cancel Invoice access should not affect the “Add Return Line” access?  These are two separate functionalities in my opinion. 

We issue some POs in which we will physically pick up the goods. Is there a way to change the Ship To details on the Shipping tab of a PO to reflect a Pick Up rather than a shipment?  

We have several different warehouses that we stock our component parts depending on which building they are consumed at.  I am trying to set a different ROP for each warehouse.  When I go into stock items and add the other warehouse, I am getting the following message: Error: Another process had added the “INItemRep” record.  Your changes will be lost. In Acumatica can you have different ROP’s for multiple warehouses?   

hi, i’m sure i’m just not doing this correctly but i have some conditions in place and would not like to show cancelled or invoiced sales orders. however the cancelled is coming up for this customer. does anyone know what i am doing wrong?