AX 2012 | Sales order Prepayment

Until recently, I thought there is no standard functionality to link sales order with prepayment. Guess what ! I was wrong.
Dynamics AX provide simple straight foreword functionality to link prepayment with sales order. Special thanks to Ahmed Assaf, who helped me to figure this out.

the following steps illustrate how to link prepayment with sales order:

AX 2012 | Cash On Delivery

In the previous post we had discussed how to process cash sales. Today we are going to continue the second part of the cash sales where customers must pay when they receipt the goods or services. this process what we call cash on delivery.

Dynamics AX provide the functionality to process the cash on delivery. the following steps illustrate how to set up and process the cash on delivery.

AX 2012 | Cash Sales

In this post we will illustrate how to configure and process cash sale within Dynamics AX 2012. Cash sales is one of the common business practice between entities. In cash sales process the customer is required to pay cash on the spot. Dynamics AX create two vouchers when we post sales invoice with cash payment terms as follow:

First voucher

Debit: Customer Account

     Credit : Revenue Account 

Second vouchers 

Debit: Cash Account

     Credit : Customer Account

follow the few steps below to set up and process cash sales:

AX 2012 | Address Book Security Based on Team

In this tutorial we are going to discuss how to set security privileges to party records (Customers, Vendors, Workers, Contact, Prospect, Applicant... etc). Dynamics AX provide three ways as following :

• Secure by legal entity
• Secure by address book
• Secure by both legal entity and address book.

In this post we are going to focus in how to secure Address book based on teams. which means that only workers who are assigned to a team that has access to an address book can view the party records in that address book.

when we select Secure by address book, access to the address books is restricted by team. You must select the teams that have access to each address book. For each address book, you can set security privileges that allow or deny access to specific teams. If you grant a team privileges to an address book, all members of the team can view the records in the address book. If you do not grant a team access to an address book, the team cannot view the address book or its contents.

AX 2012 | Reimburse Customers

This article illustrate how to create reimbursement transactions for customers. Reimbursement transaction used when a customer has a credit balance, if the following conditions is applied you can reimburse customer for the amount of the balance.

1. The customer must have an associated vendor account( If a customer does not have a vendor account, a one-time vendor account is automatically created for the customer).
2. balance amount must exceed the minimum reimbursement amount that is specified for your legal entity.

When you create reimbursement transactions, a vendor invoice is created for the amount of the credit balance. This will remove the credit balance for the customer account and creates a balance due for the vendor account that corresponds to the customer.

Do the following steps to set up and create reimbursement transactions:

AX 2012 | Withholding Sales Tax

In this post we will discuss how to set up and calculate the withholding tax in Dynamics AX. Withholding tax is due on non-inventory deliveries (services), that a supplier delivers.

Buyer is legally responsible for paying withholding tax therefore The buyer is responsible for withholding a certain percentage of the invoice amount at the time of payment. (Net amount = invoice amount - withholding tax) is paid to the supplier. 

The tax withheld posts to a ledger account for withholding tax, and periodically is paid to the TAX authorities.

To to set up withholding tax perform the following steps:

Use the same number with transaction and transaction voucher

In this post i will illustrate how to use same number with transaction and transaction voucher. Microsoft Dynamics AX provide functionality to use the same number for some transactions and transactions voucher in accounts receivable and accounts payable modules as following:

AR Module

1- free text invoice with free text invoice voucher

2- Packing slip with Packing slip voucher

3- Customer invoice with Customer invoice voucher

4- Sales credit note with Sales credit note voucher

AP Module

1- Internal product receipt with Product receipt voucher

2- Internal invoice with Invoice voucher

3- Internal credit note with Credit note voucher

The following steps discus how to use this functionality with free text invoice and the free text invoice voucher.

Video | Import Customer accounts using DIF | AX 2012

Import Customers using Data Import framework | AX 2012 R3

This post illustrate how to import Customers basic information using the data import framework in Dynamics AX 2012 R3

Cash discount handling for over payments (Deep inside Dynamics AX 2012 Payment Settlement 3rd Scenario)

   Dynamics AX 2012 give you the ability to handling the customer overpayments through three different ways. 
AX will select the approach depending on the setup of the Cash discount administration and Maximum overpayment or underpayment fields in the Accounts receivable parameters from.

The following cases illustrate how different combinations of these two parameter will generate the three cases.

