Solved

Is there a way to create a Time and Billing Project with a Not to Exceed billable amount?

Hello,This approval works.  Only the user specified can approve the sales order directly on the sales order screen.  However, the pending approval is not coming up in the Approvals screen for the user. Any thoughts on this? 

We’re implementing Acumatica and I just learned that it’s not possible to fulfill orders in Shopify and have that information sync back with Acumatica which is very disappointing. Does anyone do that today? Maybe through a customization or how else could it be handled? Or, maybe am I forced to change our process so we do the fulfillment step in Acumatica? We do our own local delivery through a Shopify app which makes it easier for us to do in Shopify. 

Hey Team i’m sending a POST request to create Project in Acumatica but it not throwing an Error at all it showing success but i can’t find it in Acumatica  POST : https://mycompany.acumatica.com/entity/projects/22.200.001/ProjectBODY :  {  "ProjectID": {    "value": "P-76732"  },  "ProjectCountry": {    "value": "Montgomery"  },  "Description": {    "value": "TEST"  },  "GL": {    "value": "CSMABAWA"  }}   Thank you so much

Working on an audit request for list of Inventory Purchases for a specified period. Originally I was just pulling purchase receipts but that does not include any capitalized freight expense in the inventory through Landed Costs. Meaning, if we buy an item for $10 and it costs $2 to ship to us we recognize the inventory at $12. using Purchase Receipts only returns the $10 of the purchase not the $2 in freight expense. Is there a better report that will show me the total inventory cost Purchase + Landed Cost?

Anyone know if it’s possible to set the variant Inventory Policy in Shopify based on the Item Status of the stock item in Acumatica? I’ve played around with the Export Mapping under the Stock Item entity but I can’t seem to get it to work. The Inventory Policy is a checkbox in Shopify so I tried the below formula but it had no affect in Shopify:  

Unable to to action button Extend as vendor on the customer screen while using the import scenario, as the import scenario works only on one screen which is the customer screen in this case.

There are certain inventory items that we “manufacture” into kits- large quantity items that get broken down into smaller items.  However we need to be able to list a different cost for the new item, and incorporate a labor cost per item in the kit.  How can we do this?  Let me give an example of what we’re trying to do with a generic setup:Bulk Item A- cost $1/lbKit Item B- cost $2.50/lb, container for Item B $2 per kitLabor for 1 Kit $5

Hello Team, One issue is facing that in acumatica time and system time is different and due to that session expire issue is happens quite alot so i want to fix the issue regarding set the EST time in Acumatica platform so your help is alot to me  Please find attachment. Thanks and RegardsRushabh Shah@Naveen Boga @laura01 @BenjaminCrisman 

If the quantity is 0 in any row, a confirmation dialog box will appear, if you click on OK, the value will change, if you click on cancel, the old value will be returned. It will be applied to the entire grid.

Hello all,Currently I would like to stop Shopify orders that are on hold from importing into Acumatica right away.I figured I could use the “import filtering” on the Sales order entity, however the only valid values are numbers (they might correspond to an ID for something, but I have no proof for that) and I cannot find where these are defined anywhere.Does anyone know what the numbers correspond to? Or if this is changed in a newer version?If anyone knows any other way where I can stop orders on hold from coming in until they are off hold I would appreciate that as well.Thanks.

