Solved

Hi,For Acumatica authorization such request is used URL : https://ath.acumatica.com/entity/auth/loginBody ;                                              {"name" : "admin",                                             "password" : "somePassword",                                             "company" : "",                                             "branch" : "",                                             "locale" : "en-US"}Sometimes company, branch, locale are obligatory, sometimes are optional.When we use Oauth 2.0 authorization to Acumatica I do not see the usage of these parameters anywhere My question is : Does Oauth 2.0 require company, branch, locale for authorization ?How Acumatica process these parameters for oauth2.0 ?

Hello guys,I am facing this issue after upgrading Acumatica from Build 22.202.0040 to Build 23.105.0016Here is the source code when I open by Visual StudioWhat I have done is:upgrade Acumatica  22.202.0040 to  23.105.0016 Update dll file by building Project StockItem in Visual Studio (see my image above) Reload the siteDo you have any idea about the root cause?Thanks in advance. 

I’m looking for a fully mobile label printing solution. I’m looking at the zebra zq500 series. It says it is compatible with iOS apps, but would like to confirm that I would be able to print from Acumatica’s iPhone app to one of those printers. If not, could we use a Zebra mobile device to send the print jobs from there?

Hello Community,I have a scenario where the prospect not only does the local shipments but also does shipping of the items overseas. Was wondering how can we record the overseas shipments in Acumatica.The flow is like: SO→ Shipments forwarded to forwarding agencies (with invoice & packing list) → Customs Clearance → Delivery to the overseas customer.Thanks in advance.

Hi Acumatica People,I am setting up a new environment and I did the following: -created a customer after I had set-up my customer classes-set up my reason codes-set up my warehouse with locations -created two items-Entered receipts (like this): -Entered the order: We haven’t changed any setting associated with Project (which is part of our planned implementation). This order is non-project order (identified in our settings as X).  I am presently going through the “Project Inventory Tracking: Implementation Checklist”. Are there standard set-ups for the non-project, X, that I have missed? Thanks, Patrick      

Hi all, We’re trying to create integrations and during the testing, I’m running into some issues with the api parameters. Does Acumatica support the following?  entity/default/22.200.001/vendor?$filter=VendorID eq '501446'&?$expand=MainContact,MainContact/AddressI find that when I try to use filter or select when expanding that I get unexpected or limited results. Is this a limitation of the api or is my syntax not correct?I’m trying to get an efficient query that gets a couple of fields on the vendor entity and a few off the expanded entities. I have been able to remove filter, select, and expand and get the entire data set, but I don’t want that waste in the automation.  Thanks in advance!

HI All,Currently the exported pdf version from Report Designer is shown commo “,” as the grouping symbol.Is there a way we can change from commo “,” (19,941,572) to dot “.” (19.941.572)?Thanks in advance,Yên Chi

Hi all,I want to format use a dot not comma as a thousand separator. But I don't know how to format it, I don't quite understand.I expect it show as 2.223.600

Hey all hope everyone is doing well! i have this custom object that creates information about POs from the mapping manager and i want to add it to the endpoint but i don’t know how, becasue i want to use REst API to POST and GET   How to add it in the Endpoint web services    Thanks

I am looking for an explanation of these settings on the Ship Via Advanced Fulfilment Tab. 

On my custom screen, I have a “dummy” form that includes a tab with two tab items.  Each tab item has it’s own form.  Each form is essentially a screen with it’s own DACs.I COULD create two separate screens, one for each tab item, but I want to include them on one screen.For a single form I would add the primary DAC to the graph declaration to add the full toolbar to the form (cancel, save, new, Next Last etc.)However, each tab is a unique form.  I want to show this in each tab item.To reiterate, this graph does not have a true “primary” DAC.  The main form just has a dummy primary DAC (PXFilter<MasterTable> MasterView;).  I’ve hidden the standard buttons for the main form.This is the aspx for this screen.<%@ Page Language="C#" MasterPageFile="~/MasterPages/FormTab.master" AutoEventWireup="true" ValidateRequest="false" CodeFile="IC102000.aspx.cs" Inherits="Page_IC102000" Title="Untitled Page" %><%@ MasterType VirtualPath="~/MasterPages/FormTab.master" %><asp:Conten

The Billings I manually grab the total sales from the P&L report.I want to add this in report designer which field i have to select ?

Hello, I am trying to concatenate string and integer fields from ARSalesPrice Table - InventoryID, CustPriceClassID, PriceType, CustomerID, BreakQty.  The purpose of this GI is to count if we have duplicate prices at the same break qty. But currently, it does not let me concatenate string and integer fields together.  Could you please advise how that is achievable? 

