Solved

In ARM report, if the data source for a row has no activity, the row shows blank. I need it to show ‘0’ I tried the IsNull formula. This works if I have no accounts in the data source, but if I have accounts selected with no activity in the period, it still shows blank. So it’s looking at the data source rather than the result/activity. Anyone know how this might be accomplished?Thank you  

Hi, user meet an issue when doing an AP bill,there is a bill with vendor A, but employee1  already help to make the full payment.Right now, they want to use the same ap bill to pay back the amount to the employee1 to clear the amount which still owed to the Vendor A.Scenarios:Vendor still = Vendor Abut the amount in checks and payments screen pay to Employee1Is it able to do it?

Hello all,I am trying to add an asterisk symbol next to a currency value in report designer, but I’m having some difficulty.I believe that I can’t use the format box in the Appearance section because the asterisk isn’t a numeric value, so I’m attempting to format the numeric value using a format formula, and then concatenate it with the asterisk symbol.I used the formatting suggesting at the bottom of this thread:  However, the result that I see in my report does not show any commas within the numeric value. It did add the decimal places at the end. =Format([@PARAMETER],'###,###.')  results in a display of 123456.00 instead of 123,456.00Can anyone recommend a solution? 

I have a dashboard to display on 20+ kiosk TV screens on our shop floor.  We are attempting to show the Moves that were completed for today to show how much progress is being made.  I have a generic inquiry that displays the columns needed and the only parameter is the Work Center (each TV screen will have a different parameter value for the appropriate work center).I can get my kiosk software to automatically pull up a generic inquiry for the correct work center by adding “&WorkCenter=SUB3” to the URL to be displayed on the TV screen: Dashboard Parameters, however, do not add the “&WorkCenter=SUB3” when a dashboard-level parameter is entered in:Therefore, I have no way to get my kiosk software to display the Moves by work center by using the same dashboard.  I would have to create 20+ dashboards, each specific to a work center.Anybody have creative ideas for how to utilize one dashboard but be able to pull up each work center (parameter) via a different URL like I can with Gen

Hello, I’m trying to disable the VOID button for our AP Clerk Role in Checks & Payments screen. Does anyone know how to do this? 

I created a new user defined field on Sales Orders, how can I find this within SQL? Does it exist in a EXT table?  Also assuming the answer is yes to the EXT tables, can you run a Generic Inquiry off of User Defined Fields and have it generate emails, notifications, etc. using automation schedule.   

I am trying to add address fields to the Location selector on the Opportunities screen.I copied the code from Sergey’s blog at https://asiablog.acumatica.com/2015/10/customizing-selector-attributes.htmlFrom the blog, the code is like this: #region CustomerLocationID public abstract class customerLocationID : PX.Data.IBqlField { } [PXMergeAttributesAttribute(Method = MergeMethod.Merge)] [PXCustomizeSelectorColumns( typeof(PX.Objects.CR.Location.locationCD), typeof(PX.Objects.CR.Location.descr), typeof(PX.Objects.CR.Address.addressLine1))] [LocationID(typeof(Where<Location.bAccountID, Equal<Current<SOOrder.customerID>>, And<Location.isActive, Equal<True>, And<MatchWithBranch<Location.cBranchID>>>>), typeof(InnerJoin<Address, On<Location.defAddressID, Equal<Address.addressID>>>), DescriptionField = typeof(Location.descr), Visibility = PXUIVisibility.SelectorVisible)] public int? CustomerLocationID { get; set;

I created a new Non-stock item to use for expense claims, but the “Current Cost” is not updating even though I saved the item with the new cost and current date. (see screen shot).  Why did that not update the current cost? 

I am not able to edit an existing “ONHOLD” Bill, has anyone run into this issue today?  My Bills that are in the “OPEN” status don’t have the PAY option available either.  I can create a new bill but as soon as I save it the amount is not transferring over to the AMOUNT box.ThanksHolly

hi!is anyone aware of a way to mass delete emails pending processing?  i know you can click into the email and cancel processing which removes it from the list but i wasn’t sure if there was something already in acumatica that would allow you to cancel more than one email at a time!any help is appreciated!

