Learn
Learn
Support
Support
Product
Community
Partners

Community
Discussion ForumsFinancials 1094 Distribution 1151 Manufacturing375 Construction358 CRM33 Field Service154 Retail-Commerce290 Payroll137 Low Code | No Code Customizations or Integrations73 Develop Customizations1589 Develop Integrations with Web Services | APIs338 Other Developer Topics63 ISV Solutions 96 Configuration and Installation 491 Reports and Generic Inquires 1038 Import and Export Scenarios 412 System Health and Performance 86 Community site discussions139 Community Introductions63 Everything Else 521
News & AnnouncementsAcumatica News & Updates86 Developer Newsletter 19 Newsletter 26

Create topic
Login

Community
Discussion Forums

Discussion Forums

Get inspired and gain all the knowledge you need

8501 Topics

Recently active

Most replies Most views Newest first

lauraj46Captain II

asked in System Health and Performance

When are the settings on screen SM201060 applied to truncate older audit logs based on the specified number of months?

We recently modified the ‘Keep Audit History for:’ setting from the default of 999 months to 2 months. Does anyone know if there is a schedule as to when the truncation occurs?It has been 24 hours be we have not seen any change in the table size on the Space Usage screen. I did run the ‘Calculate Used Space’ function on SM203525.Audit settings on SM201060:Thanks!Laura

1 year ago

mhapsJr Varsity III

asked in Develop Integrations with Web Services | APIs

Cascading Delete [PXParent] does not work

