Solved

Hello COmmunity,I am simulation a process.Assuming a client go live. On the bank module, transactions like inter bank transfers, payment, bank charges etc have been posted against a bank.HOw can I bring in the opening balance of the bank before go live so that the bank balance can be use to relate with the reduce the negative value to it actual value….. Thanks in anticipation

Has anyone created an accrual to cash financial statement within the system for the BS & IS? Any suggestions on building that report?

is it possible to automatically show approved PTO from the Acumatica payroll module in the service calendar boards so that appointments are not set when techs are out on PTO?

I want to add the “Last Vendor Price” that is shown in the Stock Items screen to the data grid on the “Purchase Orders” screen.I believe this will involve creating a custom non-DB related field in the PX.Objects.PO.POLine DAC.  Then I would get the value from the POVendorInventory table for the respective vendor in the Purchase Orders screen.  I think I would do this in an POOrderEntry_Extension : PXGraphExtension<POOrderEntry> extension as that is the graph used for the Purchase Orders screen.I would get the value to store in the custom field and trigger it with one of the row events.  However, I’m not sure which one to use.  Can someone give me advice on which one of these is the most appropriate? Thank you in advance for your help.  Also, if you think my plan is bad, I’d welcome any suggestions.Joe Schmucker(Noob) 

We are trying to implement the  Daily Field Report for our field employees.  Many of our projects are billed in full before all work is completed due to contracts being a lump sum and not T&M. Once they are billed complete they are removed from Active status to Billed Complete so they are removed from our WIP reporting for that month.  The problem we are having though is that once the job is no longer in “active” status employees can no longer find this job under Projects in the Daily Field Report if they need to add additional hours after it was closed on the accounting side.  Is there a way to have the Daily Field Report continue to show jobs that are in a different status other than just active?

We do not want items sold out or not available for sale to show up on our Big Commerce Website.  Here is our problem: When the last item in stock of a particular SKU is on an Acumatica sales order (but not invoiced) it still shows on the Big Commerce website as available for sale.  How can we configure our Acumatica connector so when the last item of a SKU is on a sales order the item will not show up as available for sale on the Big Commerce website?  We are on Acumatica 2020 R1. 

How do you get a PO status to say closed when you end up returning all items and canceling the PO?

Does anyone know if there is an integration with Dunn & Bradstreet or any other credit checking facility for Acumatica? ThanksSharon

Hello, I have a situation where a user needs to be notified whenever the credit limit utilisation of a customer exceeds a certain threshold. I have tried using an existing GI which Acumatica offers out-of-the-box with title ‘AR-CreditLimitCustomers’ and added a field to calculate the utilisation percentage. The calculation is as below.=((([ARBalancesSharedCredit.CurrentBal]+[ARBalancesSharedCredit.UnreleasedBal]+[ARBalancesSharedCredit.TotalOpenOrders]+[ARBalancesSharedCredit.TotalShipped]-[ARBalancesSharedCredit.TotalPrepayments])) / [CustomerSharedCredit.CreditLimit]) * 100 However, as expected, the business event does not trigger due to a known limitation that business events do not work on calculated fields. For this reason, I created a SQL View which basically runs the same query as in the GI above and included the custom formula as well as a separate field. I created a DAC linked to this SQL view and added it to a new GI and a business event to it linked to this field.Despite hav

Hello, good afternoon. I have a tab "summary" that contains fields of type date and I assign the default value (today) as well as in my header but the values ​​do not appear. For confidentiality reasons I cannot show all the fields on the screen  in the corresponding fields (DAC) of my header and summary (detail DAC) I used: [PXDefault(typeof(AccessInfo.businessDate))]but only works in the header date field (not in summary tab as you can see in the image above) the screen is a customizationcan you help me please? thanks

Hello,I am unsure of the purpose of Stock Item kits in Acumatica.I created a stock item and marked it as kit.Then I defined the kit in kit specifications.  It is just 2 purchased parts in the kit.I put if a sales order for the kit’s stock item ID and MRP did show it in the MRP display.How do I generate something for the shop to build the kit from MRP?It seems like I have to see the demand in MRP display, then open Kit Assembly and process this.It seems like just having a BOM with 1 “assembly” operation and the component materials is a better way to go as I can generate the production order directly from MRP and when completed the completed kit goes into stock.Am I missing some basic understanding of Kits in Acumatica?Thanks!

