Solved

Created and successfully prepared customers in an import scenario.  However, when “Import” was activated, random customers were not loaded.  Can not find a common problem as to why it brought some in and some not.  It did not give an error, just did not bring them in.Reran in test company with  The ones in yellow are missing.Excel dataThe Customers loaded: 

Using the out of the box Import Scenario for Customers.  The customer is displayed but when Import is selected, get the error:Here is the Import Scenario: The excel data file:Thanks. 

Hey, everyone - It doesn’t appear that the “Total Sales” field is calculating in Project quotes, despite being values in the “Ext. Price” and “Amount” columns.  This doesn’t appear to be an issue with hand-keying items line by line.  However, our estimates are fairly sophisticated and large and our estimating team will be making frequent use of the Load Records from File button and it only seems to be an issue when data is loaded in this way.  Is anyone aware of this happening either specifically or in a related way?  In full disclosure, I did customize fields on the screen but only by changing their display names and requirement status.  If you have any insight please advise.  Thank you!  

In the Projects form in Acumatica, if we attach more than one file in the record, how can we select one specific image file to be selected and printed in the report, this image file will have a specific naming convention so that it will be selected to be printed in the report. How can I approach this development?

Hi everyone, I want to set approval condition when PPV field is non-zero but I don't see PPV Amount field on assignment maps screen, anyone have an idea to set up I’ve already tried to set up on another screen (Bills & Adjustments) or purchase order but it doesn't work. 

Hi everyone, is there any quick way to change the column name and column length in Acumatica Time Card? (Screen ID: EP305000) Thanks

Hi,I have a custom field named UserSearchName on Stock Item and I want to use this field to combine DescriptionField of seletor Inventory.I updated the attribute DescriptionField of InventoryID to: PX.Objects.IN.InventoryItem+userSearchNameBut I got the error regarding syntax I think, I have no idea what wrong here. Do you have any experience about this one?Any idea would be appreciate.Thanks

Hi I would like to Populate the customer Billing Email automatically when we run the report for one customer for sending an Email. Response from Acumatica :The report will need to be customized in order to meet this requirement. Even if the customer is indicated in the report parameter, there is no link between this parameter and the mailing settings of the report. Looking for some best approach to meet this requirement.

Business Requirement- Send a product review after the Invoice is closed.We have created a below GINow in the Template, we need a display the Items with Image when we have multiple Lines.We are displaying the Line Items in a same row because of our business scenarioIn the GI the inventory Info is listed row-wise which we need to show as columns in the notification template.Expectations in the template as shown belowI am expecting those 3 Lines as below in the notification template. Acumatica responded this required customization- Need your thoughtsFor each loops can loop through multiple rows on a GI based on same reference number, but will not loop through multiple data fields listed on the same row on a GI.  SKU Image 10343886230   85126691547   85126691555    

