Thursday, 17 September 2015

Auto charges for sales order in Microsoft dynamics AX 2012 R3

Hello Readers,
Hope !! you are all well :-)

After a gap of almost three months, here I am ready to post the new topic of AX.

I hope you will find this post interesting.

In this topic, I will walk you through the setup of automatic charges in AX 2012 and its use.

Before you read the below post, if you would like to know about what is meant by charges and their importance in business. Please refer: Sales order Charges

Auto charges are used to define the automatic charges for the customers, vendors, items and for the mode of delivery as well.

These charges are applied automatically when you create sales order or purchase order.

There are few setups which needs to be done in the auto charges form in order to get these charges in the sales order or purchase order.

You can define the Automatic charges for :
                                                        1. Single customer, vendor , Item and mode of delivery
                                                        2, Group of customers, vendors , Items and mode of deliveries
                                                        3. All customers, vendors , Items and mode of deliveries

Note: Point to be noted here is that mode of delivery charges can only be define when defining the auto charges for the sale order.

Path:

a. Account receivable Setup  Charges  Auto charges

b. Retail  Setup  Charges  Auto charges

Steps to setup Auto charges

1. Go to above path and click on Auto changes
2. Select level to apply auto charges in the sales order.
    a. Main: Select main to apply charges at order header
    b. Line: Select line to apply charges at order lines.


3. Click on New to define a new auto charge.

4. Select Account code :
    a. Table: define charges for a specific customer.
        - Customer relation: if you select Table in account code then select a customer account to define the charges.

    b. Group: define charges for specific customer charge group
        - Customer relation: if you select Group in account code then select customer charge group code to define the charges.

    c. All: define charges for all the customers
       - Customer relation: if you select All in account code then customer relation field gets disabled as you don't have to specify anything as charges applies to all the customer.

5. Select Item code:
    If level "Main" is selected then item code is by default selected as All & item relation field is disabled as charges then applied to sales order header level.

   If level "Line" is selected then you can select the specific item code among Table, Group and All.

    a. Table: define charges for specific item.
       - Item relation:if you select Table in Item code then select item number to define the charges for.

    b. Group: define charges for item charge group
       - Item relation:if you select Group in the Item code then select item charge group to define the charges for.

    c. All: define charges for all items.
      - Item relation:if you select All in Item code then item relation field is disabled as charges are applied to all the items.


6. Select Mode of delivery code
    a.Table: define charges for a specific mode of delivery.
       - Mode of delivery relation: if you select Table in mode of delivery code then select a mode of delivery to define the charges for.

    b. Group: Define charges for delivery charges group
      - Mode of delivery relation: if you select Group in mode of delivery code then select a specific delivery charge group to define the charges for.

    c. All: Define charges for all the mode of delivery
       -Mode of delivery relation: if you select All in mode of delivery code then mode of delivery relation field is disabled as charges are applied to all mode of deliveries.


7. Now expand the Lines fast tab to add charges and other details for the auto charges.

8. Select Currency so that the charges will get calculated in that currency.

9. Charge code: select specific charge code from the drop down menu.

 Note: Charge code needs to be defined before defining the Auto charge. To know more about creating the charge code refer Sales order charges

10. Category: specify the category to define how to calculate the charges. Categories are of the following:
      a. Fixed
      b. Percent
      c. Pcs.
      d. Inter company percentage
      e. External

11. Charge value: enter the value based on the category define for the charge.

12. Charge currency code: select currency for the charge. It is different from the one specified in the currency field. Charge value will get define in this currency but the charge will get calculated in the currency defined above.

13: From amount and To amount : enter the starting and ending amount in these fields to apply auto charges. This is optional.

14: Sales tax group: specify the sales tax group to calculate the tax for the charge amount. This is optional.

15: Keep: It keeps the charge transactions after invoicing so that charge is applied every time we post the invoice for the specific customer account.


16. Once we set all the necessary information in the auto charge form, create sales order in AX.


17. If the sales order meets the criteria specified for the Auto charge, the charge will get calculated automatically for the sales order.

To view the charges:
 
Go to Sales order → Sell fast tab → Click on Charges 


18: we can also see the total charges calculated for the order.

In this way, you can setup automatic charges for the sales order in ax 2012 R3.

See you soon with the new topic. Keep Daxing :-)

"Knowledge has no value unless you use and share it."


------------------------------------------------------------------------------------------------------------------------------------
Abhijeet Hele |  Dynamics AX Enthusiast | My Profile 

The information provided on this site represents my own opinion/view and does not represent the opinion/view of my employer or Microsoft.

Sunday, 21 June 2015

Purchase order charges in AX 2012 R3

Hello Friends,
Today in this topic, I will explain the allocation of the charges to the purchase order in AX 2012 R3.

To know more about charges refer: Setting up charges for sales order in AX 2013 R3.

In my last post, I have explained the setting up of the charges in the sales order. Please refer above link for the same.

Maintain charges:

1. First step is to create charges codes which will use to maintain charges for the purchase order.
2. To know about setting up the charge code, refer: Setup charge code.
3. Once the charge codes have been created in AX 2012 R3, next step is to set it up against the purchase order.

Steps to setup charges in purchase order:
1. For header level charges, Go to purchase order --> on the action pane, on the purchase tab, in the charges group, click on maintain charges.

OR

1. For line level charges, go to purchase order --> Purchase order lines --> Select particular purchase order lines --> Click on Financials --> under charges --> Click on maintain charges

2. Select charge code which we have created.
3. Select the category. (It can be fixed, percentage or inter-company percentage etc.)
4. Select the charges value. (In case of Fixed, enter the amount of charges / In case of percentage, enter the percentage for charges)
5. You can assigned sales tax group and item sales tax group if you want sales tax to get calculated for the charges.

6. Once the charges are setup against the purchase order, click on Total to see the charges.



















Allocate charges

1. It is used to allocate charges to purchase order lines by selecting various parameter in the Allocate charges form.

2. Go to purchase order --> on the action pane, on the purchase tab, in the charges group, click on Allocate charges.




















3. Charges allocation: It can be
          Net amount: Charges are allocated based on the each line amount relative to total net amount for the purchase order or invoice.

          Quantity: Charges are allocated based on the number of units for each line relative to total number of units for the  purchase order / invoice.

           Per line: charges are allocated equally among the total number of lines. For example: if the charge value is 500 and there are 5 lines in the purchase order then amount 100 will get distributed amount 5 lines in the purchase order.

4. Allocate charges to lines
         All lines: It will allocate charges to all the lines on the purchase order.
         Positive lines: It will allocate charges only to lines with positive amount.
         Negative lines: It will allocate charges only to lines with negative amount. For example: If we want charges to get incurred while returning goods to the vendor then we can select this option.

5. Allocate all
It will allocate charge to PO lines even if charge code has debit type other than Item.

6. Received
In this charges are allocated to the lines based on the quantity that has been received for each line.

7. Stocked
It is for the stocked items. Charges will get allocated only to stocked order lines.

8. Show selection and clear specific lines:

   a. This check box only enables if charges have been setup in the order.




















  b. Ticked show selections and clear specific lines check box.

  c. Based on the criteria selected in the Allocate charges to lines and stocked fields, it will show the liens in the grid.
  d. For example: if the criteria selected is Positive lines and stocked then system only show positive stocked lines.





















  e. Clear the Include check box to exclude the lines from allocation of charges.

  f. Click on Allocate to allocate charges to the selected lines.

  g. Once the charges have been allocated, go to purchase order --> on the action pane, on the purchase tab, in the charges group, click on Maintain charges.












  h. You can see empty form as charges have already been allocated between the lines in the order.

  i. Go to Purchase order Total --> you can see amount of charges allocated in the order.



















Please note the following:

  • You can also allocate charges at the time of invoicing the purchase order.
  • Charges can also be allocated after the purchase order invoice gets posted.

Hope!! This post gives you more insight about setup and allocation of charges for the purchase order in AX 2012 R3.

Please post if any queries or suggestions to be made pertaining to this topic.

In the next topic, I will explain the Automatic charges in AX 2012 R3.

Keep Daxing :-)

"Knowledge has no value unless you use and share it."


------------------------------------------------------------------------------------------------------------------------------------
Abhijeet Hele |  Dynamics AX Enthusiast | My Profile 
The information provided on this site represents my own opinion/view and does not represent the opinion/view of my employer or Microsoft.



