Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

How to resolve field disable issue when Joining DAC's in a view

I created a custom screen of type FormTab. I added the following view to the form (summary) area. However, some fields appear as disabled(uneditable) when the screen is displayed. Specially all fields in the second DAC. When I add these DACs alone as the view, fields appear correctly with editability. This issue occurs only when the DACs are joined. public SelectFrom<AMMTran> .InnerJoin<AMProdItem>. On<AMProdItem.orderType.IsEqual<AMMTran.orderType>. And<AMProdItem.prodOrdID.IsEqual<AMMTran.prodOrdID>>> .View HeaderView;I tried resolving this issue using an a RowSelected event handler as follows, but it didn’t work. I also set Enabled = true for the fields using the Customization Project Editor, but the problem persists. Any detailed instructions, tips, or code snippets would be greatly appreciated. Thank you! protected virtual void _(Events.RowSelected<AMProdItem> e) { if (e.Row

385

1 hour ago

Chris HackettAcumatica Community Manager

Community site discussions

Heidi Dempsey - Acumatica Community Featured Member for November 2024

Meet Heidi Dempsey our Acumatica Community Featured Member for November 2024. It’s great to have you as part of the Acumatica Community @Heidi Dempsey!Hello everyone. I am Heidi Dempsey, Subject Matter Expert for Construction and Projects. I have been with Acumatica for over 6 years since the beginning of the Construction module. I was raised in California and started my career in accounting after college. In the 90’s I had 4 kids within 5 years and stayed at home with them for many years. When I returned to the workforce over 20 years ago, I was able to combine my accounting and computer skills to enter the accounting software industry. It has been a joy to work with partners and customers on the functionality and seeing the software improve over the years. I live in the great Pacific Northwest and enjoy biking, kayaking and hiking. Some other passions are my family, travelling, baking, gardening and recently I have taken up playing piano.

12311

2 hours ago

NaveedFreshman I

Financials

Assistance Required for Acumatica Batch Number Sequence Issue

Hello,We are experiencing an issue in Acumatica (Batch Number Sequence), and I’ve attached a screenshot for reference. Can you please help us address this?

11221

4 hours ago

ainscorpwill

Import and Export Scenarios

Import Scenario - Check if Contact Exist and if Not Create New Contact

Hi,I am working on an import scenario which takes an exported Shopify order Excel file and bulk create Sales Orders with all line items.In the screenshot below, I have a step which uses the ‘Email’ from the Excel file and input it into the ‘Related Contact’ field. If the contact with that email already exist in the system, then it will populated the contact in the field within Sales Order. However, if the contact does not exist, then it gives me error for the lines that cannot find an associated contact.Question: Is it possible within the Import Scenario, if the Contact does not exist, it then creates one for me with all the required details (Name, address, email, business account...etc)? Many thanks!Will

4 hours ago

kdavis45Semi-Pro I

Import and Export Scenarios

File Synchronization from the Export Scenario's Data Provider

One of our clients is in the process of automating their ACH batches to auto-sync to the bank’s SFTP site.I have the file sync settings saved in the data provider, but it isn’t being added as new ACH batches are generated. Is there an automated way to do this without customization and/or a business event/import scenario?I’ve attached both the export scenario and data provider for reference. Thank you in advance!

1474

4 hours ago

Chris HackettAcumatica Community Manager

Community site discussions

Acumatica Community Webinar - Managing Construction Budgets with Acumatica - From Setup to Execution - Wed, November 20, 2024 - Recording

Managing construction budgets doesn’t have to be complicated! Join us for this webinar to learn how to set up, monitor, and adjust your budgets to keep financial control in check. We’ll cover configuring budgets, tracking actual costs, making revisions, and setting up Acumatica’s budget alerts to help you catch overspending before it happens.Introduction to Project Budgeting Setting Up Revenue and Cost Budget Budget Tracking as the Project Progresses Revising the Budget Monitoring Budget Controls Reviewing Project Balances and Performance Metrics Summary/Q&APresented by Iqra Harrison | Senior Business ConsultantPROTELO, INC

4 hours ago

rhemerikFreshman I

Reports and Generic Inquires

Creating GI that lists Sales Orders from 13 months ago

Hi all, I’m trying to write a GI that lists Sales Orders from 13 months ago. For example, if I run the GI successfully with a business date of today, it will show me all Sales Orders in September 2023. I think this is best achieved by setting some conditions in the Conditions tab of the GI, but I am not sure of the formula to use. Does anyone have any suggestions or can point me in the right direction?

Cash Account Reconciliation Issue

Hi,We have a cash account that needs to be reconciled. It has been sitting on hold since 1/31. When clicking on it in Reconciliation Statements it times out and won’t load the transactions. I checked theCAReconEntry.CATranExt table and there are over 7400 unreconciled transactions. Is there a max number it can reconcile?Also, there is a clearing account tied to the cash account. Could this be causing an issue? The clearing account does not have reconciliation required checked but the cash account does. Only one of the two charges methods in the clearing account are listed in the cash account also. Could this be causing the issue?Last question, the periods are closed since the last reconciliation date was 1/31. Do we need to reopen the periods in AR to get these reconciled? Could this be the issue? Thanks so much! Your wisdom is appreciated!

602

5 hours ago

jwengerdFreshman I

Construction

AP Check Orientation Randomly Changing

Has anyone come across the situation where the orientation of AP check’s printing randomly changes. i.e. I print a check with the top of the check facing forward and it prints fine and then I print another check and all of a sudden it prints upside down.

6 hours ago

susane18Freshman II

Payroll

Weekly timecards but Semi monthly payroll

How do you get the timecards to work when they cross payperiods. The pay periods are always 1st through the 15th and the 16th throught the end of the month. What do you do when the time cards cross pay periods? Manual OT calcs would be preferrable and having timecards that match the payperiod. Has anyone gotten this to work?

6 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

2127 topics
7127 Replies

Distribution

2090 topics
7804 Replies

Manufacturing

756 topics
2845 Replies

Construction

712 topics
2523 Replies

CRM

226 topics
677 Replies

Field Service

344 topics
1143 Replies

Retail

515 topics
2343 Replies

Payroll

245 topics
859 Replies

Professional Services

3 topics
1 Reply

Low Code | No Code Customizations or Integrations

330 topics
1226 Replies

Develop Customizations

2853 topics
11653 Replies

Develop Integrations with Web Services | APIs

716 topics
2869 Replies

ISV Solutions

132 topics
542 Replies

Configuration and Installation

913 topics
3349 Replies

Reports and Generic Inquires

2119 topics
8276 Replies

Import and Export Scenarios

808 topics
3331 Replies

System Health and Performance

148 topics
564 Replies

Community site discussions

273 topics
540 Replies

Community Introductions

95 topics
293 Replies

Everything Else

844 topics
2820 Replies

Technology Partners and Customers

Forum for Acumatica technology partners and customers to collaborate on their unique products

MYOB User Discussions

19 topics
41 Replies

JAMIS Prime User Discussions

3 topics
1 Reply

News & Announcements

Get the latest on our community & company!

Acumatica News & Updates

125 topics
177 Replies

Events & Meet-ups

151 topics
98 Replies

Developer Newsletter

19 topics
0 Replies

50 topics
0 Replies

RKarunarathne51Freshman I

Develop Customizations

How to resolve field disable issue when Joining DAC's in a view

385

1 hour ago

NaveedFreshman I

Financials

Assistance Required for Acumatica Batch Number Sequence Issue

Hello,We are experiencing an issue in Acumatica (Batch Number Sequence), and I’ve attached a screenshot for reference. Can you please help us address this?

11221

4 hours ago

ainscorpwill

Import and Export Scenarios

Import Scenario - Check if Contact Exist and if Not Create New Contact

4 hours ago

jwengerdFreshman I

Construction

AP Check Orientation Randomly Changing

6 hours ago

susane18Freshman II

Payroll

Weekly timecards but Semi monthly payroll

6 hours ago

leahcarpenitoFreshman II

Construction

Archiving Projects

Does anyone know of any existing functionality around archiving projects that are no longer active? I’d like to be able to archive/inactivate them to the point that they do not show up on search lists when using the search bar.

243

6 hours ago

lunarchickadeeFreshman I

Reports and Generic Inquires

How can I use Data from a custom GI field as part of a condition?

Goal of the GI:Compare the Current Price Class with the New Price class, and filter out any entries that are already the same to reduce the amount of entries sent through an Import ScenarioCode for the New Price Class assigns a type of discount based on the amount sold:=switch(Max([Location.CPriceClassID])='STAFF','STAFF',Sum([SOOrder.CuryOrderTotal])>1200, 'RETAILBULK',Sum([SOOrder.CuryOrderTotal])<1200, 'CUSTOMERS')But as y’all know, when you make a new field, you can pull up it’s internal ‘field’ name, and I can use that for style like this: =iif(SOOrder_Formulad9d511aff428430595f645b5e7225bcf = [Location.CPriceClassID],'','red20') But I can’t use it for comparison in any part of conditions or even within the results grid=[SOOrder_Formulad9d511aff428430595f645b5e7225bcf] doesn’t work@SOOrder_Formulad9d511aff428430595f645b5e7225bcf of course doesn’t workjust SOOrder_Formulad9d511aff428430595f645b5e7225bcf doesn’t workIs this a hard limitation on GI’s, or is there a trick I don’

454

7 hours ago

rmillerKimballVarsity I

Reports and Generic Inquires

Report Viewer Find only returning first instance

My controller relies heavily on the Find function (search) in the report viewer. The find function used to find the first instance on the first click (or enter key) of the find button on a report, then would find the second on a secondo click/return & so on through the list. This functionality is now lost, it will only find the first instance every time you use the find, its almost as if the report is re-loading every time you click Find. I have tested this in new instances of the same build and have the same results.Has anyone else noticed this, and is there a fix for it?Acumatica 2023 R2 Build 23.212.0024

7 hours ago

skalb11Jr Varsity II

Distribution

SOOrderEntry Release From Risk Hold

I am sure this is a basic question, but I need to add some steps when releasing from Risk Hold.I copied my Release From Hold commands and changed it to ReleaseFromRiskHold. Visual Studio Acuminator message: The signature of a method with the PXOverride attribute must match the override method.I went into the Customization Project Code to have the system create the extension code for me. I did not find ReleaseFromRiskHold as an option. Code:public delegate IEnumerable ReleaseFromRiskHoldDelegate(PXAdapter adapter);[PXOverride()]public IEnumerable ReleaseFromRiskHold(PXAdapter adapter, ReleaseFromRiskHoldDelegate BaseMethod){ // my code here return BaseMethod.Invoke(adapter);}Thank-you.

151

8 hours ago

quantumlingualFreshman II

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! October, 2024

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

saifalisabrihas earned the badge Easy talker
sbhattaraihas earned the badge Easy talker

Show all badges

Acumatica Community

New to the community?

User leaderboard

Acumatica employee leaderboard

Badge winners

Events Calendar

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded