Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

How do I locate the SQL behind the Pivot Table?

Is there any way to get the SQL running behind the Pivot table? Also, if I have a SQL Script, how can I get the PIVOT to be created from that SQL?

26 minutes ago

aaghaeiCaptain II

ISV Solutions

Is there any integration between Acumatica & HeavyJob and/or HeavyBid?

Hello All, Is there any integration between Acumatica & HeavyJob and/or HeavyBid? Or has anyone done something about it?I had a look at HCSS website and apparently they integrate with all ERPs but Acumatica.

39 minutes ago

sd79Freshman II

Distribution

How to resolve : "An error occurred during processing of the field Location value MAIN Error: Location 'MAIN ' cannot be found in the system.

We are getting this error while creating shipment from SO

41 minutes ago

dougmcbride79Varsity III

Distribution

How to ship a multiple box SKU in Acumatica shipping

We have individual SKUs that ship in more than one box. In the Acumatica pick, pack, and ship process, the Acumatica workflow seems only to accommodate one box / one shipping label per SKU. How can we print multiple shipping labels for a multiple-box SKU? We do not have Acumatica WMS. Your help is greatly appreciated.

42 minutes ago

travislawson

Import and Export Scenarios

Create Transfer Receipt - IMPT error

I’m using a business event based on a GI to trigger an import scenario. The import scenario gives an error of “Handler of type IMPT is not exists” I’m trying to have a PO transfer receipt created, add the transfer, select the shipment number that matches the GI. Where am I going wrong here?

1 hour ago

sweta68Semi-Pro III

Develop Customizations

Customer Pricing Add-on

Hi Experts,We are currently exploring the development of an add-on for customer-specific pricing in Acumatica. While Acumatica offers robust pricing capabilities, it does not provide native functionality for pricing based on specific customers. After reviewing other ERP software, such as Sage 300, we noticed that they have dedicated screens for managing contract pricing specific to individual customers.Considering this, we believe it would be a valuable idea to develop an add-on that extends Acumatica's pricing capabilities to include customer-specific pricing.Your insights and suggestions are highly appreciated. Regards,Sweta

2 hours ago

priekenberg40Jr Varsity III

ReportDesigner API Documentation

Hi,i wonder if there is a documentation for the API the ReportDesigner uses to query, download and upload reports to an instance?We would like to create a tool to sync a local directory of reports with an instance. Instead of doing them one by one with ReportDesigner.RegardsPascal

2 hours ago

rcreasyVarsity I

Configuration and Installation

Limit Access rights on specific branches

I need to allow limited access to a branch outside a user’s home branch.One specific example - Our production managers need to see inventory levels at branches other than their own. This ability lets them find stock items they need to order from a sister branch. I don’t want to give the production manger the same rights they have on their own branch.Is there a way to do this?Also, this is just an example. There are other similar situations.

2 hours ago

aiwanJr Varsity III

Low Code | No Code Customizations or Integrations

CROpportunityProducts: Custom field lengths changing between DAC & DAC Declaration

Hi Guys,I have encountered an issue where in the customisation project editor, I am writing an extension for CROpportunityProducts and below is the declaration: #region UsrCloser [PXDBString(2)] [PXStringList(new string[] {"T4", "T2", "NA"}, new string[] {"TS4000", "TS2000", "N/A"})] [PXUIField(DisplayName="Closer")] public virtual string UsrCloser { get; set; } public abstract class usrCloser : PX.Data.BQL.BqlString.Field<usrCloser> { } #endregion #region UsrDoorHanding [PXDBString(3)] [PXStringList(new string[] {"LHH", "RHH", "LHA", "RHA", "BHA"}, new string[] {"Left Hand Hung", "Right Hand Hung", "Left Hand Active", " Right Hand Active", "Both Hands Active"})] [PXUIField(DisplayName="Door Handing")] public virtual string UsrDoorHanding { get; set; } public abstract class usrDoorHanding : PX.Data.BQL.BqlString.Field<usrDoorHanding> { } #endregion #region UsrVPSpec [PXDBString(512)] [PXUIField(DisplayName="VP Specification (D

4 hours ago

matthewgerdanJr Varsity III

Develop Customizations

Processing screen to perform 1 action on a set of records instead of 1 action per record.

Hi Everyone, I wouldn’t mind some direction before I get stuck into this. In short I want a processing screen that performs a single action over all the selected records instead of one action per record.A bit of background first, our company doesn’t quite a manufacture our products, but we do build them using the kitting feature. (Packaging and labeling and basic assembly done in house etc) I have developed a customisation that takes a forecast of what we are expecting to sell (sale units) and it then calculates how much of the purchase components that we will need, compares this to our current inventory levels and then looks at things like the vendor lead time, safety stock etc and generates recommendations for what we should by and when. A small example of this looks like below (The actual run of this would have a lot more lines with larger spread vendors)We intend to run this with a fresh forecast every week, so while the plan may generate multiple purchase recommendations within th

