Solved

Hello Everyone,I have a SQL View where I join some tables in each block and then, using UNION ALL, I combine all blocks and return a list. In Acumatica by using PXProjection, I should be able to replicate the result of each block as a flat DAC but I am not sure how then I can aggregate these Projections to get a unionized result of all DACs. As a very simple example, how I can replicate the below SQL example in Acumatica?CREATE VIEW [MyUnionView] ASSELECT 'AP' AS [DocType], [RefNbr] AS [RefNbr] FROM [APInvoice]UNION ALLSELECT 'PO' AS [DocType], [OrderNbr] AS [RefNbr] FROM [POOrder]UNION ALLSELECT 'PM' AS [DocType], [ContractCD] AS [RefNbr] FROM [Contract]GOSELECT [DocType], [RefNbr] FROM [MyUnionView]GO 

Hello!I’m invoking a processing form through API, and all the process is executed correctly, but, how can I know when a record is processed with errors?I’m trying to get the processing result to know what records have been processed and what records have raised errors…  

If you Move code to an extension library (DLL), can that code be published to a hosted Acumatica Site.  By Hosted I mean a site that is like youcompany.acumatica.com.  An instance hosted by Acumatica, which you cannot access the servers. 

During picking a handful of times, we are getting this error. I’ve checked each time and the lots are correct, the correct qty is allocated/picked, but the system will not let us move to a sorting location. Is there anything I can do that doesn’t involve adjustments? 

Does anyone know how to setup Quebec taxes (GST+QST)

I am looking to modify the FA643000 report.In the stock report I see a table called FAProjectedGLTran.What is the source of this data?Maybe I am missing something but I can find no reference to this table other than in the report builder.

Hello,We created a UDF on the Change Orders Screen We want to restrict some users from being able to change the value of this UDF, but they need full access to the rest of the Change Orders screen.I do not see the UDF in the security tree for Change Orders as I expected.So I tried restricting “ANSWERS” to VIEW ONLY and can still change the value of the UDF when logged in as this user.How can I make this VIEW ONLY for a role?

After clicking Calculate BOM Cost in the dialog box its not showing the cost value. 

Hi, We would like to print our checks to out dot Matrix printer we have the correct layout but printing from the AP.64.10.00. Its almost like the printer can not understand how to print this.  We also cant add the check in the Device hub Q as this report can not be added to that Q this leaves us with the PDF check report that opens on the a new tab and this report is not printing to our dot matrix printer. is there a config in the Report Designer that would allow the dot Matrix printer to decode the strings and print them.  Please let me know if someone has managed to print checks to a dot Matrix printer out of Acumatica. 

We are on 2021 R2 with the Big Commerce connector.  Can we configure Acumatica to limit which warehouse the customers can shop from when the customer is shopping in our connected Big Commerce website?

Good Day,This is my first time to post here in the site, please bear with me. :)One of the requirements of our project is to duplicate an existing screen (Customer Contracts) into a new screen (Vendor Contracts) imitating the existing screen. I already saw one approach that the asp files can be copied and renamed but that is possible only for the ASP files.Could this be possible? If so, are there other things to consider (graphs, DACs of the existing screen to be duplicated as well?) Are there other ways to achieve this?I'm still new to acumatica btw. Any responses are very much appreciated.Thanks and stay safe.

Good day!I managed to import AP Bill with type=bill successfully using Import by Scenario. But those with type=debit adj. ,system shows warning message below. Any advice?   

Hi everyone,  How can we apply partial payment in acumatica? after invoice is release, the invoice is 100, and the customer paid only 70. whe we applied the 70 in the payment , it shows “the document is out of balance”. Can anyone help? Thanks!

Good day,This isn’t causing any particular issues per-say, but ever since we’ve upgraded to 22R1, we get the following warnings when publishing customizations.\Controls\PageTitle.ascx.cs(877): warning CS0219: The variable 'webItem' is assigned but its value is never used\Controls\PageTitle.ascx.cs(1105): warning CS0414: The field 'User_PageTitle.auditMenuEnabled' is assigned but its value is never usedCustomization Log SampleI’m more just curious where this might have crept in, and whether it’s specifc to our instance, or if more people are seeing this one.If anyone is aware of a solve for this warning, that’d be great too.