During or shortly after the Release action for a ChangeOrder I would like to perform additional updates to the related Project. However, I am not sure how to do this in a way where the Release action is full persisted before continuing.  Below I have attempted to handle the standard release action (Base.Release), and then tag on a function call (SetCurrentOrderSet) to update the project, however since the Release action has not been persisted my logic in SetCurrentOrderSet fails.public class ChangeOrderEntry_Ext : PXGraphExtension<ChangeOrderEntry>{ public PXAction<PMChangeOrder> release; [PXUIField(DisplayName = "Release")] [PXProcessButton] public virtual IEnumerable Release(PXAdapter adapter) { var result = Base.Release(adapter); PMProject prj = this.Base.Project.Current; ProjectEntry prjGraph = PXGraph.CreateInstance<ProjectEntry>(); ProjectEntry_Extension prjGraph_Ext = p

Has anyone found a solution for handling secondary or overflow bin locations in warehouse management? We have several items that say, don’t fit on Shelf 1 (because we stock so much of it), so the rest of the inventory on hand might be on Shelf 2. Currently, I do not see a place where I load this information into the system, therefore the picker only knows to go to shelf 1 and pick what is there. He does not/will not know there might be more inventory in another location. Has anyone come across a solution for this?This will also cause problems with physical and cycle inventory counts.

I want max two number in my Custom field. Example the value of that field cannot go above 99.I have set the MinValue and MaxValue like this[PXDBInt(MinValue = 1, MaxValue = 99)] but ideally i would like to restrict user from entering the third digit. If anyone knows plz answer.Thanks.

Hi Team, Can we create a Fixed asset directly from Purchase order. I know we can do with “convert purchase items to Fixed assets” but I do need to know how it works when we directly purchase from Purchase order. And what will be the possible transactions that will be displayed in the “convert purchase items to fixed assets”.

Hi, Community!We are using Procore’s synchronization with Acumatica and would like to see the logs in Acumatica for Procore synchronization processing as input to the decision to increase synchronization frequency. Where do we find the API logs?Procore does not have any logs that are client-facing outside of the change history on the individual items within Procore. As far as anything logging specifically within Acumatica, the Procore dev team doesn't write any logs to the Acumatica server and there is no known journal of activity.Thank you,Dave Z

Hi, Have anyone done similar inquiry to view all the critical materials for all the production orders? Would be great if able to share the GI with me, or assist me in creating the GI. Thanks!

I’m trying to give a link in a GI whereby I could put in dynamic fields to automatically populate the initial fields of the Activity based on the line in the GI.  For Example, if the GI Line references Task 001 of a Project, then I would have a hyperlink to create a new activity and when the activity window pops up, it would already have Task 001 from the Project populated.  Then I’d like to do the same thing with Task Owner, Cost Code, Project, Activity Type, etc.

Good day, everyone.We are attempting to update the Commitment tab details in the change order screen using the REST API, but we are encountering problems when updating the Commitment type and Commitment nbr values from the API.Commitment type is set to Purchase order by default, and if we assign PO transaction values to Commitment nbr. from API, it works fine because PO values are already loaded into selector. However, when we assign "Subcontract" type to Commitment type and subcontract # to Commitment nbr via API, we receive an error stating that the subcontract was not found in the system. The JSON and URL for this call are shown below. Can anyone suggest a solution to this problem?PUT: {{SiteURL}}entity/DefaultEx/18.200.001/ChangeOrder{ "RefNbr": { "value": "000020" }, "COMMITMENTS": [ { "ACCOUNT": { "VALUE": "51250" }, "AMOUNT": { "VALUE": 600432.0000 }, "CostCode": {

Acumatica help lists 3 files types for uploading. OFX (Open Financial Exchange) QBO (QuickBooks Online) QFX (Quicken File eXchange)When choosing a “Statement Import Service”, I only see an OFX option.  Maybe it handles all 3 file types above, but I’m getting errors with QBO and QFX files so I doubt it.How do I get or add the other Statement Import Services / PX.Objects?  

Is there a way for the Daily Demand Forecast calculation within the replenishment parameters to consider production demand?We are looking to use replenishment feature for the material that goes into an order, but looks like it ignores production demand and only considers items included on a completed Sales Order. Which would be our finished good and not the material used to make the finished good.   

Hello All, I am trying to activate an extension in APInvoiceEntry conditionally based on a setup extension from PreferencesGeneral. In all methods typically I can pass “Base” as a parameter in my code and retrieve the expected data but in “public static bool IsActive()” when I try to pass the Base (in my case APInvoiceEntry) it is not recognized. As an alternative, I tried to directly select from the database but I am not sure why the setup record is returned null and obviously, I can not get the extension from null. I read @Sergey post “https://asiablog.acumatica.com/2017/02/dynamically-activate-extensions.html” but couldn’t find a solution there either. See my code below and advise how I can overcome this issue. public class HCLAPInvoiceEntry : PXGraphExtension<APInvoiceEntry>{ public static bool IsActive() { PreferencesGeneral setup = PXDatabase.SelectMulti<PreferencesGeneral>() as PreferencesGeneral; HCLSMPreferencesGeneral setupExt = setup.GetExtens

Good day,Question, How to add back to the toolbar the Delete icon the sales order form.  (The icon is on the toolbar for purchase orders and other forms)  The Acumatica documentation on this area is lacking.Any assistance would be greatly appreciated.Thank you.Evan  

2 of our prospects need to allow an employee to clock in to multiple jobs at once. Ex: 3 production orders have a paint work centre and the company wants to track time for each of the jobs although they are all done at once by the same employee. Same issue for a company that uses a plasma cutter to cut parts for multiple production orders in one pass.I know we can’t clock in to multiple jobs and dilute time to each order but is there any way to combine the tasks?If I can at least combine the jobs I can calculate percentage of time dedicated to each work order using square inches to be painted or inches cut. Thank you.

We have recently started with Acumatica and had all of our information from our previous system ported over, however the checks were not included.  For context we never used the previous system to reconcile our bank statements.  We exported our information on to an excel sheet and did it there.  We made the necessary JE’s into the system as needed to balance, therefore all of the checks on that system were never marked as having been cleared individually.  So I know that for that reason porting them over would have been a gargantuan task! I will be using Acumatica for our reconciliation and know how do use it. What I don’t know is how to clear out the previous checks that are now clearing?  Because everything that was ported over was in our GL, I’m not sure what to do? Any help is greatly appreciated! 😊

Hi,I am trying to create an A/P Approval Workflow so it’s based off who entered a PO that is linked to a Project or Owner who created the PO under Purchases. Sometimes this workflow will require a 2 step approval process or a 1 step based on who entered the PO. I can’t get it to work. Here is my configuration. What am I doing wrong. Any guidance would be appreciated. Thanks. Here is Step 1:Here is the Condition for Step 1: Here is the Rule for Step 1: Here is Step 2:  Condition for Step 2: Rule for Step 2:  

Is there a way to turn off Auto application of Credit memos in accounts receivable?I want to be able to choose what credits get applied to what invoices so the customer and I are on the same page.  I can do this by un-applying the credits, but this is making more lines than necessary and extra steps to the process.