Solved

I want to upload excel in the Purchase receipt screen in the document details tab but when I allow the upload from the grid in the in the screen customization the upload button is disabled and the solution is adding Pximport to the graph before the view  but I do not have the graph in my customization project because this graph is default in the website

How to clean inventory transit expired from item plan or can receipt it

How do we set up the Acumatica Payments Customer Portal?I have reviewed all the posts I can find and none of them provide step-by-step instructions on how to set up the Acumatica Payments Customer Portal.  Where do I find this Company Portal? 

How do I hide the "Files" and "Notes" columns in a generic inquiry? I don’t mean removing default visibility, I mean suppressing them from the results grid altogether.I have an inquiry related to certain employee attributes that I want all users to be able to see, but I don't want them to see notes or attachments we've placed on employee records. The inquiry is allowing this even if they don’t have access to the underlying records.I looked for a different table join that would marry the PX.Objects.EP.EPEmployee and PS.Objects.CS.CSAnswers tables without using the NoteID/RefNoteID fields, but I couldn’t figure out an alternative.

I’m trying to convert a BA to a customer in the import scenario screen. I received an error that said “edit customer”.. I only had the businesss account id  and then the action to extend as customer. Can anyone tell me what I'm doing wrong?

Hi Team,In the AR module, our invoices have a "Quantity" field populated. Could you please advise how I can download the quantity data for all invoices within a specific month?I have not been able to find a download solution. Thank

Hi, Is it possible to identify duplicate entries through a generic inquiry, If possible could you please provide a quick guide to detect the duplicate. Example - Customer order number in the invoices and memos form can be duplicated. I need to generate a generic inquiry which picks only the invoices with duplicated Customer order number.  Thanks,Dulanjana 

Acumatica has a built in function to “recalculate” various balances such as vendor and inventory.  We have been live for eighteen months and have never run these “recalculate” functions.  Recently, we noticed an error in our inventory and our VAR suggested we run the “recalcuate inventory” function. We ran the fuction and it fixed our error.  My questions is should we run all of these “recalculate” functions regularly such as monthly or quarterly?  Is there any harm in running these recalculate funtions more often?  

Greetings, I am trying to work though something, but I am hitting a bit of a wall. This is the request of a client. They have a simple AR tran inquiry but instead of pulling all the records, they only want to pull the most recent ar tran line per customer. It needs to be accurate for that line, so I can’t do any grouping since the values don’t generally fall within the min/max/average solutions.

Hi All,We are trying to provide an access to a customer, to our internal ERP as we cannot enable Customer Portal due to Multiple base currencies feature been enabled.The approach we are trying to execute is to create an external/ guest user who will have access only to a specific customer related cases with view only access to their cases.When restricting the access i have created a custom GI which was derived from the cases GI CR3060PLHowever, if i revoke access to cases form i do not have access to click the custom GI lines and view the cases in CR306000Is there any possibility for us to only give access to the custom GI and perhaps hide the CR3060PL (Cases) from the customer’s user?Thank you all in advance for your support!

Can Acumatica handle tracking Leave Without Pay?  I need to track the hours but the pay is 0.00. I setup an Earning Type for this and added it to my paycheck test in Paychecks and Adjustments.  I was able to add the earnings detail line with hours and set the pay rate to 0.00 however, during the Calculation process, Acumatica removed the line.  Any suggestions? Thanks in advance!

What is the best way to track items issued out of inventory to an internal project for accumulation and capitalization to fixed assets? Here is the scenario I tried to do but received an error when creating a fixed asset.Added the fixed asset clearing account to an asset type account group Created an issue reason code to the fixed asset accrual account Created a PO tagged to a project and task Received the item into inventory (we use items from inventory for external and internal projects so steps 3 and 4 may not always occur) Created in inventory issue transaction to the project Capitalize the project costs to a fixed assetWhen creating the purchasing transaction in fixed assets, I get the following error:Error: Inserting 'GL Transaction' record raised at least one error. Please review the errors. Project is Required but was not specified. Account '14900' used in the GL Transaction is mapped to Project Account Group.The problem is I do not see a way to enter the project information in

Our client is using the ShipStation integration with Acumatica. However, we’re noticing that when the shipment is completed in ShipStation and it writes back the shipment info, it is updating the shipment to the wrong Ship Via.Example:In ShipStation, the ‘USPS Parcel Select Ground’ option has been selected: And in Acumatica under the SHIPSTATION INFO tab of the shipment, this method is correctly recorded: However, on the SHIPPING tab the Ship Via has been incorrectly changed to ‘UPS GROUND’: This is causing issues downstream as Shopify thinks the shipment is via UPS but the tracking number is for USPS.Anyone know what might be going on here and how to fix?

