Discussion Forums

Hello,I’ve created a custom endpoint in Acumatica, but I’m encountering issues when trying to retrieve or manage the approval mapping details, specifically the approval steps and associated rules. Despite setting up the custom endpoint, I am unable to retrieve the step and rule details.When I perform a GET request to the Approval Maps (EP205015) screen, I receive the following response:{        "id": "3bdd9e49-3ae5-ef11-8220-a0481c0a4b38",        "rowNumber": 2,        "note": {            "value": ""        },        "ApprovalMap": {            "value": 3        },        "Conditions": [],        "EntityType": {            "value": "Purchase Orders"        },        "MapEntityType": {            "value": "PX.Objects.PO.POOrder"        },        "MapId": {            "value": 3        },        "MapName": {            "value": "Purchase order"        },        "Name": {            "value": "Purchase order"        },        "Steps": [],        "custom": {},        "_links": {           

Hi Everyone,Can anyone help me provide the Json request to insert the Payment Instructions details in the Vendors → Default Payment Settings → Payment Instruction details?  

Hi, A client has several AP invoices that need to be reversed. Reversing a bill to create a debit adjustment record works fine and links the original document to the new debit record however when clicking apply on the debit adjustment record, the resulting payment record only shows the debit adjustment line to apply by default. Is there any way that the corresponding invoice get added as a line automatically as well via some sort of setup? Regards, Andrew

Hello - I would like to import some forecasting data into custom DAC’s using the API. I’ve worked with parent/child data before and imported via the API but I’m finding this situation difficult because the forecasting data consists of 3 levels of data. I’m not sure how to configure the graph or the API to get this working. Here is a cut down version of the DAC’s, in the code I’ve included PXParent and PXDBDefault to link the DACs.DAC 1 - ForecastHeaderForecastNbr (key)CustomerDAC 2 - ForecastLineForecastNbr (key)LineNbr (key)ProductCodeDAC 3 - ForecastScheduleForecastNbr  (key)LineNbr  (key)ScheduleNbr  (key)ForecastDateForecastQty With this type of DAC structure I would like to submit json in the following structure.{ "ForecastNbr": {"value": 1}, "Customer": {"value": "Customer001"}, "ForecastLine": [ { "LineNbr": {"value": "1"}, "ProductCode": {"value": "Prod001"}, "ForecastSchedule": [ { "ScheduleNbr": {"value": "1"}, "ForecastDate": {"value": "2025050

How to get Check and payment screen in Type dropdown value rest api endpoint .i want to get all doctype in check and payment which return doctype array.  

Hello Everyone, We are trying to  Extended DAC Fields in the Sales Quotes header section classic to Modern UI .DAC has 4 extended fields need to display it in the modern UI Sales order screen.  tried with below code, Unable to see fields in Modern UI, below screenshot red marked field need to display it in the modern UI Sales Quotes screen header section.classic UI screen shot tried with below HTML Code but when switched to Modern UI , cannot see these fields in UI 

Hi everyone,I’d like to ask if Acumatica has a subaccount mechanism similar to other ERP software (as shown in the attached image from NetSuite).In this structure, users are not allowed to post transactions directly to the parent account, and reports querying the parent account will automatically sum the data from its subaccounts.Does Acumatica support this functionality, and if so, how can it be configured?Thanks in advance!

When we receive bills from our vendors wiith fees such as shipping and handling on the bill itself and we are paying our vendor (not a trucking service) for those fees. I want to be able to link those fees to the items on that bill specifically. Does that mean I have to have all my vendors selected as “Landed Cost Vendors” as well?Scenario 2 - we pay royalties on items to vendors and I want that fee to be reflected in the cost of goods for that 1 singular item (not all of the items on that PO) Example:Invoice from vendor:Item A - Qty Purchased 5 - Unit Cost $2 - Extended Cost $10Royalties Paid for Item A - $0.10 per unit - Extended Cost $0.50Item B - Qty Purchased 5 - Unit Cost $5 - Extended Cost $25Total Owed: $35.50 BUT I want the stock item to reflect that it’s last cost is actually $2.10 and not $2From my understanding if I entered the royalties as a landed cost that $0.50 would be allocated to all of the items on purchase order?

I have a client that would like to view all of their fixed assets and their calculated depreciation for the next 12 months in a single report. I have edited a copy of the Fixed Asset Balance report (FA630000) and I made a custom report (FA63001D) to use as a subreport that will list the financial period, calculated depreciation, and YTD calculated deprecation.  The subreport takes 2 parameters: [FixedAsset.AssetCD] and [FABookBalance.BookID]. Passing the BookID works fine but for some reason it doesn’t like how the AssetCD is passed to the subreport. If I hardcode a value for it like 1000-001, it works but I want it to run the subreport for each asset in the main report. I’ve also tried basing the subreport on [FixedAsset.AssetID] but this gives the same result. The stack trace only gives this for a SQL message:  @@DBTS, IDENT_CURRENT('WatchDog') OPTION (OPTIMIZE FOR UNKNOWN)/* */  

Hi all,I have a local instance set up for training (Build 24.112.0026), and I am seeing the following message on the Transactions and Profiles tab after performing a Universal Search:The search by a phrase or a list of keywords might not work because the Full-Text Search feature is not enabled. Contact an administrative user to enable the feature.I have run ‘Process All’ on the ‘Rebuild Full-Text Entity Index’ screen, and I have also tried the ‘Restart Full-Text Search’ option, but I am still seeing the warning.Anyone seen this before or know how to deal with it?

I am trying to add the Unit Cost, Average Cost, and a custom field Kit Unit Cost to the Sales Order Details container in the mobile app. Here is my code to do this:update screen SO301000 {  update container "Details" {    add layout "LineCostRow" {      displayName = "LineCostRow"      layout = "Inline"      add field "UnitCost"      add field "KitUnitCost"      add field "AverageCost"      placeBefore group "LinePriceGroup"    }  }}This only added my custom field Kit Unit Cost (Shown in image below): I tried simplifying my code to this:update screen SO301000 { update container "Details" { add field "UnitCost" add field "KitUnitCost" add field "AverageCost" }}And the only field displayed is my custom field as well, just at the bottom of the container. I’ve confirmed the field names using the WSDL Schema as shown in image below:Any suggestions on how to get either Average Cost or Unit Cost to show up on the details tab of the Sales Order? Am I missing something? Any help wo

HiThe aim of this topic is to identify how to add invoices with different customers to "Documents to Apply" tabThe result which I am trying to achieve look like this The Customer of the Payment is ABCVENTURE and the customers of the invoice which I added to the table are AVCSTDUDIOS and ABCVENTUREHowever, in another acumatica I can’t add invoices with different customers, for example Here Acumatica allows to add only one invoice, because only one have corresponding customerHow to add invoices with different customers ?  

Hi All,I have a GI where I am pulling the total quantity required for Materials in multiple production orders.The GI is grouped by AMProdMatl.InventoryID and the TotalQtyRequired has the aggregated function: SUM. Then I have the INSiteStatus.QtyOnHand which I have the aggregated function: AVG so that I see the actual On hand quantity and it does not technically get grouped. What I would also like to have is an expression of =IIf( ([INSiteStatus.QtyOnHand] - [AMProdMatl.TotalQtyRequired])<0, [INSiteStatus.QtyOnHand] - [AMProdMatl.TotalQtyRequired], null) Meaning if we are short QOH for what is totally required, it will show the difference. Or else its blank. For some reason I cannot get this Expression to display correctly. I am assuming it is because of the Grouping and maybe aggregated functions. Is there some way I need to do something to choose the aggregated function like this:=(AVG[INSiteStatus.QtyOnHand]) - (SUM[AMProdMatl.TotalQtyRequired])   ? I have attached my GI, a lot of

Stock item has demand and shows up in Inventory planning display.Source accurately shows as “Manufacturing”.It has an active BOM.I select the line and click the action of “Manufacture”.It looks like it is working, and the message comes up “The operation has completed”.However, the line remains in the inventory planning display grid, and not production order is created.Any thoughts why the production order is not created?Thanks!

Hello all,We are running into a potential bug with the PaceJet carrier integration. We recently updated to 24R2 in an attempt to have the following workflow without customization:Create a Sales Order with PaceJet as the Carrier for shipping.  Create a Shipment for the Sales Order from the Process Orders screen. Use the Pick, Pack and Ship screen to handle picking and, once completed, confirm the shipment. Pack the shipment in PaceJet manually. Update the Acumatica Shipment from the Process Shipments screen.The issue we encounter is that PaceJet does not receive shipment information unless a shipment has at least one package added to it before shipment confirmation in Acumatica. We have the Carrier configured with the Usage Scenario of ‘Manual Packing and Shipping in Pacejet’, which appears to mean that all packing will be done in PaceJet so the Acumatica shipment will receive all of the box information externally. Yet when a shipment without any packages is confirmed, the PaceJet Statu

Hi all, I have a prospect who uses Exaktime for time reporting and imports that data via AccountLynx into ADP for payroll, he says this “connection is unreliable.” Has anyone experienced issues with data import from Exaktime to Acumatica? Any help/feedback is greatly appreciated, thanks in advance!

Hi Guys,I have not built an import scenario before.  I need to create a scenario for importing credit card payments into our system so that we dont have to have someone key in all of the credit card payments manually.Can someone suggest where I might find good information on how to create an import scenario from scratch to accomplish this as the canned one seems to have fields in it that do not exist, so I need to modify it or create a new one.   As always, your thoughts would be greatly appreciated.

I'm currently working on SDK tests and need to interact with various Dashboards. The SDK README file provides instructions specifically for Dashboard DB000038, which is functioning correctly on my end. However, I’m unable to access any of the other Dashboards.My question is: do we need to generate wrappers for the other Dashboards? If so, what is the correct process for doing this, as the Class Generator does not generate them? Alternatively, if wrapper generation isn't required, how should I access these Dashboards?Thank you!

Hi, We are trying to create an import scenario to mimic pushing the ADD INVOICE button on RC order types. We are trying to select a certain item from a certain AR Invoice. The issue we are having is trying to select or check the Selected box on the Add Invoice Details pop-up. The pop up box is looking for the Add & Close button but that is not available as a dialog answer selection. Here is an image of the Import scenario. It is also attached.   

I created a Dashboard. But I get this error in KPI Widget. Any idea of this .The GI Works Fine BTW.  

Hi Team, When putting a bill/adjustment  i am specifying my tax catagory, but its just defaulting to the default tax cat set on the tax zone id on the vendor.  No matter what i do.if i set the vendor tax zone id’s default taxcat  to nothing, i get no taxcat on the bill lines.Working with overheads for now, with no inv code on lines!  (PO is fine because you select tax cat on the line items in the PO.)ive tried adding these to the header also;        "IsTaxValid" => [ "value" => false],       "TaxZoneID" => [ "value" => "MYWANTED ZONE ID"],confirmed my tax catagories exist in the tax zone used...and my detail lines as follows;"InventoryID" => ["value" => null]"LineType" => ["value" => "MiscCharge"]    - was told to add this by GPT, no effect"UOM" => ["value" => "EA"],   - UOM mandatory for tax apparently"TaxAmount" => ["value" => number_format((float) $InvoiceLine['TaxItemAmount'],5,".","")]   - tried with or without this"TaxCatagory" => ["value" =

Hello - Looking to see if anyone has an AP Aged Period Sensitive as a Generic Inquiry?

We have a number of COD customers, this means that they have payment terms stating 0 days (nothing to do with their actual payment method).  Essentially we want to create an invoice for them (showing their details) that must be paid instantly.  However, any invoice immediately goes onto credit hold, due to their credit verification being days past due.  What is the best way to manage this, that ensures:Any invoice becomes due immediately No credit hold needs to be released when creating the invoice

I was making some changes to the Project Issue report and now it is completely inaccessible. Usually if there is an issue I can go back to a previous version, but the system isn’t even allowing access to the screen where I can select an inactive version. When I click on Project Issue Form under Project Management/Reports, I get the “We’re sorry an error has occurred...” message. When I click on show trace it tells me the error is 'Element' is an invalid XmlNodeType.I also tried opening the report directly from report designer and receive an error message there stating “The designer loader did not provide a root component but has not indicated why.”How do I fix this? Any suggestions would be appreciated.Thank you! 

Hello Guys, I would like to add the proforma invoice type to this drop down. Hope you can help me :)