Meta tags:
description=In this training lesson we have done the following: 1. Set up sales tax. 2. Set up commission. 3. Post an invoice. 4. Analyze results of invoice posting process (invoice document, inventory transactions, and general ledger transactions).;
author=admin;
keywords=commission,sales tax,post an invoice,axapta training,trade and logistics training;

Headings (most frequently used words):

ax, training, post, an, invoice, dynamics, agenda, introduction, how, to, sales, taxes, commissions, summary, trade, and, logistics, 11, comments, advertorial, facebook, page, blogroll, links,

Text of the page (most frequently used words):
the (401), sales (236), tax (110), commission (84), form (81), group (80), and (75), #invoice (65), account (58), that (56), this (51), ledger (50), item (48), general (47), order (46), field (45), for (44), amount (43), posting (39), set (35), transactions (34), customer (32), setup (31), are (29), charges (29), code (28), training (24), can (24), accounts (23), manager (23), must (22), dynamics (20), under (20), button (20), find (20), microsoft (19), tab (19), contains (19), line (18), you (18), create (18), inventory (18), from (17), will (17), groups (17), all (16), post (16), our (16), employee (16), vendor (15), opens (15), when (14), used (14), see (14), process (13), let (13), receive (13), belongs (13), click (13), team (12), total (12), paid (12), carrier (12), check (12), 400 (12), codes (12), management (11), misc (11), included (11), document (11), because (11), recorded (11), items (11), receivable (11), select (11), not (10), how (10), during (10), fill (10), says (9), following (9), into (9), have (9), lesson (9), only (9), sold (9), authority (9), taxes (9), calculation (9), new (9), rep (9), user (9), common (9), forms (9), av_cast (9), about (8), technical (8), these (8), 2010 (8), company (8), currency (8), system (8), packing (8), slip (8), trade (8), purchase (8), menu (8), cost (8), bottle (8), track (8), record (8), 940 (8), yer (7), logistics (7), information (7), money (7), 535 (7), data (7), california (7), dax (6), thanks (6), understand (6), charge (6), applied (6), each (6), commissions (6), area (6), amounts (6), voucher (6), taken (6), already (6), demo (6), profile (6), lines (6), assume (6), details (6), lot (5), value (5), business (5), per (5), same (5), created (5), transaction (5), remember (5), 105 (5), journal (5), 7210 (5), posted (5), appropriate (5), basic (5), period (5), settlement (5), warehouse (4), finance (4), need (4), thank (4), usd (4), what (4), table (4), status (4), delivery (4), analyze (4), generated (4), but (4), case (4), also (4), price (4), revenue (4), 140 (4), 875 (4), customers (4), natural (4), juice (4), one (4), printed (4), fuel (4), surcharge (4), box (4), calculated (4), make (4), now (4), with (4), date (4), managers (4), relation (4), open (4), relations (4), users (4), steps (4), different (4), 2009 (3), help (3), very (3), 100 (3), default (3), secondary (3), difference (3), work (3), returns (3), print (3), types (3), store (3), last (3), results (3), summary (3), header (3), sum (3), fields (3), goods (3), 1000 (3), previous (3), issue (3), 211500 (3), 602140 (3), net (3), located (3), 403500 (3), core (3), handling (3), ancillary (3), 220110 (3), parameters (3), before (3), 270 (3), follows (3), sure (3), other (3), want (3), close (3), percent (3), invoicing (3), sale (3), administration (3), don (3), authorities (3), increased (3), download (3), pdf (3), concepts (3), denis (2), library (2), product (2), facebook (2), search (2), october (2), 2012 (2), example (2), 150 (2), pays (2), cash (2), discount (2), there (2), excluded (2), january (2), much (2), problem (2), every (2), time (2), calculating (2), converting (2), best (2), nasser (2), july (2), really (2), materials (2), pingback (2), words (2), module (2), areas (2), transfer (2), orders (2), quality (2), quarantine (2), issues (2), shipping (2), shipment (2), available (2), arrival (2), registration (2), model (2), note (2), through (2), was (2), financial (2), offset (2), nothing (2), 510190 (2), 142300 (2), 141050 (2), 130300 (2), 401190 (2), belong (2), since (2), exclude (2), studied (2), chapter (2), special (2), 403150 (2), 130100 (2), gen (2), major (2), right (2), received (2), selling (2), changed (2), 805 (2), good (2), just (2), finds (2), clicks (2), quantities (2), she (2), parameter (2), sets (2), second (2), save (2), control (2), disregarded (2), receipt (2), today (2), message (2), invoices (2), link (2), origin (2), perform (2), earned (2), shares (2), associated (2), certain (2), between (2), possible (2), specific (2), representative (2), your (2), has (2), life (2), they (2), temporary (2), hr_cast (2), sp_cast (2), both (2), include (2), which (2), periods (2), values (2), country (2), decreased (2), introduction (2), production (2), installation (2), powered, avocation, wordpress, copyright, 2024, axapta, rights, reserved, license, agreement, privacy, policy, contact, oleksandr, katrusha, ax7, patrick, hawker, kurt, hatlevik, ludwig, reinhard, violaine, lars, mikkelsen, dev, services, fedotenko, functional, macchinetti, sumit, loya, casperkamal, vanya, kashperuk, santosh, ramamurthy, alexey, voytsekhovskiy, dilip, msdn, sustained, engineering, supply, chain, community, wiki, blogroll, links, page, advertorial, manuals, helpful, basics, artata, zaman, within, threshold, where, informative, writeup, quick, question, way, shyam, great, helps, 2011, jaffar, clap, worthy, efforts, put, site, lalit, setting, facing, method, unit, showing, actually, after, convert, while, would, appreciate, kind, regards, dear, sir, september, august, benny, huang, tutorial, ever, seen, saeed, awesome, sharing, art, god, bless, anton, valuable, june, abdulla, content, comments, nice, support, planning, video, cover, follow, informed, progress, twitter, reporting, statistics, journals, quotation, requisitions, request, quote, agreements, over, serial, batch, numbers, miscellaneous, interface, promise, forklifts, pallet, warehouses, aisles, racks, shelves, bins, zones, locations, dimension, been, covered, hope, done, feel, confident, recommend, learning, essential, source, knowledge, viewed, penny, sometimes, happens, equal, rounding, zero, disappears, changes, its, generates, additional, 999999, reflected, 200, image, reversed, picture, consumption, packaging, persons, expense, profit, analyzed, stored, 505, freight, credit, balance, balances, profiles, positing, again, place, 405, 108, recall, inquiry, deduct, why, such, forgotten, 0825, like, result, goes, selects, correct, finally, quantity, orde, reviews, appears, until, expenses, point, view, who, delivers, access, credited, debited, updated, looks, less, settings, teams, receives, two, choices, includes, necessary, assign, member, divided, members, according, buying, assigned, any, empty, retyped, paragraph, official, ax2009, calculates, level, upon, searches, related, combination, relationships, combinations, representatives, define, rate, get, online, log, internal, path, references, manually, real, filled, cans, 9000, 2400, shows, shown, ignore, relevant, discussed, earlier, three, know, should, onto, payable, cast, out, tracking, overview, caa, 7001, buys, were, enter, end, quarter, currently, governor, arnold, schwarzenegger, year, read, budget, crisis, wikipedia, percentage, rules, contain, takes, kinds, even, district, united, states, here, complicate, task, wants, verifies, prices, performs, actions, deducted, posts, guarantee, pay, them, sent, via, fax, mail, sign, main, finalize, step, processing, printing, agenda, attribute, development, bills, material, routes, operations, centers, resources, cycle, initial, equipment, dimensions, paying, financials, load, initialization, checklist, courses, everyday, aid, specialists,

