Solved

Hi guysI need two clarifications on two scenarios 1)What’s the meaning of Plus sign on the row and in that grid “Seq” number is autonumbering some times it’s skipping row’s.2)And when I clicking on next > record on Parent grid it’s not fetching the  2nd record and its Holding  1st record onlyTIA 

Hello,We recently had the unpleasant surprise of discovering that the default behavior of the Sales Prices Inquiry screen and web service has changed between 2020 R1 and 2021 R1.We used to query the API for all sales prices with no EffectiveAsOf date specified, and would get back all prices for all Effective Dates, including expired prices.Now, all API requests default to returning only prices that are EffectiveAsOf the current date.We whipped up an emergency GI to serve this purpose, but I would prefer to use the built in Sales Prices Inquiry, if possible.Is there a way we can get the old behavior back? I have tried API requests with no EffectiveAsOf date, a null EffectiveAsOf date, and an empty string, but it always comes back with today’s date in the response, and prices missing.Thanks in advance for any insight. 

Hi. Is anyone can give me an advice on how to get customer specific pricing out of Acumatica via API?

We would like to change the warning message when changing the class of a customer.  I found the message is defined as a public const in PX.Objects\AR\Descriptor\Messages.cs but we are not on-prem so I’m not sure if it’s possible to change it.Is there a way for us to override this particular message? Thanks for any help, Phil

Good morning, I thought I would reach out to see if anyone is manually processing Amazon payments, and specifically how are you handling the Monthly Reserve withholding and subsequent release in the following month? Since each has an impact on the payment amount how are you applying those to payments?

I was doing some checks on space usage this morning - we are on a SaaS model and have purchased a set amount of storage space.I was wondering what the MLEvent table records?  Just under 10% of our current data storage is used up by this table. 

The auditors would like a printout of the audit history.  We can see the changes through Audit history, but there is no way to send a report to auditors for their files.

Hello. How can I find entity details? I need to update customer but I dont know the correct data structure http://joxi.ru/8238DOvu9NJMpA

Dear all,I’m using acumatica version 21.117.0037. My requirement is to create a custom screen like “Inventory Allocation Details (IN402000). In the grid of that screen, the DAC used to create the data member is “InventoryAllocDetEnqResult” which is a non-existent table. The same [PXFilterable] view (ResultRecords) as in “InventoryAllocDetEnq” BLC was created in custom entry page, but when assigning the view for the data member of custom class, server error occurs.Can anyone help me to create a view for this kind of scenario? 

Hi All,I need to add a filter to the “Approve Time Activities” (EP507010) so that only records where the Approve = true/false show, based on an additional custom checkbox in the filter section called "Approve". I tried to override the filter using “AddFilters” and “AddCommonFilters” methods, but it is not working. Could you please help me on this. Regards,Ramya

when I was releasing the purchase receipt it showing the following error why.ERROR: One or more lines have unassigned Location and/or Lot/Serial Number 

Hello,Implementing Acumatica.We have a scenario as follows:Sales reps can create SO only for a few order types.Customer Service can create SOs for all order types.Is there a way in Acumatica to restrict what SO types are available based on a user id or user role?

How can we access Pick, pack and ship screen I cannot see that in my site.

I was looking at various ways to group customers by local truck route. We have our own fleet of trucks, and various local routes that service different customers. I would like a way to organize customers based on which truck route they belong to.It seems that there is a default Ship Via option for Customer Class, but this doesn’t seem like the best way to organize customers by class (for example, the default credit terms for a customer have nothing to do with which truck route they are on).Maybe there should be a Customer Shipping class added to Acumatica for this purpose? Does anyone have any ideas for how to do what I want without using the Customer Class for this?

Any ideas on where to look first to reconcile end of month inventory to GL balance?

I will gloss over the absurdity, for now, of a “low code/no code” platform requriing this kind of technical solution to do something as simple as redirect the user to an external website by clicking a button:https://asiablog.acumatica.com/2017/08/redirecting-to-external-page-from-button.html I have implemented the solution described in the article, with a button in the Sales Order toolbar to launch a custom item lookup screen (it’s an external webpage that lives outside Acumatica and communicates to Acumatica via webhook).That all works well, except for one thing. If I try to pass any query parameters in the url (standard http get request….i.e Redirect8: http://www.mysite.com?myqueryparam=bob, then for whatever reason the query parameters are all stripped when the page loads. This seems to be happening with some sort of Javascript perhaps (I haven’t traced the source yet), because it’s very clear that the url is requested with query params, but then ends up without them. If I load the

I would like to push an item to a sales order line in a sales order, and have it appear live while the user is in that sales order. Is there a way to do this with push notifications or some other mechanism, where we can tell the program that there has been an update to a sales order line via the REST api, and then reload that part of the screen to show the update? I know this can be done manually by the user with the little refresh button inside the sales order, but ideally I’d like to have a program that is watching for these changes and can reload that part of the page automatically when the new item is added.I feel like with enough hackery I can get this to work, but I’m wondering if there is a straightforward way to do it first.

