Discussion Forums

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 

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?

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.

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. 

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?

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?

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. 

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

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. 

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?

When will the Multiple Base Currency feature support all modules?I was quite excited to see multiple base currency support in 2021 R2, as this solves the single biggest pain point we have with Acumatica.Currently, we have a Canadian sister company that does a lot of interco transactions with the US company, and because of that company’s base currency being in CAD, we have to use a separate tenant.This creates a lot of manual re-entry of documents PO / SO / shipping docs etc and tends to be an error prone process, especially due to exchange rates etc.Now in reading through the details on this feature, I see to my dismay that there is a whole list of other  modules that are not supported by this feature. Meaning you can’t use multiple base currencies feature and these other modules. The modules that we use are in yellow:  Is there any road map on when these modules will be supported by this feature? 

   -----------------------------------------------------------------------------------------------------------------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

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 

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)

Advanced Kitting Boost your sales with bundles!Acumatica’s Advanced Sales Order Kitting capability is designed to streamline and optimize your sales bundles. This feature improves visibility into non-stock kit components and inventory availability, and significantly boosts profitability by enabling better control over pricing and margins. It streamlines the order entry process, allowing customer service representatives to customize sales orders and packing lists, which leads to increased operational efficiency and a superior customer experience.  Additional highlights of this solution can be found below.Be a part of our Acumatica Labs Program to implement this innovative solution and help shape the future of sales order kitting! If you’re interested in participating, please complete this short qualification questionnaire.  This will allow us to consider you for the program. We will review your submission and get back to you within 5 business days to confirm your qualification. Improve 

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

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?

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 “

Please check this link to know about deprecation of Authorize.net in Acumatica ERP.  Authorize.net Support and Deprecation in Commerce moduleAuthorize.net will be supported in Commerce module until there is a fully working solution for Acumatica Payments with BigCommerce and Shopify. This means customers can import the credit card payments from Shopify and BigCommerce into Acumatica as credit card payments without any issues.Customers canImport Authorized transactions from BC/Shopify to Acumatica. Capture in Acumatica/BC/Shopify Void in Acumatica/BC/Shopify Refund in Acumatica/BC/ShopifyWe are in the final stages of approval of Acumatica Payment with BigCommerce and Shopify. As soon as a we have a working solution, then we will announce when Authorize.net will be deprecated in Commerce module. Please let us know in comments if you have any questions.Update on June 30th 2025We have decided to continue supporting Authorize.net in both the ERP and eCommerce systems for our Retail Commerc

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.

An Acumatica client  recently saw a webinar (Jan-Feb 2021) with new features that are to be added to the Acumatica Customer Portal to allow a customer to view an invoice and process a payment for an invoice.  Can you verify that feature – taking a payment on the portal, what release and what is the cost? I just reviewed the 2021 R1 release notes and saw no reference to this.  Do you know if this is planned?  And…. If you can direct me to any documentation or a webinar that would be great.

Hi,What are the steps to configure or use the GS1 barcode in Acumatica? Any example? Thanks,EV

Hi Guys,I need help to sync Line Item properties to Acumatica. Shopify apparently stores the variant options in and array format. Default connector only syncs the 1st option from line item properties but it could have up to 10+ options in that field.Is there a way we can create a loop to loop through the array and show all the options in Acumatica? Thanks for your help.