Discussion Forums

Do I have to fill out the ACA Reporting form (PR207000) if I am using Aatrix to file 1095s?If using Aatrix, is there a way to get the system to prepopulate the Policy of Origin and the months of coverage, based on the employee’s payroll data in Acumatica? When I did a trial run, all Policy of Origin boxes and employee coverage month boxes were empty.

We’re looking for a way to track which Invoice or Proforma a specific Change Order was billed on in the Project module. Specifically: Is there a field within the change order,  or a report that shows which Proforma or AR Invoice includes a Change Order? If the Change Order was partially billed, is there a way to see the amount invoiced to date and what remains? What’s the best practice for tracking Change Order billing in Acumatica? Any tips, custom reports, or screen references would be much appreciated!

Hi GuysHoping someone can help with this query.In some instances, we have to manually create a credit note adjustment as the standard way of reversing will not work due to the UK having CIS (UK Tax for Construction).When manually creating the credit note, we cannot add the PO number and therefore, does not deduct the credit amount off the PO to leave a remaining balance.There seems to be ‘Add Subcontract’ but we use ‘Drop-ship’ as this option defaults to the site address where the other PO types do not.Is there any way to get the PO added when manually creating a credit adjustment? Thanks  

Is it possible to override a method in a framework graph abstract class?  I am attempting to override a method in the 24R2 Sales Order entry screen for the Add button on the dialog that opens when the Add Items button on the Details tab is selected -- Inventory Lookup. The method is PX.Objects.Extensions.AddItemLookup.AddItemLookupBaseExt<TGraph,TDocument,TItemInfo,TItemFilter>.AddSelectedItems(). I have tried extending it like this including the full class hierarchy:public class KRSOOrderEntry_Extension : PXGraphExtension<AddItemLookupBaseExt<SOOrderEntry, SOOrder, SOOrderSiteStatusSelected, SOSiteStatusFilter>, SiteStatusLookupExt<SOOrderEntry,SOOrder, SOLine, SOOrderSiteStatusSelected, SOSiteStatusFilter>, AlternateIDLookupExt<SOOrderEntry, SOOrder, SOLine, SOOrderSiteStatusSelected, SOSiteStatusFilter, SOOrderSiteStatusSelected.salesUnit>, SOOrderSiteStatusLookupExt, SOOrderEntry>

