Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

BigCommerce Integration: How to unmap variant price/weight from syncing?

We have template items setup with matrix items that map to the BigCommerce variants. Client does not want price or weight to populate BigCommerce from Acumatica. They want to maintain that in BigCommerce only. I’ve set in both the Stock Item and Template Item entity to unmap these fields yet the variant in BigCommerce is updating the price/weight based on what is on the variant in Acumatica. Is there a better way to accomplish this? This is 22 R1 for reference.

51 minutes ago

simonliang91Acumatica Employee

Retail

How To: Create a custom mapping in Shopify Refund entity

In the current Shopify connector, it doesn’t support the custom mapping in the Entity mapping screen for the Refund entity, but if you want to have some custom mappings in the Refund order, you can do it in the customization project. In this topic, I want to share how to create a custom mapping in Shopify refund entity through the customization package. You can make a mapping to the original field or custom field. I tested it in 2023R2 and it works well. Create a new customization project Create a new code file, and extend the Graph from SPRefundsProcessor. Override the method CreateRefundOrders public class SPRefundsProcessor_Extension : PXGraphExtension<PX.Commerce.Shopify.SPRefundsProcessor> { public static bool IsActive() => CommerceFeaturesHelper.ShopifyConnector; #region Event Handlers public delegate Task CreateRefundOrdersDelegate(SPRefundsBucket bucket, MappedRefunds existing, CancellationToken cancellationToken); [PXOverride] public Task CreateRefundO

55 minutes ago

jpaquetteFreshman I

Configuration and Installation

Updates to Newest Version

What is the process on keeping customer current on the latest release we have 3 customers on 2023 R2 when will the update happen to move to 2024 R1?

1 hour ago

andrew15Varsity I

Payroll

payroll tax on travel

We are testing and hoping to implement the canadian payroll. So far it is working ok, but we have a situation where we will need to start charging payroll taxes on the distances travelled when the next union agreement is implemented. we didn’t have to do this before because the amount charged per km was under the limit specified. The new amount is above that threshold and therefore need to charge the taxes on the amount over the threshold. How do we go about doing this as we can’t add km on the timecard? whatever process it is to do this, we would have to do it to about 20-30 employees a week.

1 hour ago

Doug JohnsonAcumatica VP, Product Management

Payroll

Canadian Payroll

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

111920

1 hour ago

FRANKDSWK91Freshman I

Financials

SO Error: The document is out of the balance for Build 23.113.0042

Hi, I’m wondering why I’m getting an saying SO Error: The document is out of the balance in the Bills and Adjustments screen. I’m not sure on what to do to fix this error.

1 hour ago

MelNadFreshman I

Financials

Change date on contract

HI, All my contracts are created hat when I run the contract invoicing, I get billed at the end of the month. We want to change and charge at the beginning of the month. How do I make this change?Thanks to help me. Melanie

2 hours ago

DrewNisleyJr Varsity I

Field Service

Arrive action on appointments starts log for all techs

We are having an issue where we have multiple technicians on an appointment, let’s say three for example, one departs (only selecting themselves to depart), then he arrives (again only selecting themselves), and the appointment moves to In Process. Once this happens, it starts logging time for all the technicians, even though there was only one selected and they are the only ones who have a travel time log. Obviously the other techs are not there, so they should not have their time being tracked. Here’s an example of what it looks like after arriving the one technicianAny help is appreciated, thanks!

2 hours ago

wmatthews1877Jr Varsity III

Reports and Generic Inquires

Using SWITCH to use another field name if first field is null or empty

We have a Generic Inquiry that has the Customer.ParentAccountID and not all of the parent accounts have that that number all by itself (the account number also, in some cases, has the name of the customer). I was thinking in that case to use a SWITCH similar to the one here:=IIF([Customer.ParentBAccountID] = ' ', [Customer.AcctCD]) but that is not working also. Also I am not sure if the Customer.ParentAccountID is empty or NULL. I know that the Customer.ParentAccountID should be showing up because when I do a CRTL+ALT the Element property shows the field as Customer.AcctCD. I also thought about getting just the number portion of the AcctCD but that seems more work then necessary. I could use any suggestions that the Community may have.There are accounts whereby the Customer.ParentBAccountID is showing up correctly on that column.In this case the Customer.ParentBAccountID = ‘ ‘ or NULL and the customer.AcctCD is 16310 - Grainer.

2 hours ago

ltussing03Captain II

Reports and Generic Inquires

White space left between boxes in report designer

Hello,I’m trying to make a form in report designer that has text in boxes. The problem is that there are tiny gaps and the lines of adjacent boxes don’t touch leaving a gap of white space. This method worked fine in the header section, but in the detail section I cannot get this gap closed.It looks good in report designer showed below.I have tried increasing the size by the smallest amount, but then report designer shows it in error.The form is covered in boxes and this looks sloppy.Any thoughts on how to overcome this? I’ve tried panels with broders and have the same problem.Again, this worked fine in the header section which makes no sense to me.I am just putting borders on these text boxes to create my printed boxes. Thanks!

2 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1731 topics
5742 Replies

Distribution

1678 topics
6476 Replies

Manufacturing

594 topics
2224 Replies

Construction

568 topics
1913 Replies

CRM

154 topics
451 Replies

Field Service

275 topics
916 Replies

Retail

451 topics
1985 Replies

Payroll

213 topics
702 Replies

Low Code | No Code Customizations or Integrations

218 topics
790 Replies

Develop Customizations

2358 topics
9596 Replies

Develop Integrations with Web Services | APIs

560 topics
2295 Replies

ISV Solutions

120 topics
488 Replies

Configuration and Installation

748 topics
2723 Replies

Reports and Generic Inquires

1724 topics
6702 Replies

Import and Export Scenarios

662 topics
2732 Replies

System Health and Performance

131 topics
478 Replies

Community site discussions

225 topics
420 Replies

Community Introductions

95 topics
281 Replies

Everything Else

711 topics
2358 Replies

News & Announcements

Acumatica News & Updates

110 topics
155 Replies

Events & Meet-ups

132 topics
83 Replies

Developer Newsletter

19 topics
0 Replies

43 topics
0 Replies

andrew15Varsity I

Payroll

payroll tax on travel

1 hour ago

FRANKDSWK91Freshman I

Financials

SO Error: The document is out of the balance for Build 23.113.0042

Hi, I’m wondering why I’m getting an saying SO Error: The document is out of the balance in the Bills and Adjustments screen. I’m not sure on what to do to fix this error.

1 hour ago

DrewNisleyJr Varsity I

Field Service

Arrive action on appointments starts log for all techs

2 hours ago

wmatthews1877Jr Varsity III

Reports and Generic Inquires

Using SWITCH to use another field name if first field is null or empty

2 hours ago

abinayaa94

Distribution

Customers - Shipping Mail has to be Added in GI

In Customer Screen Will have mail In three tab whereas in General Tab , Billing Tab and Shipping Tab I have already fixed General Tab Mail and Billing Mail Tab as per the below screenshot Need help to fix the Shipping Mail in the Generic Enquiry Added Xml also - could you help me to add the shipping mail in GI

2 hours ago

ernst97Freshman I

Import and Export Scenarios

Add multiple vendors to a stock item and skip when excel is empty

Hello everyone,I have the problem that I want to add several suppliers to a stock item. This works so far, but I need a way to skip empty rows in Excel.For example:I have three possible suppliers in my Excel list.Two are imported.For the third one, it throws an error because there is none, for example. Does anyone have any idea how I can work around this?Kind regards

4 hours ago

AleciaFreshman II

Distribution

Location 'MAIN cannot be found in the system

Good day, We are receiving an error ‘location ‘MAIN’ cannot be found in system’ occasionally. Any guidance on how to resolve the error will be appreciated. Kindly see attached a screenshot of our request and response logs. Kind regards.Alecia

4 hours ago

fmrubi11Freshman II

Reports and Generic Inquires

Journal Listing Generic Enquiry with company and or branch parameter

i want a generic enquiry that lists all journals filtering by Company and or branchChallenge is filter only showing branch level and no company level. Any help

5 hours ago

jpaquetteFreshman I

Configuration and Installation

What are the datasets avalable

Are these the only Training Datasets T100 and U100… Where can i locate the latest copy and/or how do I find out if there is an update to a dataset

5 hours ago

BHEDGEPETHSWK78

Financials

Customize AP dec req templates per vendor

Is a customer able to customize a template in AP doc recognition to make it specific to a particular vendor?

5 hours ago

New to the community?

Get Started HERE and be sure toIntroduce Yourself

Acumatica User Groups

Educational Resources

Community Library

Blogs

What you may have missed in the Acumatica Community! March, 2024

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

AndreasKleinfeld72has earned the badge Manufacturing expert
leppleyhas earned the badge Easy talker

Show all badges

Acumatica Community

New to the community?

User leaderboard

Acumatica employee leaderboard

Badge winners

Events Calendar

Latest Articles

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded