Friday, July 24, 2020

Fixed Asset Reclassification Journals on Microsoft Dynamics Nav Business Central

Dear Friends,

Today's we will learn how to do a reclassification journal for fixed asset. The aim of doing this is sometime users regroup many fixed asset in one fixed asset and something when they wish to dispose some fixed asset from that group they are not been able to do so because disposal is done fully not partially. To dispose the small quantity of asset, what can be done is to transfer these fixed asset to another asset and dispose it completely. To transfer a fixed asset to another fixed asset you need to do it on reclassification journal.

To access the journal go on the following menu:

Main Menu --> Department --> Financial Management --> Fixed Asset --> FA Reclass. Journal.


FA Posting DateEnter the posting date
Document NoIf no series is set up it will generate automatically else put it manually
FA No.Enter the original fixed asset number
New FA NoEnter the new fixed asset number
Depreciation Book CodeEnter the depreciation book code
DescriptionName of the original fixed asset will display there, you can enter a description manually
Reclassify Acq Cost %Enter the percentage amount you wish to transfer
Reclassify Acquisition CostIf you want to reclassify the acquisition cost checked this field
Reclassify DepreciationIf you want to reclassify the depreciation cost checked this field
Reclassify Write-DownIf you want to reclassify the write down cost checked this field.

Then Click on the button Reclassify.


Click OK to close.

Thursday, July 23, 2020

Revaluation of item cost on Microsoft Dynamics Nav Business Central

Dear Friends,

Today's tutorial is about evaluating item, revaluation is done when the user wishes to evaluate its inventory due to price changes and inflation in the market.

To do the revaluation go on the following menu.

Main Menu --> Department --> Financial Management --> Inventory --> Costing --> Revaluation Journals.


Step 1:

Click on the button Calculate Inventory Value

Step 2:

Fill the pop up filter.

a.) Enter the posting date.
b.) Enter a document number
c.) Calculate per item ledger entry
d.) Enter the Item No.

Step 3:

Enter the unit Cost you wish to revaluate.


Then Amount, Unit Cost (calculated), Inventory value (calculated) will be calculated automatically.

Step 4: 

Click on Post validate the revaluation.


Click on OK to close and go to your item card and check the unit cost.



Wednesday, July 22, 2020

Creation of Sales Quote on Microsoft Dynamics Nav Business Central

Dear Friends,

today we will learn how to create a sales quote. The aim of doing that is that some company they give quotation to client upon approval of quotation then they convert the sales quote to a sales order.

Step 1:

To create a sales quote go on the following menu

Main Menu --> Department --> Sales & Marketing --> Order Processing --> Sales Quotes.

Step 2:

Click on the button New


Step 3:

Enter the following Information.


General
Customer NoEnter the customer number
Customer NameThe name of the customer will display automatically
External Document NoEnter any important number related to the quotation
Sell-to
AddressAddress of the customer will display automatically
Address 2Address of the customer will display automatically
CityCity of the customer will display automatically
Post CodePost Code will display automatically
Country/RegionCountry will display automatically
Contact NoIf the customer has a contact person enter the contact number
ContactThe Contact person name will display automatically
Customer Template CodeIf the customer has a template code enter it
Order dateEnter the order date
Document DateEnter document date
Quote Valid to DateEnter the validity date of the quotation
Due DateDue date will be calculated automatically
Requested Delivery DateEnter the delivery date
Your ReferenceEnter any reference you have
Salesperson Codeif you have sales person code enter it to show which sales person has work  on the quote
Campaign NoEnter campaign number
Opportunity NoEnter Opportunity number
Responsibility CenterEnter Responsibility center
Assign User IdIt will show who has created this sales quote
StatusIt shows the status of the quote
Work DescriptionIf you have any other description, you can enter it.


Lines
TypeEnter the Type
NoEnter the type number
DescriptionThe name of the type will appear automatically
Location CodeEnter the location code
QuantityEnter the quantity
Unit of MeasureEnter the unit of measure
Unit Price Excl VATEnter the unit price
Line Amount Excl VATQuantity * Unit price
Line Discount %If you want to give  line discount percentage
Line Discount AmountIf you want to give a line discount amount
VAT Prod Posting GroupEnter the VAT type



