Solved

Hi Acumatica Community,Seeking your assistance with my concern,Currently the Stock Items Conversion is set up to 6 decimal place. In the Companies Screen, I already change this into 3 decimal place in which I wanted to appear.But it is still the same.. (no effect)Do you have any suggestion for my concern?Thank you!

We are relatively new to Acumatica and we are looking for an easy way for our AR people to see what a customer owes in each of the aging buckets when they call to make a payment. Most of our customers have consolidated accounts - meaning one parent account with a number of children accounts rolling up to the parent. When a customer calls in to make a payment we are not able to easily see what they owe as a function of aging. All we get is a balance amount which includes everything including the invoices that will appear on next months statement. Ideally we would like to be able to go to the customers screen (AR303000) see what they owe in each of the aging buckets then click the Create Payment action which opens the AR302000 screen and have it show the aging amounts for the customer there as well. Right now we have to bounce around between various reports, write down the amount and then go to the payment screen and create the payment. Has anyone heard of or done anything with displayin

Hi,I am constantly getting HTTP 500 error with Invoice endpoint when called using HttpClient C# code with part of stack trace below.In postman I get the same error the first time but I try it again it works. So, the issue is not with the payload and it is not with HttpClient C# code because it works with Customer endpoint.Any suggestions please?Thanks{"message":"An error has occurred.","exceptionMessage":"An error occurred during processing of the field Type value FCH The 'FCH' list value is not allowed for the Type field. The allowed values are: Invoice, Debit Memo, Credit Memo, Credit WO..","exceptionType":"PX.Api.SyImportProcessor+PXFieldErrorException","stackTrace":"   at PX.Api.ContractBased.ExportTableHelperExtensions.RunExportAndAssertSuccess(SyExportContext exportContext)\r\n   at PX.Api.ContractBased.EntityService.GetList(ISystemContract systemContract, String version, String name, EntityImpl entity, CbOperationContext operationContext, Boolean ignoreValueFields, PXGraph graph

How can we facilitate auto-saving the check (AP641000.rpx) as a PDF as soon as the document is processed? Can it be done directly through the Acumatica Report Designer or is a customization approach to be taken?

I have two change orders for a subcontract, one is showing up in details to be able to bill, but one is not, and I don’t know why. It’s listed in the Change Order part of the sub contract But it doesn’t get pushed over to the detail part of the sub contract, so I am unable to bill against it: They are both closed, it has not been added to the main contract, I don’t know how to make it show up in details.

The second week of March we upgraded from 21R1 to 22R1.  Immediately after the upgrade all of our incoming emails related to purchase orders started failing processing with this error: CR Error: Unable to create new case. Business Account is Vendor. Following the hint of the error message, I created customer accounts for a couple vendors.  While this makes the error go away, these messages are now turned into Cases instead of being attached to the related entity. This seems to only be an issue for purchase orders.  Our incoming sales order emails are attaching activities normally.  Originally I thought it was because those emails come from Customers and not Vendors.  However, at the end of this message I’ll go over some of the testing I did before posting here.  The results suggest this is more than just a vendor/customer issue. Prior to the upgrade, we had a total of 20 incoming purchase order email messages fail for some reason or another.  Now, they're all failing until I create a c

I have created a new grid in Cases where when you populate the Relations grid tab with invoice documents it then populates this new grid called CAMRelations with all of the invoices entered in the Relations tab.Right now, I have it working where the CAMRelations grid pulls the invoices one at a time from the Relations tab, but I want it to populate with all of the invoices from the Relations tab, not simply one at a time. If you highlight each item in Relations the CAMRelations pulls the correct invoice information, but again only one at a time and not a list of the invoices from the Relations grid.The screen shots below show what I am seeing.Basically below is the logic I want to use, it simply fails validation.  So I do not know what I should do for this.                    var items = Base.Relations.Select().FirstTableItems.ToList();                                        foreach (CRRelation item in items)                    {   PXSelect<ARInvoice, Where<ARInvoice.noteID, Equa

Does anyone know why this checkbox wont save? I also cant POST the value via the API, yet I can GET it and it reads null. Ive set commit changes = true?.  

 How do you verify whether an automation schedule to prepare and email statements is working?

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?