Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

Hello everyone,I have the problem that I want to add several suppliers to a stock item. This works so far, but I need a way to skip empty rows in Excel.For example:I have three possible suppliers in my Excel list.Two are imported.For the third one, it throws an error because there is none, for example. Does anyone have any idea how I can work around this?Kind regards

1 minute ago

ifelixFreshman I

Reports and Generic Inquires

Report Designer: Open status SOOrder parameter

Hi. In my report parameters I want to load Sales order number parameter that has open status only. How can i achieve this ? Please help!I tried to achieve this by setting the soorder.status equal to N in the filter section. But it’s not working. Can anyone help?!

1 hour ago

SubbuFreshman I

Develop Integrations with Web Services | APIs

Creating Project Record in Postman - REST API

Team - I'm encountering an error while trying to create a new project record in Postman. I've included all the mandatory fields that are required when creating a project directly in the UI.Here's the issue:I'm getting an error when sending the request through Postman. I'm unsure if fields like "ProjectID" need to be populated when creating a record. In the UI, these seem to be generated automatically.For reference, I included "ProjectID" : {"value" : "<NEW>"} in my request body, but it didn't resolve the error.Could someone please advise on:What I might be missing that's causing the error (406) in Postman? Whether fields like "ProjectID" need a specific value when creating a record or are they indeed auto-generated? I was referring the below link to create request, https://help.acumatica.com/(W(15))/Wiki/ShowWiki.aspx?pageid=13f5f5b8-33d1-40d9-83db-3f3dfc5dcba9

3 hours ago

HarshitaCaptain II

Everything Else

Business Event stopped triggering

Hello All,I recently created (yesterday) a BE which was running as expected, but today it is not getting triggered. No conditions have been modified and not date conditions have been added to run the business event. What might be the reason? has anyone faced such issue on the same? I have faced this multiple times and when i created a new BE with the same parameters/filters/conditions then it got to working.

4 hours ago

HarshitaCaptain II

Import and Export Scenarios

Purchase Receipt Import Scenario with Add PO

Hello community,I have been working on an import scenario of Purchase Receipts, where I am looking to import the lines using Add PO button → Under the Details tab, but the scenario isn’t working. Can anyone let me know what is it that I am missing here?Have attached the XML file of the import scenario. Thanks in advance.

4 hours ago

Doug JohnsonAcumatica VP, Product Management

Payroll

Canadian Payroll

Acumatica will offer the Controlled Release of Payroll in Canada beginning with the 2023 R1 release coming in April. The initial release of Acumatica Payroll will support:Federal and Provincial Tax Calculations T4 and RL1 tax forms (T4 summary and RL1 available in 2023 R1) PD7A remittance validation report for CRA (2023 R1) Record of Employment Final Paycheck Canadian Specific features Paid Time Off calculations Deduction and Benefits calculations Payroll related features EFT (via Canada localization) T5018 (improvements in 2023 R1, ability to separate goods/services in 2024 R1) The following features will be supported in a future release:Multiple base currencies. Customers who want to run both US and Canada payroll need to implement 2 separate tenants PTO enhancements T4A (AP report)The table below outlines the stages and timelines of the rollout.Stage Tentative Date(s) Information/Activities Acumatica Demonstrations July 2022 Acumatica supervised demos using a previ

110016

5 hours ago

ericklasimin61Freshman II

Develop Customizations

Insert 'Load Records from File' on Release Production Orders screen

Hi there, I have a requirement to read the Production Order Nbr. from Excel file and update the Select checkbox accordingly. I tried adding a ‘Load Records from File’ function to Release Production Orders screen by setting the ‘Allow Upload’ in Customization Project Editor to true and extended the graph by adding the PXImport as shown below:public class ReleaseOrd_Extension : PXGraphExtension<ReleaseOrd> { public PXCancel<AMBatch> Cancel; [PXImport] [PXFilterable] public PXProcessing<AMProdItem, Where<AMProdItem.statusID, Equal<ProductionOrderStatus.planned>, And<AMProdItem.hold, Equal<False>, And<Where<AMProdItem.function, Equal<OrderTypeFunction.regular>, Or<AMProdItem.function, Equal<OrderTypeFunction.disassemble>>>>>>> PlannedOrds; public PXSetup<AMPSetup> ampsetup; } However when I tried to upload the Excel,

5 hours ago

JReppardFreshman I

Reports and Generic Inquires

Template Email Double Spacing lines

Has anyone had any issues with / when sending a email via a template, the message will look exactly how you want it to look on the template, in “all emails” it looks good, but when received in outlook it looks like it goes from no spacing between lines to double spacing. Every line, including signature from “my profile” being inserted looks like it’s going from single space to double or 1.5x. It looks unprofessional and not sure what the problem is. Any ideas?