I have a DAC MySOInfo defined as Child of SOOrder and another DAC MySODetail as Child of MySOInfo.If a SOOrder is deleted in Screen SO301000, I would expect that the linked MySOInfo entries are deleted and MySODetail entries, too. In fact the first Children MySOInfo are deleted but the Children’s Children MySODetail are not deleted.The DAC’s are defined like this: [Serializable] [PXCacheName("MySOInfo")] public class MySOInfo : IBqlTable { #region RecordID [PXDBIdentity(IsKey = true)] public virtual int? RecordId { get; set; } public abstract class recordId : PX.Data.BQL.BqlInt.Field<recordId> { } #endregion #region OrderNbr [PXParent(typeof(SelectFrom<SOOrder>.Where<SOOrder.orderNbr.IsEqual<orderNbr> .And<SOOrder.orderType.IsEqual<orderType>>>))] [PXDBString(15, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Order Nbr")

1 year ago

AmrutaFreshman I

asked in Reports and Generic Inquires

Custom fields in push notifications and Generic Inquiry

Hi All,We have configured several custom fields in Customization project for our Business Account in Acumatica. We have also used Push Notification using a Generic Inquiry to send us notifications when any field is updated in Business Account. The Generic Inquiry has the custom fields added as well. So when we get a push notification about changes to Business Account, we see the custom fields in the Inserted and Deleted blocks. We have been using this setup for over a month.Everything was working as expected until we stopped seeing the custom fields from Business Account in Push notifications. We checked the following things to make sure our setup was right: Customizations are published Generic inquiry had custom fields in result grid View Inquiry of the Generic inquiry had customer fields Push notification was subscribed to the correct Generic InquiryAfter 2 days, the custom fields started appearing in Push notifications again without us having to do anything. Has anyone else exper

1 year ago

mohamed1walhaJr Varsity II

asked in Develop Customizations

Create XSD Files

Hello,Is it possible in Acumatica to have a button that allows me to invoke a function that retrieves all the data from a screen and formats it as an XSD file? This button will be generalized on all screens containing the "Editions" action.The XSD files will be saved in a new destination.Best regards.

1 year ago

arturoromo51Jr Varsity II

asked in Develop Customizations

Error en Selector cambia Descripción por Valor en la Tabla

Good morning, we are developing a capture in "Form View", I include the image,In the "Marca" column we must select an element by name and take its key to place it in the corresponding table.It presents us with 2 problems, the first is that it does not convert long names to its key, it gives us an error that the field is longer than what is defined in the table and it assigns a different key to it; the second problem is that the fields that have an "&" in the name, it removes the ampersan and puts the text in place of the key.I am attaching the DAC code. #region Marca public abstract class marca : PX.Data.IBqlField { } [PXDBString(20, IsUnicode = true, IsKey = true)] [PXDefault()] [PXSelector(typeof(Search<CSAttributeDetail.valueID, Where<CSAttributeDetail.attributeID, Equal<attributeLaboratorio>, And<CSAttributeDetail.disabled, NotEqual<True>>>>), typeof(CSAttributeDetail.val

1 year ago

sarahFreshman I

asked in Develop Customizations

Rearrange Action Menu

Does anyone know if there is an option to rearrange the order of the items in an Action Menu?On the Process Shipments screen in Receivables, we want to rearrange the order of the items in the Action Menu to match our process order.

1 year ago

jchavezFreshman II

asked in Develop Customizations

Custom Logo on collapsed menu

Hi,We are currently able to change the default Acumatica logo by setting it in the Branches screen on the Visual Appearance tab, but when the left side menu is collapsed, the small Acumatica “a” logo is displayed.Is it possible to set another custom image as the logo when this menu is collapsed?Thanks in advance

1 year ago

larrylySemi-Pro II

asked in Distribution

How to change location on SPLIT line in a shipment

Hello everyone,I have a big order that need to pick item from different location. In shipment it shows a total quantity with SPLIT location line. In pick list it shows every locations that worker need to pick item. The problem is for some reason the location B300-09B is empty. Worker picked item from another location. How do I change the location for this case?

1 year ago

ray20Captain II

asked in Reports and Generic Inquires

The sub report parameter works only after the sub report be triggered

Hello， I’ve studied the article, but I do meet a issue. I write a sub report, and want the sub report be displayed only when it is having count(lines)>0 Per my test, only when the subreport be trigger at least once, will the subReport1_Count having value. Like below

1 year ago

mhapsJr Varsity III

asked in Develop Integrations with Web Services | APIs

How to set Discount on Sales Order programmatically

For a newly created Sales Order I want to add positiv or negativ discounds, on document and line level.Discounts by percentage work find. On document level I create a new SOOrderDiscountDetail, set Type = ‘B’, IsManual = true and DiscountPct. On line level I just set SOLine.DiscPct.But I have problems to set discounts by amount. If I set SOOrderDiscountDetail.DiscountAmt or SOLine.DiscAmt, it is set back to 0,0.The lines and discount details are created any persisted like this.SOOrderEntry.Transactions.Insert(new SOLine{...});SOOrderEntry.DiscountDetails.Insert(new SOOrderDiscountDetail{...});SOOrdeEntry.Actions.PressSave(); What is the correct way to set a discount amount on document and line level code?

1 year ago

alicia23Jr Varsity II

asked in Reports and Generic Inquires

Linking ARInvoice table to CRActivity table

I am trying to build a GI with the invoice info and the activities that belong to it. I was trying to link table ARInvoice with CRActivity. Has anyone linked these two table up before or know if i am targeting the wrong activity table ? Thank you .

1 year ago

jramsell21Freshman I

asked in Reports and Generic Inquires

Issue referencing Production Order Attribute in report.

So we are about to try and use an attribute on our Production Orders for the first time. I have associated an attribute with a production order type that we use for all of our production orders. It is a checkbox. I now need to show a textbox on the production order ticket when this checkbox is checked, however, when I go to find the attribute in the schema builder, it’s not there. Normally when the attributes don’t show up, I’d just hit “Refresh All” to reload the fields and it would show up, but that’s not working for this case. We just upgraded to 21.106.0024 from 2019R2 and I have no way of telling if the upgrade is the root of my issue, as we just started using attributes on production orders this week.

1 year ago

arturoromo51Jr Varsity II

asked in Develop Customizations

Cómo ejecutar una instrucción desde una variable

Tengo la necesidad de generar varios campos de filtro en un “Form View” y de estos elegirlos todos o solo aquellos que se requieran, la integración de los queries para filtros no me permiten hacer esto (o tal vez no se como), por lo que se me ocurre integrar en una variable la instrucción del Select para el filtro con base en los campos que requiera (desde uno hasta todos). La variable para el Select la puedo integrar pero requiero que algo la ejecute para que se aplique el filtro con base solo en los campos en los que se seleccionó información, Agradeceré si me pueden ayudar a resolver este problema.

1 year ago

jgrammer42Freshman II

asked in Everything Else

DBowersAcumatica Customer Success

posted in Everything Else

Customer "Ask the Expert" Community Event - June 11

Customers mark your calendar! Join us on June 11 at 1pm EDT/10am PDT, where we will be hosting an interactive “Ask the Expert” Acumatica Community event. This is your opportunity to pose questions to Acumatica Subject Matter Experts. You be able to ask questions, network with other Acumatica customers, gain insights and ideas in areas of interest! This month we are offering 5 sessions:eCommerce Financial (General Ledger) Manufacturing Reporting, Filters and Pivot Tables PayrollAlso, we have enabled the feature that customers have the option to meet randomly with other customers for short, fun video chat sessions, where you have the option of exchanging a virtual ‘card’ to keep in touch.Please register here for the event.We encourage and welcome questions prior to the event. You can post them here or send them to csteam@acumatica.com.

1 year ago

andrewm80Freshman II

asked in Everything Else

Generating Shipments from an SO via REST API

Hi i have been having a strange issue when creating a shipment of a sales order via the API This is the standard endpoint i am using: (replaced my base address)https://baseaddress/entity/Default/18.200.001/ShipmentAnd the request:{ "Type":{"value":"Shipment"}, "CustomerID":{"value":"TEST1"}, "LocationID":{"value":"MAIN"}, "WarehouseID":{"value":"WAREHOUSE1"}, "Details":[ { "OrderType":{"value":"SA"}, "OrderNbr":{"value":"ORDER123"} } ]}This does create a shipment for the order however the shipment number it creates has already been allocated to another shipment on the system. What could i be missing here? the Shipment number i an expecting is a new one that has not been previously allocated to any sales order.

1 year ago

MahdiFreshman I

asked in Reports and Generic Inquires

How to order column alignment in excel when exporting a report designer

1 year ago

justinl

asked in Reports and Generic Inquires

Pivot Table Filter

I am creating a pivot table for shipment line details and want to be able to filter for multiple shipment numbers.However, when you add Shipment Number to the filter section you only have limited options for filtering, as below:Is there any way to make this a multi-select filter so the above would show a list of available shipment numbers that you can select with a checkbox?Many thanks

1 year ago

dmaughan83Freshman I

posted in Configuration and Installation

1 Tenant for Implementation isn't enough

It would be very, very beneficial to have 3 tenants for even just the implementation phase so the implementation can go smooth and we can set-up a test environment/UAT along with the Production Environment and the demo environment. If they need an extra tenant for an additional company, then we add that extra tenant as a paid one.I agree, this takes away a major factor in the decision process. Many of our customers buy Acumatica alone for the extra tenants...

1 year ago

lleibkuchlerFreshman I

asked in Financials

When trying to print AP Checks we receive: Field not found: 'PX.Objects.AP.APPrintChecks.APPaymentList'.

Hello All, apologies if this is a silly question. We are new to Acumatica and getting more experience by the day.In our sandbox environment when trying to print AP checks we are receiving the following error:Field not found: ‘PX.Objects.AP.APPrintChecks.APPaymentList’.On the Checks and Payments screen it shows status of “Pending Payment’. Any feedback is appreciated. Thank you in advance

1 year ago

andrew15Jr Varsity III

asked in Construction

Construction Reports

We are using 2020R2 and I am trying to edit many of the construction reports to have the project manager as a parameter. Our previous version 2019R1 had the project table right in the schema, so it was easy. In this version for example, the Project WIP Reports only has the tables Branch, PMReportProject, and PMWIPTotalBudget. When I look for the tables in the DAC, they don’t exist. I assume that they are hard coded somehow, as they are not a view in SQL and I can’t find these 2 of the tables anywhere in acuamtica or the SQL server. Does anyone know the relations of these tables with regards to the project table so I can add ownerID.Thanks

1 year ago

uma47Freshman II

asked in Reports and Generic Inquires

Pivot tables - number formatting

Hi, I have created a pivot table for shipment data and it has lots of number fields that are presented as text, when you export to excel. Is there a way to format the number columns so, it will show left aligned in the table and will have the correct format when exported to excel?

1 year ago

trenton78Freshman I

asked in Distribution

Create Purchase Orders - No Stock

Is there a way to change settings in the Purchasing module to have any stock item that is at a negative quantity (i.e.outstanding sales order for the stock item that is not in stock or only partially in stock) to populate on the Create Purchase Orders screen? In essence, automating the “Mark for PO” check box on the sales order forms.

1 year ago

Page 305 / 341

Badge winners

kdavis45has earned the badge Reports and Generic Inquires expert
tfarwell11has earned the badge Easy talker
jon95has earned the badge Innovator
Foujanhas earned the badge Easy talker
Fiehas earned the badge Easy talker

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

About Acumatica ERP system

Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.

Privacy Policy
Terms of Use
GDPR
SLA
Support
Report an Outage