Discussion Forums

I am trying to collect strings for translation. I have created a Translation Set and added some screens which I need to translate. After this, when I click “Collect”, the process shows error after running for some time “Another process has added the 'LocalizationResource' record. Your changes will be lost.”

I want to be able to create a side Panel on the Vendor Form,  In the side panel i want to view the vendor Inventory.Display this as a side panel on the above. But when i go into the customization, and try to add the vendor Inventory in the destination this view is not available in the list.What do i need to do to have the Vendor Inventory as a Side Panel on the Vendor Form?    

Good morning allI'm sure this is a simple question but currently I can't for the life of me think of what I should do.  I have 2 invoices that have been paid via BPay - so the payment has gone through as one.  It isn't letting me match the two invoices with the payment - even if I tick "Match to Multiple Payments".  Any help on this very wet and windy (Cyclone is coming) Friday morning. 

Is there a way to apply a specific certificate signature to a given report?Ideally a fully PAdES compliant PKCS#11 cert on a user by user basis instead of a global one.

Hi!I’m wanting to use audit history to report on when a Project Task went from Active to Completed or Cancelled for example? Has anyone does this before, or can recommend the right table to use in a GI?

I am trying to build an import scenario for using the “Generate Time cards” button on the History tab of an employee / Actions button on employee, but it says its run, but the timecards actually do not generate.I can do them manually so its not due to my user setup.  I have tried using Dialog Answer OK, and the actual button says GENERATE but that doesnt work at all.Has anyone done this sucessfully? 

We are currently in the process of upgrading our Acumatica instance from 22.120.0019 to 23.109.0023.During the testing of our API integration, we have noticed that we are no longer able to push through a Sales Order that has a negative value in the Unit Price field, and we are presented with the following error: Incorrect value. The value to be entered must be greater than or equal to 0. I tried to capture a SO manually, to check if the same issue exists, and indeed it does:If I attempt to save the SO, it changes the value to 0.00 Question:Is this ability now completely removed, or is there a configuration setting relating to this that I can change to allow the negative value?PS. I searched through the release notes for 22R2 & 23R1, but I couldn’t find something specific to this.

One of our reports, the print invoice report, is now showing multiple of the same item. I assume its from a bad join, but I’m not sure where it is or how to fix it. 

Good day,I have multi branch/company environment.  I have a new Canada Company starting shortly.  Based on what I read so far is the CA Company needs a based currency of CAD and a separate ledger.  All the CA company transactions will be done in our CA Company, separate customers, vendors, etc.  Also a new cash accounts.Ledgers:  Do I need two CA Ledgers:  One for Actual and One for Reporting? Translations:  I need to be able to report in CAD and consolidate/translate into USD for consolidated reporting.My overall needs are to have CAD reports for taxes and Consolidated reports for Overall company financials by branch.Thank you in advance for your assistance.Evan

If a WC has multiple machine, I cannot stop Acumatica from scheduling the one WO in multiple machines. My customer wants to schedule only one work order per machine, so we have each machine as a WC with only one Machine.Based on Demand and capacity analysis, we have fixed machines for each SKU. the client checks the WC capacity and updates the WO’s Work center before releasing and scheduling. I am able to update the work center manually in the production details screen after putting in on HOLD. But I need to update the Work Center of open Work order via import, because at any movement I can have hundreds of work order which are open and which need WC center update.

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.OrigOrderType = ar.SOOrderTypeand sl.OrigOrderNbr = ar.SOOrderNbrand sl.LineNbr = ar.SOOrderLineNbr 

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.