Solved

Is there a simplier way to backfill box 7 on existing AP bills once a vendor becomes 1099-eligible?  AP Bills that were created before vendor became 1099-eligible shows blank, while the AP bills created after vendor became 1099-eligible shows box 7. Currently i have to open every bill and add box 7 manually, which is a huge waste of time.

Hello experts,I have been trying to add a dropdown list to a new processing screen but, the list isn’t getting displayed. I have shared the dac and graph codes below. Please guide me out where i am getting wrong.Thanks in advance.Dac code:using System;using PX.Data;namespace MassCust{  [Serializable]  [PXCacheName("Mass_Activity_Table")]  public class Mass_Activity_Table : IBqlTable  {    #region Activities    [PXDBString(50, IsUnicode = true, InputMask = "")]    [PXUIField(DisplayName = "Activities")]    public virtual string Activities { get; set; }    public abstract class activities : PX.Data.BQL.BqlString.Field < activities >  { }    #endregion    #region Source    [PXDBString(10, IsFixed = true, IsUnicode = true, InputMask = "")]    [PXUIField(DisplayName = "Source")]    public virtual string Source { get; set; }    public abstract class source : PX.Data.BQL.BqlString.Field < source >  { }    #endregion    #region Cust_Lead_ID    [PXDBString(IsUnicode = true, InputMas

Hello,Is there a way to setup an Alert or Notification that will let us know that inventory has dropped below a certain level with Acumatica. Thanks,Nelson

Hello All, I have a Field updated Event Handler that calls a method. It works fine until the change to the field comes from a PXLongOperation. To be more specific, on APInvoice the status field is updated by the different actions. All actions and status changes are monitored just fine until I Release the document (Status changes from Balanced to Open). This is when the handler misses the change possibly because it is running in a separate thread/scope. Below is the Handler I have. How can make the handler listen to the change from PXLongOperation too?protected void _(Events.FieldUpdated<APInvoice, APInvoice.status> e){ if (e.Row == null) return; SyncStatusTransitionLog(Base, e.OldValue, e.NewValue);} 

Has there been any update that will let us print the 1096 form in Acumatica? This form is used in conjunctions with Form 1099 filed with the IRS. The only topic I can find was from 2 years ago, but the links for help lead to a topic that is unrelated.

Hi there,I am trying to make a relationship of Freight details so that I can put the line total on the invoice but I think my relationship is wrong, could someone help please  

On my custom page, I have an action to open the Recalculate Customer Balances screen (AR509900)        public PXAction<RecordsToProcessFilter> Rebuild;        [PXButton(CommitChanges = true)]        [PXUIField(DisplayName = "Rebuild Accounts")]        protected virtual IEnumerable rebuild(PXAdapter adapter)        {            var graph = PXGraph.CreateInstance<ARIntegrityCheck>();            throw new PXRedirectRequiredException(graph, false,                    "Rebuild Accounts");        } There are two versions of this screen.  The new one and the (old) one.When the graph gets instantiated, the highlighted line sees the screen being called from IC501010, not AR509900.  Thus, it kicks me to the else section and uses the OLD way of doing it.  It actually opens screen ID AR509901.  The arReleaseGraph actually errors out when recalculating a customer in the U100 sample data, whereas the new way does not.  Plus, the new way is a LOT faster.protected virtual void _(Events.RowS

 Hi,We need to add created by user name into payment voucher report is acumetica.We try to join ApPayment and Users Table.ApPayment has CreatedByID and User table has username field.Below screen shots attached for the reference.ApPayment TableUsers Table We join these table using report builder below like that.After the report complied it shows below error. Because CreatedById is uniqueidentifier type and user name is nvarchar type. Can you give the solution to get createdby name for the apPayment transactions is Payment Voucher Report.Thank you

Hi All, I want to stop adding new lines to a sales order based on a condition. How can I do this.?I tried adding the following. But It did not worked.  protected void SOLine_RowInserting(PXCache cache, PXRowInsertingEventArgs e)  {            var row = (SOLine)e.Row;            if (row == null) return;            //Condition            if(Condition == true)           {                       Base.Transaction.Delete(row);            }   } 

I have a custom table that stores the customer ID of customers that have been merged in my “Merge Customers” application.  After customers get merged, I want to automatically select them to be processed on the Recalculate Customer Balances screen.  After merging, it is just simpler to let Acumatica calculate the new customer balances than to do it myself.I created an extension for that graph.  The idea is that I redirect to this screen at the end of the Merge Customers process and the user simply has to click PROCESS on the screen as all the affected customers would be selected already.In the extension, I thought I could use the RowInserting method on the grid to check the box on the line if it was in my custom table.  That line doesn’t fire when the grid is being filled from the related View. I also tried FieldVerifying on the Customer field of the grid (and a few others) but they don’t fire unless you actually interact with the grid.Just to try to get something to work, I committed a

Hi, I’m trying to create a unit test for my Extension Library, but retrieving a DAC Extension always returns null for some reason. I followed all the steps in T280 course but I still can’t get the DAC Extension. I am currently trying to create unit tests for version 22R1. Here is the code snippet: using Xunit;using PX.Data;using PX.Tests.Unit;using PX.Objects.CA;using Custom.DAC;using PX.Objects.GL;namespace Customization.Tests{ public class CashAccountMaintExtTest : TestBase { [Fact] public void TestingCashAccountExtension() { Setup<CashAccountMaint>(new GLSetup()); Setup<CashAccountMaint>(new CASetup()); var graph = PXGraph.CreateInstance<CashAccountMaint>(); CashAccount cashAccount = (CashAccount) graph.Caches[typeof(CashAccount)].Insert( new CashAccount { CashAccountCD = "Test" } ); //This

We have a generic inquiry for Move where we display the AMBatch Total Amount and the INRegister Total Cost. We are currently only using final moves from WIP into Inventory, not from operation to operation.How/When is the AMBatch Total Amount populated?  Why are so many zero?Acumatica Build 22.115.0035Valuation Method: AverageProduction Order Costing Method: EstimatedSee attached snipping of our Move GI 

Has anyone successfully recreated the Inventory Valuation report as a GI? We currently have 181614 stock items and each one has more than likely touch multiple location. This leads to multiple entries on the inventory valuation report which then leads to a large document which can be a little annoying to parse through and analyze. I’ve been trying to recreate the report as a GI, but so far have remained unsuccessful. I’m open to any ideas!

Hello,This is what displays as my Linenbr, which seems to follow the line nbr of the list inside the system, I want it to count the line in this print though. Where should I edit this? Thanks a lot!

Hello Hello, I have a custom field on POOrder  named “additionaldescr” (Usradditionaldescr).I want to bring this field value to POReceipt which also have the “Descr1” (UsrDescr) when creating Purchase Receipt by click button “ENTER TO RECEIPT”. After that I would like to carry again “ Descr1” field to APInvoice which have the “Descr2”(UsrDescr2) by clicking Enter AP Bill.The goal is like this. POOrder » POReceipt» APInvoice . Can someone help me please. Best Regards,May

Hello fellow Acumatica Users! :)Do any of you know on the Construction>Revenue Budget, what the “Pending Invoice Amount” represents?  Right now, we have an “Original Budget” of $1,090 and a “Pending Invoice Amount” of -$1,090. Thanks in advance!Kay

I have a UDF UsrCustomerID.I originally used this for my DAC        #region UsrCustomerID        [Customer]        [PXUIField(DisplayName = "Customer")]        [PXRestrictor(typeof(Where<BAccount.parentBAccountID, IsNotNull>), ICSMessages.ParentAccount)]        public virtual int? UsrCustomerID { get; set; }        public abstract class usrCustomerID : PX.Data.BQL.BqlInt.Field<usrCustomerID> { }        #endregionI wanted to have access to the DescriptionField of the selector, so I tried this (which works)        #region UsrCustomerID        [PXDBInt]        [PXUIField(DisplayName = "Customer")]        [PXSelector(typeof(SearchFor<BAccount2.bAccountID>.            Where<BAccount2.type.IsEqual<GetICSCustomerType>.            And<BAccount2.parentBAccountID.IsNotNull>>),                typeof(BAccount2.acctCD),                typeof(BAccountCRM.acctName),                SubstituteKey = typeof(BAccount2.acctCD),                DescriptionField = typeof(BA

MRP is indicating to buy 5,000 units of 173L8100 STK with the following action and promise dates. I have created two POs, one for 2,500 (promised on date of Jan 5, 2023) and another for 2,500 (promise date of Jan. 11, 2023). I have regenerated MRP but those two lines remain on the MRP Display. Why do they remain? When should they disappear from MRP Display?

We are not having a great experience using the ACM Payroll module and are looking to move to another service that integrates with AMC… Does anyone have any suggestions? We pay twice a month (15th & 30th) and commissions on the 20th. Any suggestions would be appreciated!Thanks in advance!  

Hi Team Acumatica,We have recently implemented acumatica. For employee salary processing is there any integration available for acumatica with Wise/Payoneer/Veem platform?? Best Regards,Jewel

Our customer would like to keep track of their Vendor Prepayments that are outstanding.  They make the prepayments using the Purchases screen.  When the payment is made it doesnt track to the Purchase Order any more.  Their vendors require prepayments for almost every Purchase Order so doing it by vendor will not work.  Has anyone had to do this?

Hello,I’m not using any filter because I’m not using any parameter, how can I format this in RD visible expression so that I can only display the same name once? Thanks!

Hello everyone,I want to compare what I’m charging for shipping versus what I’m paying for shipping.  SOSHIPMENT - CuryFreightAmt, is not equaling SOOrder - CuryFreightAmt, I’m not sure why, so I’m trying to add SOrder - CuryFreightAmt to the Shipments GI.  I’d like to connect them by the original order number, which as far as I can tell, does not exist in SOShipments.  So I’m trying to use either SOShipLine - OrigOrderNbr or SOOrderShipment - OrderNbr to build the relationship.  I can get it all set up, except the GI is showing duplicates and I’m not sure why.  Please help.  

Can we have a “Business Account” that is not a customer or a vendor?  We have a need to have in Acumatica persons and companies related to our business but that are not customers or vendors. “Regulators” are an example.  Other examples are trade associations.  Can these types of person and companies be “Business Contacts” but not customers or vendors? 

Hi All, Our company is looking for a custom daily report which runs automatically in the evening and distributes to a email list. The report would consist of all the SO’s entered in that day. So first, what would you recommend for a GI build? A simple copy and customization of the Sales Order screen and then just setting up a automated schedule?