Discussion Forums

Hi EveryoneThe warning message, "NTE Value Exceeded. Do you want to process it?", appears repeatedly in the Appointment form whenever "OK" is clicked. This occurs when attempting to save an appointment that was created from a Service Order form.We need assistance in preventing the warning from being shown multiple times during the save process.Could you please assist for us.

Hi all, I am wanting to add suppliers bank details onto the remittance from but am unable to extract the data from the grid. I have added the PaymentMethodDetail table to the report but it doesn’t report on the actual information in the grid and just gives me either the headers or other values.   

I am trying to set a business even that creates a task when the Negotiation date is changed on a Contractible Ingredient but I want the tasks due date to be something configured like @today+30 with the start date being @today. these options are not available when selecting the from schema option nor does it seem to work when entered as such manually. is there something I am missing here or will this require customization? 

Business task - CR Quotes (from Opportunities) are emailed to the prospective customer. The quote is attached as a pdf. After a month, we wanted to send a follow-up email to see if there are any questions or if the quote is “dead”.Setup - We created an email template for the follow-up which includes the new verbiage as well as the original email verbiage. (Did this so that the new verbiage is at the top of the email rather than the bottom - a known issue in Acumatica.)Process - The original quote email is opened, select “Forward” (so that the pdf is still attached), select the follow-up email template and click the “Replace Email Contents” box and hit Select.Problem - The follow-up email is sometimes created, but more often it does not populate. There are no exceptions noted in the trace.We can’t figure out why the template isn’t working or another way to send the follow-up which includes the pdf.Below is the template we are using.Any help or suggestions would be appreciated. Thanks!

I have a need that I think is quite simple but I can't figure out how to do it.I want to have a line chart that shows the total count of open cases(CR3060PL) over a period (eg: the last 30 days).So X = dates and Y = total count of open case at the given dateI want to be able to see if there is a trend.Can someone show me how to do it?Thanks

How to create Generic Inquiry to display information from report generated using Report Writer?