Hi,We just started our Acumatica implementation. We are a wholesale food distributor in Ohio. I was wondering if someone out there did a recent implementation and is willing to have a conversation about their experience.Thanks in advance.

I am working on getting MRP up and running for my company. We have been getting by until we could get our BOMs updated with acumatica and in line with how it would pull inventory. Then, we did an entire inventory count to balance back out all of the mistakes that had been made over the months since our “go-live” date. That being said, we have several POs that have been created due to word of mouth need instead of through MRP. Is there a way to go back and link these POs to lines on MRP to remove the items from the list so we do not create any more POs for unnecessary items? If not, how should this be handled to get these items off of MRP?TIA

Is there a way to permanently exclude credit and debit memos from the Print/Email process?  IE we would like memos to permanently not show up on Print Invoices and Memos screen (filter not really acceptable) and not trigger the Invoice notification template defined in AR preferences Thank you!!

This seems like a simple enough question but I can’t seem to find a clear answer on it so I decided to take to the experts here!  In laman’s terms, what’s the difference between the following as it affects inventory and accounting?  It seems to me they have the same functionality, but there has to be a difference between each one, no?Credit Memo Return for Credit RMA Order Return with Replacement

Hi @Naveen B , All, I have the following Generic Inquiry which I need to calculate a new cost from the attributes against the Item.  I think the calculation is not working due to the data types but am struggling with what prefix to use.Attributes:-I have tried using the Mask without luck also.  The generic inquiry is attached.Any help appreciated.Regards,laura 

We are trying to add a group at the end of the Summary tab on the Projects screen.  We create the new group by adding a new group from the controls box.  When we add the data field to the group and try to publish it, we get a Validation Error.  Is this the correct process to accomplish this?

What is the best option available if you have “Released a Payroll Batch” and did not get the .TXT file. Is there a way to Delete or Void a Payroll Batch so that a new one can be created? 

Is there a global or customer setting to allow overshipping on a shipment?Salesorder is for 10 pcs but shipping 12pcs. ThanksJohn 

Hi,I have two methods that extend functionality of 2 UI elements1)Release from Check and Payments tabProcess from Release Payments tab  Unfortunately, when I press process from Release Payments tab, it calls persist methods which is responsible for Release button in Checks and Payments and executes it’s logic, that I have wrote. I tried to omit this by using static class , checking if the flag was set to true in class which responsible for Release Payment tab, but it’s not working as I expected due to method is called arbitrary  How to prevent calling of Persist method of Release button when  Processed button is pressed ?

Hi, Good night. I want to recalculate the field (% Above Winner) when a new row is inserted/updated/deleted. I did the method (and it works) but when i put this method in a event of the same grid i got an error/debuggin visual studio warning. But if i put the method in other field (other tab etc, no in the same grid) it works.Can you helpme please? i paste some images to explain me better.  1.- this is the grid. I need to recalculate the column “%  AboveWinner “(for all rows) for Add,Update, Delete action.2.- when i put the method “getAboveWinners” in the update field event of this grid i got an “error”This is the error.When i put the method in other button/tab etc (not in the same grid) it works! public void getAboveWinners() { int countLowestValue=0; decimal? lowestValue=0; //we get the lowest value; foreach (CEEstimateBidWinner soLine in this.viewCEEstimateBidWinner.Select()) { if(lowestValue==0) { lowestValue=soLine.

We are just moving from our old system to Acumatica.  In our old system we have an email that is sent automatically a week after a shipment has been sent.We have a shipment confirmation automatic email notification going out when the status changes to shipped. Is there any way in Acumatica to trigger a subsequent email x days after that email?

When will the customization package be available for the Point of Sale module for 2021 R2?

Hello,we are at evaluating Acumatica cloud subscription stage:currently we have users who write/run sql select statement or view from SQL sever studio, server is on premise.if migrate to AWS, will this be a concern for us and any additional cost we need to consider?Z

Hello There,I want to setup commission per items, how can set the percent? Thank youJennifer