Solved

Hello Community,Does anyone know how to prioritize loading the extensions? Let's say I have two or more extensions on a base graph. How we can educate the platform on which one should be executed first and which one next? or necessarily I should declare my Graph Extensions hierarchical? For example, if I have a MyExtA that has priority over MyExtB I should do public class MyExtA : PXGraphExtension<BaseGraph> {}public class MyExtB : PXGraphExtension<MyExtA , BaseGraph> {}

Hi all,how can I solve root element missing in report designer? Thanks

I thought that the only time a View gets populated with records if is you make a call to “View.Select()” or if the View references a “fromcurrent”.In the following simplified example, I have a graph with a view.  When I run a SelectFrom statement, without referencing the view, the view gets populated with records and I don’t know why.PXGraph joesGraphin the joesGraph there is a view:public SelectFrom<ICSARAddressSQL>.View JoesView;In my method, I use a fluent BQL to fetch records in the ICSARAddressSQL table (which is actually a SQL View) where the customerAddressID is equal to “item” where item is the CustomerAddressID I am fetching.  Then I check to see if that record is in the joesView cache.  If it is ALREADY in the cache I update the cache record.  Otherwise I add it to the cache in the ELSE section.foreach (ICSARAddressSQL record in SelectFrom<ICSARAddressSQL>.Where<ICSARAddressSQL.customerAddressID.IsEqual<@P.AsInt>>.View.Select(joesGraph, item)){       

Hi all, fairly new to Acumatica -- is there a way to set the default origin of a dropdown menu? We always want our FOB point to select a default instead of manually setting it. Please see screenshot. Thanks! 

I wrote a new P&L in ARM with expense rows coded to show as negative. It works correctly in the report, but when exported to Excel I have the problems below:Amounts appearing as positive in Excel but negative in the formula bar (i.e. Excel treating as negative but appears as positive) Amounts appearing as positive when they are actually negative (opposite of #1) Amount showing as negative in both Acumatica and Excel (correct) but in formula bar it’s actually pulling through as a positive numberBasically the negatives are all wrong in Excel, but not consistently so 🙃 I’ve looked extensively online and in the community but haven’t found a solution. An example of the row format is below:  Appreciate any help! 

Issue:  I need a formula to work one way when its to account 0500 and another way when it isn't.  I tried: 0500 ‘0500’ and “0500”, and the formula is only returning values for the false.  How to I format the expression to return the result for when its True.   = IIf( [GLTran.AccountID]= '0500', ( ([GLTran.CreditAmt] *.5) - ([GLTran.DebitAmt] ) *.5) , ([GLTran.CreditAmt] *.75) - ([GLTran.DebitAmt] ) *.75 )

We are trying go paperless with Pick List for our warehouse; Does anyone know how to make the Item’s barcode and the bin location’s number to display on the Pick List as a barcode?  Like the pic below, thanks... 

Error is occurring when adding InventoryID to ARTran .Stack Trace:Error: An error occurred during processing of the field InventoryID: CS Error: Invalid mask specified in segment 5 for Sales Sub. from..PX.Objects.CS.PXMaskValueException: CS Error: Invalid mask specified in segment 5 for Sales Sub. from.   at PX.Objects.CS.PXDimensionMaskAttribute.MakeSub[Field](PXGraph graph, String mask, String[] allowedValues, Int32 DefaultValueIdx, Object[] sourceIDs)   at PX.Objects.AR.SubAccountMaskAttribute.MakeSub[Field](PXGraph graph, String mask, Object[] sources, Type[] fields)   at PX.Objects.AR.ARInvoiceEntry.ARTran_SubID_FieldDefaulting(PXCache sender, PXFieldDefaultingEventArgs e)   at PX.Data.PXCache.OnFieldDefaulting(String name, Object row, Object& newValue)   at PX.Data.PXCache`1.SetDefaultExt(Object data, String fieldName, Object value)   at PX.Objects.AR.ARInvoiceEntry.ARTran_InventoryID_FieldUpdated(PXCache sender, PXFieldUpdatedEventArgs e)   at PX.Data.PXFieldUpdated.Invoke(P

HiWe have a Payment Voucher Report in Quick Checks Form that can be print when the Status is equal to PrintedStatus is Equal to Printedthe Payment Voucher Report But we want to print this Payment Voucher Report when the status is equal to Pending Print.When Status is Pending PrintReport is not showing correct values when the status is Pending Print.Does anyone know how to solve this issue?Thank you.

Hello,We are getting started and I would like to learn how to create Generic Inquiry and how to customize dashboards for users. Does anyone know of any tutorials or guides on creating them and some useful GI so I can start learning how to create them.Thanks

We normally process a single AP import containing payments for multiple branch IDs. Prior to our upgrade to 2021 R1, all invoice entries would import with the appropriate cash account regardless of the branch we are in. After our upgrade, it seems the only cash accounts populating are those that are linked to the branch we are in while processing the import.Has anyone else experienced this issue?If so, can you please advise me on the best way to fix this?Thank you!Sondra 

In the case where a client has employees working in multiple states, some employees have additional state tax withheld. If an employee works in MO and KS and has additional tax of $10 for KS and does not work in KS that week, Acumatica still withholds the $10 additional tax for KS. The only way around it is to update the Employee Payroll Settings and remove the $10 additional tax from KS for that week and then put it back again for the next paycheck. This involves a lot of intervention to prevent this and then remembering to go back and update the tax settings after generating payroll for those individuals. We need a way to have Acumatica not include the additional tax when they are not working in the State with the additional tax. 

Hi, I need to have a capability to show how many times the customer has exceeded their credit terms (late payment based on credit terms). Do anyone have any idea how to achieve this?Any help would be highly appreciated.  

Good dayI have a scenario where I created one sales order with multiple lines and the stock is coming from multiple warehouse as per the screenshot below, where I am picking stock from 3 different warehouse  I have seen that Acumatica forces me to create a single shipment per warehouse, thus three shipments from one order , creating too many documents I do not need, yet I just need one shipment and a single shipment CONFIRMATION (MY Delivery note).Is it possible to create one shipment from a sales order with multiple line items from different warehouses? How best can I manage such a situation?

Hi,Version :22.204.0019 I am unable to display all report data on pdf .pdf showing only 2 pages. I have all pages report data in Pdfcan anyone help me for this issue?

Hi All,  I have created a GI and when I try to view the generic inquiry it keeps on loading. Do you have any idea why this happens? Attached is the GI for your reference.  Appreciate any help on this.  Thank you very much.

Hello Everyone,I am playing around with various costing method scenarios in right now. Let’s say I enter a PO for 10 of an item at $100. This item is costed at FIFO. Let’s say the accompanying AP Bill is for $120. I understand there will be $20 going to PPV and $20 going to Purchase Accruals. The cost of the item stays at $10/unit even though the bill was for $120. Is there anyway to retroactively update that item’s cost to $12/unit for this PO/Receipt?   If anyone has suggestions or ideas that would be great. Maybe there is an industry standard.Thanks

Hello,I am currently going through training, trying to generate a custom object and have it be able to be interfaced via the workflow engine ui. However, when I attempt to add a field to the “State Identifier” field on the workflow interface, it does not return any available values. I plan to debug.. but figured I would put this on the community to see if there is something that immediately jumps out that I’m doing wrong.  Thanks in advance, code snippet for DAC and Graph below.Note: I realize that I’m taking a shortcut by not creating a helper class for the status values (perhaps to my detriment).. figured I would give it a shot before I go the effort to build out entirely.If I were to guess at what the problem is, I’m either not decorating the DAC or field with an attribute to signal to the engine that its a valid field to build the workflow off of. I’m trying to get away from having to code the workflow by hand.DAC:using System;using PX.Data;namespace BlyTestObject{ [Serializable]

I recently moved from using Business Central and in that system we could set up a posting table for sales and cost of sales using BOTH item class and customer group.  I’ve searched but can’t find how to do in Acumatica.This setup is great for groups as it makes it easy to split out intercompany activity for elimination.  Its also useful for segment reporting.Any ideas?  thanks Peter

I currently have the scan move screen customized to flow into the Qty State automatically to allow for a qty to be scanned in.However I would like the user to have the option to hit enter and skip the step, which would ideally pass a default qty of 1.The issue I’m running into is that the barcode field won’t allow the user just hit enter to pass a null value.Is there a way I can have null values passed through on that field?Thank you.

public class NewTest : PXGraph<NewTest> { public PXFilter<TestFilter> Filter; public PXCancel<TestFilter> Cancel; public PXFilteredProcessing<APPayment, TestFilter, Where< APPayment.docType.IsEqual<TestFilter.docType.FromCurrent>. And<TestFilter.fromDate.FromCurrent.IsNull. Or<APPayment.adjDate.IsGreaterEqual<TestFilter.fromDate.FromCurrent>>>. And<TestFilter.toDate.FromCurrent.IsNull. Or<APPayment.adjDate.IsLessEqual<TestFilter.toDate.FromCurrent>>>>, OrderBy<Desc<APPayment.createdDateTime>>> CheckPayments; [PXHidden] public class TestFilter : IBqlTable { #region IsVoid [PXString(3, IsFixed = true)] [PXUIField(DisplayName = "Doc. Type")] [PXDefault(APDocType.Check)] [PXStringList( new string[] { APDocT

Hi,I need to know, If I created a DAC extension table for the POline table and create a orderType field for the DAC extension.Is it possible to get same orderType column data inside in the POLine table into my DAC extension orderType field.ex: POline row 1 OrderType is ‘standard’ and My DAC extension orderType is same to with ‘standard’ type.? 

HelloI got client’s customization project with version 21.209.0034How to convert it to 22.210.0020 (2022r2) in proper way ?

I’m starting to get really frustrated with processing screens lately, but maybe I’m just bad at making them. The latest frustration is that when I use ProcessingView Lines, the screen looks like a processing screen: But when I use  ProcessingView.FilteredBy<PODDocumentsFilter> Lines, all the processing tools  go away: I have defined the data view like this:public PXCancel<PODDocumentsFilter> Cancel;public PXFilter<PODDocumentsFilter> Filter;[PXFilterable]public SelectFrom<SOPackageDetailEx>. InnerJoin<SOShipment>. On<SOPackageDetailEx.FK.Shipment>. LeftJoin<ISSOShipmentTrackingPOD>. On<ISSOShipmentTrackingPOD.FK.PackageDetail>. Where< SOPackageDetailEx.customRefNbr1.StartsWith<fedEx>. And< Brackets< PODDocumentsFilter.action.FromCurrent.IsEqual<actionDownload>. And<ISSOPackageDetailExExt.usrIsPODDownloaded.IsEqual<False>. Or<ISSOPackageDetailExExt.usrIsPODDownloaded.IsNull>>. Or

when i put the inventory id in the details tab of the sales order form, i get the following error " inventory of inventory id does not exist in the system". so i am unable to process the new sales order.