Discussion Forums

When looking at the MRP display, there is an item that is on there for a base qty of 5,000. I have a few questions in regards to it. There is a Sales Order for 5,000, however this item has no Safety Stock and no min/max order qty. There is also nothing on the replenishment tab. There is also nothing on the Vendor tab. So, how does Acumatica calculate this? I know it is demand based but if you do not want to carry 5,000 in a warehouse, how do you get this to not show up on the MRP display? Will a Purchase Order clear this?  

We have setup an AWS server per Acumatica’s Instructions, we have our sales Demo installed and working.   Now we are trying to connect velixo to the salesdemo data and recieving this error.  What changes do we need to make to get this working?See Attached picture.

Is there a way to set up a hierarchy of locations within a BoM.Our company makes seed mixes and often times end up with a “partial” bag of a seed mix, for example 5 pounds remaining from a 50 pound bag. We often set this bag aside away from the retail location to use in the next seed mix.Is it possible to set up the BoM to say “use all that is in THIS location first, and then pull from a secondary location if needed”? I would like it to show up on the production ticket if an employee needs to pull product from 2 different locations.

For some sales offers we need to show optional or alternative articles or positions in the sales offer. For example: Position 1: 1x Notebook A  1000 USDPosition 2: 2x Bag for Notebook as option 100 USDPosition 3: 1x Notebook B als alternative for 1500 USD The total amount of the sales offer should be still 1000 USD as position 2 is only an additional option for the customer and position 3 is an alternative for position 1.  I am not sure how to set this up in an sales offer as all 3 positions are priced and the total sum of the offer should be 1000 USD, means the price without the options.  Has anybody the same topic solved ?

Is it possible to automate the printing of production label with help of business event?I’m trying to automate label printing from production order details screen when certain operation status got changed to completed. 

