Discussion Forums

Hello all,I am wondering aside from the lengthy guid kind of value that is assigned to ExpenseRefNbr when an Expense Receipt is created though the Bank Feed, does Acumatica keeps any other reference to other tables to differentiate Expense Receipts created manually from those through the Bank Feed?

Hello All,I have a multi-step approval map set up. With the first layer as a lab tech. They submit the requisition and their manager approves it, it then goes to the Lab Manager who then approves it. The last step is to go to our purchasing department where the PO is set up. I don’t think I’m understanding how everything is supposed to work at each step.Step one → Goes to manager (set up as Next step, always)Step Two → Goes to the lab manager (Next Step, always)Step Three → Goes to Purchasing ( Approve Document, Always)So should each step have an approve button? Or, will it step through the process? Right now, the first manager can approve, the second manager approves bidding, and then Purchasing sets up the PO. I want to make sure this is all correct prior to moving forward.  Brent

Hi everyone, I’ve always struggled with how to pull two address types into a single GI, and right now I really need it. The GI I’m working on needs the Default Address (or shipping address) and the Billing Address info. Attached is an XML from my test environment. The problem I’m having is either no Billing Address info pulls through, or it pulls the same address as default. If I change Billing Address on customer it doesn’t show in the GI. Would really appreciate the help!

We have an issue where we will receive more of an item than what’s on the PO, however we don’t want our receiving team to be able add that to the receipt.Is there a way to prevent adding items or QTY that’s not on the PO? 

Hello, I have a customisation which is already published on one tenant and I would like to publish it to other tenants. The customisation contains files, sql scripts, generic inquires and site maps, and if I install on the current tenant I understand that:Files (such as dlls) are stored central and will affect all tenants.Sql scripts will affect the database which all tenants share.Generic inquiries and site maps will only affect the current tenant, and not be seen on other tenants. This is all quite painful and sharing dll files across a live and test tenant makes testing in a test tenant very difficult. But that’s how it is.The site has about 20 customisations, and I want to publish one of them to the other tenants. The only option seems to be to use the ‘Publish to Multiple Tenants’. When I click this I see the following pop up window. But I’m not sure what happens next, the screen allows me to select Tenants, but I’ve not been able select which Customisations will be published to t

Good dayI have created my Import Scenario based on the Move screen AM302000 and I am getting the following error message.“OperationID” cannot be found in the system However if I create the transaction from the system I can pick it as per the screenshot belowI need to import a number of Move transactions from a historical Tenant as I have changed my base currency.How can I resolve this issue?

While importing AR Payments, I am getting an error “Input sring was not in correct format”    

