Discussion Forums

Hello, I am working on creating an Action to preview and send an email created from an email template. I have the email template created and now I want to add an action to a page to call the template and show a preview where the user can edit the email if necessary. However, I am not finding anything on this. Any help is appreciated.Thanks

it looks like some of my fields are missing. it suppose to have this but i see only thishow do I get it in the is table of InItemCost

Good day,Attached is what I thought would be a simple import for Funds Transfer data.  Any ideas where I have issue.  I am not sure if it my file or the scenario.Any suggestions.I appreciate your assistance.Evan

Hi Acumatica,I am trying to add a customer Attribute DEALERCODE to the customer statement; however, when I refresh all on the tables, I lose fields rather than gain the Attribute I am looking for.  It is the out of the box Customer Statement report, but I cannot get the Customer Attribute I am looking for to show up I was able to get it to pull in on the Invoice and Sales Order layouts, but not this Customer Statement. Any suggestions? Thanks,RJ

Using 2021 R2.  We have an order that was shipped in full in one shipment.  The order stays in Back Order status.  Why?

Hello everyone,I have a customer asking whether Matrix items can support the bill of materials (BOM) functionality. Where can I get some information about that ? Thanks

Hi everyone i need one help very important. There is one report which is called as" Sales profitability by Item class and Item(Detailed). In this report customer told me to add one column as Qty. I have added but it not working as a date time period For ex:- From -13/06/2023             To - 1/07/2024              Qty - 604,69.00             Net Sales - 674,69.00             It Should be Same as Net Sales I have tried by adding INItemSiteHistDay using table and added the relation "InventoryID - InventoryID" Plz help me how can i fix this and show proper data in the Qty field.

