Solved

Hi all,I'm trying to include an uploaded jpeg image of a stored item to be invoiced on the standard AR641000 form. I've carefully followed an example in the Acumatica S150 Reports Designer document - (See attached Training Doc1 & Doc 2, pages 30-34.). I have checked and rechecked,  but continue to get the following error.  (See Trace 1 attached).The problem seems to be with the table / table join of the Inventory Item. (See attached schema build.Any assistance would be very much appreciated.Thanks

Why do we get “You can’t delete the last link” message when we try to delete/remove an attachment on our BOM or Item?  In the screenshot we are trying to remove 10004893.pdf because the other file is the newest one.Message: You can’t delete the last link 

Good dayI am trying to filter the warehouse selector on the following screens on the sales and purchase order screen.This filter would either occur by branch or company based on the users selection on the custom fields brought in on the Inventory preferences screen.I am not sure how to filter the selector in the graph based on the user selection.Please see my code attached protected void SOLine_BranchID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler) { if (InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (SOLine)e.Row; INSetupExt extINSetup = row.GetExtension<INSetupExt>(); //retrieve current branch SOOrder SOOrder = new SOOrder(); var currentSelectedBranch = SOOrder.BranchID; //See what condition is selected //If filter by branch is selected, based on the branch selected in the financial tab, //

I am using Acumatica Payroll with Construction.  I am not seeing the union benefits along with the raw hourly rate by hours being distributed to job cost jobs.  I have reviewed all the settings and do not see any action that would facilitate this process. Any suggestions. Thank you in advance

Hello,I want to know if i can get the action name of the pressedaction in the screen from graph by code.Best regards.

How do you set up SMS / Mobile Notifications?  Is there a document that shows us the steps?  

Hello I have an action button that needs to be conditionally available after the quote approved checkbox is selected from the opportunity then this box “conver to project” needs to be conditionally available. I was provided a sample code, but I am unsure of how I use it?  Would I create a project, and create a new code with it?  protected virtual void SOOrder_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler){InvokeBaseHandler?.Invoke(cache, e);SOOrder row = e.Row as SOOrder;if (row != null){if(Condtion){ActonName.SetEnabled(true);}else{ActonName.SetEnabled(false);}}}

I noticed an open credit adjustment in the system and no bill to apply it to. How do I close?This is off topic . . . does anyone know how to create a weekly transaction report in Stripe? I find it tiring to scroll through all the payments/refunds when all I need is the last 7 days. Thanks for your help!

Has anyone had an experience with a government agency utilizing the customer portal to place orders? We produce and sell medical equipment to the military and are looking to simplify the ordering process but with the government’s security level we aren’t sure if they will be able to use the customer portal. Any advice? Thanks!

I’m looking to add a "Date of Service" column to the Services > Invoice > Details grid.I'm trying to add a column on the Details tab of the Invoices screen to show the Appointment Date for charges listed on the Details tab. It pulls this information just fine on one of my reports (relationships shown on the bottom row, Left join FSARTran to FSAppointment, in the attached image), but when I duplicate this join (the FSAppointments table to FSARTran) in the Generic Inquiry for the Invoices page, the fields are all there, and it saves with no errors, but it begins generating errors for our users. Anyone know how to add a column for Appointment Date to the Details tab of the Invoices screen?I found the info (see image) for tying the Invoice to the Appointment Dates in the report file SO643000.RPX. All the fields seemed to be there and the tables appeared to add and relate without error. However, once I clicked Save, the system began generating errors when attempting to populate the In

In my code I’m looking to see if an invoice already exists before proceeding.  I was using this query: ARRegister invoice = PXSelect<ARRegister, Where<ARRegister.docType, Equal<Required<ARRegister.docType>>, And<ARRegister.refNbr, Equal<Required<ARRegister.refNbr>>>>>. Select(this, receiptRow.ApplyToDocType, receiptRow.InvNbr);But it would not find the record.  I confirmed that it is in the ARRegister table (local install, local database).So I decided to try this:ARInvoice invoice = SelectFrom<ARInvoice>. Where<ARInvoice.docType.IsEqual<@P.AsString>. And<ARInvoice.refNbr.IsEqual<@P.AsString>>>. View. Select(this, receiptRow.ApplyToDocType, receiptRow.InvNbr);and that worked.  It is a different table but the primary keys on both tables are the same.So, my question is, what’s the difference between the PXSelect and the SelectFrom calls? In case it matters ‘this’ is within an Action bu

I have a client using the product configurator and they want to roll up pricing based on the parent item and all the selected children options. This client uses discount pricing and the pricing of the fully configured item is subject to a discount which varies by customer. My client would like the pricing to rollup in the configurator such that the base item is discounted but the children are not. The issue is that the calculated price of parent item and the options essentially take on a new identity resulting in a discount on parent and children. Has anyone run into this issue before and how did you resolve it?

Do we have the ability to offer different Shipping Methods in BigCommerce that will be mapped to existing Ship Vias in Acumatica? Would this configuration through the Entities work well?Where do we map the Shipping Method in BigCommerce to the Ship Via in Acumatica? 

Hi Sir We would like to add in column D in column set. Anyone can guide me how to add in?  

Our implementation is such that all customers will be generated in Acumatica and pushed to BC prior to the customer logging into the BC storefront. Is it possible to push the CustomerID to BC into a customer user field? I looked into the articleHowever, it doesnt seem to allow CustomerID to be a source - nor does it seem to allow custom fields on the BC Customer object.We have some supplemental API inquiries that BC is going to do which require the CustomerID and it would be best if it were already there. Relying on the email address as a unique key when it isnt required to be unique in Acumatica doesnt seem like the right way to go.Any thoughts?

I’m not sure why but a custom field I’ve created is not showing in the grid on the screen.The new field is the Mark Up % and it shows in the Column Configuration but not in the grid. Here are the layout properties: Here is the aspx: Here is the extension code:using PX.Data.ReferentialIntegrity.Attributes;using PX.Data;using PX.Objects.AP;using PX.Objects.AR;using PX.Objects.CM.Extensions;using PX.Objects.Common.Discount.Attributes;using PX.Objects.Common.Discount;using PX.Objects.Common;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.IN.Matrix.Interfaces;using PX.Objects.IN;using PX.Objects.PM;using PX.Objects.SO;using PX.Objects.TX;using PX.Objects;using System.Collections.Generic;using System;namespace PX.Objects.CR{ public class CROpportunityProductsExt : PXCacheExtension<PX.Objects.CR.CROpportunityProducts> { #region UsrMarkUp [PXDBDecimal] [PXDefault(TypeCode.Decimal, "0.000", PersistingCheck = PXPersistingCheck.Nothing)] [PXUIField

I am working with the product configurator and I’ve come across a situation:1. Create a sales orders with a configurated item.2. Configure the item, and push to production to get it on the schedule.3. The configuration changes AFTER the SO is created but before production happens. 4. Delete the production order since the BOM has changed.What we are running into is that we cannot reconfigure the item on the SO, we have to completely delete the SO line and re-enter it to be able to do a new configuration. We are also finding if we configure, but don't push to production, and the configuration changes they cannot pick up the new configuration and reconfigure. Has anyone run into anything similar and are there creative process solutions around this? 

I have added a field to the existing SOOrder DAC in order to carry a ReasonCode.. But I only want to select records from the ReasonCode where the Usage field is equal to ‘A’Here is my selector code to display the ReasonCodeID and Descr fields..[PXSelector(typeof(Search<ReasonCode.reasonCodeID, Where<ReasonCode.usage, Equal<'A'>>>), typeof(ReasonCode.reasonCodeID), typeof(ReasonCode.descr))]  But this is the error:\App_RuntimeCode\PX_Objects_SO_SOOrder_extensions.cs(36): error CS1031: Type expected

Hopefully I explain this correctly.  On the Project Revenue Budget tab I’ve added two new fields: Unit Cost and Mark Up.  When the values in these fields change we want to update the Unit Rate.  I’m using the FieldUpdated event to do this and everything works great.  The problem is that we also want to allow the user to enter the Unit Rate manually and when that happens it needs to update the Mark Up.  This also works fine but the issue is that when the Mark Up is updated from the change in Unit Rate the FieldUpdating event on the Mark Up is called and then updates the Unit Rate again.  Currently my Mark Up rounds to two decimal places.  Because of the rounding on the Mark Up the Unit Rate is then recalculated incorrectly.  Questions:1 - Can I change my precision on the Mark Up to more than two decimal places to give me more precision and prevent rounding? If so, the how?2 - Can I prevent the code from running in the FieldUpdated event for Mark Up when the Unit Rate is changed?3- Shoul

I am working on the Task screen (CR306020).  I am able to set the Start Date to null so that the user must select a Start Date.  I want to also default the Due Date to null.Here is my code:    public class CRTaskMaint_Extension : PXGraphExtension<CRTaskMaint>    {        #region Event Handlers        protected void CRActivity_RowInserting(PXCache cache, PXRowInsertingEventArgs e)        {            var row = (CRActivity)e.Row;            //var dateAndTime = DateTime.Now;            //var date = dateAndTime.Date.AddDays(1);            row.StartDate = null;            row.Priority = null;            row.UIStatus = null;        }        protected void _(Events.FieldUpdated<CRActivity, CRActivity.startDate> e)        {            var row = (CRActivity)e.Row;            row.EndDate = null;        }        #endregion    }The RowInserting works great.  The Start Date is empty after this code fires.The FieldUpdated event fires.  I verified that the EndDate is being set to null.  B

Good day,I have added a custom field on the purchase orders screen to display the vendor class under the vendor info tab. This field will be disabled.I am trying to populate the field after the vendor has been selected on the header.Please see my code below:My DAC: #region UsrVendorClass [PXDBString(10, IsUnicode = true)] [PXDefault()] [PXSelector(typeof(Search<VendorR.vendorClassID>))] [PXUIField(DisplayName = "Vendor Class")] public virtual string UsrVendorClass { get; set; } public abstract class usrVendorClass : PX.Data.BQL.BqlString.Field<usrVendorClass> { } #endregion My Graph: protected void _(Events.FieldUpdated<POOrder, POOrder.vendorID> e) { var row = (POOrder)e.Row; VendorR vendorClass = new VendorR(); vendorClass = PXSelect<VendorR, Where<VendorR.acctCD, Equal<Current<VendorR.acctCD>>>>.Select(Base, row.VendorID); POOrderExt extPOOrder = row.GetExtension<POOrderExt

I'm trying to change the default customer location by setting to default a different location using Import scenario 

Hello,We have a client who have an in-house Exchange server and have been using Exchange Integration with Acumatica since 2018.Many emails have been synchronized between Exchange and Acumatica.They are now moving to Office 365.Does anyone have experience with this situation and able to share thoughts?  My primary question is will there be an issue when the mailboxes are migrated, where Acumatica exchange sync is unable to recognise that emails have already been synchronized (therefore starts duplicating emails)?  I believe this will also depend on which method is used to migrate the mailboxes from Exchange to 365.Thanks in advance.

how do i extract customers master file in a CSV format

Hi All, We were wondering if we are allowed to use field dependencies in Acumatica. An example of field dependency would be that if a value of field A changes, then change the value of field B. Here’s an example for better understanding: If the Tax Zone of a Business Account changes which is extended to Customer and has locations in it, then we will want to change the tax zone field for all associated customer locations as well. Please let us know if you need any further clarifications about this. Thanks in advance! Best Regards,Amruta