Get inspired and gain all the knowledge you need
We have a Dollar account and a Euro account. We do a Bank Transfer from Dollar to Euro, enter the conversion rate, and everything works as it should. Except our Euro bank charges $5 and we send it in the same transaction. So if we want $1,000 worth of Euros, we actually transfer $1,005. We tried adding a $5 detail line on the Bank Transfer but it still shows up as a separate transaction. It would be silly to create a clearing account just to add these two amounts together, so we just deal with 2 debits in Acumatica Banking and 1 debit in Online Banking. Does anyone have a solution? (We don’t particularly want to modify the exchange rate to allow for the $5 either, although I know it’s another workaround.)
How do I give a user access to ONLY the Cross-Reference segment of the Stock Item screen?I can give them rights to images and packaging just fine. Those live under:Inventory → Stock Items → InventoryItemI have DELETE rights to Inventory → Stock Items → Cross-ReferenceBut I still can’t access that grid. I’m obviously missing something here. Any help is greatly appreciated.
Hi Team,In version 2020R2 we have override the “ActionDelegate” method in SOShipmentEntry Graph. Now we are upgarding to version 2022R2. I could see this method is available in the latest.Could you please let me know how i can resolve this. Regards,Ramya Krishna
Is it possible to export a customer attribute from Acumatica as a tag to the customer record in Shopify? We have a customer attribute that is a combo type attribute that we would like to send as a tag to Shopify. I’d imagine that should be possible with something like the below: However, I’m having difficulty testing this; if the above is correct, is there something else we need to set up to make sure this syncs to Shopify when this attribute is updated?
I've built out an Acumatica Webhooks project. I've successfully got it reading the incoming POST, and figuring out what to what to do. So far I can successfully insert Customers, Customer Locations and Projects without an issue. Honestly, from someone who does a fair amount of integration work, this is basically magic. These integrations are as close to real-time as is practical, so amazing work Acumatica.That said, using nearly the same code, I'm trying to insert AP or AR Invoices and I get bizarre or meaningless errors.I’ve stripped that code down to the most basic version, and when running the code that lives in the webhooks dll from a button on a graph it works exactly as expected. When it runs within the webhooks environment itself I get weird errors.For what it’s worth I’m running in 22R2, but I moved the code over to 23r1 and I get the same issues.My case in “in engineering review” so I thought I’d field it here to see if anyone has thoughts on what it is about the AR/AP graphs
Hi Experts,We are currently exploring the development of an add-on for customer-specific pricing in Acumatica. While Acumatica offers robust pricing capabilities, it does not provide native functionality for pricing based on specific customers. After reviewing other ERP software, such as Sage 300, we noticed that they have dedicated screens for managing contract pricing specific to individual customers.Considering this, we believe it would be a valuable idea to develop an add-on that extends Acumatica's pricing capabilities to include customer-specific pricing.Your insights and suggestions are highly appreciated. Regards,Sweta
Hello,I am adding a parameter to a working GI.I check the box “From Schema” on the parameter.There ARE records and values for this field and I show them on the output.If I set a default value on the parameter it works for the default.I simply cannot select a value for my parameter from the database which is the whole purpose of “From Schema”.Any thoughts?
I need help to figure out whats best to handle a production order that has been closed and still says there’s a balance remaining to produce even though you have scrapped some of the order that needed to be fulfilled and we don’t wish to issue more material to complete the order. For instance we wanted to produce 10 nozzles and issued the materials that were needed to full that order but 2 of them were damaged in the process. In the move transaction we moved the 8 the were completed and in the scrap section we put 2. Since we produced 8 and cant issue anymore material.What would be the best way to approach something like this since someone closed the order and can’t back track it?
We have a process where we produce WIP stock items from various raw material stock items via production orders. We then produce packaged finished goods from the WIP items plus a few more components via production orders. If an error were to occur, such as an improperly costed raw material found its way into the WIP item, that flows through to our sales orders on finished goods and COGS is incorrect. I have experience other ERPs where this is an issue and this is how it has been handled: Reverse sales orders to reverse GL entries to Sales/COS etc Reverse production orders to reverse impact to various produced items, whether WIP or FG Make corrections to materials Repeat steps 2 and 1 to arrive at the correct amounts.Obviously this is important for order/item margin analysis, but am I missing any unique ways of handling this in Acumatica? I could envision an inventory adjustment but that won’t reflect on the order/item level, simply on the GL/financial statement level.
Is there any difference between Base.ViewName.AllowUpdate = true and Base.ViewName.Cache.AllowUpdate = true
Hello All,Does anyone know what is the difference between “Base.ViewName.AllowUpdate = true” and “Base.ViewName.Cache.AllowUpdate = true”?My understanding from the Acumatica resources is the former is a shorter form of the latter. I have been using the short form forever and haven’t had any issues so far. I recently came across a weird situation in RowSelected event I am setting AllowEdit = true in the short form but when I trace I see the AllowEdit is still false RANDOMLY when this line of code is executed resulting in the line being read-only. I spent 4:30 tracing and chasing ghosts and finally, I just thought let's use the long form and surprisingly it is working.The funny thing is I have two Grids in the form and of course, each is tied to a view. One of them works just fine without any issues but the other one is acting up. The only difference between these two views is the one which is acting up has a view delegate while the other one is just a simple public view.Does anyone have
We are coming off an ECISolutions software and migrating to Acumatica. In the mapping of Customers there is a field called Account Ref which I believe links that customer to a GL Account. My question is what actually goes into that field? In ECISolutions there is a field called debnr that is listing the customer number back to the gbkmut table (main GL table). Would it be better to link the Customer Class back to the GL Account(s) or continue using the cusotmer number? The final say of course would be for the Accounting Manager to make that decision.
Hi All,My name is Rod Ingarfield. I am a Support Consultant with Stratus Consulting Group here in Australia, a Platinum MYOB Partner.I would like to be able to access some of the areas that document solutions to issues. In particular at the moment, there solution at: Discussions, Best Practices, and Product Feedback | Community (acumatica.com)Is this possible? If so, how can it be arranged?Thanks in advance (no pun intended)Rod
I am very new to customizations in Acumatica. I was wondering if it’s possible to only display certain values in a selector. For example, I would only like to display 3 out of the 9 possible values below as we would like to deprecate some of them. I’m assuming this has to be done with changes to the code, maybe a graph extension, but I have not made customizations through code changes before so I’m not sure how to approach this. If anyone has some example code for something similar, I would greatly appreciate it.
Hello Community,I have a requirement where a company has been selling their items to their customers.Here, they are recording the VAT for the sales as well as the income tax one the same record. So how shall I record the Income Tax on the same? Kindly guide me. Thanks in advance.
Employee time card :- Customization to calculate time spent based on the local start time and local end time cutom field
Helloo,I’ve added 2 custom field as local start time and local time field in the employee time card detail tab, but don’t know how to add a calculation on the time spent field, which will be difference between start time and end time entered in these 2 custom fields. Attached customization project of these custom fields. I would greatly appreciate any assistance in resolving this issue.Thanks.
A client, in Canada, needs to have some TaxIds grouped together on the printed AR InvoiceI created a subreport to do the calculations & return the calculated total. This is what the calculation is: =$GST + IIF ( [ARTaxTran.TaxID]='FREIGHT13' OR [ARTaxTran.TaxID]='FREIGHT15' OR [ARTaxTran.TaxID]= 'FREIGHT5' OR [ARTaxTran.TaxID]='GST' OR [ARTaxTran.TaxID]='GSTNOPST' OR [ARTaxTran.TaxID]='HST13' OR [ARTaxTran.TaxID]='HST15', [ARTaxTran.TaxAmt] , 0)This works perfectly for Invoices. When a Credit Memo is printed the result returns zero. I set the subreport up in the site map & ran it & the totals appeared as expected. I have no idea why the Credit Memo is not returning the results. Any assistance would be great!The 2 reports are attached.
\Clock Entry Screen with ErrorI have an employee who clocked in and somehow the system clocked him in over 45 days ago. Now...we cannot clock out and get an error message saying that the value is too lage (probably) for an Int32 field. Normally we would clock the employee out and fix the clock entries on the Approve Clock Entries screen. Any suggestions? We’ve had to create a temporary employee for this employee to use while we figure this out.
I am trying to use business event to schedule delivery email. After following the process of creating a GI, adding the notification template, linking a business event, and scheduling the automation schedule, the emails are still not being sent out, and it’s not executing. Has anyone encountered this issue before or knows how to go about solving it?
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.