Solved

Hey Community,  Does anyone have a generic inquiry that is triggered off of import errors? Looking for a GI to display the import scenario that has the error and a translation of the error message.  I have something like this below but struggling to get the actual error message and the import scenario on the GI.   

We manufacture items using a Lot/Serial Class configured as follows:We want the system to auto-generate serial numbers by default when these items are finished in a Production Order. However, we want to manually override the auto-generated serial number occasionally, as when we are making R&D items.My Question: If I keep “Auto-Generate Next Number” enabled to handle the majority of our volume, does the system prevent manual editing of the serial number field during the Production receipt/move process? I am looking for a workflow that defaults to the auto-generated sequence but still allows a user to manually override the serial number on specific units before the transaction is released.

Has anybody come up with an elegant solution for this? Client wants to add inventory items to service orders to communicate to the warehouse that it needs to be shipped from the warehouse to client site (drop-ship to client)  Client is currently shipping parts from the warehouse via sales orders in a normal distribution workflow for sales activity But what about service orders?  The client wants inventory to be decreased when the parts are shipped from the warehouse  There is no way to track parts that are shipped from the warehouse natively like with sales orders  Inventory items will not be decreased until the service order is billed I’ve seen and experimented with a few solutions: Use Workflow Stages or UDFs and monitor inventory shipping statuses via dashboard widgets  Additionally, transfer inventory from MAIN warehouse to “service” warehouse  Effectively decreasing on hand inventory in the MAIN warehouse at time of shipping  Mark for PO / intercompany SO is created  This seems

I’m trying to use a third-party service (Skyvia) to sync records from Acumatica to our local SQL server.  When I pull data from the Manufacturing endpoint, it cannot do incremental updates because the data does not have either a 'CreatedDateTime' or 'LastModifiedDateTime' column.  Is there a way that I can get this information in the endpoint?

We are currently doing stocktakes in this system for the first time.  We have had a couple of counts error in the Physical Inventory Review screen when trying to Complete PI.  The error we get is ‘Updating Item ##Inventory ID## in warehouse ##warehouse## quantity available will go negative.’ As an example the book quantity is 3 and we are trying to post a physical quantity of 0.  We don’t allow items to go into negative however that is across the whole system.  This has happened on about four of five items out of thousands.  Any ideas on why?  We have checked Inventory summary/allocations etc and nothing has been allocated. It is a rarely used part and has had the initial adjustment in, then a transfer that is pretty much it.

We have a stock item that is primarily manufactured, but can also be purchased / outsourced when required.Since the Item Master allows only one Replenishment Source, we would like to understand how MRP handles order quantities: If MRP generates a Manufacturing Order, does it use the Inventory Planning tab (min / lot size)? If the same item is planned as a Purchase Order, does it use the Vendor tab minimum order quantity? As per my understanding, MRP behavior is driven by the Replenishment Source, and standard MRP does not support planning the same item as both Make and Buy automatically with different order quantities.Please let me know if this understanding is correct or if there is a supported approach.

In Classic UI, I could duplicate Site Map records by assigning different Screen IDs and pointing them to the same URL. When I attempt to switch one of these duplicated records to Modern UI, I get the error below:I have one client in particular who leans extensively on the ability to duplicate out-of-box screens in order to assign them as unique Entry Points in GIs.

Hello Is there anyone who has been able to add an image to a grid column? Regards,Vard

Hello everyone.I’m asking if someone can help me with this issue.I have a Processing screen where I have grid column that display an image based on a URL. The column type is Icon and the DisplayMode is set to Value. In the Classic UI, this works perfectly, but when I switch to the Modern UI, an error message appears while the screen is loading. (External URL has been specified. Parameter name: url)I searched for a solution, but I couldn’t find any way to add an image to a grid column in the Modern UI. It seems that only the <qp-image-uploader> tag can be used, and only inside a form. When I change the ItemImageURL with  the Acumatica stock item image URL, the screen opens, but the image is still not displayed Can someone help me with this issue?Thanks in advance.

Hello!I am required to calculate sales tax on Invoices, but the tax should not get reported on the invoice but only when receiving the payment. Is there any way that I can do this?Thanks

Hi All, I have created a GI on GL journal detail but my filtering doesn’t work on the batch number ( from and to) and journal date ( from and to) can someone please give me a lead on what I have missed? None of these filters work.Thank you   

We are experiencing a workflow issue related to Production Orders in Acumatica Manufacturing and would like clarification on expected system behavior.In our case: A Production Order was marked as Completed After completion, the system still allowed posting additional transactions, including Move transactions However, when attempting to Close the Production Order, we receive the following error: “Select a production order for which transactions are allowed according to the workflow.”We understand that Acumatica may allow late Labor or Material adjustments after an order is marked Completed, but we have not seen clear documentation confirming whether Move transactions are expected or supported after Completed status.Questions: Is it expected behavior that Acumatica allows Move transactions after a Production Order is marked Completed? If allowed, should this prevent the Production Order from being Closed later due to workflow validation? Is this considered a workflow limitation,

Hi Everyone,I prepared a sample email template to send package information when a shipment is confirmed.Currently, our end users go to Shipment → Print Shipment Confirmation → Select Email Template → Send Email.I have already prepared the Business Events and added the <foreach> loop in the email, which is working fine at the moment. However, due to our business requirements, we would like to send the email through the above process, but it does not work as expected.I tested using the following syntax: <foreach view=""> <foreach view="Transactions"> Could you please review and advise on the solutions or steps to resolve the issue. Same email template works when I use the Business event  

