Consultant Diary: SQL Server – In order to get the list of tables in a database with column counts, run the below query in SQL Server Management Studio. SELECT table_name , COUNT(COLUMN_NAME) RecCountFROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_CATALOG = ‘DBname’ AND TABLE_SCHEMA = ‘dbo’ and TABLE_NAME like ‘Tablename%’group by... Continue reading
+1-905-282-9675
operations@smartmilestones.com
#400, 30 Eglinton Ave W. Mississauga, ON, L5R 3E7, Canada
+1-905-282-9675
Blogs By Smartmilestones
In today’s fast-paced business environment, small businesses need efficient inventory management software to stay competitive. Whether you’re a small retail shop or an e-commerce startup, having the right tools to manage your inventory can make all the difference. In this guide, we’ll explore the best... Continue reading
Select required work date Continue reading
The Default Posting Date determines the default date used when posting purchase documents such as purchase orders, invoices, and credit memos. Configuring the Default Posting Date Open Business Central and navigate to the “Purchases & Payables Setup” screen. Locate the “Default Posting Date”... Continue reading
Example 1 Simple Codeunit for Logging A basic codeunit that provides functionality to log messages. codeunit 50000 “Log Management” { procedure LogMessage(Message: Text) begin // Code to log the message end; } Below is the Example of calling the Above “Log Management” codeunit from... Continue reading
Step Document Name & Description Item Example Stakeholder Debit (GL Type & Description, Reason for ↑/↓) Credit (GL Type & Description, Reason for ↑/↓) Debit Amount (↑/↓) Credit Amount (↑/↓) 1. Purchase Requisition Creation Purchase Requisition Form Shipping services request Procurement Dept. Inventory (BS: Asset,... Continue reading
What is a Codeunit? A Codeunit in AL language is a container for AL code that performs a specific business task, operation or logic. Think of it as a module or a library where you can group related procedures and functions. This encapsulation makes your... Continue reading
Tax(Balance Sheet)Tax…InspectionReceiving(Balance Sheet)Inspectio…Purchase RequisitionPurchase Req…Purchase Requisition ApprovalPurchase Requ…QuotationsobtainedQuotations…Preparation of Comparative StatementPreparation o…GRN Good Recieved NoteGRN…A purchase requisition is a formal document that is used when an employee needs to request for a purchase. Purchase requisition is usually prepared by requesting department and approved by designated approver.A purchase requisition is a formal document that... Continue reading
AccumulatedDepreciation(Balance Sheet)Accumulat…Overheads Payable(Balance Sheet)Overheads…StakeholderStakeholderDocument Name & DefinitionDocument Name & DefinitionGeneral Ledger EffectGeneral Ledger EffectSales ManagerSales Manager
Order received Order receive…Receiving the order by sales department means accepting the order from customer.Receiving the order by sales department means accepting the order…The order requirements are completed and officer prepares... Continue reading
AccumulatedDepreciation(Balance Sheet)Accumulat…Overheads Payable(Balance Sheet)Overheads…StakeholderStakeholderDocument Name & DefinitionDocument Name & DefinitionGeneral Ledger EffectGeneral Ledger EffectSales ManagerSales Manager
Order received Order receive…Receiving the order by sales department means accepting the order from customer.Receiving the order by sales department means accepting the order…The order requirements are completed and officer prepares... Continue reading
Showing 1–10 of 19 posts