Solved

Hello,The scheduler could schedule a production order late if either materials are unavailable or if needed capacity does not exist.Is there any audit GI or report available so you can check why a production order was not scheduled when it was needed?Thanks,Larry

I have a GI that seems to keep defaulting to a value when i have no default value set. The report works however its just annoying to have to change the value every time We really dont use the “stocked” class for much.  This is what I want This is what I get every time ..  Here are my ParamsAnd Conditions As you can see I don’t store anything as a “default” value.

Can I customize the following print action in this screen ? If yes then how can I do it. Please help. I cannot find any view or DAC in this page.   

I am trying to fetch value from DB in FieldDefaulting event but the value is not reflected in the UI.This my code in graph extension.protected void SOShipment_UsrPickListPrintNumber_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e) { var row = (SOShipment)e.Row; SOPickingWorksheetReview tempGraph = PXGraph.CreateInstance<SOPickingWorksheetReview>(); SOPickingWorksheet txsetup = PXSetup<SOPickingWorksheet>.Select(tempGraph); SOPickingWorksheetExt rowExt = PXCache<SOPickingWorksheet>.GetExtension<SOPickingWorksheetExt>(txsetup); e.NewValue = 100; }DACExtension#region Virtual fields [PXInt()] [PXUIField(DisplayName = "# of times Pick list printed", Required = false, Enabled = false)] public int? UsrPickListPrintNumber { get; set; } public abstract class usrPickListPrintNumber : PX.Data.BQL.BqlInt.Field<usrPickListPrintNumber> { } #endregion 

HiLooking to figure out which REST API I can use to update/amend the substitution lists.The swagger.json at the top level isn’t showing me much helpI can subaccounts but not substitutionsIdeas?  

Hi guys, I wonder if there’s a way to set view restriction on project tasks? Like for some employees, they could only see part of the tasks in a project; but the others could see all the tasks. Anyone has any idea? Thanks a lot!

2021R2 version.  We receive an EDI 850 from our customer.  Through True Commerce APIs, we create a sales order in Acumatica.  Later, we receive an EDI 860 change order from our customer.  Our business does not want this change order to be automatically applied to the existing sales order in Acumatica.Instead, our business wants us to generate an exception report that lists the content of the 860 (e.g. header info, line item data) and generate exception messages where the 860 change order is different than the sales order on Acumatica.  For example, provide exception message that the line item quantity changed, or that a new line item was being added to the sales order.  This exception report would go to the customer service rep., who would review the changes and manually enter them on the Acumatica sales order if accepted.  Has anyone already built functionality that creates custom change order tables (header, lines, notes), and then matches this to the sales order already existing on

Hi, I am doing a GI to show the GL accounts for NonStock Items.The NS Items are tied to a posting class. The posting class can use the default of Inventory Item (I) or Posting Class (P) I am trying to get the GL account to be in one column. My data field looks like this: =iif ( [INPostClass.InvtAcctDefault]='I', [InventoryItem.InvtAcctID], [INPostClass.InvtAcctID])The GI is returning 2037 instead of the GL#, 11302. Is there a function or a way to get the 11302( The GL from the chart of accounts) to display? Thank you, Bill 

I have a request from a client to delete all “Canceled” Service ContractsI tried adding a delete button to the Service Contracts GI.This resulted with: Error: The record cannot be deleted. Different approach: I tested using a SQL DELETE in my local Acumatica instance database.to bulk delete all existing Service Contracts that have a status of “Canceled”                  DELETE FROM [FSServiceContract] WHERE Status = 'X'This appears to have deleted all the Service Contracts that have a Status of “Canceled”, which is what the customer wants. Note: This SQL approach does bypass business rules in this module. Question: Is there a better (preferred) approach to deleting Service Contracts that have a Status of “Canceled”?My customer requests:Bulk delete all of the Service Contracts that have a status of “Canceled”. Give them the ability to delete Service Contracts that have a status of “Canceled” on their own.Thank you in advance.Ken Severud   

We would like to be able to restrict users to a single warehouse.So the user would only be able to ship and receive in their assigned warehouse.Is this possible?Thanks!

We are experiencing integration error regarding Tax Detail ID’s between Celigo and Acumatica.  It seems that Acumatica cannot find a match for the Tax Detail ID being passed from Celigo which is causing the errors.  This has been working fine for the past 2 years and the issues started in early to mid April.  Celigo and Acumatica claim that there have been no changes made on either side to cause this to stop working.Is anyone experiencing this as well?

