Solved

I am currently trying to make a PositivePay compliant output from a Generic Inquiry. I am attempting to remove all comma, dash, decimal, and non-numeric characters from all numeric fields. So I would like date to be 010924 as an example. I see that my question has been answered here:  However when I apply the below code to the Style field of APPayment.DocDate it has 0 effect on the output. I notice this solution was posted a year ago and I wonder if there has been some sort of update between then and now which has changed the approach?=Concat(IIf(Month([APPayment.DocDate]) < 10, '0'+CStr(Month([APPayment.DocDate])), CStr(Month([APPayment.DocDate]))) + IIf(Day([APPayment.DocDate]) < 10, '0'+CStr(Day([APPayment.DocDate])), CStr(Day([APPayment.DocDate]))) + Substring(CStr(Year([APPayment.DocDate])),3,2) ) 

Is an Acumatica site’s IP address static, or is it a dynamic one that can change over time? Our IT needs to know so they can set up a Microsoft 365 Connector, and they’re concerned a dynamic IP address could make it difficult to maintain. 

Does anyone know how to load external url image to Acumatica Form?For example I have an UDF UsrImageUrl = https://designerimages.artifi.net/UserPhoto/0e8a78b2-eea3-475e-b38c-b3ea2b606926/Customize/Standard/5f2142de-766c-44a0-8f32-0b447de9f6e2.png.How do I load image in UsrImageUrl to an Form? Thanks

Thanks to the other topics already posted here, I’ve been able to create a wiki for my custom page!  If I put my wiki on the dashboard, and click it, it opens to my default “Overview”.  When I click the help button on my custom screen, the wiki opens but it does not start out at Overview.  It defaults to the “root”.  If you click Overview in the tree menu, it opens the overview just fine.  It is just a little UI issue for me to not put the user at the “root” where there are no articles.Here are some screen snips showing what I mean.Here is the dashboard:Clicking this gives me the desired results: From my custom screen I click the help button and this is what shows up:Note that Overview is not selected by default.This is the setup for the Wiki which looks right as it does show overview by default when selected from the dashboard.I will eventually remove this one from the dashboard as I will want it used just on the custom help button.  It is on the dashboard now just so I can see it fun

I have a user uploading an Excel file into the journal transaction screen. If a subaccount in the file is inactive in Acumatica, it automatically changes to the subaccount of previous line. No warning or anything.  I tried recreating in my local test environment, and instead I get an error that subaccount is inactive. I don’t see any relevant differences in the settings. Anyone seen this or have an idea how to solve? Unfortunately upgrade was delayed so I can’t submit case with Acumatica. 

I’m trying to create a simple Year-to-date chart on a dashboard to compare 2 different series of data and am experiencing an issue when sorting on month number.I would like the data to display in correct month order (i.e. 1,2,3,4,5,6…) and instead it seems to be sorting differently (i.e. 1,10,11,12,2,3,4,5...). I’ve tried multiple Sort By options on the chart settings and nothing seems to change. Is the sorting issue because I don’t have a full year’s worth of data in both series? Are my sort settings wrong? Am I representing the month number in the GI the correct way? Any help would be appreciated. Thanks!GI DatafieldGI DataChart SettingsResults 

We start with 60x288 raw sheets of metal and cut them down to 60x248 (just as one example) in high volumes.  The 60x248 makes the primary part #, the 60x40 is a usable drop/remnant.  I would like to inventory these 60x40 “drops” (by-product) and give them value, because we’ll use them later for plasma cutting small parts.When creating the BOM for the primary part #, I am consuming the entire 60 x 288 material, and then adding the by-product (60x40) as a negative quantity.  This works great for inventory tracking purposes, because the by-product is added to inventory each time we do a Move on the primary part #.My concern is costing.  We use average costing, so do not revalue our inventory (as you would in a standard costing environment).  The value of steel fluctuates widely, and therefore the theoretical cost of that 60x40 drop should change relative to the cost of the 60x288 raw sheet.  However, in order to accomplish this, I have to manually do calculations for a 60x40 portion of a

Hello Community,I was hoping you can shed some light on this issue…We show duplicate Vendors in the Vendors' Generic Inquiry.    This is how the table relationship is set, I believe is probably incorrect because of this.   Please help me set the relationship correctly. Thank you

I have a client who would like a customized GI for their Project List.They want to see all Projects listed once and if a Project has billing tied to it, they want to see the last ProForma Ref Nbr and the last AR Ref Nbr.In the example, on Project 9683, they would want to see AR Ref Nbr - 000004 and ProForma Ref Nbr - 000007. Is this doable?  If so, can it be done in a GI or does it need to be a report? 

First question, does Acumatica 2022 R1 run on Windows server 2022?Second question, has ANY version of Acumatica yet been certified to run on Windows server 2022?(the 2nd question is because from the matrix I have seen, not even 2023 R1 is certified on Windows server 2022.)Thank you, 

