Discussion Forums

I am trying to get a report showing detailed BOMs including costing and I can’t seem to find how to do this? Can anyone help?

Hi, There is and GI Tax-AR TCS RMS Wholesaler. When i active the artra.invenotry id and inventoryitem.inventory id its giving me below error.Can any one guide me please. I have tried solution but did not work.  

I have a custom field that interacts with a query to count the number of production order materials with negative quantity requirements. We are using this to indicate byproducts. Here is the DAC for the custom field: Here is the code for ProdMaint:namespace PX.Objects.AM{ public class ProdMaint_Extension : PXGraphExtension<PX.Objects.AM.ProdMaint> { public PXSelect<AMProdMatl, Where<AMProdMatl.orderType, Equal<Current<AMProdItem.orderType>>, And<AMProdMatl.prodOrdID, Equal<Current<AMProdItem.prodOrdID>>>>> ProdMaterials; #region Event Handlers protected void _(Events.RowSelected<AMProdItem> e) { AMProdItem row = e.Row; if (row == null) return; AMProdItem prodItem = (AMProdItem)Base.ProdMaintRecords.Current; var amProdItemExtVar = PXCache<AMProdItem>.GetExtension<AMProdItemExt>(prodItem); var inventoryIDletters = ""; foreach (AMProdMatl material in ProdMaterials.Select()) {

I want to try something and im curious if anyone has tried this. We are using shopify plus and I am having a very hard time importing matrix items into acumatica. The complications I'm having is i don't want to break up my items into separate item classes for now, I simply have 1 item class for stock items and i have about 50 “Variant” attributes for this item class. But the problem is when i try creating matrix items it requires me to inactivate all attributes I'm not using on each template item, which is very annoying and complicated with an import scenario. Here is what I'm thinking to do to simplify. Since i’m never looking to have more than 3 variant types anyway (shopify limit), i want to create only 3 “variant” attributes lets say Varient1, Varient2, & Varient3 and add a regular (non varient) text field attribute right above each variant so lets say Varient1Name, etc. And have this replace the default mapping to shopify for the variant name. Anyone tried this or know if it w

Hi Everyone,We are making an API calls to Acumatica like below but creating lot of API sessions and not logging out from Acumatica. Can you please review and help us on this? Log into Acumatica - Working Creating Sales Orders - Working Logout from Acumatica - Not workingPlease find the screenshot for reference. 

For many in the service industry it is important to be able to fill out inspection sheets out in the field. While there are many providers of the fillable form concept (WorkMax,FastField etc.) none of them have the ability to save the inspection sheet (usually saved as a PDF) directly to a service order or appointment on the mobile app

Hi...we are in the middle of converting to Acumatica and I am just beginning to get into the API for integrating with our other internal systems.I have figured out how to use ODatav4 to read stock items.  I even figured out how to use a “Navigation Property” (by trial & error) to pull in the item class description. Below is the current request broken down for readability.But now I also want to pull all of the Cross-References (customer item numbers) for a given inventory item.  The Cross-References show as another DAC - INItemXRef - but there doesn’t seem to be any navigation property from the InventoryItem DAC to it.  Can I pull in this related information with an $expand clause?  Or do I just need to query the INItemXRef separately and combine them manually?Thanks!https://<company>.acumatica.com/ODatav4/<tenant>/PX_Objects_IN_InventoryItem?$select=InventoryCD,Descr,ItemStatus,BaseUnit&$filter=ItemStatus eq 'AC'&$expand=INItemClassByItemClassID($select=ItemClas

In 24R1, I created a new project.  When I open the project in the editor, the tree on the left looks normal.  As soon as I add the PO301000 screen, the tree is almost empty.I reset caches, restarted the app, recycled the app pool in IIS.  I deleted the project and started over, same thing happens. Any ideas?

When a new matrix item is synced to Shopify, the Variant Option Name defaults to “Title”.Is there a way in Acumatica to change the Variant Option Name to something else?

Is there anyone can help me to display 5 line items on the first page of the report then sixth or next line item will display on the next page of the report

When I uploading an image using the API, the following error message occurs: Error 500: Internal Server Error.  

We would like to be able to view Inventory Summary on the mobile app, is it possible for us to add that or does that have to be built in by Acumatica?

Do we know when a new build will be released for 25R1?  It seems the original from about a month ago is the only one available.  25.100.0054

Our business just began manufacturing; we have always imported and distributed. However, now we are taking our raw materials and converting into a finished good. We do not have the manufacturing module. We have the distribution module and are in the process of implementing a WMS.If I am not going to implement MFG module right now, how would I keep track of raw materials, finished goods and waste? I have outlined my original thought process below, but I am afraid it will be time consuming and opens up the possibility for mistakes. I am open to ideas and recommendations.I have thought about creating a new “Inventory Adjustment” for every sales order. In the “Description”, I would put the SO# and the Job Name so that I could identify the order. Then I would deduct inventory from the raw material to account for the finished good and the waste. And I would add inventory to the finished good. This way, the inventory is now accounted for and we can create a shipment from the SO and invoice th

Hello guys,i tried to create a Multiselect Combo Box but it not working, hope u can help me.[PXDBString(500)][PXStringList(new string[] { "E1", "E2", "M", "U" },               new string[] { "elektr. Sicherheit", "EMV", "Material", "Umweltsimulation" },MultiSelect = true)][PXUIField(DisplayName = "Bereich")]  

In the Acumatica produced YouTube video Set up Allocation Rules to Recognize Revenue - Acumatica Construction Edition from April of 2020 viewers are cautioned against using Auto Completion of the Cost Budget if there is more than one cost line per task: Is this still a limitation?If not, in which release was it resolved?If so, is it dependent upon the selection of Completion Method (Budgeted Amount or Budgeted Quantity)?

Hi Expert.I added 2 field this screen FA303000Base locgic: if change value field Department and more.. then tab “Locations” insert a row into FALocationHistory table.Now I want 2 field Warehouse and Location change value => insert new row into FALocationHistory table (behavior same field Department).I try many solutions and overried base code but The system is still not working properly. protected virtual void FixedAsset_RowUpdating(PXCache sender, PXRowUpdatingEventArgs e)        {            var newAsset = e.NewRow as FixedAsset;            var oldAsset = e.Row as FixedAsset;            if (newAsset == null) return;            if (this.WillAccountsBeChanged(newAsset, oldAsset, out int? faAccID, out int? faSubID, out int? accDeprAccID, out int? accDeprSubID)                && FAInnerStateDescriptor.IsAcquired(newAsset.AssetID, this)                && !FAInnerStateDescriptor.WillBeTransferred(newAsset.AssetID, this)                )            {                if (As

how to handle the direct tax and indirect tax?

Hi,I've recalculated inventory from the beginning, but I'm noticing that some transactions are missing from the historical inventory transactions. Additionally, the balances are not matching the Inventory Register report. Has anyone encountered this issue before or have any suggestions on how to resolve it?Thanks.   

Hi,Can somebody help with the “Leave Request Approved” emails?When personal leave (sick leave) is approved the email back to the employee returns a zero value for Balance Remaining. When annual leave is approved the email works correctly and returns the remaining balance.Finally, the “Approved By” contains our company name, not the Manager’s name.How can I fix this?Below is a pic of the email and the template if that helps…Approval emailleave request approved email template 

What is everyone using for reporting within Service to show revenue by service order?  Either report designer reports or GIs.  Our partners seem to be waffling--one day we hear that there are lots of service order profitability reports, and then we get on a call and the only thing they can show us is the Profitability tab within each service order.We want to be able to roll it up by branch, by customer class, by tech (we do have a custom field for lead tech, so there’s just one “lead” tech per service order that we would roll things up by).

Hey everyone! Hoping I can get some help with an import scenario I can't seem to get working. The goal of the scenario is to update the scrap factor on specific materials across our bill of materials. This means we have to target the BOM, Revision, Operation, Material, then update Scrap Factor. I am able to target BOM, Revision, Operation, but I cannot figure out how to target Material. For many of our BOMs we only have one material per operation, so in those cases I can take this scenario and run it without the @@Inventory ID line and it works perfectly. For any operation with more than one inventoryID it's only going to update line one. Has anyone had success with this before? The @@Inventory ID does not target for some reason. I tried also @@Line Nbr and Line Nbr. I tried <key: external> but nothing seems to work. We are running 24R1, so a lot of things in manufacturing have changed - I did see some old posts on similar topics, but the advice in those posts didn't help here. H

How does one create a fully new report? I’m making a tweaked version of an existing report, but need to create a new report on the site, and I’m not sure how.Thanks for any help.

Is there a way in a Generic Inquiry to determine the which Quarter of a year a date falls in.I am working on a Generic Inquiry where I would like to display the Quarter of the year the SOInvoice.DoDate falls in.Thank you!

Hello everyone, I am sure we all have events we would want to run once per screen load, unfortunately, we do not have a ScreenLoaded event or anything of that sort. To overcome this you can create a non-persisted bool.#region TrueFalsepublic abstract class trueFalse : BqlBool.Field<trueFalse> { }[PXBool][PXUIField(Display Name ="True/False", Enabled = false, Visible = false)]public virtual bool? TrueFalse { get; set; }#endregionThen you can control the value of this with a RowSelected event handlerprotected virtual void _(Events.RowSelected<YourDAC> e){ YourDAC row = e.Row; if(row == null) return; if(row.TrueFalse != true) { row.TrueFalse = true; } else return;}This field value will hold until the screen is refreshed, however, when it is refreshed it will trigger the RowSelected handler again and set the value to true. You could also update the field value within the handler that executes your logic, in this case my non-persisted bool is UsrCreditHold and use an i