Solved

Hi,We are currently trying to create an import scenario to Reclassify Transactions - depending on the external ref / transaction description, the GL should be reclassified to specific branches. Looking for some help to get the import scenario working.Note that we cannot use the screen filters normally, since they only allow for one condition at a time, and no conditional replace. Doing it manually means to load, replace and process hundreds of unique refs/descriptions each one at a time.The import scenario is as follows:Current just trying to get the Load Transactions button working, so we have deactivated the other steps, but we are running into unspecified view errors. The data provider is not used. 

Hello All, I would like to ask for your help guys. How can I show in the report designer and generic inquiry the RELEASED DATE and RELEASED By?In the > Purchase Receipts          > Bills And Adjustment          > Checks and Payments         > Receipts        > Transfers        > Adjustment       > and others, all with release function/action  Thank you. I really need your help guys. 

I have a customer with a very highly customized Sales Order Invoice form and needs to find a solution for improving the performance of printing the report.  The customizations are specific to an Order Type - format 1 prints for “RO” orders and format 2 prints for all other order types. Creating 2 unique report formats is one option however we would like a solution where the system automatically selects the correct report when the print action is selected.Please let me know if you have any ideas.Thanks!!Michelle

Client has attached the wrong PO receipt to the Landed Cost? How do they correct?

Hi, I have to load two separate customizations for two different tenants under the same Acumatica URL. None of them are test tenants. I keep publishing but if I post the one the other always get unpublished. Any suggestions? Thanks,Frances   

Hi All.I want the system to refresh the currency rate from EUR to CHF daily automatically. So I created an automation schedule of “Refresh Currency Rates”. It is being executed at the scheduled time, but there’s no processed reocrd (see below). Could someone please tell me what’s wrong? Thanks!And the settings are the following: 

Is it possible to change the account group type? I set up an account group that was linked to all asset accounts, but the type was listed as expense, and now I am unable to change it to asset. Is there a way to adjust this?   

Is there any sales price history tracking report for sales orders item-wise and AR invoice item-wise?

Hello.  Is an extension project required for use in the workflow API?  I don’t see this question answered in the training class, although it’s example uses the extension library.  When building a workflow code file for use in the website App_Runtime folder (instead of a .Net library), an error happens in a transition.  I’m unsure if the ambiguity is legitimate or not.  

Has anyone tried to concatenate a barcode for the Scan Move form?  For example, I would like to concatenate Production Nbr & Operation & Quantity into one bar code.  I attempted to modify the Production Ticket with Barcode and attemped these codes for starters: =[AMProdItem.ProdOrdID]+'<CR>'+[AMProdOper.OperationCD]=[AMProdItem.ProdOrdID]+'Chr(13)'+[AMProdOper.OperationCD]=[AMProdItem.ProdOrdID]+'Chr(19)'+[AMProdOper.OperationCD]=[AMProdItem.ProdOrdID]+’\n’+[AMProdOper.OperationCD]=[AMProdItem.ProdOrdID]+’\r’+’\n’+[AMProdOper.OperationCD] I obviously don’t know what I’m doing trying to code the carriage return / pause/break / line feed to make it work with the Scan Move form.  The codes above do combine it into one barcode, but the issue is whether I can code something into the barcode that pauses for a second while the Scan Move form moves on to the next prompt. 

How does one filter the Purchase Order Receipt and Billing report to only show Unvouchered Receipts?

Hi guys.How can I make a user defined field required for only a soecific branch. I am sure this can be done on workflows but its not working out for me. Has anyone tried this?Please let me know. Thanks community.

Hi,We have an requirement from our client, they need to send both packing list and SO Invoice when sending the email from Email Invoice function. I have tried with the EmailTemplate Attach Report Scenario, how ever it was not successfull.Appreciate if anyone can point me the option that I have used was wrong, what is the correct method to do this or other wise is there any other option available.Please Note this Packing List is a Customized Report. Best Regards,Kavindu

I’m working on a GI to display the following information for future audits. Basically, the auditor wants to see a list of field changes on vendors within a given time frame. They want to pick one of the changes and have the team pull the necessary approval paperwork for that change. I’m currently using PX.SM.AuditHistory and PX.SM.Users. Here are the needed fields:OperationChangeDateUsernameTableNameModifiedFieldsScreenIDChangeIDOld valueNew valueI was able to get the fields listed except for the old field value and the new/updated field values. Doing some research, I think that this information is stored separately, but wanted to ask the community first. Is that “change” information stored separately?

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