Invoice Details
Currency CodeEnter the currency code if the the quote is foreign
Shipment DateEnter shipment date
Prices Including VATIf the VAT is included in price
VAT Bus. Posting GroupEnter VAT business posting group
Payment Terms CodeEnter the payment terms code
Transaction TypeEnter the transaction type
Payment Discount %Enter any discount % on payment
Pmt. Discount DateEnter the date of the payment discount
Location CodeEnter location code.


Shipping and Billing
Ship-toIf you want to ship the item to another location
Code    Enter the location Code
NameThe name of the location will display
AddressThe address of the location will display
Address 2The address of the location will display
CityCity of the location will display
Post CodePost code of the location will display
Country/RegionCountry of the location will display
ContactIf the location has a contact person enter the contact no
Shipment Method CodeEnter the shipment method code
AgentEnter the agent
Agent ServiceEnter the agent service
Package Tracking NoEnter the package tracking number
Bill-toIf you want to bill another customer
NameEnter the name of the customer
AddressAddress of the customer will display automatically
Address 2Address of the customer will display automatically
CityCity of the customer will display automatically
Post CodePost code of the customer will display automatically
Country/RegionCountry of the customer will display
Contact NoIf the there is a contact person at the customer enter the contact no
ContactName of the contact will display automatically


Foreign Trade
EU 3-Party TradeIf the quote is a third party trade for Europe 
Transaction SpecificationEnter the transaction specification        
Transport MethodEnter the transport method
Exit PointEnter the exit point
AreaEnter the area.

Step 4:

After entering all information, click on the button Make order to convert the sales quote to a sales order.


Step 5:

to check if the sales order has been created go on the following menu.

Main Menu --> Department --> Sales & Marketing --> Order Processing --> Sales Order

Tuesday, July 21, 2020

Creation of purchase quote on Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will learn how to create a purchase quote then proceed to make it a purchase order. Some companies they do not generate purchase order directly for any purchases they take quotation from different supplier and the best quotation will be converted to purchase order.

Step 1:

to create a purchase quote go on the following menu:

Main Menu --> Department --> Purchasing --> Order Processing --> Purchase Quotes

Step 2:

Click on the button New.


Step 3:




General 
Vendor NoEnter the Vendor No
Vendor NameThe name of the vendor will appear automatically
Quotation NoEnter the quotation number you received
ContactIf the vendor has a specific contact person
Document DateEnter the document date
Order DateEnter the order date
Request Receipt DateEnter the receipt date
Vendor Order NoEnter the vendor order number
Vendor Shipment NoEnter the vendor shipment number
Purchaser CodeEnter a purchase code if there are
Campaign NoEnter the campaign no if there are
Alternate Vendor Address CodeEnter if the vendor has an alternate address
Responsibility CenterEnter the location of the vendor
StatusThis shows the status of the order
Lines
TypeEnter the type you wish to use 
NoEnter the type number
DescriptionThe name of the type will be display automatically here
Location CodeEnter location Code
QuantityEnter the quantity
Unit of MeasureEnter the unit of measure
Direct Unit Cost Excl VATEnter the unit cost
Line Amount Excl VATIt will take the quantity * unit cost
Line Discount %If you want to give a discount in term of percentage
Line Discount AmountIf you want to give a discounted amount
VAT Prod Posting GroupEnter the VAT type


Invoice Detail
Currency CodeEnter the currency code
Expected Receipt DateEnter the delivery date
Price Including VATIf you want to enter the price including vat
VAT Bus posting GroupEnter the VAT Bus Posting Group
Payment Terms CodeEnter the Payment Term Code
Payment Method CodeEnter the Payment Method Code
Transaction TypeEnter the transaction type
Payment Discount %
Enter if there are payment discount
Pmt Discount DateEnter the payment discount date
Shipment Method CodeEnter the shipment method code
Payment ReferenceEnter Payment Reference
Creditor NoEnter the creditor number
On Holdstate if it is on hold
Shipping and Payment
Ship-toIf you want to ship to another location
NameEnter location name
AddressEnter ship to address
Address 2Enter ship to address
Post CodeEnter ship to post code
CityEnter ship to city
Country/RegionEnter ship to region
ContactEnter if there is a contact person to the shipment location
Pay-toIf you want to pay the vendor on another name
NameEnter vendor name
AddressEnter vendor address
Address 2Enter vendor address
Post CodeEnter vendor post code
CityEnter Vendor city  
Country/RegionEnter vendor country
Contact NoIf vendor has a contact person enter contact no   
ContactContact person name will display automatically


