Discussion Forums

Hi,I have problem with PXSelector on acumatica 24 R2, bql query worked fine for previous versions but not on the 24 R2. Now it gives odd message “The method or operation is not implemented”. My query looks like [PXSelector(typeof(Search2<InventoryItem.inventoryID, InnerJoin<POLine, On<InventoryItem.inventoryID, Equal<POLine.inventoryID>, And<POLine.orderNbr, Equal<Current<MyDAC.poorderid>>>>>>), typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr), SubstituteKey = typeof(InventoryItem.inventoryCD), DescriptionField = typeof(InventoryItem.inventoryCD))] 

I have this formula that allows me to see the amount of the check like this= IIF([APPayment.ExtRefNbr]<>[APPrintCheckDetailWithAdjdDoc.StubNbr],'** VOID **',PadRight(UCASE(LEFT([APPayment.AmountToWords], 1)) + LCASE(SUBSTRING(replace(replace([APPayment.AmountToWords], '  ', ' '), ' Only', ' and Cents') ,1 , LEN([APPayment.AmountToWords]) - 1  )) , 60, '*' )) But I would like it to be presented in some way as Two Thousand Two Hundred Twenty Three And 00 Cents, what changes do I have to do on the formula?

I’m not sure why (another topic for another time) but I am seeing some astronomical unit cost and extended costs in some of our production receipts. What is the best way to adjust these to get a better inventory valuation?

Hello all,Can anyone let me know if there’s a specific field where I can find the original cost of the subcontract?In the above screenshot, the ext cost column get updated if there’s an increase/decrease in the amount.

The Staff Calendar board and Calendar board give a good illustration on Staff members not assigned to appointments for the day.Appointment Summary provide information on Appointments and can be filtered per Staff member.How do I get the field service staff members per day that has not been assigned to any appointments out in a GI    

Does anyone know how to get a report of line-item purchase history including item description?

Currently the Shipping Module when using integrated shipping creates the shipping labels in ZPL format. Many of our clients want the return label created by the shipment. Is there a way for the Shipping Module to create the Return Label in a PDF form?

Has anyone ever had a report parameter not show up in the navigation parameters on a GI? I made Two simple reports to be used for printing labels. I added a parameter on both. The parameter shows up in the report screens. But when I try to add it to the side panel of a GI, the parameters  arent populated in the navigation parameter pull down. i tried adding existing reports to the new gi and they go in just fine (last screenshot). I created two separate reports today and this happened on both of them. i tried comparing an older report to a new one and i cant find a difference. i also tried copying a report and making a slight change and upload with a new site location and it didnt work either.

I’m just starting to use the Prepmt. Invoices to collect customer prepayments from the Sales Order. It all works perfectly until the moment I prepare the nomal Invoice and try to release it. The invoice status goes to “Open” but I get this error message:  "Sequence contains no elements".The prepmt invoices remain unapplied.Is it a bug or am I missing something in the setup.

I'm working on a query to join GLTran data to Sales Order (SOOrder or SOLine) and need some pointers if anyone knows.From what little I could find, I need to join GLTran and Sales Order through ARTran. I have the join between GLTran and ARTran producing correct results. However, I'm struggling on the Sales Order to ARTran join as it's not producing the correct results. Below is what I have thus far.Any help or guidance is much appreciated! select top 100 *from acumatica.dbo.SOLine sol left join acumatica.dbo.SOShipLine sl on sol.OrderNbr = sl.OrigOrderNbrand sol.LineNbr = sl.OrigLineNbrand sol.OrderType = sl.OrigOrderTypeleft join acumatica.dbo.SOShipment SS on sl.CompanyID = ss.CompanyIDand sl.ShipmentType = SS.ShipmentType and sl.ShipmentNbr = SS.ShipmentNbrleft Join acumatica.dbo.ARTran AR on sl.CompanyID = ar.CompanyIDand sl.Orig

