Discussion Forums

In most situations, if I have an order with two lines--one line that I have stock on, and one line that I don’t (and the order is set to Backorder Allowed), when I create a shipment it only has the item that I have stock on.We’ve found a small subset of shipments over the past year (as far as I went back) that, with the example order above, show both items but the item with no stock has a Shipped Qty on the shipment of zero.  I looked at audit detail and it wasn’t added and then changed--the system (we create most shipments from the Process Orders screen) created the shipment with two lines, one with qty and one without.We discovered this because one of our warehouse managers had a pick ticket with multiple zero qty lines on it; he asked if this was something that “broke” during our upgrade (we moved from 23R1 to 25R1 last month).  I dug deeper and found about 10 shipments each month this year with zero qty lines added.This isn’t necessarily a problem, but I’m really confused what the

Hello,under “all E-Mails” we have the tab “all records”. When i archive an e-mail in the “all records” list, the archived E-Mail is now visible under “archived E-Mails” but still also visible under “all records”.I want to build in an steady filter, that excludes the archived e-mails, so that archived e-mails are only visible under “archived E-Mails” and not under “all records” anymore, So to sum it up, i just want to exclude the archived e-mails under “all records”, without using an standard temporary filter. (Via graph extension for example).I dont want to do it like shown in the folliwing screenshot, because i dont want a new tab, i just want to edit the existing “all records” tab non-temporarily: How can i build the code to do that?Hope you can help. Greetings  

Hi Team,We have issue with purchasing to appointments.We used to be able to add the vendor to the appointment, but now the field FSAppointmentDet.POVendorID is locked for editing. This was needed so that on the Create Purchase Orders process screen (PO505000) we could filter by vendor and the appointments would all come up to select and generate a PO from the lines. This is xxxx who service many sites and we need one PO with many lines. Without the vendor in the appointment we have lost the ability to filter the process screen to create the PO. We noticed the Service Contract Schedule now has a vendor, which would work, except it doesn’t flow to the appointments so what is the point? Please see the below screenshots    

