Solved

New to Acumatica. My question is why is my Depreciation calculation not reducing the asset cost for salvage value before calculating depreciation.  The report reads asset cost = depreciable value on an asset with a declared salvage value.

Hi,I tried to customize the Account Summary screen (GL401000) by adding an extra financial period field to the header without success. I want to add a period to and from field so I can run the Account Summary by a date range versus one period. What is the correct way to add this customized field or it cannot be done without a change to the code? Let me know. I tried to publish multiple customizations but it failed each time. Here is the screen shot. I want to add another Period Field. Let me know.  

Howdy all,I’m looking for support on showing some additional customer aging data on the Invoice Form (AR641000).Ideally I’d show these fields:Customer Current Balance Invoice Amount Customer Current Balance - Invoice Amount as “Revised Balance” I *think* what I want to do is add a subreport to the invoice form (AR641000) that references the Customer Documents Total filed from the AR Balance by Customer Report (ar632500). But I’m not clear how to access that exact field value:But I’m not sure what the best way to proceed is in order to recreate the field “$CustomerBal” and add it to the Invoice as a subreport.Or, should I try and do the linking within the current report so I can have “$CustomerBal” interact with the invoice total field? Would be curious to hear what others would do.Thanks for the ideas! 

Hi,In Unit Test Framework can we fetch values from DB or using PXSelect Query for Table.I am getting null object when i use PXSelect in unit test frameworkThanks.

I facing the issue with the unitcost field where datatype is decimal(25,6) and in the DAC, i have used [PXDBDecimal(typeof(Search<CommonSetup.decPlPrcCst>))]. In Company Screen i have set Price/Cost  = 4 still its defaulting 6 decimal place. please guide if missed any thing to default from the company set up.  

