Unanswered questions

We overproduce on our first operation sometimes. I want to be able to overproduce at that time. However, I do not want to allow for people to be to go crazy or not have the rest of the order qty’s controls in place that make each operation qty’s match.  Example set system to overproduce So, on operation 10 qty to produce was 100They were able to produce 150, and they complete 150 Then on operation 20 because system is set to allow over production, even though there are only 150 to make they complete 180.  I was trying to come up with the best solution so I could overproduce but keep the integrity of the locked system in place. Maybe some kind of buyoff and order adjustment? Operator triggers an over production buyoff, and some corrects the order qty? I don’t want to reinvent the wheel if something already exists.  

We are trying to create Lot/Serial Allocations for a Manufacturing Move Transaction through the Contract-Based REST API.Environment:Acumatica Manufacturing 24.200.xxx Move Entry screen (AM302000) Lot/Serial tracked finished good Custom endpoint exposing MoveEntry and Generate actionScenario:Create a Move Transaction successfully through REST API. The transaction line is created with: Quantity = 2 LotSerialNbr = blank Allocations = empty In the Acumatica UI, the Generate Lot/Serial Numbers button is enabled and works correctly. However, when invoking the Generate action through REST API:POST /entity/{endpoint}/MoveEntry/Generatewe receive:PXActionDisabledException: The Generate button is disabled.Investigation:The Move Transaction is in Balanced status. Hold = false. Quantity exists on the transaction line. Allocations are empty. LotSerialNbr is blank. Generate button is enabled and executable from the UI. The exception occurs only through Contract-Based REST API.Questions:Is creatio

I’m creating a Pivot Table from a Generic Inquiry and I have multiple rows included. In this example, I’m just pulling the Employee, Project, and Time Entry and mashing them together so we have a report that shows Employee totals and Employee Project totals. It looks and works great. But the problem is when you export to Excel and it looks not so great. The second column moves over to the blank column when the name doesn’t show (names and project names replaced with generic data). Is there any way to stop this from happening? I would expect it to look more like this considering this is how it looks in the pivot table: Anyone have any suggestions? Or is this just a bug?Editing to add a quick note: I could do this in Report Designer with a Tabular Report which downloads nicely to Excel, but then I can’t have a total on the far right side.

Is it possible to prepare an existing binary snapshot already prepared for export in XML using “Prepare in XML format”?If this is possible, would I need to put the tenant in maintenance mode to do so?I exported a binary snapshot to import via the setup wizard and also to save as much space as possible but I forgot that it had to be in XML format for that method of import to work. 

Hi everyone I hope you're having a great week! I'm running into an issue with Subcontracts and Projects in our system, and I'd love to get some advice from the community.Here is our current process:We have a 1-year Subcontract with a Vendor that covers multiple Projects. Each month, we:1. Reopen the main Subcontract.2. Add a new line for the current month's payment (linked to an active Project).3. Click Remove Hold to process it.4. Create an AP Bill to pay the vendor.The Problem:Over time, some older Projects on earlier lines have been marked as Completed. Now, whenever we Reopen the Subcontract to add a line for a new month, the system blocks us from clicking 'Remove Hold' because of those Completed Projects—even though the old lines linked to them are already Closed.What we expect:The system should only check the Project status for Open lines, and ignore Closed lines so we can keep processing the main Subcontract.Has anyone faced this issue before? Is there a recommended setup or wor

npm run watch --- --env customFolder=development screenIds="TR300300" run successful but in browser my screen is not changed. But if i republish my project  change become

Since there is no documented automatic process that reliably matches those imported Shopify payment records to Acumatica Bank Deposit payment lines.  Has anyone designed and created a customization or a controlled reconciliation process to automatically link imported Shopify payments to Bank Deposits?

Hi,I have a Labor Item filed on grid and when I update the field on one line, value changes for this field for other lines. And in the cache it looks right. But to see the changes on grid, I need to hit the Refresh button for changes to be visible. The logic of updating the field for other lines is written in RowUpdated event handler and i wrote View.RequestRefresh() for FieldUpdated event handler but it did nothing too. I tried adding AutoCallBack for grid with Refresh command and for target i wrote the id of the grid. And, well, it refreshes but only when i click on other cell of grid. And when i just click on my grid or want to change some field, the grid is always refreshing. So I dont think this option works for me. What is the recommended approach to force the grid to repaint secondary cached rows after a field update without losing input focus or requiring a manual refresh button click? 

Is it possible to restrict/hide export of a report created using report designer?  

My company has certain service parts that can be refurbished and reused on the next call. Is there a way to receive these items back, refurbish them, and then add to stock as a refurbished item? My initial thought would be to RMA the item, receive, disassemble to a “core” item, then assemble the refurbished item with a tag to call it out (XXXXX-RFB). I feel there is a step missing in this thought. Does anyone have any experience with this scenario?

Hi,I have noticed that the AP Bills and AR Invoices created through Recurring Schedules are being automatically released.I checked the Business Events and Automation Schedules, but I could not identify which setup is causing the documents to be released automatically.I would like to prevent these documents from being automatically released.  how I can disable the automatic release?Thank you.

I have a client with a pretty niche requirement but based on my research it should be possible. The client creates SOs from their CRM which they use as the central document for tracking of the Job. From the SO they create PO for the Serialized goods that will be delivered and installed on their Field Service Order. So the lines from the SO are marked for PO and Service Order and linked to the PO and to the Field Service order through the standard Acumatica “Create Purchase Orders” and “Create Service Order” actions. When the PO is received it allocates the Serialized material to the SO but that causes a conflict on the Field Service Order making that serial unavailable for selection there because it would cause the quantity to go negative. In order to use the FSO and Appointment to issue the material, instead of a shipment, the users must manually unallocate the SO and then manually allocate the Serial to the Appointment. This is a bulky and difficult process especially with Approvals

