Discussion Forums

When viewing a Blanket Order in the Acumatica UI, a tab is displayed which lists the children of that blanket order. Is there any way to fetch this list of orders using the REST API?Thank you.

Good day, I have a client that has a employee on vacation, with the delegation to a other employee from 9/27/24 to 10/12/24, so right now, the reassignation should be working the rule has the checkbox turned on to allow reassignation of Approvalas,. and instead of Employees, we have Workgroup to be the approver, the employee on vacation belogs to that workgroup, but the system is not allowing us to reassing the approval on the “Reassign Delegated Activities” screen (EP503020). if you have a Employee as the approver on the rule, the system reassings everything automatically with no issues, but not with a workgroup. As anybody find a solution how to reassing the approvals of a workgroup when they are out?

Hello Community!!,Using SalesDemo, I am trying to add/update One Line item in Appointment Details with ActualQty, having Line type as "Non-Stock Item" through Postman PUT call using the “Appointment” EndPoint. Add Scenario: If the ActualQty is not included in the JSON request or if added as null then ActualQty is saving as 1.00 by default. But when I try to insert any value for ActualQty field I am getting an error as "exceptionMessage": "An error occurred during processing of the field Qty: Specified cast is not valid..".Update scenario: If the ActualQty is not incuded in the JSON request then the other fields are updating with out any error. If the ActualQty value is null then getting "error": "'BaseEffTranQty' cannot be empty.; 'BaseEffTranQty' cannot be empty.; BaseEffTranQty: 'BaseEffTranQty' cannot be empty.". Tried including the BaseEffTranQty but no fields are udpating. If the AcutalQty has any value such as 2, 2.0, 2.000000 or “2” then getting an "exceptionMessage": "An error

Does anyone have a way to sort the Substantiated Billing - Consolidated Report by cost code? 

Our Acumatica instance is 23 R1 build 120 and I am trying to override the default URL for Shopify Products using the Custom URL field in the Ecommerce tab on stock items.  When I make changes to this field, the prepare data screen picks them up but after I process data, the product’s URL handle under search engine listing remains unchanged.  Is there something additional that has to be done to make this work?  I don’t think I’m misunderstanding the purpose of this field, given that if I try to include /products/ in the front of the Custom URL value, the system automatically removes /products and leaves a leading slash followed by my custom value.

Situation: sales order was changed to Credit Hold status when the SO was taken off hold. A user clicked the REMOVE CREDIT HOLD button and the order is now open.It appears there is no way to put that SO back on credit hold. If the order is put back on regular HOLD and then taken off hold. It does not go back through the credit checks, it just opens the SO.Is this how it’s supposed to function?How do I get the order back on credit hold?Thank you!

Hello all,I have setup a successful UPS integration, defined the ship via codes with no costs & just the packages.and the shipping terms so as to calculate the freight price.But still upon creation of the shipment, the freight cost is getting calculated which should not happenHow can I let the system to not calculate the Freight cost?Thanks.

Is there a way to only update the metrics in the Dashboard manually? I want the data to remain the same until I refresh it again at the end of the week, but the once a week refresh isn’t working, (set it to refresh once a week last Friday and it has already refreshed twice today.)

Has anyone encountered a customer request like this, and is it something Acumatica can support? The customer is asking for all invoices from the statement period to be sent attached along with the AR statement. Please share your experience.

Hello all!We recently upgraded to Acumatica 2023 R2 Update 13 (Build 23.213.0015) and have noticed a slight change in the data type of the Currency Rate field located in screens such as Funds Transfers and Bills and Adjustments. At the moment, it appears the Currency Rate is rounding up if we try to manually adjust the SPOT type. This causes a number of issues for us, as some of our accounts that may be labeled USD or CAD will sometimes be transferring EUR, and we need to change the SPOT rate for those specific use cases, which is why we can’t simply set the currency rate and rely on the value that auto fills.The issue arises where, we add a value with 8 decimal places, but the value rounds up to 3 decimal places instead, which creates massive issues for our final RGOL value. Where the field is located Setting the value to an 8 decimal place value Auto rounding after clicking “OK” I’ve checked the SQL table, and it appears the data type for this field is set to Decimal(19, 8), so I ass

Am i wrong why it is not working I would like to include the details of the TIN in my report by retrieving the CustomerMaster.ParentBAccountID and fetching the data for the customer where it matches the Customer.AcctCD. Is this possible?

New community users require moderator approval before they can post or reply. Registrants are strongly encouraged to use their business email when signing up. Please note that approval can take up to 24 hours. If you have an urgent product issue, contact your designated support. If you have a question regarding the approval of your registration, please reach out to christopher.hackett@acumatica.com.

I’m trying to setup a GI that would allow me to update an inventory item’s Default Vendor through mass actions - however, because this is set at the Vendor ID/Location level, I believe I’m having trouble.Neither the Stock Items screen and Vendor Inventory screen allow me to  Is there an entry screen where I can assign the PreferredVendorID & PreferredVendorLocationID as the item default?  If not, is there another way to update an already assigned vendor on the stock item as the default vendor?  