11 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1724 topics
5731 Replies

Distribution

1666 topics
6453 Replies

Manufacturing

591 topics
2221 Replies

Construction

566 topics
1912 Replies

CRM

153 topics
448 Replies

Field Service

272 topics
911 Replies

Retail

450 topics
1973 Replies

Payroll

211 topics
695 Replies

Low Code | No Code Customizations or Integrations

218 topics
784 Replies

Develop Customizations

2358 topics
9584 Replies

Develop Integrations with Web Services | APIs

558 topics
2287 Replies

ISV Solutions

120 topics
487 Replies

Configuration and Installation

744 topics
2705 Replies

Reports and Generic Inquires

1714 topics
6675 Replies

Import and Export Scenarios

660 topics
2719 Replies

System Health and Performance

131 topics
478 Replies

Community site discussions

225 topics
420 Replies

Community Introductions

95 topics
281 Replies

Everything Else

709 topics
2355 Replies

News & Announcements

Acumatica News & Updates

110 topics
154 Replies

Events & Meet-ups

132 topics
83 Replies

Developer Newsletter

19 topics
0 Replies

43 topics
0 Replies

abhijit

Reports and Generic Inquires

How do I locate the SQL behind the Pivot Table?

Is there any way to get the SQL running behind the Pivot table? Also, if I have a SQL Script, how can I get the PIVOT to be created from that SQL?

26 minutes ago

sd79Freshman II

Distribution

How to resolve : "An error occurred during processing of the field Location value MAIN Error: Location 'MAIN ' cannot be found in the system.

We are getting this error while creating shipment from SO

41 minutes ago

travislawson

Import and Export Scenarios

Create Transfer Receipt - IMPT error

1 hour ago

rcreasyVarsity I

Configuration and Installation

Limit Access rights on specific branches

2 hours ago

aiwanJr Varsity III

Low Code | No Code Customizations or Integrations

CROpportunityProducts: Custom field lengths changing between DAC & DAC Declaration

4 hours ago

bmccauley13

Distribution

Ship warranty replacement before receiving return

When a customer makes a warranty claim, we replace the item for free. We want to ship the replacement out immediately and don’t want to wait to receive the defective product. I am using the RR (return with replacement) order type but am unable to Create Shipment without first running the Create Receipt process and confirming that the return shipment has been received. Am I not able to use the Return with Replacement order type to ship out a replacement product before receiving the defective product? If not, what is the best process for handling this scenario? Process:Create new RR order In the details section, use the Add Invoice button to select the invoice containing the item that needs replaced Click the Create Shipment button to send out the replacement itemThis results in the error “Order RR does not contain any items planned for shipment”.

15 hours ago

epanJr Varsity II

Everything Else

open period report for companies in the same tenant

Hi There,We have many companies in the same tenant with different financial year ends. Just wondering if there’s a report to view the current opening period/close period for all the companies. Just wanted to double check if all the periods are closed across all the companies at month end. Thank you.

17 hours ago

tahayabaliFreshman I

Develop Integrations with Web Services | APIs

Connection of Zapier or MS PowerAutomate with Acumatica

Hi all, I am planning and checking to find if there is a way to connect Acumatica with Zapier or MS Power automate to perform some tasks for eg if new customer added in acumatica so it should raise notification on teams to me and my Manager. Note: This is just an example but I am planning to connect it for others tasks as well. Any guide will be appreciated. Thanks

17 hours ago

sean21Jr Varsity III

Import and Export Scenarios

Error: Items have not been processed success. View Name: Schedule.

I am trying to create an import scenario that deletes all Transaction line items in the Deferral Schedule. I keep getting the following error. I tested several different ways and I don’t know why this error is coming up. My ultimate goal is to delete all transaction table line items in the deferral schedule, then add 1 new line item, but I just want to test deleting first. Can anyone spot something obvious that I am missing? Note: The deferral schedule is Open and the transactions are editable.

17 hours ago

lawsontJr Varsity II

Retail

The record cannot be synced because it does not exist in the external system

I’ve had this issue for exactly a month now. Items randomly fall into this error status of “The record cannot be synced because it does not exist in the external system”. All of these also have the characteristic of being a Status = Deleted. The item itself isn’t deleted but the Sync History record is. See this video which shows that when I try to update the status and sync the item, it automatically falls back into the status of Deleted: We’ve been manually updating our inventory in Shopify, among other manual updates due to bugs. It’s very labor intensive and we’re going into our busy season. We migrated to Acumatica due to the integration with Shopify, but it’s not working out so great. Please help!

17 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

raphrfhas earned the badge Construction expert
philr75has 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