We can successfully import the updated health insurance rates using an import scenario; however, we have to manually set the previous deduction to inactivate it / set the ending date before importing or the import fails. We tried to create a separate import scenario to update existing deductions, but I am not seeing how to differentiate between creating a new deduction vs updating the existing. SQL is so straight forward in comparison. Update … will update the record. Insert will create a new record. Not seeing comparable in the import scenario. Any suggestions?
I have published Generic Inquiry that functions as designed. All is well except there is a request to be able to print the results. Can you make a generic inquiry printable without first exporting to EXCEL? Thanks!
Hi Everyone, Hope you are doing well. I am new to Acumatica. I have a few questions regarding the data validation, hoping someone can help me out on this. When I tried to test creating / updating records through API service, I noticed a few issues. For instance:When creating an invoice with an invalid type value in the payload. The application doesn’t response with error message, like “the invoice type is wrong”. Instead, an invoice with bad data is created. See screenshot #1. Once it happened, all other request of updating / creating invoice will fail. When creating an invoice with invalid details. For instance, if I create an invoice record with two items in “Details”, The first item has an invalid inventory id, then the second item has the valid inventory id. Acumatica will accept with this request, then create an invoice. But the details in the created invoice, the first item will have empty value in the “Inventory ID” value. When updating a closed invoice through API. Ac
Hi Team, Can we upload bank statements in PDF format to import bank transactions?
Hi,I have recently increased the character limit of the description fields to 4000for the Tasks, Revenue and Cost Budget tabs in the Projects screen, and I am wanting to replicate this in the report that pulls in these description fields.Is it possible to increase the amount of characters that a field can hold in the report designer? Or is it set to a maximum that isn’t able to be changed?Kind regards,Andrew
Acumatica will only allow items from the same warehouse on a shipment.I’m trying to understand the logic for why this would be limited.I have customers with multiple warehouses in the same building and items on a sales order could come from any of those warehouses. They would like to be able to have all the items on one shipment record.Can anyone help me out?Thanks!
Hello Community,My name is Rohit and I am from Hamilton, Canada. I just started as Dev Support engineer @ Acumatica.I come from technical background with five years of experience supporting ERP for a mid-sized manufacturer. At my past job, I developed custom screens, report, dashboard, processes etc.I need to learn a lot in next few months. I hope this awesome community wouldn’t mind silly questions from a newbie. I hope to add some value to the community as I learn more.Excited to be here.Rohit
Good dayI have a scenario where I created one sales order with multiple lines and the stock is coming from multiple warehouse as per the screenshot below, where I am picking stock from 3 different warehouse I have seen that Acumatica forces me to create a single shipment per warehouse, thus three shipments from one order , creating too many documents I do not need, yet I just need one shipment and a single shipment CONFIRMATION (MY Delivery note).Is it possible to create one shipment from a sales order with multiple line items from different warehouses? How best can I manage such a situation?
HelloIs it possible to use Related Items in the same way that you can on the Sales Order screen SO301000 with the Sales Quote screen CR304500.ThanksMatt
Hi team, Our logistics team has a use case to re-route/change the destination warehouse of our imported inventory. Is there a way to update the destination of a TR or let any location receive a TR? Our current solution would be an additional 1 step transfer to adjust planned to final destination however this would cause issues with recording landed cost as well as being additional admin. Appreciate the help!
Hi Experts,One of our customers looking for creating customers from the mobile App.I would appreciate your response in this case. Thank you.
How can I see non-replenishment items on sales orders that I need to order? Here is my issue. We often have a salesperson put an item on a sales order, and we have zero of that item in stock (and zero on order). The item does not have a replenishment set for it. AND the sales person does not mark the item for “Purchase Order”. How can I prepare a Puchase Order and have this item show up on the Purchase Order? Or how can I “see” this item so i know to put it on a purchase order? Thank you in advance for any help you can give to me.
In the SOShipLine table, there is a field used on the Shipments screen called OrigOrderQty. I want to use that field on a pick-list report that can be printed for each shipment. When I try to add this field, it’s not available. The SOShipLine DAC shows the field as being available, but it’s not found on the table in REPORT DESIGNER. Why is that?
Hi, I have developed a custom screen, it’s working fine in my development instance. Then we published it in a UAT instance for testing and when we checked , it was working previously but now the screen is not visible in the workspace we added. Even the admin has the right to access this custom screen but the screen is not there. So we unpublished the customization project and removed it from the instance. Then we published again the same project package and this time the screen is not available in the project as well. we unpublished it and published again, still the screen id is empty as below.customization project in the uat instancedoes someone have an idea on this issue?Thank you in advance.
Get Started HERE and be sure toIntroduce Yourself
Acumatica User Groups
Educational Resources
What you may have missed in the Acumatica Community! February, 2023
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.