Solved

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, Please can someone advise on how to change default ‘Dispatch Priority’ on Production Order Profile. Currently defaulting to 5.Many thanks

Hello everyone,I need to run a query without the platform merging the DB result with the Cache and showing it to me. I have something very simple like thisbool isResumed = PXSelect<EPApproval, Where<EPApproval.refNoteID, Equal<Required<EPApproval.refNoteID>>, And<EPApproval.status, Equal<Required<EPApproval.status>>>>> .Select(Base, RefNoteID, HCLEPStatuses.CustomPending) != null;In one of my queries I know for sure it should return false as I do not have the matching criteria in DB but because the query result is merged with Cache “true” is returned. I could clear the Cache before querying but the case is I need the data stored in the Cache by the platform for further processing. Any help will be appreciated. I got around it using “PXDatabase.SelectSingle<EPApproval> …” but I do not believe it is the correct way.

Is there any way to add a delete button to a selector, allowing us to delete a record which showing in the selector window?  

Hi,For the given project template, the project template screen revenue and cost tabs show $0, the project budget screen has 0 records, but a the PMBudget table has 21 records.The GI we built to analyze project budgets is including the project template due to these 21 records, so does anyone know how to get rid of these records?Thank you,Dave Z

Hi, is there a difference in copying a tenant vs creating a snapshot then exporting and importing it?does one include customizations, etc or do they basically do the same thing?

Hi Everyone. I need help in filtering some entities. Note, we are using Bundle B2B.1. Sales Order Export - Filter by BranchI need to only export Sales Orders in the SLC-APPL branch to BigCommerce.I have tried filtering by CurrentDocument.BranchID for Equals or Contains SLC-APPL, and even tried the underlying number associated with the branch in SQL (27 in Sandbox)Any filtering on CurrentDocument.BranchID seems to filter all orders instead of letting only SLC-APPL orders through. Since we do so many Sales Orders in different branches this makes error monitoring very difficult.Inactive Acumatica customers are exporting to BigCommerce/BundleB2B. I have run some tests on Sandbox with the entity filters and it doesn't seem to be working as intended. Thank you.  

I am trying to find a way to change SQL server from using UTC time to Local time. This is because I need to be getting Local time when I pull data using ODATA via excel. Is there a way to configure the SQL server from UTC to local time?

When confirming a Pick List i always get the error:Another process has updated the 'SOPickingWorksheet' record. Your changes will be lost.Create Sales Order Create Shipment Create Pick Lists with “Create Single-Shipment Pick Lists” Check “Send To Picking Queue” and “Confirm Shipment on Pick List Confirmation" Start “Pick, Pack, Ship” - Next List - Scan Location, Package, Item - Confirm Package - Finish And Next ErrorSetting: PackOnly  What am i doing wrong? In 2021 R2 it worked this way.

Hello Everyone,By default, can we make this field empty? If yes, can you please share the code sample  

When I try to export BOM, the first line of each Assembly shows the same incorrect Material Component ID and UOM;   The second line on to the last line is correct;  It’s only the first line, and only these two fields that are incorrect with the same incorrect value each time.  I’m assuming maybe I need to use some kind of offset to fix?  Any advice would be appreciated!Acumatica Job Setupoutput file from job exampleyou can see the yellow highlighted blocks are always the same item ID and UOM, but the second row on is 100% correct;  Quantity on the first row is correct.   This is the same for all 9,000+ BOM Assemblies exported in this report so a manual fix would be quite difficult.Any idea’s on what I’m doing wrong here?This is the form for the first item in the example, you can see what I’m expecting 001-201 item id;   

I have a customization that has CacheAttached for PMInstanceID for SOOrderEntry that is overridden in two different areas.Is there a way to control the order these apply? e.g. I need them to apply in a specific order or it doesn’t work correctly as the merge removes some attributes.

Yes the modified check is selected as active.  what I DID: under payment methods I have selected checkThen under settings for use in AP I selected the AP641000 Check Form with Remittance.  Under the AP menu I select Check Form with Remittance and click on the Edit Report and did some minor changes. Just moving fields on the check itself.  I saved the report as new version check box and made sure it is actived. Then I go to Process Payments / Print Checksselect Checks, enter the account and next check number click on process and the check generated looks like the check unmodified. Are my assumptions correct, that selecting AP641000 under payment methods for Check will make the system use the latest modification under Check form with remittance (the one I selected) or am I missing something here???? Any help would be appreciated