Hi,I need to add Vendors list popup on details grid on sales order page. I created new field in database with customization studio. Also added DAC extension then I update sales order screen (SO301000)but it just displays regular I want to have it like on Vendor Price screen (AP202000) 

I’m trying to create a condition so that I can hide an action if the customer doesn’t have terms or if their terms require some prepayment. Below are is the condition I created in the customization.  I then set the Hidden option for the action to the above condition  However, the action is never not available. How do I get it so that the action is hidden whenever the terms are not any of the prepay options?

Does anyone know of a table/datafield that stores the site URL? I’m trying to feed parameters into a GI navigation link and have it be transferable across multiple sites without needing to update the URL on each site. Thanks!

Hello,We have just upgraded from 2019R2 to 2023R1. In 2019R2 I was previously able to change the template ID of an existing and assigned stock item if I had the “Edit Template ID” checkbox enabled in the item class. Today I went to do that and the Template ID is greyed out and unable to be edited. Is this a bug or new behavior? Is there anyway around this without making a customization to reenable this field?Thanks you in advance. 

Could someone point me in the right direction of where to start on a Generic Inquiry that can show Project Managers the ‘burn rate’ / spending's on their project based on certain dates?So two scenarios - Time Entry / Labor. We enter time and process payroll via Acumatica. There are a number of Inquiry Title pages that contain billable time fields and amounts, but I couldn’t seem to get that correlating / summing properly by Project. On top of that, would need a way to say ‘pull this data between these dates’ or from the previous weeks dates.The other one would be project transactions during those dates. However I’m not sure how I’d accurately show these dates because bills can be entered but not paid at the same time.Appreciate any insight!

Hello,We are running into an issue currently where users are able to see all AP Batch Payments under the “Batch Payments” screen even if they do not have access to that Company/Branch. When they click into the batch, they are unable to see the payment details, however if they have access to the Release function, then they are able to release that batch. Is there any way to prevent a user from releasing a batch that is not within their branch access list? And/or can we restrict their view from the Batch Payments screen?Thank you!Ashley

When setting up a Vendor for 1099 reporting purposes, the option to select a 1099-INT form is unavailable. How can I report Interest income?

Hi, I have a client that has a question for the Approvals grid under Time and expenses. In screenshot 1 they want to know why the note section is not highlighted like it is in Bills & Adjustments in screenshot 2. I tested in our demo and same thing. Is this by design? Client is on 2023R1.Sceenshot 1: Screenshot 2: Thank you,Frances  

I have created a Import Leads Scenarios, but I’m unsure what to put for the source field/value for Lead ID. The below screenshots mapping works, but it’s actually inaccurate as it is possible for 2 person to have the exact same first name and last name. e.g. when import successfully with 2 records of the same first name and last name, the leads only show 1 record, but it should show 2 records.any idea how can I fixed this import scenarios? thx

Is it possible to NOT specify a default payment method for Customers? We accept account payments at the Cashier (our own POS) and they can be in several different tenders and two currencies.I know that this can be overridden when entering an Acu journal voucher but when uploading an excel file of payments those ARPAY entries where the payment method isn’t as expected throw an error. The user can go back and edit to override those errors but that’s introducing an extra step.Is a custom scenario my only workaround?

We’re trying to use an iPaaS service to search a customer record by email and add an activity, however we’re getting an error message and having difficulty deciphering its meaning and/or what might be causing this.Here’s our PUT request:PUT https://pXXXXXXXX.acumatica.com//entity/Cyclr/20.200.001/CustomersByEmail?$expand=Result HTTP/1.1Accept: application/jsonAuthorization: REDACTEDUser-Agent: Cyclr, (https://cyclr.com)Content-Type:application/json; charset=utf-8Content-Length:47{"Email":{"value":"kXXXXXX+test201@gmail.com"}} 500 Internal Server Error:{"message":"An error has occurred.","exceptionMessage":"The given key was not present in the dictionary.","exceptionType":"System.Collections.Generic.KeyNotFoundException","stackTrace":" at System.ThrowHelper.ThrowKeyNotFoundException()\r\n at System.Collections.Generic.Dictionary`2.get_Item(TKey key)\r\n at Microsoft.Data.OData.Query.SyntacticAst.ExpandBinder.GenerateExpandItem(ExpandTermToken tokenIn)\r\n at System.Linq.Enumerable.Where

We are trying to figure if there is a way to setup an email template for the Inventory Register Details report (IN614000).Current Process: The user enters a new record using the Issues screen (IN302000) and then they run the Inventory Register Details report (IN614000). After reviewing the report they click the Send button which opens the Email Activity screen. The user then has to enter the To address, the Subject, and the Message. Is there a way you setup a template for this report so they user doesn’t need to fill in all the information each time they send the report?Thank you!