Solved

Hi all,I'm hoping someone has hit this before, because I've run out of things to try from the endpoint screen. **What I'm trying to do**Validate a customer location's address through the contract-based REST API instead of clicking **Validate Address** on the Customer Locations screen. SetupAcumatica 25R2 (25.201.0213). I extended the Default endpoint to `KNMCEndPoint / 24.200.001` and added an action under the top-level `CustomerLocation` entity: - Action Name: `ValidateCustomerLocAddress`- Mapped Action: `ValidateAddresses` API CALL:```POST /LocalENV/entity/KNMCEndPoint/24.200.001/CustomerLocation/ValidateCustomerLocAddress``` ```json{  "entity": {    "Customer":   { "value": "AACUSTOMER" },    "LocationID": { "value": "MAIN" }  },  "parameters": {}}``` Response: `204 No Content`. No error, no fault, no `Location` header. And the **Validated** checkbox on the location's address stays unchecked. A follow-up GET confirms `IsValidated` is still false — nothing was persisted. Clicking **V

I have a generic inquiry containing filters and pivot tables When I tried to switch to the modern UI no results were given and an errror message “Object reference not set to instance of object” was displayedI then made a copy of this generic inquiry, published it and tried again to switch to the modern UI (without the additional filters and pivot tables) I still got the same error. The pivot tables on the original generic inquiry are also used on dashboards

Getting an Error at the time of releasing the inventory receipt document.Error Code is like “caused cost to quantity imbalance”

Hello all,Where can I find the format of password of user accounts in Acumatica?

Hi, I want to send an automated daily email of daily receipted stocks from Acumatica. I need them to be broken up between companies/branches and by item class if possible. Business event is what I am thinking, but I’d like to get your thoughts on how you would do it. Any recommendations are welcome 😊

Any idea about this error when creating a Purchase Return from a Purchase Receipt and how do I resolve this? Item is serialized, so I ran Inventory Lot/Serial History and don’t see the item going out of warehouse location. See snippet below with only one transaction happened in that serial number.This is the POR with Line Type ‘Goods for MFG’ but when I tick each line and create a return, line type is ‘Goods for IN’ and unable to change. 

Issue: A Purchase Order (PO) has many items. One item can have multiple Purchase Receipts.For example: Item A is received in 3 receipts: POR1, POR2, and POR3. I created an AP Bill from the POR3 screen. However, when I released the bill, the system matched it with POR1 (the first receipt) instead of POR3.Questions: Is this normal system behavior, or did we make a mistake? How can we make the bill match only with POR3 when we enter an AP Bill from the POR3 screen?

Is it possible to pull this highlighted Stock item Description tab Information into a GI.  

We are having trouble with Native Acumatica, and want to see if there are any options. We receive a lot of items in Sea Containers. Multiple orders are put in to a container shipment when they are all ready to ship.Our typical work flow to place an order is:Place a main order for a container of products. We will call this PO-001. Maybe this PO takes 90 days to prepare for shipment.  During this time, we will add PO’s for smaller items, generally repair parts. So let’s say that during the time it takes to get PO-001 ready, we make PO-002, PO-003, PO-004, and PO-005. Now PO-001 is ready to ship, and most of the other open PO’s (PO-002 through PO-005) are also shipping in this sea container. But sometimes, one or 2 items will not be ready in time to make the shipment, so it will still be left on order for shipping at a later date. Our people need to see an accurate delivery date and tracking info for this shipment, and need to know that all of these shipped in the same container. So right

We are using the Acumatica Shopify Commerce Connector to synchronize item information from Acumatica to Shopify.A template item in Acumatica contains an attribute named TEMPCLOSEO. The attribute value can be either TRUE or FALSE.We want to configure an export entity mapping with the following logic:When TEMPCLOSEO is TRUE, export the value Closeout to Shopify. When TEMPCLOSEO is FALSE, export a blank value.We attempted to use the following formula in the Shopify export entity mapping:=IIf([[TemplateItems -> Attributes.TEMPCLOSEO]] = 'TRUE', 'Closeout', '') Data is syncing fine when the SKU has true value but it is failing false information(field: input.metafields.0.value) Value can't be blank. Acumatica returns this following error:Expected ResultThe export mapping should return:Closeoutwhen the TEMPCLOSEO attribute is set to TRUE.When the attribute is set to FALSE, the export mapping should return a blank value.

The only way I can get the changes to the MUI screen is to modify the files in the development section in VS, then update the MUI files in the project editor and publish the project.I thought I could update the MUI screen by executing this statement in Terminal, but it doesn’t make the changes:If this worked, it would save me hours in testing.  Publishing the entire project takes forever compared to running the command line to build the screen.Also, my popup wasn’t showing the fields.  I published, restarted the app, reset caches, MANY times.  I kept changing the TS and HTML, but the fields were not showing.  Suddenly, they are showing.  I literally spent 5 hours trying things, republishing resetting everything and it didn’t show the fields.  Is there some steps I am not taking after publishing the project to get the MUI code to display properly?  I’ve been losing my mind over this.    

