Solved

I’m creating an Import Scenario for the Purchase Request screen (PO.30.20.00).I’m having difficulty with the ADD PO button (found under the DETAILS tab).  My error message is: “The Add PO button is disabled.”  Here are my steps:  What am I missing?

Hi all, We need to trigger an email notification when our AR dept receives a payment and takes the Sales Order from On Hold status to Open. This lets customer service and shipping know the order is available for shipment. In the past. this worked but what was happening that subsequent changes made to the order (ie, our distribution changed status from open to shipping), the credit hold release email was still going out. So what we did was put PAID in the order description and we want that as the only trigger. Unfortunately, that’s not working the way we have it set currently… any help?(PS -- other notifications are going out just fine so the email end of things appears to be ok...) 

Scenario 1) Holidays are days off for the employees but the time needs to count towards weekly OT.  If the employee had Monday off as a holiday, but then works a 40 week on top of the holiday, the employee would get 8 hours of OT.   

Good day,I am using Email Template to send an ACH notification from Screen AP302000, normal ACH notifiaciton with business Event. My client is requesting to add the Branch of the Bills on the Email template (I manage to add that to the AP642000 report), but cant find the way to add it to the Email body. I am using the following datafields but none has the Branch from the Bill that was paid:Some are from the Payment Branch, is not helping the case. Any recomendation is appreciated. Thank you team. These is the result of an email with those fields for Branch (Test enviroment)The number 5,7 and 8 are the Branch ID from the Payemnt, not the bill(s) paid.

Hi everyone, I’m hoping someone might have a solution or suggestion on the Taxes by Paycheck report. (It probably does not matter, but the Acumatica version is 2023 R1, build 23.103.0013) Working with my client, we built 2 templates utilizing Additional Sorting and Filtering. 1 template lists the detail for all paygroups that start with “EB” correctly. 1 template lists the detail for all paygroups that start with “JT” correctly. The Totals page is identical for both runs; therefore, the totals page does not adhere to the Additional Sorting and Filtering. Does anyone have any suggestions?  

When using the pick/pack/ship functions, the quantity on the scanner always defaults to 1 and the user has to manually push the button to change the quantity on the line to the actual picked quantity. This can become a very tedious when there are pages of shipping lines to be picked.There should be a setting in the Sales Order Preferences->Warehouse Management tab that allows the pick screen to default to the quantity on the shipment line.The purchase receipt screen has a similar option to set the default the receipt quantity to zero or to the PO order qty.

I have a screen called Transaction Entry.When a certain criteria on a related Sales Order is not met, Transaction Entry should be read-only. And I’d like to let the user know that the condition on the Sales Order has not been met.Currently I’m using RowSelected to test for the condition on the Sales Order. If it fails, then I’ve been setting e.Cache.AllowUpdate = false. In addition, I have been setting:e.Cache.RaiseExceptionHandling<MyDac.transactionNbr>(e.Row, e.Row.TransactionNbr, new PXSetPropertyException(“Condition failed”))I’ve used this elsewhere so that the user can see the red X and know why they can’t edit the record.BUTSince RowSelected is fired while I’m creating the record when the Sales Order condition hasn’t been met, my code is throwing the exception.So, is there a more correct way to alert the user when they pull up a record as to why they cannot edit the record?At this point it feels like it will be easier to create a PXAction button that I can show/hide and giv

I have this error when deploying default event for FieldSelecting(No changes made yet). It is also happening with other events for ARDocumentResult

Hi all,Has anyone else encountered this issue:After implementing another entity in intercompany, when navigating to the Opportunities Form, i have noticed the “Order” Tab and “Invoice”  Tab has disappeared.the below is before intercompany functionalityAfter intercompany functionality.This is not a custom field, we have also ensured the Inventory Management feature has been enabled.Any help on the matter would be highly appreciated.

Hi Team,I would like to exclude Status On Hold and Status Open from Shipment Confirmation SO642000. So I have tried with 2 options:Option 1: Status not equal On Hold or Open → I'm still able to print Open Shipment → incorrect Option 2: Status = Confirmed or Status = Completed → I cant print Confirmed Shipment → incorrect Do you have any idea on this issue?Thanks in advance,Yên Chi

Hi Team,I'd like to add the text "REPRINT" as a watermark in the report. When I print the report, I want "REPRINT" to be displayed in the background like a back image. want to add the text "REPRINT" in the report, just like the text provided below. However, I'm having trouble adding this text as a watermark. I've been attempting to do so, but I'm only seeing image selection options in the properties. I would greatly appreciate your assistance with this issue.Thank you. Regards,Sagar

Hi,I have a GI that shows about 400,000 records. After I add same tables join to show first invoice of customer. The result show that data is too huge to load.Please advise me how to fix this situation.

How do I create a location ID?

