Discussion Forums

HiI am adding the warehouse location field to the deadstock screen.I managed to add the field and view the location for each warehouse. However the data is not filtering based on the location.I know I tried creating a graph extension to add the location as a filter but its not working. using PX.Common;using PX.Data;using PX.Objects.CS;using PX.Objects.IN.DAC.Unbound;using PX.Objects;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System;namespace PX.Objects.IN.DAC.Unbound{    public class INDeadStockEnqFilterExt : PXCacheExtension<PX.Objects.IN.DAC.Unbound.INDeadStockEnqFilter>    {        #region Usrlocation        [PXDBInt]        [PXSelector(typeof(Search<INLocation.locationID, Where<INLocation.siteID, Equal<Current<INDeadStockEnqFilter.siteID>>>>),            typeof(INLocation.locationCD),            typeof(INLocation.descr),            SubstituteKey = typeof(INLocation.locationCD))]        [PXUIF

HI New user here. We are located in Mtl and our generic dunning letter msut be in French. Where can I change the wording on a Dunning letter?

Hello all,I am trying to add a Selector attribute on a new field in order to store a vendor in a case screen customization using the Customization Project Editor. After I publish the customization, I receive the error: “Cannot create ctl00_phG_tab_t2_CstPXSelector122 control. The PXSelector attribute is missing for the UsrInst_InstallVendor field. Make sure the names of the data views specified for controls in the ASpX file match the names of the data views defined in the corresponding graph.”I have added the following attributes in the UsrInst_InstallVendor field:[PXDBInt][PXSelector(typeof(Search<PX.Objects.CR.BAccountR.bAccountID, Where<PX.Objects.CR.BAccountR.type, Equal<PX.Objects.CR.BAccountType.vendorType>>>))][PXUIField(DisplayName="Install Vendor")]Then, I create the control on the tab I have added in the Cases screen customization. After publishing, the screen shows the selector, but when clicked, I receive the error message above. Am I missing a step in my

My controller relies heavily on the Find function (search) in the report viewer. The find function used to find the first instance on the first click (or enter key) of the find button on a report, then would find the second on a secondo click/return & so on through the list. This functionality is now lost, it will only find the first instance every time you use the find, its almost as if the report is re-loading every time you click Find. I have tested this in new instances of the same build and have the same results.Has anyone else noticed this, and is there a fix for it?Acumatica 2023 R2 Build 23.212.0024  

Customer does not have the Project module installed.  So I can see how COGS gets posted to the GL by releasing the issue associated with an appointment invoice, but how does the cost of labor get posted to the GL?  How is the cost determined and when does it get posted and is there something that needs to be done in order for this to happen?  I have already added a time card for an employee and added a labor rate for same, enabled time tracking in Service Order Preferences as well and I am using a non-stock hourly labor item associated with a labor item class and choosing the above employee for the appointment, performing the appointment and closing, then run billing and release the invoice.  Still can’t see the cost of labor posting.  What am I missing?

Hello - We have a custom AR Invoice form which includes some custom fields created using a customization project. I just added some additional custom fields to this project but with the no coding method and now the previous fields are showing up on the report with an error. At first view, it produces results fine but then when I refresh the errors appear. Is there something I need to change on the customization?Here is the full error message:[A]PX.Objects.AR.CCMBSMM_ARRegisterExt cannot be cast to [B]PX.Objects.AR.CCMBSMM_ARRegisterExt.Type A originates from 'gvuedunh, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' in the context 'LoadNeither' in a byte array.Type B originates from 'titsnhbc, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' in the context 'LoadNeither' in a byte array. 

Hello - We have a custom AR Invoice form which includes some custom fields created using a customization project. I just added some additional custom fields to this project but with the no coding method and now the previous fields are showing up on the report with an error. At first view, it produces results fine but then when I refresh the errors appear. Is there something I need to change on the customization?This appears to be the full error message:A]PX.Objects.AR.CCMBSMM_ARRegisterExt cannot be cast to [B]PX.Objects.AR.CCMBSMM_ARRegisterExt. Type  

I need to know how to give someone rights/access to delete uploaded files.For example, we upload item drawings to the item’s BOM and when we have a new/revised drawing, we want to delete the old drawing and upload the new drawing.Where do I go to give someone permission to delete the file attachment???

There seems to be a bug with the Set as Primary button on an Opportunity.Here are the steps to produce:Create an Opportunity Create a Project Quote. Ensure you set its Opportunity ID to be the Opportunity ID of the Opportunity we created in step 1 Create another Project Quote and also set its Opportunity ID to be the Opportunity ID of the Opportunity we created in step 1 Use some mechanism to fetch both project quotes, I just use Postman. Note their LastModifiedDateTime’s… Click the Set as Primary button on the Opportunity for the Project Quote that is not presently the Primary one (we specifically choose this Project Quote as this is a data change and should -- at least, in theory -- update the LastModifiedDateTime of the Project Quotes) Repeat step 4. Note both of their LastModifiedDateTimes remain unchanged.Is this a known bug or planned to be fixed? Our company uses the LastModifiedDateTimes for DB syncs and this is a major problem for us. I’m aware of workarounds and plan to addre

Good day, I have a customization with 2 custom fields that are selectors called 480 Tax Line, one in Non sotck item screen and another in the lines of Bills and Adjustments; these selectors have the values from an Attribute and there is an Instance where I am having an error, everytime I choose one of the options and press save, I receive the error "Error: Updating  'Inventory Item' record raised at least one error. Please review the errors.” and then in the field it has the error '480 Tax Line' cannot be found in the system.The DAC is configured to show the description of the attribute in the UI and save the ValueID in the database, everything is working well on every other Instance I publish my customization, but in this one I don't understand why I have conflicts where everything is the same, the attributeID is APLINE and the data is the same on every other environment I have tested. public class InventoryItemExt : PXCacheExtension<PX.Objects.IN.InventoryItem> { #region Usr

Hello all! I'm looking to limit viewing of commissions between our sales people. For example, I don't want john seeing Jodi's commissions and vice versa. However, I want them to see their own commissions. This is mainly on Sales Orders. Has anyone encountered this and how was it remedied? ThanksBrent

When selecting the project in the sales order the quantities are updated to zero    

We are facing a scenario where a user needs to process a credit note while the customer's status is on Credit Hold. With EDI integration and automated warehouse processes in place, it is not feasible for the user to temporarily remove the customer from Credit Hold, process the credit note, and then place the customer back on hold.Are there any workaround for this situation?

Managing construction budgets doesn’t have to be complicated! Join us for this webinar to learn how to set up, monitor, and adjust your budgets to keep financial control in check. We’ll cover configuring budgets, tracking actual costs, making revisions, and setting up Acumatica’s budget alerts to help you catch overspending before it happens.Introduction to Project Budgeting Setting Up Revenue and Cost Budget Budget Tracking as the Project Progresses Revising the Budget Monitoring Budget Controls Reviewing Project Balances and Performance Metrics Summary/Q&APresented by Iqra Harrison | Senior Business ConsultantPROTELO, INC   

How do you get the timecards to work when they cross payperiods.  The pay periods are always 1st through the 15th and the 16th throught the end of the month.  What do you do when the time cards cross pay periods?  Manual OT calcs would be preferrable and having timecards that match the payperiod.  Has anyone gotten this to work?

Hello guys, I am having an issue with a workflow event handler:Workflow declaration:.WithHandlers(handlers =>{ handlers.Add(handler => handler .WithTargetOf<ARBalances>() .OfEntityEvent<ARBalancesCreditHoldExt.MyEvents>(e => e.CreditLimitViolated) .Is<SOShipmentEntryCreditHoldExt>(g=> g.OnCreditLimitViolated) .UsesPrimaryEntityGetter< SelectFrom<SOShipment>. Where<SOShipment.customerID.IsEqual<ARBalances.customerID.FromCurrent>>>() ); handlers.Add(handler => handler .WithTargetOf<ARBalances>() .OfEntityEvent<ARBalancesCreditHoldExt.MyEvents>(e => e.CreditLimitSatisfied) .Is<SOShipmentEntryCreditHoldExt>(g => g.OnCreditLimitSatisfied) .UsesPrimaryEntityGetter< SelectFrom<SOShipment>. Where<SOShipment.customerID.IsEqual<ARBalances.customerID.FromCurrent>>>() );})//Add to Sta

Hi Team,Any thoughts on how Acumatica handles the scenario for Importing transactions for Bank Feeds when the transaction currency is different from Cash Account currency.   

Hi I am settling up a connection to BigCommerce and have template items which are syncing with BigCommerce using the connector. I have attached images to my attributes used in the  configuration of my matrix item and would like these to sync with the Variant Options in BigCommerce. Does anyone know if this is possible please? Thanks Matt 

We have a project that is not yet approved, however there are already commitments (Purchase Orders) against it.  We don’t want Purchase Orders to be issued to suppliers before the project is approved.  How do we stop it, is there a setting somewhere?

Hi all, Our Projects could have up to 25 tasks. We bill on certain tasks by adding the amount to Pending Invoice amount and running project billing. When we do that, the invoice will have 0.00 lines for each task and 1 line for the task that we entered an amount. Is this the expected behavior? Can that be turned off? Thank you

Does anyone know of any existing functionality around archiving projects that are no longer active? I’d like to be able to archive/inactivate them to the point that they do not show up on search lists when using the search bar.

We send emails out of Acumatica and today had an email come into our Inbox in Acumatica.  One of our users replied to that email and copied our support team on that email.  They do this often, but today we noticed that the email did not send and in the Email area, it appears in the “Failed” filter of All emails. When we open the email that failed, it says “Illegal characters in path.”.  I haven’t noticed this type of error before.The user tried to resend the email and it again failed. She also remove the people on the “TO” line and added them back in by doing a search for their names.  That email failed to send as well.The user ended up sending it out of Outlook, then copying the sales inbox for tracking purposes in Acumatica.Any ideas on what the error message means?Also, one thing that is not very clear is the activity under the opportunity says “open” and the mail status says failed. Would be nice if the email activity under the opportunity reflected “failed”. 

Hello Community. I am looking for someone (Subject matter expert) that can help hand hold our purchasing and operations department whilst we implement the DRP within Acumatica. Is there anyone out there that charges by the hour to help two of our staff members set up all the purchasing forecasts and business events to automate what is possible and make the stock management as efficient as possible. This will have to include training on using a dashboard to manage the overview and to have a daily and weekly summary to send to the directors for their insight.In the near future we are seriously also considering integrating with a 3PL company for storage and we will need assistance with integration with their system via API’s.any recommendations, guidance or contacts appreciated.

I am trying to design a report using INReceiptStatus which is hidden and cannot be selected in report designer or Generic Enquiry. How can i make the DAC available for report designing 

Hi,I am working on an import scenario which takes an exported Shopify order Excel file and bulk create Sales Orders with all line items.In the screenshot below, I have a step which uses the ‘Email’ from the Excel file and input it into the ‘Related Contact’ field.  If the contact with that email already exist in the system, then it will populated the contact in the field within Sales Order.  However, if the contact does not exist, then it gives me error for the lines that cannot find an associated contact.Question:  Is it possible within the Import Scenario, if the Contact does not exist, it then creates one for me with all the required details (Name, address, email, business account...etc)? Many thanks!Will