Hi,I’m currently working with a customer regarding their integration to retrieve Labor Cost Rate via REST API. Does this API endpoint use pagination like Employees(entity)? Do you have any API documentation?
The report itself is rather simple. It’s a profitability analysis report where I have to show how much item we have sold to a customer, filtered by date. The formula for my Qty field right now is:=sum(IIf( [ARTran.TranType] <> 'CRM' AND [ARTran.CuryTranAmt] >= 0, [ARTran.Qty], 0 )) - sum(IIf( [ARTran.TranType] = 'CRM', [ARTran.Qty], 0 ))which lists the items we sold to the customer for a cost. Now, we also give out free stuff to our customer, and for that, I use this formula:=sum(IIf( [ARTran.TranType] <> 'CRM' AND [ARTran.CuryTranAmt] > 0, [ARTran.Qty], 0 )) - sum(IIf( [ARTran.TranType] = 'CRM', [ARTran.Qty], 0 ))I was using VisibileExpr field under properties > behavior to switch between formulas from a parameter where user selects if the report has any free items or not. Is there any way to do it without using VisibleExpr? I was looking for a way to do the same thing I’m doing right now, but simpler.. Maybe using just one field for Qty rather than using 2 and re
We are trying to close an order and the following error is generated “The status of the production order cannot be changed because it has related transactions that are not released.” We have ran all product we needed and returned any material that needed to and we are ready to close this work order.I have referenced other related topics and we have reviewed all transaction related to the work order and all show released and posted. This order does not prevent us from closing the month which further validated all transactions have been released and posted. Any help is appreciated.
Received this error when trying to calculate depreciation for this asset.
In all the Sales Profitability Reports there are two flags to choose: Released Transactions Only and Completed Transactions Only.Released Transactions Only is easy to understand as it will display only released invoices or all invoices regardless they are released.My question is about Completed Transactions Only. What does actually mean completed transactions? I thought it was closed invoices but, based on the testing I did, it does not seem it is that.
I’ve trying to create a simple purchase order but running into all types of problems. Can anyone explain why this isn’t working and offer a solution?I’ve attempting to create a simple PO containing 1 inventory item. There are 2 methods below, both fail. Setting properties directly. public POOrder CreateTransactionPO1(InventoryItem inventoryItem){ POOrderEntry graphPOOrderEntry = PXGraph.CreateInstance<POOrderEntry>(); POOrder pOOrder = (POOrder)graphPOOrderEntry.Document.Cache.CreateInstance(); pOOrder.OrderType = POOrderType.RegularOrder; pOOrder = graphPOOrderEntry.Document.Insert(pOOrder); pOOrder.VendorID = ((BAccount)Base.Select<BAccount>().FirstOrDefault(x => x.AcctCD == "ABB001")).BAccountID; pOOrder = graphPOOrderEntry.Document.Update(pOOrder); POLine pOLine = (POLine)graphPOOrderEntry.Transactions.Cache.CreateInstance(); pOLine.OrderType = POOrderType.RegularOrder; pOLine = graphPOOrderEntry.Transactions.Insert(pOLine); pOLine.InventoryID = inventoryItem.Invento
On screen "Pick, Pack, and Ship", (SO302020) I am trying to make some changes, but it is an odd screen so any ideas would be welcome. I have managed to make some changes and I am spending a lot of time in the debugger trying to understand what I can do but I haven't got that far yet. I have been working with methods and events like:SOShipLineSplit_RowSelectingSOShipLineSplit_RowSelectedSOShipLineSplit_LineNbr_FieldSelecting These don't fire when I would expect. They don't fire when I click on the grid. Perhaps this is because the grid is is not editable. I don't see how to change this. Basically what I ideally want is to detect when a row is selected or clicked on and then run code populate the Scan field with the Inventory Code. I could also do this from the header on a button or something, but when I play with events on the header and get a link to the table I can't see a selected row in there so I am stumped.// Acuminator disable once PX1045 PXGraphCreateInstanceInEventHandlers [Jus
We have a customer who would like the ability to enter Sales Tax information for Customers and Locations in Acumatica, including an uploaded certificate image, and have that same information populated in AvaTax’s Certificate Management database without having to manually enter it. We’re aware of a library of APIs Avalara provides, and we’re wondering if anyone has developed scripts to accomplish this? The overarching goal is to enter the data once rather than having to add the info in both Avalara and Acumatica. The other driving factor is that customer exemption information entered in Avalara is not visible in Acumatica and requires users to log in to Avalara to determine if a customer already has an exemption certificate on file.
Hi, I have this error someone change the password on my account on sql, and i have this error.I already change the password and try to Log in on the Tenant Maintenance with this password and Acumatica let me pass straight to other steps.I have the tenant on the same version 23.108.0020 and idk the error says can't get the version.
Customers are being alerted by FedEx that the development for the FedEx Web Services (SOAP) integration has been discontinued in preparation for its retirement. FedEx is suggesting to modernize the integration by using the FedEx API (REST) solution. Does Acumatica have a schedule for the conversion of the FedEx plugin to use the FedEx Rest API services?
Hi,My final target is to create a Business Event in order if Regular Time is Over 40H and is submitted, to put a timecard on hold, and send a SMS to the employee to notify him to correct it. So my target is to have the total Regular Hour for a given timecard. My problem is i don’t find bounded field with this total. I see bounded fields like Total, total of overtime, total billable, but no total of Regular.It’s acheivable to do a grouping in the GI or a calulation, but theses two things aren’t compatible with the business event!Other option could be to customize and put the warning as an error, but I dislike it because that prevent saving the timecard, and the person could loss is data.Thanks
Hi,A client is having an issue where the Owner field in the Purchase Orders screen is always empty.I found the existing question below about this issue, but the selected answer didn't work for me.Is there a different way that this Owner field should be populated now? If so, what is the best way to added options for this field?Let me know if I can provide any other information.Kind regards,Andrew Purchase Order owner | Community (acumatica.com)
Hello Acumatica Community,I'm curious to know if there's a way to link an image uploaded within Acumatica to a notification template without the system sending the image both as an embedded item and as an attachment in the same email.I've been encountering difficulties trying to achieve this functionality. Despite successfully displaying the image in the HTML where it's intended to appear, it's also being attached when the email is sent out. Interestingly, when I check the Email Activity at CR306015, it doesn't seem to be added as an attachment, yet it arrives in that manner.Any insights or assistance on resolving this matter would be greatly appreciated
Hello. I am looking for an idea or a solution to a problem. We have noticed a bug that is triggered when there are too many panels in the detail section, or when there is a section with "PrintOnEveryPage" in the middle of the report without the "PrintAtBottom" attribute. Under these circumstances, the actual footer moves up and down instead of staying where it should be. Is there another way to circumvent this problem other than not using panels in detail sections or working without "PrintOnEveryPage"?
I’m getting this error despite all my addresses being US addresses. Carrier Service returned error. DHL Express:This DHL account is owned by EasyPost and does not support non-US origin shipments. Please link your DHL Express account to continue with the shipment
Get Started HERE and be sure toIntroduce Yourself
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.