I am trying to build a GI that has an actual percentage margin (Sales-Costs/Sales), instead of an average. This report needs to be aggregated by day (to show the actual margin on a dashboard that is updated every time the page is refreshed)What the query does is if the AR transaction is not released, it will pull in the costs from the SO table to work out the margin.The GI currently looks at the ARTran and SOLine tables I can easily get the net sales and the costs , and can work out a margin based on actual costs from the ARtran table, however I cannot seem to get this to work with unreleased AR transactions that need to pull in costs from the SO table. Any ideas?I have tried this formula =(IIF([ARTran.TranAmt]  >  abs([ARTran.Cost]), ([ARTran.TranAmt]) * IIf( [ARTran.DrCr]='D', -1, 1 ) - (IIf( [ARInvoice.Released]=True, [ARTran.Cost], IIf( [ARTran.DrCr]='D', -1, 1 )*[SOLine.ExtCost])),(([ARTran.TranAmt]) * IIf( [ARTran.DrCr]='D', -1, 1 ) - (IIf( [ARInvoice.Released]=True, [ARTran.C

As part of our integration, we push time activities for the customer from our system into Acumatica. We currently are hitting this error for one specific customer, and are unclear as to how to fix it. Other customers do not run into this, so I’m wondering if it is something to do with the customer’s specific setup? Inserting 'Time Activity' record raised at least one error. Please review the errors. Employee: Employee 'E00001' cannot be found in the system. ProjectID: Project '5360' cannot be found in the system. Please verify whether you have proper access rights to this object. ProjectTaskID: Project Task 'T160LB' cannot be found in the system. I’ll note that we cannot view the “Employee Time Activities” screen on Acumatica with the user we have used to connect Acumatica to our application. Also, I’ve confirmed that the Employee ID, Project ID and Project Task ID all exist in Acumatica.

After running the Full Resynchronization for Salesforce Integration for Contacts. I have not been able to view the Import or Export Scenarios. Upon selecting the scenario, it returns this error: An item with the same key has already been added. I have some customizations but none that touch the Contacts screen, however I have tried to unpublish them, same issue, and publish them with cleanup still same issue. Here is the trace log that goes with it.  I have tried creating a new Scenario and I get the same error but at the mapping levelHere is the trace that goes with that error Thanks for any guidance!

Hello! I want to import multiple sales orders and create service orders from them. I am unable to create service orders for imported sales orders but when I copy and paste the same sales order, is able to create service order. Below is the import scenario I have created.  

Is there a way to tell if an employee is missing from a rate table either before or after payroll has been processed?

Hello all,I have been facing an error whenever I try to load the PL of Projects it shows the following error: How to resolve this?I have customizations applied.

I am receiving the error “Attempted to divide by zero” on any order from big commerce that comes in with an item discounted to be $0 on the order. How do I get around this and get the order into our system without manually entering it into Acumatica? Thanks

Hi All,I am trying to delete this test tenant, but I am getting this error.What am I doing wrong? 

Fixed assets - depreciation appears as negative when asset still active with positive net value

Sales/Account Managers should be able to freely create opportunities and subsequent project quotes from the mobile app. The are typically at project sites when gathering all the information, so it would be more ideal to do this via mobile than via web on a laptop. Currently, you can create opportunities via mobile app, but functionality is limited. You can’t specify the customer location record, but you can do this on the web. If the sales/account managers were then able to create a quote from mobile, they could be filling out quote details as they estimate--all on-site in the palm of their hand. Extremely efficient. 

I’m working through the process of setting up NEW taskcodes for a project.  At the moment we have existing taskcodes and have 1) budgeted them, 2) created subcontracts, & 3) recorded invoices.Mgmt has now decided they want a difference set of taskcodes.  To do this I’ve:created the new taskcodes, updated the budget to set the old taskcode amount to zero & enter the new taskcode amount created a journal entry to record a reclass from the old code to the new. created change orders to reclass taskcodes from old to new.This processmaintained my GL reporting gave me the project reporting with the new taskcodes in Project Cost Reports and in the Project Cost Budget screen.  This includes budget, Actuals, & open commitments.But, when I look at the resulting subcontracts I still have “actual amounts” recorded against the old taskcodes.  The totals for the subcontract are correct but individual lines for the old taskcodes still have actual amounts. I realize that instead of journal

I am new to this topic and I would like to know what is the easiest way to update the information in this column. I have followed some tutorials but in the end I only get this error  

Looking for a customization on attaching files to Purchase Order Receipts. When we enter Receipts for our Purchase Orders, looking to see if there is a customization that will automatically match up the packing list with the receipts?

I’m working on a GI that will have show in a line or partial line on a sales order is allcated.  We use the Product Configurator so if we have a order with 10 configured products on it and one of the 1 is allocated the report will show a line for the one that is allocated and separate line for the 9 that are not.   i can’t see to find the table name for the “Line Details” table on the SOLine that shows if a item is allocated or not and if that is the right table.I’m currently using the SOLineSplilt and getting the duplicates.   Below are the Relations that i currently have but i have changed each one to no avail. any help would be much apricated.Our Production Team uses this report to keep track of what they have and have not build and sent to shipping.  Shipping allocates the Non Configured Products and the Production Order auto allocates them as they are completed on the Prod. Ord.   either way they drop off the Production list to build. 

Our client has a specific requirement to set the Shipping Address to the Branch Address for Purchase Orders that are of the Type = Project Drop Ship.  Currently, users are manually overriding the Ship To Address for these types of Orders and they have asked us to code it such that if the type of the Purchase Order is Project Drop Ship, then to set the Ship To Address equal to the Branch Address from the OTHER tab of the PO.  The following code does what we need it do; however, upon clicking save an error is generated.  The error is:Error: Inserting ‘PO Shipping Address’ record raised at least one error.  Please review the errors.  Error: ‘RevisionID’ cannot be empty.The following code does what it needs to do, but for the error when saving:protected void POOrder_ProjectID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler){  if(InvokeBaseHandler != null)    InvokeBaseHandler(cache, e);  var row = (POOrder)e.Row;  var po_branchID = row.BranchID;  var

The Versioned selection box still exists on the Wiki Properties tab, but the History tab and it’s functionality no longer appear and when I search the Acu help articles, I can see the relevant help articles exist is v2023R1 but not in v2023R2.  We’re currently upgrading to 2024R1 and this is functionality I use regularly.  Is it entirely gone, or been moved to some other feature?  I can’t find anything related in the release notes.  Perhaps I’m just missing something? the help articles available in v2023R1 and earlier  The history tab of a wiki article and the actions available on it 

Looking to set up an inventory count in one of warehouses where:Count A - Certain Item Classes are counted in Full (every month) This one is easy - choose warehouse & by Item Class and choose the applicable item classes for full count. Count B - All remaining items are included in the population of a random spot count of 20 items (every month). For Count B - I’m looking for the easiest way to set it up so the specified item classes from count A are not included in Count B population. We have >25,000 skus so hoping to avoid select the items one by one.  

Hi I am trying to update the Item attribute for a stock item and it is not ediable.The attribute category belongs to “ Variant” and not a child item. Any Suggestions @KarthikGajendran 

If alternate IDs with the Global and Vendor part number types were specified on the Cross-Reference tab on the Stock Items (IN202500) form for a stock item and a purchase order was created for a sales order with this item, the system inserted the global alternate ID instead of the vendor part number in the Alternate ID column on the Details tab of the Purchase Orders (PO301000) form for the item Fixed in 22R1 Update 10 Build 22.110.0018.