Compress Lines in POS- Microsoft Dynamics NAV/BC LS Retail

Compress lines in POS

Client always ask question when using LS retail POS about compressing the same lines if same item is scanned more than one time. For example customer buys 5 bottles of soya sauce of American Garden, it should appear as 1 line with 5 quantities in POS instead of 5 lines for 5 quantities. 

Let us see how this can be achieved.

1. Go to the functionality profile which is attached to the Store/Terminal.

  

2. Navigate to the functionality card and tick mark the Compressed when scanned option as shown below

3. Check below the POS line for once compress when scanned is checked and when it is unchecked.

I hope you guys like the post, keep liking and keep sharing. 

How to Skip/Add VAT printing on receipt - Microsoft Dynamics LS NAV/BC

VAT Printing on receipt

We can manage the printing of VAT on Microsoft Dynamics NAV/BC LS Retail.

1. Go to the functionality profile card ( Name of the functionality profile you will find in the store card or terminal card)

2. Now move to the functionality Profile Card and under Amount TAB there is option called skip VAT on Receipt

3. Check the receipt now, it should not have VAT column

How to setup TIPS in Microsoft Dynamics LS NAV/BC?

Tips in Restaurant

In Restaurant business there is lot of tips are given and have you ever wondered how to implement tip in Microsoft Dynamics LS NAV/BC. In LS Retail there is simple option available to configure Tips, Let us see how we can configure it.


1. Go to the store card and then click on cash & Management then tips

2. Configure an income account as shown below

3. Let us make a button on the POS to enter the tips.

4. Command in Tips button

Opening balance Part 1:- Microsoft Dynamics NAV/BC

There are lot of queries come my way from juniors or people who are starting their career in ERP field. 

What are opening balances?

Opening balances are generally the first entry which we enter from start of the financial period. 

Let us see the real ERP life example. Suppose there is company called ABC General Trading LLC. Company ABC is using a local ERP for last 5 years and want to move to new Business Central/Navision ERP beginning of year 2019. As they are already using some local ERP it will have closing balance at the end of year 2018. Suppose there is closing balance of Customer is USD 50,000. There are total 3 customers Active Distribution, Sintech Distribution, Infotech Distribution having balance of USD 25,000, USD 20,000 and USD 5,000 respectively. Let us import there opening balances in Business Central/Navision starting year 2019.

Opening balance format for Navision/Business Central for 3 customers.

Put the above opening balance format in General journal and post them.

Charge late payment fees- Microsoft Dynamics NAV/BC

Late Payment fees/Finance Charge Memo:- We can automate the late payment fees on the customer invoices. Navision has the option of setting up terms for the late payment fees. Let us first setup the Finance Charge terms. Navigate to the finance charge terms to the following path. This finance charge term will be mapped to customer.

What is Late payment fees? 

Late payment fees are the interest or charges which are debit to customers in case the payment for invoice is not received within due date.

Setup Late Payment fees/Finance Charge Terms

Interest rate:- Interest in percentage which is charge to the outstanding invoices.

Interest Calculation Method:- Average Daily balance, calculate the interest charge based on daily closing balance.

Make a sales invoice for the period for which due date already has passed.

Customer ledger entry

Create a Finance charge Memo

New Finance charge memo is created along with the late payment fees. System calculates the value of late payment fees based on finance charge terms which we defined in the previous step.

Issue the Finance charge memo

Posted Finance charge memo

Automatically apply Payment at the time of Posting sales order:-Microsoft Dynamics NAV/BC

There are always some cash sales happen in every trading company. I have faced so many questions regarding it from client. Every time client asks to settle the invoice at the time of  posting of sales order. We configure the same in Navision/Business Central.

1. Create a Sales Order

2. Attach the Payment method in the sales order under Invoice Detail TAB

3. Payment method should have balancing account attached to it.

4. Post the sales order now

5. Navigate the Posted sales invoice and see payments are applied to the document

Subscribe to Blog

Subscribe the blog to get the notification to your email. To subscribe then enter your email ID in the Top right of the page.

Closing Income statement Second Time for the same year-Microsoft Dynamics NAV/BC

What is Income Statement Closing?

It is the process of passing entries to retained earning account from Profit and Loss accounts. Retained earning is the balance sheet account. Whatever company earns in accounting period that is transferred to the balance sheet at the end of the accounting period making the Profit and Loss account zero.

Let us see the simple format of Profit and Loss account.

In our scenario Income statement is already closed but by mistake users has passed the entries in closed period. We would be closing the income statement second time. In Navision/Business Central income statement can be closed second time if the entries are passed in closed period.

Pass Entry in Closed period

Close the Income Statement second time for the Year 2007

Run the Closing income statement batch Job

Post the Entry for the income statement which is created in general journal with document no. Closing 2nd 2007

Conclusion:-  Income Statement in Navision/Business Central can be closed second time for the same period too.

Subscribe to Blog

Subscribe the blog to get the notification to your email. To subscribe then enter your email ID in the Top right of the page.

Payment Tolerance:- Microsoft Dynamics NAV/BC

What is Payment Tolerance?

You can set up a payment tolerance to close an invoice when the payment does not fully cover the amount on the invoice.You can use payment tolerances so that every outstanding amount has a set maximum allowed payment tolerance. If the payment tolerance is met, then the payment amount is analyzed.

How to setup payment Tolerance in Business Central/NAV?

1. Go to general ledger and setup to set payment tolerance

2. Put the payment tolerance

Payment Tolerance %:- Maximum percentage to allowed to post to the payment tolerance account. 
Max. Pmt. Tolerance Amount:- This is the maximum amount the tolerance will be posted.

Customer Posting Group will have the account where payment tolerance will be posted. 

What is customer posting group?

This posting group maps the accounts receivable account, payment discount accounts, invoice and application rounding accounts, interest and fee accounts relating to customers.

3. Let us adjust the Invoice of amount 990.25 against payment of 990. The system will post .25 to payment tolerance account.

4. System would prompt for payment tolerance warning.

5. After posting the payment, Tolerance will be posted to tolerance account.