Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

Alpha characters entered into an INT field

Is there a way to “filter” out alphanumeric characters from an INT field? Somehow, our Parent.BAccountID field has aat least four customer numbers, such as AAMISC, C000001, INTMISC, and KCTEST which, when I do a GI linking Parent accounts with Child accounts it continually throws an error message:I’ve tried filtering out the “bad” customer numbers in various ways without any success. For example and I am only using two of the four for now:Any help, if it is possible, would be appreciated. I suspect that these were imported into the system because I didn’t think it was possible to do this as a manual entry.

just now

Fiona KalinowskaFreshman I

Distribution

How to create a new task for several employees automatically?

My boss wants that when a new order is created in the system, a new task is automatically created for certain employees. However, I can only select one employee in the Task Templates screen, not several. Does anyone know if it's somehow possible to set this up to create a task for several employees at the same time? It should also be set up that if one of these employees is the one who created the order, the task will not be created for him.

17 minutes ago

pjamesFreshman I

Develop Integrations with Web Services | APIs

jaymarzianJr Varsity III

Import and Export Scenarios

Service Order Import Scenario Generated By a Business Event Issue

Hey Folks,Hoping someone has tried to do this before. I have everything working except that I can’t get the import scenario to work because of “Branch Location”. When you run an Import by Scenario manually, Branch Location gets populated based on the one selected in your profile, but because the import scenario gets run by the triggered business event, it does not pick up any Branch Location. I can’t even tell what Branch the system chooses to post the service order from. So, this is what I need:1, Some way to select a Branch Location from the Import Scenario. Something that can maybe search the field, and return the first value.Here is my import scenario, I tried manually selecting my default BL, but to no avail:

1 hour ago

mralyeaJr Varsity II

Financials

Update inventory valuation report to display Qty Available instead of Qty on Hand

I need to add the Qty available to the Inventory Valuation report, however the entire report seems to be based off Qty on hand in the INTranCost table. We need to know how much of a given product is available and the total cost of everything sitting on the shelf unsold. Has anyone else tried adding this field to the report in report designer?

1 hour ago

josbornFreshman I

Distribution

Vendor Lead Time GI

Hello,I am trying to create a GI that shows Vendor ID, Vendor Name, and Lead Time so I can revise it and upload back to Acumatica using a Data Provider/Import Scenario. I cannot find the field for vendor lead time in the GI builder. Anybody know which table to add?

1 hour ago

jdreselFreshman II

Construction

Project budget line added by accident, how to correct or stop it

Hello,We have had a couple instances where cost budget lines are added to a project by accident. What's the best way to fix it, and is there a way to stop it from happening?We have two scenarios we happen. We are implementing a new software for time tracking and the wrong cost code came over when we ran payroll, it added a 00-000 default cost code. How can i fix that? I looked at the GL batch and project transaction screen to see if I could reclassify, but there is only a reverse option (which seems a hefty lift option). The other scenario is an AP invoices. Which those are easier to fix with a reclassification.Thoughts? Thanks,Jeremy

1 hour ago

jvarughese23Freshman II

Import and Export Scenarios

Do Anyone has an Import Scenario to Update Bank Account details to Employee Master File for ACH

Am totally new to Import Scenario , Can anyone help on this

1 hour ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1776 topics
5841 Replies

Distribution

1719 topics
6598 Replies

Manufacturing

603 topics
2272 Replies

Construction

583 topics
1949 Replies

CRM

161 topics
482 Replies

Field Service

284 topics
930 Replies

Retail

454 topics
2007 Replies

Payroll

213 topics
719 Replies

Low Code | No Code Customizations or Integrations

225 topics
814 Replies

Develop Customizations

2398 topics
9686 Replies

Develop Integrations with Web Services | APIs

584 topics
2397 Replies

ISV Solutions

120 topics
494 Replies

Configuration and Installation

762 topics
2784 Replies

Reports and Generic Inquires

1763 topics
6815 Replies

Import and Export Scenarios

683 topics
2792 Replies

System Health and Performance

133 topics
482 Replies

Community site discussions

230 topics
433 Replies

Community Introductions

95 topics
281 Replies

Everything Else

724 topics
2390 Replies

News & Announcements

Acumatica News & Updates

110 topics
164 Replies

Events & Meet-ups

139 topics
85 Replies

Developer Newsletter

19 topics
0 Replies

43 topics
0 Replies

wmatthews1877Jr Varsity III

Reports and Generic Inquires

Alpha characters entered into an INT field

just now

Fiona KalinowskaFreshman I

Distribution

How to create a new task for several employees automatically?

17 minutes ago

pjamesFreshman I

Develop Integrations with Web Services | APIs

authApi.Login() hangs up

31 minutes ago

jaymarzianJr Varsity III

Import and Export Scenarios

Service Order Import Scenario Generated By a Business Event Issue

1 hour ago

mralyeaJr Varsity II

Financials

Update inventory valuation report to display Qty Available instead of Qty on Hand

1 hour ago

jdreselFreshman II

Construction

Project budget line added by accident, how to correct or stop it

1 hour ago

jvarughese23Freshman II

Import and Export Scenarios

Do Anyone has an Import Scenario to Update Bank Account details to Employee Master File for ACH

Am totally new to Import Scenario , Can anyone help on this

1 hour ago

charithalakshan49Varsity I

Develop Customizations

Set selected Production order's Order type in another field

Hi all, I have a selector in SOLine grid as follows.#region UsrProductionNbr [PXDBString(15)] [PXUIField(DisplayName = "Production Nbr")] [PXSelector( typeof(Search<AMProdItem.prodOrdID, Where<AMProdItem.inventoryID, Equal<Current<SOLine.inventoryID>>>>), typeof(AMProdItem.orderType), typeof(AMProdItem.prodOrdID))] public virtual string UsrProductionNbr { get; set; } public abstract class usrProductionNbr : PX.Data.BQL.BqlString.Field<usrProductionNbr> { }#endregion I have another field for production order type in the same grid as follows. #region UsrProdOrdType [PXDBString(5)] [PXUIField(DisplayName = "Prod. Order Type", Enabled = false)] public virtual string UsrProdOrdType { get; set; } public abstract class usrProdOrdType : PX.Data.BQL.BqlString.Field<usrProdOrdType> { } #endregion I want to set the UsrProdOrdType value based on se

2 hours ago

susanw10

Construction

AIA 702 and 703 with Sales Tax

I need to add Sales Tax to the AIA report. Has anyone done this and does anyone have a copy of the AIA.

3 hours ago

krausef77Jr Varsity III

Everything Else

Restrict via User Security to access Reassignment of Approvals

I am struggling to find the correct Setting under User Security to hide the Reassignment function from certain Roles: I cannot find this under the appropriate Document type, Approvals or any Hidden Folder.Any idea where this is living?Approve and Reject are to be found on the AP Document in this case.

3 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

kkeating24has earned the badge Easy talker
GlenMartin34has 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