Discussion Forums

Good day,In Bills and adjustments I added a custom field in which I want that if it has any value it is considered for the calculation of the cash discount, at first I thought it could work to add the field into Terms since in another project I did something similar and it worked, but now it doesn't do anything, and in the Business logic I can't find a method or event that has the specific formula or instruction to calculate the cash discount when doing a prepayment.Is it possible to override the cash discount calculation? public class APInvoiceEntry_Extension : PXGraphExtension<PX.Objects.AP.APInvoiceEntry>{ [PXNonInstantiatedExtension] public class AP_APInvoice_ExistingColumn : PXCacheExtension<PX.Objects.AP.APInvoice> { #region TermsID [PXMergeAttributes(Method = MergeMethod.Merge)] [PXUIField(DisplayName = "Terms", Visibility = PXUIVisibility.Visible)] [APTermsSelector] [Terms(typeof(APInvoice.docDate),

Any one has used case of integration to either Service Pro or Sales Force Field Service and Acumatica Financials.Iam working on a prospect who is seeking this.If not these two solutions any Field Service Solution Integration will help.Please email me at bala@iccg.comBala AnantharamaICCG, Inc.

Hi, our team was working through creating T&M Pro Forma and made the mistake of marking several transaction rows as Write Off and we need to correct them. We went through the normal correction process of Reverse and Apply through the AR screens.When we attempt to create the replacement Pro Forma, it is not pulling in the transaction rows for the items marked as Write Off in the previous version. The AR Credit Memo generated new transaction rows for the billed items, but did not reverse the incidental Write Offs.Is there a step that we missed, or alternate solution to recapturing these Write-Offs? Other than manually adding transaction rows to the Pro Forma?

I’m trying to turn OrderType from a selector of every order type to just certain order types for our customer portal. I’ve been trying to change it to ComboBox since those options can be changed, but every time I save the Screen Editor, it goes back to Selector. What would be the best way to go about this?OrderType 

Hello!Is there anyway to calculate a supplemental item’s selling price based on a percentage of a configured parent line item within the Sales Order? Or is there a way to set up the configurator such that it is able to take a percentage of the SO Line item price and allocate it to the supplemental items? For instance, in our old ERP system, it was able to price supplemental items based on a percentage of the entered price of the parent line item. For example: Parent Line Item entered price: $1000Price Breakdown: Parent Line: 80% → $800 Supp. Item A: 10% → $100 Supp. Item B: 10% → $100 If you have any ideas, anything helps! Thank you!

Hello! We are currently building out our manufacturing area of Acumatica and onboarding our factory/shop employees to start using Acumatica to complete the move transactions work center by work center. Is there any way to create a dashboard that shows where each production order is by the work center? I have looked into the APS Module, but we are not at the stage where we can capacity plan based on setup times, labor times, work center capacity, etc. Is there anyway to utilize the DAC and formulas to craft this into a GI? Thank you!

I want to create Generic Inquiry for Vendor Name, Account Name and ReportID 

We would like to create a customization that takes the output of a given screen (let’s assume sales quote or estimate) and have it export a customized excel spreadsheet with that information.In our use case, we need to have several tabs in the exported file pre-defined (sort of like a template) and on one of the tabs the data from the screen being exported needs to be formatted a particular way (sor of like a stylesheet).I had thought about using a report as an intermediate step (where you have a little bit more control over the excel export) but I’m unaware of a way to have that result in multiple tabs. (incidentally, is there a way to “style” the exported cells from a report?)Thanks

Hello Everyone,I created a custom printed form and added it to the site map. I also created a customization project to allow this form to be printed from the Sales Order screen via Action Menu > Printing & Emailing. However, after publishing the customization, the report is not visible in the menu.The custom form has the correct access rights and works fine from the Printed Forms screen, but it does not appear under Printing & Emailing in the Sales Order screen.Acumatica Cloud ERP 2024 R2Build 24.203.0023Please see my screenshot and advise.  Thank youJennifer

Hi community,I need some help with a formatting issue. In a Sales Order report, I am using a subreport to fetch VAT and SVAT values, and the values are being retrieved correctly. However, there is a formatting issue. The numbers are displayed like 1669.18, but I want them to be formatted with thousand separators, like 1,669.18. I tried using ‘#,##0.00’ and ‘SOLine.OrderQty.Format’ to change the value format, but it didn’t work. Does anyone have a solution to fix this.  

Hi Everyone,I am currently making modifications to the lot/serial number report to display project IDs and tasks. However, I cannot seem to find the correct table to relate to INLotSerialStatusByCostLayerType in order to display the project data. I have tried using INTran and INCostCenter, but I keep encountering duplicates. Can anyone provide guidance on how to correctly relate these tables?

We are very new to Acumatica.  We have monthly consolidated scheduled ocean shipments. Most of my ‘DEFER” on the exception list is due to we put in on the earlier ocean to arrive in time. For instance, I have a 6/25/25 scheduled ocean, and MRP is telling me to DEF to 7/9/25. I don’t have a 7/9/25 ocean, and need to make sure it’s on the 6/25/25 ocean.  Is there any schedule we can put in for our ocean, or once it moves to “IT-OCEAN-MTL” warehouse, it won’t show to defer or expedite since it’s not possible for either. 

Hi, I currently have new fields on the Tools screen to make it more useful. I have a custom selector called AMToolMstExt.usrToolLocation and AMToolMstExt.useToolWarehouse. The custom warehouse selector works fine, but I want the selector for the location to show a list of locations that belong to the warehouse contained in the custom warehouse field. I am trying to use PXSelector and a BQL to relate the list of locations in the selector to the value stored in AMToolMstExt.usrToolWarehouse.Here is the current setup for AMToolMstExt.usrToolLocation: Here is the current setup for AMToolMstExt.usrToolWarehouse: Here is what currently happens, with all of the locations in the system showing up: In the above example, only the locations starting with ‘03’ should be showing, since ‘03’ is in the custom warehouse selector field.

Hello all, Does anyone know how I can get the Status of a tenant via code (below screenshot)? Is there any service for it? I tried the below but no luckCompanyMaint companyMaint = PXGraph.CreateInstance<CompanyMaint>();UPCompany upCompany = UPCompany.PK.Find(companyMaint, PXAccess.GetParentOrganizationID(companyMaint.Accessinfo.BranchID), PKFindOptions.None);  

I need to dynamically break the page in a report based on transaction volume. The default printing height is 20 cm. When the transaction volume exceeds 20 cm, the report should break after the end of all transactions. Similarly, if the transaction volume is below 20 cm, the report should break after the end of the last transaction before reaching 20 cm.How is this possible?

We maintain nearly all of our pricing at the customer level  (very few at Base level and none at a Customer Price Class level) and the inventory ID has all of our customer cross-references.  When we setup the sales price profile for a customer/inventory ID combination the Alternate ID does not populate if we create the line and enter using the inventory ID.  But if we enter the Alt ID in the inventory ID field, it will replace the Alt ID with the proper inventory ID and populate the Alt ID with the correct Alt ID (b/c we have the box checked to do so on the Accounts Receivable preferences tab.)  Is this a bug that the alt  ID is not populated when using the inventory ID or is the Alt ID only serve functionally to allow you to load pricing using the alt ID rather than a stock item?   Thanks for any help.  

Hi,A client has recently requested that the Source field in the Contacts screen (first image below) be made mandatory as they are wanting to do some reporting on this field. However, now that it is a required field, users can no longer create a contact via the Business Accounts screen as the dialog box doesn’t have a Source field option for them to fill out. They receive the error shown in the third image below when trying to create a new contact via this method.For now, I have told them to create contacts in the Contacts screen and assign the relevant Business Account, but they would like to still be able to add contacts in the Business Accounts screen.Is there a way to add the Source field to this dialog box and ensure the Create Contact process still works as expected? I had a look in the customisation project and I can only choose a small number of fields, as shown in the second image below.Let me know if I can provide any extra information.Kind regards,Andrew  

Please kindly advise, How can I change invoice from 156.54$ to 158.26$ ? and I am using cross rate. Thanks in advance  

Hi, I created a PO using a normal type for a stock item in a project. I created an issue to allocate the expense to the project. No issues there. I applied a PO receipt against the PO and paid the A/P bill. I do not need to reverse the A/P bill. However, I want to reverse the stock item out of the project and put it back to inventory by doing a PO Receipt return. I am on 24r1 and keep on getting this error message below what I am doing wrong? Is there another way to reverse out an expense allocated to a PO and stock item in a project? I don’t have a warehouse 236. Any help would be greatly appreciated. If you need more information I can provide.  Thanks,Frances  

Hi,I created a cost budget line item and created a Project Drop Ship PO on a stock item. I applied a PO Receipt and entered the A/P Bill for the PO. However, Acumatica is creating a duplicate line item like below: but when the expense is allocated to the project via A/P it’s offsetting against the correct line item below:Here are my project preferences on drop shipments:  What I am I doing wrong? Any guidance would help. I am also attaching more screenshots on this issue. Thanks,Frances    

Hi Goodday i want to Add Tax ID and Tax Rate on my report i dont know i keep getting duplicate records when i use APTaxTran i use grouping but it still duplicate record

HI, We have created an employee time card and created a Pro forma invoice.In Pro forma Invoice we have changed the Qty to invoice as less amount.We changed the line status to "Hold Remainder".When we ran the next billing, the system created 2nd invoice lines as we expected.However, the remaining qty(From the Previous bill) relevant lines have been duplicated.Could we stop this duplication? Attached is the screenshot.

Good day.I am not sure what the problem is for the Row Set (ALLACCOUNTS).  I have three accounts that are not showing on the TB and TB Roll ARM Reports.Accounts: 85425/85450/85475.  I thought if I fixed Code 00135 with the Value =@00135*-1. It fix the issue.  No luck.  Any suggests.  I would to not have to fix this when Accounting adds new accounts.   

We have a large number of refunds to write off, the refunds are coming from Shopify→ Acumatica, Is there is a Best process to handle this scenario? I have seen a below article but Looking for additional suggestions. Currently I have created a credit memo for 0.01 and applied to refund to close the document.  

Acumatica ERP allows you to define attributes for various entities. In this article, I will explain how to extend attribute functionality to entities where it is not natively implemented.Before we start let’s look at how existing attributes work.CSAttribute – contains the definition of an attribute;CSAttributeGroup – contains attribute setup for a particular Class. EntityType – entity for which attribute is used, EntityClassID – type of the entity.CSAnswers – contains values of attributes. RefNoteID – NoteID of the entity.In our case entity is PX.Objects.CR.Contact could have different types and you can set up different attributes on each of them.1.  Custom FormStoryYou have:Custom Entry screen with master-detail relations. (ex. Sales Order (SO301000)). Custom Order Type screen where your entry screen settings are specified (ex. Order Type (SO201000))  You need: Attributes tab on the Entry screen which is configured on the Order Type screen. ImplementationStep 1. Order Type Screen.1.