Hi Team,We are getting the below error while upgrading db from 2022r1 - 2023 r1. Any thoughts.MySQL version - 5.7.1System.NotImplementedException: MySqlScripter: There is no conversion from logical data type Udt to MySql physical type   at PX.DbServices.Points.MySql.MySqlScripter.scriptColumnDataType(TableColumn col, String& comment)   at PX.DbServices.Points.MySql.MySqlScripter.getColumnDefinition(TableColumn col, String tableName, DefaultScriptingMethod scriptDefault)   at PX.DbServices.Points.MySql.MySqlScripter.<Script>d__40.MoveNext()   at PX.DbServices.Points.DbmsBase.DefaultExecutor`1.Execute(Func`1 cmdProvider)   at PX.DbServices.Points.DbmsBase.PointDbmsBase.executeCommands(IEnumerable`1 commands, ExecutionContext context, Boolean withoutUsingDb)   at PX.BulkInsert.Installer.PointInstallationExtensions.RunSchemaFirst(PointDbmsBase point, DataSchema schema, ExecutionContext context, Boolean customScript, Int32 timeoutMultiplier)   at PX.BulkInsert.Installer.PointInsta

Hi!Does anyone know the easiest way to check if a bank is compatible with Plaid prior to setting up bank feeds?  Thanks!

Is the Blanket Purchase are calculated for the supply in inventory planning (MRP). I tried to do that but it is not working as expected. Can anyone have idea, will the Blanket purchase order calculated for MRP?

What does this AM Error mean? I am receiving it with trying to release receivables transactions in Acumatica.

Hi, For the AR Aging report, there is an option in the Statement Cycles screen shown below that allows this report to display by Financial Period. Is there a way for this same setup to be used for the AP Aging report? If not, is there another way this can be implemented in the system, or would it need to be done via a customisation. Kind regards,Andrew 

Hi ,I have a requirement to create a generic inquiry to see the projects revised budget (Original + Change Orders) for a given date. It needs to be able to select the date as a parameter and system show the total revised budget for the parameter date. I tried creating a GI but it was not successful. Do you anyone know a table to fetch this data or way of creating a GI to get this results?Thank You,Dulanjana

Good day, we have a client that has suddenly received an error on one of their Generic Inquiries.On the Main GI there is an exclamation mark that states System was not able to get record count and there’s an exclamation mark in the top right corner indicating that the number of records is capped at 50,000On one of the exisitng filters it states: The exact number of records cannot be retrieved. During export to Excel top 1000 transaction records will be exported.See screenshot below.Version 2024R1 PCS on an Azure server  

Hi, I have a user defined field in customer screen (LocationExt.usrExpectedPaymentDate) as below, I need to access this field for a calculation in the sales order entry graph but I get this error.[2024-10-23 04:45:10.957] \App_Code\Caches\SOOrderEntry.cs(159): error CS0246: The type or namespace name 'StandaloneLocationExt' could not be found (are you missing a using directive or an assembly reference?)using System;using System.Collections;using System.Collections.Generic;using System.Diagnostics;using System.Linq;using System.Text;using PX.Common;using PX.Data;using PX.Objects.AP;using PX.Objects.AR;using PX.Objects.CA;using PX.Objects.CM;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.DR;using PX.Objects.EP;using PX.Objects.GL;using PX.Objects.IN;using PX.Objects.PM;using PX.Objects.PO;using PX.Objects.TX;using POLine = PX.Objects.PO.POLine;using POOrder = PX.Objects.PO.POOrder;using PX.CarrierService;using PX.Concurrency;using CRLocation = PX.Objects.CR.Standalone.Location;

Hi, I’m working on a custom validation that requires looking up PO commitments  for a given Branch/ExpenseAcct/ExpenseSub/Fiscal Year. The fiscal year is a custom field that was added as an extension to the POLine DAC. I’ll be converting this query to fetch the sum of unbilled amounts, but for now I’m just trying to get the correct lines to be filtered and I’m getting a crash (stack overflow on FIeldVerifying) when my current BQL query is executed. Is there something I’m missing to be able to connect the POLineExt in this query?public SelectFrom<POLine>.Where<POLine.branchID.IsEqual<@P.AsInt>.And<POLineExt.usrFiscYr.Contains<@P.AsString>>.And<POLine.expenseAcctID.IsEqual<@P.AsInt>>.And<POLine.expenseSubID.IsEqual<@P.AsInt>>>.View POLineView;Thank you!

We have a newly created report that we would like to add to certain customer’s Mailing and Printing setting. When we attempt to add the report it is not found under either Mailing ID or Report ID. What is the process for adding a new report to these setting. 

I’m configuring email accounts for a customer using Google accounts. Is a separate external application required for each email account? Unable able to view already used external email account. 

There are new regulations for determining 1099 filing, etc for 2024. I was wondering how Acumatica is working to accomodate these changes.

We recently migrated from MS Dynamics SL 2018 to Acumatica. There is one feature we used a lot in MSD that is missing in Acumatica: the ability to copy from excel and paste information in any grid like screen.For example, if we had a spreadsheet set up with the same columns, in the same order as the allocation screen, we could copy the information from there and paste into the software.It would be very helpful to not have to upload an invoice allocation or a JE. 

How can I add a column for inactive/active employees on this employee payroll settings screen?

Hi All, I was wondering if there is a way to make part of the Acumatica Wiki (specifically Custom Wiki Articles) public/ expose them to Users having the Link?One Usecase might be linking back to Acumatica Wiki Articles from BigCommerce. Any thoughts/ideas?

 Hello po i just want to ask if i can change the report when the print is clicked ? base on Branch

I have a requirement to include a field for storing the user ID of the person who released the invoice. How can I achieve this? 

When issuing a sales order and the quantity on hand for one part in the BOM is zero.  Where is the notification that there is a parts shortage?   What report shows when you could expect to manufacture the item given purchase order lead time?  Can you go directly to the purchase order screen to order the part?

Client has many small parts they want to be included on the cost calculation but not show up on the traveler.  They would like to control only major parts by having a select few printed on the production ticket.  Any way to limit what is printed?

Hello! I received the following error when trying to open a GI that I have created. I’m assuming this has to do with customization projects? The system recently got upgraded to 2024 R1, and the customization projects are published. Any ideas on where to go for this? Thanks!!