Solved

  I want to get PXSelector Order Number value For Line Nbr Filter,that order number is only in view not db can i do that?with this code lineNbr is empty or doesn't display data Please Help Me

There is only one option to generate conditional waivers on AP check printing, need to be able to select generate conditional lien waivers when the bill is entered, this makes most sense to clients that require a conditional and unconditional lien waiver.  Please expedite this as it is a deficiency in this module. 

We have a product order that calls for Material Subassembly A.  Subassembly A calls for Component Part B.  We created the product order and also created linked child order for Subassembly A.  MRP has a demand line for Component Part B coming from Subassembly A AND from the product order (MRP must have created this demand item by blowing through the BOM).  MRP is not recognizing that Component Part B is already demanded on the child order, so now we’re doubling up demand for Component Part B.

Can someone suggest a way to use Acumatica “Opportunities” for our situation.  We know how much a customer or prospect spends on supplies in a year.  We want to create an “opportunity” for the yearly amount the customer or prospect will spend with all suppliers.  For expample, a customer will spend $50,000 per year with all suppliers.  We want to create a $50,000 “opportunity” and then as we write invoices throughout the year, we could see “how much” of the $50,000 “opportunity” we are getting.  For example, if by June we wrote 5 invoices for $5,000 each, we would see we captured $25,000 of the $50,000 opportunity.  Is this possible to do with Acumatica “opportunities”?  

I am new to this financial report designer.  We are still setting up the system. I can’t figure out why my report results show only zeroes, when I try to input a formula into a column set to show me each line item’s % of total income.  In the Row Set (below) row 0102 is my total Project Income.  I want to show Gross Margin as a % of income.  Eventually, I want to show each income line as a % of total income and each cogs line as a % of total COGS.I am not sure if I have the row sets set up properly, but I do have a base row code which is total income.So, I’m trying to use the “value” field in the column set to divide the row by the base row, but I keep getting an error.What is the correct formula for the value field?  Is something else setup incorrectly in either set to make this work?COLUMN SET ROW SET  Result if I try a validated, but apparently incorrect formula in the Value field on the Column Set:    

I tried to update Sales Order Detail Open Qty by import  Scenarios. It shows “unit conversion is missing error" .Could someone give me any hints? Thanks for your help 

All, I’ve recently take on Acumatica support at my company and was told that some time back, an Acumatica update broke the @me filter in our dashboards. Then I found this:Here’s the drilldown… do I jut need to change OwnerID_description to OwnerID? from the GI results gridThanks!

We have “restriction groups by branch” in place.  We have the “access role” configured on our branches.  And yet, all our users can see projects for all branches.  This is not the case in other modules.  I see another similar post here, and it doesn’t look like it was resolved there either.  Is this a known bug?  Acumatica 2021 R2Build 21.215.0016

I have a requirement to disable  printing of invoice more than once for some employees. I can use the “IsPrinted” condition to check if invoice has once been printed. I need a way to capture the current logged user so that i can add in my conditions

I am testing moving a site to a new location due to drive space constraints.I created a site Test2 on the old location.I copied the site files to my new location.I updated the web config file in VS to my new location as well as the virtual folder path in IIS.The site works fine.  I can even publish a customization to it.In addition, to ensure it isn’t a security issue, I set permissions to the new location by adding Everyone and granting full control.However, in the Application Maintenance screen of the installer, it still references the old location.Where can I edit this information so that the installer sees the real location?  I cannot find any references to the old location in the site. You can see the new location is updated in IISThe application pool also shows the new location 

Hello,The AP Aging report has only 3 period buckets.(AP631000)  These are given values in AP preferences.I want to modify the report to print more period columns.As I look at the report in Report Designer, I see the values reference fields I cannot find in the tables.  These appear to be variables, but I cannot find them.Is it possible to modify the AP aging to report a couple more columns for additional periods?Can anyone explain what this value is referring to?Thanks! 

I want to create a copy of a generic inquiry that exists (OOTB) within our implementation.  Acumatica 2022 R2, Build 22.205.0026.  Construction Edition.  The inquiry is within the Services module and is named “Appointment Summary.”  It has the screen ID of FS400100.  Within the Services module, the title shows under Inquiries, as you would expect.  The inquiry opens when selected and presents the expected form and results (the OOTB inquiry).  To attempt to create a copy that I can edit, I navigated to Customization, Generic Inquiry.  When I select the magnifying glass to perform a lookup of the desired title “Appointment Summary,” no such inquiry exists.  I’ve attempted using “appoint,” “app,” “FS,” “Summary,” “40.01.00,” and anything else I could think of.  I cannot find this inquiry.  I do get results in the lookup, just not containing the inquiry I’m looking for.  I have made certain my view displays every available result by enlarging the search results form or walking through each

