Solved

Our current credit card processor (authorize.net) requires an authorization to be above the dollar amount of the actual capture.  We have to authorize before we ship and are using the Acumatica Fedex and UPS carrier plugin to obtain our Freight Charges. What is the best way to get our Sales Order an estimated dollar amount above the actual order total, but only have the actual freight (from the plugin) on the Invoice.  We currently have found no solution that doesn’t require manually editing the Invoice.  What are other companies workflow like?  What is the Acumatica recommended workflow? Thanks!

Is it at all possible to upload the beginning balances for a GL account with subledgers? Please help! or is there a work around? Thanking you in advance!mrivera67

Hi!I am a new Acumatica user and looking for a help ticket/ chat function in Acumatica that we can use for our internal teams to improve internal communication and get away from Whatsapp groups. Does anyone have any ideas?

Is there a separate customization package for Construction Edition in 2021 R1? or Is it built-in already? Thank You

Does anyone have a recommendation toward when to license Microsoft SQL Server per Cal verse per Core for a PCS Acumatica system.  This customer would only be hosting the Acumatica database so I would think that one Cal per instance of Acumatica would be all that is needed.  This assumes that users connect to the Acumatica web server and the server consumes one Cal as it connects to SQL.  Can someone confirm this theory or make a recommendation.  What other factors should we concider.Thanks 

Hello,I m a new user of Acumatica,  I would ask the other more experimented users, is there some way to retrieve data from the cloud database down to Excel like I was used to do with my MS SQL Server database, via Power Query fonctions (I had of course the Server address, username and password to be authorized to get in) ? thank you very much. Cai

This really shows my noobness.  I have a request to modify a Manufacturing screen.  Is that possible?  If so, will I be able to get access to the Code Repository for that edition so that I can leverage existing code?Also, is there demo data for Manufacturing?Thanks!Joe

Pretty sure this is a bug:In the SM203525 Space Usage / List of Snapshots:Highlighted the first snapshot, which as you can see is Kirk Properties 2021-03-06. Clicked on the name, it brings up the tenant screen, but… …while it shows the correct tenant it shows the wrong snapshot, and one that doesn’t even belong to this tenant!  Dangerous, to say the least!

