Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

JWS539Varsity II

How does NLog work and why is it returning connection refused?

Hi, I have two local instances of 2022.217.202.5321 hosted on the same PC which have two different customisations. On one of these instances the debugger behaves perfectly, on the other it doesn’t. On the one that doesn’t behave I was getting lots of missing symbols/can’t load Nlog.pdb, etc. messages. After doing some research on symbols, I ended up changing the paths in the yellow box below in Visual Studio from tools Options/debugging/symbols. On the instance which is having the problems I currently have:C:\Users\John\Wrk\Helm\MYOB Versions\MYOB.Advanced-2022.217.202.5231\Files\Bin C:\Users\John\Wrk\Helm\MYOB Versions\MYOB.Advanced-2022.217.202.5231\Schick_20230929\BinI set these to make the unable to load symbols messages I was getting go away. Have never had to mess with these before and I’m not 100% sure that I am doing the right thing here - but id did resolve the missing symbol problems. On the instance which works fine I have:c:\users\john\wrk\helm\natt C:\Users\John\Wrk\Hel

1015

13 minutes ago

bguzman43Freshman I

Develop Customizations

Adding a scan state to INScanTransfer

I am stuck trying to add the option to scan a projectid and project task to the Scan and Transfer form. Trying to follow the documentation and the abstract examples but I can’t get the task added in correctly. I’ve added what I have so far. The actual task is bare bones, I get how to edit those for the most part.

122

16 minutes ago

JWS539Varsity II

Develop Customizations

State of customization is wierdly different to what is expected - site corruption issue?

Hi, Just wondering if anyone has seen the type of issue described below (which I’m currently at a loss to explain or know what to do next)? Symptoms started last night when we attempted to republish a customisation. We needed to slightly change a SQL view (with a DAC on top of it). Couldn’t get this very simple change to work. SQL statement was just skipped no matter what I tried. What I found is that the only way to get the publish step to attempt to rerun the SQL statement was to deliberately make the SQL statement malformed. In this scenario the publish step attempted to apply the SQL statement and errored out as it should. However, as soon as the SQL statement was valid, it always got skipped even if radically different to the previous publish. Spent a few hours trying all the usual tricks to try and get a valid SQL statement to publish, tried all the different tick box options, priority settings, etc.Then today we have the weird scenario described below: We have custom fields

21 minutes ago

bwhite49Captain II

Reports and Generic Inquires

Updating HTML Description so that it displays correctly in a report.

I’ve imported HTML descriptions, but they are not displaying correctly in a report. They are displaying correctly on the stock items screen - just not the report where it is needed.If I go to the stock items screen and make one small change, Acumatica will rewrite the HTML and it will then display correctly in a report. Anybody have any ideas for updating these descriptions so that Acumatica will rewrite the description HTML. Should I put a ticket in for a SQL script? Will that resolve the issue? Imported HTML Imported Display Report DisplayDisplay After adding a minor change to the description - Acumatica rebuilt the HTML

53810

1 hour ago

cpaizis

Configuration and Installation

Tax Emeption Type 'Resale' not working with Avalara

We are in the configuration phase with Acumatica, on 2024 R2, and are testing the calculation of sales tax through the Avalara integration. When Tax Exemption Type is set to Resale, the transaction shows up in Avalara saying the product/service is not taxable even though it is:I cannot get this to show ‘Yes’ unless we change the Tax Exemption Type to ‘Taxable - Override Exemption,’ which defeats the purpose. We want the exemption to remain on the customer (if they have a valid certificate), but if they do not, we would need the circled field in Avalara to say ‘Yes’ in order for any tax to be calculated. Any advice?

1 hour ago

jsieberJr Varsity III

Financials

Consolidate Financials - Including the parent company's financials.

We currently have consolidated financials setup so that company’s BLC and BBLPMC are included when running financial reports for company BLLLC. We also need company BLLLC to be included in these financial reports, but they are not being included. I took a look at how the Unit Set is currently defined and it shows the following:Do I just need to add the parent company to the value to include it withing the consolidated reports like so? Am I going down the correct path with these changes or is there more that I need to do have data from all three companies within the consolidated reports?

134

2 hours ago

tahayabaliSemi-Pro III

Reports and Generic Inquires

Subreport is keep Running

Hi,I’ve attached a subreport to my main report in Acumatica Report Designer. The main report loads fine(alone), but the subreport is taking a very long time to run and causing overall performance issues and keep running The subreport (TE806000) is based on tax with two parameters . Parameters are passed correctly from the main report. When I run the subreport independently with the same parameters, i work fine.I am Attaching both reports. This is my first time working in subreports. The both reports are in initial phase. only testing with few fields right now. Please guide

3 hours ago

zhuj92Freshman II

Low Code | No Code Customizations or Integrations

How to Display "Created By" Field on Form Level (Not Just Audit History)?

We are currently implementing Acumatica and transitioning from NetSuite. In NetSuite, the "Created By" field is easily visible on most forms, which helps our users quickly identify who created a record.In Acumatica, I see that the "Created By" field exists in the Audit History, but not directly on the form itself. We would like to have this field (and possibly "Created On") visible at the form level for ease of use.Has anyone implemented this? What is the best way to display the "Created By" field directly on a form in Acumatica?

172

3 hours ago

Malinda278Freshman II

Financials

Unit of measure conversion

