Discussion Forums

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.

Create Shipment import scenario was working in 23R1 but gets an error in 24R1. The error message is “Another process has added the 'SOShipmentCarrierData' record. Your changes will be lost.” The Add Order function works in the UI but I have tried everything to get an import scenario to work to no avail. Here is what my current scenario looks like: Any Ideas would be appreciated.

Hi Team,The issue is that they are trying to create a service order from schedule #FSC00036400. By using the following screen: 

Hello all,Is it possible to display all the projects irrespective of the statuses in the payments and applications form?

After pushing images from acumatica to Shopify, I deleted the image in shopify to test a re-sync. It failed to push out the image and gives me the following.   After that I can’t get the images to resynch correctly even with a full prepare and process. It there a way correct this? also how are others managing multiple images with matrix items and variants? 

When trying to hit the ‘+’ button on Vendors screen, a pop-up with following error message comes up:Error: [DiscTakenSubID] '00000 ' cannot be found in the system. Please verify whether you have proper access rights to this object.Don’t know what that means. If anybody knows anything about it, or anything similar, please reach out.Thanks

Hi all,I have searched high and low for this but cant seem to find an answer.Is it possible for a direct vendor return without the item returning back into our warehouseHere is the scenarioCustomer orders item, item is fault, vendor says they will pick it up from the customer, I will credit the customer and the vendor will credit meIt appears to me that I can only create a customer return to bring it back into stock and then a purchase return to send it back to the vendor so the item does look like it was returned to my warehouse at some point when it was not

hello, i'm trying to implement the authentication, i want to check the feasibility of connecting an angular client to acumatica if is possible i want to get solution.Best regards. 

Does anyone else do floorplan with their vendors?  For those unfamiliar with the term, we purchase equipment inventory from our primary vendors, and we do not pay for the inventory until either the inventory sells, or the vendor financing expires.We have a working solution, but we’re hoping to find other companies that are also doing it to compare notes.