Solved

Are there any character limits to warehouse and warehouse location names? Ie. length and special characters like dashes?ex. Warehouse-Bulk-Fuel

I have created a Date Parameter for a custom report.  I am trying to filter the report by this parameter, the result is coming back with no data (a blank report).  I am selecting a date that i am 100% sure is in the dataset because i have a raw dump of the data.  What am I missing, why is my filter not working?  Does this have something to do with the values being seen as text instead of date? 

Hello Acumatica Community,i am trying to add the attributes of a stock item to the PO Line in the Details TabThese Attributes:For my problem i found this post: I thought i could transfer that to the PO and add the inventory attributes to the Details Tab. After 2 very long days and suffering i no longer know what to do. I would like you to take a look into the code of my customization. I added a new custom field in POLine which i believe later stores the value of the specific attribute. But i am not sure if i correctly defined which attribute to show.Here is my Code for the DAC Extension of POLine:using PX.Common;using PX.Data.BQL;using PX.Data.ReferentialIntegrity.Attributes;using PX.Data;using PX.Objects.AP;using PX.Objects.CM.Extensions;using PX.Objects.Common.Bql;using PX.Objects.Common.Discount.Attributes;using PX.Objects.Common.Discount;using PX.Objects.Common;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.IN.Matrix.Interfaces;using PX.Objects.IN;usin

