Solved

I am getting the following error when trying to Correct a Shipment already confirmed but not invoiced, “The line cannot be deleted because it is linked to a purchase order”. This error is new to the upgrade however I upgraded 2023 R1 and R2  at the same time so not sure which may have caused this.  Items are not marked for PO or anything that makes sense. 

Please assist, I am trying to use the switch formula on the report design, but i get an error when validating the formula. I don't know what i am missing.   

Is there a list somewhere of fixes and/or added functionality going from 2022R2 to 2023R2?

We have recently updated our overhead rates on some of our Work Centers. when applying labor to a production order that was created before the update date the old rate is being used. If the production order was created after the update it is using the new rate. Is this a bug or a feature? if it is a feature is there a way to have the older production order use the new rate? 

Hello Acumatica famDoes anyone know where I can find the article that shows this diagram for how Vendor Prices are handled?I found a reference to the diagram via this forum topic. There’s link to the original Acumatica doc but the link is broken. 

Just want to ask for a customer who is a medium size business in the Food retail market, as to what options you have experienced with external POS systems that integrate to Acumatica.Clients main concern is having flexibility in choice of payment gateway to avoid huge merchant fees on credit card transactions.  Always good to get other consultants opinions on what options are out there, so thanks in advance!

I’m trying to view the details of a PO that’s linked to a SO line. My API call, {{api_base_uri}}/SalesOrder/SO|SO00000051?$expand=Details, works just fine. However, when I try {{api_base_uri}}/SalesOrder/SO|SO00000051?$expand=Details,Details/PurchasingDetails, I get an error stating “the given key was not present in the dictionary”.  I may have been misinformed on this being the correct key, but there’s nothing online covering this topic. Can I please get some help?  Context: I’m trying to create a collection run in Postman that creates an SO + PO, then PO links their lines. I’m on 2023 R1. 

https://{myendpoint}.acumatica.com/entity/{myentity}/v1/SalesOrder/CreatePurchaseOrderI am attempting to invoke the webservice endpoint here (created by me): I have created another request where the mapped action is the createPurchaseOrder@replenishment to attempt that as well: I want to simulate the conditions of this buttonhere is the postman request (screenshot 3)I am unable to find anything anywhere to understand what parameters may be required, and the reponse is downright confusing.The error returns this-     "innerException": {        "message": "An error has occurred.",        "exceptionMessage": "Purchase Order '{0}' created.",The ambition is to process the order below, but i have zero feedback from the api’s themselves on missing required parameters or other oversights.Any assistance would be appreciated,Chris

Good day,I have another strange import scenario issue. Sometimes it works.Do I need to make sure the business account owner matches or if blank I need to add the salesperson. I have used it before and it worked perfectly.  I am trying to update over 8000 locations in the Salesperson tab/ by location.  It is fails or takes for had not update and referred me to the BA Profile. If I do one at time, I don’t get an error.Any suggestion on making work with large customers with lots of locations.Thank you.@Evan G 

Our customer often encounters the following: customer order 900 lotted items (lotted, when received, user entered lot nbr) which they mark for PO, PO is created for 900 items, vendor overships 1000 items, customer agrees to buy all 1000. Because they are lotted, the only way we have been able to accomplish this is to go back and update the quantities of the SO and PO to match the end qty of 1000. Then they do a PO Reciept for the 1000. The problem comes when trying to create a shipment. The shipment only wants to ship what is allocated, which is the original 900. And Line Details on the SO is acting like they need to create another PO to satisfy the extra 100 - I cannot uncheck the Mark for PO box. Screenshots of the entire process below.Original SO for 900 marked for POQuantities on SO and PO changed to 1000. Then…Purchase receipt for 1000SO line details has allocated 900, not 1000Can’t uncheck Mark for PO or check Allocated on the third line. Adding a new line acts the same. They cou

The void and delete buttons are disabled. How can I enable them and trigger the action?Thank you in advance

I am investigating different integration options and wondering if others have utilized Azure Data Factory as their ETL tool or have any insight into this tool.

