Learn
Learn
Support
Support
Product
Community
Partners

Community
Discussion ForumsFinancials 1461 Distribution 1420 Manufacturing492 Construction464 CRM98 Field Service220 Retail-Commerce367 Payroll177 Low Code | No Code Customizations or Integrations151 Develop Customizations2094 Develop Integrations with Web Services | APIs457 Other Developer Topics120 ISV Solutions 109 Configuration and Installation 636 Reports and Generic Inquires 1414 Import and Export Scenarios 540 System Health and Performance 115 Community site discussions182 Community Introductions88 Everything Else 622
News & AnnouncementsAcumatica News & Updates97 Events & Meet-ups127 Developer Newsletter 19 Newsletter 37

Create topic
Login

Community
Discussion Forums

Discussion Forums

Get inspired and gain all the knowledge you need

11228 Topics

Recently active

Most replies Most views Newest first

nehar12

asked in Other Developer Topics

How to check whether dateis in present quarter

need help

1 year ago

K2aJr Varsity III

asked in Reports and Generic Inquires

ppowellVarsity III

asked in Develop Customizations

How do I go about overriding the field verifying event for Customer Class ID?

I wanted to set the default button in the Messagebox to be NO but apparently can’t do that. As a workaround I need to override the following:protected virtual void Customer_CustomerClassID_FieldVerifying(PXCache cache, PXFieldVerifyingEventArgs e) { Customer row = (Customer)e.Row; CustomerClass cc = (CustomerClass)PXSelectorAttribute.Select<Customer.customerClassID>(cache, row, e.NewValue); this.doCopyClassSettings = false; if (cc != null) { this.doCopyClassSettings = true; if (cache.GetStatus(row) != PXEntryStatus.Inserted) { if (BAccount.Ask(Messages.Warning, Messages.CustomerClassChangeWarning, MessageButtons.YesNo) == WebDialogResult.No) { this.doCopyClassSettings = false; } } } }I have changed the warning message by adding a translation for the warning message as by default we want YES to only change the class ID and nothing else. How do I go about overriding the code to match? I only want to change the if statement to action on W

1 year ago

cmorelandSemi-Pro II

asked in Develop Customizations

Custom field from Inventory Item to MRP

I have a custom field on the inventory item called usrBuyerPlanner. I want to show that data in my MRP Display (AM400000) I have created a custom filed here Called usrBPCode and modified the attributes like so. [PXDBString][PXUIField(DisplayName="Buyer Planner")][PXFormula(typeof(Selector<AMRPDetailExt.usrBPCode, InventoryItemExt.usrBuyerPlanner>))]However it does not appear to be pulling in the BPcode from the item. Any thoughts?

1 year ago

Jherrick

posted in ISV Solutions

CRM and Clickdimensions

Looking for information on integrating Clickdimensions with Acumatica’s CRM.

1 year ago

john25Freshman I

asked in Distribution

Email SMTP

Our email stopped working and this is the error on the message. Anyone else notice this?Is this Office365 or Acumatica ?535 5.7.139 Authentication unsuccessful, SmtpClientAuthentication is disabled for the Tenant. Visit https://aka.ms/smtp_auth_disabled for more information. [YT1PR01CA0043.CANPRD01.PROD.OUTLOOK.COM]

1 year ago

abdiJr Varsity III

asked in Field Service

Field Customer Details

in the customer detail screen seen from the DAC the data is taken from ARDocumentResult.The question is how to retrieve the value in the currency balance field using the report designer?because when in the report the data issued is the number 0 while on the screen it is not the number 0.example: ics21005506

1 year ago

lauracastagnaVarsity I

asked in Import and Export Scenarios

Import Scenario not working when using "Quick Process" in SO's upload

Hi,I am trying to use the “Quick Process” in an import scenario. The SO already exists in Advanced. The import contains only the Sales Order Nbr. The SO has he “Quick Process” actions to “Ship” and “Invoice”. The Import Scenario comes up with an Error “View: Name Document”.Import Scenario is very basic. It is attached.I would really appreciate any assistance. A Sales Order just needs to exist in MYOB. Add the Sales Order no. i the Import Scenario . And the quick action turned on in the SO Type. Regards,Laura

1 year ago

brucewarrell96Jr Varsity III

asked in Distribution

Automatic Update of Vendor Info on Stock Item Record

When a PO is created, the vendor record is added to the Stock Item automatically. Can this be turned off?

1 year ago

MasterLukeFreshman I

asked in Configuration and Installation

email sender notification template is ignored

hi everybody,i set the “From” adress in our ShipmentConfirmationNotification to “versand@”, but it will always be overwritten by the user profile email settings of the automated sender, in this case “info@”. Does anybody know how to avoid this? Thank you!!Best Regards, Benjamin

1 year ago

nperez94Freshman I

asked in Distribution

Is there an import scenario out there to allocate lot/serialized items at SO line level

I have a WIP import scenario that works if and only if the serial number that is being allocated is Available for Shipping, with is correct, but if one of the serials I am trying to allocate is not available the whole import scenario fails and no serials get allocated at all even the available ones.I get this error “ The record was not processed because of an error during processing of the previous record” Thank you for anything that might help me get to the bottom of this.

1 year ago

IvanVarsity I

asked in Develop Integrations with Web Services | APIs

Password is showing values until they were inputted

Hi,I have custom screen form that was created for inputting credentialsThe problem is that field “Password” depicts hidden symbols before something was written. On that screen I just switched to this tab, all fields are empty, but Password is showing that something was inputted. I attached my solution to Acumatica and verified that Password field is empty, so there is some problem with view.I attach customization project settings and codeAcumatica 2021R2Maybe you can suggest how to null its value, while tab is loading for deleting all from view or maybe another approach to make it look correctThanks in advance

