Solved

Hi Everyone,  I want to create a KPI dashboard for our warehouse. Besides the obvious number of open/late shipments, we want to measure productivity. i.e., the average time it takes to pick a shipment after the pick ticket is printed/assigned. How often do locations need to be changed due to inaccurate inventory. I'm not sure where this information is stored in Acumatica, if it is at all. Can anyone shed some light on this? Does anyone have any ideas?  

Does anyone know what Acumatica’s response to this is?  The original post was 10 months ago and it seems like we are 3 wks away from our UPS utility not functioning with still no solution available from Acumatica. I have added a new branch and am unable to setup UPS for that facility which is a problem.  

Trying to make a GI that has a Condition to only show results is a specific Warehouse Item detail exists, and if that Warehouse Item detail has the Override Replenishment check box checked.  This is what I have currently:But my results do not filter out just the check boxed items.  And I triggering the validation of a check box incorrectly?

Warning showing as ‘Warning: Enter the document open balance to this box.’ and we have entered actual open balance of the Invoice. Can someone help me to import this Invoices. Please note: Migration Mode Activated

HI All,Is it possible to add a frequency to a service order or to a line item on service order?Business Case: we supply service Maintenance quarterly. We expect to create 1 service order and that service order can be run automatically quarterly to create an appointment for each quarter.Current I run manually after create a service order. In this case, I have to click Create Appointment 4 times when I want to have schedule for service Maintenance within year.service order with maintenance service need to run quarterlycurrently i run appointments manually after creating service order and then edit the schedule datethanks in advance,Yên Chi

I am new to GI’s. I am trying to expose the G/L accounts for the items below for the GI Inquiry under Vendors. I also need to expose the Account e-mail field to the Vendor GI Inquiry as well. Also, what table do I need to add below to get the above Data: Also, what relations do I need to add to below.  Any help would be greatly appreciated?  Thanks,Frances    

Hello everyone,The goal is to set a custom field simultaneously when the Shipping information of the Sales Order is populated upon selecting the Customer.I tried to accomplish this through customization, but unfortunately, I'm unable to locate the correct method name for capturing the moment when the Customer information is integrated into the Sales Order.Appreciate any assistance!

I need to add the Qty available to the Inventory Valuation report, however the entire report seems to be based off Qty on hand in the INTranCost table. We need to know how much of a given product is available and the total cost of everything sitting on the shelf unsold.  Has anyone else tried adding this field to the report in report designer?

Hey Folks,Hoping someone has tried to do this before.  I have everything working except that I can’t get the import scenario to work because of “Branch Location”.  When you run an Import by Scenario manually, Branch Location gets populated based on the one selected in your profile, but because the import scenario gets run by the triggered business event, it does not pick up any Branch Location.   I can’t even tell what Branch the system chooses to post the service order from.  So, this is what I need:1, Some way to select a Branch Location from the Import Scenario.  Something that can maybe search the field, and return the first value.Here is my import scenario, I tried manually selecting my default BL, but to no avail:  

How to use cash account details to find discrepancy in between Bank Rec & Trial Balance Summary ending balance. My Bank Rec cash account balance & Trial Balance Summary ending balance have not been matching for a couple of months and can not seems to find the discrepancy, I saw a article saying the cash account details can help but I’m not sure how or what i should be looking for.any help would be appreciated!Thank you, 

We have run into a costly issue of “ghost” PO’s being sent that none of our buyers claim ever sending. Is there a way of removing the “email purchase order” option from users (picture below)?  I have tried revoking access right to “Print/Email Purchase Orders” from the role but users are still able to accidently use the “Email Purchase Order” option.  

 I need to fix acuminator warnings of type PX1072. Here I have a custom graph written in which there’s a static method. Inside this static method, I need to use graph in BQL statements. Since its custom graph with static method, so I cannot use this and Base as well. Initial code is using new PxGraph() as a wrokaround. Below is the screenshot. Also wanted to understand if calling a delegate having update/insert statements at various places inside row selected is good or bad? I am using 2024R1 Preview as my instance.

I have a customer who made a payment using a credit and wants to change to a different card (different payment method already associated with his account).  How can I modify the payment to reflect this?  I tried the following PUT method URL in Postman:https://sandbox.com/AcumaticaERP/entity/Default/22.200.001/PaymentHere’s the body I passed:{        "Type":{"value":"Payment"},        "ReferenceNbr": { "value": "183610" },        "PaymentMethod": {"value": "CC MASTCRD"},        "NewCard": { "value": false },        "CardAccountNbr": {"value": "Mastcrd:****-****-****-4203"}}I don’t get an error but, unfortunately, Postman just returns the existing Payment with no card change applied.

When I Upgrade to 24.104.0008 from 23.104.0030 instance i get this error   “ at AcumaticaConfig.Installation.DatabaseWork(BaseInstallProvider provider, ProgressBase progressBar)   at AcumaticaConfig.Installation.WithProgressBar(BaseInstallProvider provider, Action`2 installationMethod) “ 

 I added a field on a customer record to the SO header.      When I add this customer to the SO the field appears as does the value on the customer record. However, when I close the record and return to it later the value disappears.  If I do something in this record and save it again the value will reappear.  Below is the attribute...do I need to add something here?  I have tried to commit the changes but that does not work.  Advise would be appreciated. [PXDBBool][PXUIField(DisplayName="COA")]  

How to fix this Note:I’m using a local instance

Hi,Does anyone know how to resolve this error? I am unable to access report IN615000 Inventory Balance Report.Thanks for any help.  

How do I update Customer Credit Limit for groups of customers with different values? We have appx. 1000 customer Credit Limit changes/updates to make (out of our 2500 total customers) with multiple different $$$ value limits. We prefer not to do these manually. Thank you.  

a webservice end point removed by accident, now I’m trying to bring that endpoint back, is there away to bring it back Thank you

Is there a way for the Attributes to appear on the po screen?

Hi, Can we restore the snapshot on test tenant without affecting on the live tenant of live instance.

Hi guys, I have been introducing the packing feature to our factory staff and training them up on this.I have been experiencing an issue where when the shipment is open, and a run of production is complete, the produced items OCCASIONALY do not allocate to the sales order and therefore cannot be added to the shipment. Has anyone else experienced this? Thanks all, Aleks

I’m trying to change all of my Non-Stock Item Inventory ID Numbers to have “NS-” in front of them.  When I run my Import Scenario the first inventory Item does not get changed at all.  The second inventory item gets renamed with the New Inventory ID I had for the FIRST item.  All subsequent items get similarly renamed with the next Inventory ID in the Data Provider - all off by one record.     Any ideas? 

Using 2023R2, I want to hide the following tabs:Using roles, I’ve been able to hide all but CRM Info, Relations and Marketing Lists.  I can seem to find the screens/actions to revoke in the Access Rights by Screen or Roles screens.  Any guidance?

Hi Guys,First timer here!We are using Acumatica version 2021 R2 Build 21.212.0039. We updated the storage locations (Default Receipt To and Default Issue From) for each stock item to read as something else other than the default value of 'Storage'. This was done through Import Scenario and the update went through without any problems and both values updated successfully. However, on checking the same list a few days later, it seems that the Default Receipt To value has reset back to read as ‘Storage’.Import Scenario How to ensure that this value does not revert back to read as Storage because from the end result, the purpose of having different locations is defeated? If this is not something that is expected, has this issue been addressed and fixed in version 2023 R2 Build 23.207.0025  (we shall be upgrading to this version soon)?Please advise.Manish