hi all i have two questions#1 is it possible to add lines to a sale order by hitting the enter key or is it strictly using the plus symbol ?#2 can you release an invoice to sell quantity you didn't enter the receiving yet thanks

Hey folks, does anyone know how to populate this field on the Service Order Print Page?  

Hi,I need to link one of table in RQ613000’ Schema Builder (fig.1) with RQRequest However, those tables doesn’t have any relation in DAC schema browser.and it will revert an error in Report Designer when force to relate each others.Need your advice, to take Request header description on the new modified  RQ613000 report. Thanks in advance.

Hi Team,I tried to create a Fixed Assets but I edited the Default Fixed Asset Clearing Account to Other Income, Since the scenario is I found some asset that need to recognized in my books. Upon Releasing of FA Transactions It gives me this error message:I tried to locate, but this transaction is not project related.Seeking your assistance for this concern.Thank you!

Hello,Order types have a checkbox setting for“Ship Separately” and “Bill Separately”However, I do not see where we can designate this for a customer.We have some customers who want this and some who do not and we need to control it at the customer level.Any thoughts or guidance are appreciated!

Hello, I made a simple rpx like below.I would like to sort the lines by inventoryCD.I don’t know why. is it caused by the relationships below?Or is it that the sorting did not work for group sections? The result is not as expected. It is not sorted by inventoryCD. 

Good morning all. I’ve created an export scenario that pulls data from a GI to generate a positive pay CSV file. The particular requirement right now is to encase the payee name field with a single set of quotes. I have the data provider set to not put quotes on all fields. The field for the payee is set as a string. If I use a Concat command like this: Concat(”’,[Field],’”’) it looks right on the prepare to export screen. Upon downloading the exported result, I am getting data that looks like this:,previous field,”””PayeeName”””Is there another way that I can add the quotes that won’t cause the export to generate three sets?

Hi Acumatica Community Hope everyone is well.I’m sitting with a few Customers where there is Open Receivables Invoices that have a Negative Balance. I need to know if someone dealt with this before and how you resolved it please:Kind RegardsMarilize van Zyl

Hi everyone.I am encountering a layout error with a field that will not display when printing on a Purchase Order. I have created a PO and generated an intercompany Sales Order. under the “others” Tab of that purchase order there is a Related SO nbr which i need to display on my PO layout. In my Report Designer i have selected this field [POOrder.IntercompanySONbr]. It is standard in the Schema and did not need to be brought in via manual connecting.  When i print this report the field is blank and does not show the related SO Nbr.  I have tried refreshing the Schema and refactoring but nothing has seemed to change.Would anyone have an idea to what the issue could be here. 

I was trying to set up the Lot/Serial Numbers Report (IN.61.30.00) to be an automated report (CST.SM.20.50.20) that gets emailed out, but I did not see it under the Screen ID selection.  Or maybe it was Business Events (CST.SM.30.20.50) that I was thinking of that would send out emails.Is this an access thing I need to turn on or it cant be done?

How to edit the Vendor's Last price in the stock item screen. Below is the screenshot attached for your reference.  

Hi, for new sales offers we would like to use the vendor price of the standard vendor as base for our calculations. But the standard sales order screen does not show it. It seems that there is a customization nessary.Did anybody do this already or knows how to do it?CheersLars 

Hey everyone!I have an issue with an Export Scenario. I am trying to Export Sales Orders to Salesforce, and it’s so close to working but I am still struggling with the the Details of the Order.  I currently have a Source Restrction to limit the export to just one order while I’m testing. This one order, has six products on the details. When I Prepare the export however, Acumatica is showing a row for each Detail row. On this order with six products, I can see six prepared rows. The issue is that Salesforce is thinking I’m trying to update just that field, and it’s only displaying the details for the very last row (the last one sent to SFDC)Is there anyway to concatenate all the all the details on one row for export?Attached is my Scenario. I’d really appreciate any help with this, I’ve been stuck on this a few weeks.  One order, six rows. One for each Detail Row.