Learn
Learn
Support
Support
Product
Community
Partners

Community
Discussion ForumsFinancials 1094 Distribution 1151 Manufacturing375 Construction358 CRM33 Field Service154 Retail-Commerce290 Payroll137 Low Code | No Code Customizations or Integrations73 Develop Customizations1589 Develop Integrations with Web Services | APIs338 Other Developer Topics63 ISV Solutions 96 Configuration and Installation 491 Reports and Generic Inquires 1038 Import and Export Scenarios 412 System Health and Performance 86 Community site discussions139 Community Introductions63 Everything Else 521
News & AnnouncementsAcumatica News & Updates86 Developer Newsletter 19 Newsletter 26

Create topic
Login

Community
Discussion Forums

Discussion Forums

Get inspired and gain all the knowledge you need

8501 Topics

Recently active

Most replies Most views Newest first

FarhanaM60Freshman I

asked in Distribution

StockItems screen to update Default Price with some UDF's Addition Values

Hello, I have added Three UDF’s and UDf’s Addition values am assigning in Default Price of Stock Item Screen Please Help me with the SolutionThanks,Version-22R1

1 day ago

nperez94nawFreshman I

asked in Distribution

What is the link field between ARInvoice and ARDunningLetter?

I have queried both tables separately but can’t find anything that matches between the two.Thanks for your help

1 day ago

DjangoCaptain II

asked in Develop Integrations with Web Services | APIs

When is the Location header returned via REST?

We have some heavy customizations around Sales Orders and we also have Avalara integration. When the Sales Order is saved, it can take a few seconds to save the order. When I add an order via the Rest API, I don’t receive back a Location header like I would when I call a Release action, for example.My question is: Is there something I can do to make Acumatica return a Location header when saving (PUTting) a Sales Order via the Rest API?

1 day ago

frankfiorentino81Jr Varsity II

asked in Field Service

Field Service Appointments 'Tax is not up to date' Message

I have a client that is testing 2022 R2 and on the appointments screen of field services, they are getting the message that Tax is not up to date however tax is recalculating. This message does not disappear when saving the appointment but when this message appears on the service order, it disappears with a save. I did not see a known issue for this but could have missed it. Anyone know why this is happening?

1 day ago

jwarrenJr Varsity III

asked in Reports and Generic Inquires

Calculating on GI for Sales Orders

Trying to modify the Sales Order GI so it calculates partial price (ignoring or subtracting one of the line items on the Sales Orders). Is this possible? Example:SO100038 - Total Order Price of $10,000Item A $2000 Item B $5000 Item C $3000 In my GI, I want to display an adjusted price column that is calculated by taking total Order Price - Item C Price resulting in an adjusted price of $7,000 per this example. I can perform joins to bring in the SOLine detail but not sure how I would be able to subtract the correct line item? Any thoughts?

1 day ago

dsimone20Freshman I

asked in Manufacturing

Change Config Key Format While Copying

We have a client with a configurator with lots of attributes. The key format is currently set to Formula. There are so many attributes, they want to change to a system generated key format to be more usable. But when copying an existing configuration, there isn’t an option to change the key format on the newly created configuration. Does anyone know of a way to change the key format either on a new or existing configuation?

1 day ago

phillipmarottaFreshman I

asked in Configuration and Installation

After upgrade to 2022 R1, get error that Employee is not a user when trying to create a timecard. Is the requirement not that we have to create an user for all Employees?

After our upgrade to A2022 R1, users are cannot create a Timecard for employees that are not setup as users. We have the delegate assigned. Error:Error: An error occurred during processing of the field Employee value 000001562 EP Error: The employee record is not associated with a user.IF this is the requirement, then this seems will cause major business process changes to enter time for employees associated to projects that are not users.

1 day ago

ElliotCFreshman I

asked in Develop Integrations with Web Services | APIs

apickard5Freshman II

asked in Field Service

Integration of Field Service with Project Accounting - Construction

Hi all,I am trying to figure best way to handle the following.Let’s assume that a new Project (related to construction edition with Progress Billing) is opened to manage the installation of HVAC and electrical installation. This project needs to monitor both costs related to equipment and labor. It would be ideal when new equipment is to be delivered and installed on site, a Service Order and related appointment is created to manage both the issue of the equipment from store to site and also to manage the time it takes to install the equipment and employees who are doing such service and capturing all related costs directly on the Project. The question I am trying to resolve is how best to record the issue of equipment and capture all costs on the Project as there seems to be 3 possible optionsThrough a Sales Order linked to Project - Seems strange and not logic to use this especially since billing of both equipment and service will be done directly through the Progress Billing functi

1 day ago

donnadeskins55Jr Varsity III

asked in Distribution

Testing UPS integration in 2023R1 sandbox

We have a customer going through upgrade testing for 2023R1 and they are receiving the error below when trying to confirm a shipment: This is what the configuration on the carrier looks like (and testing the connection was successful): Thanks for any assistance!

1 day ago

ramya15Jr Varsity II

asked in Import and Export Scenarios

Required Import Scenario template for Project Transactions

Hi Team,Does anyone have have import scenario template to import “Bills and Adjustment” transaction to Project Transaction screen. Please help me on this. Regards,Ramya Krishna

1 day ago

Malinda278Freshman II

asked in Financials

Customer statements