I have created a customization project with a new generic inquiry, new screen, popup window with a smart panel, new tables in db, and with a newly created report. Please take a look below. Now I want to fully migrate this customization project build to a test environment with inserted data. Please give me some guidance. Thank you.Generic Inquiry viewNew screenPopup windowCustom report 

Does anyone know if it is possible to setup a Approval Mapping where if AP Trans unit cost or ext cost is > than PO issued amount to trigger a required approval?

I can not change the default address on a customer record or vendor record. The override check box does not actually override the record when you try to print a copy of the invoice.  We have been creating new customer accounts and new vendor accounts when needing to update a new record.  Any suggestions on what we are not doing correctly? Thank you in advance for your help,Lisa Z.

Is it possible to use the UPS Mapping tool to import addresses into WorldShip and export the the shipping information (tracking and freight) back into the shipment within Acumatica?

I have just created a new custom inquiry form. I need to add a sum of two columns in the bottom just like the GI. But not able to find a way. Can we do that in custom inquiry ? Please help.Thanks.

Hello:Please someone that Support me.I try to import this SO, but the SO is imported but only with Two lines, the salesperson is importedHere you have the SalesPerson colum, but in the second screen only I have 2 lines with salesperson.The screenhoot 3, the salesperson is linked.I attached the scenario fileThank you.             

Does anyone know why Project Balances or Cost Budget lines do not alter even after AP Credit Memo is released / applied?

I’ve been asked to bring in some historical/static data from a legacy system for a new Acumatica customer.  Going to be using it for reference only via GIs I figure if needed.  Some of it is quite detailed, many fields, etc.  I was going to create and load new Acumatica tables to hold the data and then I realized to use the import scenarios I need a screen name.  For my purposes, I don’t' need a screen necessarily.  Is there anyway in Acumatica to load data directly into a table from a file, the files at the moment are given to me as tab delimited text files, without having a screen in Acumatica?   I’m not a SQL expert, but I’m presuming the tables could be loaded directly via SQL commands, but wondering if I’m missing something..

After the upgrade to 2022R2, we started having an issue with quick checks for one particular branch, the error appears when users save the checks.Based on the error message, it looks like the issue is related to the Approval Map. Double checked the map, no visible issues with it. Any suggestions are highly appreciated. Thank you! 

Hello, I am trying to add a scan mode to the Receive and Put Away screen. I've tried the guides on the help site but can't seem to get the mode redirect to work. https://help-2022r2.acumatica.com/(W(6))/Help?ScreenId=ShowWiki&pageid=365ee72f-d2f0-42fb-bdbb-315158ee5693 Here is the code i have so far:using System;using System.Linq;using System.Collections;using System.Collections.Generic;using PX.Common;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.BarcodeProcessing;using PX.Objects.Common;using PX.Objects.IN;using PX.Objects.IN.WMS;using PX.Objects.PO.WMS;namespace CWDasign{ using WMSBase = WarehouseManagementSystem<ReceivePutAway, ReceivePutAway.Host>; public class PrintLabelsExt : ReceivePutAway.ScanExtension { public static bool IsActive() => true; [PXOverride] public virtual IEnumerable<ScanMode<ReceivePutAway>> CreateScanModes(Func<IEnumerable<ScanMode<ReceivePutAway>>> base_CreateScanMode

Hi,Have you anyone created a GI to get the item-wise inventory report to tally with the ledger account for a specific date? I’m trying to build a GI but it does not tally with the ledger account balance.  Can anyone help with an approach or a GI developed?Thank you,Dulanjana 

Hello guys, I’m planning to migrate from GoDaddy hosting(domain,email,website) to Microsoft, Since most of the applications like outlook etc. that we use are provided by Microsoft.Is anyone here using Microsoft hosting services to kindly assist me on how to go along with the migration?Kindly assist here on how to go along with this, Hosting on GoDaddy expires in some few days and I need to migrate to Microsoft before then and not wait for next year. Any kind of response will be highly appreciated. Thank you all 

Can I ask what Specific role do I need to have an access to edit the account group please someone thank you.