Hi Team,Good Day!As a practice our company used to print the payment voucher from the checks print process. (Kindly refer the following image 01)Image 01In that process one check is only allowed to print at only once. So if we have any issues with the print we are not able to reprint it also we are unable to track the issues.So my concern is, is there any other way to get the print of the payment voucher from the system ? (Without using the check printing process) Thanks & Regards / Yashodha

Hi Team,I need to save some data into an another table in the DB. I created a table in the DB and also created a DAC. Can someone please help me?public PXSelect<CISTaxSubmittedData> cisTaxSubmittedData;[PXButton(CommitChanges = true)]        [PXUIField(DisplayName = "Submit Tax Report", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = false)]        protected virtual IEnumerable submitTaxReport(PXAdapter adapter)        {             need to save data to the cisTaxSubmittedData             return adapter.Get();        } 

Hi there, I am having trouble to display the custom field value for Inventory Item Class in Storage Summary screen as shown below: My DAC:public class StoragePlaceStatusExt : PXCacheExtension<PX.Objects.IN.StoragePlaceStatus>{ #region UsrItemClass [PXDBString(30,BqlField=typeof(StoragePlaceExt.usrItemClass))] [PXUIField(DisplayName = "Item Class")] [PXDBScalar(typeof(Search2<INItemClass.itemClassCD, InnerJoin<InventoryItem, On<InventoryItem.itemClassID, Equal<INItemClass.itemClassID>>>, Where<InventoryItem.inventoryID, Equal<StoragePlaceStatus.inventoryID>>>))] public virtual string UsrItemClass { get; set; } public abstract class usrItemClass : PX.Data.BQL.BqlString.Field<usrItemClass> { } #endregion} When I tried creating the field in Customization Project Editor screen, it seems like it was created in two places: StoragePlace and StoragePlaceStatus. However, referring from the Element Inspector

Hi,Could you please anyone explain how can we set an expiration date for the item produced when we report the production through production order? Best Regards,Dulanjana

Good day everyone, I am trying to update the Display name of a field on the AR508000 screen and I get the following error:The underlying field is a surrogate. Attribute overriding for this field is not supported. These are the fields in question on the ARDocumentList data view. I have tried extending the DAC and also tried changing it via the CacheAttached but cannot get it to work correctly or publish it without errors. Any help would be greatly appreciated. Thanks,

We have a custom report that will display list of stock items with their age and the customer that is associated to those items. However, one stock item can have multiple customers linked and this is causing the items to not appear on the list.Is it possible to add multi select functionality on the report designer? I am also attaching the report file below. thank you for the help in advance!

Hi, I am trying to import on the Item Warehouse Details and I am getting an error that the warehouse can not be empty. Does anyone have an idea?Here is the screen that I am importing to:The import scenario:The error (warehouses are filled in) 

Hello all,Just curious how we could find the generic inquiry behind any screen. For example, the 'Account Summary' Screen: ScreenId=GL401000.I ask, because the mission is to create a dashboard tile showing the ending balance for a certain GL Account where the record period = the current period.I’d like to understand where I can copy/edit/manipulate the data I see on the Account Summary screen. I tried:Navigating to the screen Customization button (looking for ‘Edit Generic Inquiry’)But ‘Edit Generic Inquiry’ is not an option.What is an efficient way to get the info in the grid below, assuming I can create the parameters for Ledger & Period?Thank you for any input. 

Why would there be no hours available on the employees when the front loaded amounts are there?   

On Requisition detail, there is an Account and Subaccount field. When I enter a Requisition, these fields are empty by default. If I populate the fields, then create PO from the requisition, the Account flows to the PO (even if different from account on the non-stock item), BUT the subaccount does not. It defaults from non-stock item. Is there a way to allow subaccount to flow from Requisition to PO?  My understanding is AP Preferences determine where the subaccount comes from if non-stock items are used. I have it set to pull from inventory item. Don’t see anything that could be changed here to accomplish the above. Anyone know what else I could do? I don’t understand the point of subaccount on Requisition if it can’t flow to the PO/Receipt where the actual posting occurs. Thought maybe it’s just for budgeting, but that doesn’t explain why the Account does flow to the PO.  Thanks in advance. 

Hello All,I have been trying to create a PO for the project that has the Inventory Tracking set as Track by Location. but it gives the following warning message:How can I resolve this?Thanks in advance.

I have a timecard for an employee April 1, 2022;  this happens to be his first time card; however I would like to create all of his time cards from Jan 1, 2022. The Employee Generate Time card only creates timecards for the first time card forward?

Hello All,I have been looking out for templates that would help us out to import the project Balances. I would also like to know if importing the Project Balances would mean importing to the Project Transactions screen? Also how can we import Project AR Invoices?Thanks in advance.

I would like to set up recurring cell phone reimbursement contributions in Acumatica for employees that receive this monthly. This is done in the first pay cycle of each month. I have created a benefit code in the deductions and benefits screen but I cant figure out how to input the frequency so that i dont have to do 12 individual line items in the employee payroll settings. Any advice on how to accomplish this? TIA

Our customer would like to apply payments by using a process for pay/release A/R invoices.For credit card there is “auto-apply payments” but this is not available for any other payment method.What do you suggest?