Discussion Forums

I’m trying to get all inventory movements through a purchases accrual account in an inquiry. I can get the APTran joined nicely. I have about HALF of my INTran records showing as expected.The issue I have is that I “think” I need to use Line Number, but the Line Number on INTran is 1, but in the GLTran it’s 2 for a record (Purchases Accrual comes in as the 2nd line, the 1st line is the offsetting account). Without the Line Number, I’m concernced that a transaction could have two rows with the same Item and Account ID, thus creating duplicate entries. The DAC Browser doesn’t have anything regarding these two tables that I can find (hopefully those get more flushed out as we go along). Joins between GLTran and INTranThanks for looking/helping everyone!

Hi, We are trying to set up email configuration on one of the UAT instances. We have configured the external application and tested the email function on the TEST environment, where it is working as expected. However, we are encountering an OAuth connection failure on the UAT instance, which states: 'The provided anti-forgery token was meant for admin@RTU TEST, not admin@RTU UAT.'  The provided anti-forgery token was meant for user "admin@RTU TEST", but the current user is "admin@RTU UAT".    at PX.Data.PXFirstChanceExceptionLogger.ProfilerFirstChanceException(Object o, FirstChanceExceptionEventArgs args)   at System.Web.Helpers.AntiXsrf.TokenValidator.ValidateTokens(HttpContextBase httpContext, IIdentity identity, AntiForgeryToken sessionToken, AntiForgeryToken fieldToken)   at System.Web.Helpers.AntiXsrf.AntiForgeryWorker.Validate(HttpContextBase httpContext, String cookieToken, String formToken)   at PX.Web.UI.PXPage.OnPage_PreLoad(Object sender, EventArgs e)   at System.EventHandle

I’m trying to prepare GI similar to the AP Register Detailed report. I tried copying the same relations as defined in the report designer for the GI but the results are not as expected. the date filter does not work well. I would really appreciate help on this one.

I was wondering if anyone has access to the business logic behind this button :-) as not all PO’s are displayed.I’m guessing, but need confirmation - it’s only PO's that have not yet been receipted, and I’m also guessing that there is some date logic behind it?  Like the date of the PO cannot be earlier than the date of the SO maybe?  The help file on this does not explain these rules and it would be helpful for it to be added there too!

We have a client with three main companies.  Each company has it’s own logo.  The logo’s are set up in each Companies profile.  However, on the printed AR invoice the logo is the same.How do you set this up so that when an invoice is printed for a company, that companies logo is displayed?

Hi, how do I export all the stock item description tab content for all my stock items that has a description content? Not the item description on top.   

