Solved

Is there any way to get reports or financial report (ARM) to use it on Mobile App ?

Hi Team, I want to get External Reference field value from Opportunity Rest API but currently it is missing in the response model. Is there a way I can get the value ? Also I have checked the details property in the response model as it is empty 

We wanted to see if there's a way to create a non-stock kit and when this is added to a sales order, we print out a picklist, for the components of this non-stock kit to explode and show the components that makeup that non-stock item. Preferably they would see all the items in the kit listed as individual items on the order. This would be a feature just for us and pickers, it doesn't need to explode the components of it for the customer's copy.

I have created a new “FormTab.master” form that I have two problems with it. The form works fine when I take away the tab from the form but when add it back the problems persist.When I Click Add New Record, not sure the form doesn’t reset the fields. The fields whithout default value, should be empty but are not. Even if the data is saved (I confirmed through both DB and Primary List) after clicking on Save, no matther what action I trigger (Add New, First, Last ...) I get an error that "Any unsaved changes will be discarded."For claification the header PKs are ProjectID and RevisionID and detail PKs are thesame fields plus TranPeriodID. Here is my Graph: public class PMCashflowProjectionEntry : PXGraph<PMCashflowProjectionEntry, PMCashflowProjection> { [PXViewName("Projects Cashflow Projections")] public PXSelect<PMCashflowProjection> CashflowProjections; public PXSelect<PMCashflowProjectionSchedule, Where<PMCashflowProje

Is there a way to increase the qty shipped on a shipment record without first having to edit the original sales order?

We’ve created one user login for clock entry on the mobile app for labor recording by shop floor employees.  We are limiting the user login through role assignment to only display the Clock entry function on the App.  We are interested to know if this login password can be saved to a stationary android device? 

We have an entry that needs to be reversed for a specific branch. Since the initial entry was made, that account was made into a cash account for another branch. Therefore, we can not correct the entry since it will not let us book a cash account for a branch that was not setup for that cash account. Any idea how we resolve this issue? 

I am unable to remove this below generic inquiry. we have created this in earlier version and once we upgraded we are seeing this issue and we don't have any scope to manipulate like export, add, copy and change screen ID.   All we need is to delete this item.  

Hi there,I have a requirement where I would need to grab a value from Stock Item attribute, trim it down to the first letter and assign it to Production Order Type as shown below: However, when I tried to customize the field itself, I was greeted with the following pop up: Is there any other way to edit this field via Customization Project Editor?

 Hi,The aim of this case is to identify how to form REST request properly in order to create Bill with status "Balanced"Our client is using our application, which creates requests and put data to Acumatica. Client asked if we can  create invoices with status "Balanced". I checked such request with our Test Acumatica environment and it was easy to implement. My request successfully worked and created Bill in Acumatica with status "Balanced" However, when we do same request with client's Acumatica we get this error :  "exceptionMessage": "Bill.CashDiscountDate: 'Cash Discount Date' cannot be empty.\nBill.DueDate: 'Due Date' cannot be empty.\nBill.LocationID: 'Location' cannot be empty.\nBill.Terms: 'Terms' cannot be empty.\nBill.Vendor: 'Vendor' cannot be empty.\nBill.VendorRef: 'Vendor Ref.' cannot be empty.\nInserting I searched and found that this error is caused by this fieldWhen I removed it from the request it successfully worked.My question is : what is the possible difference bet

Hi Team, I am trying to create opportunity through rest API and it worked first time. I tried to create another opportunity it gives me below error: Although the model is same which I have passed first time just subject is different. I have observed that If I delete all the opportunities then it works fine but it is not creating 2nd opportunity event for another business account.URL: /entity/Default/18.200.001/Opportunity Model: {    "BusinessAccount": {        "value": "4424"    },    "ClassID": {        "value": "STUDENT"    },    "ConvertedLeadDisplayName": {},    "ConvertedLeadID": {},    "CurrencyID": {        "value": "AUD"    },    "CurrencyViewState": {        "value": false    },    "Details": {},    "Discount": {        "value": 0    },    "Location": {        "value": "MAIN"    },    "ManualAmount": {        "value": false    },    "OpportunityID": {        "value": "E1223"    },    //"Override": {    //    "value": true    //},    "Owner": {},    "OwnerEmployeeName": {},   

I am attempting to create a flow of basic steps for enabling the MRP feature. Please let me know if I am missing anything in particular, or confirm that the basic steps are included below. Thank you! MRP Configuration Prerequisites Numbering Sequences: CS201010 Production Order Types: AM201100 Work Calendar:  CS209000 Replenishment Classes: IN208800 Warehouses: IN204000 Review Manufacturing and Location Table tabs Stock Items:  IN202500: Review Replenishment Info  Configuration Steps: Creating an MPS Type: AM203000 General MRP Settings: AM100000 MRP Buckets: AM201200 Step required to view data: Regenerate MRP

The Active Users list in the System Monitor shows individual users multiple times. Is this something we need to be concerned about and is it consuming resources? (In our prior ERP seeing the same user multiple times meant they hadn’t logged out properly or a session hung.) It’s especially strange that the “admin” user appears multiple times with high “Time from Last Activity” values as no-one uses that login.Do we need to take action on this or is it normal? Thanks! 

Hi Team,I have enabled manual number for Sales Order Number but When I am creating sales order from opportunity it is throwing an error as Manual numbering is activated. I think I have to add Order number field in the dialog box. How can I add Order Number field in the Create Sales Order dialog box ?   

Hello Community,I’m newbie to the Acumatica Mobile application development.  Please bare with me, If I’m wrong.I have a specific below requirement in Scan and Issue screen. Please find the details below.I have created a new site map, which is exactly duplicate screen of Scan and Issue screen. In this newly created screen, I don’t want to scan the location and directly scan the BarCode of an Item and it should defaulted to “Default Issue” field from the Stock Items screen.As soon as scan the Barcode of item, it should take location from Stock Item screen and then should be Released automatically.Can you please help me on the 2nd and 3rd point. Thanks in advance!

I am working on upgrading our Acumatica instance from 2019R1 to 2021R1.  A substantial part of my project involves updating a set of service layer applications that enable bidirectional communication between our ecommerce site and Acumatica.  Our web site runs on a platform that does not have an available integration for Acumatica.  The site interacts with Authorize.net for all credit card transactions.  I’ll spare everyone the long explanation for why I need to unmask the Payment Profile ID (CCPID) in the API.  The TLDR; is “our web site’s integration with Authorize.net could be better”.  Most of what I need to accomplish involves not creating duplicate payment methods in Acumatica because of web orders.With our customized v18 API endpoint in 2019 R1 my code could load a customer’s payment method list to access the temporary ID for that payment method.  A second request was sent to load a single payment method using the temporary ID with the payment method details expanded.  That woul

This is a follow up to this one:  How do I make my default value for my second UOM selector appear in the selector on page load?Here’s my DAC declaration. I also used the strategy in the referenced link to set the values for the selector dropdown on load.I added this to try to get the default value to display...but it didn’t work:         [PXUIField(DisplayName = "jUOM", Visibility = PXUIVisibility.SelectorVisible)]I also tried a few other things that didn’t work. Any thoughts on how to get a Default value to appear in the Selector at load?This part of the below referenced DAC should load the default, I think, but it doesn’t work…        [PXDefault(typeof(Search<InventoryItem.salesUnit, Where<InventoryItem.inventoryID, Equal<Current<SOLine.inventoryID>>>>), PersistingCheck = PXPersistingCheck.Nothing)]         #region juOM        public abstract class juOM : PX.Data.BQL.BqlString.Field<juOM> { }        protected String _jUOM;        [INUnit(typeof(SOLine.i

I have a need to remove the current quantity from item stock.  The quantity were incorrectly imported.  This tenant has been inactive.  We have sales or purchase transactions.  What is the best or easiest why to zero out the quantities.  I was thinking of doing an inventory adjustment or use the physical count.  There are financial issues since the tenant has not transaction.  The amounts were imported.  I appreciate any assistance or advice on the best way to handle this issue. 

I’m trying to print the contents of a Note for a Service Request in a Notification Template. Anybody know the field reference I should use on that page? I’ve tried the solution suggested in topic “Notification Template - Invoice.Note,” which is to use field ((Document.NoteText)), but that only produces a blank line. Thanks in advance.

Hello, I just added subaccount for some of the inventory IDs. Is there a way to mass update historical invoices (linked to inventory) created and journals posted with the new subaccount?Thank you so much. Regards,Cherlene

I have created a second PXSelector that mimicks the behavior of the out-of-the-box UOM field in the Sales Order entry screen. I have detailed the process of creating this below; I have basically copied all the elements I can find from the existing UOM field (and renamed to jUOM as necessary). Everything works, except I get an error when saving the Sales Order document that says “Invalid column name ‘jUOM’.I am stuck trying to figure out how to create an extended field on the SOLine cache that can save the value chosen by the user for this second UOM field (called jUOM) to a field in the database.I confess to not really understanding how the out-of-the-box UOM field is being saved to the SOLine database table, which is part of my problem. I have played around with using PXDBString etc, but that breaks the UOM selector (can’t be used with the:  [INUnit(typeof(SOLine.inventoryID), DisplayName = "jUOM")] DAC field declaration).Can someone help me makes sense of what’s going on with these U

On premise instances, Secure a Tenant can be done with Acumatica ERP Configuration Wizard.How can this be done with SaaS tenants/instance?

I’m attempting to configure Microsoft Azure for Integration with Acumatica ERP instance by following these instructions:https://help-2021r2.acumatica.com/(W(7))/Help?ScreenId=ShowWiki&pageid=6b852c66-01c4-40b5-af7d-c53d7e4bd672 In Step 4, I’m required to specify the application ID URI of our Acumatica instance. Supposedly I’m supposed to find the application ID URI in the Web.Config file. But I can’t find this Web.Config file - where would I find this or is there an alternative way to find the application ID URI? J

Hi  I would like to analyse sales and COGS via subaccounts. I have created subaccount under GL for the inventory ID. I have also indicated the subaccount when invoice is created.  However, when I generate the P&L, only the sales is breaking down in subaccount but not the cost.Is there a way to indicate subaccount in shipment? Or why the ARM is not breaking down the COGS into subaccount?Thank you in advance.  

When navigating to Learn and cover development I was trying to access the Development T190 Training Guide.  I was then forced to login and challenged with a strange ‘Allow Request’ Screen with a title ‘Stop Spam’?  Screen attached as PNG file.