Text of the page (random words):
line in the commission calculation form select table in the item code field fill in 1 bottle in the item relation code field setup customer if we want the sales manager to receive commission when invoicing any customer select all in the customer code field it is possible to set up specific customer commission group in this case select group in the customer code field the customer commission group is created under accounts receivable setup commission customer groups for commission a customer is assigned to a customer commission group under accounts receivable common forms customer details sales order tab sales order field group commission customer group field it is possible to set up specific customer in this case select table in the customer code field we assume that the sales manager must receive commission when he or she invoices only the 1000 natural juice customer select table in the customer code field fill in 1000 natural juice in the customer relation field perform settings for the sales manager if we want all sales managers to receive commission when invoicing the natural juice customer buying the bottle item we must select all in the sales rep code field if only a certain sales team must receive commission we must select group in the sales rep code field and fill in the necessary group in the sales rep relation field the sales team belongs to the sales commission group the sales commission group is set up under accounts receivable setup commission sales groups the commission sales group form opens we can assign a new sales manager to the sales team in the commission sales group form sales rep button create new record or under basic common forms employee details commission menu button sales groups button create new record if the sales manager belongs to the sales team the commission is received by each member of the team as it is divided between all members according to the percent parameter the percent is set up in the sales rep form click the sales rep button in the form sales rep form only two choices are available all sales managers or sales team we assume that only the sales team that our sales manager belongs to must receive the commission so let s find the sales commission group that includes employee 7210 go to basic common forms employee details the employee form opens find the employee account that is associated with our user id it is employee account 7210 click the commission sales groups menu button the commission shares form opens commission shares form we can see that the sales manager belongs to sales teams 20 and 30 the sales manager receives 45 of all commission earned by sales team 20 and 20 of that earned by sales team 30 let s assume that the sales managers included into sales commission group 20 can receive commission select group in the sales rep code field fill in 20 in the sales rep relation field fill in 10 in the origin field note all sales team will receive 10 commission our sales manager will receive 45 of this commission 4 5 so it is less that we assume our new record looks as follows commission calculation form create the same record for the can item during posting of an invoice the commission amount will be recorded to special general ledger accounts the commission posting form is used to link general ledger accounts to a commission transaction when a sales order is invoice updated the commission amount on the posted sales line is debited to the commission account credited to the commission offset account to access the commission posting form go to accounts receivable setup commission commission posting commission posting form remember general ledger account 602140 this account belongs to the expenses group also remember general ledger account 211500 this account is used to store amounts of money that must be paid to sales managers this account belongs to the vendor group so from the company s point of view the sales manager is the vendor who delivers order invoices we can t see the commission amount on the sales order until we post an invoice if we want the commission to be taken into account during invoice posting we must set up a commission sales group on the sales order line in the line area of the sales order form go to the setup tab and fill in the sales group field group with 20 make the same setup for the second line when we save the line the delivery date control is disregarded because the receipt date 6 10 2010 is before today message appears just close it post an invoice the sales manager sets up sales taxes and commission reviews the charges for the carrier now it is time to post the invoice the sales manager goes to the sales orde r form finds an appropriate sales order and clicks the posting invoice menu button the posting invoice form opens the sales manager selects packing slip in the quantity field of the parameter field group go to the lines tab and make sure that the quantities and other parameters are correct select the print invoice check box and finally he or she clicks the ok button the result of the posting process is as follows the invoice document is printed invoice document in the invoice document we can find the information about the invoice total amount 12 875 sales tax amount 940 50 and carrier charges included in the misc charges 535 the invoice total amount is calculated as item price misc charges sales tax i e 12 875 11 400 535 940 50 check the sales tax in this training lesson we have set up 8 25 sales tax the sales price is 11 400 so the sales tax is 11 400 0 0825 940 50 good it is just like in the invoice check the carrier charges remember that in the previous training we set up the following charges core charges 400 handling charges 30 fuel surcharge 270 and ancillary charges 105 the total charge amount is 400 30 270 105 805 in the invoice document the misc charges value is 535 why is there such difference 805 535 270 that is because we have forgotten to select the charge fuel surcharge check box in the sales order form sales order form header area delivery tab carrier information field group charge fuel surcharge check box so the fuel surcharge is not included in the invoice total amount commission amount is not printed in the invoice document issue status on inventory transactions is changed from deduct to sold to check this in the lines area of the sales order form click the inventory transactions menu button the transactions form opens transactions form sold status general ledger transactions are generated let s check the general ledger transactions that are created during posting of an invoice document all information about the invoice can be viewed under sales order form header area inquiry button invoice menu button the invoice journal form opens invoice journal form before we check the general ledger transactions let s recall the sales tax carrier charges and commission amounts to find the posted sales tax amount click the posted sales tax button in the invoice journal form the sales tax transactions form opens sales tax transactions form the total posted sales tax amount is 940 50 to find the carrier charges included into the invoice click the misc charges button in the invoice journal form the misc charges transactions form opens misc charges transactions form the total carrier charge is 400 105 30 535 to find the commission amount click the commission commission transactions menu button the commission transactions form opens commission transactions form since the commission is received by the sales team we can see that our sales manager employee account 7210 will receive the 405 commission for selling bottle items and the 108 commission for selling the can items the total commission amount is 10 11 400 100 1 140 if we sum all employee commissions we receive the same amount 1 140 so again all amounts are in one place total invoice amount is 12 875 50 sales tax is 940 50 carrier charges amount is 535 core charges 400 ancillary charges 105 handling charges 30 commission is 1 140 items sales price is 11 400 let s check the general ledger transactions in the invoice journal form click the voucher button the voucher transactions form opens this form contains general ledger transactions generated during the invoice positing process voucher transactions form analyze the voucher transactions i e general ledger transactions total invoice amount is 12 875 50 this amount is recorded to account 130100 so this account is used to track customers balances the amount of money that must be paid to our company from customers this general ledger account is taken from the default posting profile that is set up in the account receivable parameters form located under accounts receivable setup parameters ledger and sales tax tab posting field group posting profile field our demo data contains gen in the posting profile field to find the posting profile setup go to accounts receivable setup posting profiles find gen posting profile setup tab customer posting profile form the natural juice customer belongs to customer group 20 major customers so only the last record is right one for our customer the summary account for this record is 130100 sales tax is 940 50 this amount is recorded to general ledger account 220110 so this account is used to track the authority balance the amount of money that must be paid to the authority the 220110 account is taken from the ledger posting group that is set up on the sales tax codes we have already studied how a general ledger account is set up for the sales tax in the sales taxes chapter of this training lesson carrier charge is 535 in the previous training lesson we analyzed that the carrier charges are taken from the customer and stored in special general ledger accounts this is set up in the misc charges code form located under accounts receivable setup misc charges misc charges code posting tab credit account field in our demo data for the core or freight charges general ledger account 403500 is used for the handling charges it is the 403150 general ledger account for the ancillary charges it is also the 403500 general ledger account so in the voucher transactions form we can see that 400 105 505 is recorded to account 403500 and 30 is recorded to account 403150 commission is 1 140 this amount is recorded to accounts 211500 and 602140 account 211500 is used to track commission the amount of money that must be paid to sales persons since the commission is included into the invoice amount we must record that the commission is an expense net profit must exclude the commission this amount is recorded to account 602140 these general ledger accounts are taken from the commission posting form located under accounts receivable setup commission commission posting we have already studied how general ledger accounts are set up for the commission in the commissions chapter of this training lesson item sales price or revenue is 11 400 this amount is recorded to account 401190 so this account is used to track the revenue the amount of money that must be paid for sales items this general ledger account is taken from the item group the bottle and can items belong to the packaging item group go to inventory management setup item groups the item group form opens go to the sales order tab item group form the revenue field contains the general ledger account that will be used to track the revenue amount we can see that this field contains general ledger account 401190 inventory transaction inventory transaction is also reflected in the general ledger accounts when the items are sold the cost amount must be excluded from inventory value and included as cost of goods sold remember that in this training lesson we set up the bottle item cost to be 5 and the can item cost to be 7 so the total cost amount is 1000 5 200 7 6 400 this amount is recorded to accounts 510190 142300 141050 and 130300 account 510190 is used to track the cost of goods sold account 141050 is used to track the inventory value cost of items in the warehouse these accounts are set up in the item group form sales order tab invoice field group issue and consumption fields see the previous picture when we post the packing slip general ledger transactions are generated for accounts 142300 and 130300 find these transactions in this training lesson the voucher transactions form packing slip transactions image during posting of an invoice these general ledger transactions must be reversed penny difference sometimes it happens that the amount in the general ledger account and the amount in the offset account s are not equal because of rounding if we sum all general ledger amounts we must receive zero because nothing disappears but only changes its form in our case if we sum all amounts in the secondary currency the amount secondary currency fields we receive 0 01 so microsoft dynamics ax generates additional general ledger transactions for amount 0 01 this amount is recorded to account 999999 this general ledger account is set up under general ledger setup posting system accounts system accounts form note if you do not feel confident in finance i recommend that you go through this financial training when i was learning finance in microsoft dynamics ax it was an essential source of knowledge summary in this training lesson we have done the following set up sales tax set up commission post an invoice analyze results of invoice posting process invoice document inventory transactions and general ledger transactions this is the last lesson in the trade and logistics training i hope this training will help you understand the microsoft dynamics ax trade and logistics module the following issues have been covered during the trade and logistics training how to create an item what an item group an inventory model group and an inventory dimension group are purchase business process how to create a vendor warehouses aisles racks shelves bins store zones store areas and locations forklifts and pallet types how to create a purchase order item arrival and registration process in microsoft dynamics ax print management system purchase order posting packing slip and invoice sales business process how to create a sales order available to promise shipment process in microsoft dynamics ax shipping carrier interface miscellaneous charges sales tax and commissions sales order posting packing slip and invoice the following issues are not included into the training serial and batch numbers quarantine management vendor returns customer returns over under delivery customer and vendor trade agreements request for quote purchase requisitions sales quotation quality management transfer orders inventory journals inventory reporting and statistics i am planning to create a video training to be paid for the trade and logistics module that will cover all these areas you can follow me on facebook or twitter and be informed about the status and the progress of this training thank you all for nice words you re...