Discussion Forums

hello all,I have been working on production orders. I have an item that has been received in the qty of 377, and then when I went ahead to create prod orders out of this 377, it shown me out of stock item.Highlighted below.Item ID : 00031381: The first line has the available qty of 272 which is fine, but for the one that is highlighted it shows incorrect release & avail qty. whereas out of 377, 270 has been used in the Prod order no. 1506 so I still have 105 available. But it doesnt show up in the highlighted line.But if I go to manually add up the item in the Material transaction it allows me to add up the figure same as that of required qty. for highlighted prod order.

I cannot seem to find anything on the API that returns currency exchange rates.  Is it possible to get to these?I have come across an answer stating that Acumatica uses https://openexchangerates.org/ internally as the source of exchange rate data, but if we have the exchange rates already it seems superfluous to have to subscribe to another service to get them.

Remove WMSHEADER Table in 2024 R1 - What is the replacement of this table? 

I added some custom columns to SOOrder in a customization project (under Database scripts) and they’ve been created in my database correctly in the SOOrder table.  I’m also able to view/modify these columns in the PXCachExtension with my C# code.  However, when I run a SQL query in SOOrder on these new columns, they always return as NULL.Question: How do I save updates to these new fields in the database?I’ve tried the following without luck:                    Base.Document.Update(Base.Document.Current);                    Base.Document.Cache.Update(Base.Document.Current); 

HiIs there anyone know how to add in a new Tax ID?Currently , we need one more new Tax ID , not sure where can we add in ? Is there any effect that we add in one more Tax ID?Thank you 

Hello! We are just starting to use the Advance SO Invoices for our Sales Orders and we are coming to an impasse when we go to release these SO Invoices. Receiving the error message “Object reference not set to an instance of an object” and we are unsure how to proceed.When I view the trace I see this error:Does anyone know how to get around this error?Thank you!

I am using multi base currency and it enforce restrict visibility to specific companies or group of companies, Is it possible to create a supplier or customer without this restriction being enforced. I extended the companies on the tenant as customer and vendors and the system does not force this restrict visibility rather it create a tab for balances with multiple currencies. Standard Vendor Extended Company as Vendor, the restrict visibility no longer has the asterisk  

Hello,could someone explain what is the difference between the sales quote created in screen CR304500 and the sales quote created in screen SO301000? When I should use which screen?

Hi AllIs there a way to configure Multifactor Authentication for Acumatica contacts on the Acumatica Portal?

Hi all, We are implementing the manufacturing module in about 3 weeks and had a scenario come up that I’m unsure of the best way to handle.  We use production orders for sampling new products.  We need to be able to log material and labor transactions against the production order, but we do not want the parts to stock into inventory.  I tried to adjust some settings but haven’t found anything that lets us do this.  Any ideas?  Thanks!

Hello - We recently upgraded to 24R1 and now seem to be experiencing issues when trying to import AR Invoices with Doc Descriptions exceeding 512 characters. I started looking into how to create a customization to expand this, but noticed it says the limit should be 4000. When I test importing via postman or manually entering myself, it continues to stop at 512. Does anyone know why this might be and how I can go about expanding?

Hi all, How do I access the link I posted to acumatica without having an acumatica account to log in. I have successfully attached the link to the email, but I don't know how to let people outside access itThanks in advanced

Hi Team, Can some help in showing some examples how to modify a Production ticket that once printed will also print a PDF file attached to the releviant BOM ie Part Drawing!I understand the BOM Schema needs to be included in the Production Ticket Form, but how to link it to the BOM.

Our client has SSO installed, and have more than 30 users with the SSO, but seems that 2 users are not receiving any emails, there is an error for Full mail box, but this is not the case for the 2 users that are having the issue. Acumatica emails are being sent and processed with no issues, our client reviewed the users and nothing seems to be out of order with those users. If someone has had a similar issue and was able to solved it let us know, I appreciate the help.Error: ‎554 5.2.2 mailbox full; STOREDRV.Deliver.Exception:QuotaExceededException.MapiExceptionNamedPropsQuotaExceeded; Failed to process message due to a permanent exception with message [BeginDiagnosticData]Cannot get ID from name.

Hi! I saw this post on how to enable modern UI for 2023 R1: New UI in Acumatica 2023 R1 (23.100.0138) • Everything Else • Acumatica User Group ForumsIs this how to enable modern UI in 2024 R2 as well? If not, what is the correct way to enable the modern UI?Thanks!

Hi all,We have some timing issues in some European countries where we need to report VAT and Acumatica is using the Invoice date to make the reports, so we end up “sending” some late invoices to the next period. We are wondering if we can configure Acumatica to prepare Tax Reports based on the Invoice Posting Period instead of Doc Date?Thank you,a.

Hello, I've added two push notification of type WebhooksThe first One working perfectly and it's set to read data from the Genric Inquiry  the push notification is firing and the webhook URL receive response without issues.The other one whch read inventory updates and available qty is the one that we have a problem with and can't make it work,  this one was created also based on the generic inquiry this one is set to push notification to the same end point as the first one I see that the generic inqury working well and grap data, but the push notifications is not firing. The push notification has beened added and configured the same way as the first one but not sure why the second one doesn't work, is there any reason on why this happening Best regards

I have developed a custom report which display data related to CashAccount. I need to sort the Cash Account according to the alphabetical order of the [CashAccount.Descr] field. But it is do not works as expected. I have added a grouping according to the CashAccountID. I tried changing the sorting field with few other data fields. But nothing works as expected

Has anyone had any luck printing a label per package on the Acumatica shipments screen? Looking to print a custom shipping label per package. 

Hi I want to modify the Parent Lot/ Serial Nbr to only show selector records where the value is greater than 0 in remaining quantity.I’ve tried to modify the selector using this approach below and it does not filter as expected.[PXSelector( typeof(Search<INLotSerialStatus.lotSerialNbr, Where<INLotSerialStatus.qtyOnHand, Greater<decimal0>>>),Any help would be appreciated, thank you!

I need to restrict purchase orders to only those a user created or owns. I’ve put conditions on PO primary list and restricted access to certain buttons on the PO entry screen. This works, but there are several loopholes. One is that user can still use search bar to find any PO. Is there a way to restrict access to search for certain user roles?Thanks in advance for input. 

Hi everyone,We’re experiencing an issue with one of our GIs where we need to filter for empty lines in a specific column. We’re using the ‘Is Empty?’ filter, but it doesn’t seem to display all the empty lines.For context, we know there should be 10+ empty lines, but only 1 line is being shown.Has anyone else encountered this issue? If so, do you have any suggestions or fixes?

Hi, we are trying to delete a Tax Zone but encountering an error that it is related to a tax transaction that I cannot seem to find. Is there a way to deactivate it instead? Thank you so much in advance. tax 

How do we add or remove required fields? For example, in the New Customer record the following are required fields denoted by an asterisk: Customer IDCustomer StatusCustomer Class Account Name CountryAs we only do buisness in the United States, I would like to remove the requirment for this field. Or default it to United States. For Sales Quotes, we would like to make the Expiration Date a required field.  

There will be no "Ask a Question, Get an Answer" for this week. We will try and get a catchup one done next Friday. Please check out last weeks’ to see if there are any remaining to help with. Ask a Question, Get an Answer - December 9 - December 13, 2024 - Can use some extra help this week! Thank you everyone for your efforts and Happy Holidays!