Discussion Forums

Hey,Does anyone know how to remove a BOM as a default BOM for a stock item. For example, I have a BOM for an item that we used to make, but the item changed and needed a new BOM revision, and when that new revision is set to the default BOM, I assumed it would remove the default from the old BOM.   Instead, now I have two BOMs for the same stock item, that are both the “default’ BOM.  

I am trying to retrieve the tax ID number from the vendor table. I see the field I need, but it comes up blank. All I need is the vendor and tax ID to show up in this query, and all I can get is the Vendor ID and name to show. I tried linking the location table, but I get the following error: conversion failed when converting the nvarchar value ‘Main” to data type integer. I feel like this should be a simple query, but I am obviously missing something.

We are testing using the STEPS tab on the Bill of Material and having this show up for operators in the Production Order Details as Work Instructions with pictures and we can’t get the Step detail that is added to a Bill of Material to show up on the Production Order.  We want to keep this digital and not print a production ticket report which we could build a custom report to have it show up.   Has anyone used steps and can provide some advice?  I haven’t found any reference at all to STEPS in the HELP nor on Community so I’m at a loss.   ​@ChrisOkamuro52 - You showed step detail in the Shop Floor Kiosk demo at Summit this year.  Was pulling the Step detail into a production order new functionality and not something available today?  

I am trying to create a report with a blank column to divide out actual vs budget columns.  When I run the report there are zeros on some rows but not others.  I can’t figure out why it is pulling the zeros.  Everything else looks correct for the actual columns.

Hello all,I have been trying to create an export scenario of CSV file but it is not filling in the schema fields if I only define the column names. But if i enter any data under the column names then acumatica displays me the schema fields. Since this is an export scenario, we cant fill in dummy data under those columns.Attaching the xml of data provider. 

When I am posting the SO and Statue is  Awaiting payment so, I don't know how to change it as open. If I can change it I have normal flow process. Thanks for your support and helping 

I am working on a mobile app customization for the Bill and Adjustment (AP301000) screen. I need to display a pop-up for the user to enter a reason when they reject a document.I have tried the following customization:update screen AP301000 {    add container "EnterReason" {        add field "Reason"        add recordAction "EnterReason" {            behavior = Void            redirect = True            redirectToContainer = "EnterReason"        }    }    update container "DocumentSummary" {        update recordAction "Reject" {            behavior = Void            redirect = True            redirectToContainer = "EnterReason"        }    }} Issue:When I press Reject, the "Enter Reason" screen appears, and I can see the Reason field. However, I do not see the OK and Cancel buttons on the screen, which prevents the user from confirming or dismissing the action.Expected Behavior: When the Reject button is clicked, a pop-up should appear with a Reason field and two buttons: OK and Cancel.

Has anyone done an SMS gateway integration with Acumatica ?  Can you integrate any Bank’s SMS gateway as long as they have the right APIs ?

I am running into an issue when attempting to publish a new report I have created from scratch to my Acumatica instance. This is occurring after our upgrade to 24R2Unlike the other related article, How to resolve the 'Root element is missing' error on opening a report in Acumatica Report Designer | Community, this error is happening in Acumatica and not the report designer itself. I know my report designer is working correctly because I can edit and save-to-server existing reports without issue.The issue only happens when I try to use a new site mapping. I am able to connect the report designer to Acumatica. I can save it to the server. I have updated the Site Map screen to create a new screen for it - IN615300 since it is an inventory status report. I have set permissions to allow the appropriate people to access the report. Yet, when anyone goes to view the report, we all see: with a trace of:  Is there some additional configuration I need for new reports? Are there restrictions to w

Hello all,How can I print the page numbers in a correct way? I now there’s an option under the properties section - Print on Every Page but I’m unable to find that option in report designer.   FYI, there are no joins/tables being used in here as it is just a simple form.

I have a customer who has been anxiously waiting for the ability to complete a 2-step transfer on the mobile app. I see now that you can actually select Transfer Receipt as on option under Purchase Receipts:However, all I seem to be able to do is create the record. I can’t find anywhere to enter the Transfer Order to receive. Help?Thanks!   

Hi Community,Could someone please assist with the following situation:I have a Sales Order for 5 items Marked for PO, Purchase to Order. I create the PO, and I increase the quantity from 5 to 50. I try to Receive these 50 into my warehouse, and I get this error. Error: IN Document has been created but failed to release with the following error: 'Error: Inserting  'Sales Order Line Split' record raised at least one error. Please review the errors. Error: 'Lot/Serial Nbr.' cannot be empty.'. Please, validate a created IN Document This is the Lot/Serial Class associated with the item: Thank you,RJ

