Discussion Forums

I have an import scenario for projects and it is erroring on “Country” cannot be empty. I have tried several settings on the Address fields, including the following setting and it will not allow the import. It is requiring the project address country to be filled in. I have also tried using the CountryId=US On the task setup, if there is one task for each project what is the best way to add that task to every project created?

I love that there is now an option to adjust for PTO adjustments that is separate from Paychecks and Adjustments screen. However, I just entered a bunch of carryover adjustments, and it does not update to the user profile screen under the Dashboard. Is this a glitch? Something that will need to be updated by Acumatica to reflect real time PTO balances? It appears that they reference numbers that I see are related to PTO adjustment are not being reflected in the User Profile screen. Any ideas? 

Is there a way to title box 14 to read FAMLI when showing on the W2? It’s showing as box 14 other right now.

Has anyone enabled staff to purchase additional leave through payroll?

We have an employee that was on leave for a few months and is now back and I need to create a new time card for this week.  When I go into Time and Expenses, and Employee Time Cards and pick this employee, it only allows me to create the next time card after the employee went on leave.  Surely I do not have to create each time card individually until I get to this week?  

The PTO bank accrues the hours correctly; however, I am trying to configure the system to also accrue the amounts and create the corresponding entry in Journal Transactions.  Does anybody have a suggestion on how to do this?  

Acumatica will only allow us to add 10 payment methods per customer. This is an issue as some customers have more than 10. All of them are not active, but even if a payment method is inactive, it cannot be deleted if it was used on an invoice.

For some reason our RefreshToken is always expiring after 24 hours. Regardless of what we set in Connected Applications settings. We are using Resource Owner Password Credentials and RefreshToken is set to Absolute expiration 30 days. Our Acumatica version is: 2024R1 and installed locally. Any help is much appreciated

hi!we have a prospect who’s current POS system is lightspeed POS and they are looking to make the switch to acumatica.  I was wondering if anyone else has any clients who use lightspeed pos and was able to successfully integrate with acumatica. I would love to hear your experience and what challenges you faced.  

Hello, We have recently started using Shopify for both ecommerce and point of sale. We have several products that we want to ONLY sell at the POS and not online. It is my understanding that the Export to External check box is what syncs the products over to Shopify, and then the Visibility is what has it show up on the sales channels within Shopify. Our Store Default is Visible and Set as Available (Track Qty).   When the product syncs over with this format, it becomes available on all sales channels. We have manually (using bulk edit within Shopify) removed products from certain channels, like the website. However, we have noticed that when a product resyncs, since the visibility is set to Visible, it turns the product back on for all channels. Is there something within Acumatica we can set to prevent this from happening or assign it to the channels we want to be active?  Thanks in advance!

We are trying to  Extended DAC Fields in the Customers screen GL accounts tab classic to Modern UI .DAC has 1 extended fields need to display it in the modern UI Customers screen GL accounts tab.  tried with below code, Unable to see fields in Modern UI, below screenshot red marked field need to display it in the modern UI Customers screen GL accounts tab. DAC Typescript import { AR303000, Customer2 } from "src/screens/AR/AR303000/AR303000";import { PXFieldState, PXFieldOptions } from "client-controls";export interface GLAccount_customfields extends Customer2 {    UsrPSOCogsSubID?: PXFieldState<PXFieldOptions.CommitChanges>;}export class GlAccount_customfields {    UsrPSOCogsSubID?: PXFieldState<PXFieldOptions.CommitChanges>;} HTML <template>    <field after="#columnFirstGlAccounts [name='COGSAcctID']"           name="UsrPSOCogsSubID"></field></template> When Switched to Modern UI getting below error see in screenshot 

We are trying to  Extended DAC Fields in the Ship via Code screen Details tab section classic to Modern UI .DAC has 2 extended fields need to display it in the modern UI Ship via Code.  tried with below code, Unable to see fields in Modern UI, below screenshot red marked field need to display it in the modern UI Ship via Code  screen Details tab section. here am sharing the DAC And Modern UI TS and html filesDACTypescript import { PXFieldState, PXFieldOptions, PXView } from "client-controls";import { Carrier2 } from "../CS207500";export interface Details_customfields extends Carrier2 { }export class Details_customfields {    UsrNAWFreightAccrualAcctID: PXFieldState<PXFieldOptions.CommitChanges>;    UsrNAWFreightAccrualSubID: PXFieldState;}HTML <template modify="#tabDetails">           <field name="UsrNAWFreightAccrualAcctID"></field>        <field name="UsrNAWFreightAccrualSubID"></field>   </template> 

I have an attribute that we created a while back and until recently users were fine with having to go to the Attributes tab on the contacts screen to see the attribute and its value. I now have a request that seems simple enough, which is to make it so the attribute shows up at the top of the Contact screen right under Status. The attribute in question is a combo box attribute with some values that the user can select from. I open the customization project for the screen in question (302000) and go to the Add Data Fields and I can see the Attribute field in question under that All section. is isn’t visible in the Visible or Custom views.  Not if that is significant or not.  When I highlight the field and click the Create Controls button I get an error that says “No fields are selected” which is preventing me from adding it to the Form Column. Not sure if I am trying to do something that isn’t supported but it seems like a simple enough type of customization. I don’t even need to be abl

Hello! We are required to import Sales Orders from the Shopify site, but we are not required to create Payments on Acumatica through Shopify and create payments manually at the end of the month comparing the statement. Will it be possible to import only the Sales Orders and will there be any impact on not importing the payments? Thank you in advance!Amanda