Curious if anyone has attempted to modify the default Receipt To and Ship From locations from the mobile app.  It does not appear the mobile platform can load these as they are from the Stock Items → Warehouse Defaults area (throws an error that it is unable to load the view “Item Settings”.  I am referring to these fields below:I have tried instead to load them from the “Warehouse Details” tab which will display the data, but it is not modifyable here.  I used a redirect to the item warehouse settings form using container action “Add Warehouse Detail” but this always wants to add a new record, not modify an existing record.  On the form there is also a pencil button which will redirect to the Item Warehouse Settings form and load the existing record.  I can’t seem to invoke this action through the mobile app though.  Anyone else come across this or have some ideas how this could be accomplished?

Hello everybody,My question is:We pay our employees the professional fees reimbursement by bank transfer (SEPA).  And we made it through another software, so we have to book the reimbursement laterly in acumatica, for example on the bank statement, it would appear 3000€ outcoming that we have to affect to 10 employees accounts (512100 Bank account to Sxxxxx employee subledger accounts).  It seems that this schema is not available under acumatica, I don’t find how to dispatch a payment and distribute it to 10 different accounts.  (as prepayment, sometime the fees bill comes later) For the received payments, check remitment for exemple, I can use the check remit account to aggregate 10 checks and got a unique incoming amount for the bank reconciliation, but I don’t know weather there is a way to do the same with the outcoming payments ? Hope you understand my issue. Thank you in advance for your help.

Our approval maps have always been employee supervisors and when we upgraded to the new version somehow its changed.  We are not able to approve time cards because there are lines that are not approved.  The only approver is the supervisor but Acumatica wont let us do that now.  Any suggestions, yes I did put in a case.  No response for 5 days to the case.

I have several detail grids with one master. Each detail has its own tab. The problem is the grids that are in a tab, that is not in view, are not updated when the master record changes.I’ve already done in aspx and code:MasterGrid: <px:PXGrid SyncPosition="true" KeepPosition="true" <AutoCallBack Command="Refresh" Target="tree" ActiveBehavior="True">      <Behavior RepaintControlsIDs="DetailGrid1, DetailGrid2View"               BlockPage="True" CommitChanges="False"></Behavior> </AutoCallBack> (I am unsure about Target in this case)   DetailGrid_n: <px:PXGrid SkinID="DetailsInTab" SyncPosition="True” <CallbackCommands>         <Refresh SelectControlsIDs="MasterGrid" ></Refresh> </CallbackCommands>   Graph: public SelectFrom<DetailDAC_n> .Where<DetailDAC_n.Id.IsEqual<MasterDAC.Id.FromCurrent>>             .View Details_n; BLC: _(Events.RowSelected<MasterDAC> e) {            Details_n.V

Hi Good Day,Installed Build 21.100.0127 today and the first thing I notice is the sales demo installation is missing on the Acumatica Framework Configuration Wizard. Where/How do I install Sales Demo?Thank You 

on my constructor, I put a checker if this feature is available or not, using prefetchable. public ModelTypeMaint(){ Helpers.PreferenceHelper.CheckFeatures();} Now, I have tried to run a unit test on this particular graph, unfortunately even though I’ve implemented a mock setup, It still reads the Prefetchable checker.How do I bypass the prefetchable on the constructor?Unit Test Codeprivate ModelTypeMaint PrepareGraph(){ SetupEnableDisable<ModelTypeMaint>(); var graph = PXGraph.CreateInstance<ModelTypeMaint>(); return graph;}[Fact]public void Test_Description_ValidLength(){ ModelTypeMaint graph = PrepareGraph(); ModelType type = (ModelType)graph.Caches[typeof(ModelType)].Insert(new ModelType { ModelCD = "UT00001", Description = "Model Type: UNIT 00001" }); Assert.InRange(type.Description.Length, 5, 255);} Thank you.

Hello everyone, Can someone show me how to block the Unit price field in Sales Ordes Screen? Thanks in advance!

I’m trying to access attachment contents over OData so I can pull Stock Item images into Excel. I tried PX.SM.UploadFileRevision and PX.SM.UploadFileWithData, but the UploadFileRevision.BlobData column doesn’t appear in either a Generic Inquiry or in the OData feed. Does anyone have any ideas on how I can access the raw file attachment contents? Note in these screenshots that there are 5 columns in the Generic Inquiry, but only 4 columns appear in the results: 

Could anybody help me with customization. I have an application, witch connect to acumatica with acumatica libraries: Auth, Default_18.200.001, RESTClient from here: https://github.com/Acumatica/AcumaticaRESTAPIClientForCSharp I am using it like submodules - if somesings will change on git - I always can update itI needed to add custom fields to the Project form. I did it - added fields, posted changes.After that, I created a new endpoint inheriting it from default endpoint - and the new fields became available to me when working with the Project entity. I achieved this by creating classes that inherit from api and the base model with overriding the GetEntityName() method.If I need to change the fields, I will have to create new inheritance classes.Perhaps there is some standard way to support customization fields? And I just didn't find it.My Api extension:public class ProjectExtApi : EntityAPI<ProjectExt> { public ProjectExtApi(Configuration configuration) : base(conf

Hello everyone!What is the best approach to manage this scenario?In the payments and applications screen I need to put on "pending approval" status when the exchange rate changes in the document.Thanks for your help!

Hello! we have been doing our work to get our badges and have the U100 data set in a testing company to work through the training with. Out of nowhere, today, we are getting an error when trying to bring up the Customers screen. we are opening it in windows explorer, we have not modified that i know of. Our other testing companies with other data work just fine. We are new to the acumatica world and so not up to speed on how to figure these issues out. If you need any further information to help deduce the issue please let me know. any help would be greatly appreciated.  Here is the stack trace message: [PXException: Error: This generic inquiry does not exist anymore.] PX.Data.PXGenericInqGrph.PrepareCaches(String id, String name, Dictionary`2 parameters, Boolean fetchSchema) in C:\Users\svc-builder\AppData\Local\Temp\~PX.Data.0\PX.Data.dll.il:936172 PX.Web.UI.PXGenericDataSource.InstantiateDataGraph(Type type) in C:\Users\svc-builder\AppData\Local\Temp\~PX.Web..1\PX.Web.UI.dll.i

If a customer is not using standard cost, when a component is added to a bill of material, the cost is 0 unless one is manually entered, and after the component item is received into inventory and the cost is established, the cost on the bill of material is not updated. Users will base price estimates on the bill of material and when the costs are not current on the bill, there is no way to look at a bill of material and view the current cost of the item.  They must look at each component item and retrieve the cost, or create a bogus production order to capture current cost.This would increase usability and customer satisfaction.

Hello,I have a DAC MyCustomer that has Customer reference BAccountID. In a graph for another DAC MyPartnership I want to use a Selector to pick a MyCustomer and also shows the AcctCD by using an unbound column. The selector itself works fine, but I get errors for persisting MyPartnership or loading existing ones.The error in Trace is this.Invalid column name '[MyCustomerExt].[acctCD]'  Please note, that MyCustomer is not an Extension and I have no idea why it is looking for MyCustomerExt. Here is my code:    public class MyCustomer : IBqlTable    {        #region BAccountID        [Customer(IsKey = true)]        [PXDefault]        public virtual int? BAccountID { get; set; }        public abstract class bAccountID : PX.Data.BQL.BqlInt.Field<bAccountID> { }        #endregion        #region AcctCD        [PXDBScalar(typeof(Search<BAccount.acctCD, Where<BAccount.bAccountID, Equal<MyCustomer.bAccountID>>>))]        public virtual string AcctCD { get; set; }       

Hello,It’s possible to execute an update sql query by code in Acumatica?I wanna update a field that exist in the database but not in the DAC Thanks . 

I know the purchase order was created in the system because I have a pdf record, but I’m not able to find it in the database. I assume it was accidentally deleted. How can I recover deleted purchase orders?

We’re on 2019R1 and the Production Order Maintenance screen in the Modern UI takes SEVERAL minutes to filter the list if you use the filter field in the upper right corner of the grid. We’re currently in the process of upgrading to 2020R2, and it is STILL not usable.  I figured Acumatica would have cleaned them up to be on par with the rest of their screens given they own it now and have had plenty of time to do so.  Is this something that is a known issue, are plans in place to fix it?  We have zero issues with this functionality throughout the rest of Acumatica.

Good day, I modified a check form (AP641000), and everything looks good, when printing more than 1 check, the View PDF or View HTML shows the correct data on the preview of the PX.ReportViewer.axd. But, when you print the checks using the PRINT button, ** I edit this part, as I get the margins to work, but not the first page *** the starting the second page, the margin for the second and third page will move up, but the first page margins (seems to be the top margin) will not match the other pages, is about a row down, not even that much, but is notisable.  Have any had any experience with this? The customer is printing on an HP printer and I have an HP printer and can replicate the issue, but cant seems to find a solution for it.