Solved

Hi, How do you maintain your petty cash float in Acumatica. What are the steps taken to get the necessary funds in to petty cash to maintain the petty cash float. Would really appreciate your feedback.

Can anyone explain why these provide different values?from the results grid the result:from the GI 

1) should device hub run on our print server?2) we want to use device hub to send specific sets of production orders to specific printers. What is the best way to accomplish this?

In case of Database persistence errors I get the error message ‘Access to Message Queuing system is denied.‘But it not an issue of the Message Queueing system. I can access the databas and store data in general. In fact it is an issue with some concrete data that cannot be stored. E.g. property of an entity is wrong or missing.I get this every time when saving to the database fails. For example creating a Shipment from a Sales Order:Is there a chance to get a meaningful error message?

When you enter a sales order with SO or IN order type, click save, then on the payments tab click on create payment and enter the info, everything works correctly.  If you enter a sales order for a future date and try to create a payment, we get the following error     “Error: An error occurred during processing of the field Order Nbr. value AR008512        AR Error: The order cannot be applied, the specified combination of the order type and order number cannot be found in the system.”  This also occurs on our 2020R2 demo version.  Any ideas?

I have a question on whether on the Sales Order Form, if there is a possibility when entering a value in a custom field in the summary area, when we enter a value to that, it triggers appearance of some selected columns in the table (line level).

Only happens when I try to preview.  I can publish and run the screen fine.ASPx looks OK and there is no ColumnSpan property being set anywhere that I can see. <%@ Page Language="C#" MasterPageFile="~/MasterPages/FormDetail.master" AutoEventWireup="true" ValidateRequest="false" CodeFile="AP504520.aspx.cs" Inherits="Page_AP504520" Title="Untitled Page" %><%@ MasterType VirtualPath="~/MasterPages/FormDetail.master" %><asp:Content ID="cont1" ContentPlaceHolderID="phDS" Runat="Server"> <px:PXDataSource ID="ds" runat="server" Visible="True" Width="100%" TypeName="APCustomizations.APStaleDateLettersProcess" PrimaryView="Filter" > <CallbackCommands> </CallbackCommands> </px:PXDataSource></asp:Content><asp:Content ID="cont2" ContentPlaceHolderID="phF" Runat="Server"> <px:PXFormView ID="form" runat="server" DataSourceID="ds" DataMember="Filter" Width="100%" Height="100px" AllowAutoHide="false"> <Temp

I have a problem with my customization project.I added a SplitContainer manually to the aspx file since it is not avaible as control in the Screen Editor. It worked fine until I dared to remove Panel1MinSize of the SplitContainer in the Screen Editor. From then on Preview Changes always failes with this error message.“Cannot create an object of type 'System.Int32' from its string representation '' for the 'Panel1MinSize' property.”Setting this property again with an integer value does not help. Even after removing the splitter this error message prevents to preview the screen. The only way to get rid of it is to remove the hole screen and add it again with different ID.

Is there a way to rotate text on a report in Report Designer?I print information on a label and have a 3/4” section of the label that runs vertical.Is there a way to rotate this information?  

In the mobile app | Attribute Code | Text field typeHow can a user see all the information that is entered in a text attribute code?  It cuts off the information entered in the field.  We can’t figure out how the user can see the entire text that was entered.Currently tested in attribute codes entered in Cases. 

Our current process requires us to print one label at a time. For example Purchase order 1-10 have individual orders and our warehouse staff to print one at a time. Is there a way they can set a range and print them all?

We have a lot of back office staff and our AP clerk accidentally deleted a line on a service order that has a P.O. attached to it.  Now we have no way of getting correct costs to the service order that will reference the any accounting data in the system.  we need to add the line back so we can have the backup of the P.O. and then the trail to the AP invoice so it shows on the service order as the customer requires all backup and the AR clerk can invoice the service order for the correct amount.  We are running 2019R1.In a side note, the rest of the system should talk to the service management for proper cost accounting.

We are trying to understand the relation between the BILLABLE checkbox and the FREE checkbox in the field service module. There doesn't seem to be much content on this through help.  We have noticed a few issues and not sure if this is a bug or our limited understanding of the workflow. Example, we need to return to a customer site to perform a warranty service call:On Appointment or Service order if the BILLABLE box on any line is UNCHECKED (meaning we don’t want to invoice the customer for the line) the billing will not go through and will hang up in the RUN SERVICE ORDER/APPOINTMENT BILLING process screen indefinitely. (This might be a bug). However, if you go back and CHECK the BILLABLE item and ALSO check FREE, the system will generate a $0 SO invoice and will disappear from the process screen.  This creates a second problem; THEN, because there is no way to mark a SO invoice as DO NOT EMAIL (like you can an AR invoice), the $0 SO invoice will sit in a PENDING EMAIL or PENDING PRI

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")

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

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

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 .

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.

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.

I have a Generic Inquiry that sums transactions over a date range specified by Required Parameters StartDate and ThruDate with Default Values of @YearStart and @MonthEnd-1 respectively:Generic Inquiry ParametersAs I needed the ThruDate in Excel exports of this GI, I added it to the Results Grid:Generic Inquiry Results GridThe unexpected result is the Parameter (Thru Date) and the Result column (Statement Date) get different values when the Inquiry is executed:ResultsIf the Parameter is manually changed in the results screen, the dates match.The value in the resultant column is the date being applied (not the defaulted date displaying at top) verified by the calculated values and manually entering the dates. 

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.

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

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?

04-Jun-2021When I attempt to install the ERP 2021 R1 Update 6 version from the downloaded AcumaticaERPInstall.msi file, I receive the error listed in the title above.  I also receve the same error when attempting to install the ERP 2020 R2 Update 11 version. I have reviewed the “Сan’t get your IIS version from the registry. Probably you don’t have IIS?” error resolution, but I cannot duplicate it.  My registry does not have the key:  Computer\HKEY_LOCAL_MACHINE\SOFTWAREMicrosoft\InetStp Please advise.  Thanx.

Hello Everyone,I want to sync Stock Item Attribute (combo/multi-select combo) Value Description instead of Attribute Value ID at the time of Stock Item Sync from Acumatica to BigCommerce as custom field name and value.From Entity Mapping it is not possible, so I did a customization but observed that one attribute value, updating across all other custom field values.Please find below sample code and screenshots for reference.Sample Code:public class KNBCStockItemProcessorExt : PXGraphExtension<BCStockItemProcessor>    {               public delegate object GetAttributeDelegate(BCStockItemEntityBucket bucket, string attributeID);        [PXOverride]        public object GetAttribute(BCStockItemEntityBucket bucket, string attributeID, GetAttributeDelegate baseMethod)        {            MappedStockItem obj = bucket.Product;            StockItem impl = obj.Local;            impl.Attributes?.Where(x => string.Equals(x?.AttributeDescription?.Value, attributeID, StringComparison.Inva