Discussion Forums

I have an AP employee who is trying to use the Additional Remittance Form and it seems regardless of Cash account, Payment method of other fields entered it always prints out a blank page when the report is run. I have not been able to get it to print anything but the AP employee says that it prints out what they want at least 50% of the time. does anyone have experience with this issue or know what might be causing the problem?

We have a report where we concatenate the InventoryID and the Description fields.Is there a way to bold the InventoryID while leaving the Description portion of the string normal/Thank you!

Hi,We have a client that wants to import A/R Invoices and Payments into Acumatica using files that have pipe delimited txt, csv, txt, or dat extensions and also export data from Acumatica using the same file extensions. Is this possible? Any help or reference guides would be great.Thanks,Frances   

This new feature is a very useful one.  I assumed that it might take into account the corresponding vendor price breaks for different volumes but now I am not so sure.  The documentation does not mention this.I suppose that it would mean that the estimate pricing process would need to do an MRP look up, but anything is possible.  Also vendor pricing of materials by volume is one of the key factors in unit cost changes by volume.Does it ?ThanksJames  

I have an inquiry that shows all Bills who need to have the Pay by Line box checked (next I am doing Invoices and Memos). I have a business event that triggers off an import scenario every time a new qualifying record is created. Below is my import, it shows that it runs successfully in the event history, but the PAY BY LINE box is never checked like I need. Anyone know what I may be missing??? I have tried setting the checkbox value to:=’1’=1=’True’=True Nothing seems to stick. The history says it accessed the proper document, but nothing is ever changed. Thanks for the help!

