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.

3 hours ago

BorisRudi56Acumatica Employee

Retail

Scenarios of Refunds import for Shopify Orders with cash or credit card payments

Hi All,The Commerce Retail team has recently prepared a technical guide about import of Refunds supported by the Acumatica Shopify connector in version 2023r2. This guide covers the most common refunds scenarios for Shopify orders with cash or credit card payments. We believe that this document will help to improve users’ knowledge of the refund import process and what results they can expect.If there are any other frequent scenarios of refunds applicable for Shopify orders, please let us know in replays for this post. Thanks

3 hours ago

aiwanJr Varsity III

Develop Customizations

Error: Another process has updated the 'NCRLog' record.

Hey guys,Hope you are all well, I am working on including some of our ISO records onto Acumatica. I have created a new from for Non-Conformance entries and a substitute GI for the entry screen.However, I keep receiving the error ‘Error: Another process has updated the 'NCRLog' record. Your changes will be lost.’ The first save works fine, however any actions thereafter, e.g., save, delete, cancel, all give that error. Has anyone encountered this before?I have attached my code files here.NCRLog.csGilcrestMaint.csThanks,Aleks

3 hours ago

cwomack98Jr Varsity III

Everything Else

Outlook Add-in keeps spinning

Does anyone else’s add-in just spin unless you close Outlook and reopen? Not using a web browser, using the outlook app.Then you can use it once and have to close and reopen it every time you want to add something to Acumatica? At first I was told I have to have the Display settings in Outlook set to Optimize for compatibility but it was already set to that so I changed to Optimize for best appearance (application restart required) and it would work for one use. Switched back and of course had to restart and it worked for one use again. I now just close and reopen without changing the settings and can use it for one use. Getting tired of closing and reopening Outlook in order to get things attached in Acumatica.

3 hours ago

debbiereed72Jr Varsity II

Distribution

Shipping - Default checked (true) Use Customer's Account when customer has account

Is there any way to force the User Customer’s Account box to be checked, by default, when the Ship Via selected is related to the Carrier where the customer has an account setup?

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

adilaleemJr Varsity III

Develop Integrations with Web Services | APIs

Createing AR Payment throwing error 'Reference Nbr.' cannot be found in the system

AR302000Content ARPayment = context.AR302000GetSchema(); #region PaymentCommand var cmdInsert = new Command[] { new Value { Value = "Payment", LinkedCommand = ARPayment.PaymentSummary.Type }, new Value { Value = "CATLX11572", LinkedCommand = ARPayment.PaymentSummary.Customer }, new Value { Value = "MAIN", LinkedCommand = ARPayment.PaymentSummary.Location }, new Value { Value = "USD", LinkedCommand = ARPayment.PaymentSummary.Currency }, new Value { Value = "Balanced", LinkedCommand = ARPayment.PaymentSummary.Status }, new V

4 hours ago

mmarklow44Freshman I

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!

4 hours ago

emelda71Jr Varsity II

Financials

Customer journal from one customer in branch A to a customer in branch B

Good day. Is it possible to do customer journal from one customer in branch A to a customer in branch B like we do with journal transactions? So far all i can see is that you will have to do 2 separate transactions.I have tried to document the issue in the attached file, hope it’s clear.Thanks!

4 hours ago

lewisadFreshman I

Reports and Generic Inquires

Zero quantity items on Service orders and appointments

Is it possible to stop selection of all incl. serialized items with 0 balance on the SVO/Appt.. Or highlight that entry in red when someone picks that item on the Service Order or Appointment?

4 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1752 topics
5782 Replies

Distribution

1692 topics
6515 Replies

Manufacturing

595 topics
2231 Replies

Construction

571 topics
1927 Replies

CRM

157 topics
453 Replies

Field Service

279 topics
922 Replies

Retail

451 topics
1993 Replies

Payroll

213 topics
709 Replies

Low Code | No Code Customizations or Integrations

219 topics
798 Replies

Develop Customizations

2374 topics
9632 Replies

Develop Integrations with Web Services | APIs

574 topics
2323 Replies

ISV Solutions

120 topics
490 Replies

Configuration and Installation

751 topics
2744 Replies

Reports and Generic Inquires

1743 topics
6760 Replies

Import and Export Scenarios

666 topics
2753 Replies

System Health and Performance

132 topics
478 Replies

Community site discussions

228 topics
420 Replies

Community Introductions

95 topics
281 Replies

Everything Else

715 topics
2372 Replies

News & Announcements

Acumatica News & Updates

110 topics
158 Replies

Events & Meet-ups

136 topics
83 Replies

Developer Newsletter

19 topics
0 Replies

43 topics
0 Replies

aiwanJr Varsity III

Develop Customizations

Error: Another process has updated the 'NCRLog' record.

3 hours ago

dsimmerlySemi-Pro I

Import and Export Scenarios

Export of GI error - Illegal characters in path.

4 hours ago

adilaleemJr Varsity III

Develop Integrations with Web Services | APIs

Createing AR Payment throwing error 'Reference Nbr.' cannot be found in the system

4 hours ago

emelda71Jr Varsity II

Financials

Customer journal from one customer in branch A to a customer in branch B

4 hours ago

lewisadFreshman I

Reports and Generic Inquires

skumar98Freshman I

Reports and Generic Inquires

How to significantly speed up the performance of Reports ?

Any suggstions ?

7 hours ago

vannakheng66Freshman I

Reports and Generic Inquires

How to navigation to customer screen in report design

9 hours ago

brucewarrell96Jr Varsity III

Distribution

Credit Card Payment for Cash Sale Sales Order Type

In 2024R1, the help indicates that a credit card payment method can be used to with the Cash Sales sale order type. But when I add a credit card payment method to the order, I get a blocking error stating the credit card payment method is not supported by the Cash Sales order type. Is the help incorrect?

9 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

keithschmhas earned the badge Easy talker
alanconroynawhas earned the badge Easy talker

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