All Kinds of Model Trains Equipment

Great Plains Consultant Notes: Sales Tax Calculation and Reporting in Dynamics GP

If you are upgrading your corporate ERP and accounting application to Microsoft Dynamics GP, former Great Plains Dynamics, you should expect some additional flexibility in your Sales reporting.  State Sales Tax reporting is typical candidate to learn new functionality and make probing calculations.  In this small publication, which is intended to end Dynamics GP user, not GP consultant, we would like to give you some technical highlights:

1.       Inventory items and Sales Tax accruing.  You have several options for Sales Tax calculation: non-taxable (such as something that is in essence the service: Freight, Insurance, Bank Wire Transfer charges), in this case select Not Taxable in Inventory Item Maintenance screen on the left side (from Sales perspective).  And now the majority of your physical items, such as merchandize should be marked as Based On Customer

2.       Invoice Subtotal and Total Taxable Sale Amount.  Here you need to understand nuances – in your monthly Sales Tax report (Reports->Company->Taxes) – only Total Taxable Sale Amount is summarized in it.  If some GP inventory items are taxable and others are not, then two amounts (Total Sales, and Total Taxable Sales) will deviate.  This means, that you cannot use AR transactions register for the month to reconcile your sales tax amounts

3.       Sales Tax under the hood.  We recommend you to review Sales Tax in the following tables: RM20101 – posted AR transactions, RM10601 – RM Tax Work file.  Receivable Management module is closer to Dynamics GP General Ledger, comparing to Sales Order Processing tables: SOP30200 and SOP10105 (SOP Tax Work and History table).  The nuances typically are related to the fact of voiding Sales Invoices in RM module, if you voiding this way, SOP posted invoices (SOP30200 and SOP30300 tables) will remain non-voided

4.       Sales Tax for large corporate ERP, when you have to pay State Sales Tax in multiple US states.  In this scenario you typically are calculating Sales Tax based on Ship to Zip code.  There are multiple Dynamics GP ISV partners with their Great Plains Add-ons to consider, Avalara for example

5.       Sales Register report.  In Crystal reports, we recommend Sales Register report for those of you who has tax incentives from the State, give us a call on details

About the Author

Andrew Karasev, Alba Spectrum. http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577. Web portal: http://www.pegasplanet.com We are Microsoft Dynamics GP technology partner, ERP and software integrator, who serves you USA, Canada, Mexico and Latin America nationwide. Local service is available in Chicago, San Diego, Los Angeles, Houston. We have customer in the following business metros: Phoenix, New York, Boston, Milwaukee, Buffalo, Rhino, San Jose, Miami, Atlanta, Minneapolis, San Francisco, Detroit, Montreal, Las Vegas, Oceania, Colombia, Caribbean, Poland, UK, New Zealand, Australia

Non Dynamic

US Auctions Australian Auctions Austrian Auctions Belgian Auctions Canadian Auctions French Auctions German Auctions Indian Auctions Irish Auctions Italian Auctions Dutch Auctions Polish Auctions Spanish Auctions Swiss Auctions UK Auctions

Best Match Time: ending soonest Time: newly listed Price: lowest first Price: highest first Price + Shipping: lowest first Price + Shipping: highest first

N GP40 2 NON DYNAMIC COMPLETE Body Shell Assembly Undecorated ATLAS N Scale    US $15.90

N GP7 Phase 1 COMPLETE Body Shell Assembly Undecorate NON DYNAMIC ATLAS N Scale    US $14.99

N SD7 NON DYNAMIC Body Shell Assembly Undecorated ATLAS CHINA VERSION N    US $14.95

N GP40 NON DYNAMIC BRAKE Body Shell Assembly Undecorated ATLAS N SCALE    US $14.95

N SD9 NON DYNAMIC Body Shell Assembly Undecorated ATLAS CHINA VERSION N    US $14.90

N SD7 COMPLETE Body Shell Assembly NON DYNAMIC ATLAS N Scale KATO JAPAN VERSION    US $12.95

N C420 BODY SHELL PARTS NON DYNAMIC ATLAS N Scale    US $9.95

N 2 C420 UNDECORATED NON DYNAMIC BODIES ATLAS N SCALE    US $6.29

N SD7 BODY SHELL NON DYNAMIC ATLAS N    US $3.99

N GP40 NON DYNAMIC HOOD AND NOSE ATLAS N SCALE    US $3.79

N SD9 NON DYNAMIC BODY ATLAS N SCALE    US $2.99

Thanx papa bear, it's a hard world, but some of us out there take a "lean wit it, rock wit it" attitude..lol most importantly don't forget who you are and change for no one!