Get inspired and gain all the knowledge you need
Recently active
Our invoice form contains a gif with our address that has a typo in it. I would like to replace the image. However, when I go into report designer, click on the image (which is a picture box) the properties, Data shows “Database” and I cannot determine where that image would be located. (see screenshot attached) Does anyone know how to find and change a database image in a form in report designer? At the moment I am working with form SO643000 but would have to make the same change in a few other forms. Any feedback would be helpful.
i’ve noticed that more and more screens have the ability to add a UDF but i have not seen it on the Employees Screen (EP203000). i have a few customers who want to use schema objects that are not available to be used on the traditional attribute tab.also, if attributes are considered deprecated and no more improvements will be made, it would be helpful to have the option to create a UDF
I’m trying to use the PutFile method (https://help-2020r2.acumatica.com/(W(8))/Help?ScreenId=ShowWiki&pageid=591def3d-5fe5-42c1-bb35-cfe5b4c77f6f)I am using version 23.109.0023 and here is my code: public async Task HandleAsync(WebhookContext context, CancellationToken cancellation) { using (var scope = GetAdminScope()) { try { if (context.Request.Method == HttpMethod.Post.Method) { using (var result = new JsonTextReader(context.Request.CreateTextReader())) { if (result.Read()) { JsonSerializer serializer = new JsonSerializer(); ObjectJSON test = serializer.Deserialize<ObjectJSON>(result); var bytes = Convert.FromBase64String(test.Value); StreamContent
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
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); } }
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.
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.
Would I be correct in thinking that the purchase order line item status completes when received and closes when their corresponding bill is paid?
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
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!
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?
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.
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!
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.
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>();
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.)
