Discussion Forums

Hi,How can I add a customized payment method called Onlineach to the Check Register Inquiry under Payables? Is it only used for the payment method of checks? Let me know. Thanks, Frances Pantelidakis  

I was trying to use the Import Scenario with no luck; I must be missing something.  

I created an import scenario to create new Service Orders.  It only works when I run a row individually?  Does anyone know why this is happening??   

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

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. 

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:

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 regardsI 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 “    

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<

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 

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 = 1I 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?

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.  

I don’t use FieldSelecting (almost never) and I think I should have been using it a lot more.  However, When I set the Qty on a line in Bills and Adjustments, it just displays it on screen, and if you add a cost, it doesn’t extend the cost out.You can see it defaults the Qty to 1.  But when you add an item, the extended cost is 0.Here is my method: protected void APTran_Qty_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e) { var row = (APTran)e.Row; if (row == null) return; if (row.Qty == null || row.Qty == 0) { e.ReturnValue = 1m; } }If I do this in the RowInserting it works, because I can actually update the cache. protected void AP