Hello Community! I had a question on how to create a shipment with multiple SOs attached through code in a processing screen. My main processing table is SOLine and the code I am attempting is below. This is for a transfer shipment which is why I have no customer ID. The shipment gets created without issue but no line items populate. My trace shows the loop through SOShipmentPlan finding the SOs I am selecting to add but I seem to be missing something.   public static string TransferShipment(SOOrderEntry orderEntry, SOShipmentEntry shipment, List<SOLine> lines, string sOShipmentType, string operation) { PXTrace.WriteInformation("1: Building shipment"); string shipNo = String.Empty; List<SOShipmentPlan> plan = new List<SOShipmentPlan>(); PXTrace.WriteInformation("0: "); SOShipment trShipment = new SOShipment() { ShipmentType = sOShipmentType }; trShipment = shipment.Document.

HI, I am trying to create an Import scenario to load Activity Notes in Cases (cr306000) I loaded the IS from here: But I an getting a message that the Activities$Attach_RefNote action cannot be found. I deactivated the fields that I do not need. Here is an image of the import scenario, Any assistance is appreciated. Bill  

When using the Scan and Count on the mobile app, currently I scan the PI number, then the location I am counting, then the inventory ID and then the count.  After that, it is asking for another Inventory ID.  But the counting I am trying to do needs a new location becuase I have counted all of the expected inventory in that location.  The only thing I see right now is to confirm the count, then start over at scanning the PI again. What I would like to do is mirror the Scan and Transfer that would just ask for the next location to count instead of having to start the PI over.  I have not really seen any documentation on editing workflows.

What benefits do you get from manufacturing data collection beyond the standard product?What additional functionality is provided?Are there any good references showing why a company would purchase this?

I’m working on a Report to pull in AR invoices for a specific G/L code, but I am getting double results.  I think it is do to SO-Invoice and AR-Invoices sharing the same ARTran record.  What is a good way to limit this.  In the report I want to see each line for the invoice where that G/L account is used, so I know I can’t group by the AR number. 

I’m trying to automate some reports to run weekly, however, these reports are not appearing within the drop down list, even if I search for them. Is there some setting I need to check on reports in order for them to appear within the Automation Schedule Tab?

We are using the contacts tab under projects and noticed that the phone number pulls in without any dashes. Even though this pulls directly from the customer contact, which shows the number formatted correctly, for whatever reason the formatting does not pass through to the project contact tab table. See attached. Phone number shown under the project contacts tab is not formattedContact record where the project contact is pulling from shows formatting. We have the information from the project contacts tab pulling to a report and would like to have the phone number formatted correctly. I’ve tried every format option in report designer that I can think of (or found based on searching the internet) and nothing is working. Does anyone have any suggestions on how to get the correct formatting? I’m assuming having it corrected on the project contacts tab would have to be an Acumatica thing, but surely there is something in report designer I can do. How phone number pulls to our report 

Our customer uses the SendGrid plugin for marketing purposes. When a user creates a new Email Activity from a record using the SendGrid email account, there is an option to “Bypass Suppression Checks”. That option allows emails to be sent to email addresses that are on the SendGrid Suppression list which is useful for certain communications. However, that option is not available when creating a Mass Email. Is there any way to include that option for Mass Emails?This is the Email Activity showing the option: 

Sample URL https://acumatica/(W(6))/Main?ScreenId=SO301000&OrderType=QT&OrderNbr=000455&Company=C20125 I want to get the Company from the url into the row inserting event 

I’m Implementing a custom Material request note (MRN) screen. Now I need to add a custom button to Production orders screen which create a MRN based on that production order. currently it gives the Object reference not set to an instance of an object. error. I have added few if conditions to check the null values, but it did not hit any if condition. Following is my Action code  public PXAction<AMProdItem> CreateMRN; [PXButton(DisplayOnMainToolbar = true, CommitChanges = true)] [PXUIField(DisplayName = "Create MRN", Enabled = true)] protected virtual IEnumerable createMRN(PXAdapter adapter) { // Populate a local inventoryItemList variable. List<AMProdMatl> inventoryItemList = new List<AMProdMatl>(); foreach (AMProdMatl inventoryItem in adapter.Get<AMProdMatl>()) { inventoryItemList.Add(inventoryItem); } if(inventoryItemList.Count == 0) {

Using 24R1 - After creating a proforma invoice from the Run Project Billing action, we add additional services to the proforma.  When we add the non-stock item (service), the description is blank - it doesn’t populate with the description from the non-stock item screen.

Hello all,I have been facing the above error while I am trying to confirm the shipment.After successfully establishing the connection between UPS & Acumatica, under the Customers tab, I added the customer as below:and the same got updated for the customer ID. And now when I m trying to confirm the shipment it triggers the error.I would like to know what would happen if I wont any of the customer accounts under the Carriers screen?

Hi, I am trying to Import Customer Payment Methods & Cash Accounts into 2020 R2. I am trying to Import in to Customer Payemt Methods, AR.30.30.10My import scenario is not working. I just get a message that the “Items have not been processed successfully. View Name: CustomerPaymentMethod”The import scenario looks like this:  Any insight would be appreciated.Thank you in advance.

Hi, I have tab in sales order called Scope of order highlighted in below screenshot, which is not available to see in mobile application. Is there any addition setting to make is visible for mobile application ?  

Hi,I am trying to mass import notes into Vendor Activities, and I tried using 2 different import scenarios but it is not working, can anyone advise? The first method I use is as below which I import through the Vendor screen, but I kept getting error  Another method I tried is importing through screen Activities, it managed to import successfully but nothing is showing up in my vendor Activities: If anyone had any experience importing notes under Activities, your assistance is greatly appreciated, thanks! Regards,Chern

Hello all,I have been working on integrating the UPS with Acumatica and while trying to confirm the shipment in sandbox the following error is triggerred:How to resolve this?

In Haufe X360, when I apply a discount to an item (inventory item), a discount is automatically applied to the freight as well (on the receipt). How and where can I disable this?

Hello all,Have been wondering as to how we can get the tracking number/URL inserted in the shipment screen. I have a UPS integration setup in sandbox and now I am looking out for steps where someone could let me know how Acumatica could directly fetch in the sample tracking numbers/url from the end user’s UPS account.   Thanks a lot in advance.

I trying to create a new Action on the Appointment screen. when I add the following code it to the graph extension it gives following error messages. But i have add the dll references to the project.Reference to type 'PXBqlTable' claims it is defined in 'PX.Data', but it could not be found   customization packageReference to type 'IBqlTableSystemDataStorage' claims it is defined in 'PX.Data', but it could not be found   customization package public PXAction<FSAppointment> CreateMRN; [PXProcessButton] [PXUIField(DisplayName = "Assign", Enabled = false)] protected virtual IEnumerable createMRN(PXAdapter adapter) { bool isMassProcess = adapter.MassProcess; Base.Save.Press(); PXLongOperation.StartOperation(this, delegate () { }); return null; }when I am investigating the issue, changed the DAC name to FSAppoinment to ARInvoice then it works.I delete the PX.Data.dll from the bin