1 year ago

patrickcolgan94Freshman I

asked in Configuration and Installation

Is there a method to merge two tenants into one?

Is there an Acumatica method to merge two tenants into one which are currently in the same database?Client has multiple companies and multiple branches in two separate tenants, is it possible to merge the two tenants into one, if they share the same Chart of Accounts and same periods? If not, Is there a script that can be run to bring the master records together with just the settings without transactions?

1 year ago

FrankXiFreshman I

asked in Develop Customizations

How to modify the value of custom fields when the Sales Order status is closed or shipping?

Hi Experts,I have some custom fields in Sales Order screen as below. I know we can’t update this Sales Order when the sales order status is shipping or closed. But I want to set a new value to these fields. I know I can update the confirmed shipment by the action “Correct Shipment”. Does Sales Order screen have any way to modify the fields when the status is shipping or closed?

1 year ago

carloscarasFreshman I

asked in Develop Customizations

Import XML file. DTD prohibited

When I tried to import an XML file with the Generic Inquiry page, I get the following error:

1 year ago

chidao

asked in Develop Customizations

Customization Project - Automatically Unpublished without reasons

Hi All,Please advise if you have some ideas for my issueMy customize project is usually unpublished and I don't know why, for sure that no one has touched on this.Thanks for your advise,Yên Chi

1 year ago

mattsylvia22Freshman I

asked in Financials

Fixed Assets - Remove transaction from Convert Purchases to Assets

If an AP invoice is accidentally booked to the Fixed Asset clearing account, and then either reclassed to an expense instead of the FA clearing account or reversed with an adjustment, the original AP invoice still shows in convert purchases to assets.Is the best way to remove the transaction to mark it as reconciled and process? It seems to remove the transaction from the list, but I’m not sure if there are any other issues that may cause I’m not seeing yet. Or is there another way to remove that transaction from the list so users don’t accidentally convert it to a FA?

1 year ago

patrickcolgan94Freshman I

asked in Financials

Best Practice to Convert Multiple Purchases over to Single Fixed Asset.

What is the best method to Convert Multiple Purchases over to Single Fixed Asset.A customer buys multiple laptops (Qty 8, similar Class, similar useful life) each at $1,000 on different dates or the same date. What is the best method to convert to an Asset.Fixed Asset thresh hold to capitalize is $5,000.Do you setup an Asset with zero value and convert the 8 purchases as components to one Fixed Asset? Or would you setup an Asset with summary amount of $8,000 and then convert purchases as components to this Asset #? Or do you setup a Parent Asset then add each converted purchase line amount to an Asset associated with the Parent Asset?

1 year ago

katiedavisonFreshman I

asked in Construction

Reversing Pay Application and AIA Report is Now Off

Hi there! I reversed a pay application because it got rejected. I applied a credit memo to the original invoice. NOW - the pay application is showing like I still billed it and that it was never reversed. This is throwing my payment application totally out of whack. Does anyone know what I can do to rectify?

1 year ago

rjean09Semi-Pro I

asked in Develop Customizations

Portal My Cart - add attachments

I have a request to add file attachments to the My Cart details grid and have those carry over to sales order lines. Is there a trick to this? If I try to add NoteID it changes to UsrNoteID and I also don’t think this field works on a DAC extension with PXNote attribute.

1 year ago

esimonFreshman I

asked in Construction

Change Request Log

Has anyone found or created a change log, similar to what you would print out for discussion at weekly OAC meetings? I am trying to avoid using Excel spreadsheets, but unless I can find something in Acumatica I might be back to that.

1 year ago

bmortensonFreshman I

asked in Distribution

How to Process Requisition Requests with Non-existing items

We are new to acumatica and trying to use the Purchase Request / Requisition process. In our legacy system the users will make purchase request for known and unknown items. In acumatica we are able to make the requests for unknown items however, when our purchasing personal try to create the requisition from the request we get errors as the ItemID does not exist. Is there a workflow where you can take the request item information and create a new item from it? Or does anyone have any ideas on how you could allow requestors to make a request for non-existing items or vendors?

1 year ago

K2aJr Varsity III

asked in Import and Export Scenarios

Correct Customer Class Via Import Scenario

Version: 2021R1Hello, as many of us experience, the commerce connector will only allow 1 customer class on import. This functionality is limiting. So I wanted to use other fields in the customer record to update the customer class (dynamically). So the intention would be: commerce connector imports customer from Shopify with Customer Class “K2TEST”. I build a GI that looks for all records with customer class “K2TEST” I create a data provider based on the Generic Inquiry noted above. I create an import scenario that uses the data provider noted above and has logic to look at an ATTRIBUTE on the customer record and map a new customer class “K2NEWCLASS” accordingly. I then schedule the import scenario to run from a Business Event or Schedule...making it AUTOMATED.This scenario works with EXCEL as the data provider, but obviously that takes manual intervention to process. But switching to the GI gives me the following error: 1 items have not been processed successfully. View name: BAcc

1 year ago

Page 305 / 450

Badge winners

freboredohas earned the badge Easy talker
khalmehcgchas earned the badge Easy talker
jvarughese23has earned the badge Easy talker
KELhas earned the badge Easy talker
marina25has earned the badge Financials expert

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

About Acumatica ERP system

Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.

Privacy Policy
Terms of Use
GDPR
SLA
Support
Report an Outage