Hi Guys, i am trying to process a purchase receipt of a purchase order but i keep getting this error below. Can you kindly help? I have followed the Acumatica example found here : https://help-2021r1.acumatica.com/(W(61))/Help?ScreenId=ShowWiki&pageid=81e5ec25-09f7-421a-8f80-01b6b71d38c9 EndPoint: baseURL/entity/Default/18.200.001/PurchaseReceiptRequest{  "VendorID": {"value": "DIG001"},  "Location": {"value": "MAIN"},  "Details": [    {      "POOrderNbr": {"value": "PODP003483"},      "POOrderType": {"value": "Normal"}    }  ]}Error:        "innerException": {            "message": "An error has occurred.",            "exceptionMessage": "PO line number, PO type, and PO number must be filled in for the system to add the purchase order to the details.",

Our customer is looking at dumping StarShip because of the horrible integration. We suggested Easy Post but I need to confirm 2 things that I believe are correct but can’t find the documentation.Can Easy Post do or allow Rate shopping? Last time I configured it was 2 years ago and I forgot. I am pretty sure I read that clients can use their previously negotiated rates through Easy Post. Is that correct?Sorry for the silly questions.Thank you.

We've done enough testing of this (trying to find a work around) that it's pretty clear what is happening is a bug and not a misconfiguration/misunderstanding.  We already have a support ticket open, but I wanted to share out situation in case anyone else might be unknowingly having the same symptoms. Problem appears to occur when the *pay period* crosses the calendar year boundary.  This is because Acumatica breaks it up into two PTO bank records - a 2021 portion and a 2022 portion.  Then the PTO allocated is pro-rated across the payroll week... so in our scenario, with a payroll week from Monday-Sunday, two days are in 2022.  And so our notional 1.54hr PTO weekly accrual gets split into a 2021 portion (1.1hrs) and a 2022 portion (.44hrs).On that first paystub of the year, we see ONLY the .44hrs allocable to 2022 reflected (same in the PTO Details by Employee Report -- though on THAT report you see the 2021 record broken out, it just isn’t summarized correctly.. I can live with that b

I have been asked if it’s possible to add SO Number and Invoice Number columns to the popup Selector for choosing the original transaction when issuing a refund on the Payments and Applications screen. This would make finding the original transaction a lot quicker. Any pointers on how I would go about doing this would be most welcome.See image below:Thanks, Phil

Hi Everyone, I’m trying to understand formulas in GIs. The documentation does not provide guidance on how to use formulas. There is a Report Designer guide that lists each formula and how it’s used (Isnull() on p. 63) but it lacks detail about how data types affect expressions within the formula. If you know of another resource, please share :-) On to Isnull(). Here’s the documentation.I’ve written a simple formula with unexpected results:=Isnull( CStr([ARInvoice.CustomerID]), 'NULL')in row 1, ‘9698’ does not match either of the referenced columns. Why?My ultimate goal is to have this algorithm in a way that Acumatica understands:If CustomerID is null, return ReferenceID, else return CustomerID 

The report exists on my end.  I can see it under Data views. See screenshot.  However, Emily and other users can’t view it anymore.  She used it this morning.  I looked at the security.  I review the GI but nothing pops out on what the issue could be.  I tried moving it to a different module and the moved it back.  Any ideas? 

We had an import scenario that worked in an older version of Acumatica that was used to import large volumes of projects into the system and automatically create and activate the projects.  In the older import scenario we used to force a “False” into the Hold field to trigger the activation.With the upgrade to 2021R1 and the addition of the Workflow Automation, the old import no longer works as the Hold button is gone.I have tried using both of the options below, but I get the same error on both of them.Target Object Field/Action Name Project Summary <Action: Activate Project> (Activate) Project Summary <Action: Activate Project> (Activate@Action)  Error: Object reference no set to an instance of an object.If I deactivate the line in my import scenario, the projects are created just fine, but they are “in planning.”  The error only comes when I try to activate them.  I’ve also tried updating the status field directly in the import scenario but that does nothing.Wha

I have added 35 custom fields to PMCostProjectionLine and the same number of fields to the PMCostProjection to keep Lines summary. Acumatica’s Cost Projection screen itself is pretty slow. The fields I have added doesn’t have any business logic (No code in Graph) but at the DAC level 26 of these fields are using PXFormula to do some calculations and almost all custom fields at the PMCostProjectionLine have SumCalc in their PXFormula to update the PMCostProjection. The problem I have is being slow navigating between Lines. Just clicking on a line and then another line without any change takes couple of seconds.When I trace as there are a lots of break I can’t really figure out what causes the performance issue. I disabled the formulas temporarily it was slightly better but didn’t make a real difference.This fields in the grid have CommitChange = true as I need by changing each value the dependent fields values be refreshed as per the defined formulas.Has anyone experienced this and is a