Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

carmelinem89Freshman II

Field Service

How do I get the data from Service Orders Totals Tab?

23 minutes ago

abd28xdFreshman I

Develop Customizations

Trying to access a GraphExtension variable in my javascript function

Hi, I am trying to access a variable in my graph extension from the script on my page, can someone please help me achieve this. Trying to build a URL in graph extension and sending it Javascript to render it in an iframe.This is the code, where i want to access the key field from this GraphExtension in my javascript function #region Selects public PXSelect<SOOrder> AllRecs; #endregion #region Event Handlers #endregion [PXString] [PXUIField(DisplayName="API")] public virtual String vartanaKey {get; set;} public PXAction<SOOrder> VACreateOrder; [PXButton] [PXUIField(DisplayName = "Create Order")] public virtual IEnumerable vaCreateOrder(PXAdapter adapter) { try { usrVAVartanaConfigGraph configGraph = PXGraph.CreateInstance<usrVAVartanaConfigGraph>(); VAVartanaConfig keyRec = configGraph.AllRecs.Select().FirstOrDefault(); vartanaKey = keyRec.UsrVAApiKey;//throw new PXException(vartanaKey.U

37 minutes ago

OzVerum

Import and Export Scenarios

How could I use OData in function in $filter query ?

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.

2 hours 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?

4 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!

4 hours ago

dougmcbride79Varsity III

Distribution

Opportunity Stage: How to edit stages

Where can I modify / add “Opporunity Stages”?

4 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

4 hours ago

myoungFreshman I

Everything Else

Login error

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

4 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!

5 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?

6 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
921 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
9627 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

carmelinem89Freshman II

Field Service

How do I get the data from Service Orders Totals Tab?

23 minutes ago

abd28xdFreshman I

Develop Customizations

Trying to access a GraphExtension variable in my javascript function

37 minutes ago

krausef77Jr Varsity II

Distribution

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

4 hours ago

mnecaiseVarsity I

Reports and Generic Inquires

Report Not Found Error

4 hours ago

rcambierFreshman I

File not instantly downloading when using PXRedirectToFileException

4 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

7 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?

7 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