Solved

I have queried both tables separately but can’t find anything that matches between the two.Thanks for your help 

Copyright © 2005-2022 Acumatica Inc. All rights reserved.Acumatica Cloud ERP 22.110.0018Build 22.110.0018 + All, we can’t search by Sales Order Lines -- if we enter a string in the search field (magnifying glass), we simply get a spinning blue circle. Log out and log back in and it seems the main screen seems to hang and can take about 30 to draw/display.Known bug? Something we can try to alleviate?

How can I add the ship to State to the Sales Order by Customer Report - or any sales order report? Thanks

Hello Everyone!I have query, hope you guys can help me out. We have an existing inventory list, all of which LREX is not enabled...but now we want to enable the LREX monitoring, is this possible? What are the conditions e.g. should the qty be zero? is it set in the PO stage of getting new qty of the inventory item? Are there any more conditions? Also how can I apply the LREX monitoring to the existing qty of items? Thanks in advance!Kind regards,Mrivera67

I have this GL Error showing up when I am disposing an asset owned by CEMPLEXFL branch but wanting to deposit into my MAIN branch CASH account - that is NOT restricted by branch visibility.  It will not let me reconcile my Fixed Asset.  I am thinking the FA module is not set up correctly with the multibranch ?  Can anyone advise?  THanks  

How to create a Template/Report which will combine Parent and Child Purchase orders with inventory Id’s.

Dear ALL,Please help to fix Error CS0234 The type or namespace name 'Fluent' does not exist in the namespace 'PX.Data.BQL' (are you missing an assembly reference?) in Visual Studio.Best Regards,NNT 

Hi, We are trying to use Australian Diminishing Value in Fixed Assets, however system forces us to use ‘useful Life Year’.This method is only capturing the place-in-service date, the cost and the percentage per year.So it does not make sense to have years against each asset, as it’ll change the method. Can someone assist and let me know how you imported your assets using this method? Thanks,Foujan

Sub report​​​​Used filters in the sub reportAbove sub report was created to get the bank name, bank code and branch code. All the different data come under a one data field as below. Please check the below images.Sub report viewBelow image shows the DAC related to this.DACI want to assign the Account Value column data corresponding to the 4545,4546,4547,4548 and 4549 ID shown in the above image to separate variables, in order to send them to the main report. If is it possible, can I know how to accomplish my task?

Screen modifying: Print Production Orders (AM511000) - in version 22R2Overall Goal: Pass Report ID from custom selector to be used in the print report process instead of reportID off line item.Issue: custom field returns null instead of selected value  I have created a custom selector that lists Report IDs from the AM module on the Print Production Orders form, and I have modified the BuildReportRequiredException method so that I can pass the selected Report ID through to be printed for any processed records. However my custom field in the ProductionOrderPrintProcessFilterExt DAC extension is returning a null value every time instead of the selected value.Note: I’ve even tried creating a simple text field within the DAC extension and that also returns null when trying to process the record instead of the value entered.   Graph Extension: namespace PX.Objects.AM{ [PXProtectedAccess] public class ProductionOrderPrintProcess_Extension : PXGraphExtension<PX.Objects.AM.ProductionOrde

Hi Everyone, How to create a bill directly from PO not PO receipt?ExamplePO created - material + freight(non stock)PO receipt - only material When I create a bill, I can add the PO receipt details, so freight cost will not be added on the bill. If I manually add it in the bill, will there be a problem on the PO side? My boss doesn’t wanna add the freight cost in the PO receipt, since freight is not a material.  

Hello,I have several Union Employees who live in New York City but at times travel out of state for work. As per the NYC tax code, all wages are subject to NYC personal income tax regardless of where the resident works. https://www.tax.ny.gov/pit/file/nonresident-faqs.htm#:~:text=All%20city%20residents'%20income%2C%20no,for%20New%20York%20State%20domicile.At the same time the Employee will be Subject to the locality they are physically working in tax. This creates a scenario where I need to withold taxes for the NYC resident employees 2x once to NYC and once to the locality actually worked in. How can I solve for this in Acumatica?

I’m not sure if I’m terming this correctly, and I’m also not sure if this is addressed in purchasing/receiving or if this is separate and is more of a kit consideration.We are a service company.  The scenario is that we purchase an item from a supplier, but sell the items components as separate items in our system.  My thought would be to create a “reverse” kit that can be “assembled” to negate the purchased item and increase the component count, which is the opposite of the normal assembly process for non-stock kits.For example;  We purchase a repair kit/item from a supplier, which contains a bolt and a bracket.  We will receive the item, however we want to stock the components as inventory.  We will then use/invoice either the bracket, or the bolt, or both, however those pieces will be invoiced as separate items.Any thoughts on how to make this work in Acumatica 2022r2 (or beyond)?   

Hello Everyone, I am trying to create a email template to be used when sending out an email from a payables report. I wanted to embed both the vendor’s name and a logo of our company on the report. The problem is that I cannot do both on either the notification templates screen or the report designer mail settings body section. If I use notification templates, the vendor account name does not show up as the screen I am using does not appear in the screen selection. Does anyone know if it is possible to embed an image in the formula editor?   

Is there any way to within a GI using the IIF command to do the following?I wrote a GI to pull all of the SO’s of a certain customer along with the associated invoices created from the SOShipments.  No problem.  See attached screen shot below for an example.What I would like to do is set the “Sales Order Total” to be 0.00 if there are more than one associated invoice numbers.The pseudo code logic statement would be something like this:IIF (‘Order Nbr’.row-1 = ‘Order Nbr’.row), ‘Sales Order Total’=0, ‘Sales Order Total’)Using this type of logic then the second line in the example screen shot below would be “0.00”, while the first row would be “14,283.93”.  (Ideally that value would be set to NULL, so that no value at all appears there...but that may be even greater wishful thinking.)Is something like that even possible to do in an Acumatica GI?    In some ways, yes, I trying to create a ‘group by’ function inside of the GI.