Case 1: The Cash discount administration value is Specific and the over payment amount is between 0.00 and the amount that is entered in the Maximum over payment or underpayment field. In this case the over payment amount will posted to a cash discount difference ledger account which specified in n the Account for automatic transactions form

Deep inside Dynamics AX 2012 Payment Settlement scenarios (2nd Scenario)

Microsoft Dynamics AX can select the transactions automatically by using the automatic settlement functionality. 
This topic describes how transactions are settled if you select the Automatic settlement check box in the Accounts receivable parameters form. 
You can also customize how automatic settlements are processed by using the Prioritize settlement check box, the Use priority for automatic settlements check box, and the Manage priority link. 

In this article we are going to illustrate how we can confugire Dynamics ax 2012 to Automatically settle customers invoices Using the following Methods:

1. Default automatic settlement
2. User-defined settlement priority

Deep inside Dynamics AX 2012 Payment Settlement scenarios (1st Scenario)

In this series I am going to illustrate 8 scenarios about how we can settle a customer payment with invoice in Dynamics AX 2012.

We will start with the basic scenario, then move on to more complex scenarios each time. the following list illustrate the roadmap for the series:

First Scenario: Settle a customer payment with an invoice.
Second Scenario: Automatic settlement and prioritization.
Third Scenario: Cash discount handling for over payments.
Fourth Scenario: Settle a partial customer payment and settle the final payment in full before the discount date.
Fifth Scenario: Settle a partial customer payment before the discount date with a final payment after the discount date.
Sixth Scenario: Settle a partial customer payment that has multiple discount periods.
Seventh Scenario: Use one customer payment to settle multiple invoices that span multiple discount periods.
Eighth Scenario: Settle a partial customer payment that has discounts on credit notes.

DIXF Part I:Export Customers to DAT File | Dynamics AX 2012

Purpose: The purpose of this article is to illustrate how to use Data import/export framework(DIXF) to export Customers Accounts to DAT File.

The DAT file used to transfer master data from Microsoft dynamics AX instance to another.


To Export the Customers Accounts please do the following steps :

AX 2012 Cash flow forecast Part I: Sales Cash flow forecast

Purpose: The purpose of this article is to illustrate how to use Cash flow forecast functionality for sales orders .

  Use the following procedures to work with Cash flow forecast:

1.     Click General ledger > Setup > Posting > Liquidity.

AX 2012: Customer Item Statistics

Purpose: The purpose of this article is to illustrate how to use Customer Item Statistics functionality to analysis revenue,Item Group and item Sales amount per customer.

Scenario:For a customers account  that you manage, it is very important to analysis the revenue,item and item group sales amount for a customer before decide to grant long payment terms,discount or bonus.

  Use the following procedures to work with Customer Item Statistics:

1. Go to Accounts receivable-->Common-->Customers-->All customers
   

Export Sales Order Data to MS Word template with Dynamics AX 2012 ( Document Management )

Often, the customer asked to modify the layout of the Standard reports to meet existing templates or tastes. and as we all know that changing the layout in the SSRS reports will take long time. Instead we can use one of the Dynamics AX functionality to export the customer data to MS Word Template in simple way and short time.  

The Document management functionality in Microsoft Dynamics AX give you the ability to attach files to records. For example, you can attach PDF, Microsoft Word, or Microsoft Excel files to a purchase order or a sales order. You can also create Word and Excel templates from Microsoft Dynamics AX data. 

This Article will discuss how to use MS Word templates rather than customize the standard SSRS reports in Dynamics AX 2012.

Payments in advance ( prepayment ) from a customer | AX 2012

This Article discuss Payments in advance ( prepayment ) from a customer. This article divided into three parts

• Introduction
• Setup (Step by step with screenshots )
• Implementation (Step by step with screenshots )

Introduction:                                                                           

Accounting practices in many countries/regions require that prepayment journal vouchers, or payments in advance, from a customer or to a vendor not be posted to the usual summary accounts for the customer or vendor. Instead, these prepayment journal vouchers must be posted to special ledger accounts for prepayment journal vouchers. When a sales order or purchase order is made, an invoice is issued to the customer or vendor. When the invoice is paid, the prepayment journal voucher and sales tax prepayment journal voucher on the ledger accounts for the prepayment journal vouchers are reversed. The invoice amounts are then automatically posted to the usual summary accounts.