Hi,Our company has many “purchasing contracts” with customers that renew on an annual basis that cover an approved total $ amount. This allows our customers to allocate funds within their annual budgets for us. Over the course of the year, we create orders and reference the above “purchasing contracts”. We generally refer to them as Blanket PO’s.Is there a way for us to utilize the BL order type to create a BL order for the total $ amount, but no specific item or qty???We would then create child orders against this BL that would give us visibility into how much money our customers still need to spend before the order expires. Any help is appreciated. P.S. - We current;y don’t have contract functionality in our system in case that is anyone’s suggestion. 

Hi, is it possible to overlap logo’s in Report Designer.  So I have a large company logo and the client wants the smaller accreditation to sit on top of the Company Logo.  Is this possible? Regards,Laura

I’m in the Report Designer. I have a barcode. How do I integrate the value of the barcode into the barcode as shown below. It doesn’t have to be nested into the code as shown below, underneath is fine too.My issue is that barcodes are variable in length and they completely ignore text alignment, so I can’t center the Item Number (my value) under the barcode. The barcode is always left justified making for some very ugly labels. Thanks!

Hello Community! I am trying to find a way to make the Description field on the GL Batch screen editable once it has been Posted/Released. I followed the instructions from this blog here but not sure what I missed because it isn’t working. Wondering if there is a way you can tell by looking at my screenshot below?https://asiablog.acumatica.com/2021/10/enable-customization-fields-when-document-is-completed.html  

Good day.I am having the strangest thing happening.  I have 7K work centers to update.  I am testing the attached import scenario.  I ran the below together; One was perfect.  The other only partly updated and missed a work center.Attached is the XML.  What could be wrong.  I tried to add a line number; that screwed up everything with updating the wrong Work center.Any thoughts.Thank you.Evan  

I have a Customer with Auto-Apply Payments selected on the Customers screen.I entered a new Invoice and a new Payment into the system, separately.On the Auto Apply Payments screen, I have the Customer's Statement Cycle ID selected.I click Process, but nothing changes on the Invoice or Payments screen (the payment is not applied). After clicking process on Auto Apply Payments, Invoice still shows a balance:And no Invoices were added to the Application History tab on the Payment: 

HI, I have set up allocation and billing rules based on the attached document to process project billing from field service appointments.However, when we run billing from the appointments, the system is not marking stock items as billable. As a result, these stock items are not being billed in the AR invoice when we execute the project billing    I've attached a document on the field service management demo script, which includes the setup process and a detailed transaction process between pages 58 and 95.Can someone please review and let me know why the stock item is not being marked as billable in the project transaction. Thanks.  

HelloAs I commented in other post I get this error while I’m trying to import my file. I don’t know how to fix it. Any idea?Thank you.  

Hello.Back in May, I was having issues getting the 4.1 REST API code to actually be able to log into my Acumatica Instance.Dmitrii provided me with a link to the 5.1.2-beta version and it worked like a charm.  I’ve been coding with it ever since and moving forward.Fast forward to today - I am trying to add code to the library to pass back more detailed error messages from the API, and the place I would normally do that is in the function VerifyResponse that is found in a source file named EntityAPI_Implementation.cs - however this file does not exist in the 5.1.2-beta code I have, so I cannot update it to pass back extended error info.Is there a replacement in the beta version for that function in that file?  

I am attempting to, via import scenario, create template items and create all their matrix items. I need to create hundreds if not thousands of template items. When assigning attributes to Item Classes and then assigning those item classes to the Template, all attributes are set as “Active” for that template item by default when creating the item. I want to set the checkbox in the header of that column to FALSE so that it ideally unchecks all attributes and then allows me to go set the appropriate attributes to TRUE again through import scenario.Attributes from Template ItemHow can I set the header column checkbox to FALSE and thus uncheck all attributes via import scenario. I don’t want to create 100s if not thousands of item classes just to use with the appropriate attributes. Some attributes in an item class don’t apply to all template items so I need to pick and choose which attributes apply to which template items. 

Is there a way to set up a maximum production amount for a single production order?Example:We have a custom seed mix that we make in house. Our mixer can hold up to 450 pounds total. I want to be able to limit a single production order to 450 pounds or less being made.Thanks!

Hello All,I have a very simple list grid with one DAC is assigned to it. The DAC only has one Key Field and it is correctly defined. My data loads correctly without any error. The Row Selected event is fired when initially page is loaded. The problem I am facting is that the RowSelected event is not fired when I chnge row. below is the page.<%@ Page Language="C#" MasterPageFile="~/MasterPages/ListView.master" AutoEventWireup="true" ValidateRequest="false" CodeFile="HC3080DB.aspx.cs" Inherits="Page_HC3080DB" Title="Untitled Page" %><%@ MasterType VirtualPath="~/MasterPages/ListView.master" %><asp:Content ID="cont1" ContentPlaceHolderID="phDS" Runat="Server"> <px:PXDataSource ID="ds" runat="server" Visible="True" Width="100%" TypeName="HCL.Custom.Stockmeister.HCLEPEmployeeTrainingMaint" PrimaryView="EmployeeTraining"> <CallbackCommands> <px:PXDSCallbackCommand Name="Save" CommitChanges="True" /> </CallbackCommands> </px:PXDataSour