Solved

Hi,What would be the best way to reverse the code below so that I can update the original DAC field with the custom DAC field? The reason for this reversal is that I created the new custom field to replace the original Description field. This is because I wanted the descripition field to hold 4000 characters, but reports would still be pulling it in as having only 250 characters since I didn’t update the SQL. Now that I realise my mistake of not updating the length of the description field via SQL, I will need to reverse the code below so that I can move the text back into the original description field as this custom field is no longer needed. Kind regards,Andrew protected void PMRevenueBudget_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { PMRevenueBudget row = (PMRevenueBudget)e.Row; if (row is null || row.Description is null || row.Description == "") return; var value = row.Description; cache.SetValueExt<PMBudgetExt.usrDescriptionExt>(row, value)

Is there any setting or upcoming feature that will allow our customer to only pre-authorize the credit card for the amount being shipped when using the Create and Authorize process screen?I saw a pay by line option on the customer record but that did not seem to alter the pre-authorized amount, it always captures the whole sales order.Our client processes an incredible amount of SOs daily, many of which have back ordered items. Their clients are upset that their credit is tied up by pre-authorizations for the whole order, especially when some of the orders had shipments that were future dated.I know the pre-authorization falls off after a few days but their clients are still upset.

I’ve been trying to build a subreport (basically a copy of the trial balance report) that would pull the 12th period ending balances for each account and pass that value to the standard Trial Balance. I can get the subreport to show values if I run it directly but the value never shows on the original. Am I missing something or is there an inherent problem with trying to get this value into the same report? I’ve attached the report (GL632EMS) and subreport (GL632e99) to this topic. If anyone can point to me what my issue is I much appreciate the assist!

A customer is using the kit assembly with multi-evel kits. So to create a kit the sub-kits need to be created before.Is there any automation possible like the automated (or half-automated) creation of the sub-kits in the process of creating a kit?Do you know any customer doing the same?Any ideas?I am grateful for any advice. 

Hello :) Does anyone have a good video/advice when applying invoices to a subcontract/commitment from a vendors subcontract total?? 

Hi,  Where are the settings to allow a role/user to edit the value of an item attribute? 

Has anyone seen this?  I don’t know how to explain this?This pdf invoice does not show correctly in the annotator panel, but when you download it, there is a section with the details that does not display in the annotator panel.  

First, I’m not a developer by trade.  However, I like challenges.  Requirements: create three UDFs within Purchase Orders (Estimation Notes (text), Warehouse Last Review Date (date), and Warehouse Shipping Notes (text)).  Two of these fields (the “Warehouse” fields) must be modifiable regardless of the state/status of the NORMAL type PO.  The third field, Estimation Notes is only used during PO creation and not modified afterwards.  All of these are needed within the Details Grid.  One existing field, POLine.PromisedDate is needs to be modifiable as described for the other fields.I created the three fields within the Details Grid. I then created an extension named mrROExtension in the workflow.  I added the all of the UDFs to the workflow extension.  I then created the Code graph managing the RowSelected base handler.  After verification and compilation, no errors.  Upon publishing to my local instance/tenant, all appears to work as desired.I would greatly appreciate Community members

Has anyone else encountered this with Sales Demo snapshot Build 22.212.0046  

We are not using WMS (yet).  How do you handle shipping pallets and pallet costs?  We have a mix of stock items that are finished goods and BOM-based goods so doing fixed overheads I don’t think would work. We have 7 different pallet sizes we have as stock items since we track inventory on them, cost and if we charge the customer for it.  We also have mixed item pallets so while we know item X is 60 to a pallet, Adding Item A, B, C, D and E may not be 60 to a pallet any more due to variations in size of the box, etc.  With our current system we have 1 stock item pallet.  The sales person enters the sales order, adds the stock items and if we charge for the pallet they enter a price.  When the warehouse picks/ships the order they add the pallet item to the sales order at $0 (unless sales person added it already with a price) and the quantity of pallets used.  That follows through to the invoice and shows the pallet quantity and how much they were charged (if anything). With Acumatica we

I am trying to run an Odata V4 query but have not been able to get it to workThis simple query works fine:"URL/odata/Tenant/IN-StockItem?$filter=substringof('TestItem', InventoryID) eq true" But when i add the v4 part, it does not yield any results."URL/odataV4/Tenant/IN-StockItem?$filter=substringof('TestItem', InventoryID) eq true"Is the above V4 syntax wrong?Is there something that needs to be enabled in order for Odata V4 to work?I ensured the user has the ODatav4 User ( Access to data exposed via OData v4) role assigned.  

Hi @everyone. I would like to map my stock item’s Pending cost to the BigCommerce Inventory cost.  But I can’t find the right source field for it.   Thank you.-Bernadeth

Hi @all,Have been trying to configure Automation Schedule to email statements. When I select Bi monthly which is the statement cycle ID set up for my customers no records come into view as shown;- What actually causes this? And again what if I continue configuring the automation schedule, will it be able to email the statements even if no customer records appears? 

Hi,I need to change the attention field on an email notificaiton template.I need to include the bill-to info → account nameHowever, everything I try only gives the account info → account nameIs it possible to get to the bill-to info account name in an notification template? These are all of the fields I have tried and do not work -  ((DefaultCompanyContact.FullName))((DefaultCompanyContact.BAccountID))((Customer.DefContactID.FullName))((DefaultCompanyContact.MemberName))((DefaultCompanyContact.FullName))((Customer.AcctName))((Customer.BillCustomerID))((Customer.BillLocationID.Descr))((Customer.BillLocationID.DefContactID.FullName)) ((Customer.BillLocationID.DefContactID.MemberName)) ((Customer.BillLocationID.DefContactID.BAccountID)) ((Customer.BillLocationID.DefContactID.BAccountID.SendInvoicesTo)) ((Customer.BillLocationID.DefContactID.BAccountID.BillCustomerID))

Hello,Is there a way to mass delete sub accounts so I can re-import them. I know I can use the X delete button but I am look for a quicker method since there is not a way to shift select multiple accounts.I suppose I could use an importer with the action <Delete> if there is not an simple way to complete this. 

Hi all,I need to get SOLine.POrderNbr filed to my custom smart panel . This customized smart panel consists fields of both SOOrder and SOLine DAC’s. But After adding the SOLine.POOrderNbr field, unlike other fields, it’s not visible in smart panel preview. When I checked SOline DAC, it shows that the POOrderNbr field is not existing in DataBase. How can I set this kind of fields into my custom screen? Appreciate if you can help on this as well. Thank you.

Hello, I have a customer that has a holding company(100) that is over its operating company(200). We currently have the operating company (200) setup as a company with 7 branches under it. We need a way to make the holding company (100) over the operating company (200). I initially thought of creating a second company for holding company (100) and attempted to add operating company (200) as a branch. However, it seems I am not able to add an existing company as a branch under another company.Anyone else figured out the best we to set this up? 

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 :)