Solved

Hi, I meet a problem when creating a GI, not sure why the result will not display decimal number result.Here is the calculation.=SUM(DateDiff('d',[POReceipt.UsrReceiptDate],[POOrder.ExpectedDate]))/(COUNT([POOrder.OrderNbr])) The attached with the xml file.

Customer has device hub and printers configuredCustomer has a custom PO receiving report to print to a specific paper printer.Is there a setting so that the report will always print to specific device hub printer ?Currently the report prints to the screen and then the browser / windows is used to select the printerI found help for the User Profile / Printer Setting Tab (pageid=8430c8b2-a79c-4f7b-9768-b0b7fad23a59) that says:  In this table, you can list reports that you regularly print and specify the default printer to be used when you print each of these reports. When you print a report from the list, the system uses the assigned printer.I was not able to set a ‘default printer’ as described in this help.  What am I missing?     

I have a customer going live next week and we need to bring in their beginning inventory.Normally, this is a simple Inventory Receipt, but they’re using lot/serial attributes (the latest customization for 2023R1).It looks like I need to load the inventory in 2 steps:Create an Inventory Receipt record to add the item, qty and lot numbers Use an import to update the those inventory records with the lot attributesThe reason I think it needs to be 2 steps is because lot attributes can’t be added to a Receipt record until the record is saved (the attribute fields don’t become available until after the save).However, my import is failing with the very informative error below: I’ve come to realize that this doesn’t really mean that there is a problem with an attribute value but rather it’s an issue with the import structure.Has anyone successfully imported lot/serial attributes? And if so, can you help with what the import should look like?Below is a snapshot of the import and I’ve also attac

I keep getting this error when i try to convert sales quotes into orders of the SU type. I have never had this problem before. Please help! CS Error: Cannot generate the next number for the SUORDER sequence.

Who is currently using Korber One (what was HighJump)?The company I joined implemented HighJump about a year ago and our current integration solution with Acumatica is not sufficient. How is your integration setup with Acumatica?

I am working on a GI to pull Customer information. This information will be used to update another system. I have the GI pulling all the information with the exception of the Customer’s SHIP-TO ADDRESS (found on the AR303000 screen under the SHIPPING TAB). I have tried the Inspect Element function and it showsI can not figure out the corresponding table and Address ID field to use to pull the Ship-To information.Thank you for any assistance. 

Hi! We are currently migrating form Sage 300 CRE to Acumatica. We are wondering how can we best translate to Acumatica our Sage 300 CRE Account definition. In Sage 300 CRE, we use a suffix for example: 31000.001 The first 5 digits (31000) - Account The last 3 digits (001) - is our suffix (department, company, project, etc) 

Hello everyone,I'd need to display the first PDF file linked to current AP invoice in the AP301000 screen. Is it possible to do that using side panels ? Thx.

Can you add “Backorder” status to the Open Sales Order filter so the Sales Orders in Backorder status are displayed under this filter?  

I’ve been updating the user access to the GL Accounts tabs (view-only) on the Customers, Customers Classes, Stock/Non-stock item, etc. I was able to find most of the GL Accounts and Subaccounts fields on most screens except for the Customers screen.Under the Access Right By Screen > Receivables > Customers > Customers, I can only find the Cash Discount and Prepayment fields listed. Where can I find the rest of the fields?  Thank you,

