Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

bbohnVarsity I

Generic Inquiry via OData - Friendly Names and Extra Fields

Is there a way to adjust the metadata of a generic inquiry exposed via OData? I have a simple customer balance inquiry that an external CRM system will use to get an account’s balance. The friendly names of the parameters are “Company” and “Customer”, but the OData field names are “BranchID_2” and “Account”, respectively. Also, the response includes fields that aren’t in the Results grid of the inquiry. Why? Presumably because they are fields used in the joins and aggregation, but there’s no need for them to be in the response as it just adds clutter. Thanks.

46 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

343

2 hours ago

Joe SchmuckerCaptain II

Distribution

Issue with displaying Inventory ID in mobile app using a custom GI

This question was asked 4 years ago. I have the same issue. However, I think the solution provided in this topic is frankly unacceptable. Unless of course, I’m missing something obvious.Issue with displaying Inventory ID in mobile app | CommunityIn my GI, I am displaying the Inventory CD. Looks great when viewing on the site.Per the link above, when the GI is displayed on the mobile app, the Description field is shown, not the inventory CD “by design”. Well, that doesn’t seem like a good design.If I follow the old link, I have to uncheck the Expose to Mobile App and basically, rewrite the entire GI as a new mobile screen. By exposing the GI to the mobile app, it is doing everything we want except for actually displaying an inventory id (cd). There HAS to be some way to modify the GI results grid to show the Inventory CD in the mobile app without recreating the ENTIRE page on the web app.Has anyone else figured a workaround for this? EDIT: I meant to create this in the Develop C

312

4 hours ago

gballFreshman I

Field Service

Changing Customer on an Appointment after it has been completed

In Field Service, we struggle with not being able to change a customer on an appointment after the appointment has been completed. This is an issue for us. Customers often ask that we change the Customer or the Bill To Customer after the appointment has been completed. To change the Customer or the Bill To Customer, we have to create a new appointment, delete all material and labor from the original appointment and cancel the appointment. This is tedious and time consuming, especially if we have many, 15-20, appointments on a Service Order. In Sage CRE, we could change the Bill To Customer at any point before the Work Order was invoiced. We could also send an invoice back to Service Management from AR, and change the Billi To Customer with ease. Does anyone have a solution for changing the the Customer or Billing Customer with ease after an appointment is completed?@khowe86

544

5 hours ago

nbnexFreshman I

Field Service

ServiceOrder Billing - Bill Actual Amount From Appointment

Hi everyone, I have a created a service order billing cycle:Run Billing for: Service Orders Group Billing Documents by: Service OrdersIn an appointment I have a service item with an estimate of 4 hours but the actual qty is 6 hours. After closing the appointment the item is transferred to service order for billing.However instead of the actual amount of 6 hours the only 4 hours are billed when running billing. If I change the billing cycle to: Run Billing for: Appointments Group Billing Documents by: Service Ordersnow billing is moved to the appointment which will create multiple invoices which isn’t what we want. Changing the billing cycle: Run Billing for: Service Orders Group Billing Documents by: Appointmentis not permitted by the system. Is there a way to to make service orders bill the actual amounts and qtys from the appointments? Or am I missing something why this isn’t supposed to work? Thanks

2833

5 hours ago

jacobslotta06Freshman I

Develop Customizations

Run Print Labels and Print Shipment Confirmation from one button

I'm trying to create a button that will run both the Print Labels and Print Shipment Confirmation actions for a shipment. I found some examples in the Acumatica base code that look to run one action, then wait, then run another, but it's not working for me. Below is one of the code examples I'm trying. The order which they run doesn’t matter. Everything I’ve tried either doesn't run the second action, or doesn’t run either action. I think I'm having trouble because one returns files and the other runs a report. Any ideas on what to do? public PXAction<SOShipment> printCombinedLabelShipmentConfirmation; [PXButton(CommitChanges = true), PXUIField(DisplayName = "Print Labels/Packing Slip", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] public virtual IEnumerable PrintCombinedLabelShipmentConfirmation(PXAdapter adapter) { var list = adapter.Get<SOShipment>().ToList(); var key = Guid.NewGuid();var printArgs = new PrintPackageFilesArgs{Shipment

5 hours ago

JSpikowskiFreshman I

Other Developer Topics

New Seveloper

Hi Everyone,I joined the Acumatica forum as a resource for my external Acumatica application extensions using REST and the ScriptBasic application web server. Any good links to REST interfacing would be appreciated. John Excuse typo in the title., 🙄

423

6 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

412

8 hours ago

mohammadnawaz51Jr Varsity I

Financials

Creation of Landing cost entry via API for Account Payable

Hi,I am looking for any end point that can help me create landing cost entry in ERP. I could not find anything in the documentation. I have anyways created a custom end point with all the necessary data points but not able to get the right result. Can someone help me if they have come cross a scenario where in they have to create a landing cost via API.Regards,Nawaz, Mohammed

353

16 hours ago

wilson71Jr Varsity I

Financials

Inter-company transactions between companies with different base curreny

1 | No inter‑company transactions at all when base currencies differWhenever I try to create any document that involves two companies whose base currencies are different—an Payment of an AP Bill on behalf of another company with different base currency an inter‑company GL journal entry a Cash Transfer between branches—the system blocks the save with the message that “branches has different base currency”Question: Is there a supported way to post any inter‑company document when base currencies differ, or am I missing a configuration flag / workaround? 2 | Vendor / Customer sharing across base currenciesI’ve noticed that Intercompany ▶ Extend as Vendor/Customer creates a single vendor (or customer) record that remains usable by all companies—even when those companies’ base currencies differ.By contrast, a standard vendor or customer is limited by the “Restrict Visibility To” rule, which forces us to segregate records by base‑currency groups.Question: Why can’t the same cross‑base‑currenc

16 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

2543 topics

Distribution

2412 topics

Manufacturing

894 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

428 topics

Develop Customizations

3358 topics

Develop Integrations with Web Services | APIs

858 topics

ISV Solutions

152 topics

Configuration and Installation

1057 topics

Reports and Generic Inquires

2564 topics

Import and Export Scenarios

961 topics

System Health and Performance

167 topics

Community site discussions

369 topics

Community Introductions

99 topics

Everything Else

1004 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

bbohnVarsity I

Reports and Generic Inquires

Generic Inquiry via OData - Friendly Names and Extra Fields

46 minutes ago

JWS539Varsity II

Develop Customizations

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

343

2 hours ago

jacobslotta06Freshman I

Develop Customizations

Run Print Labels and Print Shipment Confirmation from one button

5 hours ago

JSpikowskiFreshman I

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

Isharamhas earned the badge Easy talker
CAS2809has earned the badge Easy talker

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