Hi,My application generates new Bills in Acumatica via REST request.if document’s size is less than 25mb everything works fine, new bill is created and document is attached to it, otherwise if documents size is > 25mb, I receive this error.Is there any configuration parameter in Acumatica to increase allowable size of the document ?

I have an import scenario based on a GI. The GI is grouped by several key fields, and one of the resulting fields is called ‘State’, which is a count of the number of States that are represented in the data.The GI returns the correct result: But when I attempt to use the resulting value in the Import Scenariothe result is empty.I’ve tried so many work-arounds, but nothing with aggregate fields seems to compute.Is this a bug or a known limitation?

Every invoice that I try to “Recognize” in the Incoming Documents screen generates the error “Discovery Endpoint Address not set”.  I am manually dragging and dropping the invoices onto the screen and they do display but that’s all other than the error.

Hi, is there a way to include unposted transaction in Customer Statement ? or creating a alternate customer statement which include unposted transaction?

I have a report that I need to run everyday at 7PM.   The report has a Date Range Parameter.  I need this parameter to be the Current Day   ie @TODAY.   I can not enter @TODAY in the parameter fields.  How can i schedule this report to run daily?  The community articles lead me to creating a business Event, but in order to setup a business event you need to have a ScreenID.  I dont have a screenID, or a trigger such as change record.   I just have a report that needs to run at 7pm.Report Parameters - Need to set Start and End Date to Current Date.Automation Schedule - This schedule works, but I dont know how to set the date parameters for Current Day. 

Hello,I’m having an issue where AP did not link the PO to the bill when it was entered. It went through the whole process and was paid.I know it can be reversed if the status is open, but since it was paid and now closed is there any way I can link it to the PO?I don’t understand either.. if it can be reversed, how would you apply the payment again without it thinking it was paid twice? Reverse the bill and payment and then enter it all again?It’s causing a lot of extra work when I’m in the project close out report, the costs are allocated to the project but finding out what costs belong to what PO manually with a ton of bills and PO’s on a job…it’s very time consuming.Not sure if there is a way to do a project transaction like entry where it can hit the PO but not be posted to the GL? but..Any help would be appreciated.

I have customers who do a large volume of drop shipping items to customers.They want to be able to invoice directly from the PO to close the purchase order, or to be able to mass process purchase orders like you can with sales orders:Mass create purchase receipt (default to the PO line order qty) Mass release purchase receipt (this can already be done) The preferred solution would be a check box on the stock item to not require PO receipt for the item if it is on a drop ship order. The workflow would behave like a nonstock item with the Receipt Required box unchecked.

I have created a generic enquiry to show the latest invoice age per customer but the ARInoice.DocDate seems to have a problem because my date values are all negative. My formula is =DATEDIFF('d',TODAY(),[ARInvoice.DocDate]). Could this be also because I’m grouping my data  This also impact my options to filter because I would like to only get invoices older than 90 days 

Hello,I am trying to setup Device Hub to print a label for a file folder on an action. However I keep getting 2 errors which I cannot figure out what is causing them. Here are screenshots of the errors.I am running DeviceHub as administrator on my device and I have given the user admin access rights. With the User, I am able to access the Printers page, Print Jobs page, and the report I am trying to print. Here is the code of the action:protected void printFileLabel() { PMProject project = (PMProject)Base.Project.Current; Dictionary<string, string> printParams = new Dictionary<string, string>(); string projectID = project.ContractCD.ToString(); string projectIDDash = $"{projectID.Substring(0,2)}-{projectID.Substring(2,6)}-{projectID.Substring(8)}"; printParams["ARRetainageReportParameters.ProjectID"] = projectIDDash; string actualReportID = "PM6210LB"; SMPrinter printer = PXSelect< SMPrinter, Where<SMPrinter.printerName, Equal<Required<SMPrinter.pri

Hello!Is there a way in Acumatica to show all items that have had no activity in the past few years? Thank you!

 I create PO from this code            RQRequisitionEntry instance = PXGraph.CreateInstance<RQRequisitionEntry>();            instance.Document.Current = ii;            instance.createPOOrder.Press();            instance.Document.Current.OpenOrderQty = new Decimal?(0M);            instance.Document.Current.Released = new bool?(true);            instance.Document.Current.Status = "E";            instance.Document.Update(instance.Document.Current);            instance.Save.Press();And after I debug the requisition.ReqNbr have value but query always return nullPOOrder pOOrder = SelectFrom<POOrder>.Where<POOrder.rQReqNbr.IsEqual<@P.AsString>>.View.Select(this.Base, requisition.ReqNbr); and check database value of this po is still null. I think instace.Save.Press() not save to database yet. So how to save po to db

Example one base screen is available in acumatica screenID: SO503050 & graph name: SOPickingWorksheetProcess for List button