Sunday, 26 April 2015

Sales order charges in AX 2012 R3

Hello friends, Just to give you hint about what is going to be there in today's topic. Today I will explain the sales order charges and their setup in AX.

But before I start, let me give you brief about what is meant by charges?

It is an amount of money paid against the service rendered or goods supplied. Charges can be of different type, such as freight charges, Shipping & Handling charges, Installation charges, Broker fees, Fuel surcharge and other miscellaneous charges.

Charges can be paid by the customer or can be paid to the vendor or to the third party depending on the type of service rendered. Sometimes company bares the charges instead of customer. Also sometimes charge amount is included directly in the item cost.

In AX 2012 R3, we can setup different type of charges which are applicable to the business while carrying out operations.

Before we apply any charges to the particular order in AX , we need to setup it up first and then we can apply them in the order,

A. Setup charges code in Account receivable:

1. Go to Account receivable > Setup > Charges > Charges code.
2. To setup new charges, click on New.
3. Enter charge code ( Lets say, Freight).
4. Enter description ( Lets say, Freight charges).
5. Item sales tax group : Select the item sales tax group in order for the sales tax to get applicable on charges.
6. Prorate: if this is ticked then the charges will be prorate across the invoices. it is only applicable in customer charges.
7. In the posting tab, select the appropriate debit and credit account for proper posting of the charges.
8. If the customer is paying the charges then charges should be added in the sales order total so you can do the following setup:
   a. In Debit field group, in the Type field, select Customer/ Vendor in order to add the charges to the customer account.
   b. In Credit field group, in the Type field, select Ledger account, then in the Posting field select appropriate posting type. In the Account field, select the main account to track the charges which are applicable to the customer.


B. Setting up charges in the Sales order
1. Create Sales order and add lines in it.
2. Go to Sell tab > click on Charges.
3. Select charge code which was created earlier from the drop-down list.
4. Select the category. It can be Fixed (for fixed amount charges for the order) or Percentage (it will calculate the percentage of total net amount in the order). Category also can be inter company percentage, external or pcs.
5. Enter the charge value. If the category is Fixed then enter the total amount of charges for the order. If the category is Percentage then enter the percentage value which are applicable for the order.
6. Description will get populated from the charge code.
7. Currency will get populated automatically from the sales order.
8. Sales tax:
     Sales tax group : It will populate directly from the sales order.
     Item sales tax group: It will populate directly from the charge code setup.
9. Ledger : the ledger information will get populated after the posting of the charges in the ledger i.e. after the sales order invoice posting.
10. Intercompany: Information will get populated during intercompany transactions.


12. Once all the setup is completed, save and close the form

13. Go to sales order > Click on Total > You can see the applicable charges against the invoice total amount.


14. Process the order till invoice.
15. Click on charges > to see the setup and for the ledger information.

16. Go to voucher > you can see charges posted in the ledger.

In this way, we can setup and apply charges for the sales order in AX 2012 R3.

In the next topic, I will walk you through the setting up of charges for the purchase order in AX.

Happy Daxing :-)

------------------------------------------------------------------------------------------------------------------------------------
Abhijeet Hele |  Dynamics AX Enthusiast | My Profile 
The information provided on this site represents my own opinion/view and does not represent the opinion/view of my employer or Microsoft.



Sunday, 22 March 2015

Sales order types in AX 2012

In this topic, we will see various sales order types present in AX 2012. When you create a sales order in AX 2012, you must select type of order that it is. You can select one of the type from the following:

1. Journal
2. Subscription
3. Sales order

Following Sales order types cannot be selected manually and they are created through return management or through the project management and accounting module.

4. Returned order
5. Item requirement


Default setting for sales order type:
You can setup a default value for the sales order type in AX so that when you create a new sales order, system would automatically take that default value in the new order.

Path:
Account receivable parameter -->General --> Sales --> Default values --> Order type



Sales order types

1. Journal: It is use as "Draft". When you want to create a order but do not want to process it then you can assign order type as "Journal".  All the postings (Confirmation, Picking list, packing slip, invoice) are disabled in this case and can be enabled after changing the order type from journal to Sales order /Subscription. As we cannot process the order, it doesn't impact the inventory stock and does not generate any inventory transactions. 

