I am having a difficult time recording production waste from a raw material input. In a BOM I have configured, it takes 3lbs of an item for a yield of 1.95lbs. I set this up in the BOM material line item indicating that 1.95lbs are required with a scrap factor of 0.538462 so that a total of 3lbs is removed from inventory. I set up a production reason code and in the Work Center and BOM I set scrap action to Write Off. The raw material is a lot tracked item, so I issue the material and I see 3lbs removed from inventory and go into WIP. When I perform the move transaction, the cost of 3lbs is moved into inventory when only 1.95lbs should be in inventory with 1.05lbs written off. I have also tried changing the settings to quarantine and set a scrap warehouse and location (set up in the order type and stock item (but I cannot get that to work wither. This is not the produced product that is waste...it is one of the input materials so I cannot specify a scrap amount on the move transaction

Hi,I have customized a new tab called ‘Discount’ to my custom data entry screen. There are two fields called Discount Amount and discount percentage in the grid as below.When I changed a value of discount percentage, I want to set value to discount amount based on discountable amount just after the field updated. For that I used below code but it get executed when adding a new row.protected void APProformaDiscount_DisctPercent_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (APProformaDiscount)e.Row; APProforma item = APProformas.Current; decimal? amount = (row.DiscountableAmt * row.DisctPercent) / 100; //row.DisctAmt = amount; cache.SetValue<APProformaDiscount.disctAmt>(row, amount); }Even I tried with cache.SetValueExt but it also didn’t work.Note: this is custom graphCan someone help me on this to find a solution please?Thank you.

I added a new field of type PXNoteAttribute to the DAC to enable file attachment.i.e  #region NoteID public abstract class noteID : PX.Data.IBqlField { } protected Guid? _NoteID; [PXNote()] public virtual Guid? NoteID { get; set; } #endregionOn testing I got the following error what could be the issue? Kindly assist.Thank you all.

My client would like to prevent users from accessing the mobile app. I logged a support ticket and was told I could use IP filtering, which is not an acceptable solution. The other option I was given was to create a customization. Does anyone know how to accomplish this? They are looking to completely disable mobile app access for the time being.Thanks

Hi All, I want to get expense claim approvers’ details to expense claim details report. What are the tables that should be joined in Build Schema to get details such as EmployeeID, Name etc. Thanks

Hi all,I have created a new screen & two new tables. But when I’m saving a record I got this error.  And now I can not access that screen. ErrorError: An error occurred during processing of the field Tstamp: Unable to convert MySQL date/time to System.DateTime, set AllowZeroDateTime=True or ConvertZeroDateTime=True in the connection string. See https://mysqlconnector.net/connection-options/.Here is DAC Tstamp field. #region Tstamp [PXDBTimestamp()] [PXUIField(DisplayName = "Tstamp")] public virtual byte[] Tstamp { get; set; } public abstract class tstamp : PX.Data.BQL.BqlByteArray.Field<tstamp> { } #endregion Anyone know how  to fix this?Thanks.

With the Screen Event we control the invitations to our web seminars. Once I send the invitation from the screen event (CR306030), the record is locked in the grid for editing (checkbox optional or the comment field). It is only possible to delete it. This is inconvenient if you want to note in the comment after the invitation that the participant will attend later, or maybe did not show up.I tried a few settings in the project editor, but I could not do the editing once the invitation status changed.Can someone help me?Thanks!

 I already generated a company employee name in the Configuration >Employee module, but when I wanted to create a new user, the employee's name didn't come out in Linked Entity. Can refer to the error 'contact ... already associated with another user'. So how can I solve this issue.

Hi,What would be the best way to reverse the code below so that I can update the original DAC field with the custom DAC field? The reason for this reversal is that I created the new custom field to replace the original Description field. This is because I wanted the descripition field to hold 4000 characters, but reports would still be pulling it in as having only 250 characters since I didn’t update the SQL. Now that I realise my mistake of not updating the length of the description field via SQL, I will need to reverse the code below so that I can move the text back into the original description field as this custom field is no longer needed. Kind regards,Andrew protected void PMRevenueBudget_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { PMRevenueBudget row = (PMRevenueBudget)e.Row; if (row is null || row.Description is null || row.Description == "") return; var value = row.Description; cache.SetValueExt<PMBudgetExt.usrDescriptionExt>(row, value)

Is there any setting or upcoming feature that will allow our customer to only pre-authorize the credit card for the amount being shipped when using the Create and Authorize process screen?I saw a pay by line option on the customer record but that did not seem to alter the pre-authorized amount, it always captures the whole sales order.Our client processes an incredible amount of SOs daily, many of which have back ordered items. Their clients are upset that their credit is tied up by pre-authorizations for the whole order, especially when some of the orders had shipments that were future dated.I know the pre-authorization falls off after a few days but their clients are still upset.

I’ve been trying to build a subreport (basically a copy of the trial balance report) that would pull the 12th period ending balances for each account and pass that value to the standard Trial Balance. I can get the subreport to show values if I run it directly but the value never shows on the original. Am I missing something or is there an inherent problem with trying to get this value into the same report? I’ve attached the report (GL632EMS) and subreport (GL632e99) to this topic. If anyone can point to me what my issue is I much appreciate the assist!

A customer is using the kit assembly with multi-evel kits. So to create a kit the sub-kits need to be created before.Is there any automation possible like the automated (or half-automated) creation of the sub-kits in the process of creating a kit?Do you know any customer doing the same?Any ideas?I am grateful for any advice. 

Hello :) Does anyone have a good video/advice when applying invoices to a subcontract/commitment from a vendors subcontract total?? 

Hi,  Where are the settings to allow a role/user to edit the value of an item attribute?