Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

FIFO Valuation Method - View Cost Layers

Is there any way to view Cost Layers for a given inventory item? We are looking into switching to FIFO from AVG and we need a way to be able to view all cost layers for an inventory item.

3 minutes ago

woodyg84Jr Varsity III

CRM

ejmillarJr Varsity II

Financials

General Ledger Anomaly Detection

Has anyone managed to successfully setup the GL Anomaly Detection within the Sales Demo environment?I’m trying to train a model using the PRODUCTS company but the training keeps failing and the following warning is displayed: ‘The model is not ready for analysis. Not enough data was sent to the model for accurate analysis. You can attempt to train the model after adding transactions.’

4 hours ago

driesdeklerk50Freshman II

Financials

User audit history

Hi All,Where can I pull a report or something to see audit history? I need to see when users were added and removed, those types of activities. The auditors need this info

4 hours ago

harunh69Freshman I

Low Code | No Code Customizations or Integrations

Sales order quantity available will go negative warning

When I try to create a sales order, I would encounter a warning Updating item 'APJAM08 0' in warehouse 'WHOLESALE ' quantity available will go negative. Because of this warning, I’m unable to create a Shipment. Can anyone tell me how I could resolve it.

5 hours ago

raphrfSemi-Pro II

Develop Customizations

Grid - How to prevent adding new row automaticly

Hi group,When cursor reaches the last editable cell, it creates a new rowDo you know if it's possible to prevent adding new row automaticly at the end of a row (when pressing enter) in grids of acumatica? People have "Insert" right(not delete), they can Cancel the row after an unvolontary inserting but it's little bit anoying Thanks =)

5 hours ago

aaldrichFreshman II

Develop Integrations with Web Services | APIs

How to create a sales order via the REST API

Hello, I’m wondering how I can go about importing a sales order into Acumatica by using the REST API. I realized that this is likely through the use of the Actions however I could not find one that would do the action of “New Sales Order” Any ideas on how to do this?

6 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1733 topics
5744 Replies

Distribution

1678 topics
6478 Replies

Manufacturing

594 topics
2224 Replies

Construction

568 topics
1913 Replies

CRM

155 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
793 Replies

Develop Customizations

2361 topics
9596 Replies

Develop Integrations with Web Services | APIs

560 topics
2296 Replies

ISV Solutions

120 topics
488 Replies

Configuration and Installation

749 topics
2723 Replies

Reports and Generic Inquires

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

woodyg84Jr Varsity III

CRM

Incoming junk email could not get deleted

Showing “An invalid character was found in the mail header: ','.

4 minutes ago

saikrishnav35Freshman I

Develop Customizations

How to Programmatically Open/Close Financial Period

2 hours ago

tamiholmes54Freshman I

Reports and Generic Inquires

Email Templates

3 hours ago

ejmillarJr Varsity II

Financials

General Ledger Anomaly Detection

4 hours ago

harunh69Freshman I

Low Code | No Code Customizations or Integrations

Sales order quantity available will go negative warning

5 hours ago

raphrfSemi-Pro II

Develop Customizations

Grid - How to prevent adding new row automaticly

5 hours 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!

7 hours ago

rashmikamudalinayake10Jr Varsity III

Low Code | No Code Customizations or Integrations

The header value doesn't automatically update.

This is an extension of a thread: How can I change header value of a field based on currently selected row in the grid.So far, I have found a working solution. However, there's a minor issue: the UsrWorkCenterID field (show details...) doesn't update automatically. I need to clear the current record to obtain the new value. If anyone knows how to resolve this minor issue, please share the solution. protected void AMProdItem_UsrWorkCenterID_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e) { // Getting the production item data. var prodItemRow = (AMProdItem)e.Row; if (prodItemRow == null) return; // If there's no data, return. // Trying to find the current operation info. var currentOperRow = Base.Caches<AMProdOper>().Current as AMProdOper; // If the current operation matches the item's details, use its Work Center ID. if (currentOperRow != null && currentOperRow.ProdOrdID == prodI

10 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.

15 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.

15 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