Solved

I am using PXFormula to multiply a qty and cost to create a new extension field in the details of Physical Inventory Review (although I would think the specific screen wouldn’t matter.) That part is working fine. However, I then want to sum that new column’s values into a new extension field in the header. I can't get that part to work.Here is the relevant detail code:using PX.Data;using System;namespace PX.Objects.IN{  public class INPIDetailExt : PXCacheExtension<PX.Objects.IN.INPIDetail>  {        #region UsrExtBookCost        [PXDecimal]        [PXUIField(DisplayName="Ext. Book Cost")]        [PXFormula(typeof(Mult<INPIDetail.bookQty, INPIDetail.unitCost>),        typeof(SumCalc<INPIHeaderExt.usrTotalBookCost>))]        public virtual Decimal? UsrExtBookCost { get; set; }        public abstract class usrExtBookCost : PX.Data.BQL.BqlDecimal.Field<usrExtBookCost> { }        #endregion  }} Here’s the header code:using PX.Data;using System;namespace PX.Objects.I

I’ve modified the sales quote to allow the unit cost to be visible and editable but when I create a sales order from the sales quote the sales order is using the unit cost setup on the stock item and not what I set on the sales quote.  I’m not sure what needs to change in order to get the unit cost on the sales order lines to match what is on the quote line.  Is that something that can be changed? If so how would I go about it?

Hi,  I’m trying to creating Inventory Class to my stock and not stock items with an import scenario using the Stock Item and non stock item screen.Has anyone successfully completed import scenario sheet regarding the Item class? RegardsNethupul

Hi, I am trying to use the “Quick Process” in an import scenario.  I am uploading a file with the SO number.  From this SO I then want to use the “Quick Process” to raise the Shipment/confirm the shipment and create the invoice.  I am unable to get this to work. Import Scenario attached.Has anyone used this successfuly?  

Checking to see if some knows if the Outlook Integration will support MS Outlook 2016?

Hello, The generic inquiry for our push notifications includes several custom fields that are only used by downstream systems. They are not really part of the account data per se. So we want our push notifications to contain these fields, but don't necessarily want changes in these fields to trigger push notifications. Is this possible? Can a generic inquiry or push notification be configured such that a notification is only sent when certain fields are changed, but not others?Thank you for your help. Best regards, Dave

I am fairly new to Report Designer and I have a requirement where they want the total of a column in the header section, this should print only on the first page and values consideredshould be where page index = page count, how can I fulfill this?

I have extended a Web service End Point to include the results using instructions from https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/. and Am using a GI as a data source with Celigo (integrator.io).  The problem I’m running into is it breaks down the GI into pages and with my  $Skip formula to chunk the data into pages. I think its because all the data is in the Detail item “Result” and it sees everything as 1 big record.  I think this because to read the results correctly I had to point the resource path to “Result”   I’m at a loss here on how to fix the issue but I’m not an expert so maybe someone here has dealt with this and can help! Thanks in advance, Greg

Hi AllCurrently, we have auto trigger customer statement to customer every month.For those over due customer , we would like to send reminder and would like to use “dunning letter send by email” May i know how to set for it?We have “tick” the “ SEND DUNNING LETTER BY EMAIL” what is the next step?Does it mean system will auto trigger to customer once the invoice is over due?  

Is there a way to retain the filters in the Calendar Board? As soon as we refresh the screen or login on the next day we need to re-apply all the filters. It would be great if these filters could be saved for a user

I cannot add the request class item list, how to enable add function?  

I am not sure if every union is like this but in the midwest they have a layoff Payoff rule. So if you are laid off a job you have to be paid when you leave the job.   In payroll with set weekly periods, there is no place to modify the check date even if it is within the period. Is the answer to set up a new calendar or am I overlooking the ability to modify the check date when a weekly period end calendar is used Thank You

Hello,     In 2020r2, we’ve had a new feature called “intercompany sales”.https://help-2020r2.acumatica.com/Wiki/(W(2))/ShowWiki.aspx?pageid=e4827607-362f-40fb-b466-303c414ee980     According to the guide, it says it can deal with “sold goods” scenario. Unfortunately, according to my understanding, it is not.       Both AR invoice and AP bill has nothing to do with Inventory.     For real intercompany goods sold, the inventory of company A which pretends to be the vendor should have qty deduction, while the company B which to be the customer should have qty increasing. And in most cases, we do real shipment. We ship goods from company A to company B. Company A do real shipment, company B do real receiving. The new feature did not take this into consideration.      So in short, can we request for a full feature of “intercompany sales”, which we can extend the PO to a SO?

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?