I’m planning to make the SOOrder.ShipVia field required and want to add an error message to help our employees.I have found a couple of examples but am working with this right now:namespace PX.Objects.SO{ public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { #region Event Handlers protected void SOOrder_ShipVia_FieldVerifying(PXCache cache, PXFieldVerifyingEventArgs e) { var row = (SOOrder)e.Row; if(row == null) { string errorMsg = "Ship Via Cannot be Empty"; throw new PXSetPropertyException(errorMsg, PXErrorLevel.Warning); } } #endregionNot being a programmer, I’m sure there is something simple missing, but I would appriciate the help.  

Hi! What would cause emails to be stuck in Email Pending Processing Screen?I am using expense approval email template to automatically send email to approvers that there is an expense pending approval. Some emails go out fine, but some remain in the Emails Pending Processing screen. When I hit the ‘Process” button, no error is given, and email goes out perfectly. But is there a way for email notification to send out automatically without having to hit “process”?

Hello,Can someone please help me with a null formula in my GI. If my customer reference number field is NOT blank, I would like it to have Blue or Blue Font. Here is what I came up with: =IIf( [SOOrder.CustomerRefNbr] <>' ' , 'blue40', default) The result is everything is blue.  

Apparently you can Void an AP or Quick Check that has already been marked as cleared and/or reconciled in the system.  I put a ticket in with the Acumatica support and was advised to put in an idea for product change.  Has anyone else found this and addressed this issue?

I am trying to create a Selector Type Attribute, to use in a User Defined Field, in Cases.  The purpose is to select from a list of sold Serialized Items to track cases for warranty.  Any ideas?  I have tried various tables, but none provides a resulting list of serialized items.Thank you

Is there a Sales Order type which is not considered in inventory replenishment even the items has replenishment parameter's defined.If there isn't any order type like that then what would be the best way to neglect item from replenishment for certain orders and consider the same item in replenishment for the normal sales order.The purpose is to sell the damaged goods returned from some customer to other customers who are willing to buy it, but these orders should not be considered in replenishment.

I have to do a customization in the production order maintenance screen where in the line details tab there is a generate button to create the line in sequence 000001 and so on.But I want to change it to grab the production number for example (PP000004) and the lot/serial number generated is PP000004-000001, PP000004-000002, PP000004-000003 and so on till the quantity to generate is satisfied. How to achieve this via customization? The generate button needs to be extended to change the Lot/ Serial number, any help would be appreciated! Thank you!

Hi,i wonder if there is a documentation for the API the ReportDesigner uses to query, download and upload reports to an instance?We would like to create a tool to sync a local directory of reports with an instance. Instead of doing them one by one with ReportDesigner.RegardsPascal

When I go to close a production order I sometimes get an error that says there are open transactions that need to be released before the production order can be closed. This all makes sense but I find it very difficult to pin point which transaction (materials, labor, or move) isn’t released. In most cases it’s a second materials transaction that someone forgot they started and created a new one. Unfortunately the unreleased transactions do not show up on the events page of the production order (which also makes sense). How else can I track down what transaction is holding up the closing process?Thank you!

Hi, We want to disable print option on sales order  whenever it is in pending approval or open status.In our scenario we want to disable to print forms. I have tried solution advised in below link but it work only disabling one print option and not both. When I tries adding second condition first print option is not visible instated of getting disable.  Customization project for first print form:  Customization project for second print form:   

RequirementAfter clicking "Prepare Invoice" on the Shipments screen, I need to recalculate the invoice line items to match the actual quantity for the credit card charge. For instance, if the Sales Order (SO) has a quantity of 10 but only 2 have been shipped, the credit card fee should be based on the 2 quantities instead of the original 10. This involves two steps:Recalculate the invoice line items and update the document total accordingly. Once the recalculation is complete and the document is ready, programmatically trigger the capture button on the Applications tab.I’m currently using the ARInvoice_RowPersisting event in the SOInvoiceEntry graph. While the recalculation works well, I’m struggling to find the right place to invoke the capture button. Whenever I attempt this, I encounter an Acuminator warning, and in some cases, it leads to an infinite loop or stack overflow exception.I would appreciate your assistance.CODE /// <summary>         /// AR Invoice row persisting e

Hi everyone,I created a new customised processing screen based on the logic of the SO505000: a filter provides a list of actions; when the user selects one of them, the invoices affected by that action are displayed in a grid below. Finally, a dedicated method is invoked, depending on the action chosen, when the user clicks on the ‘Process’ button.This works very well, but I've run into a problem: on a local instance, the processing dialog appears every time the ‘Process’ button is pressed, and this is the expected behaviour  However, on a remote instance (saas), the process dialog appears just once, on the first execution after publishing. Thereafter, it doesn’t appear anymore even if the process is actually executed. I don't see wha's wrong... Below, the DAC used to describe the filter :public class ARInvoiceEIprocessFilter : IBqlTable{    #region Action    [PXUIField(DisplayName = "Action")]    [PXDefault(ARInvoiceEIProcess.DefaultValue)]    [PXStringList(        new string[] { ARIn

HiI need help because i want to view my RefNbr on my GLTran base on my module   but when i click this it is not getting the record of the refnbr

We have few attributes with multi-select control type.AttributeHowever, when multiple values are selected, the values are concatenated in the database. Below is a database snapshot: Db snapshotWe have a GI that is using this attribute as a parameter. We would like to filter based on individual attribute and not look for a specific combination. It doesn’t work right now as it keeps looking for a specific combination of attributes  Is there a way to store this differently in the database or a way to separate them?

I don’t understand why a change order we have in ‘Canceled’ status would contribute to the ‘Potential CO Amount’ in Project Balances.  We canceled it so that we had the history of what we originally priced, so it is worth while to keep the data around (rather than deleting), but it shouldn’t contribute to ‘Potential’.  Is there a good reason for this that I'm not understanding? 

In the Invoices Form, Tax Details tab there can be instances where 2 taxes are applied as below.We need to get both these tax values to the report. I have used this join for that purpose.But this join takes only one tax ID to the report and the detail lines end up getting duplicated. How can I avoid this issue?

I need to limit Requests view so employees can see their own Requests or those of employees in their department (field on Request). I can easily limit users to their own requests using RQRequests.CreatedByID = @Me in the GI condition. But I need the equivalent of “Or RQRequests.DepartmentID = @Me” . Problem is, @Me doesn’t work for DepartmentID field. Does anyone know how I can accomplish this?

Hi,I’m having trouble with one of my projects.I created a screen linked to a table I made. When I select my client through the selector, the client’s data is displayed in the designated fields. However, when I try to add new data by pressing the "+", I encounter a problem: the default client ID is set to -2147483647. When I enter information into the form and save, two rows are created in the table—one with a new ID but empty fields, and another with the values I entered into the form. 

The QTY on hand shows 0, Available QTY is 5 and available for shipping read 0 also, what is might be the course of this difference

Hi,I'm encountering an issue with Manufacturing Backflush. I have a production order where all the component materials are set to backflush. The problem is that, despite having sufficient stock in the warehouse, the system is throwing an "out of stock" error during the move transaction. There’s plenty of inventory in the system, but it’s not being recognized during the move. Is there a specific logic that the system follows when selecting a location for backflushing? I’ve noticed that when there is stock in the location defined in the production header, the error doesn’t occur.  I believe the system should check all the locations within the warehouse that are set to "production allowed.