Just getting used to the what seems incredibly formal statement process (for a small company anyway). I ran the statements for a period and forgot to enter one receipt of money from the customer, how do I re-run the statement to include for this extra money received on the last day of the month. It all feels very locked in and unwieldly to me as I am used to just re-running a statement as many times as I like. Best Regards Malinda

1 day ago

lightmanFreshman II

asked in Configuration and Installation

Hosting Acumatica PCS on local server

My company previously had Acumatica PCP license, and we had to change to PCS because acumatica stopped selling the perpetual license. Now, our acumatica country agent is insisting that we move to AWS because PCS cannot be hosted on local server. I found multiple online sources saying that both PCS and PCP licenses can be deployed anywhere, on-premises or in a private data center, depending on your preference. But I still wanted to confirm it Can we install acumatica PCS on our local server?

1 day ago

pchappell19Freshman II

asked in Everything Else

Mobile Users - Restricting information based on individual users...

Is there a way to restrict information mobile users can see? For example, (with project/job costing) can a project manager only be presented with his/her specific jobs, cost codes, etc. and not the entire project/cost code, account groups? In particular, asking this in regard to Advanced Expense Management mobile users who would select the appropriate project, etc., after OCR has run?Of course, this would apply to other mobile users who need to interact with manufacturing, distribution, etc.

1 day ago

SanthoshB09Freshman I

asked in Reports and Generic Inquires

How to create a GI to show Qty on Hand and Sold Qty

Hi Team,We have a requirement where we have to create a GI and have to show Qty on Hand across all warehouses and Sold Qty (Qty across all released Invoices) for stock items. We created a GI and for all new products it is working fine but for existing products the values are incorrect. I am attaching the created GI, can you please review and suggest the best way possible to achieve it.Thank you!

1 day ago

abdulmuksithshahul61Freshman I

asked in Distribution

Vehicle Tracking

I own a manufacturing company. I uses vehicles on (own, rental, contract) basis. I delivery my goods to different logistics area through vehicles. my question is can I able to track my vehicle and also diesel usage ?

1 day ago

sagar07

asked in Develop Integrations with Web Services | APIs

How to get count of records while executing any webservice within Acumatica while executing API in postman

Hi Experts,I am currently working on integrating with Acumatica and I have encountered a situation where I need to retrieve the count of records while executing an API from Postman.I have a few questions regarding this: Is there a solution to obtain the count of records in Acumatica through the API? What is the purpose of the "$expand" key? Is there an alternative way to import all inner nodes without explicitly specifying them using the "$expand" parameter? How can I determine the "Data Type" of a field when retrieving the schema of an object within the Acumatica system from Postman? I would greatly appreciate your assistance.

1 day ago

sd79Freshman II

asked in Reports and Generic Inquires

Amount In Words for Trillion Number

We do not have any facility in Acumatica Reports to convert Amount In words for Trillions.Eg : 5235460235892.85Amount In words : five trillion two hundred thirty-five billion four hundred sixty million two hundred thirty-five thousand eight hundred ninety-two and eighty-five hundredths. Do we have any solution for this In acumatica ?

1 day ago

FoujanJr Varsity II

asked in Financials

Australian Diminishing Value Depreciation method

Hi, We are trying to use Australian Diminishing Value in Fixed Assets, however system forces us to use ‘useful Life Year’.This method is only capturing the place-in-service date, the cost and the percentage per year.So it does not make sense to have years against each asset, as it’ll change the method. Can someone assist and let me know how you imported your assets using this method? Thanks,Foujan

1 day ago

param2022Freshman II

asked in Reports and Generic Inquires

Combine report for multiple sales order

How can we combine all the sales order report (so641010) within a specific date range. I want to merge so641010 report based on a date range on order date. If five order are placed on a particular date I want all 5 report for individual sales order (so641010) to be combined in a single one. Any ideas how it can be achieved ?Thanks

2 days ago

chidao

asked in Construction

Project - How to set different currencies on Project Currency & Billing Currency

Hello All,We are a trading material company. We buy materials from different countries and sell them in our based country. On the Construction/ Project function, we type Cost Budget as the sourcing country's currency (usually in USD & EUR) but the Invoice must be issued in based currency (VND).When trying to set Project Currency = USD, Billing Currency = VND, the error message from the system shows “Another billing currency is not supported because the project currency USD differs from the base currency VND.”Therefore, we can't use the different currencies on Project Currency & Billing Currency.Really appreciated it if you have any ideas for this case.Thanks all,Yên Chi

2 days ago

jeffgrammer69Jr Varsity II

asked in Develop Customizations

Visual Studio not finding referenced component

I am trying to Build and compile a customization in Visual Studio 2022 and it is throwing warning messages that it cannot find any of the PX DLL files that are in the referenced folder. Other DLL’s I am referencing are found in that folder, just none of the PX DLL files.Does anyone have a hint, suggestion or idea why only the PX DLL’s are not being referenced when OTHER DLL’s I am using are being found?Here is a screen shot of the folder and the VS 2022 warnings.

2 days ago

Page 3 / 341

Badge winners

kdavis45has earned the badge Reports and Generic Inquires expert
tfarwell11has earned the badge Easy talker
jon95has earned the badge Innovator
Foujanhas earned the badge Easy talker
Fiehas earned the badge Easy talker

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

About Acumatica ERP system

Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.

Privacy Policy
Terms of Use
GDPR
SLA
Support
Report an Outage