Discussion Forums

Hello,The column name shown in the image above is row 2 in the EXCEL file.  Row 1 is the column headers.  I have copied and pasted values into a new spreadsheet etc. trying to get past this.  Seems to be an EXCEL thing but I cannot find how to get past this.

I’ve created a report that groups Inventory Items so that I can sum Qty Produced for each item over a given time frame. The goal is to have a column for Inventory ID/Description, a Qty Produced Goal Column, and an Over and Under Column for the sum/difference where an item was over or underproduced where even if the item has not been produced, it would still show on the report. For instance, no CHOC400 had been produced, it would still appear on the report, where:Goal = 700Qty Produced = 0 Under: -2060Instead the report is only showing if the item has been produced. So, for example, an inventory ID, CHOC400 which has not been produced this month, isn’t showing at all. How can I fix this? I’ve attached a copy of the .rpx version of the report that’s saved as .doc so I could upload it.  

Hallo,und zwar ist uns aufgefallen, dass wenn ich einen Haupt Produktionsauftrag AM201500 habe, und bei diesem dann die Aktion “Aufträge für Unterbaugruppen generieren” ausführe, dass dann die Unteraufträge erstmal richtig Terminiert werden, gegen Unendliche Planung.Wenn ich jetzt jedoch “Produktiosaufträge Grobplanung” AM501000 verwende und z. B. den Hauptauftrag nach vorne verschiebe, vom Termin her, und dann den Hauptauftrag und alle dazugehörigen Unteraufträge (sind in Referenzen miteinander verknüpft) zusammen neu einplane gegen endliche Kapazität. Dann werden die Unteraufträge nicht wie erwartet richtig vor den Hauptauftrag Terminiert, sondern alle werden als eigenständige Produktionsaufträge behandelt und Nicht zusammengehörig eingeplant.Gibt es hier also eine Möglichkeit zusammengehörige Haupt und Unteraufträge ordentlich zu Terminieren?

ISSUE: Logged time from Service Appointments transferred to the employee time card is always not checked as “Billable”, so we manually have to check each line in order for it to be calculated correctly.POSITIVE POINT: Any logs coming from projects are automatically checked as billable. As you can see below, all items coming from appointments are unchecked. Those that have projects involved are checked.If I go into the Earning Type Codes, I can set the default coming from projects to be ‘Billable’, which is great! QUESTION: How can I do this for any logs coming from Service Appointments? Any ideas?Thanks in advance.

Is there a process to copy Access Roles between Tenants or sites?Thanks.

We’re about to start our first phased construction project & I’m struggling to figure out how to get it set up.  We use (what I think) is a pretty standard NAHB set of cost codes that follow a 5 digit format where the first two digits are the major categories and the last three are the detail description of the cost.  So we have:01-000 general requirements 01-310 project management 01-510 temp power 02-000 site works 02-100 demolitionand so on.  The major categories from 01 thru 29 are hard costs.  30 is land costs.  40 and beyond are soft costs.At present we enter all five digits into the costcode field and duplicate the first two digits into the projectTask field.  This allows us to get subtotals for the major categories (but we can’t get totals for hard costs, soft costs & land costs).As we start planning on an upcoming phased project I want to drop the redundant data entry into the projectTask and

We are having a problem trying to use Create Transfer Orders, in that when we try to process we get an error that CS cannot generate the next number.   This causes two problems.  We have to create the transfer manually,  and the prepare replenshment report wont reccomend a quantity because there is a value “in replanned” Does anyone have ideas on the cause of the errorAlso, does anyone have ideas on how to clear those items “in replanned” Much appreciate any feedback  

2 warehousesManufactured item had demand for 100I have none in the warehouse with demand.I have 100 in warehouse that does not have demand.Using MRPI want to create a production order to meet demand, UNLESS I have quantities in the second warehouse.  Then I want inventory planning to tell me to transfer these.Since the source is MFG, inventory planning tells me to build when I could do a transfer instead. Same question on purchased items.Is this a thing in Acumatica?Thanks!

So for certain customers we use a non-stock charge item on the SO/Invoice. If this particular case the SO was create that had 10 units of stock item X, and a second line item for the non-stock item for Qty 10. We had to short ship the SO, so only shipped 9 units of stock item X. (As you know non-stock items do not populate on shipment)When we prepare the invoice the stock item comes over correct @ 9 units, but the non-stock item still defaults to the SO qty of 10 and cannot be changed nor deleted. The only way I can see to fix with is to delete the shipment, change the SO qty. We would not want to do this because I want to see the original source of record, the SO and the qty, and what we shipped. I want to see that 10 were order but only 9 were shipped.Is there a config change needed in the non-stock item setup? Seems implausible that I need to delete the shipment and change the SO, but wanted to get the opinions of the group before I did that.  Thank yo

In our test environment, we’ve created a Non-Stock ‘Freight Estimate’ item to add to Sales Orders so we can authorize a credit card payment before the shipment.  The ‘Require Shipment’ box is unchecked and the settings for our Sales Order Preferences, Order Type, Shipping Rule, and Non-Stock Item are identical, but in our Live environment it is left off the Shipment (visually), but is pulled onto the Invoice and shows the Shipment # on the line.  This does NOT happen in testing which is the desired behavior. We have ‘Add zero lines for Items not in Stock’ checked and we give the ‘Freight Estimate’ a quantity of 0.   Does anyone have any info on why a non-stock item that doesn’t ‘Require Shipment’ is being attached on the back end to the shipment..and messing up our invoices? This issues has been driving me and our Partner nuts.  Nobody seems to be able to figure it out, so I’m really hoping someone here can help us out.  I can post a ton of

