Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

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

ViweMFreshman II

Distribution

Printing two invoice and copy of the invoice from the AR Invoice form

A client wants to print the AR Invoice and Copy of the Invoice at one push of the print button.To achieve this I added a sub-report which AR Invoice form AR641000, on the report footer. The sub-report is the Copy Tax Invoice, both forms are supposed to print in A4 format. Page 1 (Original invoice prints well) but Page 2 (Copy Tax Invoice) prints all details but stuffs it in half the page. The sub-totals from the group footer are pushed up right close to the lines? Has anyone come across this? I have even increased the size of the sub-report but nothing works

4 hours ago

Sagar GreytrixPro I

Import and Export Scenarios

select Multiple Order Lines in Import scenario using ADD PO Lines Action on Purchase Receipts

Hi Experts,I'm currently working on an import scenario where I need to select multiple order lines using the Add PO Line action on the Purchase Receipts Screen.I came across the following forum post which addresses a similar issue:[Import Scenario - Purchase Receipts - ADD PO LINE button not adding PO Line 2](Forum link)However, the solution provided seems to work only for single transaction orders. When dealing with multiple line orders, it fails to function correctly. Could someone please assist me in resolving this issue?Any assistance on this matter would be greatly appreciated.Thank you.

8 hours ago

sodell

Develop Customizations

Display popup on RowSelected Event once

On the RowSelected Event, I am checking parameters and displaying a popup. The popup is working, but it displays the popup an endless number of times. I have tried adding a cookie when the dialog is displayed and required the cookie to not be there for the dialog to display again, but that does not seem to work.var response = HttpContext.Current.Response;if (!response.Cookies.AllKeys.Contains("mycookie")){ HttpCookie mycookie = new HttpCookie("mycookie"); response.Cookies.Remove("mycookie"); response.Cookies.Add(mycookie); Base.Document.Ask("This is a TEST.", MessageButtons.OK); return;} I am news to Acumatica Development, so any guidance or tips would be appreciated!

9 hours ago

CorbinHurstFreshman I

Reports and Generic Inquires

Backorder Report - Linking inventory ID to Purchase order "expected Date"

Hey Guys,I need a little help, i have a back order report im pretty sure i found on here. ive made some changes, but i’d really like to show the expected dates for the items. Im having trouble relating tables todo so. Is it as simple as adding PO.POrder to the table then adding a relation? the relations confuse me.

9 hours ago

mrthanhkhoiJr Varsity II

Develop Customizations

Filter grid records by custom field

Hello community,I want to filter list records in Grid result by a custom field on screen Vendor Prices (APVendorPriceFilterExt.usrShippingTermID) How to override the original select statement and add condition?Source code of selects Records:[PXFilterable]public PXSelectJoin<APVendorPrice, LeftJoin<InventoryItem, On<InventoryItem.inventoryID, Equal<APVendorPrice.inventoryID>>, LeftJoin<INItemClass, On<INItemClass.itemClassID, Equal<InventoryItem.itemClassID>>, LeftJoin<Vendor, On<APVendorPrice.vendorID, Equal<Vendor.bAccountID>>, LeftJoin<INSite, On<APVendorPrice.siteID, Equal<INSite.siteID>>>>>>, Where2<Where<Vendor.bAccountID, IsNull, Or<Match<Vendor, Current<AccessInfo.userName>>>>, And2<Where<InventoryItem.inventoryID, IsNull, Or<Match<InventoryItem, Current<AccessInfo.userName>>>>, And2<Where<INItemClass.itemClassID, IsNull, Or<Match<IN

10 hours ago

skumar98Freshman I

Distribution

Error status 'Update Purchase Order Status' Screen

Why does this ‘Error Processing PO’ in EDI Status column and ‘Error’ in Error Status column appears ?How to ged rid of the this error ?

17 hours ago

mithray80

Retail

Handling mutiple selling prices for one product

HiFor an example if we purchase the same product (say a book with price tagged) in two different times with two selling prices.Product 1 | Purchased 5 books on January 01 | Tagged Selling Pirce 100Product 1 | Purchased 10 books on April 01 | Tagged Selling Pirce 120When entering a Sales Order how can we the select price of the book (either 100 or 120)?If we are using FIFO to issue the goods, is there a way to allocate the stock automatically when selling 8 books in the above example.Selling 8 books , 5 @100 and 3 @120

20 hours ago

joshmcgrewJr Varsity I

Distribution

Fusion WMS

Has anyone had experience with Fusion WMS?I am getting a login error upon sign in to the fusion app on our tc21 scanners that says “Error: The request is invalid” I can sign into the acumatica app with the same account no problem and The user has all the correct Fusion and Branch access roles. I just wanted to see if there is a step im missing or anyone has had experience with the mobile app.

23 hours ago

mprimeau

Financials

Quebec sales taxes?

Good morning, i’ve recently started playing with Acumatica, and I’m trying to figure out the (sales) taxes for Quebec.Normally, for the rest of Canada I assume, you’d use two fiscal agencies, one for the federal tax and one for the provincial tax. In Quebec, both are handled by the provincial government, so two taxes added at the same time, handled by one agency, which also handles the federal part (and HST) for the rest of the country for Quebec companies. How would I set that up? It can be done using two different agencies both named the same thing, almost, but that’s not the most efficient way to go.I’ve managed to put them under the same agency, but then the taxes amounts are combined in the report, and we have to report the numbers separately, so that doesn’t help either. I’ve only previewed the report however, so they might be separated in the final complete report, but I haven’t made it this far yet. Both taxes need to be in the same zone, and often the same category, but need t

1 day ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1752 topics
5785 Replies

Distribution

1695 topics
6517 Replies

Manufacturing

595 topics
2231 Replies

Construction

571 topics
1927 Replies

CRM

157 topics
453 Replies

Field Service

279 topics
922 Replies

Retail

453 topics
1993 Replies

Payroll

213 topics
709 Replies

Low Code | No Code Customizations or Integrations

219 topics
798 Replies

Develop Customizations

2375 topics
9634 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
6762 Replies

Import and Export Scenarios

666 topics
2755 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

Sagar GreytrixPro I

Import and Export Scenarios

select Multiple Order Lines in Import scenario using ADD PO Lines Action on Purchase Receipts

8 hours ago

CorbinHurstFreshman I

Reports and Generic Inquires

Backorder Report - Linking inventory ID to Purchase order "expected Date"

9 hours ago

mrthanhkhoiJr Varsity II

Develop Customizations

Filter grid records by custom field

10 hours ago

skumar98Freshman I

Distribution

Error status 'Update Purchase Order Status' Screen

Why does this ‘Error Processing PO’ in EDI Status column and ‘Error’ in Error Status column appears ?How to ged rid of the this error ?

17 hours ago

mithray80

Retail

Handling mutiple selling prices for one product

20 hours ago

joshmcgrewJr Varsity I

Distribution

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

2 days 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

2 days 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