Can someone let me know what the logic of the conversion of units of measure is. I have read the help area about 10 times and I must have a mental block as it seems to be the reverse of what I would expect for converting from one unit to another. i.e. I would think converting a box of 10 bottles to a base of 1 bottle would require the instructions to divide by 10 but the operand is multiply. I am feeling quite stupid about this so please be gentle..

310514

4 hours ago

jbaronFreshman II

Configuration and Installation

Acumatica - Outlook integrations

Hey Acumatica Community, We developed a Teams bot (similar to OpenAI) to create emails in the Outlook web app for our Acumatica leads. We want these generated emails to be recorded back in Acumatica as email activities. I'm checking if we already have a connection established between Outlook and Acumatica to achieve this.Here's a simplified flow: Teams bot retrieves the email addresses from Acumatica leads. The bot generates an email with the recipients. Outlook opens to send the email. The sent email should reflect back into Acumatica leads as an email activity.

4 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

2540 topics

Distribution

2408 topics

Manufacturing

893 topics

Construction

846 topics

CRM

291 topics

Field Service

392 topics

Retail

570 topics

Payroll

283 topics

Professional Services

20 topics

Low Code | No Code Customizations or Integrations

427 topics

Develop Customizations

3354 topics

Develop Integrations with Web Services | APIs

857 topics

ISV Solutions

152 topics

Configuration and Installation

1057 topics

Reports and Generic Inquires

2562 topics

Import and Export Scenarios

961 topics

System Health and Performance

167 topics

Community site discussions

368 topics

Community Introductions

99 topics

Everything Else

1002 topics

Technology Partners and Customers

Forum for Acumatica technology partners and customers to collaborate on their unique products

MYOB User Discussions

31 topics

JAMIS Prime User Discussions

11 topics

News & Announcements

Get the latest on our community & company!

Acumatica News & Updates

147 topics

Events & Meet-ups

154 topics

Developer Newsletter

19 topics

58 topics

bguzman43Freshman I

Develop Customizations

Adding a scan state to INScanTransfer

122

16 minutes ago

JWS539Varsity II

Develop Customizations

State of customization is wierdly different to what is expected - site corruption issue?

21 minutes ago

cpaizis

Configuration and Installation

Tax Emeption Type 'Resale' not working with Avalara

1 hour ago

tahayabaliSemi-Pro III

Reports and Generic Inquires

Subreport is keep Running

3 hours ago

jbaronFreshman II

Configuration and Installation

Acumatica - Outlook integrations

4 hours ago

darylbowman

Develop Customizations

Prevent Modern UI grid with dynamic columns from removing the columns

I am dynamically creating grid columns on a Modern UI grid. This works great.What is not working great is that the dynamic columns seem to vanish when the grid ‘refresh’ button is used or the grid paging is used.Does anyone know how to prevent this?TypeScript:@gridConfig({ adjustPageSize: true, exportRowsLimit: 5000, fastFilterByAllFields: true, generateColumns: GridColumnGeneration.AppendDynamic, //generateColumnsAfterSelect: true, pagerMode: GridPagerMode.Numeric, preset: GridPreset.Inquiry, preventInitialFocus: true, repaintColumns: true, //statusField: "Availability", suppressAutoHide: true,})export class DXDynamicResult extends PXView { @columnConfig({ width: 70, textAlign: TextAlign.Left }) DXResultNbr : PXFieldState;} tagging @vanit05 because of this post

5 hours ago

kyoung14Varsity I

Reports and Generic Inquires

Sales Order Process Invoices and Memos Print Invoice Action - not printing all selected

We have a customized Sales order Invoice report that contains links to custom tables and subreports, etc. The report has been used for a few years with no problems and previous to 24R2 upgrade (previously 23R2) a few months back, ran fine from the Process Invoices and Memos → Print Invoice action as well. However, after the 24R2 upgrade, from the Process Invoices and memos screen, if user selects some number of multiple invoices, it does not print all of them. In production the user has found that if they select <=5 invoices all will print. If more than that they often get less invoices. If I try to print the missing invoices manually - the report runs fine so not a report problem. I don’t know that 5 is a magic number as in my local test system I got different results but still less were printing than selected. If I reverted back to simpler/standard report with no subreports it seems to be OK. But as I said, previous to 24R2 it all worked fine. Anyone encounter anything lik

5 hours ago

lauraj46Captain II

Develop Customizations

How to reference the field 'UserPreferences.DefaultSite' in a customization

Acumatica customization gurus, is it possible to reference the UserPreferences.DefaultSite field in an event? Code snippet is below, but I’m receiving the error ‘UserPreferences’ does not include a definition for ‘DefaultSite’. The field does exist in the SQL table in my local test environment. Thanks in advance! var line = e.Row; var currentUserID = PXAccess.GetUserID(); UserPreferences prefs = PXSelect<UserPreferences, Where<UserPreferences.userID, Equal<Required<UserPreferences.userID>>>> .Select(Base, currentUserID); if (prefs?.DefaultSite != null) { line.SiteID = prefs.DefaultSite; }

5 hours ago

hyadav08Jr Varsity II

New to the community?

Get Started HERE be sure toIntroduce Yourself and reach your Community ManagerChris Hackett

Acumatica User Groups

Educational Resources

Community Library

Blogs

What you may have missed in the Acumatica Community! June, 2025

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

CAS2809has earned the badge Easy talker
Tara Hodgkinshas earned the badge CRM expert

Show all badges

Acumatica Community

New to the community?

User leaderboard

Acumatica employee leaderboard

Badge winners

Events Calendar

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded