Discussion Forums

Hi Everyone, Will MRP always select the default vendor when creating purchase orders? Or will MRP recommend an alternate vendor (with a shorter lead time) if the preferred vendor’s lead time will not be quick enough for a Production Order/Sales Order.  

I have problem , i try for change value in field in xml make java sciprt, this new screen,why after save this cant save to database ?. async function addQtyku() {    var scale = document.getElementById("ctl00_phF_form_CstPXTextEdit2");    var qty = document.getElementById("ctl00_phG_CstFormView177_CstQtyNbr123");       console.log(qty);    var floatValue = parseFloat(scale.textContent);    qty.val = floatValue.toFixed(2);    qty.value = floatValue.toFixed(2);    qty.setValue(floatValue.toFixed(2));    qty.dispatchEvent(new Event('change'));    console.log(qty);  }Please Help Me SenseThanks

SWK (our solutions provider) has mentioned multiple times that Acumatica has the ability to accomplish split payments on Purchase Orders. Example we receive 10 items into inventory. The total for that PO is $14,010.00We have a vendor where we make payments on that particular PO in 3rds.If we received the inventory in July and our first payment due for that order is August 10th in the amount of $4670.00. Next payment will be September 10th $4,670.00 and August $4,670.00 completing the total payment for that invoice.  How do we accomplish this?

Can someone explain the use of Work Calendars?   

We have LastModifiedDateTime in the database tables in the future. On the application level it’s correct.Application Time  Database field time Database collation is SQL_Latin1_General_CP1_CI_AS. Our location -  US, Central Time

I have a GI titled New Accounts. Sales reps get either a $500.00 bonus if their first initial order with a new customer is >= $5,000.00 - $9999.99, and $1,000.00 if the initial order is > $10,000.00. My IIF statement is as follows:=IIF([ARTran.TranAmt] >= 5000.00, (IIF([ARTran.TranAmt] < 10000.00, 500.00,IIF([ARTran.TranAmt] >= 10000.00), 1000.00))). The Inquiry errors out when being run. I’ve tried using SWITCH also to no avail. Maybe my syntax is not correct? It does Validate with no errors. 

Good day, I have a client that asked me to do a Rejection Notification using email, i have created a Business event with the Trigger New Fiel Value Expense Claim status equal Rejected: Using this template (Note, I have removed the clients email from the FROM field):Make several attempts with differnet fields like Expense Total Greatar than zero (Using Operator AND), and diferent Expense Claims emails TO fields.Be advise that the my client has a Expense Claim Approval Mapping and a Notification setup for that on the Time and Expense Preferences. Any help is highly apprecaited.

I am brand new to Acumatica. I entered in our Trial Balances as of 02/29/2024. Our go live date was 03/01/2024. I did not take into account checks written in Acumatica prior to go live. Also, there were some prior year adjustments, which affected my FY beginning balances. My question is: do I post journal entries as of 3/1/2024 or can I enter trial balances for 3/1/2024? If I enter trial balances for 3/1/2024, will this negate all transactions on 3/1/2024? 

I would like to create a custom field on the Customer form which has a list of options basically stating why the customer’s acccount is in the “OnHold” state. Basically a combo box. Going through the Acumatica Univeristy, it shows you how to create the field but not the difffent types using the Acumatica tools. Most of the later part of the demo uses coding which I am not familiar with. Is this doable just using the gui instead of coding?

Under Customers, after clicked on generate on demand then click on print statement, I tried to click send. But the email template not pop up, pls help:)

