Not each consultant knows about Sales Order Processing Quote advanced features, of the like kind as the possibility to reuse the name on the monthly, annually or another periodic base. We've seen numerous cases where customers need to subsist billed periodically with the old template, perchance with fractional price increase, but items stay the corresponding; of like kind. One of the popular ways of historical implementations was Integration Manager, that pulls into Great Plains customer invoices, exported from habit ecommerce or something simple like MS Access. Integration Manager is definitely a vigorous and flexible tool and it have power to do member dues billing annual collection import from external application. However today we would like to display you simple way of doing via repeating quotes in Sales Order Processing module:
1. General model. You have repeating quotes staying in the corresponding; of like kind batch over the years. When dues invoices got to have existence produced you transfer quotes to invoices adhering the batch level. If you like some creativity – you can program quote compensation update from your SQL Server, or originate integration in IM for update, at which place you pull each quote and cook price increase. Integration Manager is preferred in the manner that it validates business logic and you work not have to do professional given conditions repair in the case of SQL scripting learning curve
2. How to setup Quote writing type? In Sales settings for SOP Document Type against the Quote please allow transfer to Invoice and switch Default Quantities to Invoice. Plus eminence Allow Repeating Documents checkbox. Now you are prompt to type in or integrate quotes from outside text file or database via ODBC
3. In Sales Transaction Entry have existence sure to pick the document protoplast, which we discussed in previous paragraph. If you did it that habitual method, click on the arrow next to Document consist of, when quote is prepared. In Sales Document Detail Entry track Repeating checkbox, leave Times to Repeat to the degree that zero (in this case there is ~t one limitation on the number of what is yet to be repeats). In Transfer to Invoice detail Invoice Type ID and Batch. It is for ever a good idea to place the invoices, produced from repeating quotes into disunited batch for further printing, emailing and processing
4. Transfer quotes to invoices. There is ~t any magic there, simply pull batch and clink on Transfer button, mark Quotes to Invoices and contain totals. There is one popular inquiry about transfer to show zero documents transferred. Be doubtless that you have set Quote paper type to send quantities to Invoice. If it shows to Order, in consequence on Quote line quantity to regularity is set to get the digit and quantity to invoice is nothing (this is why invoices are not produced)
5. Initial Quotes mean or key-in dilemma. In of great size membership services outsourcing organization data change of heart is more feasible, versus manual access. Integration Manager does wonderful job by importing quote from text file or via Advanced ODBC data source from ODBC obliging databases: Oracle, MySQL, Pervasive SQL, MS Access to give you several popular names. If you be warmed that IM is lacking the functionality to brand quote as repeatable – then that could have existence done in GP macro, where eddish. document is opened and macro more remote opens details window and sets required fields in that place
6. Where the technology could have ~ing implemented? First of all definitely in the more than half of memberships, where dues are sent to existing customers and they bring forth an option to extend the being a member or drop off: museums, arboretums, propriety centers, national parks or park districts, nationwide professional institutions and associations, volunteering organizations. Secondly on the supposition that you have small number of mercantile customers with historical high ticket succession, you may decide to initiate the methodize in recurring quote. This options should suffer you to stick to negotiated value in the future orders
No comments:
Post a Comment