I try to clear error and reset new value in post code filed update but not clear and not set new value. if input right code it’s ok but I input wrong code, i will raise error message and after I reinput the right code again it’s not clear error and not set new value.protected virtual void _(Events.FieldUpdated<CRAddress.postalCode> e){    if (e.Row == null || e.NewValue == null) return;            e.Cache.RaiseExceptionHandling<CRAddressExt.usrDistrict>(e.Row, null, null);             if (postal.Length == 4)            {                string province = postal.Substring(0, 2);                string district = postal.Substring(0, 4);                e.Cache.SetValueExt<CRAddress.countryID>(e.Row, "KH");                e.Cache.SetValueExt<CRAddress.state>(e.Row, province);                e.Cache.RaiseExceptionHandling<CRAddressExt.usrDistrict>(e.Row, e.Row, null);                e.Cache.SetValueExt<CRAddressExt.usrDistrict>(e.Row, district);           

I am trying to create an AWOE screen from scratch and have extended the ScanHeader to include the fields I need.   simplified I have this (I have tried WMSScanHeader, QtyScanHeader, ScanHeader also) :  public sealed class TestingScanHeader : PXCacheExtension<ScanHeader> {#region HdrOrderType[PXDBString(2, IsKey = true, IsFixed = true, InputMask = "")][PXUIField(DisplayName = "Order Type")][PXSelector(    typeof(Search<AMOrderType.orderType>),    SubstituteKey = typeof(AMOrderType.orderType),    DescriptionField = typeof(AMOrderType.descr))][PXDefault("RO")]  // Set default value to "RO"public string HdrOrderType { get; set; }public abstract class hdrOrderType : PX.Data.BQL.BqlString.Field<hdrOrderType> { }#endregion#region HdrProdOrdID[PXDBString(19, IsKey = true, IsUnicode = true, InputMask = "")][PXUIField(DisplayName = "Prod Ord ID")][PXSelector(    typeof(Search<AMProdItem.prodOrdID,           Where<AMProdItem.statusID, In3<PX.Objects.AM.Attributes.Produc

Hello,I want to sort data displayed in PXSelector by LineNbrhere the Selector: PXSelector(typeof(Search<Choixfournisseur.inventoryCD, Where<Choixfournisseur.reqNbr, Equal<Current<Choixfournisseur.reqNbr>>>,OrderBy<Asc<Choixfournisseur.lineNbr>>>), new Type[] { typeof(Choixfournisseur.lineNbr), typeof(Choixfournisseur.orderQty),typeof(Choixfournisseur.itemDesc),typeof(Choixfournisseur.curyEstUnitCost),typeof(Choixfournisseur.curyEstExtCost),typeof(Choixfournisseur.inventory) },ValidateValue = false, Filterable = true)] But it dosn’t work Thanks for your feedback. 

When a Purchase order has been received and later returned. We need the system to block the bill of the PO Receipt.On the PO Receipts the history Tab will show the Returned items.Sample Scenario:Purchase 10 items.Receive all 10 items. Return 5 Items and create and release the Debit Adjustment to return the 5 items.On the  Purchase Receipt, when I enter AP Bill the Bill QTY is 10 and it does not consider the 5 Items that I have returned.How can I stop the Enter AP Bill for all 10 items 

Hi @all,our client creates non-stock kits as templates.When they add those templates to a Quote or Sales Order they want to change components and quantities there.Does anyone know, if this is possible? Or do you have any idea, how to solve this requirement?Kind regards Michael

E.g.So description is showing below; But when you switch to other tab then return back to the description, it disappears;  

I have created action with PXAction and it is showing on the screen but when I try to add this action in Acumatica Web Service Endpoint screen with respective endpoint screen it is not showing to add

      In 2024R2, we customized a report based on Acumatica's built-in Inventory Balance (IN615000) page. The main change was to group by a custom field of the stock item and then count the quantity of each group.           I added a variable here. Strangely, only the value of the first group was correctly summed. The values of the next two groups were both 0.Can anyone give me some guidance?The customized report is attached.

Where on the invoice/AR transaction can I find the SoLine.UsrCustomerConfig field equivalent?

In Customization project of Acumatica. I need to add the color the orderQty field to the screen SO30100 based on the condition of ordeQty > 1000, when ever the page loads or the field is updated. How can I fix it using Graph?

Hi Acumatica,May I ask if there is a way to create a shipment even if the quantity on hand is zero?Is there a setup needed to procced the transactions?Thank you!

Hi, Can anyone provide to me step by step instructions in how to remove an inventory stock item that posted to a project using a PO of the normal type. Any guidance would be appreciated. Thanks, Frances    

I’m trying to capture the update in price class when changing it in customer. I can capture the customer updating in persist method but I can’t capture the new price class value only the old one. I need to capture both the oldvalue of the price class and the new one.  

Hello Everyone!I’m trying to import credit memos to apply to prepayments and have created an import scenario but it doesn’t seem to work. I’ve search on the forum to try various solutions but I can’t seem to get this to work. Here is my import scenario and the error I’m receiving. Any advice would be greatly appreciated! Thank you!I’ve also included the xml for the IS.  FYI, I use a similar IS to apply credit memos to refunds and it worked without any issues.

How can I create a GI for AP Tran with all of the data fields without manually having to select them all in results grid. 

We are creating a business event to trigger an email if a POLine Promised Date changes by more than a certain amount. The logic for the comparison is, if the change in date of the Promised Date is greater than 20% of the difference between the old Promised Date and Today() we want to trigger the email. I cannot figure out how to reference both the old and new value in the Trigger Conditions to achieve the desired result. I can’t be sure, but from my testing, if I chose Operation: New Field Value or Old Field Value, the value of Promised Date field on both sides of the Condition are value as specified in the Operation. How can I get both new and old values together in an expression to compare these to decide if the date change was significant enough to trigger the Email Subscriber?

Is there a way to add the Hire and Termination dates from the Employee Payroll Settings Employment History tab to a generic inquiry?  Our client is needing this information for an audit.  If we use the Start Date and End Date of the positions we do not get accurate information if the employee had a position change.  The DAC indicates these fields do not exist in the database and are part of the application code.  The client is need the hire date field to populate the original hire date of the employee and the termination date only if the employee has been terminated.  They do not need the end date of a position change.

HiI have an import scenario that imports/updates existing customers in the system. Its fairly complex with a lot of lines.  Its been working well for weeks.Suddenly it stopped working and I get the dreaded “Object not set to an instance of an object” error.  That’s often a very hard error to diagnose.I did the standard things to try to debug it.  Set the import to break on error.  Deactivated all but require field lines in the import scenario.  Visually checked every line of data mentioned in the import scenario.  Nothing looks wrong.First thing that I found odd…  I thought to delete the scenario to just recreate it one bit at time to test it incrementally, but it won’t let me delete it.  Second thing I noted… if I simply open the customer record that it fails and stops on, it will succeed in the next ‘Import by Scenario’ on that line.  For example, it fails on line 1 with the error mentioned before.  I open that customer’s existing record in the system without making any changes to it