Discussion Forums

Is it just me or is Acuminator not showing Row events in the code map?I’m running version 3.1.3 on VS 2022.I’ve uninstalled it and re-installed.I was pretty sure that I’ve seen Row events listed in the map in the past but maybe something on my side has changed?

I am trying to figure out the best way to load large intercompany mappings through import scenarios. Have anyone done this successfully?

Hi All Did anyone translated Acumatica in Portuguese yet?  RegardsMuhie 

Dear All,I want to create a business event where, if the Sales Order (SO) type is "SO" and the status is "Open," the system will automatically quick process to create and confirm the shipment. I have created an import scenario, but it is not working even though the business event history shows success. Could you please point out where I might have gone wrong?   

Hi All,Is there a way to modify the parameters in the RMA report?For example, I want to add the From Date and To Date fields to the Profit & Loss RMA report in the Acumatica 24.1 version.Any guidance on this would be greatly appreciated.Best regards,Lalith

Hello all,I have created a selector Attribute id as below: I am trying to add this attribute id under Opportunity Class screen, but when trying to add it doesnt show up. Am I selecting an incorrect schema object?As this attribute ID would be used in Contact class, account class, customer class screen. And the data will be forwarded from opportunity to the above mentioned screens while we try to convert an opportunity to create contact etc.

I'm having an issue with my report because there's no Beginning Balance in the Account Details, yet the report is showing an amount. I'm trying to consolidate the two branch, but its showing an amount even though it has no balance. the others is correct  this must be 0   

Hi Community,I have created a tile to display a shared filter on a GI, but the results are not displaying properly. For Example, this Docusign shared filter has 4 records, but my tile shows only 1 record. I cannot seem to get the tile to display more than 1 record. Any suggestions?  This is how the tile is set up: 

Hi All,I’m trying to generate Demand PO’s linked to SO’s from the PO505000 screen but am finding it will only generate a PO for one line item at a time, rather than the multiple items available for Purchase from the one supplier or multiple suppliers.  I’ve created a Custom Endpoint via Web Services linked to the screen, added the ProcessAll button as an Action with OrderNbr and OrderType as parameters: I call via HTTP using Postman and the below Body:I get a 202 back saying its successful.What seems straight forward and works in the GUI with the above filter options, will only ever generate one PO for the first line, no matter how many lines there may be meeting the criteria.Not sure what I’m missing and this seems like a process many people would want to use via API?? Is there something required in the Entity that I am missing??Any help appreciated :-) 

A client wishes to display on a Google map the location of each open opportunity in Acumatica.  To be able to visually observe geographicclustering of opportunities.  Any recommendations on how to accomplish this?

Hi All,I am trying to get my generic inquiry to do two things that I am not understanding… Grouping the items from the bom into a grouping in some way so that it doesn't look like i need the same weldment 36 times Also, this is what it is generating when the BOM i am working with is  It seems to be changing the work center on the second operation and is doubling how many times it is showing it.  Any suggestions are helpful at this point or if more screenshots are needed please let me know!

Hello - we recently implemented the Ecommerce edition to our existing distribution edition  to connect with our Shopify store.  We do not have any 3rd party integrations for calculating tax in Acumatica as most of our business runs B2B, so we manually set up Tax ID’s and zones and apply them whenever necessary.One area that we do have to charge taxes in via web sales.  For most states, we are only dealing with a single flat rate per state.  However, there are a few states, like California, where you are charging State + County + Local in some cases.Shopify handles this as 3 distinct API calls, as opposed to a single calculation of tax and a pass to Acumatica.I’ve tried to do some mapping to change all the incoming tax rate names from Shopify to match up with my associated rates in Acumatica, but with this being 3 calls in the example above, it seems like Acumatica wants to add 3 rows with the same Tax ID name, which it obviously can’t do/will error.I know you can build out more robust

Our client would like to Create a Sales Order then Select a po to link to and have all items on the PO come back onto the Sales Order.   We understand how to do this line by line.   They may have 30 line items on the PO and dont want to have to enter 30 line items on the Sales order and then link each line by line.   Is there a way to do this? 

Good day,The user entered a CO with a quantity of 1 and an amt.  However, the Task associated with the non-stock item showed only the amount.  When we ran the Project Billing the invoice only showed the amount without a quantity so the invoice was incorrect by the amount. I can’t see why the issue that caused the issue.  the CO was correctly entered.  See the Revenue Tab below.  The item is non-stock.Is this a setting issue?  Preference.  Billing Method?  We need to revise the invoice.Thank you. 