Foreign Trade
Transaction SpecificationEnter the transaction specification
Transport MethodEnter the transport method
Entry PointEnter the entry point
AreaEnter the area

Step 4:

proceed to make the purchase quote to a purchase order.

Click on the button Make Order.


Step 5:

to check if the purchase order has been created, go on the following menu.

Main Menu --> Department -->  Purchasing --> Order Processing --> Purchase Order.


Monday, July 20, 2020

Change Report on Post and Print Button On Microsoft Dynamics Navision Business Central.

Dear Friends,

Today we will learn how to configure report on post and print button on different journal.

1. Go to the following menu if you want to change for the following:

a.) Purchase Order
b.) Purchase Quote
c.) Purchase Invoice
d.) Purchase Credit Memos
 and any thing related to purchase.

Main Menu --> Departments --> Purchasing --> Order Processing --> Setup --> Report Selection Purchase


On the field usage you need to choose which page you wish to put the report. when you have already select the page then enter the report id in the field report id.


2. Go on the following menu if you want to change for the following:

a.) Sales Order
b.) Sales Quote
c.) Sales Invoice
d.) Sales Credit Memos

and any thing related to sales.

Main Menu --> Departments --> Sales & Marketing --> Order Processing --> Setup --> Report Selection Sales.


Setup is same as purchase.

3. Go on the following menu if you want to change for bank reconciliation and check printing.

Main Menu --> Departments --> Administration --> General --> Report Selection Bank Account


setup is same as purchase.

4. Go on the following menu if you want to change for the following:

a.) Transfer Order
b.) Transfer Shipment
c.) Transfer Receipt

Main Menu --> Department --> Administration --> IT Administration --> Report --> Report Selection Inventory.


Setup is same as purchase.

Thanks

Thursday, June 11, 2020

Sales order creation on Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will learn how to create a sales order, it is a piece a document that is used to buy goods or services to a customer.

Step 1:

go on the following menu:

Main Menu --> Sales & Marketing --> Order Processing --> Sales order



Step 2:

Click on the button New and fill the information.


General
Customer NoEnter the customer code here
Customer NameCustomer name will display automatically
Sell-to
AddressCustomer address will display automatically
Address 2Customer address will display automatically
CityCity will display automatically
Post CodePost code of the customer will display automatically
Country/Region CodeRegion code will display automatically
Contact NoIf the customer has a contact person, choose the contact no
Contact NameThe name of the contact person will display automatically
Document DateEnter document date
Posting DateEnter posting date
Order DateEnter order date
Due DateDue date will be calculated automatically
External Document NoIf you have any important number related to the sales order enter it here
StatusStatus of the sales order.
Lines
TypeEnter the type
NoChoose the type
DescriptionDescription of the chosen type will display automatically
Location CodeEnter the location code
QuantityEnter the quantity
Unit of MeasureEnter the unit of measure
Unit Price Excl VATEnter the price excluding vat
Line Amount Excl VATQuantity * Unit Price
Line Discount %Enter discount percentage if you want to give
Qty to shipIt will be populated automatically
Quantity ShippedIt will be populated automatically
Qty to invoiceIt will be populated automatically
Quantity InvoicedIt will be populated automatically
VAT Prod. Posting GroupEnter the vat product posting group
Gen. Prod. Posting GroupEnter the general product posting group
Line Discount AmountIf want to give a discount amount
Line NoLine number will display automatically