Hi, I am doing an import bank transactions manually by uploading a CSV file. I have stated the beginning and ending balance, but when I create a new import bank transaction record for the same cash account, Acumatica doesn’t automatically set the beginning balance as the ending balance of the last statement. Could someone please explain clearly how this works? I would assume the system should’ve automatically detected last ending balance as the beginning balance for the current statement.

Hi,We frequently have customer invoices that are overpaid, and we handle the overpayment through a credit write-off, recognizing it as income.However, when we process the credit write-off for the overpaid amounts, the journal entry does not include the associated tax.Typically, the journal entry only debits Accounts Receivable (AR) and credits the income account. How should we handle this situation if we need the tax to be properly accounted for as part of the credit write-off?

Deposited payments are showing in Undeposited Payments reported. Can some one help me how to resolve this? 

    I have below script that I can be able to add at my screen. But Same script I am not able to add in Existing screen as customization.I want to add this script on page load of Custom screen. I have try with Acumatica customization editor but when I have added this script inside asp control ...while generate script it has gone….please help<script type="text/javascript">    window.onload = function () {    setTimeout(function () {        const el = document.querySelector(            "#ctl00_phG_tab_t18_EWQCCstPXTab35_t3_QCAttributesDetailsGrid_at_tlb_ul li:first-child"        );        if (el) {            el.addEventListener("click", function (e) {                e.preventDefault(); // optional                console.log("First li clicked");                var ds = px_alls['ds'];                ds.executeCallback('EWQCRefreshAnnotations');            });        }    }, 500);     }; </script>

Hi CommunityCould someone please help me with the correct code for displaying a custom field in the Modern UI?I am trying to convert the custom field UsrItemRevision to Modern UI and display it on the BOM (AM208000) and Stock Item (IN202500) screens.I have already tried adding the field using TypeScript and HTML, but it does not work on these screens. Similar code works correctly on other screens, so I believe I may be missing something specific to AM208000 and IN202500.BOM Screen (AM208000)import { PXFieldState } from "client-controls";import { AM208000, AMBomItem } from "src/screens/AM/AM208000/AM208000";export interface AM208000_InventoryRevision25R2_generated extends AM208000 {}export class AM208000_InventoryRevision25R2_generated {}export interface AMBomItem_InventoryRevision25R2_generated extends AMBomItem {}export class AMBomItem_InventoryRevision25R2_generated { UsrItemRevision: PXFieldState;}HTML<template> <field name="Documents.UsrItemRevision"></field&gt

I’d like to make a side panel inside the Project Screen (or any screen honestly) that would open a URL to a Google Drive Folder.  I would setup a UDF that contains the URL of the Google Drive folder.  I’d like the side panel to retrieve the URL and open it in the side panel.  This would allow our engineering team to keep their files up-to-date without having to upload the most recent files unto Acumatica.  Instead, it would simply show the Drive folder with the project related files.Anybody have a methodology that might work? 

Hi All,We are encountering an error in the newly upgraded hosted site (version 25 R1).Could you please advise if there is a way to resolve this issue, or let us know what might be causing it?Error : “The type name 'HttpClient' could not be found in the namespace 'System.Net.Http'. This type has been forwarded to assembly 'System.Net.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' Consider adding a reference to that assembly.”Im using nuget package in a customization.earlier version was leser to this.Your support would be greatly appreciated.Regards,Lalith  

Hi, how do I add the Customer PO in Customer Details (AR402000)?I want to add Customer PO below:This is a custom field. SOOrder.UsrCustOrdExtraTo populate here: I’ve tried going into Customization Editor → Graph:Documents, but the Customer PO isn’t there: 

Hello - I have created a new Email Template for when there are any changes to an order that the employee just choose TEMPLATE in the SEND box and it has different wording.  The template works except for the fact that none of the fields I’ve coded into the Email are pulling?  Am i missing some link…  

Hello Everyone,In Classic UI I have a form with a field where the user inputs a barcode and the backend adds a new line in a grid with the proper record.The focus returns to the input field after adding the line for the user to capture the next line.However I haven’t found a way to get this done with the modern UI.It used to be a very simple JS code in the aspx:<script>function FormView_Load(): void {    px_callback.addHandler(setFocusOnCB);}let setFocus: boolean = false;function setFocusOnCB(context?: any, error?: any): void {    if (setFocus === true) {        setFocus = false;        const cb = px_alls["edCBField"];        cb.focus();    }}</script> Has anyone figure this out ?

Hi, we have a custom form that prints customer payment receipt and I want to pick up the branch details (Branch Name, address, ABN, phone) from the invoice. This is because they have invoices from different branches and pay it to the main branch. In this example, invoice branch is HCCVIC and the payment branch is in their main branch HDDDDForm is printed here and there are 2 invoices in same branch. I want to pick up the branch details from invoices. Currently it picks up from company detailsCurrent setup 

I use the Default/Shipment endpoint to save shipment information to Acumatica via REST API. If the order cannot be shipped in full (or other common errors), I get a failure to save the shipment record and the only message returned by Acumatica will say “Order SO X cannot be shipped in full. Check Trace for more details.”How can I check trace for more details? I have tried: Request Profiler I can see the returned Exception here if I turn on logging, but the exception is too late to tell me where the problem is.  System Monitor Logging in as the API user and looking at the Trace page there Guzzle request to /Scripts/Trace/index.html This just returns the HTML for a deferred script unless I want to get into browser emulation just to get a usable error message Shipments can be 80+ lines, so trying to replicate the problem by hand in Acumatica is not working well.