Solved

Hi,Cannot send out an email. we tried sending out a copy of the purchase receipt from the Purchase Receipt module, we went to print the purchase receipt and then clicked on send, but upon checking, the email was not automatically sent, the email status is Pending Processing, and in the email, the cancel sending button lit up, meaning it was not yet sent out, . This is the same as the one reported in emailing statements in Receivables (Print Statements) we need to do an additional step, which is to go to All Emails > Outgoing emails > click on the email in question > click on  > Process, only then will the email be sent, 

My company uses ADP as a 3rd party payroll provider and we have been importing the payroll transactions manually.  Labor is billed to jobs as at a blended rate (labor and overhead together, aka conversion costs) and a correspond offset account is used so that actual labor and overhead costs in SG&A are netted against it.  The problem is, that Acumatica wants to apply both sides of the transaction to a job which ends up netting out to zero.  Both the debit and the credit hit the job so that when looking at project budgets in the Construction module no labor costs appear.   Worse than that, if you separate these out into two different lines in Project Transactions with the first line posting to the job and the second posting to X, the non project code, this transaction somehow doesn’t show up in the GL.  How should we go about resolving this?  Is it because both of these are considered Expense accounts? Is there a way to set up a new Account Group for the labor absorption offset acco

Hello we just went live with Acumatica Monday. I am trying to learn to use the Generic Inquiry interface.Basically I have 2 questions. First question - I am working with multiple tables and trying to create joins using the interface. Having some trouble getting my head around setting up proper joins. I am use to just creating a SQL view (Oracle) and then access that view through our ERP via a report interface. Is there a specific method for me to see the code behind a Generic Inquiry that I create.  I think that would really help me figure things out. If I understand correctly that would be the BQL code or some sort of combination of that and something else.Second question  - As I mentioned I  am used to creating SQL views in our previous ERP (IFS). Reading through some post on line it appears we have that capability in Acumatica  where we can create a SQL view and then create a DAC (Data Access Class) to look at that SQL view and then access that DAC via a Generic Inquiry or a Report.

Hi Team,I have the following question regarding the reversals of debit adjustments. (Payable Module)I have created a debit adjustment & didn’t apply to any AP bill because I found out that the created debit adjustment is wrong. Therefore, in order to correct that I reversed the debit adjustment & it created a credit adjustment. In my GL accounts the balance is net-off & it is in order. But the question is, the credit adjustment & the debit adjustment is still in open status. How am I suppose to close those documents ? Please note that I don’t have any document to apply. Thank You & Best Regards,Yashodha  

Hello,Looking for to see if anyone has tried to auto populate GL Sub Accounts based on the Branch selected on the line items of the PO. It looks like a buyer has to manually select a sub account and we are looking for to see if there is a way we can auto populate this to avoid any incorrect selection of accounts by users. Appreciate the guidance.Thanks,

Hello everyone I was hoping if someone could help me with this subject. We are using the Acumatica API for the upload of files in respect of  some payments.The thing is we can't attach files once an operation is closed, and we want to know if there is a workaround on this or an alternative that we can use to avoid this lock.Thanks for the help in advance.

I can’t find the sync schedules for our Big Commerce entities (Customer, Sales Order, etc..).I need to edit the frequency that these entity syncs are happening but cannot locate them. Any help would be appreciated.

Hello,Trying to create an import scenario with he minimum required data to start with.If I follow the steps in this scenario exactly, I can create new fixed asset records without any issues.  The import scenario says it worked and doesn’t throw any errors.  But it only creates 1 record which is wrong.  I can rerun the scenario over and over and I only have 1 record.Please note, I don't’ really know anything about fixed assets in ACU.Asset numbering is manual: Crazy results below: 

Getting really aesthetically granular with a client’s printed reports and running into some formatting issues I can’t seem to figure out. Is it possible to center align report sections to the report page layout? (1) Does this get rid of the right side gap? (2)Also can a border for the entire report be made so it is visible when printed or exported to PDF. (3)When I do print or export the outside border disappears? I have moved items around on reports by adjusting their position manually, but would like to utilize built in functionality if it exists for center aligning entire report sections, not just on report section objects.  I have reviewed the Report Designer documentation, and nothing I can find speaks to either of these issues. Any ideas?  

