Skip to main content

Learn
Learn
Support
Support
Product
Community
Partners
MAP
- Marketing Automation Platform

Community
Discussion Forums

Discussion Forums

Get inspired and gain all the knowledge you need

17099 Topics

ygagnaire12Varsity I

asked in Other Developer Topics

Usage of Dialog boxes

Hi all,I’m faced to a situation I have trouble implementing. If someone has an idea, it would be nice...I have a graph (EAPInvoiceEntry) in which I have defined an action that has two purposes :first, display a warning using a dialog box, Then redirect to an other screen (graph EAPInvoiceProcess).In the code below I have used, the instructions after warning message calling are not invoked.// EAPInvoice is a custom DAC, quite a clone of APInvoice public SelectFrom<EAPInvoice> .LeftJoin<Vendor>.On<Vendor.bAccountID.IsEqual<EAPRegister.vendorID>> .OrderBy<Asc<EAPInvoice.refNbr>> .View DocumentView; [ExcludeFromCodeCoverage] [PXProcessButton(Category ="Processing", DisplayOnMainToolbar =true)] [PXUIField(DisplayName = "Accept")] protected virtual IEnumerable acceptAction(PXAdapter adapter) { DocumentView.Ask("My title", "My Message", MessageButtons.OK, MessageIcon.Warni

dcomerfordCaptain I

asked in Develop Customizations

Warning when AP Bill total is zero

