Discussion Forums

I need help to add a new column in the AP301000 Transaction Details grid. Column Name: PCV Number  

I want to join the tables together to have the following information: Customer | Project | Type Activities 1 customer can have multiple projects, and 1 project can have multiple activities. Activities are associated with both Customer and Project.  That means my table Activities must contain 2 primary keys, the customer ID and the project ID.  I found the CRPMTimeActivity DAG table that meets the conditions, but I can only see it in the generic inquiry and not in the database.The report I constructed is based on a complex logic involving three tables: Activity, Project (PMProject), and BAccount, so I need to process data in SQL Server before uploading it into Acumatica to create a new DAC. I just saw CRActivity, but in this one, I didn’t have a Project ID, so it caused duplication when I tried to join the project table (PMProject) with CRActivity. Because CRActivity has no ProjectID (ContractID).  Does it have any other name to call in the database or what can I do or will you update i

Early last week, we started receiving the following error message when adding revenue lines to a new project. Here’s where it gets weird. We have a lower-level permissions set for the majority of the users that create new projects and enter the revenue lines, they are still able to do this without receiving the error. The error is only being received on the higher-level roles, including Admin., and it is only happening when creating the first line. If we have someone with the lower-level permissions go in and create the first line, the higher-level role can then go in and add any remaining revenue lines. Any ideas what could be causing this and how to fix? We have already cleared our browser history/cache, and tried utilizing several different browsers, each providing the same result. We are on 24R2.

For example if I were to create a shipment for UPS Express or Two Day Air, the return label would be UPS ground regardless? Is this something that is possible to do?

I have OrderQty, totalConsumedQty, and MaximumOrderQty. Orders are being placed in parallel. Each order reads the current totalConsumedQty, adds its OrderQty, and checks if it exceeds MaximumOrderQty. When multiple orders are placed at exactly the same time, they all see the same original value of totalConsumedQty, and each thinks it’s safe to place the order. Result: totalConsumedQty is exceeded because updates are not aware of each other. Updating totalConsumedQty is happens while Saving, It is required

Hi,Is it normal to have twice row with the same keys combination?Do I miss something?Thanks 

 Has anyone used IN or BelongsTo?  I’ve tried both in this format and returning no results.     

We’ve had issues lately with Business Events firing late (10-15 minutes delayed).  I’ve been told to look at the System Queue Monitor screen to see what’s going on, but this shows me almost nothing.  I have the three queues at the top (Push, Business Event, Commerce).  The bottom panel shows nothing.  Initially I didn’t have the Log Trigger Details checkbox checked, but that is checked now (with the “Keep Stats” field set to 2 days) and I’ve since restarted the system as well--still nothing shows up.We do have a processing node, but I don’t see anything useful in this screen on either that or the user node.We are SaaS; do I also need to have Acumatica enable anything on the server side?

I have a stock item in a warehosue that is dead. This item has a negative position, I just need it to go away, everything is under Account 1260. I thought I could just adjust in the missing inventory and dollars to get a net zero permission.The item has the following Account:  The posting class has the following Account:  I made the adjustment for the negative units and costing, but it’s going to account 1120, not 1260 as specified above. Is there another place overriding this account that I’m missing?Batch info below showing the erroneous 1120 post from the adjustment:   Thank you for helping me dig into this!!!!

 Hello,Is it possible to use project attribute fields to calculate our project purchase order (PO) balances? I’m trying to sum the ORIGINPO and COPO attributes in one GI column. In a separate column, I attempted to subtract this sum from the project billed amount. However, I received an error stating:“The virtual field originpo_attributes cannot be used in a condition expression.”  Is there another method I should use to achieve this?    

We have modified the Project WIP Detail Report to 1. be less information and 2. to have the Period Costs linked to the Project Transaction Details page that when clicked on, will bring up the transactions associated with the Cost Code. However, it does not filter them the same period as the report and instead, just provides us with all the transactions within that cost code. Is there a way to add a filter within Report Designer to make it so this hyperlink shows only the transactions that are being referenced in the report for the period selected?Thanks! 

So it appears we have to create a fully licensed user in order to add an email account to Acumatica.  This seems to be a bit of a problem for us because who is going to manage the accounts password and MFA codes.  Especially the MFA codes.  I assume at some point Acumatica is going to lose authentication with the email account and want to authenticate again.  Who gets the MFA code? We were told that it should be an administrator, but what if that’s only one person? What if that person is sick or on vacation.  To me the right thing to do is to create a NoReply email and use a connector in exchange.  What are the rest of you doing?  IDK, the way Acumatica is doing this is weird to me.  I’ve never seen any of my other systems do it this way.

I turned on subaccounts today and now it sees like employees can’t create purchase orders. I wish I had an example of the error I just know that when I disabled subaccounts it fixed the issue. I don’t get that error in my test tenant but I’m wondering if it is because the purchase order was already partially created?Has anyone have experience with this? I know it’s a very vauge problem I apologize.

