Solved

We have a customer that is running the AR Aging report and I see a phone number place in the report but the customer phone number does not auto print on the report.  How can we get the phone number to appear?  

Hello all,Whenever I use an equation (apologies if wrong terminology) in report writer, the formatting field doesn’t seem to affect the actual result. In this case, it will always return 4 decimal points when I try to format it to return 2. Take note of ‘Payment Applied’ - you can see it returns 4 decimal pointsWhenever I use an equation (for example, the above), it ignores the formattingI have tried =###,###.00 , =###,###.## , =######.## , =######.00 , all with and without the quotations as seen above. Any insight into this would be great!

Hi Everyone.Once again I need your assistance. I need to show the unit cost by year on the report designer.Each year needs to be on a seperate column and all the unit costs for that particuar period need to show.The structure would be similar to the screenshot attached. Is this possible. So the report will need to adjust based on the number of periods. The max periods should be around 3 to 5.So each column would be a specific period and the data in each column the unit cost of the inventory item. What I need assitsance with is showing the periods input in the parameters as columns.  

 Has anyone encountered this error and a solution. When releasing a payroll adjustment

Hello, I saw that there was during the presentation of the 2022R2 a point which is in development: Blueprint annotations. Does anyone have any details on this? This is a feature I was waiting forThanks

Good day, I would like to use the same report designer report in both the AR Print/Email Invoice that I just revised in SO Print Invoice.I basically want the user to have the same report used in the Print Forms area.  Hate have to redo it. Report version is here Sales Orders I need also here: Your assistance would be greatly appreciated.Thank youEvan

Hie , Does the Advanced manufacturing module cater for multiple base currencies.

HiI need to design a QT from scratch, it’s suppose to take the format provided below in an excel sheet.Which tools in report designer should I deploy to achieve this and more specifically draw the tables? Regards  

 I’m attempting to add a new custom table / dac into the PO Entry screen.The new DAC is tied to POLine and it can be a one to many relationship.I have PXParent and PXLineNbr attributes defined in the custom DAC and have the appropriate dac fields marked as IsKey = True.  I have a vew declared, and when I insert into the view the key fields are defaulted from the selected PO Line as they should be.When I debug, I can see the records in the cache in the Inserted collection.When I call the Base.Save.Press(), nothing is persisted to my custom table.No errors are generated, and the inserted record still shows in the cache inserted collection.I’m hoping I’m missing something simple, any ideas? View declaration public PXSelect<AHSPOLineNonConf, Where<AHSPOLineNonConf.orderType, Equal<Current<POLine.orderType>>, And<AHSPOLineNonConf.orderNbr, Equal<Current<POLine.orderNbr>>, And<AHSPOLineNonConf.lineNbr, Equal<Current<POLin

When opening a service order, the contacts area does not get populated (e.g., email).  Is there a certain order items need to be completed on the service order so that everything populates?  The contact info is in the system so there are emails and phone numbers for the contacts we are choosing.

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.