Hello!I want to create a journal transaction by using the import scenarios of business event. To this I use a Generic Inquiry. Generic Inquiry only provides information about the credit entry, and the information for debit entry is fixed.  I tried to get the journal transaction created in different ways but it only create debit leg of the transaction. Then I thought to go with the journal vouchers, but the issue is the credit and debit entries should go for two different branches and journal vouchers does not facilitate that. Can someone help me with this?Best Regards Amanda 

I have a bunch of .NET “jobs” that sync and pull data from Acumatica for use in an external eCommerce website.I often hit the login rate limit error and have been told to make sure I logout after each iteration. I call the /identity/connect/token endpoint and pass in my client_id, secret, API Username and API Password with the grant type of password. Its a typical oAuth flow. In testing via postman, I have logged in, did a simple GET query to return some data...then call the logout endpoint (with my bearer token). It returns a 204 success status code. /entity/auth/logout The issue is, I can go back and call the GET query to return some data. I would expect that my bearer token would be invalidated and that GET call would fail. However, it still works. This leads me to believe that I

Hello,I have created a query that lists the components of received items. My goal is to use this management event to automatically create outputs of components when the parent item is received. However, the event is not triggering as expected.

Is there a way to configure Inventory items to allow or disallow cash discount?For example: I don’t want Cash Discount on Delivery/Packaging.

Hello all,I have tried to modify the current workflow as: This Test Workflow is an extension of RO WorkflowBut still when the PO is in Open status. the field (Time Only Value) is still disabled. What is it that I am missing here?

Situation:There are the following warehouses:Warehouse1 Warehouse2Each warehouses has the following locations:Location1 Location2 Location3The default warehouse in the User Profile is Warehouse1. Thus, when using Scan and Transfer, that warehouse is auto-selected.The transfers are always within the default warehouse.Problem:In Scan and Transfer, when I scan the Source Location (for example, Location1), I get this message:The Location1 location is defined in multiple warehouses.Scan the barcode of the warehouse to which the Location1 location belongs.How do I stop this from happening? I want it to use th

  I need to implement the same logic on a custom screen. When I click the custom button, it should pop up a dialog box like the inventory lookup (see the image below). I need to select from the grid and have options to Add, Add & Close to the detail tab.What are the steps to implement this, and where can I find the relevant code?  

Hello members,When attempting to split an asset in Acumatica, releasing the created transaction results in an error stating that transactions cannot be posted to a suspended period in Book 'GLPOST'. Does anyone know how to resolve this?Thanks,Catherine

Dear ALL,In the Customer screen > Account Email > When you enter consecutive Emails > click Enter, it will automatically create space between the Emails.Because we integrated the data with other software and got an error because of this space.How to turn off automatic spacing between Emails ?  Best Regards,NNT

​ Iam wondering if it's possible to Lock the Line description for the sales team to not change the description anymore. I looked in the settings but couldn't find a solution 

Hello all,I recently import a change in the names of the Inventory IDs. So the thing is I have 2 Items(3026) with same IDs but in different classes (A & B).1. 3026 - Class A2. 3026 - Class BAnd I had to import the change in the Inventory IDs (eg: S3026) for Class B which was imported perfectly fine, validated on the Stock items screen.But when I saw the PO created for both these items, the PO is now showing the change in the IDs for Item belonging from Class A too. How can I now resolve this?

Hi I have a requirement to set up discounts for specific set of items which have the same price class, from one specific warehouse and to some specific customers. In the discount codes I don't see an option for this. Is there any way that I could set up the discount? The example is I have some items in a clearance warehouse, For my best customers sold with an additional discount.  Additional Discount is given only for  some selected Items.Thank you,Dulanjana

Is there any way to extend a group across multiple columns? Or is that not supported? For example, I have a logical group of multiple columns that I would like to be under the same header (see below) but not sure that’s possible. Or at least how I would have assumed to do this is not working as expected.  Not really a big deal aside from looking better, but also because the data is separated (in this example for extending an endpoint) when fields are in different groups. It just looks strange when they should both be in the Primary Info group.  Obviously I could just place them all in one column and problem solved, but it just looks better when spread across multiple

Hi Team,I have created a Custom Attribute to sort using serial number for the Tax Category selector. Sorting is working as expected, but instead of Passing the Tax categoryID, it is passing the serial number from the selector as value to UI, when i do the selection.Please help me on this. public class CATranEntry_Extension : PXGraphExtension<PX.Objects.CA.CATranEntry>{    public PXSelect<TaxCategory, Where<TaxCategory.active, Equal<True>>,    OrderBy<Asc<TaxCategoryExt.usrSerialNo>>> MySelectorView;    #region Event Handlers    [PXMergeAttributes(Method = MergeMethod.Merge)]    [PXDBString(TaxCategory.taxCategoryID.Length, IsUnicode = true)]    [PXUIField(DisplayName = "Tax Category", Visibility = PXUIVisibility.Visible)]    [CATax(typeof(CAAdj), typeof(CATax), typeof(CATaxTran), typeof(CAAdj.taxCalcMode), parentBranchIDField: typeof(CAAdj.branchID),    CuryOrigDocA

Hello, I’m pretty new to adding customization projects and was wondering if I add new column/data fields on the Sales Quote Form in the Details section, do I also need to add those to the Sales Order Form and Shipment form? When I tried adding one earlier, both the Sales Order and Shipment pages gave me the "object reference" error, so before I added anything else just wanted to see if that could be what is causing that issue.  My thought train is because you can generate a Sales Order from the Quotes, the Sales Order “form” is looking to transfer that data field but can't because it's not in the SO Form.