Hi everyone,I’m trying to create a custom API endpoint in Acumatica that simply calls a custom function inside my code (for example, to run some business logic or integration helper).Basically, I have a function inside a helper class (for example: AuthorizeExistingPayment()), and I’d like to expose it through the Acumatica REST API so I can call it externally — something like:POST /entity/CustomAPI/1.0/MyFunction/RunHowever, I’m not sure what’s the correct approach in Acumatica to make this work. However, I’m not sure what’s the correct approach in Acumatica to make this work.I’ve seen some examples using: A custom BLC (Business Logic Controller) class that defines a PXAction, Or a custom screen with a PXFilter and PXAction, Then linking that to a Web Service Endpoint.     But I’m still confused about which method is recommended for simple custom APIs that only need to: Receive some JSON parameters, Execute my internal function, And return a custom response (without saving anyt

Hello all,How can I create a push notification for a custom business event. I have setup the biz event to be triggered at a specific time of the day. But I also want to configure the same as a push notification. How to do so?Thanks.

Hello,    I want to arrange the layout into two left-right sections on a single page in the Report Designer like below. Is there a way to do this?   I am thinking of subreport, but the point is how to pass/seperate the parameters?  To make left show 1-20 items, and right show 21-40 items?

A couple of years ago the design of PO Commitments changed.  Previously the commitment amounts recorded on Projects did not include tax.   For some reason, it now works as follows: If the Tax calculation on the Purchase Order is Inclusive of tax then the Commitment amount on the project is inclusive of tax for that specific commitment.    If the Tax calculation on the Purchase Order is exclusive of tax then the Commitment amount on the project is exclusive of tax for that specific commitment.   Thus you can have a situation where some of the Commitments are inclusive of tax and other are not.  On the Project Screens and Commitment Inquiries there is no indication whether or not the amounts are inclusive of tax.  The project actuals are exclusive of tax.   The budgets are exclusive of tax.  I had a client setup a new project with Budgets (ex GST), and as soon as they raised the Purchase Orders they were over budget.  Its like comparing apples and oranges in a completely dark room.  The

Hi,I have this error after install the last version of Acumatica. Connection to RabbitMQ failedThe service RabbitMQ is running. Thanks,EV

Hi..in version 2022,  define user-defined fields  can be define as mandatory field. When we create user defined field as mandatory, example in AP Cheques and Payment screen. If we create Cheques and payment record from Invoice and Adjustment screen, we are facing error. So, due to this mandatory setup, feature to create record from original data is not working (requistion to Purchase order, Purchase order to invoice? Is there any walkaround solution to this?

Trying to recreate a form we have been using that is manually created and maintained.  The data we need for the form is all in an Acumatica Project or related tables.We have a need to render a series of checkbox fields from the project on the form with custom CSS to display a different design of a boolean field (0/1).When the field is checked the output should be a Green Box with the word “YES” in the middle.  If it is not checked, we want to show a Red Box with the word “NO” in the middle.Doing some research I’ve found references to using an embedded image and creating picture boxes for the YES and NO images. This works with two picture boxes for each field, one for YES and one for NO.  They are both visible = false and using a Visibility formula you set the correct one to visible based on the value being 0 or 1. It would be nice to change the source of the image dynamically based on a formula using fiWe have a dozen or more fields we need to do this with on the report/form and to cre

Do you guys know some cheap CRM software to integrate with Acumatica?

Here is how you set up Acumatica Payments in 2023r2 version of Acumatica ERP.PrerequisitesMake sure you have the details needed to connect to your Processing Center.For Acumatica Payments you need the following values APIKEY, HASHKEY, LOCATIONID, USERID. It usually looks like the following:LOCATIONID: 11eda672c8d689b4ae137d65USERID: 11ecb74a72b0eb6ba237fcd7APIKEY: 41db9b32681e5a2ea1122e40HASHKEY: e6f8fe93f9479c330148c9e1 To get these values, you need to log in to your merchant account, using https://[yourcompany].sandbox.zeamster.com/ for the sandbox account or https://[yourcompany].zeamster.com/ for the live account.Then navigate to your profile settings → Advanced to generate Hash Key and API KeyThen go to Locations → Your Location and copy Location Id.Then go to the settings of the location→ usersSelect your user and copy the UserID In Acumatica make sure you have the following settings.The Acumatica Payments feature is active on the Enable/Disable features form (CS100000)  On the A

I have an Attribute added to Production Orders.  I need to update the value via the API.  I’ve tried PUT/PATCH/POSTing to the ProductionOrder endpoint with a body like:{  "OrderAttributes": [    {      "AttributeID": {        "value": "PKGMETHOD"      },      "Value": {        "value": "B"      }    }  ],  "OrderType": {    "value": "WO"  },  "ProductionNbr": {    "value": "00000006"  }}...but I just get an error like "The system failed to commit the ProductionAttributes row."  What do I need to do to update the attribute?

Our customer has 20+ scanners in the warehouse and is using Acumatica WMS. The mobile app requires that each username be stored as a separate account. The management of individual user accounts on each scanner is time-consuming, especially with high warehouse turnover. They really like the ability for each employee to have their own user configured, but this mobile app limitation is causing an issue.Does anyone have ideas about an option to change the mobile app login functionality to create the account with only the url, so each user would need to enter a username and password when logging in? (similar to the web UI login)

I tried adding a tab to the IN202000 screen, but it doesn’t show up.import { GridAutoGrowMode, GridPreset, PXFieldOptions, PXFieldState, PXView, autoRefresh, createCollection, gridConfig, viewInfo} from "client-controls";import { IN202000, ItemSettings } from "src/screens/IN/IN202000/IN202000"export interface IN202000_SKPriceIndexCST extends IN202000 { }export class IN202000_SKPriceIndexCST { @viewInfo({ containerName: "Price Index" }) xtStockItems = createCollection(xtStockItems_SKPriceIndexCST);}@gridConfig({ preset: GridPreset.Details})export class xtStockItems_SKPriceIndexCST extends PXView { }{ CategoryID: PXFieldState; EffDate: PXFieldState<PXFieldOptions.CommitChanges>; AsphaltPct: PXFieldState;}export interface ItemSettings_SKPriceIndexCST extends ItemSettings { }export class ItemSettings_SKPriceIndexCST { UsrSPriceIndex: PXFieldState;}<template> <qp-tab after="#tab-Description" id="tab-PriceIndex" caption="Price

Hello Experts, i just need a clarification that can we add two PO approvals for approvals will be of different branches. 

Hi Guys, is there a way to overwrite an existing alternate ID without creating a new one ?   Thanks for anyhelp

I was given a request to modify the Weekly Activity Report for a client that tracks their salespeople’s activities. The current report filters are Salesperson, Start Date and End Date. The problem is they noticed activities are being pulled to the report based on when the activity was ENTERED not the actual Start Date.When you enter an activity, you can select the actual date of the Activity Type in the Start Date field, HOWEVER, when you filter the dates to that range on the report, the activity does not show up as it is tracked in the system by the Date is was entered. The screenshot below shows the initial setup of the activity having a Start Date of 9/25/25 but entered on 10/8.The issue is the Start Date is treated as the Entered Date and not when the activity actually happened. Below you see the report is filtered to show all activities that occurred during 9/15-9/30Here is the result: No activities are shown.When the filters are changed to the dates used, then the activities are

Hi Community,Does anyone know how to add a Java Script to a Dashboard Screen ID or the 00000000 Screen ID in a Customization project? With other screens, I can drag and drop the Java Script onto, but the Dashboards do not allow me to.   When I click save, the screen DBAP0001 does not save it just goes to the 00000000 with the Java script saved. 

I am needing to add a custom “Sort Code” column in the Stock Items screen (IN2025PL). I am a new user and seem to be stuck. 

Is it possible to have no-code Actions from multiple customization projects show on the same screenI’m only seeing the no-code action from the published customization project with the highest level.Do all no-code actions per screen need to be in one single project?Or is there a way to have them all added to the screen, from their various projects? Example:Project 1 (Level 50) - Sales Orders > Action AProject 2 (Level 60) - Sales Orders > Action BWhen both projects are published, only Action B shows on the Sales Order screen.When only Project 1 is published, only Action A shows on the Sales Orders screen.

Hi,I’m curious if anyone knows why the error line that a quantity would go negative prior to creating the shipment from a Sales Order would be present for one user but not present for another user. I checked permissions and I can’t seem to find anything that would be different. When the person goes to create the shipment, it's removing the items that would go negative, but he doesn’t have that view while others have it. If anyone else has run into this issue and knows a resolution, it would be greatly appreciated. I attached a screenshot of my view and the other users view for reference. 

I am creating Modern UI versions of my customizations. I have been through a few tutorials and it seems the workflow that works for me is:Go into the Modern UI editor from the SCREENS section of the Customization Project Browser: (image 1)    Add my custom field (ie extended data table) to the screen. (image 2) Also add the custom field to the HTML View: (image 3)  Change the HTML Code to add my Page tab and field Editing logic: (image 4 -- here I am adding it right after the Mailing and printing tab)  Then I save and Publish it. When I run it in the Modern UI, I am getting a message (I guess a warning?) that I have something undefined. But I don’t understand what: (image 5) Everything else is fine, and the field can be set on and off OK… but why the Undefined nag?  In case it is in the HTML XML code, here is the part I added: <qp-tab id="tab-DoorCoreSettings" caption="DOORCORE SETTINGS"> <qp-template id="form-DoorCoreSettings" name="1-1-9" class="label-size-xm" wg

How do I enter a prepayment for a vendor when we don't have a PO yet?

It has been a long time coming and Steve Buttry and the Buttry & Brown Development hosted a great event with 14 people showing up!  Great conversation around AI and Projects.  We are working to establish a long term group.  Let’s get involved and make this a good group.