Client has just noticed the PM301000- Cost Budget tab - when the Group by Task box is checked, a popup error message appears “GetItemExtension Failed”.  The client states this function has previously been working for them. They had an update 3/27 from 24.114.0020 to 24.116.0026, but that was almost a month ago, so I am not sure that is a cause, I do not see anything in known issues for 2024 R.1 for this screen/error message. 

Is it possible to rename a web service endpoint without recreating it?I attempted to export the endpoint in a customization, modify the name in the XML, and upload the customization, but the customization screen errors on upload with “Error during file upload: Object reference not set to an instance of an object.” Any suggestions?

Using v25R1 and following the steps to create a Power BI integration (not Power BI Embedded).  I have the external application (SM301000) connecting and I see a Token.  When I try to create the Power BI Application Resource and try to search for the External Name, I get “The remote server returned an error: (401) Unauthorized.”.  I’ve set up the Power BI Service (Dashboard, Dataset, Report) in the API permissions section of the app registration.Other insights?

I updated our current pricing in through a sales price worksheet.  When creating a sales order the price is correct however, when we create an opportunity the pricing is not updated.  How can we resolve?

Hello all,I have an SO created with non stock items, and I dont know how bt the invoice for the sales order got created automatically. It has the below status:The Shipments tab → Status: Auto generated.

I am currently writing logic to automatically create move transaction records from the materials screen. Currently the records are being created successfully via code but when I try to release the move transaction automatically I get the following error: “Parent Lot/ Serial Number is required.”But on creating the move transaction automatically the parent lot/ serial number is being correctly assigned as below:using System;using System.Linq;using System.Collections;using System.Collections.Generic;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Objects.Common;using PX.Objects.Common.Exceptions;using PX.Objects.IN;using PX.Objects.CM;using PX.Objects.CS;using PX.Objects.AM.Attributes;using PX.Objects.PM;using PX.Objects.GL;using PX.Objects;using PX.Objects.AM;namespace PX.Objects.AM{ public class MaterialEntry_Extension : PXGraphExtension<PX.Objects.AM.MaterialEntry> { #region Release Override public delegate IEnumerable ReleaseDelegate(PXAda

Hi all,We have a fairly modified Invoice (so643000.rpx). We recently upgraded from 23R2 to 24R2, and we’re now having an issue printing so643000.rpx.The issue -- with international invoices, we had a template (IIRC) to remove 0.00 zero dollar value line items. Our AR gal would go to Print Invoice, edit/pencil, select template, done.Now when she edits, she sees “no data available” so I’m thinking ok, the old modified invoice probably got overwritten, maybe I will pull from a backup. Then I thought wait, I will just pencil/edit and check the versions, maybe there’s something in there I can use.So when I go to print, and then pencil/edit, I get a permissions error:So I dive into access rights and notice this:I'm already granted access. But the confusing thing is why are there only two levels (revoked/granted) vs the usual view, edit, insert, delete etc?And also -- those access rights are for Invoices, not so643000.rpx… I’m not even sure where I would set rights for reportsAny thoughts app

Hi,I have added user-defined fields to the Sales Order (SO) screen. In our client’s business process, user create BL order type Sales Orders, and if the user enters values into these user-defined fields, they should be copied to the child orders linked to the BL order without duplicating the data insert work. Kindly help me to fullful this requirement.Thanks/Prasad

Has anyone else been experiencing significant issues with MRP in 24R2 (particularly 24.211.0024)?Could not create production orders from MRP - fixed by upgrading to 24.211.0024 MRP recommending incorrect action dates - fixed with hotfix Overhead calculations incorrect causing a workaround to be applied - unsolved, waiting on Acumatica RnD team (not MRP related but thought I’d mention this also) MRP recommending too many orders due to the system subtracting (1) from every existing order already on the floor (basically, the system does not even see an open order for qty 1 of a part, if qty is 2 it only sees 1) - unsolved, waiting on Acumatica RnD teamThis last one has potential to cause significant disruptions for our business due to MRP recommending too many orders, causing confused priorities on the shop floor and creating false late orders.

is there a PO line limit in Acumatica, as i wanted to add thousand lines in there.

Hi everyone,I have item1 at location A and B.A has 100 pcs. It is the primary location and where most orders are picked from.B has 1000 pcs. B is considered a overflow location, but sales are also allowed from this location.If I get a big order for 1000 of these pcs, could Acumatica just tell me to take 1000 pcs from B and 0 from A. What it wants to do now is take 100 from A and 900 from B. Then we would need to transfer the remaining 100 to A to maintain primary location stock.

I have had some email accounts set up in the system for a while using OAuth with each email account using its own external application connecting the Acumatica instance to our Entra ID tenant. Soon we will need to set up business events to send email notifications out to users and so far they haven’t been sending the emails out. I’m not sure if it’s my email account configuration or my business event/automation schedule configuration. The only thing I’m not sure of that could be causing a problem on the email side is that I wasn’t sure if I needed to sign into the external applications using a 365 global admin account or a 365 user account and the same for signing into the email accounts.