Hi, wondering if it is possible to create a GI that shows current year vs last year’s data? Attached is a sample GI that shows current year’s figures. How do I add last year’s data to compare them? Once working, I will need to add it onto a dashboard.If this isn’t possible, I’m thinking creating a new GI with last year’s data and add it onto the dashboard beside the current year.

If we have images attached to our stock items and a GI set up with those items and image URL’s.  Why do the images not export to Excel?  How do we get the export to include a visbible image? We just see the same woding, but not actual image in Excel… 

We have a request to update an existing sales worksheet and release status. Are we able to edit after it has been released? What is the process for that? 

Used to be able to use @OrganizationName.  It seems that Parameters are no longer supported in formulas in the headers of the Column Set in the Modern UIIn Modern UI, 26R1+ how do we get the financial reports to print the company selected in the parameters rather than the company the user is “in”?  

Hi, Can someone help explain the behavior below?When creating a Weekly Time Crew Entry manually under Time Activities, the first line always has a blank Union Local value. However, when I add subsequent lines, the Union Local field is automatically populated even before an employee is selected.Could you please advise where the Union Local value is being pulled from in this scenario?My expectation is that the Union Local should remain blank until an employee is selected, and then it should be populated based on the Union Local setting on the employee record.Any insight into the current logic or source of this value would be appreciated. Thanks!

Hi everyone,Has anyone created an Import Scenario that imports a supplier and multiple supplier locations together?The customer has suppliers with multiple locations. Currently, they use separate Import Scenarios to import the supplier locations. This means they must create the supplier first and then run another Import Scenario to add the locations.The desired outcome is to create the supplier and all associated locations together through a single Import Scenario.Please let me know if anyone has implemented something similar.Regards 

Hi @Everyone I am getting issue in Modern UI files when we extension screen in multiple project Example :- we have Bill of material screen in Acumatica so extension file Main File :- AM208000.ts @gridConfig({ preset: GridPreset.Details, pagerMode: GridPagerMode.NextPrevFirstLast, adjustPageSize: true, autoRepaint: ["BomMatlRecords", "BomStepRecords", "BomToolRecords", "BomOvhdRecords", "OutsideProcessingOperationSelected", "CurySettings_AMBomOper"],})export class AMBomOper extends PXView {} Extension 1 :- AM208000_EWPAQMS_generatedunder ts file we have code  export interface AMBomOper_EWPAQMS_generated extends AMBomOper { }@gridConfig({ preset: GridPreset.Details, pagerMode: GridPagerMode.NextPrevFirstLast, adjustPageSize: true, autoRepaint: ["EWQCBOMVariables", "EWQCInspectionPlanDetail", "EWQCAssociateChecklistGroups"],})export class AMBomOper_EWPAQMS_generated {}Issue :- my code is working but main view under the autoRepaint its not working while i publishing my files i dont know ho

We are currently on 25R2, still utilizing Classic UI, and have noticed the last couple of weeks that when we create an activity it is not automatically reflecting in the Activity tab. We either have to manually refresh or click to another tab and go back. At first, we thought this was an issue with Edge, as I had no issues when I tested in Firefox or Chrome. However, some users experience issues in Chrome and it works fine for them in Edge. Is anyone else experiencing this, or have suggestions on how this can be fixed? We have already cleared browser histories and caches, reset the Acumatica cache, and restarted the application. Nothing we’ve tried is fixing the inconsistencies. 

We have expanded Field-level audit across five tenants for around 45 screens in each tenants(45 * 5 Screens). Before we promote this to Production we want to understand the cost and the correct way to operate it long term.

I am in purchasing for our company and purchase products for all of our branches (warehouses). What I am looking for, because I don’t see this functionality in Prepare Replenishment, is way to see for a specific vendor what all the branches' needs are on one screen without changing warehouses.

Normally, the projects are visible in version 24r2; however, after upgrading to version 26r1 and running some tests, we were surprised to find that the projects no longer appear (they do not show up in the filter). Could this be due to a specific configuration required to view them on the expense request screen?I also notice there was a change in the DAC; could that be related? I have attached the code.If you are aware of any relevant configuration settings, I would appreciate the information. version 24r2#region ContractID public abstract class contractID : PX.Data.BQL.BqlInt.Field<contractID> { }[PXDBInt][PXUIField(DisplayName = "Project/Contract")][PXDimensionSelector(ContractAttribute.DimensionName,                    typeof(Search2<Contract.contractID,                                   LeftJoin<EPEmployeeContract,                                            On<EPEmployeeContract.contractID, Equal<Contract.contractID>,                                            

(Using 26R1) We cannot enter landed cost documents for vendors that have “Hold Payment” status. But we CAN enter AP bills. Which leads me to believe this is a bug on the landed cost documents side.Any insight into this?

I see some great related topics where people have discussed the overview of creating a GI, then an export to generate the layout etc… We have a positive pay solution that is working as long as the check is generated (check start date) and (Check end date) are the same day… The GI has parameters and I can change those as needed, and when we run the export it works.  However the user doesn’t have access to the GI to change the date.  Sometimes the user starts a batch, the payment approval may take a day or more, and then they finish the checks… so the dates are not the same day… The export doesn’t allow us to pass a parameter to the GI, so they’re stuck.  Is there another way to limit the checks to just the ones that need to be on the positive pay file?  Other than date, how else can the checks be identified?  Printed but not closed?  What if it’s ACH?  Automate with a business event once status changes to printed? How have you solved this?  Open to all creative and fun ideas!