Discussion Forums

Does anyone know of a way to handle the new CO Retail Delivery Fee ($.27 beginning July 1, 2022) either with Avatax or without? Avalara had sent out communications regarding this which stated to perform the following: Merchants subject to this fee will need to add a $0 line item to their orders with the OF400000 tax code. I’m unsure as to how this would be done in Acumatica. Perhaps someone from Acumatica may know if there will be something released in a new build perhaps? 

Are you using Project Budget Forecasting (PM209600) or Cost Projections (PM305000)? If yes, are you getting the desired results? Do you wish you could do more?  If no, why not? Do you need additional functionality for your specific workflows? Could you use a short training session to get you started? 

I was testing the Login endpoint in ScriptBasic with cURL and I’m seeing duplicate Set-Cookie: headers returned. Can someone in the development group check to see if they are sending dups? C:\Acumatica>sbc login.sbHTTP/1.1 204 No ContentCache-Control: privateSet-Cookie: ASP.NET_SessionId=fzij23u0gpn1ytgyppfvk5re; path=/; HttpOnly; SameSite=LaxSet-Cookie: UserBranch=16; path=/Set-Cookie: Locale=Culture=en-US&TimeZone=GMTM0800A; expires=Fri, 01-Aug-2025 03:44:56 GMT; path=/Set-Cookie: CompanyID=Demo; expires=Fri, 01-Aug-2025 03:44:56 GMT; path=/Set-Cookie: .ASPXAUTH=3E6A8CF7C56FAF5905F956EE5ABB7B17872218E74715D89CB07F22DB2F7FFC7D3DE46736133B9E1A9BFC40CD97D90287B59FCA47ABBEBA08EA1AEABE8B087BB07B41920C18FA22437784124D3FEF3092B636BFB4343575ED04610B1553C710A56C20661E011FCF4F9B31F3D0ECC9D4AFE14B125D1CDFF22CD34BEB30E019593E81EC0885; path=/; HttpOnlySet-Cookie: ASP.NET_SessionId=fzij23u0gpn1ytgyppfvk5re; path=/; HttpOnly; SameSite=LaxSet-Cookie: UserBranch=16; path=/Set-Cookie: Locale=Cu

For tax year 2021, the IRS made minor changes to the 1099-MISC and 1099-NEC forms. Details of the changes can be found on the IRS website. Acumatica will implement these changes in upcoming versions of the software to assist with customer 1099 filings. There are 3 changes that impact Acumatica.Form 1099-NEC sizing. Acumatica will reduce the height of the form to match IRS changes. Form 1099-MISC, box 11. New use for box 11 includes any reporting under section 6050R, regarding cash payments for the purchase of fish for resale purposes, from a individual or corporation who is engaged in catching fish. Form 1099-NEC, box 2. Payers may use either box 2 on Form 1099-NEC or box 7 on Form 1099-MISC to report any sales totaling $5,000 or more of consumer products for resale, on buy-sell, deposit-commission, or any other basis.1099 Paper Forms:Changes to the 1099 Paper forms are currently available in the following builds of Acumatica:2021 R2 Update 3 Hotfix 1 (21.203.0030) and later 2021 R1 Up

I’ve been hearing that Acumatica cares more and more lately about ERP Transactions (vs. Commercial Transactions) so it’s super important that companies keep an eye on how many ERP Transactions they have each month and that they aren’t going over the number of ERP Transactions that they are licensed for or they will start having to pay more for Acumatica. I’m ok with ERP Transactions, they make sense to me, but I noticed a scenario where what I consider to be 1 transaction actually counts as 2 ERP Transactions. Can someone from Acumatica (maybe @Aliya) explain why this is happening? You can see the scenario shown in my demo environment (no customizations) in this 4 minute video segment: 

I am trying to uncheck boxes on Item Warehouse Details that had previously been set to allow for Reorder Point input - now client wants override removed  But 0  I cannot get import scenario to remove the check - import runs with no error - but does not remove check 

Has anyone else had problems with modern UI for Acumatica screens that are customized?  We have discovered that when you create extension modern UI files for a screen like the Vendor screen, they won’t work because Acumatica forgot to include export statements on the TS file for the screen so that they can be referenced by ISVs TS file to include custom fields onto the modern UI.Also, the extension modern UI files don’t seem to be able to loaded into a customization project...just the files that are for non-Acumatica screens.  So, at this point, we apparently have to manually copy our files into the extensions folder for each screen and then edit the Acumatica screen TS file manually for every customized Acumatica screen for each of our customers? WTH?

