Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

Hi @ruchikasharma23 @Laura02 , hope you’re well guys, Could you please refer or help me, how I could use OData in function in $filter query ?here is my query Customer?%24filter=CustomerID%20in%20(%270000003%27%2C%20%270000004%27%2C%20%270004737%27)' and it always produced this error message"Syntax error at position 13 in 'CustomerID in ('0000003', '0000004', '0004737')'.", I know I could use this approach such as $filter=CustomerID eq '0000003' or CustomerID eq '0000004' or CustomerID eq '0004737', but in case the ids list will be long it’s definitely the best approach to use “IN” list function. Please help me with. Thanks in advance.

57 minutes ago

krausef77Jr Varsity II

Distribution

Expose File Name and potential other File Data in Generic Inquiry for Filtering and Dashboarding

Hi All, We are trying to expose File names and potential other Data to a GI.One usecase is Shipments that are being signed on Delivery through the native Mobile App.I don’t see a Flag indicating it was signed in the DAC Schemas but a signature file is attached.We would be able to utilize this for our Reporting and Analysis if we can expose the File Name. I tried joining PX.SM.UploadFileWithIDSelector and PX.SM.UploadFile via the NoteID field but just got blank results in the Inquiry for the file Data. Any ideas how this can be made happen?

2 hours ago

mnecaiseVarsity I

Reports and Generic Inquires

Report Not Found Error

I have a report that I created a couple months ago that I need to make some changes to. When I click on Edit Report, I get the normal Report Designer pop-up to login. However, as soon as I login I get the error message that the report does not exist. The report runs, so I know it’s there. I just can’t figure out why I’m not able to open it in Report Designer. I haven’t had any issues with opening other reports, so it’s something with this one specifically. Has anyone else run into this or have any suggestions? Thanks!

2 hours ago

dougmcbride79Varsity III

Distribution

Opportunity Stage: How to edit stages

Where can I modify / add “Opporunity Stages”?

2 hours ago

rcambierFreshman I

File not instantly downloading when using PXRedirectToFileException

I have a custom page that will allow a user to select several records from a grid and then click a ‘Generate Document’ button that will use a stored proc & several API calls in order to retrieve details from the selected records and generates a document using these details.Each record has the ‘Selected’ property which handles the checkbox selection and lets the ‘Generate Document’ button know which records to pull the details from (using the Reference Number on each selected record).I am using the ‘PXRedirectToFileException’ to download the file after the final API call returns the byte[] array that represents the generated document (and creating a new ‘FileInfo’ object using this byte[] array and a previously declared document name).I don’t run into any errors when executing my code and interacting with the page but when I try to click ‘Generate Document’ there is a slight loading period and then nothing happens UNTIL I click another checkbox on any record and then the file is dow

2 hours ago

myoungFreshman I

Everything Else

Login error

Has anyone encountered: “Error: An unexpected error occurred invoking “startTwoFactorPipeline” on the server.”?

2 hours ago

mmarklow44

Develop Customizations

Require one record in grid added before saving parent

So normally when you want to require a field that’s a fairly simple task. But what can you do when you want to require a record to exist in a detail grid? For example, on the Customer maintenance page there is a SalesPersons tab. I want to make sure at least one record is in that grid before allowing the customer to save. Is that an easy task? I didn’t see anything in the grid properties that would make sense and figure it will likely have to be done with a graph extension, but not sure how to go about it. For example, there is no salesperson record saved here so saving the customer should result in an error: Thanks for any recommendations or tips!

3 hours ago

dylantheriault

Reports and Generic Inquires

How to modify existing report to display an image based off the inventory ID stock item description?

We have a production ticket report for production of canned beverages.There are 50+ product specifications. These are 1 page documents/images. Is there a good way to display a specific product spec that is pulled from the inventory ID stock item description and matched with the 1 page image?The only way I can think to do this is have 50+ sections with visibleExpr that would each display the image only if the statement below was true:=iif([InventoryItem.ItemClassID_description] = 'BERRY LEMONADE', 'TRUE', This would require a lot of work to set up and maintain 50+ image files.If these product specs were to change every month or so, what would be the best way to update or set up these reports? Would a database setup allow for the image files to change without having to change anything in the report?

4 hours ago

ngerstFreshman II

Reports and Generic Inquires

Request & Requsition Questions

I am looking to create a GI that will allow our users the ability to see their requests and pull information from the Requisition and/or Purchase Order that was generated from their request. I am running into some challenges and thought I would reach out to the community…1) Our Requisitions are created by our purchasing team, thus from a request to a requisition there is no insight into who the requisition was requested by only a created user. I do see that on the requisition you can look at the Request Details and see an Employee ID - does anyone know the DAC that link these? 2) Is there an ability to create multiple requisitions to one purchase order? I ask this because if this is the case, we could have a requisition that was requested by multiple users. As the information is merged together into one purchase order I need to provide the ability to show the multiple users their requisition and purchase order information.Overall, I am working on providing more insight for our users to

