Solved

How to pass NextCheckNumber in Process Payments/Print Checks Using Rest Api.when I call processAll entity show that message-- Next Check Number is required to print AP Payments with 'Payment Ref.' empty. 

I want Create Assignment and Approval map for employee screen. If employee Payment method change i want to trigger approval map. currently i am not able to select Employee Entity in approval Map screen. How implement approval map for new custom screen?  

when status SO is credit hold, is there a way to send statement report (AR.64.15.00) to email recipients add in customers screen by using business eventBecause this business event apply for sales order screen, I don’t know how to apply trigger condition with other screen. Pls help me if you have any ideaThanks in advanced.

How do I delegate someone on my staff the power to see our staff certification progress and badges?  Any help would be greatly appreciated.

I want to import the unique customer records using import scenario.I  want to skip the existing records & insert only non existing records.The record skip logic should be execute on “CustomerID”.

Been working well with ScreenId=CR302000 entering Phone contacts and Fax but of recent, default numbers are displayed with masks and they wont go off. How do I remove them? The same numbers have replicated on all contacts now. 

Hi, i encrypted the “TaxRegistrationID” field for vendor with a customization project using this Acumatica Article: https://www.acumatica.com/blog/technical-tuesday-encrypting-fields-acumatica-database/I replace the PXDBString attribute with PXRSACryptString . Now the field is encrypted in the database but in the UI we can see the real value. Thats what we wanted.If i make an api call to Vendor end point i do get the real value but if i export the vendor or add the field to a GI i get the encrypted value.How can i get the real value in the GI?

Hi everyone,When our employee makes a prepayment for a project, how do I record this transaction into project for tracking?I don’t know why it’s not appear in project transaction.

A client with an existing Shopify store connected to their legacy ERP uses variants but they do not wish to utilized Matrix items in Acumatica.  Instead the just want to have each variant as a individual SKU in Shopify.  The Shopify help says to delete the variants and the default.  They want to continue to sell the SKU’s in their store. For example SKU 1234 has ‘’, A , and B as variants and they want to have them as1234, 1234A, and 1234B as individual SKUs

Say production ticket AM01 has two 2 ops, 10 and 20.. labor A  on his clock entry put in finish 5 pieces, and supervisor release the labor ticket.. therefor RM and overhead and labor all posted to GL.one day later, it turns out that A actually only finish 4 pieces instead of 5 in op 10how to correct this?Z