When creating a new change request there are a default checked “Create Commitment” box, as shown below. So, we want to make this checkbox unchecked by default always. Is there a way to modify this setting? Thanks! 

Our client wants to have a report that can be split into two columns in one paper page where each column has different details from different barcodesThis is from Production Order Details screen and when there is two lines that is checked for print barcode, the report must show 2 columns with different details from it.Example:Question:Is it possible to achieve this one? If yes, how?I am very new to Acumatica so it will be kind of you to answer my newbie question :)Note: Every column has different barcode so it has different details too.

Vendor 1 and Vendor 2 need to show page 1, then vendor 3 and 4 need to show page 2.but other details show same format

Transfer of goods through vehicles have certain taxes (E-way bill) in India. Can we track this bill in Acumatica ??   

How does the defaut account work or what is it ment for in the equipments. I’m aware of the rate Item for the projects costing, I would like some light on how the defaults works as the explanation is not clear.  

Hi, I’ve added supplier bank details in the supplier master GI, but bank account number is not displaying in the same format as per the supplier master payment instruction. so how we can solve this.I would really appreciate, if someone can help me on this.         

Hello All, Does Acumatica have any method to identify how a record has been created or is being created? By this I mean whether a record is created by user through UI, an Import Scenario, an API call … or we have to come up with creative solutions? I know in events we have e.External that identifies if UI has made the call or some internal processes but I have not come across entry source identifying methods? Any help is appreciated. @Yuriy Zaletskyy

I’m trying to build two ‘alternate’ sections:Limited space that only shows “Continued” (if the details extend beyond one page) Visible expr: =([PageIndex]<[PageCount]-1) Larger space that shows the full subtotals (intentionally the second-to-last page for terms & conditions at the end) =([PageIndex]=[PageCount]-1) If I apply the visible expressions to the group, it does not appear on any page.If I apply the visible expressions to the individual fields, it appears as-anticipated (though this defeats the purpose). Additional information:The ProcessOrder is Always in both scenarios The PageIndex and PageCount are definitely calculating in both scenarios Both are GroupFooters that are setup to PrintOnEveryPage (with the above exceptions, if I can get them to work)Any ideas? Suggestions?

Doing some editing work on stock Dunning Letter Form, but can’t seem to figure out how to manipulate the ARDunningLetter.Deadline field that is showing up on my Dunning Letter. Looks like it is adding 3 Days to ARDunningLetter.DunningLetterDate, but not sure where that additional 3 day setting would be coming from? 

Hi TeamLooking for an Import scenario to update the Sync field on the ‘BOPIS Store to Sync’ grid.Thank you.Screenshot for reference