Hello - I want to set an approval process for “normal” PO’s. However, I want to exclude the process for Drop-Ship POs. What is the best way to do this?I have some automation that will generate the PO for our drop ships.When I turn on an approval for the Normal PO I start getting an error regarding the lack of an owner on the PO. 

How can we generate an invoice for recognition transection after runing  Recognition it only generates a batch number. If we want an invoice, what do we do? 

Acumatica has as a 1099 Box selection - MISC 07/NEC 02 - Direct Sales.  Is there any documentation on this or does someone know how / where this box should be used ?  I have found that using this Box on AP bills does not print on either 1099 form.  Is this a big?IRS says… You may either file Form 1099-MISC (box 7) or Form 1099-NEC (box 2) to report sales totaling $5,000 or more of consumer products to a person on a buy-sell, a deposit-commission, or other commission basis for resale.  

We are exporting Bills into Acumatica from our application, and I have gotten that mostly working as expected.  A new requirement to pay bills electronically inside our system has come across my JIRA board, and I was wondering if anyone else had any experience posting a payment that has been made externally to Acumatica.  Would I just use the PaymentAPI?

I’m using 2023R1 Construction edition and Im looking to find out how to add paid holidays so that they automate. We import time cards via import scenario, is there a way to have the pre scheduled holidays add to the imported time?

Hi All,Im working on Fixed Asset then recognise some Fixed Asset which were converted from PO have wrong Orig. Acquisition Cost. 

Hello all,I was wandering if we can add a collection of pdf pages in the wiki pages? the format is the same as that of the PDF one while generating reports Can we add such a report viewer in wiki page?Thanks.

Hello, has anyone created a business event notification for when a prior period is unlocked?

We have purchased a Spanish Language Package to provide an additional language option for our Spanish-speaking users. Could someone please guide us through the process of enabling it? Our partner has initiated a case with Acumatica, but unfortunately, they haven't been able to provide clear instructions on adding the additional language. Any assistance would be greatly appreciated. Thank you.

Hello, we have the problem that we have set push notifications and on an iPhone 13 the notification arrives. But on an iPhone 7 with IOS 5.8 there is no notification. The Haufe X360 app has the same version on both devices.

Wondering if it is possible to create 2 invoices and 2 separate dispatch consignments from the one “open” shipment.Example :Order is generated via online platform then integrated with Acumatica.Warehouse “Opens” order and creates picking slipSome orders may contain “dangerous goods” which will be required to be sent separately with another carrierAs customer has already paid for goods we want to be able to separate and generate the 2 invoices. 1 each to accompany the package.If not, anybody have suggestionsThanks  

Employee has worked a few hours in a payweek therefore gross pay is not enough to cover weekly deductions. Acumatica wont calculate paycheck. How do we get Acumatica to take what it can and produce a zero dollar paycheck? 

Does anyone know of a way to use a single Rest API PUT request to both, create an SO, and allocate serialized items to the lines?I have a call structured like this:{ "CustomerID": {"value": "C000517"}, "Date": {"value": "2022-08-28T00:00:00"}, "Description": {"value": "Postman Test"}, "Details": [ { "DiscountAmount": {"value": 10.00}, "ExtendedPrice": {"value": 2000.00}, "FreeItem": {"value": false}, "InventoryID": {"value": "TestItem"}, "OrderQty": {"value": 1.00}, "UnitPrice": {"value": 2000.00}, "UOM": {"value": "EA"}, "WarehouseID": {"value": "MAIN"}, "Allocations": [ { "SplitLineNbr": {"value": "2"}, "Allocated": { "value": true }, "AllocWarehouseID": { "value": "MAIN" }, "InventoryID": {

How do I clear/delete the child PO of a Blanket PO that has been deleted and no longer available? Child PO is still showing on Hold with Error: An Invalid Argument has been specified. Parameter Name: blanketRow. Visually, the child PO is completely blank.  

Hi,Is there a history report or some other way available related to salespersons to check their assignments/Resignments etc.Thanks