Solved

Hi All,I would like to know that what is the extract time which updates currency rates in Acumatica from (GMT+05:30) Sri Jayawardenepura time zone by using  https://openexchangerates.org/  Thank you. 

Hi Team,We have an issue with additional row getting added in a grid after selecting a value from selector.Issue: Selecting an inventory Id from a SelectorAfter the selecting from the selector an additional row is added Any thoughts why there is an additional row populating?

Does anyone know of a good tool to integrate a Golf Course / Country Club / Restaurant with Acumatica?   Currently on 2022R2

in one tenant/company we are not seeing forecast showing in MRP Demand. Has anyone had this happen or can suggest troubleshooting to resolve this issue? 

Does anyone know of a report that shows how much of something we have ordered over a large period of time? Looking to see what are most used material is and average cost we are spending on it. **Not sure if this makes a difference, but most of our orders are drop ships, so this wouldn’t be reflected through our inventory.  

This is kind of an SOSI would normally spend a few days on a project before asking for help, but I’ve been given a fire to put out which has a significant impact on the customer.On the customer portal, users are able to enter support cases.  I need to limit the support cases that show up in the grid to just cases created by the contact that is logged in.  Right now, all cases are being displayed for any user.  The users are simply contacts for a BAccount “PORTALUSER”.  So, when that contact logs in, they see everything for that baccount.My thought is to somehow change the view on the grid so that it adds a where condition CRCase.contactID =  AccessInfo.contactID.FromCurrent()It looks like I need to modify the FilteredItems view.   Can I override this?  Or, is there some way I can override one of the screen events to restrict the Case view?I’m also trying to find out how I can get the contactID of the current user.I can get the userID with this code:            Guid? currentUser = Commo

For this GI AR3010PL, I am trying to create a new web service endpoint. I am able to fetch All records but I need to fetch the “Due Date”​ filtered data. Not sure how to achieve that.  Following is how i am sending request in postman  

Hi there,I created business events that sends out an email via an action trigger. The only thing is that there is an (all) option when you create an action trigger. Well I don’t want anyone to accidentally select the (all) option and send an email message to every ticket in the screen.How would I go about either disabling the use of the (all) option or having it not even appear as an option?I tried using the automation steps screen to disable the action but it still appears as an action you can use.I assume there’s an easy way of doing this but can’t seem to find anything on the web.Any help would be appreciated :) 

I’m running into an issue now that I can’t make appoints because I must be an Employee to a current Screen. I doubled check the employee screen and everything looks good and same same when under user. I’m full admin too. whats the best way to take care of this? I went though every settings and can’t find where to correct this issue.  

I am using the T350 PDF to create a new MYPL Row Set using the COPY ROW SEt and receiving an error when attempting to SAVE: Error: A record with the same value of the Code field already exists. I did have a previous MYPL but it has, as far as I can see, been deleted including the appropriate ROW and COLUMN SETS. Is there a way to find the missing/hidden MYPL Report Definition? We will begin our migration to Acumatica next month, so this is still a learning process.

Hi i encountered a problem to recreate a new report for P&L For green circle is the report i want to new create , the row and column based on DPLHowever, when i do some changes in DPL in new report (green circle) , it will affected the format in DPL (Red box)Not sure if there is any way that i can use DPL format to create a new report but i can change the format in new report where not affect the existing DPL format . 

Hi ConnectionsI'm attempting to use an API to update vendor info like primary contacts and account addresses. Except for the vendor name, the application's other data fields are not updated. Please use the payload shown below as a guide.   {    "VendorID": {        "value": "V00001"    },    "VendorName": {        "value": "SSCI Energy Sdn Bhd"    },    "Name": {        "value": "Robert"    },    "Email": {        "value": "robert@sscienergy.com.my"    }} Thanks Ram 

Hi @all,I wanted to upgrade my instance from  Build version 21.113.0011 to the latest 2023 R1 version. Have already uploaded the SQL database back up format of the system to test the upgrade offline. Have also installed Acumatica configuration wizard of build version 21.113.0011 same as my live instance  and deploy an instance on it to help me test the upgrade offline.Which place actually should I perform the upgrade? is it on the configuration wizard or on the instance: -System > Management > Process > Apply Updates>Download Package>validate customization……..Which place exactly?

On the generic inquiry Production Order Maintenance, I’ve added column which is a multi-select field (Production Line(s)). “Production Line(s)” is a custom field on InventoryItem. On InventoryItem, I am storing the IDs of the production lines as a comma-separated string (eg. 1,4,5). When I try to filter the Production Order Maintenance GI, the filter misbehaves.The results will sometimes show blank pages (although I know there are rows that match the filter) and the record count will show something like “1 to 0 of 1151” Has anyone tried something like this? Is there a way to get this to work? 