Does anyone know what is the difference between the  PMTran.Date and PMTran.TranDate? The PMTran.TranDate is not visible to user out of the box and is defaulted to the BusinessDate. User can enter and edit PMTran.Date though. So, the question is what the purpose of PMTran.TranDate is when it is not available to user?

We have been unable to submit an ROE file processed through Acumatica, because Service Canada is rejecting the file type.  The file has to be in BLK format.  We have tried numerous ways to get this to work, but it appears that Acumatica needs to automatically convert the XML file to BLK when it’s processed and saved to the computer.  (Our previous system Sage converted automatically.  The file was in BLK before saving to computer)  Seems like a programming issue in Acumatica, but so far, support has been unable to figure this out.   I’m wondering if anybody using Canadian Payroll has had to process a termination and use Acumatica’s ROE feature?   And if so, how has it worked for you?  Hope this all made sense.  I am not a system analyst and my terminology may be confusing.  lolThanks!

Hi I have two field StartDate and EndDate which are of type DATETIME in my Customization project.Now want to add the codindtion in which start date and end date are independent on each other.Conditions are :--Cond 1 → EndDate > Start Date  → If the Start Date is selected firstCond 2 → Start Date < End Date → If the End Date is selected firstMy DAC fields are the below fields#region StartDate[PXDBDate()][PXUIField(DisplayName = "Start Date")]public virtual DateTime? StartDate { get; set; }public abstract class startDate : PX.Data.BQL.BqlDateTime.Field<startDate> { }#endregion#region EndDate[PXDBDate()][PXUIField(DisplayName = "End Date")]public virtual DateTime? EndDate { get; set; }public abstract class endDate : PX.Data.BQL.BqlDateTime.Field<endDate> { }#endregion

I had learned how to create a new sale price, But I can't find the warehouse, and I can't create it. Please kindly advise and thanks for your support and helping

Does anyone know why the Bank Field Import date isn’t adjustable after you setup? For some reason our bank feed only pulls data as an example from 11/22/24. I like to do daily bank reconciliations but for some reason I can’t edit and pull in posted transactions from 11/23 to 11/25.For one other account, it can’t seem to get past 10/31/24 and I can’t edit.See below. 

I altered the EPEmployee table and added the above columns using a script. After that, I added the corresponding DAC records. However, even after publishing the customization, I still encounter this issue. Why am I getting this error?Script e.g:ALTER TABLE EPEmployee ADD      Usr____ VARCHAR(150) NULL,      Usr____ VARCHAR(50) NULL; 

Hello. I’m trying to create a Generic Inquiry that pulls information from the PREmployeeAttribute screen which resides under Employee Payroll Settings > Tax Settings.I have the GI created and linked with the PREmployeeAttribute table but I’m not sure how to specify which ROW and COLUMN that GI pulls.For example - when I choose Object: PREmployeeAttribute > Data Field: value it will return the social security number. I’m guessing because that’s the first value on the table. But I want to add another column / row in the GI that pulls the ‘value’ from the Ethnicity row. 

Is there a way to allocate inventory on a sales order as soon as the sales order is released (in open status)?

How do assign individuals as requested by in the Creating a new Requests Help says employee record, but dont see anything related to Assigning users as requestor or no roles as requestor. Question what is the setup for Internal requests

So I was calculating the % completion on a project in a generic inquiry by dividing the actual costs to date by the Revised estimated costs on a generic inquiry.  After some help from the community I was finally able to get the formula to not error out.  The ending calculation was not correct so I took out the division piece and had it show me just the top number and just the bottom number but those are not pulling correctly.  I used the same fields that are existing on other lines the generic inquiry. I’m usingPMBudget.Type= ‘E’ and the PMBudget.ActualAmount for the cost to date PMBudget.Type =’E’ and the PMBudget.RevisedAmount for the Revised Estimated costs. If I just pull those lines that already exist Actual Cost to date and Revised Budget amount and setup new lines copying the same formula.  I get different amounts.Here is the results the column and the test column next to it have the exact same formula I copied and pasted but they come out with different results?Original Cost to

Good day - I am trying to run an import purchase orders scenario, but without lot tracking. I have followed your scenario but I am not getting it to work. Can you take a look and see what I am missing please?Many thanks.