Invoice Details
Currency CodeIf it is a foreign invoice, choose the currency
Global Dimension 1Enter Global Dimension 1
Global Dimension 2Enter Global Dimension 2
Shipping and Billing
Ship-toIf you want to ship the item to another location
CodeEnter shipment code
NameThe name will appear automatically
AddressAddress will appear automatically
Address 2Address will appear automatically
CityCity will appear automatically
Post CodePost code will appear automatically
Country/RegionRegion code will appear automatically
ContactEnter the name of the contact person there
Bill-toIf you want to sent the bill to another person
NameEnter the name of the customer
AddressAddress of the customer will appear automatically
Address 2Address of the customer will appear automatically
CityCity of the customer will appear automatically
Post CodePost code will appear automatically
Country/Region CodeRegion code will appear automatically
Contact NoIf the customer has a contact person, enter the contact code
Contactthe name of the contact person will appear automatically
Location CodeLocation code of the customer will appear automatically

Step 2:

Click on the button Release.


Step 3:

Click on the button Post.


Step 4:

Choose ship and click on OK


Step 5:

Choose Invoice and click on OK.


After Clicking on OK the system will validate all account.

Wednesday, June 10, 2020

Purchase Order Creation on Microsoft Dynamics Nav Business Central

Dear Friends,

Today we will learn how to create a purchase order, then proceed with the good receipt then after we will proceed with the invoicing. The purchase order is a piece of document which allows you to purchase a goods or services to a supplier.

Step 1:

Go on the following menu:

Main Menu --> Departments --> Purchasing --> Order Processing --> Purchase Order.


Step 2:

Click on the button New and fill the information.



General
No.If no series is setup, purchase order number will generate automatically
Buy-from vendor no.Enter vendor number
VendorVendor name will display automatically
File refEnter file reference if there is
RemarksEnter a remark if there is
Buy-from
AddressAddress will display automatically
Address 2Address will display automatically
Post CodePost Code will display automatically
CityCity will display automatically
Contact noChoose a contact person if the vendor has one
ContactThe name of the contact person will display automatically
Document DateEnter document date
Posting DateEnter posting date
Due DateEnter due date
Vendor Invoice NoEnter the vendor invoice number
Order DateEnter the order date
Quote NoIf purchase order has been created from a quote the quote number will display here
StatusStatus of the purchase order
Prepared ByState who has created this purchase order
Lines
TypeEnter the type
Line NoLine Number will display automatically
NoEnter the type number
VAT Prod Posting GroupEnter a vat production posting group
Gen Prod Posting GroupEnter a general product posting group
DescriptionThe description of the type chosen will appear here
Description 2Enter a second description if you have
Location CodeEnter a location code if you have
QuantityEnter the quantity
Direct Unit Cost Excl VATEnter the direct unit cost
Line Amount Excl VATQuantity * direct unit cost
Line Discount %Enter a discount percentage if you have
Line Discount AmountEnter a discount amount if you have
Quantity ReceivedThe quantity received will be adjusted automatically



Invoice Details
Currency Code
If purchase order is in foreign currency
Global Dimension 1Enter a global dimension 1 if you have
Global Dimension 2Enter a global dimension 2 if you have
Location CodeEnter a location code
Sell-to customer NoEnter the sell-to customer if you have
Expected Receipt DateEnter the receipt date of the item or services
Shipping and Payment
Ship-to
CodeEnter a shipment code if you wish to ship the item to another location
NameEnter destination vendor name
AddressEnter destination address
Address 2Enter destination address
Post CodeEnter destination post code
CityEnter destination city
Contactif the vendor has a contact enter is here
Pay-to
NameIf you wish to pay another vendor, enter the name here
AddressEnter address
Address 2Enter address
Post CodeEnter post code
CityEnter city
Contact NoIf the vendor has a contact person, enter the contact no
ContactName of the contact person will appear automatically

Step 3:

Click the button Print to get a hard copy of the purchase order to send the vendor.


Step 4:

Release the status of the purchase order, click on the button release.


Step 5:

Click on Post and choose receive. This is done when goods is received in the stock



Step 6:

Click again on Post and choose invoice. This is done when invoice is being done for payment.



Click on OK to close

Tuesday, June 9, 2020

Item Journal on Microsoft Dynamics Nav Business Central

Dear Friends,