Any other Acumatica users in Canada trying to implement the Tax holiday?We have changed the tax status of all our products that qualify, but any orders that were entered previous to today are still having GST applied. Is there an easier way to fix that than having someone manually change the tax status of every single item on every single invoice? We are a toy wholesale company, so as you can imagine that is a lot of items and invoice we would have to manually touch.

Hello, Has anyone had issues with the Shopify Connector after Change_ID of a Stock Item in Acumatica?Even if the ERP_Id and the External_Id matches, the POS orders from Shopify generate an error that the item is not found in the ERP. 

When you Alt+Ctrl in the SO301000 screen for SOLine details. It gives you the element properties. How do you use this information to add it to an endpoint? Specifically if it is from a customization and not standard Acumatica.

I’m getting a “The given key was not present in the dictionary.” when trying pack one specific item. There is only one UOM on that item, so that’s not the issue. 

Is there a way to remove the page break on the Trial Balance Summary?  Ours currently prints on 3 half pages.  That is a lot of wasted space and paper.

I’m fairly new in working on Generic Inquiries, and would like some guidance on how best proceed. I’m attempting to pull in attribute values from inventory item on a quote. My existing table is below:​​​All of the Join Types are set to Inner:When I view the inquiry, it is essential replicating the lines: The quote itself only has 4 items: 

I have 3 seperate Transfer Sales Orders that were completed in the past that are still being calculated in Inventory Planning. Transfers were made, shipments were completed, but when I regen IP the system is still counting the transfer quantity as expected inventory, leading to a lower purchase demand (or no demand).  Are these transactions just a “stuck” transaction, or is there another step that I am missing?

Hi, We’ve recently upgraded an environment from 2023 R1 to 2024 R2. Things appear to be working fine besides some Customization Projects in the Customization Project Editor. It appears that if a Customization Project has a screen, it throws an error when loading the Customization Project Editor window. Here is the error:This happens both on a pre-existing Customization Project before the upgrade, as well as a newly created Customization Project after the upgrade after a screen is created.The look of the menu is off as well in the Customization Project Editor, my guess is the Exception was thrown while building the menu.After doing some digging, I found the following stack trace with the exception matching the error above:

I have two Generic Inquires exposed to OData. I can use the API to query one of them without issue, but the  other one always fails. In particular, it returns a partial fragment of the results and then the HTTP connection drops with our HTTP library (curl) reporting this error:“HTTP/2 stream 0 was not closed cleanly: CANCEL (err 8)”If I force HTTP 1.1 instead, the behavior is the same, but the error says “Connection reset by peer”.Any troubleshooting suggestions would be appreciated, thank you!

All,I was tasked to modify a customization package created by my predecessor. I’ve made most of the changes easily, but one last seemingly simple detail is hanging me up.We have a custom dialog with checkboxes, and I discovered it was coded with three additional generic checkboxes for future use. These controls are currently labeled Ink 1, Ink 2, Ink 3.We would like to change these to more specific names, but I’ve found no way to edit them. Am I blind or stupid? Maybe both? Screenshots below. :) (the third screenshot is where I tried to override the label text). 24R2.

We just upgraded to 2024 R2 last night.  We drag invoices into the Incoming Documents screen.  In the upgraded version, we can’t drag in the invoice.  Nothing happens.  Has anyone else experience this or have a fix?I tried disable / enable AP Document Recognition Services and that didn’t fix the issue.

Hi Team, I have a prospect who has a foreign exchange bureau. Is it possible to use Acumatica for this business?Do we have an ISV for the forex exchange business?

Please kindly advise which point that I had do it wrong and please advise. Do I need to create manual Vendor Class on system.Thanks so much 

IDear All, could you please advise which point that I had do it error? Please kindly advise because I don't know which point that I had error. Thanks 

Hello,when i create a shipment, which is not assigned to a specific purchase order, i can upload my serial numbers with the help of the import option.This option is missing when i create the shipment in a purchase order. Is there a possibiliy to activate this option?If there is no option avaiable, what would be another easy alternative to import my serial numbers?Thanks in advance.