Hello Experts,      I described this problem in another post, but due to time constraints, I didn’t explain it clearly enough at the time.The goal was to quickly find a workaround at that time. Now that we have a workaround, I hope more experts can help identify the root cause. Below is a detailed description:Background:We recently upgraded from 2021r2 + Windows Server 2016 + SQL Server 2016 to 2024r2 + Windows Server 2022 + SQL Server 2022. The 2023r1 version appeared as an intermediate version during the upgrade process. Our site has 3 tenants, all using the exact same PO3020PL. Two tenants can normally display PO3020PL and load PO-Receipts for editing on the generic inquiry page(SM651700). One tenant encounters the following issues: Directly accessing .../ScreenId=PO3020PL results in a timeout prompt. When editing PO-Receipts on the generic inquiry edit page, once a selector is used to select a PO-Receipt, the page appears to freeze. For the problematic tenant, all other PL-s

Hello,       We have been Acumatica PCS users for 8 years. Our business runs almost 24/7 (7×24 hours). To ensure stability and reliability, we chose to stay on the 2021 R2 version.However, Acumatica now requires us to upgrade from the end-of-life version. Otherwise, we will be charged a Retired Version Premium.    We are currently deployed on Windows Server 2016 + SQL Server 2016. Unfortunately, 2024 R2 does not support two third-party applications.We must upgrade to Windows Server 2019/2022 + SQL Server 2019/2022.Can someone advise the best strategy for this full upgrade? Here’s our proposed plan:Provision a new server with Windows Server 2019 + SQL Server 2019. Back up the database from the old server and restore it to the new server’s database. Use the ERP Upgrade Wizard to perform a phased upgrade: 2021 R2 → 2023 R1 → 2024 R2. Then thoroughly test all functionalities and customizations. This process may take at least one week. If testing is successful, repeat Steps 2–3 (e.g., using

Hi All,I wanted to import stock items along with images in a file.Can I use hyperlink for images existing in other database to import it into acumatica?or is there a better way to import images into stock items? 

When I create variable in page header and want to use in group section or detail section, It show zero value. but if I create variable in group section and use with other section or detail section. It show value.

Can someone help me figure out why this SO is showing multiple lines for the same item? Usually when this happens it’s because ACU is needing to pull from a different location or use multiple lot numbers but as far as I can tell the line details are all the same :)  

We are trying to create an integration with Acumatica API and we are encountering issues or weird behavior when updating multiple items in a parent record.For example when we try to update multiple contacts for a customer, it won't update the all contacts but only update the first one, but the weird thing is it picks up the values from the second item to update the first item, like the contact note field of second item will replace the contact note field of the first item, we are not sure if its bug or something.Anyone experience the same issues?Here is my sample Json payload for a Customer PutEntity endpoint, the note for ContactID: 100745 will replace the note for ContactID: 100743, but will not touch the second item.Seems like only first Contact gets updated.{ "id": "01a0c017-df7f-ea11-8175-b9d61cb73193", "Contacts": [ { "note": { "value": "Note for 100743" }, "ContactID": { "value": 100743 }, }, { "note": { "value": "Note f

Hi All,I am trying to set up a push notification to a Google Space webhook. I get an error that the format is incorrect - the error is generated from Google. Google does not like the format of the JSON that is sent.Does anyone know how to customize the JSON?

Hello,  So our pricing model is a direct markup of last cost. I’ve seen other topics talking about how to use a business event to automatically update pricing based on a change of last cost. First though I need to get the last cost field correct. We use a FIFO costing method for reference. Essentially, I want to be able to update the last cost to the true last cost after release of an AP Bill that has either a Purchase Price Variance or a Landed Cost tied to it, or both.  So far I’ve gotten things to work by creating a Generic Inquiry and a Business Event that looks for any AP Bills that have been released that have either a PPV or a LC document on them and calculates the total unit cost for that item that I want to update with the last cost. It triggers an Import Scenario that creates an Inventory Receipt with a Qty of 1 and Unit Cost equal to that Total Cost I calculated in the GI.The next Business Event uses a GI that looks for receipts with the reason code LASTCOSTRECEIPT. It trigg

Hi everyone,I am setting up a business event that sends the Inventory Valuation Report in Excel format by email at the end of each month. I have already configured the generic inquiry, the business event, and the automation schedule, and I have tested the report several times.When I run the report directly without any parameters and select the summary option, it prints all eleven warehouses together as expected. But when the email is sent out, it includes eleven attachments. Each one looks the same, except a different warehouse is highlighted in each file.I have tried updating the generic inquiry and adjusting the email template parameters, but I still get the same result. Has anyone seen this before or know how to fix it?Thank you!

We are using our own freight trucks to pick up inventory from manufacturers. We want to include the freight cost in the cost of those items that were purchased from the manufacturer but picked up by our trucks. We do not need an AP bill for this transaction since its not third party. Is there a way to use the landed cost process without creating an AP bill?Just FYI, we come up the with the freight cost by using a home grown freight cost estimator tool. Takes the overhead cost, repairs, maintenance, fuel price and mileage to come up with the freight cost. We would like to use the landed cost screen to enter that information and distribute the freight cost to the items on the PO without ACU forcing an AP bill. Is anyone needing this functionality?  

I have a customer who would like to create commission periods - 1st through 15th of month and 16th through the end of the month (aligning with payroll periods).  I am not finding anywhere to define the commission periods. Any help is appreciated. Thank you.