Hi Everyone, I noticed that the Welcome to Acumatica screen  is missing as off last night.  When our users login, this is what we see.  Has anyone else encountered this?  If yes, please share what steps you took to correct this. Thank you, Jelena

i have a client who is using task, item and cost code on their cost budget.  everything has it’s own description (task is filled out on the task tab of the project) however, when i add the cost code to the cost budget, the description inputs the cost code description, not the task description or the item description.  i was wondering if there was a way to change what description defaulted to that (ideally, i would like the inventory description to populate in the field): 

We are almost ready for Go-live and the customer noticed that the description from the change request isn’t carried over to the Change Order. The process:Change request creation 00001 Click on the Create Change Order button to create the Change Order  While looking at the cost budget it’s empty. As seen on the screenshot below: 

We use Sales Order (SO) Invoices for all our Field Service invoices.  Our SO Invoice has its own report design, which is different from that of an AR Invoice.  The invoices for Service Contracts ONLY use the AR Invoice report. Because we have several companies, we cannot modify the AR Invoice report to meet our service company’s specific needs.  I have submitted a case to Acumatica.  We are told that Service Contracts only use AR Invoices.  To use the Sales Order Invoice, a customization is needed.  This makes no sense to us.  We should be able to use our SO Invoices to bill a Service Contract.  We believe this should be an out-of-the-box feature.Does anyone have recommendations for using the SO Invoice for Service Contract Billing?

Is it possible to merge duplicate Vendor accounts into one?

I’ve noticed over the years that a string like .../(W(104))/… can be found in URLS, but I’ve never been able to determine what this indicates.  I can create a link without this section of the URL, however it resolves back with a number when the site comes up.  Can someone help me understand?

Hi,I am creating a new Inventory Item Label with a QR code. This report is intended to generate inventory by warehouse and will be used with the Scan and Count feature in the Acumatica Mobile app.At present, the report is displaying as blank, and I am unsure of the root cause. I would greatly appreciate professional assistance in resolving this issue. Thank you.

Hi Team,When we select InventoryID in Sales Order screen, it should show Popup of InventoryItem “Add Pop-up Notes”. When we create Sales Order via Processing screen, it throws error.How to avoid this popup trigger while creating Sales Order via code? This is the code piece triggering for Popupprotected void _(Events.FieldUpdated<SOLine, SOLine.inventoryID> e, PXFieldUpdated baseHandler){    baseHandler?.Invoke(e.Cache, e.Args);    if (!Base.IsContractBasedAPI)    {        SOLine line = e.Row as SOLine;        if (line?.InventoryID == null) return;        InventoryItem inventory = InventoryItem.PK.Find(Base, line.InventoryID);        if (inventory == null) return;        string note = PXNoteAttribute.GetPopupNote(Base.Caches[typeof(InventoryItem)], inventory);        if (!string.IsNullOrEmpty(note))        {            _inventoryNoteText = note;            _askInventoryNote = true;        }    }} Thank you

How would I run a report to show me the open AP documents for a specific period? Currently the reports are not tying because the AP bills were paid in a future period, so they seem to be omitted from AP Open Documents by Vendor. Our AP Aging report won’t work because it doesn’t seem to handle retainage documents.Any ideas on how to accomplish this? Is it a feature out of the box?

AP Check Form - Anyone already have a template with check in middle and remittances at top and bottom?Please see attachment sampleThanks.John

Wondering how others have dealt with this in the past or if there is an option or way through low code no code options to handle this - when you are shipping in Acumatica there is no requirement to pack the items or pack the shipment in full. This can lead to data and reporting not really making sense especially when things like EDI or other integrations are involved. We would like to ensure that when someone is shipping that everything that was picked on the order gets packed into packages, but there is not currently a way to set this up.It seems like something simple that there should be an option for this already. How have others handled this? 

October 1 begins our fiscal year and all employees have received a raise. Is there a way to import the pay increases to all employees? I have already created a spread sheet with all the data that I believe is needed to import. Most of the earning codes are the same for a majority of employees. I am new to Acumatica but I am trying to learn as much as possible and I do not want to enter one by one.

I’m not sure what to do with Government Reporting this week.Whenever we try to process it through Aatrix it usually works fine. Starting last Friday it is giving us this error message when trying to run the Federal Tax Deposit:Any thoughts on what we are missing here?Thanks!

Hello, My boss is asking for an automated email of our inventory report every week. Currently we use a pivot table set up by our VAR to show our inventory at a quick glance.  however, i cannot automate this as an excel file email so i have to build a report. I’ve got all the data to show, however, each warehouse creates it’s own line. I’ve tried grouping, but that will only pull results for the BBPA location. I looked at possible solutions but adding =Sum to each line didnt work, grouping didn’t work, trying to hide the 0s in the conditions didnt work.  Any ideas on how to combine all of those lines into one single inventory line like the pivot table does?