Shekhar: Dynamics AX,AX2009 – Credit remaining quantity

[Blog bot]

Источник: http://shekhardiptiman.spaces.live.c...B978!411.entry
==============

 

Here is a detail about a less talked about functionality in AX. There is very little information available on this feature in help documents or anywhere else online. Many of us would have worked on sales order or purchase order updates (postings). We may open order posting forms:

1. Accounts receivables

a.  Account receivables>Common forms>Sales order details>Posting button (on header) > Delivery note(Packing slip) or Tax invoice (Invoice)

b. Account receivables>Periodic>Sales updates>Delivery note(Packing slip) or Tax invoice (Invoice)



    2.   Accounts Payables

a.  Account payables>Common forms>Purchase order details>Posting button (on header) > Delivery note(Packing slip) or Tax invoice (Invoice)

b. Account payables>Periodic>Purchase updates>Delivery note(Packing slip) or Tax invoice (Invoice)



On the posting form there are two Tabs on top left corner of the form. The others tab is of interest for us . There is check box “Credit remaining quantity” which is our focus for this illustration.



This field is of significance when we post a negative quantity against a Sales line or purchase line. Consider a scenario for sales order:

A sales order is created with the Sales line quantity = 10 as shown in the following screen shot.



A delivery note is posted for the entire quantity in the sales order and sent the customer with the delivery note .



At this stage there may be following cases which may happen :

The consignment gets damaged (full / partial) in transit and customer refuses to accept the damaged goods . or for any other reason the customer does not accept the consignment (or it does not reach the destination) . The damaged goods are taken back [ they have to be :) ].In such cases we may like to do one of the following :

a.  A replacement is sent to the customer and the sales order is invoiced for the finally accepted ( received ) quantity by the customer.

b. No replacement is sent to the customer. The sales order is short closed for the not received (damaged) quantity by the customer. The customer is  invoiced for the quantity they have accepted (received) only.

We will see the use of “Credit remaining quantity” in implementing the above two solutions. Assume that Qty 4 got rejected and returned.

Case a.  A replacement is sent to the customer and the sales order is invoiced for the finally accepted ( received ) quantity by the customer.

Form name: SalesTable

1. Go to sales Line>Quantity tab> Deliver now field.

Change the value of deliver now from “ ” to “-4”

2. Sales Order header > Posting button >Packing slip (Delivery note)

Form name: Posting packing slip



3. Change Quantity from 'All' to 'Deliver now'.

4. Switch to the Other tab on the Posting packing slip form. Ensure that the check box “Credit remaining quantity” is marked.



5. Switch to the Lines tab on the Posting packing slip form.



Note that the Update field = “-4”

6. Click the OK button.

7. Click Ok in the Microsoft Dynamics form.

8. Form name: SalesTable . Go to the Sales lines> Quantity tab



The “Delivered” quantity is changed from “10” to “6” and the “Deliver remainder” quantity is updated with “4” i.e for sending the replacement.

9. The replacement delivery is sent to the customer by posting another Packing slip (Delivery note).



The sales line>Quantity tab has the Delivered quantity = 10 and invoice remainder = 10



Now this sales order will be invoiced updated for the Packing slip (delivery note) quantity and all the parties ( buyer and seller) involved are happy .

 

Case b. No replacement is sent to the customer. The sales order is short closed for the not received (damaged) quantity by the customer. The customer is  invoiced for the quantity they have accepted (received) only.









 

The solution is similar to the above . Perform the steps 1-7 above except that in step #4. Switch to the Other tab on the Posting packing slip form. Ensure that the check box “Credit remaining quantity” is NOT marked.



Then as for step 8 if we verify the results in sales order.Go to the Sales lines> Quantity tab

The “Delivered” quantity is changed from “10” to “6” and the “Deliver remainder” quantity is updated with “ ” i.e No replacement delivery is required.





Now this sales order will be invoiced updated for the Packing slip (delivery note) quantity and all the parties (buyer and seller) involved are happy .

 

The above solution can also be used while posting the Sales invoice and doing a sales return in exactly the similar way. The difference will be that we would be posting Sales invoices instead of Packing slips (Delivery note). I will leave this on the readers to try this themselves and ask me for help if they stumble.

The above scenario also works in case of Purchase orders for scenarios of posting the vendor returns and then posting the purchase invoice with the accepted/received quantity.















Источник: http://shekhardiptiman.spaces.live.c...B978!411.entry