Solved

Hi All, I want to show all records associated with any Account when Account Filter field is null in Account Details Screen. Otherwise it should work as usual. How can I achieve this? Thanks

Hi!We have eCommerce connector setup with a Shopify store and configured schedules for Stock Items preparation and processing (on daily basis).We have two problems:Some items were last processed a month ago. Is there a filter of some sort? What can affect this and which stock items can be excluded if the automation schedule screen doesn’t allow to configure such low level details (it’s just Entity, frequency, time basically). We map product visibility with status in Shopify: visible → product is Active, invisible → product is synced to Shopify still but as a Draft stock item. This gets ignored on some products and with visibility at Visible and Export to External System box checked off, the products sync as Draft. What can cause this?Thanks!

Hi Team,We are getting the below error when an update is done on CROpportunity table.“Incorrect datetime value: '4095-15-255 255:63:63.1048575' for column 'Tstamp' at row 1”Column tststamp on the table is defined as`tstamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), from my understanding this means if there is no explicit value defined for tststamp, if any update happens the value for tstamp column should be set to current timestamp. Not sure how this invalid value is getting set.  

When i call Sales Orders API and put the data in the body when i execute the Request i Get 500 Status code with "exceptionMessage":"Object reference not set to an instance of an object."but when i put the same data manually the order saves normally.anyone faced this problem before ?Below is the StackStack Trace For http://Websiteserver/siteName/entity/Integration/18.200.001/SalesOrder 

Hi Everyone.I recently had a question posed to me and I am still researching possible options. For inventory adjustment, the subaccount can only be specified through the reason code. Is it possoble to specify the subaccount outsdie of the reason code (directly on the adjustent)? Thanks

I’m attempting to override the ReleaseFromHold action on the POOrderEntry graph, I need to add my own validation before the baseMethod is called.I created the delegate using the following code, but I receive the error message below.I’ve been able to override other action on this same graph using this method, is there something unique about the ReleaseFromHold action?  public delegate IEnumerable ReleaseFromHoldDelegate(PXAdapter adapter); [PXOverride] protected IEnumerable ReleaseFromHold(PXAdapter adapter, ReleaseFromHoldDelegate baseMethod) { return adapter.Get(); } 8/18/2023 2:46:05 PM Error:Attempt by method 'Wrapper.PX.Objects.PO.Cst_POOrderEntry.ReleaseFromHoldGeneratedWrapper(PX.Objects.PO.POOrderEntry, PX.Data.PXAdapter)' to access method 'PX.Objects.PO.POOrderEntry_Ext.ReleaseFromHold(PX.Data.PXAdapter, ReleaseFromHoldDelegate)' failed.   at Wrapper.PX.Objects.PO.Cst_POOrderEntry.ReleaseFromHoldGeneratedWrapper(POOrderEntry g, PXAda

I’m not sure if this is the right place to ask this.  If not please accept my apologies in advance. We have several template items that are giving this error when trying to sync with BigCommerce. One example is below:Error: Option values ids on update should belong to the option, the following is were not found: 6593; Status: 422 How can I find out what the missing Option ID is referring to?More generally, is there a way to set up the Template items so that Acumatica will update BigCommerce automatically, without manual intervention, either overwriting what's there or creating an alternative listing?Thanks for any advice, Phil

I have noticed inconsistencies between a user releasing Time Activities vs. an Automation Schedule releasing Time Activities.  On the Release Time Activities (EP507020) screen, we encounter the following error when run via an Automation Schedule: (this error comes from the Automation Schedule History (SM205035) screen.)PM Error: Task is Completed and cannot be used for data entry.While logged in as the Admin user on the Release Time Activities (EP507020) screen the time Activity is processed successfully.  What is causing the Automation Schedule to fail when compared with the Admin user manually following the same steps? We would like to avoid having to manually releasing time activities every day.  Edit: To be clear, I understand the error is coming from a completed task not allowing the release of the time activity. My question is why can the Admin user process this record without errors while the automation schedule fails? 

Hello,We want to create a GI that lists all sub assemblies of a kit specification. Below is an example:CJ60 has kit components : CJ30, CJPC, CJLP, CJCB and CBLUE. Similarly, CJ30 has kit components - CJ12,CJTC, CJTD and TH10.  Kit Specifications and Kit AssemblyWe would like this information along with their lot serial numbers into a GI. Currently, I am using INTran table and self joined the same tables multiple times. But it is not working as expected. Table Joins on the GIWill really appreciate if you could share any ideas/ suggestions to get this to work. thank you! I can share the xml file of this GI if needed.  @lauraj46  - could you please advise if you have any ideas as well? Thank you!

Good day,I have several questions about buttons.I am trying to establish a sequence when creating customer locations, in the customer locations screen when a user selects a customer and is going to add a new location, it has to press the button, so it automatically assigns the number for the sequence. If I Define the action with PXButton in the graph extension, it creates a button in the toolbar and when pressed it does the sequence, but it places it in the wrong spot.First picture shows the button in the toolbar and on the top left corner the value.I am specifying in the code that I want the value in the LocationCD field but is not working.Then if I define the action with PXLookupButton(DisplayOnMainToolbar = false) there is no button in the toolbar which is good, but when I create a button control in the aspx the Command attribute doesn't seem to work. I can't link the code in the graph with the aspx. I did a debug and when I press the button it does nothing. And finally, I want the

I am having an issue where a chunk or reports have stopped working. I went to create an alternate version the sales order report, which I have done many times before. I downloaded the report, made the changes necessary, then saved the report under the new name and created the site map record.  However, that report gave the error Nested reports cycle detected while trying to load, and trying to access the original sales order report gives the same error. It is also affecting all the other forms that are copies of that form.  I’ve included a screenshot of the trace below. If anyone has any advice I would really appreciate it!!  

hi,in the middle of an implementation and noticed when i tried to update some workers comp codes, the system added new records instead of updating the records.  i am trying to find out if there is a way to delete the rates that are not needed?  i didn’t see the option to delete on the WCC screen or the deductions and benefits (client is using acumatica payroll).  none of the WCC have been added to anything yet.  i haven’t tried just deleting the code itself but i see that’s an option and will probably end up going that route but wanted to see if there were any other options!  i appreciate your help!

We have created a custom GI and we need to build a custom report based on this GI with Report Designer.  When we load the schema in report designer how do we get the custom GI to appear in the report designer list.  

Acumatica allows for nonsense years to be entered such as 2222 and 2044 on AP and AR documents. How can this be prevented? 

How do we create Assignment and approval map? On the Assignment and approval map we only have option for adding approval and assignment separately and there is no place for adding assignment and Approval map  

there are few files attached in the so invoice form. when manually send the email through the so invoice from i need to attached those files automatically. currently it is not happening.

Tôi muốn tạo mới report và chỉnh sữa báo cáo trên Acu phải làm như thế nào I want to create a new report and edit the report on Acu, how to do it?

Is it possible to leverage two different native connectors for WooCommerce and Shopify for two different tenants in a single Acumatica instance. 

Hello every one,I have done a payment integration on AcuPos. when the payment is processed succefully, the provider send back a payment reference.I have configured the payment reference to be pushed to the database directly upon being receive.Now, the user have to refresh the browser tab for the reference to reflect from the database to the UI.see below; is there a way I can refresh the specific field or the column or the tab so that the database value can reflect on the user interface without the user having to refresh the entire tab.Kindly assist.any kind of response will be appreciated.Thank you, great community!

I created my first report. But I’m unable to deploy it. This is a new GL report: GL6333100. It is based upon another GL report. Following deployment steps in the training video, I come to opening the Site Map then adding the new reports. However, no GL entries are displayed in the Site Map. I see several AM type listings. I assume this is permission problem but I’m not sure which permission. Does this make sense?Do you know what I am doing wrong? Thanks,Tom

how to cancel released drop ship purchase receipt??

 I applied a 100% discount to the purchase order, but the discount didn't appear in the Journal Transactions. However, this issue doesn't occur with the Sales order, as the Sales order cash discount is properly reflected in the Journal Transactions.please check the screenshot belowPurchase Order   Sales Order  

Hi.I added a UDF on the SO document (from the Manage User Defined Fields option) with a checkbox control type, I would like to have track on the user and date and time the checkbox was selected.is that possible to accomplish?Thank you

Hello, I’m looking for a way to count the color with the Generic Inquery, for example here, I want to count all the green case per line. Line 1 : 2 , Line 2 : 3 …  This is the query for the green and orange color : I try a COUNT() but it didn’t work.  Do you have an idea ? 

I am trying to create a new customer in Acumatica using the API URL https://acumatica.ipaas.com/AcumaticaERP/entity/default/22.200.001/Customer. The request body that I am using is as follows:{ "CustomerID": {"value": "Checking2"}, "CustomerName": {"value": "Aurangzeb"}, "CustomerClass": {"value": "LOCAL"}, "StatementCycleID": {"value": "EMO"}, "DiscTakenAcctID": {"value": "CHECKING"}}However, I am getting the following error message:"error": "Inserting 'Customer' record raised at least one error. Please review the errors.; DiscTakenAcctID: 'Cash Discount Account' cannot be empty."The DiscTakenAcctID field in the request body is set to the ID of a valid cash discount account. I am not sure why I am getting this error.Can anyone help me troubleshoot this issue?