When I run our budget to actuals income statement without the unit set, it runs properly with correct values.However, once I add the ‘Companies’ unit set, the budget values default back to actuals. Assume I have not set up the Unit Set correctly, but haven’t been able to resolve. Here is the Unit Set:I thought I could just remove the ‘Actual’ from Data Source in above screenshot - but this seems to change the Actual values on the Row Set as well which I don’t understand.

Hello Community,I have been trying to let the system recalculate the values upon Currency Overriding in the Invoices & Memos (AR301000) form. Here, when I override the value from USD to KHR, the Detail Total doesn’t get calculated. Would like to know if I am missing out here something. Kindly guide me.Thanks in Advance.​​​​​​​

We are trying to create a concept of a Customer Group assignment. These groups would link many items/prices with many customers. We want these customer groups to be eligible for agreed upon pricing for a list of items where the total purchase qty would be added together to meet the agreed upon purchase quantities.Additionally, customers in this group may designated some of their distributors or their customers to also be able to purchase these same items directly at the same prices and be included in the total qty purchased reporting.  If any partners have ran into the same issue with their customers, or if you have any suggestions on how to do this in Acumatica, please comment!

I have created a business event and it is working fine. Now I want to attach my custom report in the mail that is triggered by the business event. I added it as an attachment and provided the required parameters but it is not generating exact report. Some details are missing. If i generate the same report on the report screen it is working fine.  

Is there a way to change the way a name displays from Last, First to First Last?

We are having issues with our import working in real time importing contacts from HubSpot into Acumatica.  I changed the Polling from 60 seconds to 300 seconds and then I restarted the HubSpot SyncWhen I restarted the Contact Import changed from “No Polling” to how you see it below. This Polling function is why the record didn’t come in. I made a new record in HubSpot and it came in after the 5 minute mark. The Last RealTime Attempt field is queuing when processing occurs.I have no idea what made it go from “no polling” to polling. I’m not sure why Leads wouldn’t also be in a Poll status. Why is the Lead still in a (No polling) state and how do we change that?    And how and why did it even go into no polling state? 

I have attached a static form to our PO that will print with the PO on vendors that we purchase ingredients from. I created a page break on the group footer and the PO prints on the first page and the static form prints on the 2nd page but the page 1 of 1 footer in printing on the 2nd page but not the first page. And when I add multiple lines to the PO to push the PO to print on a second page Acumatioca renders 10 pages and my static form prints on several pages. I have attache images for review, and my Report Designer settings for the footers. My end goal is to print the PO first and the static form letter last, as well as adding multiple lines to push the PO to a 2nd page to only print a 2 page PO and the 3rd page is my static form. Please check out my report designer setting to see what I need to change to make this work. PO page 1 and Static form page 2Page 1 of ? should print at the bottom of every page. I do not need the page count on the static form.Top image capture of the firs

Good day, I used a Tenand ID that was not being used, thenant was on status Unlicensed, and change it to Test Tenant. After this, I imported the Demo Snapshot (Demo 22.211.0034), restored this snapshot to the Tenant, and after a few minutes, the tenant was not selectable, and now I cant access that tenant, is not showing on the tenant list screen, and it will show as a tenant on the Space Calculate screen. I am using the admin user, with all superpowers, but still can make the tenant to show up. Any ideas?

Hi,Question 1: can we add additional ‘source tab' list from default list in OPPORTUNITIES > CRM INFO SOURCE SECTION. Possible to customise it or add additional into the names list that we are more familiar for our preference. Currently the default list there is: Organic Search  Campaign  Referral  Other  Web  Phone Inquiry  Purchased List e.g. We would like to change Purchased List into existing customer or web into website or other into events so that we have a more clear understanding of each OPPORTUNITIES comes from which activities that we are doing, Question 2: Also, sometimes appear that from one potential client appear to have 2 source that trigger them engage on the product and services that we provide. Can we add 2 source at once in one same OPPORTUNITIES.  

How to Add Freight Charges to a Purchase order without affecting the Line Item (stock/non stock items ) and the Discounts Applied  on the Line level or on the total of Line Items?; ie; freight charges need to be added to the net of Line total

I received the following message when I create a cash account for a bank rec. When I create a reconciliation statement,  the transactions do not populate. How can I get the transaction to populate? What step am I missing?