Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

Lookup data not populate in Reports

Hi Everyone,Good Morning,I have added a multiple filters in Report Designer. But, all are working fine expect Location lookup data not populated. Here is my setup… So please help me out, How to fix this? Thanks,Nageswararao A.

1 minute ago

jamestJr Varsity III

Reports and Generic Inquires

Power BI Connection

Hello all, Quick question. Can Power BI only connect to Generic Inquiries? Or is there a way to connect to the instance directly like you would a SQL Server connection? We’re on a cloud instance. Thanks!

3 minutes ago

harunh69Freshman I

Low Code | No Code Customizations or Integrations

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.

7 hours ago

radhikainugala38

Configuration and Installation

CustomizationPlugin

Hi,I am trying to create a customizationplugin in which I want to setup a Vendor. While adding the inserting the data into the vendor table, i see below issue. VendorMaint vendorMaint = PXGraph.CreateInstance<VendorMaint>(); vendor = vendorMaint.CurrentVendor.Insert(); vendor.AcctCD = "TEST"; vendor.AcctName = "TEST"; vendor.Status = "Active"; VendorClassMaint vendorClassMaint = PXGraph.CreateInstance<VendorClassMaint>(); VendorClass vendorClass = PXSelect<VendorClass, Where<VendorClass.vendorClassID, Equal<Required<VendorClass.vendorClassID>>>>.Select(vendorClassMaint, "GNA"); vendor.VendorClassID = vendorClass.VendorClassID; vendor.TaxAgency = true; vendorMaint.Save.Press(); I see below - message in the exception.Please c

7 hours ago

freddydelrio39Jr Varsity I

Retail

Filter Invoices From Exporting to Shopify

Hello!I’m trying to prevent Invoices from exporting as Shipments to fulfill non-stock items sold on Shopify. My client sells hundreds of non-stock items a day which we need to import into Acumatica for accounting purposes only. After these orders are imported into Acumatica, the SO is completed, and an invoice is created. The Connector tried to sync this Invoice to Shopify to complete the order, but we do not need it to do this. I have not been able to successfully setup a filter to prevent this from happening. This is also creating a huge clutter of failed sync records and “processed” shipment/Invoices in the clients sync history screen. Any ideas on how I can stop this from happening? Thanks!

7 hours ago

kkeating24Freshman I

Retail

Error While Copying Content to a Stream

Hey folks, doing some testing in Sandbox and encountered this error when using the Commerce Connector to prepare data (Refund Entity): Anyone encounter this before? It didn’t seem to prevent items from being prepared, although I”m not sure it capture all of them. I was having intermittent internet connectivity issues as well, I’m wondering if that’s what caused this error….Cheers,k2

8 hours ago

hayleehicksVarsity I

Retail

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.

9 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1731 topics
5743 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
1987 Replies

Payroll

213 topics
702 Replies

Low Code | No Code Customizations or Integrations

219 topics
791 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

749 topics
2723 Replies

Reports and Generic Inquires

1724 topics
6703 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

jamestJr Varsity III

Reports and Generic Inquires

Power BI Connection

3 minutes ago

harunh69Freshman I

Low Code | No Code Customizations or Integrations

Sales order quantity available will go negative warning

10 minutes ago

rashmikamudalinayake10Jr Varsity III

Low Code | No Code Customizations or Integrations

The header value doesn't automatically update.

2 hours 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.

7 hours ago

wmatthews1877Jr Varsity III

Reports and Generic Inquires

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

7 hours ago

radhikainugala38

Configuration and Installation

CustomizationPlugin

7 hours ago

freddydelrio39Jr Varsity I

Retail

Filter Invoices From Exporting to Shopify

7 hours ago

kkeating24Freshman I

Retail

Error While Copying Content to a Stream

8 hours 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.

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

11 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