Discussion Forums

I’m looking for some input from those that use the Pace-Jet integration.  Does the Pace-Jet integration have an Acumatica solution for FedEx’s PRIORITY ALERT service?  

Dear Members,I have duplicate Purchase Order screen with some extra logic based on client request. Now i have request to add user defined field with Required Check true. but its not working in duplicate screen unless i add the same attribute in PO standard screen. advise how to fix this issue.Thanks,Arun

Hi I have implemented copying some custom fields from sales order header to the shipment header screen which works as expected. Now I need some custom field values copied from sales order line to the shipment line screen, I’ve implemented the below but I get the error below. using System;using System.Linq;using System.Collections;using System.Collections.Generic;using System.Collections.Immutable;using System.Runtime.Serialization;using System.Text;using System.Threading;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Data.WorkflowAPI;using PX.Common;using PX.Objects.AR;using PX.Objects.CM;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.EP;using PX.Objects.GL;using PX.Objects.IN;using PX.SM;using PX.Objects.IN.DAC.Accumulators;using PX.Objects.IN.Overrides.INDocumentRelease;using POLineType = PX.Objects.PO.POLineType;using POReceiptLine = PX.Objects.PO.POReceiptLine;using PX.CarrierService;using PX.Data.DependencyInjection;using PX.LicensePolicy;using PX.Obje

Good day, I have a situation in Checks and Payments screen with my custom fields, I need these fields to be available even after the release of the document, I have tried with events, overriding the persist method, and overriding the release, but nothing is working and the fields always become readonly, I would appreciate suggestions to solve this. Here I am adding examples of how I am trying to enable the fields with the events or overriding the Release. public class APPaymentEntry_Extension : PXGraphExtension<PX.Objects.AP.APPaymentEntry> {protected virtual void _(Events.FieldUpdated<APPayment.status> e) { if (e.Row != null) { PXUIFieldAttribute.SetEnabled<APRegisterExt.usrChkMailDate>(e.Cache, e.Row, true); PXUIFieldAttribute.SetEnabled<APRegisterExt.usrChkPickupDate>(e.Cache, e.Row, true); } }public delegate IEnumerable ReleaseDelegate(PXAdapter adapter); [PXOverride]

I have an export scenario to export payments from the Payments and Applications screen.  Most of the time it works as intended but sometimes it just skips payments that have been made since it was last ran. We run this once a day exporting on average of 700 - 800 payments.  AR created a large CC payment the other day and applied it to several invoices and then released it. So the payment was created, modifed released and closed all between running the export one day and running it the next day. Several other payments created and closed the same day were also skipped.These payments that are skipped aren’t prepared so they aren’t exported and so no errors.  The majority of payments that are missed are CC payments that are entered like this, created, applied, released and closed all at once but we have also had the issue with cash payments.My export scenario uses a sql provider and exports directly to a table created specifically for this purpose.I have checked the ARRegister table and AR

Currently I’m facing issue in “Print Labels”. Please refer the image below:When I click on the “Print Label” button. It gives me a message “The operation has completed” ,but I can see this is getting printed. I mean not even in print jobs either. I think I’m missing something here.Can anyone help me here?Thank you. 

Hello, We used to be able to bill multiple shipments into one invoice in SO screan after all the shipments were confirmed, but since this morning it is not possible. It bills the first shipment, and then it gives this error message. Has anyone else experienced the same issues? or is there any setting to be changed?  

Hello,Recently we started using the cash sales, and unfortunately it does not bring the stock item except the nonstock one when you searched for the inventory ID? Is it by default from Acuamtica that we cannot sell stock items on cash sales transactions, or is there a setting in Acuamtica that we can enable it?Thank you,  

Trying to set up Integrated Shipping for UPS, and rates are coming back over a hundred dollars more than what UPS says it will on their website. What could be causing this issue, and how can it be solved?

We would like to be able to modify to outgoing New User notification so that it first checks the user class, then sends out a different pre made NUn based on its findings.For example:An employee/internal user gets an email that says:Hello (Insert Employee name)!Your password must be updated. Please login at https://ouracumatica.hostedsomewhere.com using the following credentials where you will be prompted to change your password:Username: your Email address Password: users passwordPlease visit https://ouracumatica.hostedsomewhere.comBlah, blah blah.But an unlimited external user would get:Hello (Insert contact name)!Your password must be updated https://portal.ouracumatica.hostedsomewhere.com using the following credentials where you will be prompted to change your password:Username: Your Email address Password: users passwordFor Help visit: https://portal.ouracumatica.hostedsomewhere.com/WTHAmIDoing/(Different Blah, blah blah.)Attachment 1 Attachment 2It seems to be hardcoded to only

Hi,I want to give the task “Emails Pending Processing” to a staff. May I ask which role i should put the staff to in the ERP?Thank you.Raymond 

Good day, In a customisation package I have to buttons on the Invoices & Memos (AR301000) screen - these buttons generate a report and attaches it as a file to the invoice or memo. This is the code to generate a PDF which works perfectly. #region Action Button - Export PDF Reportpublic PXAction<ARInvoice> ExportReport;[PXButton(CommitChanges = true)][PXUIField(DisplayName = "Export PDF Report", Enabled = true)]protected void exportReport(){// Report ParamentersDictionary<String, String> parameters = new Dictionary<String, String>();parameters["ARInvoice.DocType"] = Base.Document.Current.DocType;parameters["ARInvoice.RefNbr"] = Base.Document.Current.RefNbr;var filename = Base.Document.Current.DocType + "_" + Base.Document.Current.RefNbr;// Report ProcessingReport _report = ReportLoader.LoadReport("AR641000", null);ReportLoader.InitDefaultReportParameters(_report, parameters);// Read Reportbyte[] data = null;using (StreamManager streamMgr = new StreamManager()){Repo

I am trying to get a custom field to update whenever the stock item attributes are updated, but I can’t find a way to make this work.If base the row updated event on InventoryItem, it will update if other stock item fields are updated, but that doesn’t include the attributes.If I base the row updated event on CSAnswers, then that does nothing.Does anyone have any insight?public class InventoryItemMaint_Extension : PXGraphExtension<PX.Objects.IN.InventoryItemMaint>{ protected void _(Events.RowUpdated<InventoryItem> e) { var invRow = base.Base.Item.Current; var invCache = base.Base.Item.Cache; var extension = invCache.GetExtension<InventoryItemExt>(invRow); if (invRow != null && invCache != null && extension != null) { var widthState = (PXStringState)invCache.GetValueExt(invRow, "WIDTH_Attributes"); var heightState = (PXStringState)invCache.GetValueExt(invRow, "HEIGHT_Attributes");

Hi EveryoneI would like to print the Label generated at the packing tab in the shipment screen automatically from device hub,Can you please suggest? 

We have a customer that transfers inventory to and from related entities with different base currencies.  Company A sends the inventory to Company B.  Company A has a base currency of USD and Company B has a base currency of CAD. We cannot perform Transfer Orders or 1-step or 2-step transfers to any warehouse with a differing base currency.  I have a case open on this but was hoping to reach out to the community to see how they might have solved this issue.The customer does not want to do intercompany sales for these types of transactions for a couple of reasons.  1. An intercompany sale requires the person creating the sales order to know the cost of the inventory “selling.”  They are simply transferring cost from one warehouse to another.  2. They are not billing each other for these items, they are wanting to transfer inventory and costs between Company A in USD and Company B in CAD.Any thoughts or suggestions would be greatly appreciated!

I have 3 actions on a custom form.  I set the IsLockedOnToolbar to true.        public PXAction<ICSFSSSchedule> DeleteScheduleDetails;        [PXUIField(DisplayName = "Delete Schedule Details", Enabled = true, MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)]        [PXButton(IsLockedOnToolbar = true, Category = "Other", CommitChanges = true)]        public void deleteScheduleDetails() This was addressed in the following topic, but the solution there does not fix my issue.All of my actions show in the title bar of the screen:I have reset the caches, restarted the application but the menu items still show.I want them to appear in the More (ellipse) menu.In the project editor, the items are in the correct category. Do I need to “instantiate” the More menu somehow since this is a custom form and there are no default action items?   

Hello there,I am working on a project that involves integrating Acumatica with a third party CRM system. Our goal is to ensure that customer data flows seamlessly between the two systems without any manual intervention. We are particularly focused on syncing customer records, sales orders, and real-time updates on customer interactions.What are the recommended methods for integrating Acumatica with a CRM? Is there a preferred API, middleware, or tool that you have found effective?How do you handle data mapping between Acumatica and the CRM system? Are there any common challenges in aligning data fields, and how do you overcome them?What strategies do you employ for error handling during data synchronization? Are there specific error scenarios you have encountered; and how did you resolve them?Have you noticed any performance impacts when running continuous synchronization between Acumatica and a CRM? How do you mitigate any potential slowdowns?Given the sensitivity of customer data, wh

Good day, I need to pass values from a custom field in APTran in Bills and Adjustment at the moment when the Bill is released and the Journal Transaction is created, I need to pass the values to GLTran to a custom field, but when I use the Actions.PressSave I get a null error, Object reference not set to an instance of an object. I can't find which is the value I am missing or which another field appears as null and is required, I compared between the null fields on cache and the fields in the database that say that are required, but all the fields that appear as null are allowed to be null so I can't find the problem.I would appreciate some assistance please.public class APInvoiceEntry_Extension : PXGraphExtension<PX.Objects.AP.APInvoiceEntry> { #region Event Handlers public delegate IEnumerable ReleaseDelegate(PXAdapter adapter); [PXOverride] public virtual IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod) { var

Hi all,I crafted a comparative sales report to show sales for a period of [@MonthStart] to [@Today] for a 5-year span, ie, with today being September 9, the report would show:Range A: 09/01/2020 - 09/09/2020Range B: 09/01/2021 - 09/09/2021Range C: 09/01/2022 - 09/09/2022Range D: 09/01/2023 - 09/09/2023Range E: 09/01/2024 - 09/09/2024(note: these are the default date ranges I’ve set, as that’s what our sales team wants, but the user can input any 5 date ranges they want)The report shows sales for Ranges A, B, C, D just fine, but unfortunately Range E always shows $0.So to get all 5 periods, you have to run 2020-2023 in the first report run, then plug 2024 period into a separate report run.Can someone look at the .rps/.rpx to eyeball this? It’s driving me crazy and I think I’ve missed something simple like an open or close (), but I’ve double checked the parameters and filters and everything looks ok.Thanks! 

I have an Generic Inquriy column called orig_ord_type which, depending on the ARInvoice.DocType could either be a ‘C’ for Credit or an ‘O’ for Invoices and Debit Memos. My logic for this  is =IIF(LEFT([ARInvoice.DocType], 6)  =  'Credit', 'C', 'O') which accounts for Credit Memos and Credit WO (Write Offs) which should be coming up as ‘C’, but everything is coming up as an ‘O’. I’ve even tried using =IIF([ARInvoice.OrigDocAmt] < 0.00, ‘C’, ‘O’) and anything listed as a Credit still had an O in the column. If anyone has other ideas, they would certainly be appreciated, even using the =SWITCH function. I’ve tried the =SWITCH and I received an error about the MEMO token. 

Good morning Acumatica people!I have a question about Acumatica Payments - we have recently upgraded to 2024R1.From videos I’ve found online, the payment links generated by AcuPay should take a customer to a portal where they can see all of their open invoices (see image pulled from youtube video below) Our payment links don’t do this - they send the customer to a page that only reflects the invoice where the link was generated Where is the setting for allowing customers to see their full list of open invoices instead of just the one invoice for payment? That would be a really helpful thing but I can’t find where that setting is located. Also - is there a way in the customer portal for multiple invoices to be paid with one payment instead of the customer having to click into each individual invoice and pay them separately? This is frustrating for our customers who have a multiple invoices. Thanks for the help/advice!

Hello,I created a Related Documents Tab in my custom screen Similar to Relations Tab in Opportunities screen.I added Transfers in Type Column, But Data is not retrieving from Transfers screen.Pls refer below screenshot.Is there any sample code for this or where I need to add code for this?Please suggest any solution for this. 

Would like to see a customization on attaching files to Purchase Orders and Purchase Order receipts automatically. When we enter receipts for our purchase orders, looking to see if there is a customization that will automatically match up the packing list with the receipts as well as, matching up the order confirmation with the Purchase order.

There is a new requirement to establish a connection between Sales Orders (SO301000) and Bills and Adjustments (AP301000). I attempted to add two custom fields for order type and order number in the Bills and Adjustments (AP301000) form to retrieve sales order types and sales order numbers in the database, allowing the user to select them. Using this new custom column, which stores the sales order numbers, we can establish the connection. However, this did not produce the intended result. Is this the correct approach to create a connection between these two forms? Any guidance or detailed steps on how to implement this would be greatly appreciated.

I’m trying to create AP Bill Payment by REST APII found that I can do it with “Check”, but it doesn’t work for me - may somebody have experiance with AP Payments and can say what I’m doing wrong.One of my API requests: PUT http://***/entity/Default/20.200.001/Check HTTP/1.1Accept: application/jsonUser-Agent: OpenAPI-Generator/1.0.0/csharpContent-Type: application/json{"ApplicationDate":{"value":"2024-09-08T00:00:00"},"CashAccount":{"value":"10011"},"Description":{"value":"Test"},"Details":[{"AmountPaid":{"value":15.0},"DocType":{"value":"Bill"},"ReferenceNbr":{"value":"TEST002"}}],"PaymentAmount":{"value":15.0},"PaymentMethod":{"value":"CHECK"},"PaymentRef":{"value":"Test001"},"Type":{"value":"Payment"},"Vendor":{"value":"V100"}}All my attemts finish with an error like: “exceptionMessage=The system failed to commit the Adjustments row.”