Discussion Forums

In Expense and Receipt screen (ScreenId=EP301020) “Project/Contract” field present.User can select Projects.In this selector popup we need to add customer name and service order nbr field.I can add customer name but not service order nbr. (No error - No column)Code for customization:[PXDBInt] [PXUIField(DisplayName = "Project/Contract")] [PXDimensionSelector(ContractAttribute.DimensionName, typeof(Search2<Contract.contractID, LeftJoin<EPEmployeeContract, On<EPEmployeeContract.contractID, Equal<Contract.contractID>, And<EPEmployeeContract.employeeID, Equal<Current2<PX.Objects.EP.EPExpenseClaimDetails.employeeID>>>>, LeftJoin<PMProject, On<PMProject.contractID, Equal<Contract.contractID>>, LeftJoin<PX.Objects.FS.FSServiceOrder, On<PX.Objects.FS.FSServiceOrder.projectID, Equal<Contract.contractID>>>>>, Where<Contract.isActive, Equal<True&gt

I have a need checkbox(UsrFieldName) to the Request Screen RQ301000. I need to add FieldUpdated Event to itRQRequestEntry is the main DAC  public class RQRequestEntry_Extension : PXGraphExtension<PX.Objects.RQ.RQRequestEntry>   {   #region Event Handlers   protected void _(Events.FieldUpdated<RQRequest> e) -----→ How can I update this Line   {        }   #endregion }

I’m adding a Vendor ID selector to the Stock Items screen.  I’m trying to use an existing VendorActive attribute so I don’t have to create the PXSelector from scratch.In project editor, the custom field shows a TextEdit, not Selector.  I tried editing the ASPX to make the field a PXSelector, but I get this error when I try to use the field:This is my DAC field.  I used the same “technique” as in the Acumatica training course, but does not work.public sealed class CBInventoryItemExt : PXCacheExtension<PX.Objects.IN.InventoryItem>{ public static bool IsActive() => true; #region UsrItemVendor [VendorActive(DisplayName = "Item Vendor", DescriptionField = typeof(Vendor.acctName))] public int? UsrItemVendor { get; set; } public abstract class usrItemVendor : PX.Data.BQL.BqlInt.Field<usrItemVendor> { } #endregion}Nothing is ever easy for me.

The COGS for a drop ship sales orders is the purchase price received.  But is the vendor invoice is received with a different amount  we would like the PPV to be applied to the COGS of the sales order.  We have setup COGS to use the customer location sales subaccount and set the PPV to apply to the Inventory Account,  When we process the AP Bill it creates the Inventory Adjustment but it cannot be released until the Sales Invoice is released   - no idea why this is required because the COGS was the PO cost and not the PO cost + PPV.

Client is migrating from Microsoft Dynamics GP to Acumatica, and we are trying to find the best approach for maintaining pricing. Dynamics GP isn’t particularly powerful when it comes to pricing, but it has a feature wherein it will calculate the selling price as a “percent of list price”. Each custom is assigned a “price level” (similar to a customer price class in Acumatica), and each “price level” is assigned a percentage for each item.Clearly, this functionality can be achieved with Price Worksheets, but that involves some additional work, and it would not reflect a change of “default price” real-time. Has anyone encountered this scenario and solved it with base Acumatica functionality? We are trying to avoid Price Worksheet updates (a lot of room for error), ISV solutions, and customizations.Additionally, we need the Unit Price to be set to the correct amount. A “line discount” is not desirable for several reasons, mostly focused on the user experience in the SO screen.

Hello,In the Web Service Endpoint screen in 2020/R1, when I click on Validate Endpoint for endpoint Default/18.200.001, it executes for about a minute, then fails with this exception:Exception of type 'System.Web.HttpUnhandledException' was thrown. PX.Data.PXNotEnoughRightsException: You don't have enough rights on 'Select'. …Can anyone please shed some light on what is happening?  

There are several S3 Compatible Providers as alternative to AWS for significantly lower costs.   Has anyone had any success is enabling one as an external storage provider in 2024R1+ SaaS environment? I am specifically looking at Wasabi or Vultr as alternatives to AWS or Azure.    

Hello all,I have a column for Qty in my import file and the goal is that value to be imported should by Qty/3.I entered the same forumla in Import routine but it triggered the following error:Cannot perform the '/' operation on System.String and System.Int32. How to resolve this?

Hello-With the Subitems feature being phased out, is there anything in the product pipeline to replace this loss?Primarily our manufacturing customers are looking for Revision tracking at the stock item level.Cheers,Chad

When there are multiple estimates on a quote and only one or two of the items estimated are ordered, you have to remove the estimates for the items not being ordered from the quote before raising the sales order.  This means losing the connection to the quote which can create problems if the customer subsequently wants to order those items.  It would be better if you could simply select the won estimate at the point of raising the sales order so that the quote remains as it was when sent to the customer. Have we understood this correctly or do others have this same problem? if so how do you handle this.

Per the documents I am trying to compile one screen, however I get the following error.PS C:\Program Files\Acumatica ERP\ACU-1\FrontendSources\screen> npm run build-dev -- --env screenIds=AR301000> screen@0.1.0 build-dev> cross-env node --max_old_space_size=6144 --optimize_for_size --stack_size=6144 --trace-warnings ./node_modules/webpack/bin/webpack --progress screenIds=AR301000[webpack-cli] 'screenIds=AR301000' is an invalid value for the --progress option. Only 'profile' is allowed. I have tried both folders  “FrontendSources\screen\” & “FrontendSources\” Attached is all text from my console with many different attempts, some successful when “npm run build-dev” is run, others not.

I’m trying to add a currently existing tables to a screen as a new DAC. I’ve got it added in the code tab, but it is still not appearing as a option to add its fields.  

I need to delete a certain replenishment class from about 5K items. I want to do it via import scenario. My issue is that I don’t see the delete row command in the import builder. Is there a way to do it? 

I understand the Schedule recurring sales orders is a future consideration so wondering if anyone has come up with a workaround or customization?  A supplements company (prospect) needs the ability to setup an order for a subscription that ships the items on the subscription based on predefined ship dates.

Hi, Have you anyone migrated service contracts with a new implementation? We need to migrate service contracts but we face an issue which is if we create a service contract for a past date, and when we run billing the system creates invoices from the starting date. Since the contracts have been billed in the past, we don't want to create past invoices in the system. Does anyone have any idea about skipping invoice creation for the past period for the service contracts migrated? Best Regards,Dulanjana

Business case:Quote includes a return (Trade-In).  Equipment Manufacturing and Distribution companies - sell equipment, sometimes will take a trade-in of a used equipment.  Want to be able to put the negative qty on the quote to include the credit.  Then convert the sales quote (CR304500) to an order of type = MO.Can’t enter a negative on the sales quote Can’t convert to an MO order typeDoes anyone have a process for something like this?  Put a negative on a sales quote to include a credit/return in the quote?  

Hi, I am trying to save CustomerLocation including LocationContact.Address, the CustomerLocation gets saved but not the child object LocationAddress. I am using PUT.how to save CustomerLocation with Child object LocationContact.Address? var customerLocation = new CustomerLocation {        AddressOverride = new BooleanValue { Value = false },     ContactOverride = new BooleanValue { Value = true },     Customer = new StringValue { Value = accountingData[0].EntityId.ToString() },     LocationID = new StringValue { Value = accountingData[0].Addressid.ToString() },     LocationName = new StringValue { Value = accountingData[0].Addressline1.ToString() },     LocationContact = new Contact(),     Active = new BooleanValue() { Value = true }, }; customerLocation.LocationContact.Address = new Address() {     AddressLine1 = new StringValue { Value = accountingData[0].Addressline1.ToString() },     AddressLine2 = new StringValue { Value = string.IsNullOrEmpty(accountingData[0].Addressline2) ? str

I created a simple new screen. Its pretty much the same as the T210 screen from the open university with some different field names. I reviewed it with my team in my local test environment and they want to add another field to it. i added it to the sql table and then tried adding it to the DAC and it errors out saying that the table already contains a definition for that field. error message CS0102. is it possible to add a field to this DAC after publishing, or will i have to start over? i can add the field using “add a field” in the customization project and it contains USR at the front, but when i do it that way, it wouldnt let me use that field in the field updated event where i was adding information for the other fields. i tried adding it to the DAC in visual studio and in the customization project. Can someone tell me what i am doing wrong? 

A client has the following requirements:All work centers have finite capacity except the Drying process the drying process can continue all day without any restrictions to how much product can be dried in a dayI have tested Finish Time, Move Time and Queue time - but these times only consume from the available capacity of the work center. I have read the Wik and whitepaper on APS, but not quiet sure how to setup for this requirement. Anyone has a similar process working?   

We have recently started using PO approvals which work great except that anyone can print the PO before it’s approved and then send that to the vendor which defeats the purpose of having approvals at all. Is there anything our of the box that can restrict printing a PO until it has been approved?

Did the credit memo process change with version 2024 R2?  I can’t add return lines as previously done in R1 version.  Thanks! 

Hi. Is there any Rest API in Acumatica that returns the AP Vendor Balance? This value is not available in the vendor table so not sure how to expose via a GI and can’t find a Rest API that has it.  Thanks!

Hi Everyone,Is it possible to print: 1x pick ticket, 1x packing list, 2x Shipment Confirmation , 2x Label per order ?Thank youJennifer 

For a particular screen in the user interface, is it possible to see the currently active graph extensions? I am trying to see how a particular field behaves but there is nothing in the graph code that seems to implement this behaviour, so I guess it must be an extension somewhere, and finding extensions is difficult.You can see currently active DAC extensions in the DAC Schema Browser, so I hoped there would be something similar for graphs.Thanks,Ben.

Hello All,  We are trying to figure out if there is a way to switch the cash accounts for all existing vendors in Acumatica? We have all new vendors set up to default to this new account but need our existing vendors to also be switched to this new default account. Thanks!