Customization DS0978
Miscellaneous Charge Detail
Problem Definition:
ACME is one of the world’s largest manufacturers of quality canoe, kayak, and stand-up paddles. They conduct both direct to consumer sales, and sales to resellers/distributors. The B-to-C line is handled through a web-store which integrates into Dynamics GP. The B-to-B line has some additional requirements that are not well addressed by GP.
The B-to-B line sometimes needs to record several “additional charges”, such as delivery fees or other processing fees. These cannot be added as additional lines on the transaction because they would be included in the Commissions Calculation and in the Payment Terms calculation.
The additional charges also need to post to separate GL accounts, and print on the sales documents (both open and historical).
Solution Overview:
WilloWare will add to Sales Transaction Entry the ability to record a list of additional charges. These charges will be an extension of the Miscellaneous Charges field in a new window called Misc Charge Detail.
When a Sale Invoice is posted, the enhancement will post a separate Journal Entry that reverses the credit to the Misc. Charges account, and instead posts a “detailed” miscellaneous charges transaction based on the Misc Charge Detail entries.
Design Features:
Misc. Charge Setup
Navigation: Tools >> Setup >> Sales >> Misc Charge Setup
Misc Charge Setup is used to record the Items that will be available in Sales Transaction Entry in the Misc Charge Detail window. The Item Numbers entered here must be Item Type = Misc Charges. No other Item Types will be allowed.
|
Field |
Function |
|
Item Number |
Enter a Misc Charge Item Number, or select an Item Number from the Lookup. Only Item Type = Misc Charge Items will be allowed. |
|
Cost |
Displays the Item’s Current Cost |
The window will also check that each Item has a GL Account entered in the Inventory Account field on the Item Accounts window. If the Item is missing an account, the user will be warned and not allowed to continue with the Item.
Misc Charge Detail Entry
The Misc Charge Expansion button will open both the Sales Tax Schedule Entry and the new Misc Charge Detail windows.
|
Field |
Function |
|
Item Number |
Enter a Misc Charge Item Number or select one from the Lookup. The window will only allow Accept Misc Charge Items from Setup. The Lookup will only show the Misc Charge Items from Setup. |
|
Description |
The Description defaults to the Item Description from Item Maintenance, but it can be changed in this window. The changes do not affect the actual Item Description, but are saved with the Misc Charge Detail. |
|
Cost |
Defaults to the Current Cost from Item Maintenance, but it can be changed on this window. |
The same Misc Charge Item Number can be entered multiple times, if needed. As shown above, there are two “shipping” lines.
Saving the Misc Charges will update the Total Misc Charge on the Sales Transaction Entry window, and if applicable, recalculate taxes.
When Misc Charge Details have been entered, the Miscellaneous field will be locked (not editable), and the background color will be yellow.
If the Misc Charge details are NOT entered, the user will still have the ability to enter a Misc Charge directly into the field.
SOP Transfers & Posting
When a Sales Document is transferred, the Misc Charge Details will come along with the transfer to the new document. The Misc Charge Details can be edited as needed on the new document.
When a Sales Invoice is posted, the normal SOP Posting logic will occur, which is to CREDIT the Miscellaneous Fees account from Sales Posting Account Setup for the total amount in the Miscellaneous field.
The enhancement will then create and post a second Journal Entry which DEBITS the Misc. Fees account, and CREDITS the Inventory Account associated with each of the Misc Charge Items listed in the Misc Charge Detail Entry window.
The Batch ID will be upper case User ID and the date (YYYYMMDD).
The Reference will be “SOP Misc Charge Detail”.
The Distribution Reference on each line will contain the SOP Number (i.e. STDINV2277)
The enhancement will also work for Returns. If Misc Charge Details are entered, the Debit and Credit are reversed from Invoice posting. For example, posting the Return DEBITS the Misc Fees Account, so the enhancement will Credit that account, and Debit each of the Misc Fee Inventory Accounts.
It is assumed that users will not manually change the SOP Distributions to create multiple entries for the Type = MISC distribution. Prior to creating the Misc Charge Detail Journal Entry, the enhancement will check that the amount posted to the Misc Fees account matches the Total in Misc Charge Detail Entry, and if not, it will NOT create the adjusting journal entry.
The Journal Entry Number will be recorded in the SOP Misc Charge Details table for reporting purposes.
Printing
When a SOP Form is printed, the Misc Charge Details will print in the body of the report as shown below:
NOTE: This example uses the Word Template because it was easy to mock-up the desired output. ACME uses GP reports and Liaison to email the documents.
For information on this design, or any other WilloWare customization or product, please contact us: