Solved

I have a batch of inventory adjustments to make, so rather than key them in I was going to use the Import from Excel function within the Inventory Adjustments form.  I've used this function within the order entry screen, so I was familiar.  I went to load records from file, browsed to the file (.xlsx) and clicked the Upload button.  The screen flickered, but the dialog box never comes up.  I've checked everything I can think, but nothing seemed to work.  I even tried importing to the order entry screen, to make sure that worked, and it did (tried the same file just to see if the dialog box would come up, and it did).  Is there a setting that has to be flipped on per screen to allow the import to go through?  What else might I be missing?  Using 2019R1

Eg: I am trying to create a “Customer” related field in “Invoices” screen. Dear Friends,I am trying to create a custom “Related” field and it doesn’t work for some reason, so need your input. I created a new Customization Project, and in the Data Access section for Invoice, I created a new field: Lets say the Field name is “Shipping Customer”. I added the following as part of field attributes:[CustomerActive(Visibility = PXUIVisibility.SelectorVisible, DescriptionField = typeof(Customer.acctName),Filterable=true, TabOrder=2)][PXUIField(DisplayName="ShippingCustomer")]Once the field is created, I added it to the Invoice Screen, and it appears fine (woohoo!).  But when I save the Invoice, the field value is not getting saved into the DB. Any clues why? Thanks for your help!

I'm trying to log into Vendor Classes form and come up with above error massage? Is it a access problem? Else could you please help me to sort this out. Thank you very much in advance

Good dayIs there a way to see what is pulling data out of the system and how much? I have looked at the Access History(OData refresh) but I am thinking the API can also be an issue.We currently experiencing massive data pulls via the IIS on our server and I can't see what is pulling the data.Any ideas or suggestions will be helpful 

Hi  I was wondering if the new Arena PLM integration supports muli-level BoMs.  Often in an environment where a product is produced with a multi-level BoM, if a lower level BoM changes for any reason the revision of the parent level BoM should also change revision when the lower level BoM is updated. This is to reflect that the finished good produced is a different version as a result of the component part BoM having changed. Is this something the integration can mange? Thanks  Matt  

Hello,   I’ve wrote a tabular report to show customer(as row) sales in 4 warehouses (as column).The values are the total sales qty.     The column right now is dynamic, that if 1 warehouse has no sales at all, this column stands for this warehouse would not show on the report.       Is it possible to always show 4 columns, even if that warehouse has no sales.  

Hi we have setup a processing center to connect to Authorize.net and have tested successfuly.  Is there any online form or tool to allow customers to enter their credit card information?  I’m surprised I haven’t been able to find anything….customer portal looks like it might have something but I don’t want to give every customer a username/password.   Any suggestions how I can have customers enter their own cc details online for authorization?

Hi community,Where I work we have been using the REST API quite a lot to automate redundant tasks in Acumatica and tie some of our in house software in to it. However, I do not have a lot of experience using “Actions” aside from the “Release” button and so have come to you for help. Objective: Add a PO Receipt to an existing Bill. The Bill has already been created and is on “Hold”. I have added the “AddPOReceipt” action to my extended web service endpoint. When I POST to “AddPOReceipt” endpoint I get a 204 response to which I follow up with a GET to check the status of the request and I get a 200 response. When I look at the bill there is no receipt added to it though. What am I doing wrong? myurl = "https://4iiii.acumatica.com/entity/ManleyEndpoint/17.200.001/Bill/AddPOReceipt"jsonUpdate = { 'entity': { 'Type': {'value': 'Bill'}, 'ReferenceNbr': {'value': '006357'}, }, 'parameters': { 'ReceiptNbr': {'value': '003341'}, '

Hello,       I met an issue, I don’t know how serious it is. Because the system behavior looks OK.  But It is indeed strange. Luckily, I got this issue on a test environment, but I still need help.      I did some test on shipment workflow days ago. And it seems like something is broken.  When I try to create a NEW shipment, the status is disappear, so the new shipment can not be saved.       In Order to solve the above issue, I unpublished the issue customization projects and import a backup right 1 and republish. The status issue has solved.      But Unfortunately, the “default workflow” is disappeared                 How can I add the default workflow back?

We are only 4 months new to Acumatica.  We are looking to implement mobile devices for Shipping / Delivery confirmations… Im looking for device suggestions.Thanks!Julie Rotaru

Is there a way to add a time stamp to when EDI salesorders enter Acumatica?

How to adding a clickable link for excel export using generic inquiry. It should be same report export. 

Anyone knows how to make it automatically to export inventory to csv and send to sftp server? I know I can export to csv and manually upload to sftp. I want to know if Acumatica has anyway to do it automatically. Even execute a command line after export file.

I have a prospect in the supplement manufacturing industry.  One issue that I am trying to solve for them is managing lots of ingredients or finished goods that require testing before they can be used.For ingredients the scenario is this:  A product is purchased and receipted into stock and assigned a lot number.  A sample is taken and sent to an independent laboratory for testing - the test can take up to 2 weeks to return during which time the stock cannot be used in production and is not available for scheduling. We are looking for an easy way to identify that this particular lot is still awaiting the test result whilst other lots of the same item may be available (or waiting on a test and not available until later).  Ideally I would like to have attributes for the lot, but this is not available.  I think that the best I can do right now is place the lot in a quarantine location and move it out when it has passed the test.  A similar situation occurs during manufacturing when the fi

Hello Is Multi-Combo Select Available in Parameters in Report Designer? Thanks

We have a customer that would like to default Shipping VIA and FOB Point fields.  Does anyone have an idea of how to do this?

in segmented keys I would like the system to pickup the BAccountID and fill this in as the 1st part of the subaccount being used So for example I have set subaccount up as such in the CS202000 screenAnd I would like the system to look at the customer or (vendor if applicable) and fill the 1st segment of the subaccount with the  BAccount code So if I was entering a AR Invoice I would like the first segment of the subaccount to pickup the current BAccountID and autofill with thatthe only way i can think of doing this is using custom workflows but wanted to check that I’m not missing something

I’m following the example in Lesson 3.1 of the I310 training course.  But instead of retrieving attachments of a Stock Item, I want the attachments of a Purchase Order.  In Postman, I’m performing a GET to:https://localhost/PhoneRepairShop/entity/Default/20.200.001/PurchaseOrder/000001?$select=OrderNbr,files&$expand=files The response is: Operation is not valid due to the current state of the object. This happens for both open and closed purchase orders.   Am I missing something? 

I wrote a customization to add a link for any files uploaded to a SO Line item into a Production Order.It works, but I am breaking all kinds of rules.  I am not supposed to update a cache or do BQL statements in the RowSelected handler.  The goal is that each time a Production Order is opened on screen AM201500, I do a check against the SO Lines related to the Sales Order for that Production Order and create links to the “Files” on the Production Order.  Each SO Line could have multiple attachments and we want those attachments available on the Production Order.  Also, there is most likely a better way to accomplish this regardless of which handler I use, but this is the only way I know to do it. I would appreciate any inputs/critiques you might have.          protected void _(Events.RowSelected<AMProdItem> e)        {            var row = (AMProdItem)e.Row;            if (row.OrdNbr != null)            {                using (new PXConnectionScope())                {            

Hello team.I hope everyone is well and still keeping strong.I have a question and I hope someone can help me.is there a way to add the following 2 totals up? 

We recently upgraded from 2019R2 to 2020R2.  We were utilizing the Hidden workspace a suggested the Technical Tuesday: Using Hidden Folders to Manage Access RightsFollowing the update, all Generic Inquiries that were in the Hidden Workspace show ffffffff-ffff-ffff-ffff-ffffffffffff as the workspace.Hidden is not and option in the Workspace lookup, and if manually entered saving fails with:  Error: 'Workspace' cannot be found in the system.However, in Access Rights by Screen, the Hidden Workspace and it’s many members are present. Also, the Site Map SM200520 show these with an empty Workspace and Hidden not selectable.Do I only need to create a new Hidden Workspace?  Doing so in our test bed did not hide items as before.

In our process, we buy product from a vendor. However this vendor is able to offer product produced at various locations. We need to be able to identify the producing location for regulations. Right now we add locations but in order for the purchase order to print correctly as being purchased from the main vendor all addresses have to be the main vendor and not the location. Is there a current way to add a vendor location with it's address but be able to have the purchase order report print the "corporate address"?

Hello,Regarding the Attributes screen and setup (CS205000). This is a great way to add custom fields to something, such as business account profiles.However there a way to make attributes an option on the Activities screen, and for the individual Activity types?So that if Activity Type X is chosen, there is an option to add an attribute regarding that Activity Type.Is this possible? 

Is it possible to map a specific tag to a custom field? I can see that you can import tags (in general) to something in Acumatica, but we really just want to set a command where “if a tag contains a ‘#’ then import to a specific custom field”The number we want to bring in is our Amazon sales #Our Amazon sales flow into shopify and then Acumatica. It works great except for lack of order number. Thanks for any help! 

Hello everybody! Could you help me witn “service order” entity. Which REST API endpoint conteins this entity?