Solved

Hello all, I have come across a wierd situation. In my extension to “EPWeeklyCrewTimeEntry” screen “EP307100” I simply want to rename one of existing grid columns to match with my import excel file column name. So I have added a CacheAtached event that works fine. Column is renamed, user does normal data entry, saves and so on. The problem I am facing surfaces itself when I use “Upload” button to import from Excel. The uploads works as meant to work and imports all data correctly BUT at the end shows a dialog saying “Unable to cast object of type 'PX.Objects.CR.BAccount' to type 'PX.Objects.EP.EPEmployee'”. If I click OK I still can save the imported data without any issue but after spending couple of hours, I can’t seem to figure out why this errors is thrown at the end when everything is imported correctly. If I comment the event code I do not receive this error. I have tried both old and new syntax, tried Append, Merge and even Replace the attributes and on all of them I get the sam

Hello,I am trying to create a new Service Order &/or Appointment using the (...) Actions Menu in the Projects screen. I’ve tried several different order types with the same result:  The procedure appears successful in the projects screen , but no new Service Order is created. What have I missed?When I click Create and Review, or Create, a pop-up window asks whether I want to override settings on the contacts tab.  Whether I answer Yes or No, the Operation completes, and yet no new Service Order or Appointment appears. I verified that the customer attached to my test project has all fields completed in the Service Management area of the Billing tab in the Customer profile. The project itself has a Billing Rule. The trace contains different messages depending on whether I try to create an Appointment (see below 4:29:05 pm) or a Service Order (see below 3:58:29): Thank you!

We have a GI that provides PO Receipt Information. We would like the GI to exclude Returns and associated PO lines (hide them). Is there a function similar to VLookup that can be used? Below screen shot is one of the examples we are using.  We tried the below formula but that is not working.   I have attached a xml file of the GI. Any suggestions would be helpful, thank you!

We are currently trying to change the scrap percentage of a component which exists in thousands of parts, and it looks like the Mass Change function in Bills Of Materials work space is limited to only replace one part for another.  I was hoping there would be something that we could make a change to any field that exists in the BOM for a component and be able to reload to Acumatica.

Accidentally closed a production order before all material issues were done.We really need the lot/serial information of this material to be recorded on the production order.Since you can’t re-open a production order, how can these skipped issues be corrected?

We copied the out of box project task report and made some tweaks for our field to use it as their billing list. We are wanting only the revenue budget lines to pull, and even though I have it coded as [PMRevenueBudget.ProjectTaskID], both revenue and cost budget tasks are pulling to the report. Because we have our cost task set to always be 00, I was able to put in a condition to hide the cost budget lines task =IIF([PMRevenueBudget.ProjectTaskID]>0,[PMRevenueBudget.ProjectTaskID],''). However, the hidden lines are leaving gaps in between the group header and where the revenue lines start, see below. All the wasted space is making the report several pages longer than it needs to be. Any ideas on how I can adjust the coding or add additional conditions or variables where the cost lines don’t show and there aren’t big gaps in the report?  

FYI, self taught, have a lot of python backgfround and now trying to learn C# with Acumatica. So I have a a PXFilter View and I have populated it with some data from the T100 Acumatica local installation. When I debug I can the information is in it but one row of data is under the Current folder and the rest of the rows are in the Inserted folder. Here is a screenshot. For some reason when I pass it to the FormGrid on the UI only the row from the Current folder shows. See here.  Here is a screenshot of the Customization showing I have the CombinedView set as the datamember for the grid.  Does anyone know what I am doing wrong and why the rest of the rows are not populating? --UPDATE--I just found a different spot in the View that has the same Current folder with same data. I am not sure what this is used for as it is outside of the cache. 

We’d like to be able to link shipping boxes (Sales Orders-->Preferences) to shipping box stock items so we can track when we need to re-order shipping boxes.  Other than kitting, any ideas?

Hello all,I want to display the customer ID/Name from a project record into the report but the report is not able to display it:  The Result in reportAlso tried by using Alias for the child table, but it displays the same result.

I’m using this nuget in visual studio: https://github.com/Acumatica/AcumaticaRESTAPIClientForCSharp/Trying to set up a very basic bambooHR - Acumatica integration to create leave requests from bamboo as timeEntries in Acumatica.When I log in with just a username and password, everything works and it logs me into our live tenant. When I use my local offline demo vm I have no tenants to test with also.I want to log into our test tenant, but when I specify the test tenant and branch I get a Server error 500 - internal server error. Has anyone else run into this before? In my main program I have: myAcumaticaStuff.Login(AcumaticaBaseUrl, "ApiLogin", "******", "Staging", "Edmonton", "en-CA")The sub in the module:(myauthApi is from: Imports Acumatica.Auth.Api)Public Shared Sub Login(siteURL As String, username As String, password As String, Optional tenant As String = Nothing, Optional branch As String = Nothing, Optional locale As String = Nothing)            myauthApi = New AuthApi(siteURL)

How can apply a Customer prepayment  to a refund?

When pulling a Inventory Valuation report the “QTY on Hand” appears on the report but when exporting that to Excel the QTY is missing.  Anyone have a trick to make the QTY on Hand appear on the exported version?

Good day, we are doing a project to move data from QB.  The vendor uses snapshots has development as move forward in the process from one tenant to another.  The process has caused a major space issue.  Does anyone have any advice.  We have started to delete old snapshots; this frees up some space but it is ongoing issue.Thank you

Hello, I want to display a pop up message when the quantity is entered on a sales order line if a condition is met. I have the following:protected virtual void _(Events.FieldUpdated<SOLine, SOLine.orderQty> e){ SOLine row = (SOLine)e.Row; if (row == null) return; if (row.Qty > 10000) { WebDialogResult res = Base.Document.Ask("Warning", "This is a large order", MessageButtons.OK); }}This works, as shown below. I enter a sales order and the message appears.  The problem is that the message also appears when a Sales Quote as converted to a Sales Order.This makes sense since the SOOrderEntry is used to perform the convertion. Is there any way to check whether the UI is being used to enter the sales order, or to check which graph has called the SOOrderEntry graph? Thanks

Hi SirWe would like to know what mean of production variance.As we do a disassembly transaction and notice that system auto generate “ production variance” May  i know what is this for? Please refer to the below.If based on below journal , does it mean the production variance 21.44 is reduce the inventory value as the double entry is credit account code14720 inventory.  

Hello,Sometimes it is found that material already issued to a production order is not good.It needs to be moved out of WIP and off of the production order into an inspection warehouse or location.It needs to be inspected at this point to determine if it will be returned to vendor, credit requested, or it can somehow be used.What transaction will allow us to to return this specific material into inventory, not to the original location but to a new inspection warehouse or location?If it is found to be defective, how do we return it to the vendor since the original PO receipt is complete?Thanks!

Hello Everyone,I’m getting the following error while trying to login to acumatica mobile app.What could be causing this, have researched about it but couldn’t get a solution. Kindly assist.All responses will be appreciated! 

Hello everyone,I have created a tab called fulfillment, I need it to display Normal Purchase Orders  and the corresponding purchase receipts that fulfilled the blanket order. I have tried to find any data or fields I could use to link the tables in order to get the required output. But haven't found enough to enable achievement.could anyone be having an idea on how I go along to achieve this?kindly assist.Any kind of response will be highly appreciated

Dear All,Can we add an item and mark it as free item on PO?We still want to show unit cost of that item for doing declaration.

We have had a payment issue from a third party that sends us orders and payments to import adn we need to create Customer refunds for thousands of Prepayments. I have created a simple import that fills in the necessary Form Elements, but when it tries to add the Prepayment in the Documents to Apply section I et an error saying : “The system failed to commit the Adjustments row.Here is the import: If I have the Documents to Apply section unchecked it will create the document as seen here: I need help getting it to fill in the Adjustments/Documents to apply section with the single prepayment that should be tied to it. Thanks,Harrison

Hello EveryoneWe have a problem with the size of the database due to the emails and attachements.Is there something we can do in order not to save these emails with their attachements ? a setting we missed?  If not a possibility of a purge of the data we don’t need ?Any ideas Thnx;

Hi, I created the following Import scenario to Void and Release the Payment from the Payment and Application Screen(AR302000) but getting error that “Document Status is invalid for processing.”If i exclude the last line to release the Voided Payment then it works fine and it creates the Voided Payment Document with Balance Status. Any idea?Thanks

Hello,I am Trying to find where/how to add a new “ERP Field / Value” to the BC202000 screen. We would like to be able to push an attribute with the “ERP Object => Template Items → Matrix” like we are able to with the “Template Items → attributes”.Or we would like to be able to push a custom field on a matrix item so we can push our UPCs to Shopify. How can I add custom fields to this dropdown?I’ve been looking through the PX.Commerce.Shopify source, but as far as I can find it pulls the values out of the ether.Thanks in advance!

Hello,My report doesn’t display the Customer ID & description in the report created.  Fields to display in report either Customer data fields or the Account nameDac Schema Browser: Tried the below join: But not getting displayed.How to do this?

We have a client using MRP forecasts in Build 23.104.0027. Demand Time Fence in MRP settings is set to 30 days. MRP Prefefences, Demand Time Fence set to 30 days. According to help, this is “The number of days within which the system excludes forecast records from demand data; the period starts from the day when MRP is performed. Forecasts are ignored by MRP if they have a start date specified on the Forecast (AM202000) form that is earlier than the MRP run date minus the number of days specified in this box.”MRP was regenerated today, Nov 16, 23.  This is the forecast for one part, 14 per month. Since it is mid November, I would expect MRP to skip the Dec forcast demand since it is within 30 days. But, this is the MRP Detail Inquiry for this part. Anyone know how MRP is actually using that Demand Time Fence number, or how to get MRP to skip forecast demand within 30 days?