Is there a way to add in a custom Function (C#) into a Generic Inquiry. I remember reading a blog post at a time where this was explained but I cant find it or this is not possible anymore.any guides or post about this will be helpfulthanks 

As shown in the above screenshot, I want to get the total of the “Line Volume” in the detail section and show in the field of Total Volume in the header level. This Line Volume is a newly added customized field in to the ARTran DAC. Relevant code for the Line Volume as follows.  Guys, If you can give me a guidance, it is highly appreciated. 

I have created a location selector under “Component and Warranties” grid in Equipment Screen (FS205000).The selector is working fine, location is also getting selected and saved into db. but when the focus is removed from the selector field, I can’t see the value. below is my code and screenshots attached :  #region UsrXDLocation        [PXDBInt]        [PXUIField(DisplayName = "Location")]        [PXSelector(typeof(Search<Location.locationID,Where<Location.bAccountID, Equal<Current<FSEquipment.customerID>>>>),             DescriptionField = typeof(Location.descr), SubstituteKey = typeof(Location.locationCD), Filterable = true)]        public virtual int? UsrXDLocation { get; set; }        public abstract class usrXDLocation : PX.Data.BQL.BqlInt.Field<usrXDLocation> { }#endregion This code is under FSEquipmentComponentExt.This screenshot is when the field is on focus :  This screenshot is when the field is out of focus :   Thanks and Regards

We’re working through our implementation of the Advanced Planning and Scheduling module. We’ve successfully setup a few BoMs, Machines, Calendars, etc AND have managed to schedule test orders with predictable results. several wins all around BUT there’s something we might be missing… Threaded Scheduling ( I made that name up )When scheduling a large order where individual Operations span multiple days we’ve noticed that it’s all scheduled logically as one long plan, not ideal for our environment. Let’s try this scenario...Assumptions : Operation 1 references a Work Center that resides in Warehouse A. Operation 2 references a Work Center that resides in Warehouse A, though we may opt to move Operation 2 into a different Warehouse within the same building.Scenario : We need to make 100 widgets and the BoM has two Operations. Operation 1 takes five days to complete and each day it completes 20 widgets. Operation 2 takes five days to complete and each day it completes 20 widgets.Observatio

User Roles (SM201005) > Customizer: rename it to 'Customiser'Can we make the spelling configurable in different country? forexample, we use UK English so we have to change the spellings everywhere.  Thanks in advance

What’s the best way to add an index to an existing table that’s a third-party table?It’s a table with an auto-increment field as it’s primary key (along with CompanyID). But when I look at the underlying views, the code is querying the table using non-indexed fields. I don’t have time, at the moment, to reach out to the third-party to suggest that they add a key to make the lookups faster mostly because I won’t have time to integrate any patch from them into my code base at this point even if they agree.So I was thinking of adding a non-unique key on the fields that I see the view using.Should I just add a SQL script to my customization project to add the index if it isn’t already in place?Or is there a more official way that I should do this?

I’m a little confused with the OAuth logout method. I have the login/token method working, but once the token is issued and the api’s are finished do I need to post a logout? Or can I continue to use that token for subsequent calls. Also, if I need to logout, what do I pass? I see the methods in the videos about Postman, but I’m using Power Automate Desktop actions for the automation. Thanks!

What is the best practice to pay employees for a holiday that was not setup in the work calendar Exceptions? At the time of setup, the customer missed informing us that Easter is a paid holiday. It wasn’t setup therefore we now need to get this holiday paid to the employees.  We are thinking about using Paychecks and Adjustments entry with check type = Special. Can you confirm best practice?  Also, since Easter holiday and some others float around to different dates, is it understood that we should adjust the Work Calendar Exceptions list at the beginning of a new year for the upcoming years’ proper holiday dates? Thank you much!Amy  

Is it possible to create the above credit terms?Ex: Doc date 10 Feb 2023, it is due at 30 April 2023.  

Is it possible to take photos on an appointment and save it onto the target equipment selected for that appointment? Our guys don't have access to the equipment module on their tablets and at the moment we have to take photos on the appointment and manually move them to the appropriate target equipment.

HI, I’m trying to create an approval map where a manager will need to approve the AP bill for POs enter only by certain users. It doesn't look to be working. However if I uncheck the active box for the 2 employees in the conditions tab, the approval does work. I only need it for these 2 employees though. Any Thoughts? 

How can you default the Business Account Class for BA’s that are created automatically when you create a new customer?  We have the default setting from customer  management preferences and that works great for BA’s that we create as a business account and then extend to a customer.  But…  if we create a customer, the automatically created BA does not default a business account class.  I couldn’t find any AR preferences for the Business Account class.  

How do I create a column that calculates % of sales for each row?  

Hi All, I am currently working through a Requirement for the proForma Invoice where we would like to split Time and Material Project Entries with their separate Headers and after each other:Basically Project Task 1 with the Code 00 will always be Labor and needs to flow into the Time Header Section.The Rest will always be Material.So I need to associate the Line/Detail Section to the Grouped Header of Time.I cannot figure out how to associate a certain Detail section with the appropriate Header Section.Visual Expressions didn’t bring me very far yet as it is not determining where the specific Lines shows up  Any thoughts on how to associate the Detail Section with the Header Section?

Has anyone experienced slower system operation/transaction speed when dealing with a large data set of > 500,000 SKUs (i.e., is there inverse relationship between operational speed and SKU quantity in a system)?Thanks.