I created an extension to SOCreateShipment, to override the Data View for ‘Orders’. I made this change:  public class SOCreateShipment_Extension : PXGraphExtension<SOCreateShipment>  {    #region Data Views    [PXFilterable]    public PXFilteredProcessing<SOOrder, SOOrderFilter,              Where<True, Equal<True>>,              OrderBy<Asc<SOOrder.requestDate>>> Orders;    #endregion    #region isActive    public static bool IsActive()    {       return true;    }    #endregion  }I wanted only to override the OrderBy for the view, but I was forced to also add a ‘Where’ clause to the PXFilteredProcessing class. Now when I run the program, the OrderBy clause works properly, but the filter for the selected rows is now selecting all rows. The View has a delegate method ‘orders’ that has a more filtered where clause. But, when I debug SOCreateShipment, the ‘orders’ delegate method is never reached. If I remove this extension, the ‘orders’ delegate metho

Going from one appointment to the next, he clicks Depart, and gets the warning  “AcctID cannot be empty”I’ve gone through everything in the appointment, can’t find what’s missing. Please help, thanks.

I am very new to Acumatica, I have inherited a lot of reports in which I want to update the formatting. One thing I’m stuck on is how the coding works on formatting the date. I changed the formula to this (see below). It currently reads as: I want to change the format to include a “/” or a “-” inbetween the month and Year. Another thing I want to do is to just have the last 2 digits of the year if possible so it can look like this “08-22” or at least be able to read as “08-2022”. Any help is greatly appreciated.  

Hello everyone, I'm working with a company that has 2 "companies" and several branches. One of the companies year end is October, the other is December. Is it possible, with core financials in Acumatica, to set these companies in the same tenant? I am thinking this might be an issue or I might be missing something.  Thanks

why this payload is giving me an Error:422 "error": "Inserting 'Address' record raised at least one error. Please review the errors.; CountryID: 'Country' cannot be empty.",{"Status": {"value": "Active"},"EmployeeID": {"value": "CRIC123789"},"EmployeeName": {"value": "Doe, Jane"},"FinancialSettings":{"APAccount": {"value": "ACCOUNT123"},"APSubaccount": {"value": "000000"},"ExpenseAccount": {"value": "ACCOUNT456"},"PaymentMethod": {"value": "CHECK"},"PrepaymentSubaccount": {"value": "000000"},"SalesAccount": {"value": "ACCOUNT789"},"TaxZone": {}},"EmployeeSettings":{"BranchID": {"value": "CRIC012345"},"Calendar": {"value": "NEWCAL1234"},"CurrencyID": {"value": "USD"},"CurrencyRateTypeID": {"value": "SPOT"},"DepartmentID": {"value": "1"},"EmployeeClass": {"value": "EMPCLASSNE"}},"ContactInfo":{"LastName": {"value": "Doe"}},"Address":{"CountryID":{"value":"India"}}}

My client recently began using AP Approvals. Specifically, they added an AP Approval Map to the AP Preferences form under the Approval tab and activated it.  Since doing so, when an AP Bill is entered and saved and taken off hold, it moves to a Balanced status as normal.  However, we’ve noticed that they are no longer able to add new lines to the Bill, change dates or vendor locations, etc….all things that can normally be done for a Balanced AP Bill.If we deactivate the approval map on AP Preferences, we can go back to the same Bill whose fields were greyed out and no lines could be added or changed or deleted, put it on hold, then take it back off hold, and now all those fields are available for editing again and new lines can be added, etc.If we reactivate the approval map and do the same thing - put the Bill on hold and then take it off hold again - we are back to the fields being greyed out and no lines changes are allowed.If it matters, this Bill is not subject to the approval map

I want to be able to put a GI up on a big screen in the office and not have the menu and headers showing. for example, if i wanted to hide all that i have scribbled on red below, and just keep the main table, is there a way?  

Hello. Im trying to run SalesOrderCreateShipment method right after the sales order is created.Im sending this (json encoded) array http://joxi.ru/LmGpkVnuwQvRR2 to /entity/Default/20.200.001/SalesOrder/SalesOrderCreateShipmentaddress (just like here) https://help.acumatica.com/(W(8))/Help?ScreenId=ShowWiki&pageid=9a0b1037-c931-4eff-a974-15403d3227a7but getting the following error"Error in action invocation: Value cannot be null. Parameter name: key"here is stack trace https://justpaste.it/52nn1wats im doing wrong? thanks!

Hi all - I’ve run into a situation I am hoping someone can provide insight / a solution for. We had a production order (RO A) for quantity 4. Welding completed OP ID 10 for quantity 10 (they built 6 over). Assembly processed RO OP ID 20 and 30 for quantity 4 and then RO A was closed. The cost of the 6 extra welded parts were rolled into that of the 4 completed parts. Is there a way to reopen a production order to complete OP ID 20 and 30 for the remaining 6?Any advice is appreciated - thanks! 

Hello All, I am in the process of integrating smartsheets and I’m running into user authorization issue. When I try to load smartsheet templates, I receive a message stating “you are not authorized to perform this task”. I am an admin-level user. Does anyone know what user role(s) need to be modified? Thanks in advance. 

Hello!Is there any possible way to restrict some of the document types for users? For example, we need to restrict the ‘Credit Memo’ document type for one user.Thank You,Regards Amanda 

Hi everyone,is there anyone who can tell me where can I find the B2B Portal documentation?

Hello,I work for an Acumatica VAR and currently studying for Shopify installation. However, when trying to implement the connector it is asking for a public address and I’ve only got a local install, any workaround for that ? Thanks

 Hello:In many screens we can upload files but the size is 1 GB and now I know for Acumatica that can be increased to 2 GB, with this articule:Next But we need in the screen of opportunities for line upload 2 GB, ¿is it possible with the articule top?Thank you     

How would I go about fixing this?  

Hi everyone. Quick one please. Can Power BI reports be done across multiple tenants 

Hello,I’m trying to resolve the following issue: custom column added to the grid contains no data.Here are the details.I am trying to customize the Run Service Contract Billing (FS501300) form to add Organization ID column into its Contracts grid.To do that I extended the ContractPeriodToPost DAC for the grid based on the following article: https://blog.zaletskyy.com/post/2020/03/09/post100 .My extension is as following.using PX.Data;using PX.Data.BQL;using PX.Objects.GL;namespace PX.Objects.FS{    public class ContractPeriodToPostExt : PXCacheExtension<ContractPeriodToPost>    {        public static bool IsActive() => true;        #region UsrCompanyID        [PXInt]        [PXUIField(DisplayName = "Organization ID")]        [PXDBScalar(typeof(Search<Branch.organizationID, Where<Branch.branchID, Equal<ContractPeriodToPost.branchID>>>))]        public virtual int? UsrCompanyID { get; set; }        public abstract class usrCompanyID : BqlInt.Field<usrCompany

I'm building an integration that needs to extract data from an Acumatica record and build a json string. My process for doing this is using an export scenario to define what data gets pulled from the record. Is there any way that I can leverage the logic in SYMappingUtils/SYImportProcessor to pull data? Ideally I want to pass the record and the mapping to a method, and it returns the mapped data/formula evaluations from that record. Below is how I've been able to get a portion of the data, but it doesn't work for most PXSelector fields. It pulls the integer key value and doesn't return the CD value like the export scenario does. Base.Views[objectName].Cache.GetValue(Base.Views[objectName].Cache.Current, fieldName);

In SO Process Orders, I am trying to change the sort sequence for SO’s displayed. The default is by Order number, but I want it sorted by RequestDate instead, when the list is initially displayed. I created a SOCreateShipment extension, and extended the BuildCommandCreateShipment() method:  public class SOCreateShipment_Extension : PXGraphExtension<SOCreateShipment>  {    #region Event Handlers    public delegate PXSelectBase<SOOrder> BuildCommandCreateShipmentDelegate(SOOrderFilter filter);    [PXOverride]    public PXSelectBase<SOOrder> BuildCommandCreateShipment(SOOrderFilter filter, BuildCommandCreateShipmentDelegate baseMethod)    {      PXTrace.WriteInformation("BuildCommandCreateShipment() started from extension");      // Add Order By Request Date to default view      PXSelectBase<SOOrder> extFilter = baseMethod(filter);      extFilter.OrderByNew<OrderBy<Asc<SOOrder.requestDate>>>();      string errmsg = "extFilter value is: " + extFilt

I have created an extension of SOCreateShipment, where I redefined the ‘Orders’ Data View. I now want to debug the flow for loading rows into the grid of orders. I am able to define breakpoints in the Extension, and Visual Studio breaks at the requested statements. While debugging, I also opened the base source code for SOCreateShipment, at:C:\Acumatica\MyWebApplication\App_Data\CodeRepository\PX.Objects\SO\SOCreateShipment.csand added needed breakpoints. When I open the website, attach to process, then run the application, it breaks at the statements defined in the Extension, but not the statements in the base code. I reviewed the steps in the Customization Guide, and Acumatica website, but I don’t see clear steps on how to debug the base code. Can you point me to the proper steps?