5 hours ago

rashmikamudalinayake10Jr Varsity III

Low Code | No Code Customizations or Integrations

The header value doesn't automatically update.

This is an extension of a thread: How can I change header value of a field based on currently selected row in the grid.So far, I have found a working solution. However, there's a minor issue: the UsrWorkCenterID field (show details...) doesn't update automatically. I need to clear the current record to obtain the new value. If anyone knows how to resolve this minor issue, please share the solution. protected void AMProdItem_UsrWorkCenterID_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e) { // Getting the production item data. var prodItemRow = (AMProdItem)e.Row; if (prodItemRow == null) return; // If there's no data, return. // Trying to find the current operation info. var currentOperRow = Base.Caches<AMProdOper>().Current as AMProdOper; // If the current operation matches the item's details, use its Work Center ID. if (currentOperRow != null && currentOperRow.ProdOrdID == prodI

6 hours ago

eshahid05Freshman I

CRM

Marketing Email Templates Design

Is there a design tool that can be used for building email templates for marketing campaigns in the CRM module? Customers can’t always write HTML / CSS, so wondering is there a design tool integration? Or perhaps they can create a design somewhere and copy paste the HTML / CSS into the Email Template?

7 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1729 topics
5739 Replies

Distribution

1673 topics
6468 Replies

Manufacturing

592 topics
2222 Replies

Construction

568 topics
1913 Replies

CRM

154 topics
451 Replies

Field Service

273 topics
911 Replies

Retail

452 topics
1981 Replies

Payroll

212 topics
698 Replies

Low Code | No Code Customizations or Integrations

218 topics
789 Replies

Develop Customizations

2358 topics
9592 Replies

Develop Integrations with Web Services | APIs

559 topics
2291 Replies

ISV Solutions

120 topics
488 Replies

Configuration and Installation

747 topics
2713 Replies

Reports and Generic Inquires

1720 topics
6693 Replies

Import and Export Scenarios

661 topics
2722 Replies

System Health and Performance

131 topics
478 Replies

Community site discussions

225 topics
420 Replies

Community Introductions

95 topics
281 Replies

Everything Else

710 topics
2358 Replies

News & Announcements

Acumatica News & Updates

110 topics
154 Replies

Events & Meet-ups

132 topics
83 Replies

Developer Newsletter

19 topics
0 Replies

43 topics
0 Replies

ernst97

Import and Export Scenarios

Add multiple vendors to a stock item and skip when excel is empty

1 minute ago

ifelixFreshman I

Reports and Generic Inquires

Report Designer: Open status SOOrder parameter

1 hour ago

HarshitaCaptain II

Everything Else

Business Event stopped triggering

4 hours ago

HarshitaCaptain II

Import and Export Scenarios

Purchase Receipt Import Scenario with Add PO

4 hours ago

ericklasimin61Freshman II

Develop Customizations

Insert 'Load Records from File' on Release Production Orders screen

5 hours ago

JReppardFreshman I

Reports and Generic Inquires

Template Email Double Spacing lines

5 hours ago

rashmikamudalinayake10Jr Varsity III

Low Code | No Code Customizations or Integrations

The header value doesn't automatically update.

6 hours ago

eshahid05Freshman I

CRM

Marketing Email Templates Design

7 hours ago

jhouserVarsity III

Configuration and Installation

Outlook Add-in in web?

Has anyone had success using the Acumatica add-in with Outlook web version? It works great in the desktop Outlook, but haven’t had success in web version. A year ago I installed it and signed in, but could never get it to do anything. Now when reinstalling I can’t even sign in, just spins. The company I’m assisting has many employees that don’t have license to have Outlook installed, so they use web. Any insight appreciated!

7 hours ago

jib87Jr Varsity II

Retail

Mapping Acumatica Customer Attribute to Shopify Company Notes

Good day everyone,ShopifyxAcumatica connector only allows mapping of Company to only fields Name or Notes. Now, I am encountering issue with syncing using Attribute to the Notes field. It always provide an empty value.I mapped the attribute with Customer entity to a Shopify Customer tag - it worked, has value.I mapped another field in Company entity to a Shopify Company Notes - it worked, has value.But when I mapped the same attribute with Company entity to a Shopify Company Notes - it is empty. Does anyone encounter the same? I am using 23 R2 - Build 23.209.0023

8 hours ago

New to the community?

Get Started HERE and be sure toIntroduce Yourself

Acumatica User Groups

Educational Resources

Community Library

Blogs

What you may have missed in the Acumatica Community! March, 2024

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

leppleyhas earned the badge Easy talker
BarbaraPietersen23has earned the badge Easy talker

Show all badges

Acumatica Community

New to the community?

User leaderboard

Acumatica employee leaderboard

Badge winners

Events Calendar

Latest Articles

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded