Discussion Forums

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.   

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

UPS integrated shipping has the option for gif files, which are great for sharing with customers, as it can be used without a Zebra Printer. However, the file comes out horizontal, as shown in the below image. Is there a way to get the UPS Gif files to print out vertically, instead of the default horizontal? 

Hello!My task reminders are getting popped up when I am logging in to the system only. And at the time reminder works, my screen get stuck but no reminder is visible. Is there any setting I can change when to pop-up the reminder?Thank You!

Good day I am creating a GI which will list all the lines and their columns from the relations tab for each opportunity record.The following tables have been used for the GI: CRRelations, CR Contact, CR Opportunitiy, CR Leads, BAccount, So Sales Orders. I am having difficulty showing the status of each line, as this could come form a number of tables (i.e. sales order, leads, customer, etc.) I have tried using the ‘Target Type’ from the Relations table in an IF statement, but I don’t seem to be getting the name of the type ‘name’ correct.Does anyone know how this can be achieved in possibly a simpler way?Thank you.

An account was added while creating BUDGET for 2025. That account is no longer visible under FINANCE/BUDGET but it is visible on P&L Budget. That specific account needs to be updated and cannot be located. I was looking in every subaccount, in case it was posted in the wrong place and nothing. That account has not been added to Budget configuration prior to entering it to the budget. However, it is showing under different branch budget P&L and BUDGET. I added this account to Budget configuration, but it is still not visible, nowhere to be found. I am getting an error of duplicate account/subaccount if I want to add it again. 

Hi everyone, I have a troble and I hope if someone could help me.The issue is in a project of customization, I needed to create a new screen and I had to redirect from another screen so the new screen is a pop-up screen.In the pop-up screen I have a grid and I want to save a record from another table but when I push Save button it doesn’t nothing, I checked that current cache of the dac (I mean the cache of the grid) is full but it doesnt save when i'm in its tab but if I change the tab and I try to save, it's done and It save the record, it's rare because I didn't save nothing, I didn't remove neither modify. The primary view was refered another Dac and the others tabs was refered the same view but the issue tab was from its view. Also the Dac “Cargos Adicionales” have a compound key, I mean, it have the keys from th

Using Shopify Plus+ b2b .We have 3 branches, and orders are required to be imported with the connector to the respective branch.There is a lack of mapping options available to the Company Entity.We tried manually inserting a metafield into the Customer. The metafield value definitely exist on the customer.Receiving  error "SalesOrder.Details[0].Branch: 'Branch' cannot be empty.Inserting  'Sales Order Line' record raised at least one error. Please review the errors.”What are our options for mapping to the right branch? We have too many customers to do it by locationid in orderdata. 

We currently have one company setup without using branches, The subaccount segment string is AAA-BBB where AAA is the Department and BBB is the Product.  We want to add the physical location by either creating branches or a third segment in the subaccount segment string ie CCC is the Location.  Is there any benefit to creating Branches (say for data entry, reporting, complexity of system administration) to capture this information compared with changing the subaccount string to include a third segment ? 

In Bills and adjustments, when an invoice is created and any supplier is selected, an item is automatically entered. What is desired is that a default item does not appear. Can you help me please? 

Hello Everyone, We are trying to create a new field in the sales order screen and we need to display it in the modern UI Sales order screen.  Created a new instance with version (24.205.0015). While creating the instance enabled the Install NodeJS  and Enable Modern UI check boxes.  After completing the instance setup, I tried running the npm run getmodules command, but encountered the following issue. First the NodeJS   files was not in the FrontendSources  folder. The NodeJS  folder was created in the C:\Program Files\AcumaticaTools\NodeJS\node-v18.12.1-win-x64 path.  Moved NodeJS  to the FrontendSources  and tried still same issue.  I also tried running the .\npm command in the NodeJS folder, but it did not work. It seems the NodeJS is not installed that I have installed with Acumatica instance. Removed the NodeJS from the path and followed these instructions(