I am trying to add a popup note when verifying a field (following this example from SO Line https://gist.github.com/gmichaud/17e346cdf3062de233f52c9976d0a03e) and getting the following error when publishing.  I know I am missing something within the highlighted section to make a proper if statement, but not sure how to fix it.Publish errorCode 

Hello, we are a service company, we use the Services module in Acumatica. We have a challenge of calculating the WIP for the service orders that currently open. Currently, there is no way for us to calculate the WIP because most of the transactions that happen are not date stamped. Anyone else come across this issue? Thank you

I need to override a piece of Acumatica’s Approval process that prevents from Apprving a Rejected document. Not sure why Acumatica has put this control in place but it happens many times for us that a documents gets rejected to add some supporting documents and when documentation completed, then this document can be approved. The piece of the code that prevents from approving a rejected document is in EP\Descriptor\Attributes.cs as follows:         public virtual bool Approve(SourceAssign source)        {            EPApproval item = (EPApproval)this._Rejected.SelectSingle(GetSourceNoteID(source));            if (item != null)                throw new PXException(Messages.CannotApproveRejectedItem);            if (UpdateApproval(source, EPApprovalStatus.Approved))            {                RegisterActivity(source, PO.Messages.Approved);                return true;            }            return false;        }

This seems like it should be straight forward but I’m not seeing where the issue is.I have a file with Vendor Code and a name.  I’m trying to update an existing vendor record to add the name to the General → Primary Contact → Name field.  The import scenario doesn’t report any issues but also isn’t updating the field - and no contact is added to the vendor. None of the vendors have a contact record at this point.I can type a first and last name into the field on the screen with no issues.Build 20.210.0044

Hello, When releasing our past expense claims we found an odd error in the system. on the Claim below, the total equals $104.83 but the sum of the expense receipts on the claim totals $84.28, giving a difference of $20.55. What would cause this error? This is the first time we have found it and want to ensure this does not happen moving forward, in this case, we are overpaying expense claims.Thank you,KT  

Would like to see in the Generic Inquiry list columns with “Last Modified Date” and “Modified By” to ensure that we save all inquiries before a major update. It’s difficult to determine if someone has modified an inquiry that has not been backed up without this information. There should be some kind of audit trail for this.

Hello allI have a customer with large 500+ line orders and when they need to do a return that want to have a reason code on each line.  What are my options to add a reason code to 500 line ?  can I ‘upload’ via details or do I need a import ?   

Using the AP-Vendors GI I would like to add the email field from the Payments Tab on the Vendor Profile.Can you help me accomplish this please? I have tried a few tables with no luck. I have attached the GI Thanks John 

Good day,Client has been using System Email Accounts to send / Received emails from Acumatica using Outlook (they dont have Acumatica integration on their outlook app in windows), starting on 4/8/21, the client started noticing that the emails on her inbox will automatically change to read, other users that have Acumatica accounts that also have System Email Accounts setup in Acumatica will have same issue. After several tries with their IT person from there email server, we inactivate the System Email Account for her by changing the password to something incorrect, and the issue stop. I have sit checking this issue and it occurs when the System Email Account is setup correctly.  I have already change the incoming mail server from smtp.office365.com to outlook.office365.com to smtp.office365.com. But this did not fixed the issue.  I have also test where the password in incorrect and the test is bad, and emails remain unread on my clients outlook app in windows, but when putting the pas

Hi, I’ve been trying to set up a dunning fee for dunning letters. The following is the dunning setup: Then I prepare the letter and prepare to release it: But when I release it the fee reference number is not generated and there is not dunning fee invoice either: Am I making a mistake somewhere causing the dunning fee to not be created?Side note: Are dunning fees always fixed price? Are there other options for calculating the fee, say based on a percentage of the amount overdue?Any help and insight will be deeply appreciated, thanks. 

Hello,I have a problem while I am export report to PDF that containing Chinese character inside. Inside the report page, the character is showing, but once I exported to PDF, the Chinese character becomes blank spaces Hopes you can give me the solution.

Hi,We are using the BigCommerce connector with acumatica 2021 R2, but have noticed that payments do not sync from BigCommerce if the order type in BigCommerce is “Manual Order”. These are orders that are taken manually by staff using the backend of BigCommerce. They use exactly the same payment method. In fact, I have compared the GET results of the “payment” endpoint for a normal website order, and a manual order, and the payment REST response looks identical from BigCommerce. So is the acumatica connector programmed to NOT sync these payments? If I try to manually sync the payment (Sync History->Add New->specify the external order ID) then it says “the payment record cannot be syncronized because it does not exist in the external system) Hoping someone has some insight, as I can’t find any information in the documentation as to why these payments can’t be found by acumatica. ThanksGeoff 

We are currently using lotted stock items for managing items that are similar in nature (custom doors), but will have ranges of dimensions (height, width, depth), in addition to style, species, etc (attributes which have a finite range of options). Looking at using matrix item functionality, and while I can see how this can be used for managing hundreds or potentially thousands of SKUs, not sure it will work with dimension ranges (i.e. door width can be anywhere from 5” through to 30” in increments of 1/8”).  When multiplying out the matrix, it becomes very large; looking to understand best practices for managing SKUs of this type.  Has anyone used matrix items (for handling attributes with a finite set of options) in combination with making them lotted to handle the very large number of dimensional range options possible? Alternatively, is there any way to create SKUs dynamically on the fly for the range of dimensions supported (i.e. if door (style X, species Y, colour Z, width 18”, h

Is there a way to create a filter either on a GI or Dashboard widget to show current month Plus five days?  I know there is the @month parameter is there a way to add five days to it, so it forecasts five days into the next month? 

Do you use the Project Quote in Acumatica or you use a ISV? Do you like it?Thanks