Solved

I would like to reconcile my bank account daily? What are the downsides? 

Hi there, We number our inventory items using the format00-000In our previous system, any new inventory item that is added (stock or non-stock) is assigned the next number in sequence,so after 10-999, the next number in the sequence would be 11-000 Is it difficult to configure Acumatica to automatically assign the next number in sequence (regardless of whether we are adding a stock or a non-stock item)?e.g. if we added a stock item, the system would generate 10-999if we then added a non-stock item, the system would generate 11-000 (the next number in sequence)…We have already imported our stock using this format, but when we add a new inventory item, we have to manually sort stock items in number sequence, then manually sort non-stock items in number sequence, find out what the latest number was, and then manually type in the next number in sequence.  This isn’t ideal… :)Any tips would be greatly appreciated. 

Newbie here…. When managing tenants, the training material says to make sure all users are logged out.  However, does this apply to situations like creating a new Tenant and using existing backups,  I would not be managing any tenants where users are logged in.  I would be creating a new one and using an existing backup.   Hope this makes sense. Shawn

HI All,All transactions linked with the project seem to show on Project Transaction PM3040PL but don’t know why recording Prepayment on AP Check & Payment does not.For the business case, we record deposits from customers for the specific project. We use Prepayment on AP Check & Payment for that purpose. Even though we have linked this transaction with the project, this transaction doesn't show on Project Transaction.So when we want to check all transactions related to 1 project to calculate how much the customer own us on the specific project, it will go wrong.Is it somethings wrong on my setting or the transaction Prepayment on AP Check & Payment dont link to Project Transaction as default?

Im trying to loop through each line of my grid from a checkbox (Auto Assemble Kits) in the main document header to enable/disable all rows of my grid with custom int field usrAutoBuildReq (also check if line IsAKit). Again spent half a day on this and strange behaviours at best?...    protected void SOOrder_RowUpdated(PXCache cache, PXRowUpdatedEventArgs e) { var row = (SOOrder)e.Row; if (row != null) { foreach (SOLine line in Base.Transactions.Select()) { SOLineExt soLineExt = line.GetExtension<SOLineExt>(); //if IsKit then Enable custom field usrAutoBuildReq } } } 

I have read through several posts here but am still have a problem trying to put the sum of a column from multiple rows of a grid into a header column. I have seen code snippets, however, I think I am not arranging my code correctly.I am still very new to Acumatica coding.    Below the error message is the full CS code I am using.  Everything validates and compiles, but when I try to access the Cases screen I receive this error message.  So I obviously do not know where and what I need to do here.Can someone point me in the correct direction?What I am trying to do is on the Cases screen, use the Relations tab to associate Invoices to a Case and then in a new grid populate that grid with all of the invoice information from the Relations tab. (the other problem I have is that the new grid called “CAM Relations” only lists one invoice at a time, but that is a different problem not for this topic; unless dear reader you know what I am doing wrong there also).Then I have a UDF in the header

Why is the QT not picking VAT and SO is coming with VAT.Kindly advice,

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.