Hello Everyone,We are facing an issue while conguring Outlook email account but getting error “The mail receive has failed. NO LOGIN failed.”.We have given valid credentials and other parameters but still getting this issue. Can anyone help me on this? Please find the screenshots for reference. 

When running the inventory planning module, I create the transfer order from the inventory planning screen. No matter what status I have that order in, Open, On Hold, Back Order, the inventory planning does not count it as supply. I know this because when I regen the inventory planning the demand comes back like it is not fulfilled. Why is this a problem?Sometime, the transfer order cannot be fulfilled right away. Then the regen happens and another transfer order gets created and now we have too much supply coming to fulfill that order once we do get stock. Has anyone else seen this as a problem for them? How do you handle it?

Hey all,I’m working on modifying the Production Order Performance report. I had some issues with it repeating lines yesterday, but ended up fixing them. After making further changes (necessary ones) it has started looping again. I can’t repeat the same solution, as the solution would simultaneously undo the changes as they conflict. It has to do with the relationships of tables. A screenshot is included below. I need to have the AMProdEvnt and AMMTran tables involved. They are necessary for the changes I am making. I don’t know how to properly configure them as to not cause looping. Any help is greatly appreciated. 

Hi all! I’m new to Acumatica; we just converted on 12/1 from Quickbooks.  How can I show an invoice marked as paid for my customers?  They ask for a paid invoice all the time for their records.  We sell high end products that many people need this for insurance purposes. Sometimes a customer will make a partial payment.  Example, a customer has an invoice for $100,000 worth of goods for which he paid $80,000.  I need the invoice to show: Total:  $100,000Amount Paid: $80,000Balance Due: $20,000 Or if it’s paid in full, it would be marked as such and balance due would be zero.  How can I do this?

Working on creating a Custom cc plug-in . However i cannot get the ICCHostedPaymentFormResponseParser to work . Does anyone have any ideas of how i can go about this?

Can a Stock Item be available for sale to only one customer? We have custom products that are made specific for one customer and we don’t want these available to other customers or to be accidently sold to other customers. 

I am trying to create a new project in VS on a 25R2 instance. (first time working in 25R2).I open the project and simply try to compile it.  I have not added anything to the project...just the default that was created.I get this error:Unable to find package Microsoft.Bcl.AsyncInterfaces. No packages exist with this id in source(s): Microsoft Visual Studio Offline Packages, TestSDKI see that there was a similar error a couple of years ago, but it did not address my issue. From the above link, I tried removing Microsoft.Bcl.AsyncInterfaces from my csproj file.  It compiles after doing that.  But then the site will not load.After killing the site, I can get it back up by upgrading the site only using the installation tool.Note that simply attempting to compile my project in VS, it kills the site.Could not load file or assembly 'Microsoft.Extensions.Options.ConfigurationExtensions' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference.

Hi All. I am using Post Man to create new records using PUT REST API in Acumatica. I have created new screen (grid view) and new table attach with Screen. I am trying to add new record but its not creating record but updating the existing one I have tried with if-none-match header but still the problem exist. The table have PK and Unique key. Any idea what’s going on? Thanks 

Hello,         I like Acumatica’s user defined fields feature, I can add fields without writing code.But these fileds are disabled when the shipment is completed, while I’d like to keep it being enabled.    Is there a way to do it?         I’ve found a similar question above, but as I checked, I can not find the “UDF” in automation steps. So I can not enable it.      Is there any other way to do it?

We are in the middle of implementation and I am writing a workflow for issuing Purchase Orders to Outside Process vendors for metal finishing (Ie: Powdercoating, Plating, etc),  however I am not certain that I am totally clear on the correct process. We have setup non-stock items to represent the outside processes.  These have been defined as a service, They have vendor(s) associated with them on the vendors tab and the default price as been set to $1.00.   On the manufactured (stock) item I have defined a BOM and on the operation step for the outside service I have added the Non-Stock item (Powdercoat) to the BOM as a material.  The qty required has been set to the per-piece cost that I was quoted,  the Unit cost remains at $1.00, The material type has been set to “Sub Contract” and the Subcontract Source has been set to “Purchase”.  On the Outside processes tab I have also checked the “Outside Process” box and have selected the preferred vendor for this operation.  I have then opened

It looks like they are set to print with the Acumatica Ref # order.