Hi i cannot work out what i am missing. I want a warning not a stop message when an AP Bill is created/updated if the Total value is 0. It works but i cannot save the Bill with a zero as the error keeps presenting on save. I have tried Row Inserted but that triggers to early. public class APInvoiceEntry_Extension : PXGraphExtension<PX.Objects.AP.APInvoiceEntry> { #region Event Handlers protected void APInvoice_RowPersisted(PXCache cache, PXRowPersistedEventArgs e, PXRowPersisted InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (APInvoice)e.Row; if (row !=null && row.CuryLineTotal == 0) { throw new PXSetPropertyException("The document total is zero", PXErrorLevel.Warning); } }

donnadeskins55Varsity I

asked in Distribution

Configure a product on a blanket SO

Is it possible to configure an item on a blanket sales order?I have a customer who uses the Product Configurator to configure items on sales orders. They are exploring using blanket sales orders, but it doesn’t look like configuring is possible on a blanket SO type.

kcaldapaiFreshman II

asked in Reports and Generic Inquires

How to connect epapproval to epemployee

Hi All, I would like to ask on how to connect these two tables for report designer. What I want to achieve is to print the approver with their designation. Thank you.

BenFoyFreshman I

asked in Distribution

Purchase Orders line item status

Would I be correct in thinking that the purchase order line item status completes when received and closes when their corresponding bill is paid?

robtrainer6184Freshman I

asked in Develop Customizations

Clear Dependent Fields

I have 2 custom fields, Customer and Project, that are required. The second field is a selector that is dependent on the value that is in the first field.Customer Field: [PXDBInt] [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)] [PXUIField(DisplayName = "Customer", Required = true)] [PXSelector(typeof(SearchFor<Customer.bAccountID> .In<SelectFrom<Customer> .InnerJoin<BAccount2> .On<Customer.bAccountID.IsEqual<BAccount2.bAccountID>>>), new Type[] { typeof(Customer.bAccountID), typeof(BAccount2.acctName) }, DescriptionField = typeof(BAccount2.acctName))] public int? UsrMOSCustomerID { get; set; } public abstract class usrMOSCustomerID : BqlInt.Field<usrMOSCustomerID> { }Project Field: [PXDBString] [PXD

ChrisWeidnerVarsity I

asked in Construction

How To: Add an existing AP bill to a subcontract (retroactively)

How would you reconcile subcontracts when the AP bills were not specified a subcontract number. Is there a way to retroactively link AP bills (Open & Closed) to Subcontracts? Let me know if you have any ideas or thought on how to reconcile existing subcontracts that have this linkage issue. Thanks!

pandachan48Jr Varsity II

asked in Configuration and Installation

ECR Approval setting

May I know, when user submit the ECR and the status change to pending approve, what is the ECR approval conditions formula we have to set from approval Maps?

lawsontJr Varsity III

asked in Retail

Template Item Sync Error: Shopify supports only up to 3 product options.

Hello,I’m launching on Acumatica and trying to sync Template Items with an existing Shopify store with the same products in it already. I’m hoping to sync them up with each other. However, I’m receiving this error each time (below). Please let me know if anyone has encountered this or knows what the remedy is. Thanks! Product options could not be created in Shopify. There are 1 variant types in the MISIML template item, but Shopify supports only up to 3 product options.

SanthoshB09Freshman I

asked in Reports and Generic Inquires

How to create a GI to show Qty on Hand and Sold Qty

Hi Team,We have a requirement where we have to create a GI and have to show Qty on Hand across all warehouses and Sold Qty (Qty across all released Invoices) for stock items. We created a GI and for all new products it is working fine but for existing products the values are incorrect. I am attaching the created GI, can you please review and suggest the best way possible to achieve it.Thank you!

Laura CarpenterVarsity II

asked in Reports and Generic Inquires

Creating Report for Disabled Users

Has anyone had success in building a report to identify the system users that were disabled over a period of time? I’m looking to find a way to identify the date when a user goes from the “Active” status to “Disabled” status.

orlandonegron43Varsity I

asked in Develop Customizations

Unreachable code problem

Good day, I have a custom field to indicate if a voided payment is type non-sufficient fund, if it is, when I press release in the voided payment, I have to create a debit memo and redirect from the payment and applications screen to the invoice and memos screen. The problem is that if I try to redirect the screen, the voided payment does not release and does not save either, because the RedirectException interrups the process. Do you have any idea how can I make the transition from one screen to another having the voided payment released? invMemo.Actions.PressSave();throw new PXRedirectRequiredException(invMemo, true, "Invoice"); } return Base.release.Press(adapter); public virtual IEnumerable Release(PXAdapter adapter) { ARPayment row = Base.Document.Current; ARRegisterExt rowExt = PXCache<ARRegister>.GetExtension<ARRegisterExt>(row); var invMemo = PXGraph.CreateInstance<ARInvoiceEntry>();

martinmaJr Varsity II

asked in Reports and Generic Inquires

Report Designer Bugs - Grouping (Acumatica 2021 R2)

Hi All, I have encountering an unexpected problem from report desginer. The report is made by the exported G.I., and the G.I. actuallly have no problem at all. However, when I do the same setting in the report designer, finally there are 2-3 items cannot be grouped. I have really no idea about it. The grouping data is normally including Inventory CD, LotSeriesNbr, Site ID, and Location ID. I have checked many times the data is not problem, referring to the screenshot I highlighted it in yellow, the data is matched and same, but it comes up not grouping. Is there anything I missed out or something I need to setup in the report designer (which is different with G.I.)? I surely the original G.I. is working like a charm, but just report result is not the same. Appreicate if someone can help or advise to fix this problem. Many thanks. (Exported Excel, the data is not grouped.)

asked in Manufacturing

Change BOM Attributes QTY Required from 2 to 3 decimals

Change BOM Attributes QTY Required from 2 to 3 decimals.I know this is done in the ‘Companies’ section ‘Quantity Decimal Places’ However, this changes multiple fieldsIf we are looking to change only the ‘QTY Required’ in BOMS field, and not Machine Units, Run Units, etc. Is this possible? If not, are there any other units I’m missing in my list to determine impact? (Machine Units, Run Units, QTY Units) Thanks!

markagnewFreshman I

asked in Construction

Revenue Projections for Time and Material Projects

Hi there,We use the construction module and have started to use Cost Projections to determine our cost at completion, which works well on fixed price projects billed as Progress Billings. I am wondering Acumatica has the ability to Auto-Project Revenue based on the projects billing rule and cost projections (similar to the Auto-Budget Revenue feature)?Since I have not been able to find this feature, I am seeking a best practice to project revenue based on the cost projection feature in Acumatica. Any thoughts would be appreciated.

martinmaJr Varsity II

asked in Reports and Generic Inquires

Not working Max & Min (Aggregate Functions) in Report Designer

As per subject, I have tried to use Max & Min Aggregate function in Report Designer. Screenshot like below, no matter I use Max or Min, the resulted value is same, it does not capture Min or Max value, but just the first data value. Also, I tested with same formula in GI, it is no problem at all. Seems this is the Report Designer bugs.