Hi everyone.I’m trying to pass a “notes” field in when creating or updating Employee Time Activities. Below is an example of my request: PUT "/entity/Default/22.200.001/TimeEntry"{ "note": "Some notes", "BillableTime": { "value": "01:00" }, "Date": { "value": "2024-02-16T06:00:00-08:00" }, "Summary": { "value": "Hours from Timesheet" }, "EarningType": { "value": "RG" }, "Employee": { "value": "EP00000002" }, "LaborItem": { "value": "CONSULTSR" }, "ProjectID": { "value": "X" }, "TimeSpent": { "value": "01:30" } }The Time Activity gets created, but the notes do not get passed through. Also, I’m trying to run the CompleteTimeEntry action on the PUT "/entity/Default/22.200.001/TimeEntry", but I always get the “Invalid uri structure” error even though I have this as a mapped action:Any ideas what’s happening?

How do we use the two-factor authentication on the mobile app? The box opens to enter a two-factor authentication code on the mobile, but no way to request the code. 

I have a field hidden via Low Code… do I need to set a condition and/or workflow to dynamically make it visible?

I want to filter out some specific data out of a table on the coding side so that users can’t see it. How would I go about setting filters, so specific information is excluded?

Do the Generate intercompany document (AP503500) is supposed to generate AP/AR for a interbranch timecard ?Thanks

I’m trying to create a Business Event, that when it triggers, it changes some information in a specific Sales Order Record. I presume it is using a Action Execution, but I’m not sure which Action Name needs to be used. The few I tried didn’t work.

We are just starting to configure a site for a customer that will be using service management, project management and inventory. Our service order type is set to generate project transactions upon invoice Our projects will be percentage completion billed When a service order appointment is created with inventory lines, and is invoiced, Acumatica creates an IN transactions to reduce inventory (this seems correct). However, the inventory transaction that appears on the project has no quantity or cost related to it. So while inventory is correct or job/project has not absorbed the inventory cost and is therefore incorrect.It seems silly to me that a service order tied to a project would not update the actual cost of the inventory to the project system. Am I missing a setup/configuration or perhaps a business process work around?I did see that there was this:AC-256292: If in the Generated Billing Documents box on the General tab of the Service Order Types (FS202300) form, Project Transacti

Hey there, We’re working on migrating to Acumatica. We uploaded our stock items, but the move to new system has been delayed, and the data is outdated. I’d like to just mass delete the records, and do a fresh upload, rather than go and update 100’s of products.  How do I mass delete records? Deleting 10,000 products one at a time would take a long time. Thank you!

There is a ‘Print Quote’ button on the mobile Acumatica app. Has anyone gotten it to work?Just got a notification ‘Uploading to Acumatica...’, apart from this nothing happens. 

Hello Acumatica Community,I am currently working on customizing the Tickets Screen (CR306000) in Acumatica and have added the following toolbar button within the aspx file: <px:PXToolBarButton Text="NOTIZ ERSTELLEN" Tooltip="Eine Interne Notiz erstellen" Key="AddActivityEN"> <AutoCallBack Target="ds" Command="NewActivityEN" /></px:PXToolBarButton> However, when displayed in the UI, the button text does not reflect "NOTIZ ERSTELLEN" ("Create Note" in German). Instead, it appears as "Create Notiz", where "Create" remains in English while "Note" is translated to “Notiz”. He seems to use the Activity Description here.I can’t seem to find out where i can translate this - or get rid of the “Create” as this doesn’t seem to appear in Translation Dictionaries. Any insights or suggestions would be greatly appreciated!

What I want is for these fields and button to be disabled or, rather, in read-only mode. Not like in this case, which is due to validation:https://community.acumatica.com/develop-customizations-288/why-is-the-kit-line-detail-form-always-disabled-24699?tid=24699&fid=288  

I am building a GI that would link service orders with sales order. In this case, the service order is not created from the sales order, so they are not inherently linked. Instead, the sales order number is entered manually in the description of the service order.So I am looking to join the service order and sales order tables through the service order description text field. How would I do this join?The join above is not getting me any results. 

I am trying to create a projection query this is the sql query which works. I tried something like this[PXProjection(typeof(Select4<    PMBudget,    Where2<        Where<PMBudget.type, Equal<AccountType.income>>,        Or<            Where<PMBudget.type, Equal<AccountType.expense>,            And<ParentChildContractExt.usrIsChildProject, Equal<True>>>>>,            And<PMBudget.accountGroupID, In<            Select<ProjectTransferRequestSetup,Where<ProjectTransferRequestSetup.transferAccountGroup, IsNotNull>>>>>>>>,    Aggregate<        GroupBy<PMBudget.projectID,        Sum<PMBudget.curyRevisedAmount,        Sum<PMBudget.curyAmount,        Sum<PMBudget.curyInvoicedAmount,        Sum<PMBudget.curyActualAmount,        Sum<PMBudget.curyInclTaxAmount,        Sum<PMBudget.curyTotalRetainedAmount,        Sum<PMBudget.curyAmountToInvoice,        Sum<PMBudget.curyChangeOrderAm