2. Subscription: It is use for recurring orders. It is used when it is require to sell same item/service to the same customer repeatedly over a period of time. In this case, when the sales order is invoiced, the order status again set to Open order.

In the subscription sales order, order status can never be invoiced and can only be open or delivered.

Transactions are recorded in the system after every packing slip and invoice postings.

































3. Sales order: It is a normal order created when customer actually place the order for goods. It can be processed from creation to invoiced. After posting the invoice for the order (Full delivery), status of the order changes to "Invoiced". Order once invoiced cannot be use again and we cannot make any changes in it.































4. Returned order: It is created when customer returns the goods which are sold due to some specific reason ( Like damage goods, Late delivery etc.).

For more details, Refer: Return order in AX 2012

5. Item requirement: It will get created automatically when you make a sale of items through project module. Picking list, Picking list registration and packing slip will get posted through project module only.

Path: Project management and accounting --> Common --> Item tasks --> Item requirements












a. Click on New to create new line in the item requirement form.
b. Select Project ID of the project for which these items are required.
c. Select item number, site, warehouse, quantity and other details.
d. Once all the details are entered, click on Inquiries -->Sales order












e. You can see sales order is created with the order type as "Item Requirement".










Note: All the items pertaining to same project will come in the single sales order.

f. Click on posting to post the Picking list, Picking list registration and Packing slip for the sales order.











Note: In this case, we cannot perform the posting through sales order and it can only happens through project management and accounting module.


Hope!! Everyone would get clear understanding of Sales order types in AX 2012


Please post if any queries and do let me know if any suggestions for improvement.



See you soon with the new topic :-)



------------------------------------------------------------------------------------------------------------------------------------
Abhijeet Hele |  Dynamics AX Enthusiast | My Profile 
The information provided on this site represents my own opinion/view and does not represent the opinion/view of my employer or Microsoft.

Sunday, 22 February 2015

Inventory Counting Journal in AX 2012 R3

Inventory counting journal is used to adjust the item's on hand inventory as per the actual physical stock available in the warehouse.
It displays current On-hand quantity available in the system for the particular item and lets you enter the actual physical count for the same item in the journal's Counted field.

Based on the actual physical stock available in the warehouse and the On-hand inventory recorded in the system, system makes the necessary adjustment to reconcile their difference.

If the On-hand inventory is more than the actual physical inventory, inventory issue and inventory loss accounts get updated with the inventory cost as the system considers it as "Sold" transactions.

If the On-hand inventory is less than actual physical inventory, inventory receipt and inventory profit accounts get updated with the inventory cost as the system considers it as "Purchased" transaction.

Process to created and post inventory counting journal

1. Go to Inventory management --> Journals --> Item counting --> Counting















2. Click on New / Press Ctrl+N --> New dimension form will open with only storage and tracking dimension enabled. (Product dimensions are disabled in this form).

3. Based on the storage and tracking dimensions combination selected over here, AX provides On-hand inventory count in the journal for the particular item.

For example:
If warehouse is not selected as a default dimension then in the journal, as soon as we select dimension "Site", system displays On-hand quantity of the item before even selecting the warehouse.

If warehouse and other dimensions are selected then AX displays On-hand quantity, once those combinations are selected for the item in the journal.

4. Click OK.











5. Select Journal name for which you are running the counting.
6. Journal number will come automatically as the number sequence is mandatory to set to "continuous".
7. Description will come from journal names form but can be editable.

Note: You can also click on "Create new" to create new journal and go to journal lines automatically.

8. Click on Lines to go to Journal lines.













9. Click on New / Press Ctrl + N to create new line to add item.

10. There are another ways for creating lines in the counting journal. Click on Create and select one out of three methods for creating lines in the journal.













11. Here based on the requirement, Select appropriate method to add lines in the journal.










A. On Hand
a. Click on Create --> On hand --> Form will open for selecting appropriate criteria to filter the On-hand inventory items in the counting journal lines.





















b. Click OK --> Based on the criteria selected, system filters the items having On-hand inventory available in the system.









B. Items
a. Click on Create --> Items --> Form will open for selecting the criteria to get the items in the counting journal lines. The items displayed over here are irrespective of its availability in the inventory.















b. Click OK --> Based on the criteria selected, system filters the items in the counting journal. Items with On-hand and without On-hand will display in the journal.









