Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

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?

34 minutes 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!

42 minutes ago

dougmcbride79Varsity III

Distribution

Opportunity Stage: How to edit stages

Where can I modify / add “Opporunity Stages”?

44 minutes 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

51 minutes ago

myoungFreshman I

Everything Else

Login error

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

51 minutes 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!

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

2 hours ago

ngerstFreshman II

Reports and Generic Inquires

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

665 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

34 minutes ago

mnecaiseVarsity I

Reports and Generic Inquires

Report Not Found Error

42 minutes ago

rcambierFreshman I

File not instantly downloading when using PXRedirectToFileException

51 minutes ago

myoungFreshman I

Everything Else

Login error

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

51 minutes ago

mmarklow44

Develop Customizations

Require one record in grid added before saving parent

1 hour ago

squesenberry11

Financials

How to handle credit card charges when processing back orders

We are on Acumatica 2022 R2 and use EBizCharge for credit card processing. We have multiple warehouses that may be shipping from the same sales order.When a shipment is completed, we have an end-of-day process that will prepare the invoice for each shipment that was completed and capture the credit card transaction for the amount that was completed (possibly multiple invoices applied to this payment). Our warehouses are 98% able to fulfil shipments same-day unless something is backordered so this works for most orders. Shipments that span over several days, such as backorders, will NOT be able to authorize charges to that same card transaction - the process that runs on that first day will consume that transaction. This will result in the backorder getting stuck in “Awaiting Payment” until the card is reauthorized. During this time, the order is also not considered for fulfillment because it’s Awaiting Payment.If a card is reauthorized too quickly, the bank may not release funds for th

3 hours ago

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

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

4 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

4 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

5 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