Hi community,I have an expression that displays the orderDate and percentage data as on following screenshot. However, I want to hide the time part of both the OrderDate and DueDate, only showing the date. How can I achieve this?= 'Zahlbar bis ' + Format(DateAdd(CDate([SOOrder.OrderDate]), 'd', IIf([Terms.DayDisc] Is Null, 0, [Terms.DayDisc])), 'dd.MM.yyyy') + ' (mit ' + Format(CDbl(IIf([Terms.DiscPercent] Is Null, 0, [Terms.DiscPercent])), '0.00') + ' % Skonto = ' + Format(CDbl(IIf($TotWithTax Is Null, 0,     $TotWithTax * IIf([Terms.DiscPercent] Is Null, 0, [Terms.DiscPercent]) / 100)), '#0.00') +' EUR zu zahlen: ' + Format(CDbl(IIf($TotWithTax Is Null, 0,     $TotWithTax - ($TotWithTax * IIf([Terms.DiscPercent] Is Null, 0, [Terms.DiscPercent]) / 100))), '#0.00') + ' EUR) bis zum ' + Format(    DateAdd(        CDate([SOOrder.OrderDate]),        'd',        IIf(

I’m trying to build a GI that ties a Business Event to the Username who triggered the Action that drove the business event. In some cases we use a ‘kiosk’ style machine to allow people to clock in, and knowing which machine they clocked in on will help us determine who should review their time clock entries.  I have the BPEventHistory table pulled, but I can’t figure out how to show the username of the person who executed the action that triggered the BE.

Is it possible to convert sales opportunities to service contracts? It is possible to create service orders, but I don’t know how to do the same with service contracts. This would save our team 2-3 minutes per contract on 1,000’s of new contracts per year.

I’ve searched here but couldn’t see this specific question asked, but I have a customer who just went live and now they want to increase the length of the inventory ID from the current 15 to 25.  Can this be done safely with items already existing in the system?  Will those items be unaffected if this is done?  Thanks.

Anyone got a working import scenario to create a Project Cost projection that contains all the budget lines from the project that has Budget / Actuals? 

I am trying to connect APInvoice and EPAapproval tables in generic inquiry but both tables can’t be directly joined. I already read some topics here 3 years ago that they can directly connect two tables with note ID. Based on this photo.Is there some kind of modification or setups do I need to do. Thanks community

Hello everyone! I would like to gather some inputs regarding this scenario:Base currency = PhpClient creates a prepayment document directly from the purchase order being created (in $). Suppose that the prepayment created would have an exchange rate of 1$ = 56Php. The prepayment created that time is not yet processed with payment since they still have to buy dollar in their local bank.Now, after a week, they were able to buy a dollar but it is no longer 56php, it was already at 58Php. in the Checks and Payments screen, the cross rate column is changed to 58php but the payment cannot proceed since the system will not allow the prepayment valued at 56php to be paid at 58php. Is there any other way to process this kind of transactions? 

Is there an option in Acumatica to create a credit memo directly from the Sales Order screen using a Credit Memo order type or other suitable order type without generating any inventory transactions?The customer prefers not to use the Invoice screen, as they want the credit memo to reflect the exact customer pricing. Their goal is to issue a credit memo without affecting inventory.

Hello,I am need to definitions for the ItemCostHistory table.  Acumatica help does not have table definitions so I am reaching out to the community for some help.See screenshots belowThank you. 

We use a Sales Order Type with Automation Behavior = ‘Quote’ for quoting Parts and Service inquiries.  We would like to start using this functionality for quoting used product that we take in on trade.  These used products have many Lot/Serial Attributes (we use the GitHub customization) that define Year, Make, Model, VIN, Color, Specs, etc. that we would like to display on the Printed Quote for the customer.  However, it appears you cannot allocate a serial number to a Sales Order with Automation Behavior ‘Quote’ (in order to get those attributes to display on the Printed Quote, you would have to allocate the serial number to the document first).  You can only allocate to Sales Orders with Automation Behavior ‘Sales Order’ based on my testing.  Does anyone have a creative solution?

We have a business event which sends a notification to the Purchase Order Approver.We want the owner of the PO to be notified also. Which screen field should be used so that the PO owners email can be copied in the CC field on the email template? Regards

How can I configure PM301000 screen permissions so that a specific role can only:-Insert new projects (header level only),-Delete lines in the following tabs: Task, Revenue Budget, and Cost Budget,I’ve tried setting “Insert” access for the Projects screen and “Delete” for the related detail screens (Project Task, Project Revenue Budget, and Project Cost Budget), but users can still delete existing records.What would be the best way to achieve this behavior?Thank you!.PM301000 

I want to use rest API to upload item prices against a vendor, can I directly upload to the “Supplier Price” without going through the worksheet hold and release route?

For 24R2, Professional Services was a customization project.  For 25R1, I assume that is replaced by a feature (Enable/Disable Features)?

I’m using a join between ARInvoice & ARTran as well pulling data from FSAppointment. I need ARTran for credit memos detail lines because it wont always match the appointment detail lines. When activated ARInovice-ARTran join causes a duplicate of how ever many artran lines there are. Any workarounds? I cant group by ARTran ref number for some reason as it removes my billable Labour totals. For context RefNBR 008452 in the last picture should just be the first 3 lines but its doing 3x the return because there is 3 lines of ARTrans in the document. 

HI All,I have read the help topic from Acumatica system and read Processing Return for Credit Without Receipt (below link) mention “return without receipt and shipment’.https://aneximports.acumatica.com/(W(44))/Help?CompanyID=Anex+Select+Imports+Ltd.&ScreenId=ShowWiki&pageid=7251c08c-2dc9-4c25-9193-6bb81568e541I read through the whole document and the only suggestion is to turn off “Automatically Release IN Documents” in Sales Orders Preferences so it don’t issue automatically. This is a very tedious solution as I understand it as for all Sales Orders will now need to manually be issue, which will cause a lot more work then just do a credit memo then adjust the items that were return by the CM. Does anyone have a

I am trying to get a report showing detailed BOMs including costing and I can’t seem to find how to do this? Can anyone help?

Hi, There is and GI Tax-AR TCS RMS Wholesaler. When i active the artra.invenotry id and inventoryitem.inventory id its giving me below error.Can any one guide me please. I have tried solution but did not work.  

I have a custom field that interacts with a query to count the number of production order materials with negative quantity requirements. We are using this to indicate byproducts. Here is the DAC for the custom field: Here is the code for ProdMaint:namespace PX.Objects.AM{ public class ProdMaint_Extension : PXGraphExtension<PX.Objects.AM.ProdMaint> { public PXSelect<AMProdMatl, Where<AMProdMatl.orderType, Equal<Current<AMProdItem.orderType>>, And<AMProdMatl.prodOrdID, Equal<Current<AMProdItem.prodOrdID>>>>> ProdMaterials; #region Event Handlers protected void _(Events.RowSelected<AMProdItem> e) { AMProdItem row = e.Row; if (row == null) re

I want to try something and im curious if anyone has tried this. We are using shopify plus and I am having a very hard time importing matrix items into acumatica. The complications I'm having is i don't want to break up my items into separate item classes for now, I simply have 1 item class for stock items and i have about 50 “Variant” attributes for this item class. But the problem is when i try creating matrix items it requires me to inactivate all attributes I'm not using on each template item, which is very annoying and complicated with an import scenario. Here is what I'm thinking to do to simplify. Since i’m never looking to have more than 3 variant types anyway (shopify limit), i want to create only 3 “variant” attributes lets say Varient1, Varient2, & Varient3 and add a regular (non varient) text field attribute right above each variant so lets say Varient1Name, etc. And have this replace the default mapping to shopify for the va

Hi Everyone,We are making an API calls to Acumatica like below but creating lot of API sessions and not logging out from Acumatica. Can you please review and help us on this? Log into Acumatica - Working Creating Sales Orders - Working Logout from Acumatica - Not workingPlease find the screenshot for reference.