Friday, November 23, 2018

Advanced Financial Management Features available in MS Dynamics NAV 365 Business Central

Below features of Financial Management are available and useful for Demo purpose for Pre Sales Consultant. Detailed steps are available on MSDN Website. If readers require any explanation , please comment below and let me know.

1. Cost Accounting

2. Master data in Cost Center

Cost Type & GL Account

3. Cost Accounting Tab is available on Chart of Accounts

4. Cost Objects

5. Cost Accounting Setup

6. Cost Allocation Dynamic/Static

7. Cost Center Vs General Ledger Accounting

8. Workflow in Cost Accounting

9. Setting Up Cost Accounting

10. Cost Entries

11. Cost Budget

12. Cost Allocations

13. Cost Accounting reporting

14. CashFlowForecast

15. Cash Flow Source -> Suggest CashFlowForecast->Register Cashflowforecast->StoreCashflow entries

16. Cash Flow Sources

a. Receivables
b. Payables
c. Liquid Funds
d. Manual Expenses
e. Fixed Assets
f. Service Orders
g. G/L Budgets
h. Jobs
I. Taxes
j. Cortona Intelligence

17. Steps for setting up Cashflow Forecast

a. Chart of Cashflow Accounts
b. Cashflow Setup
c. Cashflow payments terms
d. Cashflow Worksheets

18. Financial Reports available

a. G/L Account Balance
b. G/L Balance by Dimension
c. G/L Balance/Budget
d. BalanceSheet
e. Income Statement
f. Stmt of Cashflow
g. Stmt of Retained Earning

19. Account Schedule

20. Cost Budget Entries

21. Cash Flow Entries

22. Creating Reports based on Budgets

23. Analysis by dimension

24.Update Analysis Report

25. Financial Chart on Business Mngr. Rolecenter

26. Account Schedules Chart Setup

27. XBRL Terminology

28. XBRL Instance , Schema , Specification , Taxanomy integration

29. XBRL.ORG website for reference

Monday, November 19, 2018

Features in WareHouse

1. Warehouse Flow

a. Sales Order
b. Create Whse. Ship
c. Register Pick
d. Pick Document will Generate Post
e. Post SO

2. Purchase Order
Create Whse Recipt
Register Receipt
Put Away is created And Post Put Away
receive the Purchase Order

2. Location Blue is free to Ship/Receive and White is the location which is completely setup for Warehouse Demo in Demo Database.

3. Setups available in Warehouse

a. Warehouse Setup
b. Warehouse Employee
c. Location Setup

Bin Policy is the mandatory tab for decision making

d. Warehouse Zone Setup.

Warehouse is divided in Zones and Zones are divided in Bins

4. What is Bin?

Smallest unit in Warehouse.

5. What are available Activity Types in Warehouse?

Pick, Pur Away,Put Pick, QC,Receive ,Ship

6. Bin Ranking

Bin Ranking is provided to Bins in same zone for proper selection to System.

7. What are Put Away Templates?

STD , VAR

8.Stock Keeping Unit

Advance and dedicated Item Card fro WareHouse Activity

9. Warehouse class field in Item Card.

10. Item Tracking is integrated with Warehouse for Serial No and lot no.

11. Internal Movements

12. Bin Movement via Movement Worksheet

13. Bin Replenishment

14. Block Movement specific to a Zone

15. Whse. Internal Picks/PutAways

16.  Flushing Method Field on Item Card

17. How is Production Flow integrated with Warehouse?

Released Prod. Order
Select Location Code
Select Bin COde
Referesh Production Order
Post Consumption
Production Journal
Create Whse Pick
Pick Document (Select Bin Policy Always Create Put Line)
Pick
AutoFill Qty. To Handle
Register Pick
Whse. INternal Put Away
New
Get Bin Content
Zone Code
Bin
Create Put Away
Put Away
Autofill Qty To Handle
Register Put Away

18. What is Assembly Order and Integration with Assembly Order?

Assembly Orders are Knitting multiple Items into one and it is fully integrated with Warehouse like same as Other Modules.

19. How to Receive Items in Warehouse?

Via Put Away and Register and Post Put Away Document.

20. Waht is Cross Docking?

When we dont want to do Warehouse Activity just direct Ship and Receive from Warehouse.

21. How to use WareHouse Item Journal?

Warehouse Entry Only option

22. Warehouse Register

23. Item Journal Post

24. Whse. Reclass Journal

25.Whse. Phys. Inventory Journal

26. Inventory Period Physical Invt. Counting Period Code on Item Card

27. WareHouse Entry Archieve.

28. How to Enter a lost item?

Whse. Item Journal -> Register -ve Qty. -> Goto Item Journal _> Run Calc. Whse. Adjustment Batch-> Post

29. Pick Worksheet

30. BreakBulk

This is also breaking higher unit of measure to smaller.

31. Integration of Service Order with Warehouse.

All the steps are available in MSDN Sites. This post I had created for demo purpose , if any reader needs a clarification then I can give a full dedicated post.

Wednesday, November 14, 2018

FINANCIAL MANAGEMENT IN MS DYNAMICS 365 BUSINESS CENTRAL PART 1