Hi,I created a custom processing screen and is working as expected. I configured an schedule and is running fine, but in the Automation Schedule History window the total records always is zero.For the DAC I’m using an SQL View. public class NewWindow : PXGraph<NewWindow >{ public override bool IsDirty => false; public PXFilter<Filter> filter; public PXCancel<Filter> Cancel; [PXFilterable] public PXFilteredProcessing< ShipmentToProcess,Filter, Where<ShipmentToProcess.processflag,Equal<Current<Filter.processflag>>>> Document; public NewWindow () { Document.SetProcessCaption(PX.Objects.IN.Messages.Process); Document.SetProcessAllCaption(PX.Objects.IN.Messages.ProcessAll); } public void _(Events.RowSelected<Filter> e) { IUtilService serv = new UtilService();//inside this method I set the PxProcessing<class>.SetError or Info ... Document.SetProcessDelegate

how it calculate because sometime sum extend cost in detail line but sometime it’s not the same sum of details line

Looking for advice -I have a client using AP bills approvals and 3 levels of approval.  See my levels below. As shown, Bills <$10k, do not route correctly (for both Marketing and Events. The Originator step processes correctly, the Vendor step processes correctly,  but then it returns to the Originator again.  Is there another way I should setting this up? Any help would be appreciated!  

Is it possible to create a parameter on a dashboard that allows the user to select more than one item in the list of values for the parameter?   For example, we have a sales dashboard and we want to select 2 salespeople in the list of choices for the salesperson parameter to see how those choices affect the data on the dashboard.   Is there another way to do this using attributes or something else?Thank you!

Shopify Payments syncing has been working great. However, we had our first backorder on a Shopify Payments order. The authorization from Shopify within Acumatica was captured for the amount of the order minus the backordered items/freight. We received the goods in to ship, but the authorization no longer had a balance even though we did not capture the full amount. Well in Shopify, you can still capture the balance. So we did. However, that second payment is not syncing to Acumatica so we cannot apply that payment to the shopify order/invoice. What are the plans to address this? Back ordering is common in our industry and we want to allow that for web orders. We can try to create a manual payment to mark the order/invoice as paid in Acumatica. But, that is not a real solution. Thoughts?

I have a generic inquiry for displaying a side panel on an ‘Export Shipments’ page. This side panel lists all the Files on the page (this page has the option to create a document and attach it to the page, populating the default ‘Files’ popup). I would like to update this side panel so when a user clicks the file name it will download the file instead of navigating to the ‘File Maintenance’ page. I noticed the File Maintenance page has the ‘External Link’ field that is a part of the ‘UploadFileWithIDSelector’ -I was originally using the ‘UploadFile’ data class for displaying the Name, CreatedDate, and a few other properties belonging to ‘UploadFile’ on the side panel but this data class doesn’t have access to the ‘External Link’ field so I updated the generic inquiry to use the ‘UploadFileWithIDSelector’ data class and attempted to add the ‘External Link’ field in the Results Grid -  With this setup the page only displays the Name and CreatedDate with the External Link value being empt

Hi All,I have a GI that has QTY total and it works. I need to be able to add the location and lot/serial number, but when I use the table I “believe” it should be, I return no results. Does anyone have a solution? 

Hi There,I am trying to run a REST query to retrieves some fields at AR Line Level (coming from ARTran) with a couple of fields coming from the ARInvoice header table.If I start just with the AR Tran part, I have this:/ODatav4/PX_Objects_AR_ARTran?$select=RefNbr,LineNbr&$filter=RefNbr eq 'AR012031'which works fine.I then try to add the expand clause to pull in the related information from AR Invoice. This gets me this:/ODatav4/PX_Objects_AR_ARTran?$select=RefNbr,LineNbr&$filter=RefNbr eq 'AR012031'&$expand=ARInvoiceByRefNbrwhich also works fine.However - lets say I only want to see the InvoiceDate - I add a select giving me this:/ODatav4/PX_Objects_AR_ARTran?$select=RefNbr,LineNbr&$filter=RefNbr eq 'AR012031'&$expand=ARInvoiceByRefNbr($select=InvoiceDate)BANG!And this rather exciting error message that I can’t make head nor tail of.   "innererror": {            "message": "Column DocType is not found in DAC ARRegister. ",            "type": "PX.Data.PXNotSupportedEx

I want to join a table (EPEmployees) twice to get employee and supervisor info and based on the user logged in I want to show either only an employees customers or the supervisors customers + the employees that report to them. This is what I have tried among a couple other ways:public SelectFrom<Customer>      .LeftJoin<Address>          .On<Address.addressID.IsEqual<Customer.defAddressID>>      .LeftJoin<CustSalesPeople>          .On<Customer.bAccountID.IsEqual<CustSalesPeople.bAccountID>>      .LeftJoin<SalesPerson>          .On<CustSalesPeople.salesPersonID.IsEqual<SalesPerson.salesPersonID>>      .LeftJoin<Users>          .On<SalesPerson.descr.IsEqual<Users.email>>      .LeftJoin<EPEmployee>          .On<Users.pKID.IsEqual<EPEmployee.userID>>      .LeftJoin<Supervisors>          .On<EPEmployee.supervisorID.IsEqual<Supervisors.bAccountID>>      .Where<        Brackets

I have a Generic Inquiry that displays shipment information based on the tracking number that is input into a parameter. We have EasyPost integrated into our Acumatica, and we have the Tracking URL as one of the fields in the Generic Inquiry. Is there a way to make the Tracking URL link active in the Generic Inquiry so the user can simply click on the URL and view the tracking information on the EasyPost tracking page? Thank you

Hello,I am trying to embed a webpage into a tab item on an existing screen but it is not working. I am trying two different ways based on some code snippets I found. The first, utilizes standard containers and redirect exceptions (Redirect Option). The code gets validated but every time I go to check the output, I get the following: I checked to ensure that the website is iFrame compatible and it is so I am not sure why I am getting this if it has worked for others. Below is my code, very simple.. using System;using PX.Data;namespace SampleiFrame{ public class SampleIFrame : PXGraph<SampleIFrame> { public SampleIFrame() { throw new Exception("Redirect:https://**WEBSITE**.com$target=main"); } }}​​​​​​The other option is to just modify the aspx directly since I don’t need any standard containers. I followed the following code (ASPX Option). I haven’t been able to make this work in the validation stage because every time I update the aspx and

Is there some way in Acumatica to warn users, during entry, that the Inventory ID exist in another row?  ScenarioA clerk inputs a Sales Order, Invoice, or PO with numerous items, 30+, including Item A. Later on they get a request to ‘add’ Items B to the order but they inadvertently select Item A. So the order is now has two rows with Inventory ID Item A.  Required behavior:A popup prompt to notifying user that the Inventory ID already exist on the document Place a warning icon adjacent to the duplicate Inventory IDs        

In one of our tenant, any of Finance Report will give an error with trace as below and I have submit the log.Please advise.Thanks,Idrus

I’m trying to generate wrapper classes using ClassGenerator.exe and running it as a CLI tool with the config file.I’m getting the following error as soon as executable starts:C:\Users\abaranov\Documents\Work\_AcumaticaSoftware\TestSDK_22_211_0034_35\ClassGenerator>ClassGenerator.exeWrapper generation has started, please wait. It may take up to 5 minutes for the first wrapper to be successfully generated.Process FAILED - so301000System.Exception: Unable to get screen so301000 with url /CstDesigner/abaranov_PCBCustomizations/so301000.aspx ---> System.Exception: Exception of type System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation.; StackTrace: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: This method cannot be called during the application's pre-start initialization phase.Configuration file ClassGenerator.exe.config:<?xml version="

Hi,An debit adjustment (which includes incorrect date) was released against a purchase return. To remove that particular incorrect debit adjustment from the purchase return, what can we do ? Thank youNawanjana

Have been getting the above error whenever I try to sync the prices to be exported to Customer Groups from Acumatica to BigCommerce.