I have a simple combo box with a list of entries. To add a new entry, I thought you just added an item to the lists. List (shortened because it’s my full customer list):[PXDBString(50)][PXUIField(DisplayName="Customer")][PXStringList(new string[] { "", "MCU"}, new string[] { "", "MULTIPLE CUST."})] I update it to:[PXDBString(50)][PXUIField(DisplayName="Customer")][PXStringList(new string[] { "", "MCU", ”NXT”}, new string[] { "", "MULTIPLE CUST.", ”NEXT CUSTOMER”})] I publish and nothing changes. To make this a bit weirder, I can also adjust the user-visible text in the list, publish, and nothing will change like shown below.Example:[PXDBString(50)][PXUIField(DisplayName="Customer")][PXStringList(new string[] { "", "MCU"}, new string[] { "", "Some

There are two tables with same colomns. Is there anyway to get the union result using Generic Inquiry?

We are experiencing an issue where we want to round the labour actual hours to the nearest 30 minute interval, however our options are to either change the actual time or change the extended price. If we change the extended price, then the unit price will show on the invoice as something other than our flat unit price rate. For example: a 22 minute job that we want to bill out an hour for…. if we change the extended price to 110 (which is our hourly rate) on the invoice the unit price shows as $200 and change. Ultimately we want to capture the actual hours worked by technicians, but invoice to a minimum of 1 hour, or the nearest 30 minute interval.  

I am trying to add the PO# and PO Creator to the Bills and Adjustmetns GI but am getting duplicate rows.  I have added the APTran table and linked it to APInvoice.  I was hoping to get the PO# from the APTran table but now I am getting duplicate rows.  Any suggestions would be much appreciated!  

Hello I am reconciling my Monthly tax detail report with my GL account 2045 (Sales Tax Payable) and noticed that  5 Invoices with sales tax are not showing on Sales tax payable GL account. All others are showing up.. Any idea why? The invoices are created from appointments if that helps 

The font option and size is very limited in Notification Template.Can we add more? If so, how? 

Wir haben ein Problem in der Produktion mit der Maschinenplanung.wenn ich in einer Ressource AM207000 eine Maschine AM204500 hinterlege und in der Stückliste AM208000 eine Maschineneinheit und Maschinenzeiten eintrage.  Dann einen Produktionsauftrag erstellen nach dem speichern ist dieser zuerst auf unbegrenzte Kapazität eingeplant. Wenn ich jetzt auf “Einplanen” gehe, wird dieser auf unbegrenzte Kapazität eingeplant. In den Maschinenkapazitäten AM406000 werden die Maschinen erst angezeigt, wenn der Produktionsauftrag richtig eingeplant wurde Auch in Maschinen Planung AM000012 werden die Maschinen erst angezeigt, wenn Sie auf begrenzte Kapazität geplant wurde. Wenn ich nun den Auftrag auf “ungeplant” setzte und neu einplane, dann werden die neuen geplanten Zeiten auf die aktuellen einfach aufaddiert jedes mal wen ich den Prozess wiederhole, erhöhen sich die geplanten Blöcke der Maschine. 

Hello - We noticed that we have missing numbers in the sequence for our payments for one of our properties. They are creating automatically from the AP suggest next record, and no one has access to modify that setting. The system skips from reference number 7526 to 7528, skipping two reference numbers. The auditors caught this and are wondering the cause, and have deemed it an actionable issue. As far as I am aware, once a payment is created and a reference number assigned, it cannot be deleted, only voided, which still leaves the reference number. My question is, what possible scenarios could cause this, outside of someone changing the Last Reference Number on the payment method?  

Hi ALL,For example: Inventory Balance report > Click SEND   In the Email Activity screen > FILES > File name is the default.How to rename this default file in Email Activity screen before sending email ? Best Regards,NNT   

This is because the document the user is looking at has been updated and the one they are looking at is not the updated version.  If the user were to refresh after saving (when the business event has changed a field value) then there would be no problem.  Instead, if the user continues to work on the document after saving/updating and they are actually working on an old version of that document which is why they get the error upon saving. What is needed is a way to create a business event that will update the record AND do a refresh of sorts.  One of these ways is to click on CANCEL after clicking on SAVE.  CANCEL will bring into the document the latest updated values. Has anyone found a way to refresh/re-cache the document in a users browser after updating it via import scenario or actions?  I know I can get around the issue by putting it on a schedule or setting a timer to update after the user has terminated working on the document but this is s

We just upgraded to 2023R2 and have issues with the Sales Order screen.When using CREATE SHIPMENT action on the screen, Order Date changes to Requested On date.Anyone also had this issue?  

Has Anyone built a Historical Inventory Valuation report that is handled by Date ranges rather than by period? It seems to not be as simple as changing parameters because much of the field values are handled by period specifically and from what it seems I would need to build a whole new report from scratch. is this the case?

Hi All, Is there a way to format the quantity to exclude the decimal point in the email template?for example instead of 1.00 should be presented as 1.  Appreciate any help on this. Thank you. 

I want to record the bank deposit received from Shopify Payments and move the payments from my clearing account to my regular account. However no payments that used Shopify Payments show up when I go to do a bank deposit 

We have a customer that builds large assemblies.  The welding of these assemblies spans several days.  Since the Bill of Material/Production Order Details only allow up to 23:59 for Run Time, we are entering fractional Run Units to plan hours >= 24:00 per operation. For example, if the planned hours are 250 hrs for a weld operation, we would enter 0.04 Run Units at 10:00 Run Time.However, there are some cases however where we cannot plan the hours accurately due to run units only being 2 decimal precision.  Has anyone else run into this and have another solution?Thanks!LF