Microsoft Fabric: Optimize Performance by Partitioning Delta Tables
In OneLake, we are able to partition data so that performance enhancements could be made through data skipping. Consider a situation where large amounts of sales data are being stored. You could partition sales data by year. The partitions are stored in subfolders named “year=2021”, “year=2022”, etc. If you only want to report on sales […]
Microsoft Fabric: Optimizing Database Table Architecture
Very simply, we are able to optimize lakehouse data table architecture. In the case where Spark is used, Parquet files are immutable and as such, we end up storing a lot of small files. The Optimize function allows us to reduce the number of files written as it just collates them into larger files. Within […]
Microsoft Fabric: OneLake Data Upload/ Table Transition/ Query & Report Building
To take raw data files in a csv file and transition it to a table format: In OneLake, access Files > data > ellipses > upload > upload files. Here, you will be able to upload a csv file or an excel file. From the data file, select the ellipses > Load to Tables > […]
Prevent Posting of Transactions W/O Specific Dimensions in Business Central
Navigate to the Dimensions page and select the required dimension and select Account Type Default Dim. under the edit list tab. Set TableID to the appropriate table. In my case, I set it as 15: G/L Account. In addition, set the Value Posting field to Code Mandatory.
Adjusting Item Sales Unit Price in Business Central
In the case where a company wants to adjust an item’s unit price based on a flat profit rate of 20%, you have two options: 1. Run the Adjust Item Costs/Prices batch job: Fill in what to adjust, the adjust field, adjustment factor (multiply the adjustment field amount by this value) and rounding method. 2. […]
Direct Cost Applied Accounts in Business Central
When purchasing inventory in Business Central, we see that it creates 4 entries: The reason for this is that having separate purchase accounts in BC provides an easy way to view inventory purchases. It allows for reporting to capture cost of goods sold more clearly as COGS = Beginning Inventory + Purchases – Ending Inventory […]
Posting Transactions Directly to The G/L in Business Central
General Journals are used to post transactions directly to G/L – bank, customer, vendor, and employee accounts. Access General Journals. Fill out the necessary fields in the journal line and Post. This will directly post this journal line to the G/L, whereas, payment and sales journals start from a purchase invoice or sales order and […]
Posting Group Types in Business Central
Posting groups are ways for us to map things(vendor or customer) to GL accounts, basically acting as a map to the proper G/L account.
JSM Workflow: As an Admin, I want to be able to create new documentation and connect it to a specific request form
Jira has a documentation sister product called Confluence. The appropriate documentation repository should already be connected and configured to the Jira Service Desk. In the case you would like to create new documentation and connect it to the appropriate request form, please follow these steps: In the appropriate space (in Confluence), for the appropriate folder […]
JSM Workflow: As an Admin, I want to be able to interact with tickets using Teams
Jira and Microsoft Teams has an integration that enables specific users to comment and edit tickets, as well as query for tickets. Looking at the Teams integration with Jira, we can see that there are 3 main channels: General, IT Support and Tickets. The IT Support channel’s purpose is to have a space where admins […]