Hi,I am trying to close financial period, but there was an error stating: GL Error: The 09-2025 financial period cannot be closed in Accounts Payable.I have checked unreleased documents, but I can't find anything unreleased.  

We recently transitioned to Acumatica and have so issue with ggetting the credit card feed to work. Our company uses Royal Bank Credit Card (Commercial Visa Avion Cards) and we manage these cards thru Visa Spend Clarity Enterprise platform.  We are currently still using Concur Solutions (SAP) because we are unable to connect the credit card feed with Plaid or MX or via SFTP server. Does anyone have experience with Royal Bank and their credit card feed thru Visa Spend Clarity. We have about 50 cards and spend over 250K per month on them so the feed is very important to us. Thanks for your help Bruno

Hi! Is there a way to pull activity notes from the PO screen into a GI?I wasn’t able to use inspect element to find the table that the Tasks & Activities belong to. I know activity is on the CRActivity DAC, but I couldn’t relate it to the POOrder table. I know there is a Note ID field in POOrder, however I am looking for this column in the GI to display the actual body of notes instead of just the title or the note ID. Any idea if this is possible? Thanks!!

We currently have our sales order types set to pull from the Customer Location for the “Combine Sales Sub From” setting (so it’s set to LLLL).  We are setting up a new sales order type that we’d like to hard code to a specific subaccount, instead of telling it to pull from somewhere.There are plenty of places to pull the subaccount from (and we use almost none of them), so I could plug it in on the warehouse or even the inventory item and pull from there, but if I am able to plug in a specific subaccount in this field, it would make it even easier.

Hello! We have 15 different locations that need to be set up under one company and we are thinking of either setting them up as 15 different branches or as different subaccounts. Any best practices or pros and cons for doing either branches or subaccounts?We are open to any suggestions!Thanks!

Hi there!  I saw a post on this topic from 2 years ago so looking for a refresh.   We do not use inventory...most of our projects are special order.  That said, we palletize materiala and put them on racks in our warehouse until we can ship them to the job site.   We have a new warehouse assistant.  He would like us to get a printer to print these labels….I am assuming we should also get the capability to read barcodes.  1) Any ideas based on the situation I just described 2) what has everyone else had success with  3) what am I not thinking of :)  Thanks in advance! 

Hello! I am looking to change our inventory ID to our Vendor ID on purchase orders. I’ve seen it done using the alternate ID field but I’ve seen it done with comparing tables and using different techniques. Is it that difficult to do? Please help!Brent

Can anyone point me to resources to easily (low-code/no-code) add a new tab to the Customers area (AR303000)? I’d like to create a tab for some UDFs so I can better control the field grouping and display. I know I can do this through Customization> Manage User-Defined Fields, which adds them to the User-Defined Fields area at the top part of the screen. Is there an alternate way to configure a new tab to house these UDFs? Idealy the new tab would be on the same level as “General; Financial; Billing.”   I noticed that when I was in the customization project choosing ‘add controls’ that I couldn’t get the screen to respond when I chose ‘Tab’ from this list. Thank you for any ideas, it would be ideal to have a separate tab, but if that is not possible without development they can live in the User Defined Fields area.  Version/Build:Acumatica Cloud ERP 2025 R1Build 25.100.0054 +

Bad title perhaps; I’m not an accountant, but they’ve asked me why and I don't know.Not sure how to explain this since, but basically they’re saying somehow the transaction was processed with negative GST.  In the Journal it shows the #’s reversed for this 1,149.91 All others look like this (Debit left column, Credit right): There’s hundreds as above, but this one below the values are in the opposite accounts and no one appears to know how this happened (including myself):  Anyone able to please enlighten me on what may have gone wrong? 

I’ve built a dashboard for our sales manager which shows quarterly information as well as YTD information. Now that it is 2024, I want to provide the ability to toggle between current year data and prior year data. Is there a way to do this with use of an added parameter? The widgets currently pull information based on Order Date is between @YearStart/@QuarterStart, @YearEnd/@QuarterEnd.   

Hi Community  I would like to Pass the channel Information as Text from Shopify to Acumatica. I created a UDF Field in Acumatica, could you please some one help me with the Importing Mapping? 

Good morning community! I need a formula that dynamically changes a date range to “Last week’s date range. I want the widget that I have to always be displaying data based on last week.Any help is appreciated…