C. Expired batches
a. Go to Create --> Expired batches --> Form will open for selection of specific criteria for filtering the item. Expiration date needs to be given so that batches fall within expiration date range will appear in the journal.





















b. Click Ok --> It lists all the expired items in the journal as per the criteria selected.









12. Once items come in the counting journal lines with their On-hand inventory, Add actual physical count of those particular items in the "Counted" field.









13. Difference between On-hand quantity in the system and the actual physical counted quantity is calculated automatically and appears in the quantity field.









14. Worker who has counted the particular item stored at specific location, can be assigned at the journal line level against that item. It helps to know who is responsible for counting particular set of item and can be used for future reference purpose. This field is optional can be skip.









15. We can add additional lines in the journal as per the requirement.

Validate
16. Click on Validate to check if all mandatory fields are entered.






















17. Click on Post button to post the counting journal to adjust the On-hand quantity as per the actual physical quantity.






















Please post if any queries or suggestions to made regarding this topic !!!

Happy Daxing.

------------------------------------------------------------------------------------------------------------------------------------
Abhijeet Hele |  Dynamics AX Enthusiast | My Profile 
The information provided on this site represents my own opinion/view and does not represent the opinion/view of my employer or Microsoft.

Sunday, 8 February 2015

Inventory Transaction statuses for Purchase order in AX 2012

In the last post, we had seen "Sales order inventory transaction statuses" in AX. In continuation to that, in this post, we will see how the inventory transaction status updates during purchase order cycle in AX 2012.

As it is a purchase order, the Receipt field in the inventory transaction form will get updated with various statuses of inventory.

Receipt statuses are as follows:
a. Quotation receipt
b. Ordered
c. Registered
d. Arrived
e. Received
f. Purchased

Path to view the inventory transaction status


a. Go to Procurement and sourcing / Account Payable --> Common--> Purchase orders --> All Purchase orders --> Select desired purchase order -->Edit  --> Select desired line --> Click on Inventory -->Transactions.













b. Go to Product information management -->Common --> Released products --> Select desired product --> On the action pane, go to Manage inventory tab --> In the view group, click on Transactions.








Inventory (Receipt) transaction status 


1. Quotation receipt: When the request for quotation is sent to vendor and in return quotation is received from vendor, the receipt status goes to  "Quotation receipt" state.



















Go to Inventory --> Transactions








2. Ordered: When purchase order is created for items which are not available/ less available in the inventory. the inventory transaction status changes to "Ordered".











 Go to Inventory --> Transactions







Note: 

Purchase order confirmation
After the Purchase order confirmation, the inventory transaction status remains same as purchase order confirmation doesn't affect the inventory by any means.
After the purchase order confirmation, the status will remain "Ordered".

Receipt list
After the purchase order receipt list, the inventory transaction status will remain "Ordered".  The purchase order receipt list will not affect the inventory and only provides the list to verify the quantity that is expected to receive against the quantity that is received.

3. Registered: When items are registred in the inventory, the  inventory transaction status changes to "Registered".

a. Go to purchase order --> Select desired line --> Click on Update line --> Registration














b. Click on Auto-create --> Post all.










c. Go to Purchase order line-->  Click on Inventory --> Transactions







d. You can see above, the inventory transactions status changes to "Registered".



4. Received: When the purchase order is updated on a product receipt i.e. when items are received, the inventory transactions status for the item goes to "Received" state.












Go to Purchase order line --> Click on Inventory --> Transactions to view the status.







5. Purchased: Once the vendor sends the invoice and we sign it as a mark of acceptance and guarantee of payment for delivered items, we post the Purchase order invoice in AX. 


When invoice is posted for the purchase order, the inventory transactions status changes to "Purchased".











Go to Purchase order line --> Click on Inventory --> Transactions to view the status.






In this way, Inventory (Receipt) transactions status updates while processing the purchase order in AX 2012.


Please do let me know if any queries or suggestions to be made pertaining to this topic.

Happy Daxing :-)

------------------------------------------------------------------------------------------------------------------------------------
Abhijeet Hele |  Dynamics AX Enthusiast | My Profile 

The information provided on this site represents my own opinion/view and does not represent the opinion/view of my employer or Microsoft.