Discussion Forums

Dear All, I just joined the community and wanted to say Hello to everyone here. Heard great things about the community from others. Global PayEX is a Acumatica certified ISV that provides #Account Receivables and #Account Payables automation from an integrated platform. Customers can pick and choose components that serve their needs. We are JP Morgan invested B2BPayments finctech , we work very closely with VARs to bring combined value to our customers, and very importantly, we have live & happy Acumatica customers. I lead the business in the US, so feel free to reach out if you / your customers are looking to bring world-class automation in their B2BPayments areas i.e., Collect money faster, reduce #deductions and #disputes, apply cash faster to realize reduced DSOs and improved #Working Capital

I got this error when i validate a Default endpoint without any extension, same with Admin user.Why?Thanks 

Is there a way to set up Automatic Packaging by Vendor? Example, 5-gallon pails automatically select NONE for the Box ID as we stopped shipping them in boxes.Except, Amazon requires their order be shipped in a box. Is there somewhere I can set a filter that if the order is from Amazon, to use 5Gal as the Box ID? 

I have created a customization that adds a tab to the Stock Item screen. The tab contains a grid with a field with autonumber  attribute. Manually everything work find I can add multiple lines to the grid, but imports only add one line and then stop. The grid has a custom dac and view. Below is part of the dac:public class PAFactoryQuote : IBqlTable{  #region RefNbr  [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = "")]  [PXUIField(DisplayName = "Ref Nbr")]  [AutoNumber(typeof(PAQtSetup.numberingID), typeof(AccessInfo.businessDate))]  [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)]  public virtual string RefNbr { get; set; }  public abstract class refNbr : PX.Data.BQL.BqlString.Field<refNbr> { }  #endregion  #region InventoryID  [PXDBInt(IsKey = true)]  [PXDBDefault(typeof(InventoryItem.inventoryID))]  [PXParent(typeof(SelectFrom<InventoryItem>.              Where<InventoryItem.inventoryID.IsEqual<PAFactoryQuote.inventoryID.FromCurrent>>))] 

Hi, I need help.I have create Inventory ID and Linked with formula but when I want make production order I fill the code but cant pop-up    Thank you

Is the Source Restrictions tab on Import Scenarios ignored if the import scenario is fired by a business event?  I have an event that is triggered by an action on my GI.  The event can do two actions.  One of those actions isn’t always necessary (if the BE detects a cost discrepancy, it creates a cost adjustment).  I have the cost adjustment import scenario set with a Source Restriction of the cost difference field being anything but 0, but it continues to create $0 cost adjustments when the event fires.It’s not the end of the world; the $0 cost adjustment does nothing other than create unnecessary adjustment and batch documents.  But I’d like to have it stop doing that if it doesn’t need to create the adjustment.

I've created an import scenario to generate shipments to suppliers in connection with a business event, but it doesn't work. I also tried using a data supplier (Excel file) and got the same error message. However, the supplier has been created in the database, and I can create the shipment manually without any problem. 

Hello all.I have been working on ARM report & I have an individual GL Account that has figures in both Debit & Credit but different set of trxns. I’m looking to post the debit side of the amount under Expenses section & the later into Credits - Income. Kindly lmk how we can achieve this?

Hi Team,While releasing the “ Inventory Receipt”, I am getting the error ” GL Error: Missing Account Mapping for Branch 'CAPITAL ' and 'PRODWHOLE '” . Kindly suggest the missing one here.

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?