I’m been trying to add a condition to the workflow of SOShipmentEntry (SO302000) so that it will make other parts of the workflow easier to configure. My code compiles but the condition doesn’t appear within the editor.I’m guessing that I have a parameter incorrect. I’ve leaned heavily on this post but to no avail.Can anyone see something obvious?using PX.Data;using PX.Data.WorkflowAPI;using PX.Objects.SO;using static PX.Data.WorkflowAPI.BoundedTo<PX.Objects.SO.SOShipmentEntry, PX.Objects.SO.SOShipment>;using PX.Data.BQL;namespace CustomerOEMods.Workflow{ public class SOShipmentEntryWorkFlowExt : PXGraphExtension<PX.Objects.SO.SOShipmentEntry_Workflow, SOShipmentEntry_Extension, SOShipmentEntry> { public class shipViaPickup : BqlString.Constant<shipViaPickup> { public shipViaPickup() : base("PICKUP") { } } #region Conditions public class Conditions : Condition.Pack { public Condition IsCustomerPICKUPOrder => GetOrCreate(b => b

In Pivot Table , the time is not showing properly . It showing as Integer .For example below GI based Time sheet report for Equipment / Employee Time . This is showing correctlybut when we make a Pivot table using the same data the time is showing as integer , any option to show it as proper time . Tried “Format” option on Pivot table but it does not helped. 

Hi All,Is there a way to retrieve the Supplier Balance, Prepayment Balance, and Retained Balance details (as shown in the attached image) for a particular supplier through a Postman call?Any guidance or suggestions would be greatly appreciated.Thanks,Lalith

Hi There,I’m trying to release a AP batch payment, but system only allow to export. When I hit export, an error message came up . “CA Error: The batch cannot be exported. An export scenario is not specified for the payment method.” Could you please advice how can I release the payment in Acumatica ? Thank you.  

Hi,We are working on customizations to the Sales Order screen. I have added several new fields and overridden a few methods, such as PrepareInvoice and CreateShipment, to ensure that some of the custom fields flow through to shipments and invoices However, we are encountering an error with the following message:Error: Inserting 'Billing Address' record raised at least one error. Please review the errors. Error: 'RevisionID' cannot be empty.  We are unable to pinpoint exactly when this error occurs. Sometimes, it happens when adding a non-stock item, and at other times, it occurs when saving values in the new custom fields. The error disappears after refreshing the page, but this is not a practical solution as all entered data is lost upon refresh. I have attached the SOOrderEntry code and the Customization Projectfor your reference. Could you help identify what we might be doing wrong or missing? Any help would be greatly appreciated. Thank you.Ramitha Manathunga.SOOrderEntry Code #reg

Hi, I need to construct request that will update/create the cross-reference description.I tried this and many other variations, but it did not work 

Hi Team, I am creating a custom screen, and I have an issue with a column and actions . I added a screen ID "Details," but the standard actions like "Insert" and others are not working when I click them. Please provide a solution.Regards,Sagar    <asp:Content ID="cont3" ContentPlaceHolderID="phG" Runat="Server">    <px:PXTab ID="tab" runat="server" Width="100%" Height="150px" DataSourceID="ds" AllowAutoHide="false">        <Items>            <px:PXTabItem Text="Details">                <Template>                    <px:PXGrid runat="server" ID="CstPXGrid10" KeepPosition="True" DataSourceID="ds" SkinID="DetailsInTab" SyncPosition="True">                        <Levels>                            <px:PXGridLevel DataMember="detailsqltyresponse" >                                <Columns>                                    <px:PXGridColumn DataField="Cod" Width="70" />                                    <px:PXGridColumn DataFie

Hello! While developing a customization project to extend a webservice to migrate data from our legacy ERP into Acumatica, I have discovered that while there is a standard ‘CustomerLocation’ object where we can access and modify customer location entries, there is no equivalent VendorLocation object. I tried to create a VendorLocation endpoint by mimicking how the Customer Location fields were all mapped, but there do not appear to be equivalent mappings in order for me to accomplish this. Additionally, if I just select all fields from the Vendor Location Summary, it corrupts things so badly that we start getting stack overflows when trying to push a Sales Order into Acumatica:And when we try to pull the VendorLocation data via Postman, it would throw errors relating to the Address information we had mapped directly from the Vendor Location Summary (here’s a small snip of that error):"message": "An error has occurred.",    "exceptionMessage": "The multi-part identifier \"BAccountID!Add

I need to add a new segment type to Lot/Serial classes but running into an issue because of a static method.  In class INLotSerClassMaint, the persist method is overridden to do validation on the segments. Here is the method from standard Acumatica.   public override void Persist() { foreach (INLotSerClass lsclass in lotserclass.Cache.Inserted) { lsclass.LotSerFormatStr = INLotSerialNbrAttribute.MakeFormatStr(lotserclass.Cache, lsclass); if (lsclass.LotSerTrack != INLotSerTrack.NotNumbered && lsclass.AutoNextNbr == true) { int NumbericCount = 0; foreach (INLotSerSegment lssegment in lotsersegments.View.SelectMultiBound(new object[] { lsclass })) { if (lssegment.SegmentType == INLotSerSegmentType.NumericVal) { NumbericCount++; } } if (NumbericCount == 0) { throw new PXException(Messages.NumericLotSerSegmentNotExists, Messages.NumericVal); } else if (NumbericCount > 1) { throw new PXE

I am developing a new processing to process web orders that can be pushed straight through to creating a shipment.  I have the process set up that assigns the owner and creates the shipment but I’m not sure how to automatically send the shipment confirmation report to a specific printer on devicehub.The code I have which works to the point of creating the shipment and storing the shipment number is below.using System;using PX.Data;using PX.Objects.SO;using PX.Data.BQL.Fluent;using PX.TM;using PX.Common;using System.Collections.Generic;using PX.Objects.CR;using PX.SM;using PX.Reports;namespace PPCustomOrderProcess{ public class AIProcessOrdersCust : PXGraph<AIProcessOrdersCust> { public class wOOrderType: PX.Data.BQL.BqlString.Constant<wOOrderType> { public wOOrderType() : base("WO") { } } public class paymentMethodAFFIRM: PX.Data.BQL.BqlString.Constant<paymentMethodAFFIRM> { public paymentMethodAFFIRM() : base("AFFIRM") { } } public class pa

Good Morning,We are attempting to create a live sync with a sales demo site with a dev sales force site. Everything works except for the live sync. If we go to the salesforce sync page in acumatica and start the processes. Acumatica comes back and says all is good, no error messages. However the status of the SalesForce Sync is always Stopped. I’ve seen video’s and screenshots of that status as “Running”. I’m out of ideas of why this isn’t running and staying as running.As mentioned early i’ve run a full resync and all the data comes in and goes out to SalesForce. Its just the Live sync that doesn’t seem to want to work.Appreciate the help!

I’m trying to learn more about modifiying a screen deeper.  What I am looking to do is on the Process Shipment Screen, I’d like to add the SO that the shipment was created from, the order type of the sales order and maybe the amount of the invoice. What is the best documentation/training to learn customizations to that level?

Is there a way to load a specific email draft from an import scenario (24r2)? I thought that, since the NoteID is the Key for Email, that I could load one in the same manner as an inventory item.Yet this creates a new email even when the provided noteID exists. Perhaps I’m going about this the wrong way. The goal is to send customers and salespeople an email listing order lines which we had to cancel due to inventory items becoming discontinued - where we never will receive more stock to fulfill their order. This happens often enough that we provide a weekly email of any changes which occurred.My plan is currently to have one Business Event monitoring a GI for when items meet the conditions for cancelation. That event triggers one scenario to cancel the line and another scenario (this) to add the SO information to an email; We would like to cancel SO lines ASAP but not send out more than one email a week.At the end of the week a scheduled event will add some templated text and send any

I have added 2 attributes to a production order.  I want to print these on the production order ticket report AM625000.I added AMProdAttribute to the report with the following relationship. I then added 2 new Text Boxes to the report with the following values:=IIf( [AMProdAttribute.AttributeID]='STARTCASE', [AMProdAttribute.Value], '' )the second box has this value=IIf( [AMProdAttribute.AttributeID]='ENDCASE', [AMProdAttribute.Value], '' ) The first box prints as desired, but the second does not print anything.  ​​Here are the only records in AMProdAttribute: Any suggestions are greatly appreciated!!!!!

We are relatively new to Acumatica and have just started using Field Service with iPads.  We quickly realized that the web version of Acumatica is much easier to use than the iPad app.  However, there is no signature capture in the web application.  Acumatica said it cannot be done in the web application.  At the veterinarian’s office a few weeks ago they were able to capture a signature in their web application EzyVet.  I spoke with EzyVet, and it is a feature that they designed.   Does anyone have any experience or suggestions for signature capture in Acumatica’s web applicaiton?  

I’m currently trying totest the ACU Fixed Asset Import, and coming across an error:my Receipt Date in the spreadsheet is 11-7-2024my Place-in-Service Date in the spreadsheet is also 11-7-2024 Any thoughts on why it is throwing the error?

 I want to disable Allocatiob Apply field disable by default.

We have a client that issues approx 6000 checks per month for lease payments.   Most of these checks are for the same dollar amounts (ie. 3000 checks for $ 1000 and 3000 checks for $ 1500).  When the Bank Feed comes in the Bank Feed writes the Check Number to the Tran. Desc field.  Acumatica seems to ignore the Tran. Desc field and suggests matches displaying 3000 checks all for $ 1000.  Acumatica Tech Support told me that it only matches based on Amount and Transaction Date which doesn’t make sense to me since Ref. Nbr. Weight as well as Doc. Payee Weight are part of the Relevance Calculation.  What fields does Acumatica read to match  Ref. Nbr. Weight & Payee Weight ?