Solved

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.

we are have a requirement to read the data from external API and add to grid, this should repeat in every 5 seconds and stop when we clicked stop.Can someone please guide me the correct way to do this.So, we created two buttons START and STOP and also a method to read from API and insert to grid.Issue we are facing is - on start, say we are inserting 2 records, when we clicked on stop button, the records in the grid the getting duplicated, i mean, total 4 records.Please have a look at below code. public PXAction<DAC> startRead;        [PXUIField(DisplayName = "Start Scan", MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Select)]        [PXButton(CommitChanges = true)]        public virtual IEnumerable StartRead(PXAdapter adapter)         {            System.Threading.Thread.Sleep(5000);            //cntLoop is unbound field with propery [PXUnboundDefault(true, PersistingCheck = PXPersistingCheck.Nothing)]            if (this.Document.Current.CntLoop == true)

Hello, @vkumar , @Naveen B  I have an American date format in an excel file that needs to be uploaded into MYOB Adv.  The format is like so ‘20231231’ (i.e. YYYMMDD).  How can I convert this to an AUD format in the Import Scenario?Regards,Laura

Hi everyone,We need to use different languages in Acumatica. The website is working well. I only have problem with mobile app. I checked out the mobile code as below. Does anyone have any ideas to add localization for mobile app?  

I have customer who regularly gets orders from the government with quantities between 50,000 - 150,000.These are usually scheduled over a period of months.They would like to be able to create a manufacturing order for the total monthly quantity and then release smaller (unique) batches to the shop floor and be able to track those batches through clock in/out entries by shop floor personnel.If they created individual manufacturing orders for each of the batches, there would be in excess of 100 manufacturing orders for each monthly delivery and the maintenance would be prohibitive.Thoughts?Thanks for your help!Donna

Hi Everyone, I am learning Acumatica. Please help me on below issue. Whenever ,I open Stock Item Form. I am Getting the below issue.I’m unable to stop the debugging.  

Hi, I’m relatively new to Acumatica but far from new to ERP systems and implementations.I have created an item number. That Item can exist at three warehouses. Those warehouses have replenishment relationships defined with each other. I have set safety stock, order multiples, etc. at each location. I have set an inventory level at the main picking warehouse that is significantly below the safety stock. At this point, I would expect replenishment activity to be suggested to transfer stock from the next warehouse in the chain. This does not happen.I then increased the demand at the picking warehouse by adding a sales order, in case there was some requirement for a SO to trigger the replenishment. This also did not work.Hopefully, I am missing something really straightforward.Warehouses are PICK, BOX and OFF-SITE. What I want is for transfer orders to be suggested to bring stock in from BOX to PICK when there is SO demand or when safety stocks fall below the defined parameters. Likewise,