4 hours ago

chidao

Reports and Generic Inquires

Add Notes into Generic Inquiry

Hi All,I want to add & show the content of Shipment Notes on Generic Inquiry.As I know from version 2021 R1 (we use 2022 R2) we can choose which notes can be attached to GI by Attach Notes toAfter viewing GI, I don't see it appear and even though the content of notes can be seen on screen also.Do you have any idea?

5 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1750 topics
5778 Replies

Distribution

1690 topics
6503 Replies

Manufacturing

595 topics
2231 Replies

Construction

571 topics
1927 Replies

CRM

157 topics
453 Replies

Field Service

278 topics
920 Replies

Retail

451 topics
1990 Replies

Payroll

213 topics
706 Replies

Low Code | No Code Customizations or Integrations

219 topics
798 Replies

Develop Customizations

2374 topics
9626 Replies

Develop Integrations with Web Services | APIs

573 topics
2321 Replies

ISV Solutions

120 topics
490 Replies

Configuration and Installation

751 topics
2744 Replies

Reports and Generic Inquires

1739 topics
6753 Replies

Import and Export Scenarios

666 topics
2749 Replies

System Health and Performance

132 topics
478 Replies

Community site discussions

227 topics
420 Replies

Community Introductions

95 topics
281 Replies

Everything Else

715 topics
2368 Replies

News & Announcements

Acumatica News & Updates

110 topics
156 Replies

Events & Meet-ups

136 topics
83 Replies

Developer Newsletter

19 topics
0 Replies

43 topics
0 Replies

krausef77Jr Varsity II

Distribution

Expose File Name and potential other File Data in Generic Inquiry for Filtering and Dashboarding

2 hours ago

mnecaiseVarsity I

Reports and Generic Inquires

Report Not Found Error

2 hours ago

rcambierFreshman I

File not instantly downloading when using PXRedirectToFileException

2 hours ago

myoungFreshman I

Everything Else

dsimmerlySemi-Pro I

Import and Export Scenarios

Export of GI error - Illegal characters in path.

Created a new Export of GI following method in I100 training.In both training version and version in Live get error on Action Export on the Exort by Scenario - Illegal characters in path.Seems like there is path to save the export but not sure where that is defined

5 hours ago

gorazemJr Varsity III

CRM

Salesforce Sync still not able to start asynchronous sync

Hello, For the past several months, we’ve been able to start the real-time sync on the Salesforce Sync screen. a known issue was posted about it but the updated versions did not fix the issue. Is anyone else experiencing this too?

5 hours ago

dmerrill

Distribution

How to Handle Overstock Locations

In our warehouse our lower shelves are Forward Pick locations and upper shelves are Reserve Stock. We keep a supply of all inventory in the Forward Pick locations but any overstock that won’t fit below will go to the Reserve Stock locations. Both location types have their respective inventory marked Include in Qty Available but only the Forward Pick locations are marked as Sales Allowed. This allows a sales order to be created regardless of inventory location but will prevent the Shipment/Picklist creation if doing so would direct a picker to a Reserve Stock location.This is where the pain point is introduced. We currently utilize the “Tasks” feature in Acumatica to direct our warehouse mobile users to transfer items from Reserve Stock to Forward Pick so that shipments containing affected items can be created.Ideally we would like a proper means of creating a Transfer Order which would direct a warehouse user to transfer the items between locations.I’m wondering if this is already an o

6 hours ago

pgurney

Reports and Generic Inquires

Text disppears from Email window when moving the window around?

Hello,Running into a strange issue and wondering if anyone else has seen it. One of my users, when he types content into the pop-up Email window, if he moves that window around afterward, the text will be cleared entirely. This behavior is new and only occurs for one user. He is on Windows 11 and using the latest release of Google Chrome. Thank you

6 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

VidhyaHarihas earned the badge Easy talker
ruchikasharma23has earned the badge Integrations and Web Services | APIs expert

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