I have added the ‘Add PO Line’ action to the PO receipts screen on the mobile app by following the steps on the last few pages in the T410 manual.  This works great to add the lines and release the receipt.  To streamline the process, I would like to have the ‘Add PO Line’ action available on the Document Summary screen by default.  To explain further, if I update the ‘formActionsToExpand=’ to 4, then I have all actions appear at the bottom in this order: Hold, Assign, Release, Add PO Line.  If I update it to be ‘formActionsToExpand=’ to 2, I have Hold, Assign, … with the option to select … and Add PO Line.How do I get it to be displayed as the following: Hold, Add PO Line, … on the document summary screen for the PO receipt?It appears that when I added priority, listPriority and formPriority were not available options in current context.  I have also attempted to add the action, as I’ve done, then below it say update recordAction in attempt to reorder the actions.

What are the best practices for booking Shareholder disbursements in Acumatica? Should this be thru AP as Vendor payments?

Version 22.109.0023, was trying to print Lead from report designer by using CRLead, but seems that OwnerID, OwnerID_Descirption are not loading owner data properly, so where I should read Owner field then?

Hey guys, I am trying to sort the values in the rows of a pivot table to ascending order. Tried changing the same in the Pivot table by changing the sort order and sort by but the result is not as required.  In order to get it in an order, I have changed the names for appts in Workflow stages, but still not getting the desired result. Need to see 1-New followed by 2-Tentative and 3-DEL/INST/INSP and so on. Would appreciate your help :) .

Is something like this possible? I wanted to avoid excel by making a calculated field that summarizes a single or group of inventory IDs through GI or report designer. So a calculated field would look like this...=IIf((( [POLine.InventoryID] = 'DULS001') OR ([POLine.InventoryID] = 'DULS002')), [POLine.LineAmt], '')Results would look like this...    Calculated Field Calculated Field Inventory ID Line Amt Dulse Kelp DULS001 200 200   KELP001 500   500 DULS002 300 300  

Hey guys,Have been tasked to add a production order maintenance side panel onto Appointment details and Sales orders screen. I am finding it tough to merge the tables in order to achieve this.Any recommendations? 

We haven’t even started using the system at work but we’re supposed to test it out and both times I tried logging in I got locked out. Why do you lock people out if they are using the password that was set up, then they have to reset it but can’t. Why, because they are locked out. This is terrible and I cannot be the only person who has been locked out of the system. 

Hi, seeking for help on how I can implement the following: Sales Order Header & Details Tab:    Description: We don't want to show the Status.    Shipping Rule: Ship Complete Sales Order: Financial Tab: Credit Card Sales:     Payment Method: AUTH NET    Cash Account: WELLSFARGOAll other sales: Use companies default payment method (I think this is doing this already) Sales Order: Shipping Tab:     FOB Point: Prepaid    Shipping Rule: Ship Complete Sales Order: Totals Tab:    Freight Price needs to populate in Premium Freight Price instead.  Invoice Description: No Status (Assuming its the same information from Sales Order, but including in case it isn't) Order Comments:   Can we have order comments printed as a line note on the packing slip? Preferable the very last line item.   Thank you. 

Hi Team,Maya i know how to create “Tree structure “ for a customized selector field in acumatica. Please help me on this.Sample like this: Regards,Ramya

Hi Team,Please let me know, how to add “Approval Process” on Bill of Material screen.I tried to follow the below link, but it is for customized screen.https://www.acumatica.com/blog/implementing-approval-process-on-custom-screens/https://stackoverflow.com/questions/52210880/adding-standard-approvals-to-custom-acumatica-erp-module Appreciate your help, thanks in advance Regards,Ramya

In a report I want to highlight/ change the background color if the value is greater than 1. I understand i need to put two fields on top of one another. One with the default state and one with the changed state. my questions are as follows:=[POLine.BaseOpenQty]=[POLine.BaseOpenQty]               Do I use visible expressions for each field? Can you help me write the expression?I am leaning towards an IIF, but that is as far as i got.