I’m still new to programming in Acumatica, so I may have gotten several things wrong here, but I’m trying to get a single value to be returned from this BQL statement which should be the sum of a specific customer’s invoices for the current year for the price of goods only. I’m getting a highlighted error in Visual Studio that says that the entire BQL statement is a type that is not valid in the given context. I’m also not sure if the Convert.ToDecimal function will work with an ARInvoice.curyGoodsTotal object. namespace PX.Objects.AR{ public class DateYearStart : PX.Data.BQL.BqlDateTime.Constant<DateYearStart> { public DateYearStart() : base(new DateTime(DateTime.Today.Year, 1, 1)) { } } public class DocTypeString : PX.Data.BQL.BqlString.Constant<DocTypeString> { public DocTypeString() : base("INV") { } } public class CustomerMaint_Extension : PXGraphExtension<PX.Objects.AR.CustomerMain

In the following BQL Fluent statement, I am selecting a record from the POVendorInventory table.In the table, the record has a NULL in the SubItemID field.  When there is a NULL in that field, this returns no record even though my parameter “reg.SubItemID’ is passing a NULL.That field is part of a unique index.  My select statement is making sure that if a record already exists with the key fields, it does not add a duplicate.POVendorInventory test = SelectFrom<POVendorInventory>                    .Where<POVendorInventory.vendorID.IsEqual<@P.AsInt>                        .And<POVendorInventory.inventoryID.IsEqual<@P.AsInt>>                        .And<POVendorInventory.purchaseUnit.IsEqual<@P.AsString>>                        .And<POVendorInventory.vendorLocationID.IsEqual<@P.AsInt>>                        .And<POVendorInventory.subItemID.IsEqual<@P.AsInt>>>                    .View.Select(graph, bAccountTo.BAccountID,

How to print Billing and Bookings Amount in ARM Report?Below is the screenshot for reference: The Billings I manually grab the total sales from the P&L report. To only provide the weekly number of billings or sales. The report would look like this : Start Date: 7/1/2023End Date : 7/8/2023 Bookings : $598,477.13Billings: $476,910.84 The Next week it would look like: Start Date: 7/9/2023End Date : 7/16/2023 Bookings : $488,263.00Billings: $517,963.02

I need to give a role access to add notes to invoices, but do nothing else, beyond view, regarding invoices.How do I do this?

Hello,The initial brief was as follows:Show all items where itemclass in (spareparts, lvspareparts) and use date range. Fields to show:Inventory ID, Inventory DescriptionTotal Sales for date range Total qtyonhand all warehouses (just the total holding like on stock items page)Total transferred over date rangeLast invoiced dateLast Cost On the results we are getting some larger numbers, and not all the QOH look right, any idea on how to improve on the results here?  

I have a client asking if the search result color can be changed within Report Designer. They find the light green difficult to see. I haven’t found a way of changing this. Does anyone know?Example below:  

Trying to sum multiple lines on a GI - and then use that sum within a secondary calculation. Is this possible in Acumatica? I seem to be getting varied results when attempting this per below.  

Hello Linkies,I have been stuck in a situation where I have an AP Bill created in the system (Xero). But without capturing the payments Credit Note has been applied on it. How can I record the same in Acumatica?Thanks in Advance.

Hello, I am trying to set up physical inventory counts but I am not seeing all of the generation methods as shown in online tutorials. How do I add? I only have Full Physical Inventory as an option on my end. 

I have been looking into the Movement class calculations and I was wondering if anyone had any more insight as to what transactions go into this calculation? I haven’t been able to identify exactly what it is? All documentation I could find was Quantity Sold, but I wasn’t sure if this accounted for Issues to Production, Sales, Inventory Adjustment, etc?Any help would be appreciated!

Hello community,I would like to make a field of Int Data Type to not accept negative values. I would like to know if I can define the logics using the Customization project Editor? If not then using VS how shall I load up the file in which i am willing to apply the condition for the particular field?Thanks in Advance.

I am trying to access the Ship-to Address information seen on the invoice Addresses screen here:However I don’t see an available endpoint for that in the API. How do I pull this info in the API?  

Hi All, I have previously asked this question for an AR Invoice in a different approach. But I was unable to resolve it using the replies of that question because of some issues(Release method is not triggering when we process invoices from a process screen).However, Now I want to attach a report pdf to files section of an AP Invoice through Release AP Documents screen. I tried to override Release action in APPaymentEntry graph. But it is not triggering when releasing invoices through Release AP Documents screen. Then I tried the below code snippet & it is triggering for each AP Invoice. There are no errors in the code. But file is not attaching as expected. Below is my code.Acumatica Version : 21.213using System;using System.Linq;using System.Collections;using System.Collections.Generic;using System.Text;using PX.Common;using PX.Data;using PX.Data.DependencyInjection;using PX.Data.WorkflowAPI;using PX.LicensePolicy;using PX.Objects.Common;using PX.Objects.Common.Extensions;using P

Im using automation schedule on Process orders screen but it dosent want to work Am i missing something ?    

Hi All,I am pretty sure I am just missing something but does anyone know how I can add a second lot number to Production maintenance? When I add a second line and save, it moves all the qty to the first lot number.  

HiI wanted to create approval map to enable approval of the purchase orders. I’ve done the creation and leave the condition tab blank since when I select the entity type as Purchase order the status does not appear on the field name  but on the rule action tab have specified the following;- but it does not work, is there another way to do it?

I am creating a Azure DevOps pipeline for Acumatica Automation project to build and run. I am not able to run the automation from pipeline. I may be using the wrong task. I have tried dotnet run, since Acumatica Automation is console application. VS test may not work since it is for nunit/xunit type. Any idea/suggestions or link to the article or YouTube video. I tried googling but no help.

Hi All, I want to show all records associated with any Account when Account Filter field is null in Account Details Screen. Otherwise it should work as usual. How can I achieve this? Thanks

Hi!We have eCommerce connector setup with a Shopify store and configured schedules for Stock Items preparation and processing (on daily basis).We have two problems:Some items were last processed a month ago. Is there a filter of some sort? What can affect this and which stock items can be excluded if the automation schedule screen doesn’t allow to configure such low level details (it’s just Entity, frequency, time basically). We map product visibility with status in Shopify: visible → product is Active, invisible → product is synced to Shopify still but as a Draft stock item. This gets ignored on some products and with visibility at Visible and Export to External System box checked off, the products sync as Draft. What can cause this?Thanks!

Hi Team,We are getting the below error when an update is done on CROpportunity table.“Incorrect datetime value: '4095-15-255 255:63:63.1048575' for column 'Tstamp' at row 1”Column tststamp on the table is defined as`tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), from my understanding this means if there is no explicit value defined for tststamp, if any update happens the value for tstamp column should be set to current timestamp. Not sure how this invalid value is getting set.  

When i call Sales Orders API and put the data in the body when i execute the Request i Get 500 Status code with "exceptionMessage":"Object reference not set to an instance of an object."but when i put the same data manually the order saves normally.anyone faced this problem before ?Below is the StackStack Trace For http://Websiteserver/siteName/entity/Integration/18.200.001/SalesOrder 

Hi Everyone.I recently had a question posed to me and I am still researching possible options. For inventory adjustment, the subaccount can only be specified through the reason code. Is it possoble to specify the subaccount outsdie of the reason code (directly on the adjustent)? Thanks