Generic Inquiry Tips & Tricks

Hi everyone! As you may know, a lot of things (such as OData, Push Notifications, Dashboards) in Acumatica are based on Generic Inquiries. In this post I’d like to share some tips and trick related to building GIs I found useful. I hope you’ll find them useful too. Join conditions containing multiple tables. Probably, the most unintuitive trick that you can do is adding join conditions based on fields that are not in the list of Parent Fields or Child Fields. Actually, you can use every field from every table to build join conditions in GI just like you do in SQL. You are not restricted by just Parent fields… Read more

How To: Count number of prints in Acumatica

Hi All In this post I will explain how to use Acumatica’s Audit feature help to keep count of how many times a invoice report was printed and then with a little bit of Acumatica Report Designer knowledge, you can indicate on the report if it is a copy/duplicate. The objective in this example is to print a invoice with a header “Tax Invoice” and when it is printed a second time to show “Copy of Tax Invoice”. Audit Feature First you have to setup an Audit of the [ARInvoice.Printed] field on the AR301000 screen: On Invoice and Memos screen (AR301000), the checkbox field below is updated to a true value… Read more

Prevent SO Invoice from Posting Inventory

Hi All, A quick customization tip for you – if you need to cut Inventory posting from SO Invoice you can just simple override PostInvoice and don’t call the base method.In this case Invoice will be successfully released, but inventory transaction will be totally ignored. This customization might be important in some cases and have an easy customization!

Accounting Basics for Developers

Hi All, Long time ago, one my good friend explained me the accounting principles in 30 minutes in a way where I (a system developer, that time) understood it and never forget anymore. This knowledge serves me for a more than 5 years now and I promised myself to share this knowledge with every one how needs. So here it is – Accounting basics for developers.I’ll focus on accounts, account types and general ledger to explain where it is coming from and why it is like this. I guess you’ll understand how to use it after that! Part 1 – Owner is a Core Historically wise, everything has started from… Read more

Acumatica Announced a Webinar Series for Developers

Hi All, Mark Franks just announced an exiting webinars series – I want to encourage you to join and attend most important topics to you. Event if you are in the different time zone, take this chance get a recording and be the first to know new perks in Acumatica Cloud! Please register by clicking on the webinars above you wish to attend. Credit Card Processing Enhancements – 22nd FebruaryJoin us as we discuss our roadmap for our credit card processing plugin for 2019 R2, and see what’s new in 2019 R1 .  We will talk about new processing plugin interface, mobile credit card payments, portal payments, changes in our Credit Card Payments… Read more

Primary & Foreign Keys

Hi Everyone, Acumatica is a advanced ERP system. And when we speak about ERP it is not only about data input, it also about how to store, retrieve and analyze data we have. Because of this we have very connected tables in Acumatica databas where almost every 3rd-4th column is a foreign key to other record. This helps a lot with data analyses.But how to organize keys better for usage, faster for search and smaller for database storage? Primary/Foreign Keys Definition In general we have only 2 ways to define and organize keys: Natural Keys and Surrogate Keys. Each way has own benefits. Natural keys (Code, CD)A natural key is… Read more

Use Acumatica xRP Platform from Console App

Hi All, Did you know that it is not necessary to have a Web Site under IIS to get benefits from Acumatica Platform? You actually can run Acumatica platform even from console app! To do this you just simple do following: Create Console Application in Visual Studio Add references to (PX.Common.dll, PX.Data.dll, PX.Objects.dll) Copy web.config from Acumatica site to app.config of your console application Specify user and company using PXLoginScope Use Acumatica Platform as normally you do that. Here you can find a code example followed by some comments: App.config file is required to Acumatica platform to get proper environment configurations, database connection and other settings. For experiments you can… Read more

Cash Discount Customization

Hi Everyone, Today want to share with you a ways to customize cash discount calculation in AP and AR. The main payer there is a TermsAttribute, that does all required discount calculations. It is linked to fields it need through parameters in constructor: ARInvoice.docDate – input – date of the document ARInvoice.dueDate – output – due data of the document ARInvoice.discDate – output – data where discount is applicable ARInvoice.curyOrigDocAmt – input – total document amt from where discount will be calculated ARInvoice.curyOrigDiscAmt – output – end discount value As there values are configurable it very easy to replace its calculations using customization framework and use different values as a… Read more

Restoring database and create an instance.

Hi guys, I want to share on how you will restore an instance from an existing database file. We usually use the snapshot function of Acumatica, if the system has too many tenants, you will make a snapshot every single out of it, which will make it very tiring task for you also added if the database data is so large. Note: This is only good if you have access on the database itself with management tools, like SQL Management Studio for SQL Server, or Any GUI for MySQL/MariaDB Servers which will produce a .bak File or a .SQL File for you to restore. How to Create an Instance from… Read more

Concurrent Update

HI All, With current web applications architecture it is complicated to track what users are doing on browser side: are they still online or on the way to take a cup of coffee? Will they save a record or just checking it?We can’t just lock records in the Web Application every time when someone have opened it for editing.So here we have 2 main problems: You don’t know who and when will save it You don’t know if user still online or not In Acumatica we have designed the platform in the way to not depend on user behavior. But we still have 2 different ways to manage concurrent update… Read more

Team Structure and Features Work

Hi Everyone, I would like to speak a bit about team development and would like to share a bit of experience of how Acumatica organize development teams. Actually within Acumatica history I really saw how company was changing from unstructured extreme programming to real and organized scrum. This was a long path full of mistakes and success. And I think this experience is worth to share. Here are few ideas to you. Acumatica team is one, solid team where 4 different types of employees are involved. This is important in terms of responsibilities for feature. Team owns the feature and should really focus all resources to deliver it on time.Here… Read more