I’ve replicated this in client sandboxes and the sales demo data (no customizations published) in multiple builds for 2022 R2. Does anyone know if this is a known issue? If so, which build is this expected to be fixed in?  

Created and successfully prepared customers in an import scenario.  However, when “Import” was activated, random customers were not loaded.  Can not find a common problem as to why it brought some in and some not.  It did not give an error, just did not bring them in.Reran in test company with  The ones in yellow are missing.Excel dataThe Customers loaded: 

Using the out of the box Import Scenario for Customers.  The customer is displayed but when Import is selected, get the error:Here is the Import Scenario: The excel data file:Thanks. 

Hey, everyone - It doesn’t appear that the “Total Sales” field is calculating in Project quotes, despite being values in the “Ext. Price” and “Amount” columns.  This doesn’t appear to be an issue with hand-keying items line by line.  However, our estimates are fairly sophisticated and large and our estimating team will be making frequent use of the Load Records from File button and it only seems to be an issue when data is loaded in this way.  Is anyone aware of this happening either specifically or in a related way?  In full disclosure, I did customize fields on the screen but only by changing their display names and requirement status.  If you have any insight please advise.  Thank you!  

In the Projects form in Acumatica, if we attach more than one file in the record, how can we select one specific image file to be selected and printed in the report, this image file will have a specific naming convention so that it will be selected to be printed in the report. How can I approach this development?

Hi everyone, I want to set approval condition when PPV field is non-zero but I don't see PPV Amount field on assignment maps screen, anyone have an idea to set up I’ve already tried to set up on another screen (Bills & Adjustments) or purchase order but it doesn't work. 

Hi everyone, is there any quick way to change the column name and column length in Acumatica Time Card? (Screen ID: EP305000) Thanks

Hi,I have a custom field named UserSearchName on Stock Item and I want to use this field to combine DescriptionField of seletor Inventory.I updated the attribute DescriptionField of InventoryID to: PX.Objects.IN.InventoryItem+userSearchNameBut I got the error regarding syntax I think, I have no idea what wrong here. Do you have any experience about this one?Any idea would be appreciate.Thanks

Hi I would like to Populate the customer Billing Email automatically when we run the report for one customer for sending an Email. Response from Acumatica :The report will need to be customized in order to meet this requirement. Even if the customer is indicated in the report parameter, there is no link between this parameter and the mailing settings of the report. Looking for some best approach to meet this requirement.

Business Requirement- Send a product review after the Invoice is closed.We have created a below GINow in the Template, we need a display the Items with Image when we have multiple Lines.We are displaying the Line Items in a same row because of our business scenarioIn the GI the inventory Info is listed row-wise which we need to show as columns in the notification template.Expectations in the template as shown belowI am expecting those 3 Lines as below in the notification template. Acumatica responded this required customization- Need your thoughtsFor each loops can loop through multiple rows on a GI based on same reference number, but will not loop through multiple data fields listed on the same row on a GI.  SKU Image 10343886230   85126691547   85126691555    

During or shortly after the Release action for a ChangeOrder I would like to perform additional updates to the related Project. However, I am not sure how to do this in a way where the Release action is full persisted before continuing.  Below I have attempted to handle the standard release action (Base.Release), and then tag on a function call (SetCurrentOrderSet) to update the project, however since the Release action has not been persisted my logic in SetCurrentOrderSet fails.public class ChangeOrderEntry_Ext : PXGraphExtension<ChangeOrderEntry>{ public PXAction<PMChangeOrder> release; [PXUIField(DisplayName = "Release")] [PXProcessButton] public virtual IEnumerable Release(PXAdapter adapter) { var result = Base.Release(adapter); PMProject prj = this.Base.Project.Current; ProjectEntry prjGraph = PXGraph.CreateInstance<ProjectEntry>(); ProjectEntry_Extension prjGraph_Ext = p

Has anyone found a solution for handling secondary or overflow bin locations in warehouse management? We have several items that say, don’t fit on Shelf 1 (because we stock so much of it), so the rest of the inventory on hand might be on Shelf 2. Currently, I do not see a place where I load this information into the system, therefore the picker only knows to go to shelf 1 and pick what is there. He does not/will not know there might be more inventory in another location. Has anyone come across a solution for this?This will also cause problems with physical and cycle inventory counts.