Acumatica will offer the Controlled Release of Payroll in Canada beginning with the 2023 R1 release coming in April. The initial release of Acumatica Payroll will support:Federal and Provincial Tax Calculations T4 and RL1 tax forms (T4 summary and RL1 available in 2023 R1) PD7A remittance validation report for CRA (2023 R1) Record of Employment Final Paycheck Canadian Specific features Paid Time Off calculations Deduction and Benefits calculations  Payroll related features EFT (via Canada localization) T5018 (improvements in 2023 R1, ability to separate goods/services in 2024 R1) The following features will be supported in a future release:Multiple base currencies. Customers who want to run both US and Canada payroll need to implement 2 separate tenants PTO enhancements T4A (AP report)The table below outlines the stages and timelines of the rollout.Stage Tentative Date(s) Information/Activities Acumatica Demonstrations July 2022 Acumatica supervised demos using a previ

I’m trying to convert the Generic Inquiry - Customer Summary to a MySQL statement. It seems GI only display MS SQL syntax even though I’m using MySQL as the tenant DB. I have everything pretty much working but I’m seeing more customer rows using a MySQL statement than what GI is returning with Preview. Any suggestions would be appreciated. Customer Summary - MySQL ScriptBasicCustomer Summary MySQL ScriptBasic OutputGI - Customer Summary Output - Spreadsheet (PDF)

   -----------------------------------------------------------------------------------------------------------------UPDATE: Now the Matrix Item can be made as Product Kit easily by selecting the Is a Kit checkbox in the Matrix Item form. Please check this article    ----------------------------------------------------------------------------------------------------------------Create Product Kits as Matrix Items by following the below steps. Please pay attention to the screenshots were I have created a Template Item called EnergyDrink with the 3 Product Kits as Pack of 4, 8, 12 and linked them as a Matrix Items to the EnergyDrink Template Item. Steps:Create an Attribute from Attributes(CS205000) form, which would be treated as a Variant option to the Matrix Items.    Create an Item Class from Item Classes(IN201000) form and link the Attribute created in step 1 and make sure the category is set as Variant.    Create individual Stock Items from Stock Items(IN202500) form which are going

Hello there,We can add side panels to Entry screens now, and that’s awesome!  However, I can’t figure out a way to add a side panel, that would be filtered according to the selection on the SO Line.  I have created a couple GIs, added them onto a Dashboard that uses InventoryCD as a parameter.  Now, I would like to be able to add this Dashboard as a side panel to Sales Orders screen, and filter data based on what line item is selected on the sales order.Any ideas?  Thank you!

Could someone please help in providing a solution of moving the UDF from PO into AP Invoice?I am new to developing in acumatica. I have created the user defined fields in POLine and APTran.While reviewing the source of APInvoiceEntry, I looked at overriding the method CopyCustomizationFieldsToAPTran.Code I added is below.public void CopyCustomizationFieldsToAPTran(APTran apTranToFill, IAPTranSource poSourceLine, Boolean areCurrenciesSame, CopyCustomizationFieldsToAPTranDelegate baseMethod)    {        baseMethod(apTranToFill,poSourceLine,areCurrenciesSame);      var portID = poSourceLine.GetExtension<POLineExt>()?.UsrPortID;      var tranline = apTranToFill?.GetExtension<APTranExt>()?.UsrPortID;                     if (tranline != null && portID != null ) tranline.UsrPortID = portID;    }I am getting validation errors when I try to publish.error CS1929: 'IAPTranSource' does not contain a definition for 'GetExtension' and the best extension method overload 'PXCacheEx

Is there any way to customize Acumatica’s pages .cs code inside the customization projects or VS? For starter I would like to get rid eye hurting red color of Approvals screen.

Hi,My application generates REST request which is used for creating BillsThis is my request for creating BillURL : https://mcicj.acumatica.com/entity/ARTSDocAlphaEndpoint/20.200.001/BillBody :{  "VendorRef": {    "value": "1ABL-217i941"  },  "DueDate": {    "value": "3/2/2023"  },  "Vendor": {    "value": "V-06702"  },  "Date": {    "value": "1/31/2023"  },  "Terms": {    "value": "PWP"  },  "PostPeriod": {    "value": "01-2023"  },  "Details": [    {      "Description": {        "value": "Line 001 - Gypcrete"      },      "Qty": {        "value": 1      },      "UnitCost": {        "value": "34573.2"      },      "ExtendedCost": {        "value": "34573.2"      },      "Account": {        "value": "5430"      },      "SubcontractLine": {        "value": "1"      },      "SubcontractNbr": {        "value": "234567"      },      "rowNumber": {        "value": "1"      }This request is fully workable.Bill is successfully created, however these 2 fields are missedI can add them only via “