Recently active
Hello, I am trying to hide the salesperson commission on the commission tab on a sales order invoice. I’ve revoked everything I can find. Can someone please help me on where to choose the correct permissions for it? Thanks!
Is there a way to produce statements by customer locations and also being able to send them via email based on the email field within the customer location?
Greetings team, I am setting up the Check register to display ACH type from the Check and Payments. Recently I did some test but I can't identify what I need for it to reflect. test: Check register:
I need to consume pots to make a finished good. I’m automating this process. I need to find the UNIT PRICE for these pots. I used INItemCost.AvgCost as my source for this data. Is this incorrect? It’s returning 0’s on items who have a cost that we hold a position on. What is the best table/field to use to get the current AVG unit cost for an item? Thank you for helping me along!
Hello, I am trying to add a user field (decimal) called UsrSalesCommPct public class AMEstimateItemExt : PXCacheExtension<PX.Objects.AM.AMEstimateItem> { public static bool IsActive() => true; #region UsrSalesCommPct [PXDBDecimal] [PXUIField(DisplayName = "Sales Commission (%)", Required = true)] public virtual decimal? UsrSalesCommPct { get; set; } public abstract class usrSalesCommPct : PX.Data.BQL.BqlDecimal.Field<usrSalesCommPct> { } #endregion #region UsrContingencyPct [PXDBDecimal] [PXUIField(DisplayName = "Contingency (%)", Required = true)] public virtual decimal? UsrContingencyPct { get; set; } public abstract class usrContingencyPct : PX.Data.BQL.BqlDecimal.Field<usrContingencyPct> { } #endregion #region UsrMargin [PXDBDecimal] [PXUIField(DisplayName = "Margin")] public virtual decimal? UsrMargin { get; set; } public abstract class usrMargin : PX.Data.BQL.BqlDecimal.Field<usrMargin> { } #endregion #region UsrMarginPct [PXDBDecimal] [PXUIField(DisplayName = "Margin (%)")] publ
Hey All, I was wondering if there is any way (without a customization project), to filter the drop down options of a parameter based on the selected value of another parameter. In this case, I have selected the Inventory ID that I would like, then I want to select a BOM ID that is related with that Inventory ID. But, currently, the parameter options are every single BOM ID. I have seen this a BOM Attributes Customization Project, where you pick the BOM ID, and then you can pick a revision number, that is associated with that BOM ID. But this is how my current parameter displays the drop down. Does anyone know if I can get the BOM ID parameter to only show me BOM ID’s related to the InventoryID? Thanks for your help.
This question is a bit different from a prior question regarding how to reverse an inventory receipt. In our case, we did an Issue out of inventory that reduced our Inventory account and went to our inventory shrinkage account. We have to make some changes to the sku accounting methods, so we transferred it all out in order to make the change, then will move it all back in. After we issued it out, however, we received in via the Receipts transaction rather than do a corresponding inventory adjustment in. It correctly increased the inventory, but the other side of the transaction hit their finished goods control account rather than shrinkage. Now we have an imbalance and we can’t determine how to reverse the purchase receipt so we can adjust the inventory in properly and make it all balance. The Issue out: The Receipt: Since accounts 1200 and 1202 are control accounts in our case, we can’t just reverse the batch for the receipt. Does anyone know how we can do a reversal of the Receipt s
Hello, Is there any way to add both of these tables (ARContact) to the SO.Invoice GI Inquiry? I added them, but I don't see two tables on the Result Grid tab to choose a field from. I previously added ARContact for shipping, and I don't see any value on the inquiry page after I added the second one. I had to delete the ARContacte for billing in order that ARContact for shipping should work.
Has anyone had any issues with the 32 character limitation when entering Billing street address? This seems a bit low to me, believing it should be closer to 50?
hello all, I have been trying to recalculate prices on sales orders using an import scenario, but it doesnt seem to work. When I try to manually recalculate it does get, but not via import scenario. What is it that I am doing wrong here? The import scenario would be run via a biz event. So I have created a GI to list the SO on hold and whenever a new sales order would be created, the biz event should be fired.
Hi experts, Need your advice / solution on how to release Expense Claim automatically on final approval. because this configuration seems doesn’t exist in the Preferences. Thank you in advance for your solution. Regards, Iko
Good day, I want to remove the Option to Print when a Purchase Order has the status of On hold or Pending Approval. The workflow is very confusing to manipulate. Kinds scary if I remove something. Is a customization easier or cleaner? It is my first attempt to try do no code/low code process. Does anyone have a sample? Your assistance is much appreciated. @grillevan Thank you. Evan
Hello Everyone, We are facing an issue while conguring Outlook email account but getting error “ The mail receive has failed. NO LOGIN failed. ”. We have given valid credentials and other parameters but still getting this issue. Can anyone help me on this? Please find the screenshots for reference.
Best regards I have currently set up the Integration between Acumatica and Salesforces. Importing the information from Salesforce to Acumatica is not a problem for me but when I want to export the information, I have in Acumatica for Salesforces I continue to get the following error: INVALID_FIELD: There is no such column 'Acumatica_NoteID__c' in the Account object in Salesforces that column is already configured, any idea of what it can be??
I am on 2024 R 1. I am trying to correct invoices that were created with he incorrect tax amounts. I have created a Credit memo but receivng error message “ Error: 'TaxBucketID' cannot be empty.” when I try to release. Where is this Tax Bucket ID located ? The trace only states “
Order Orchestration Streamline Your Fulfillment Process and Boost Efficiency! Acumatica’s cutting-edge Order Orchestration capability is designed to revolutionize your order fulfillment process. By automatically allocating inventory from multiple warehouses based on predefined business rules, this feature reduces manual errors and minimizes backorders. It expedites orders across multiple locations, tackling common challenges such as backorders, manual reviews, and high shipping costs. Additional highlights of this solution can be found below. Be a part of our Acumatica Labs Program and pioneer the future of order fulfillment with our cutting-edge solution! If you’re interested in participating, please complete this short qualification questionnaire . This will allow us to consider you for the program. We will review your submission and get back to you within 5 business days to confirm your qualification. Flexible Fulfillment Strategies Assign specific fulfillment strategies to differen
I am struggling to add a PXDBScalar field to a CRQuote extension. In my customization, I have added a NonPersistedField to CR.CRQuote: [PXDecimal][PXUIField(DisplayName="Lead Days (Rev)")][PXDBScalar(typeof(Search<PBSA.UsrQTRevision.leadDays, Where< PBSA.UsrQTRevision.opportunityID, Equal<CRQuote.opportunityID>, And< PBSA.UsrQTRevision.quoteNbr, Equal<CRQuote.quoteNbr>, And< PBSA.UsrQTRevision.revNbr, Equal<CRQuoteExt.usrRevNbr> > > >>))] PBSA.UsrQTRevision is a custom table and DAC. I have another table and DAC like it for Sales Orders called UsrSORevision. For troubleshooting purposes I have added a similar PXDBScalar field to a SOOrder DAC extension: [PXDecimal][PXUIField(DisplayName="Lead Days (Rev)")][PXDBScalar(typeof(Search<PBSA.UsrSORevision.leadDays, Where< PBSA.UsrSORevision.orderType, Equal<SOOrder.orderType>, And< PBSA.UsrSORevision.orderNbr, Equal<SOOrder.orderNbr>, And< PBSA.UsrSORevision.revNbr, Equal<SOOrderExt.usrRevNbr> > > >>))] The SOOrder one works. The CRQuote one
Hi Acumatica People, For my Vendors import scenario, about 1/3 of my records are failing with the error, Shipping Terms FEDEXGRND Can not Be Found in the System. To make this error more intrguing, I am attaching my import scenario and my source Excel file (my data provider is really SQL, but for you all, I created this scenario). observations about this error: Shipping Terms is the value, PREPAID, and ship via is UPSGRND (not FEDEXGRND) and FEDEXGRND is the ship via, right? The trace conveys that perhaps the termid that I have is not found?? ….I am attaching my import scenario.
we build the dashboard and it was work. after few days, we are getting this error. is there anywhere i can find GI
Hi, I am adding a few custom fields to ARInvoice and ARPayment. How can I prevent these fields from being picked up in the copy/paste functionality? I tried redefining the data view in a graph extension with a new PXCopyPasteHiddenFields attribute, but it did not work.
We are using Avalara for AvaTax sales tax calculations as well as their Exemption Certificate Management system to handle our customer exemptions. We have a large volume of customers that have a sales tax exemption that only applies to certain product categories. For example, if customer buys product A it’s exempt but if they buy product B it’s taxable. Avalara has a feature “Exemptions by product category” and I believe I’ve set that up correctly adding the relevant Avalara tax code to the category then applying that category to the relevant customer exemption, however it doesnt work and charge taxes correctly. It sets the customer as fully exempt regardless of the product type when I test transactions in Acumatica. Does anyone use this feature or can they give me some guidance to a potential workaround?
Has anyone been able to have multiple visible expressions at once? I cannot get mine to work. I have two I want to combine on the details section of a report: 1) Color coding every other line: =[$LineNbr] % 2 = 0 or in the second detail section it would be =[$LineNbr] % 2 = 1 I have a Note section. It should only show if there is a note. If not then do not show: = ([LineNote.NoteText]<>Null And [LineNote.NoteText]<>'') How can I combine the two to make it work where it will color code if there is a note line, else the line does not show at all.
i.m currently on an older version of Acumatica, testing in the sandbox for version 2024R1. I am using the Construction module and crated an invoice for a project. The invoice appears in all of the modules correctly, however, the issue i am having is with the Project WIP Report and Project WIP Detail Report. The Project WIP Report headings Revenue Recognized and Billings in Excess of Costs is showing the correct amount but the Period Billings and Billings to Period are showing credit amounts. In the two test scenario billings created and posted for the two projects, there were no debit or credit memos to cause a credit balance. It appears the credit balance is equal to the tax amount on each billing. In reading through the notes this is a known problem after the 2023R1 release. The proposed solution to run Recalculate Project Balances doesn’t seem to be working. Any ideas as to whatelse i could try?
Hi, Is there any way I catch “ Control Total is required for shipment confirmation. ” exception with my code on shipment screen?
Hey everyone! I’m working in the engineering workbench and for some reason I can’t utilize all of the grey area below the red line. I’m no a PC using firefox if that is helpful. This makes it very difficult to view.
56 likes
45 likes
25 likes
15 likes
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