Following is the features provided in Financial Management :

1. FINANCIAL MASTER DATA

G/L ACCOUNT
CUSTOMER
VENDOR
DIMENSION

2. ACCOUNT CATEGORY & ACCOUNT SUB-CATEGORY

These are the further characteristics provided by MS dynamics NAV from NAV 2017 which is helpful for categorisation.

3. DEBIT/CREDIT FIELD ON COA

This field usable for end users if they want some identification of transactions.

4. INDENT COA

This function indents the chart of accounts as per Begin Total and End Total.

5. G/L Category

We can create new Account category from G/L Category page

6. Single Dimension and Multiple Dimension

These are the dimension pages present on Chart of accounts where we can provide the dimension for a single account.

7. G/L Account Deletion Control

We can control G/L Account deletion from general ledger setup page.

Field Name : Allow G/L Account Deletion Before
Field Name : Check G/L Account Usage

8. Where Used Function of COA Card

We can check the GL Account where it is used.

9. + Amount indicates Debit and -Amount indicates Credit in Dynamics NAV.

10. INCOMING DOCUMENT FUNCTIONALITY

This functionality is very useful for users when they want to start SCM process with a soft document.
It provides to create PI,SI and other journals.

11. Workflow is fully integrated with Finance Module.

12. Save as Standard Journal Function on Journal Page

This function saves your journal lines so next time you need not to type the same lines again.

13. Recurring Journal

If end user is posting some transactions regularly in a frequency then we can use this journal which provide us the methods like
1. FIXED
2. VARIABLE
3. BALANCE
4. REVERSING FIXED
5. REVERSING VARIABLE
6. REVERSING BALANCE

14. How to get last Month date in NAV?

1M+CM

15. How to post Deferrals in NAV?

Deferrals are those journal entries in nav which you can divide to pay in future like insurance,salary which we cant post right now but in coming future we want it.
There are methods which we can use in NAV :-

1. STRAIGHT LINE
2. EQUAL PER PERIOD
3. DAYS PER PERIOD
4. USER DEFINED

We also have default deferral code in COA  Card.

16. BALANCE ACCOUNT TYPE FIELD ON GENERAL JOURNAL BATCHES?

Using this field we can define Bal. Account type field in Journals Page. We can define a bank Account if  we are always paying via a BANK. 

17. REMAINING AMOUNT FIELD & OPEN FIELD

These are very important fields available in ledgers via which we can identify the open lines for  a document and remaining balance for the same.

18. WE CAN POST MULTIPLE INVOICE IN PAYMENT JOURNAL.

19. WE CAN ALSO CHECK MULTIPLE PAID INVOICE AT ONCE IN APPLIED ENTRIES FUNCTION ON LEDGER PAGE.

20. HOW TO APPLY POSTED INVOICES ?

We can post these invoices separately via Post Application function on Applied Entries page.

21. WHAT IS PAYMENT REGISTRATION?

We can register a Vendor or Customer how we will pay. This we can set up in Payment registration page. This will be helpful for Post and Send Function.

22. What is Lump Payment?

When we need to post a customer for multiple invoices. This we can achieve easily by payment registration Setup.

23. SUGGEST VENDOR PAYMENT FUNCTION ON CASH RECEIPT JOURNAL

This function collects all the vendor payments we need to post in journal.

24. Vendor Priority and Available BAlance.

When we are having less amount available and we need to pay by priority we can define the priority in vendor card from Priority field

25. Export Payment FILE FUNCTION

We need to give a file to vendors for importing data in Excel , XML, word

26. HOW CAN WE PAY TO VENDORS?

1. COMPUTER CHECK
2. MANUAL CHECK
3. ELECTRONIC PAYMENT

27. HOW TO REPRINT THE CHECK?

We can void the existing check from Check ledger entry.

28. PAYMENT RECONCIALIATION JOURNAL

This Journal provides various functions which we can use for payment to vendor.

29. TEXT TO ACCOUNT MAPPING
 
This function you can match your Description which existing COA.

30. PAYMENT SERVICE

This function we can use to link our generated invoice to directly payment link.

31. BANK RECONCILIATION

32. OUTLOOK SYNC 

We can use assited setup called Outlook for financials which can synchronise the orders and invoices in mail.

33. OCR SERVICES

We can setup OCR in Incoming document page. We need to register on this URL to use this fucntionality. hhtp://store.readsoftonline.com

33. CASH FORECAST FUNCTIONALITY

This functionality allows you to check your future incoming recievables. You need to setup this.

For Example you can receive it via ;

1. Receivables
2. Liquid Fund
3. Payables
4. Manual Expenses/Revenue
5. Sales/Purchase Orders
6. G/L Budget
7. Jobs

34. STEPS for CASH FORECAST SETUP

1. COA Flow Accounts Setup
2. Cash Flow Setup

35. Steps for Close a fiscal year

1. Close Fiscal Year.
2. Close Income Statement

36. G/L Balance page we can check Balance per period as per G?L ACCOUNT

Last we can run close income statement report as many times as we want. If for any points any readers need clarification I can provide separate steps. But this post is for anyone want to quickly review the finance module.

Most of them are already available in MSDN.