SOP: Auto-apply Return to Copied Invoice
A common scenario with Dynamics GP is to ‘void’ a Sales Invoice by creating a Return and applying the Return to the Invoice in Apply Sales Documents. The Copy function is used to copy the original Invoice to create the Return.
The Auto-apply Return to Copied Invoice Tweak will automatically apply the Return, when it is posted, to the Invoice.
Setup
Navigation: Tools >> Setup >> Company >> Setup GP PowerPack
Mark the box next to TWK-SOP: Auto-apply Return to Copied Invoice*
This Tweak has additional setup. Double-click on “Auto-apply Return to Copied Invoice*” to open the Tweaks Setup window. Locate the SOP: Auto-Apply Return to Copied Invoice section:
The Dates on the Return Document can be changed to match the Invoice, or left as-is using the default GP date. Changing the Dates on the Return can be useful if your posting setup uses Posting Date From Batch (see Tools >> Setup >> Posting >> Posting). Save the Return Date setting.
Click DONE on the GP PowerPack Setup window.
The feature will be enabled for the current user. Other users must restart their Dynamics GP client to enable this feature.
Using Auto-apply Return to Copied Invoice
The Tweak only works when applying a Return to an Invoice.
Fill in the ‘header’ fields on the Sales Return.
Select Actions >> Copy
Select the Invoice to copy from. To have the Return applied to the Invoice, the Customer ID must be the same on both documents. Click the COPY button.
You will be asked if you want to apply the Return to the Invoice. If you answer NO, posting the Return will have no effect on the Invoice. If you answer YES, when the Return is posted it will be applied to the Invoice.
As shown above, when the Return is posted, it is applied to the Invoice from which it was copied.
For the Auto-Apply to work, the Invoice must have an Amount Remaining equal to, or greater than the Document Amount on the Return. The typical usage for this Tweak is ‘voiding’ a Sales Invoice, so the entire Invoice is copied to the Return and no payments have been applied to the Invoice. However, you could also return only some lines, thus creating a partial return, and apply that amount to the Invoice.
You should NOT copy more than once Invoice to the Return. Nothing will prevent this from happening, however the Tweak tracks only the last invoice copied to the return, so the Return document will be applied to the last invoice selected.
When an Invoice is copied to a Return, the Invoice will appear in the Originating Document in Sales Document Detail Inquiry Zoom.