Today's tutorial is about using item journal. The use of this journal is when we need to make adjustment of stock in term of quantity.

Step 1:

To access the journal go on the following menu:

Main Menu --> Departments --> Purchasing --> Inventory & Costing --> Item Journal.


Step 2:

Fill the following information.

Line Noline number will be populated automatically
Posting DateEnter the posting date
Entry TypeEnter the entry type
Document NoIf no series is setup the number will be generated automatically else enter manually
Item NoEnter the item number
DescriptionThe item description will display automatically
Location CodeEnter the location code
QuantityEnter the quantity
Unit of MeasureEnter the unit of measure
Unit Amountin case of sales enter the unit amount
AmountQuantity * Unit Amount or Quantity * Unit cost
Discount AmountIf there is a discount enter it
Unit CostIn case of purchase enter the unit cost
Shortcut Dimension CodeEnter a shortcut dimension if there is.
Applies-to EntryIf you want to link the transaction to a item ledger entry
Bin CodeEnter a bin code is there is
Shpt. Method CodeEnter a shipment code if there is

Step 3:

Click on Post to validate the transaction.


Click on OK to close.

Thursday, May 28, 2020

Item creation on Microsoft Dynamics Nav Business Central

Dear Friends,

Today's tutorial is about creating an item. It is an physical article that is bought to be used in the company or sell to a customer. An item is stored in a stock, when item is being bought, the stock is debited and when item is being sold, the stock is being credited.

Step 1:

Go on the following menu:

Purchasing

Main Menu --> Department --> Purchasing --> Inventory & Costing --> Items

Sales

Main Menu --> Department --> Purchasing --> Sales & Marketing--> Items


Step 2:

Click on the button New and enter the following information.



Item
NoIf no series is setup then the item no will generate automatically
DescriptionEnter the description of the item
Base Unit of MeasureEnter the unit of measure of the item
Item Category CodeEnter the item category code
Inventory
Shelf NoEnter the shelf no
Created from Catalog ItemIf you want to create from a catalog item
Search DescriptionSearch description will be set as description
InventoryThis will show the stock count
Qty. on Purch. OrderThis will show the quantity use on purchase order
Qty. on Prod. OrderThis will show the quantity use on production order
Qty. on Component LinesThis will show the quantity use on component lines
Qty. on Sales OrderThis will show the quantity use on sales order
Qty. on Service OrderThis will show the quantity use on service order
Qty. on Job OrderThis will show the quantity use on job order
Qty. on Assembly OrderThis will show the quantity use on assembly order
Qty. on Asm. ComponentThis will show the quantity use on assembly component
Stockout WarningIf you wish to get an alert if stock amount is zero
Prevent Negative InventoryThis will prevent any negative inventory
Net WeightEnter the net weight
Gross WeightEnter then gross weight
Unit VolumeEnter the unit volume
Costs & Pricing
Cost Details
Costing MethodEnter the costing method
Standard CostThe standard cost will display automatically
Unit CostUnit cost of the item will display automatically
Special Purch. Prices & DiscountsIf you want to create a special purchase price and discount
Posting Details
Gen. Prod. Posting GroupEnter the general product posting group
VAT Prod. Posting GroupEnter the VAT product posting group
Inventory Posting GroupEnter the inventory posting group



Prices & Sales
Unit priceThe last unit price for of the item will display here
Planning
Dampener QuantityThe dampener quantity will appear automatically
Order Modifiers
Order MultipleThe order multiple will display automatically

Click on OK to close

Standard Sales Code On Microsoft Dynamics Nav Business Central

Hello Friends,

Today we will learn how to create a standard sales code. The aim of using sales code is to allow the user to create invoice with the same invoice line.

Step 1:

Main Menu --> Department --> Financial Management --> Receivable --> Setup --> Standard Sales Code.


Step 2:

Click on the button New and fill the information.




General
CodeEnter a code for the standard code
DescriptionEnter a description
Currency CodeEnter a currency code if the invoice is foreign
Lines
TypeEnter a type for the line
NoEnter the no of the type
DescriptionThe description will appear automatically
QuantityEnter the quantity

Click on OK to close.