By using this website, you agree to our Terms of Use (click here)
I was wondering if anyone knew of a way to prevent certain fields from updating with default/stored data when updating the Customer field on the Sales Order page under a certain condition.
My Goal: When on the Sales Order page, if a certain Order Type is selected (in this case, the order type that signifies it is a Sales Order created and sent from our website), changing the Customer Field does not update/overwrite the Financial Settings or the Shipping Settings. This is because the Financial and Shipping settings fields are populated and sent from the website, and may have more specific information than the stored Customer information.
I want to keep the loading of default data for other tabs/fields, but keep the customer-entered billing and shipping info.
Does anyone have any ideas on what I could try in order to achieve this?
I would be looking to have the website update/create the Customer record in Acumatica as part of the order being created. And then ideally, pass the correct Customer ID on the order so you avoid this altogether.
Sorry, I should have given a bit more info. We are currently using a default "Website User" Customer ID that is passed when a new/non-registered user places an order and a Sales Order is created. When a sales order is created this way, we then have to change the user in Acumatica to their stored existing user ID. This is when the undesired Billing/Shipping info auto-change happens.
Once we have manually verified and linked the customer info on the website, the Sales Order is created with the correct User ID and this is no longer a problem. But since the client wants the user to be able to immediately place an order while creating their account, we want the ability to change the Customer ID from the default "Website User" ID to the real Customer ID without the users entered info to be overwritten.
So instead of using a default "website customer" record, update your web code to first match the web customer to the Acumatica customer record, if none found, then create new Acumatica customer (with details from website), then create the Sales Order with Acumatica Customer from previous step.
I honestly feel this should be relatively simple coding on the website backend to do it properly than customise Acumatica to do what you are trying to accomplish.
I'll do my best to address both posts here in this response as best as I can.
The reason that we are doing it this way is because we sell primarily to tax-exempt institutions like schools and certain businesses. If a random customer comes on to our website and makes a purchase, we will have to pay the tax and will not ever do any changes to the Customer ID in Acumatica. They will remain as a default Website Customer ID.
But if an employee of one of those tax exempt institutions (a teacher at a school for instance) uses the website to make a purchase on behalf of the school, they may have their order shipped to their specific school but have a certain branch of their institution listed as billing. We will then need to change the default Website Customer ID to that institutions Customer ID in Acumatica to have the correct tax exemption and accounting applied, but not overwrite that specific information in Acumatica with what is the default stored for that institution. We also don't expect everyone that makes purchases for these institutions to know their accounting details with us. As I mentioned, once we have manually verified that the information a customer provides matches what we have on record, we link their website account to their institutions Acumatica account so that we don't have to do this change for any future purchase they make.
For this reason, we need to allow a purchase from a new account on the website to come in with a default Website Customer ID, but have the ability to change it to an existing Customer ID without the Billing or Shipping info being overwritten by stored defaults if the order type signifies it came from the website.
So does this means that at the website end, you are unable to identify whether the website user is either a "random customer" or an "employee of a tax exempt institution"?
If you are able to identify, then you can still do it at the web end.
ie. Use Default if not employee of tax exempt institution, else lookup customer record and default existing Customer ID
It means that the business owners want to be able to manually verify the information that a website user enters before the Sales Order is created with an existing customer account (unless we have previously verified and linked accounts). Whether to avoid fraud, frustration, or personal preference on their end, this is the way that they want the integration to work.
I can understand thinking that it would/should be simpler for the website to do this automatically, but there are situations like this one where a different functionality is needed or wanted. What I'm hoping to find out is if it is possible to change the Customer ID in Acumatica to an existing customer, but not have the billing and shipping info overwritten if the Order Type is of a certain kind.
A couple of points:
1) Financial settings flow from the customer record and the shipping settings flow from the customer location record selected for the customer. This is default behavior and I am not aware of a way to override it without customization.
2) I understand why you are entering an order before the customer record is created in Acumatica. However, aren't you entering the same financial and shipping settings in the customer record when it is created? If so, how is the update causing an issue?
3) If the sale is to a repeat customer, a customer record should already exist. Are you not first validating the customer before creating the order? In this case, when entering orders for an existing customer, the proper, validated customer ID should be used. This would cause the defaults to be pulled and then overwritten by the subsequent lines of the API call.
I can't see any other way of solving this without customising the code.
I'm fine with customizing the code. Have done it on a few occasions before, was just hoping to get some suggestions.
I agree with others that you probably need to customize the screen. You can try going here for questions about how to customize:
https://stackoverflow.com/questions/tagged/acumatica
Online Members