Can the ATTRIBUTES section of the Item Classes screen be extended downwards to fill the screen.

Hello,I have a SOLine custom field with PXSelector, how can I rename the column Customer Price Class to Price Code inside the selector?   In Sales Price screen (not customized), its name was Price Code. I already tried using ARSalesPrice.priceCode in the code, but it shows empty value. Here’s my code, 

I was wondering if there’s a way to create a matrix of Environmental Handling Fee being added to the Sales Order (or Sales Invoice) when certain Stock Items are selected based on the State value of the Shipping Address.Tried with fixed tax (doesn’t work for Qty other than 1) without a success.Pointing to a certain direction in setting such functionality would be gratly appreciated. Mike 

 This user access to support has been granted, but when I login as this user I still can’t create activity to reply the customer case. 

Is there a way to reset the cash account beginning balance when there are existing transactions already in the system for that cash account?If so, could it be reset without posting to the GL?Thank you

While trying to clean-up books, cannot get journal transactions booked to cash account with different subaccounts than defined on cash account. Read that cash account is one-to-one relationship with subaccount, so saw that solution may be to create new cash accounts with the not defined subaccount to clean-up, but concerned that cash account configuration has not changed yet we have transactions that are said to be impossible and are now erroring after upgrade to 2021R2. How could this have happened?

I am looking for a report that can show all union deductions and hours for all union employees for a specific time period(normally by month) to generate for employee dues payments.Wondering if anyone has created such report.  I have three different unions that I need to report employee hrs and deductions/contributions per month.  Is this something I can create with a GI?would want totals by employee and by deduction/contribution. 

I want to set up a notification that for a group of users that MRP successfully completed. What is the best way? by best I  mean easiest.

Hi everyone. It seems we get a decent amount of orders where the ship-to addresses are incomplete. That causes to notify CS. Then CS digs around by either finding a previous order or reaching out to the customer.Then we'll be sure to edit the customer account in acu/bigc. Just slows the process down in general.It's been discovered these only have a street number.We think it has to do with the customer using an autofill feature (browsers unknown), but not selecting the full address choice. Maybe just hitting Enter and moving on quickly. Just a theory.Any thoughts?Thank you.

When doing a labor transaction in the “Employee ID” field can I create or have a labor group instead of recording time for individual employees ? I

The Email Notification Template for Sales Orders that is being pulled is not the one we have setup in our system. It was working fine around 2 months ago and no known changes were made. I have verified that the Report Settings under Sales Order Preferences is set to the correct notification template and is “Active”. None of the notification templates that we have setup regarding Sales Orders use the wording that is pulling up now. It is not a customer specific issue - it is happening across the board. Any other ideas of where I can look to get this fixed? 

Hello Community,I set up 2 FACTOR authentication to an Acumatica instance. The goal is to have an access code delivered by email. I found two troubles in using this feature: Although my intention is to use on email , the instance always sends a two factor authentication message for using push request method and the user has to click on “Use another authentication method” link which leads to another prompt where the user can click on “Receive code by email”. This is confusing for the user and is an unnecessary extra step.  Really annoying if you need to do multiple sign-ins along the day. Another issue is the fact that two email are sent: one has for a Device Code and the other is for a Sign in Code. I do not understand this logic. Has anyone faced this issue out there? is there a workaround to eliminate those prompts and have a message confirming that an email was sent with the Sign in code to <email address>? It would be so much simpler and logical, in my opinion. 

We have parts that we need to inspect on receipt before they can be sold.  We have an inventory location that we receive to that does not allow sales (issues).  We would like to create a production order to inspect these items but cannot issue them from the receipt location to a production order. Any ideas on a better approach to handle incoming inspections, including scheduling and prioritizing the inspections?

We are a retailer who use the Distribution and Ecommerce modules.  We have implemented a leasing program where customers can lease the product vs. buying outright.  In this scenario, we ship the product to the customer and then “transfer” the inventory to a virtual warehouse so that we can account for it.  We started using the TR order type but this is very cumbersome.  Are there others who are leasing products to their customers and if so, how do you track it?  We have looked at LeaseQuery, but it is not the right solution because they are more for if we were leasing the product for our use.  TIA