Solved

The sync fails on a useless message.Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

Hi All, I am trying to make a new column in the below GI which contains the sum of ‘Component Qty’ for an ‘Inventory ID’. Suppose for Inventory ID JE17882TK, the component quantity is 3 and 2. The new column should have 5 as value.Thanks.  

I’m doing testing on a custom application in 2021R2.  I am trying to delete a customer from the sample database and I am getting this message:I’ve run a sql query against every table that has a field name with ‘%BAccountID%’ and ‘%CustomerID%’ (which was over a hundred).  The only place that account ID is referenced is in the Customer, BAccount, Location and a couple other customer setup tables.  I can find no records in anything related to Equipment.I’ve tried debugging the Delete process but I cannot find the place in the available code repository where validations are done to check for orphan records, so….does anyone recognize “Equipment” and have any idea what that table might be? 

I’d like to be able to make one of the web endpoints read-only.  Is that possible without going through security/roles?There are some other web endpoints that I would like to make specific fields read-only as well. Is there a way to do that?  I could make a non-persisted field that mirrors the value of the field I want to display and expose that in the endpoint. I’m wondering if I’ve overlooked something. 

I created a new restrictive role that has very limited access to a few screens.Now other users who do not have this role see less in their menus.I have seen this before.I believe it may be possible that items that are “NOT SET” may be lost on these other users when I created the new restrictive role.Does anyone have a way to have my new role not affect any users who are not assigned to it?Thanks!

Hello,    In “Search in Files”, I can select multiple files at the same time, but if I click “delete file”, only the first file in selection will be deleted.    Is it a bug?  Or the system is designed to do so?        Now, my question is , is there a way I can delete the out of date files in batch?

Is there a way in Purchase Order or on AP bills to default the GL account by selecting the project and project task?

Hi,I need to setup 2 different type of projects, one that sends all the project transactions to a WIP account (this is the current setup) and a second type that send all the transactions to another GL. Right now the GL settings on the items dictates where the amounts are posted, is there a way to bypass that setting for a specific project. Keep in mind, we have different items that hit different account groups on the same project.

I’m trying to create a new Customer using the PUT Method in Postman, and I’m receiving the following error message."error": "Inserting  'Location' record raised at least one error. Please review the errors.","SalesAccount": {     "error": "'Sales Account' cannot be empty."},Here’s what I’m sending through the Body.{ "CustomerName": {"value":"TEST TEST"}, "Location":[ {"SalesAccount": {"value": "60040"}} ]}I copied this Sales Account value from another record, so I’m not sure why it’s not recognizing the value.

Good day.Another import scenario issue.  See the attached.  The scenario creates the contact with no issue; which is pretty good.  However, the contact created does not link to the Business Account/Customer ID.  I tried a number fixes but nothing seems to work.Any suggestions or changes you can recommend.  i would not like to assign them manually.I appreciate this group’s assistance very much. @Evan G 

I’m trying to build a script that will create a new customer via REST API. I’m running into issues with linked entities not shown in the Web Service Endpoints form yet I need to pass a value for them. For example, I receive the following error message. 'error': "Inserting 'Location' record raised at least one error. Please review the errors.; CSalesAcctID: 'Sales Account' cannot be empty." However, I’m not sure how to resolve this issue when I’m sending a PUT method to Acumatica with the following parameters.    },    'Location':{        'CSalesAcctID': {'value': 60030},    }, I noticed that Location was not listed as a linked entity in the Web Service Endpoints list. How am I able to make the connection to Location if it’s not a part of the endpoints list?

Good day everyone,We have a client who is experiencing issues with the function of correcting the Shipment.The Shipment was confirmed by Accident. No Billing or inventory transaction has been taken place.The Sales Order is Completed. When I try to recreate the problem in Sales Demo environment. (Same settings on Order type etc), it works.The User hits Correct Shipment (myself included in that environment) and it says the Operation was completed. Yet, the status doesn’t change to Open as it should: Anyone ever experienced this?

HI, I have created a Item with UOM as CTN. I need to change this to BOX. I checked this, if I have any Transactions system allow me to change Sales and Purchasing Units. Then system created a conversion between both two unit of measures.  Tested scenarios attached with screen shots. 01). As mentioned Item Base unit is “CTN” and Sales and Purchasing UOM are “BOX”.Created a sales order and Order line has taken UOM as BOX then Shipped. Shipping Lines Considered UOM as BOX.  My Questions are:(01). If I change this over to a conversion rate of 1, and change the Unit of Measure, what will the implication be when we sell and purchase this item? Is it going to create a mess in the background with regard to the costs, or the average cost? (02). Is there any other validation or concerns about the UOM changes? RegardsNethupul   

Hi, I want to ask , is it available for input batch number of product in stock items menu ?

sd

I am having this error on Import for POs, trying my best but still error is there. I have a few “=iif([PO Line Status]='Canceled', TRUE, NULL)” that may be causing this issue, but according to me those are correct.Let me know if somebody have had this issue before, or maybe I need to open ticket.Thank you community.

Hi All, I am trying to create a report that can show what is our running balances on sales to meet our quota, i use invoices and memos as my references for the report, and group it by doc type, and on the formula for the running balances is =IIf([ARInvoice.DocType]='CRM', 10000000+SUM([ARInvoice.CuryLineTotal]), IIf([ARInvoice.DocType]='INV', ((10000000-SUM([ARInvoice.CuryLineTotal]))*(-1)), IIf([ARInvoice.DocType]='DRM', ((10000000-SUM([ARInvoice.CuryLineTotal]))*(-1)), 0)))how can i end up on the correct report for this  

Is there a tool or integration to allow you to have a form on your company website that will feed into leads in Acumatica?   We have Hubspot and have that integration for syncing leads but wondering about capturing leads from our website.   Acumatica says it can be done but I haven’t found if there is an integration directly into Acumatica from a web form on the website.

I’m struggling getting the Employee ChangeEmployeeID Action to work.  In Postman I’ve setup the following:Verb: PUTURL: <host>/entity/Default/20.200.001/employee/ChangeEmployeeIDBODY:{"entity": {"EmployeeID": {"value": "{OldEmployeeID}"}},"parameters": {"EmployeeID": {"value": "{NewEmployeeID}"}}}I’m receiving the following error: "Specified argument was out of the range of valid values. Parameter name: Invalid uri structure"Does anyone have a working payload for this action?Thanks in advance

Hi community team, We see there is "Check Register" screen in "Payables" menu. Is there also "check register" possibilities in "Receivables" menu?

Unable to load files from this location.  

I would like to run an accounts payable aging report grouped by types of vendors (operations, general & administrative, landlords, etc.) Not sure if I should be using vendor class or creating separate vendor attributes. I didn’t see a filtering or grouping mechanism in the A/P aging report selection criteria.

Hello all, Is there a way to make in input field that currently takes decimal number to take only a whole number?  We have a few fields that are only used to record output quantity and scrap.  To reduce errors i would like to remove decimal places as we would never scrap part of something.  example We output 16 we scrap 3. Thank for any help you can provide.

Needing to change all customer profiles FOB point to a certain ID. We were able to change the description but need to change or delete the ID. Any suggestions? Thanks!  

Customer created a Credit Memo with an Inventory Return.  They need to reverse this Credit Memo and associated inventory receipt.  Is there a way to initiate the inventory issue with a Debit Memo, or does the inventory have to be handled with a manual adjustment? Thanks!Luke