Discussion Forums

I want to use rest API to upload item prices against a vendor, can I directly upload to the “Supplier Price” without going through the worksheet hold and release route?

For 24R2, Professional Services was a customization project.  For 25R1, I assume that is replaced by a feature (Enable/Disable Features)?

I’m using a join between ARInvoice & ARTran as well pulling data from FSAppointment. I need ARTran for credit memos detail lines because it wont always match the appointment detail lines. When activated ARInovice-ARTran join causes a duplicate of how ever many artran lines there are. Any workarounds? I cant group by ARTran ref number for some reason as it removes my billable Labour totals. For context RefNBR 008452 in the last picture should just be the first 3 lines but its doing 3x the return because there is 3 lines of ARTrans in the document. 

HI All,I have read the help topic from Acumatica system and read Processing Return for Credit Without Receipt (below link) mention “return without receipt and shipment’.https://aneximports.acumatica.com/(W(44))/Help?CompanyID=Anex+Select+Imports+Ltd.&ScreenId=ShowWiki&pageid=7251c08c-2dc9-4c25-9193-6bb81568e541I read through the whole document and the only suggestion is to turn off “Automatically Release IN Documents” in Sales Orders Preferences so it don’t issue automatically. This is a very tedious solution as I understand it as for all Sales Orders will now need to manually be issue, which will cause a lot more work then just do a credit memo then adjust the items that were return by the CM. Does anyone have a better way to solve this issue? I need to create Credit Memo that show the stock items while not return them back to the system. The old system I used would ask me if I want to return item back to stock which was a nice feature, and I am surprise Acumatica don’t have s

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).