Solved

Getting this error when trying to update standard cost on a few inventory items...any ideas? 

Does anyone already have a check format that is Check/Stub/Stub? I would greatly appreciate it! Best regards, Adriel Negrete

How can I delete a Journal Entry that has been posted?

Hi,I have created New Customized tables in ISV Solution.How to Exclude Data of New Customized Tables while Importing/Restoring snapshot through the Package?Thanks,Giri.

Ive developed a custom SQL view and associated DAC which generates a table of available quantities of stock kits.Im trying to show the Qty in the Sales Order by adding PXDBScalar to the SOLine DAC detail screen however I keep getting null?  namespace AutoKitAssembly{  public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>  {        #region UsrKitQtyAvail        [PXDefault(TypeCode.Decimal, "0.0")]        [PXDBScalar(typeof(Search<KitAssy.qtyAvail,            Where<KitAssy.builtItemID, Equal<Current<SOLine.inventoryID>>,                And<KitAssy.siteId, Equal<Current<SOLine.siteID>>>>>))]        [PXUIField(DisplayName = "Kit Qty Available")]        public virtual int? UsrKitQtyAvail{ get; set; }        public abstract class usrKitQtyAvail: PX.Data.BQL.BqlInt.Field<usrKitQtyAvail> { }        #endregion  }}  

Hi, I need to disable all the notes and files in every single form. I could not find this in Access control level and How could I facilitate this? I referred those two links.  https://community.acumatica.com/develop-customizations-288/prevent-updates-of-notes-and-files-if-the-transactions-are-in-released-status-conditionally-13791https://stackoverflow.com/questions/35664927/prevent-update-of-note-files-on-disabled-views Could we make a import scenario and make the updates? or Is this a customization? RegardsNethupul   

I have a custom mater-detail screen and all standard action buttons including Copy & Paste. When I try to copy and paste an existing dataset to a new form, I get an error. I was wondering does Acumatica’s engine itself handles the copy and paste operations or I should write a custom code for it?

Hi expert.I want Show Total Line Show Pages Nbr - Calculate Depreciation FA502000 (same in Sale Orders Screen). Can you help me? Very thank everyone.Reference topic: Same topic

I stock an item, generally sell ten units a month. I have a one-time sale for a customer who buys 100, but I don’t want this sale to impact my moving monthly average.Is there a way to mark the transaction for this purpose?

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.