Difference between revisions of "Journal Entry Architecture Invoicing"
From Adjutant Wiki
| (3 intermediate revisions by the same user not shown) | |||
| Line 78: | Line 78: | ||
Sales Tax is typically split out in the GL one of two ways: by State or by Jurisdiction. | Sales Tax is typically split out in the GL one of two ways: by State or by Jurisdiction. | ||
| − | The [http://abiscorp.com/ | + | The [http://www.abiscorp.com/faq/images/b/bf/JE_Inv_States_Sales_Tax_RM_GL.png States Rule (STATE)] allows you to specify a GL account per state. |
The Sales Tax Master screen allows you to specify sales tax by jurisdiction, however this is not recommended unless you are operating in Canada. | The Sales Tax Master screen allows you to specify sales tax by jurisdiction, however this is not recommended unless you are operating in Canada. | ||
| − | If a valid account is not found in either of these two places, the Sales Tax Account listed on the [ | + | If a valid account is not found in either of these two places, the Sales Tax Account listed on the [http://www.abiscorp.com/faq/images/4/42/JE_Inv_CID_Maint_Sales_GL.png CID Maintenance screen] will be used. |
| Line 102: | Line 102: | ||
3. Sales Order Type | 3. Sales Order Type | ||
| − | - The [http://abiscorp.com/ | + | - The [http://www.abiscorp.com/faq/images/b/b8/JE_Inv_SO_Rule_Maint.png Sales Order Type] (SOTYPE) may have a [http://www.abiscorp.com/faq/images/1/15/JE_Inv_SO_Rule_GL.png GL Group] attached to it. |
4. Warehouse | 4. Warehouse | ||
| − | - The [http://abiscorp.com/ | + | - The [http://www.abiscorp.com/faq/images/d/d8/JE_Inv_Ship_WH.png Shipping Warehouse] of each line item may have a [http://www.abiscorp.com/faq/images/6/60/JE_Inv_WH_GL.png GL Group] attached to it. |
5. Department (only applicable in Time Billing) | 5. Department (only applicable in Time Billing) | ||
| Line 111: | Line 111: | ||
6. Account Manager | 6. Account Manager | ||
| − | - The [http://abiscorp.com/ | + | - The [http://www.abiscorp.com/faq/images/2/27/JE_Inv_SO_Acct_Man.png Account Manager Account Manager] on the SO may have a [http://www.abiscorp.com/faq/images/3/3b/JE_Inv_Acct_Man_GL.png GL Group] attached to him/her. |
7. Salesperson | 7. Salesperson | ||
| − | - The [http://abiscorp.com/ | + | - The [http://www.abiscorp.com/faq/images/4/42/JE_Inv_SO_SP.png Salesperson] on the SO may have a [http://www.abiscorp.com/faq/images/7/76/JE_Inv_SP_GL.png GL Group] attached to him/her. |
8. Resource (only applicable in Time Billing) | 8. Resource (only applicable in Time Billing) | ||
| Line 125: | Line 125: | ||
===Work in Process=== | ===Work in Process=== | ||
| − | WIP accounts are figured on an item-by-item basis. The item's WIP account listed on the [http://abiscorp.com/ | + | WIP accounts are figured on an item-by-item basis. The item's WIP account listed on the [http://www.abiscorp.com/faq/images/5/5c/JE_Inv_WIP_Acct.png OHF tab of the Item Master] will be credited when the item is invoiced. |
The same account is debited when the item is shipped. | The same account is debited when the item is shipped. | ||
| − | The debit entry for WIP is made during the [http://www.abiscorp.com/ | + | The debit entry for WIP is made during the [http://www.abiscorp.com/faq/images/d/dd/JE_Inv_WIP_SO.png WIP (Sales Order)] batch. The item's [http://www.abiscorp.com/faq/images/2/20/JE_Inv_Control_Acct.png Inventory Control Account] is credited. |
| − | If this account is blank or invalid, then the WIP account on the [http://abiscorp.com/ | + | If this account is blank or invalid, then the WIP account on the [http://www.abiscorp.com/faq/images/b/b3/JE_Inv_WH_WIP_Acct.png Warehouse] will be used. If that account is blank or invalid, then the WIP account on the [http://www.abiscorp.com/faq/images/f/fc/JE_Inv_CID_WIP_Acct.png CID Maintenance] screen will be used. |
[[Category: General Ledger]] | [[Category: General Ledger]] | ||
Latest revision as of 11:00, 19 July 2022
General Information
The Batch Generator can make several batch journal entries. One of the options is the batch for Invoicing (Sales Order shipment or Time Entry billing).
Many things affect which GL accounts will be debited or credited when creating an invoice. There are typically 5 accounts affected during invoicing:
1. Accounts Receivable
- AR is debited in the amount of the invoice.
2. Revenue
- Revenue is credited in the amount of the invoice less sales tax.
3. Sales Tax
- Sales Tax is credited in the amount of the tax on the invoice.
4. Cost of Goods Sold
- COGS is debited based upon the cost of the items on the Sales Order.
5. Work in Process
- WIP is credited based upon the cost of the items on the Sales Order. WIP has already been debited when the SO was shipped, so this account is always a wash (not affected).
Journal Entry Architecture
This section will describe how each fully qualified account is determined by the program.
Accounts Receivable
The AR account can be one of two accounts: The AR account on the CID Maintenance Screen or the AR account listed on the Bill To Screen of the customer being invoiced.
The account listed on the Bill To screen will always override the CID Maintenance screen. If left blank, the CID Maintenance AR Account will always be used.
Revenue
Revenue accounts are figured on an item-by-item basis; each item on the Sales Order may go to a different Revenue account.
The Revenue account is derived based on nine different factors:
1. Item Transaction Category (aka ItemCat)
2. Customer Transaction Category (aka CustCat)
The ItemCat and CustCat are combined to create a Transaction Category. The Transaction Category provides the starting point for the Revenue and COGS accounts. These accounts will be overridden by GL Groups attached to the last 7 factors.
3. Sales Order Type - The Sales Order Type (SOTYPE) may have a GL Group attached to it.
4. Warehouse - The Shipping Warehouse of each line item may have a GL Group attached to it.
5. Department (only applicable in Time Billing) - In Time Billing, the department of the Task may have a GL Group attached to it.
6. Account Manager - The Account Manager on the SO may have a GL Group attached to him/her.
7. Salesperson - The Salesperson on the SO may have a GL Group attached to him/her.
8. Resource (only applicable in Time Billing) - In Time Billing, the Resource used may have a GL Group attached to him/her/it.
9. Solution Code (only applicable in Time Billing) - In Time Billing, the Solution Code used may have a GL Group attached to it.
Sales Tax
Sales Tax is typically split out in the GL one of two ways: by State or by Jurisdiction.
The States Rule (STATE) allows you to specify a GL account per state.
The Sales Tax Master screen allows you to specify sales tax by jurisdiction, however this is not recommended unless you are operating in Canada.
If a valid account is not found in either of these two places, the Sales Tax Account listed on the CID Maintenance screen will be used.
Cost of Goods Sold
COGS accounts are figured on an item-by-item basis; each item on the Sales Order may go to a different COGS account.
For stock items, the item's weighted average cost per Warehouse/Owner/Held For will be used.
For non-stock items, the cost entered on the Sales Order will be used.
The COGS account is derived based on nine different factors:
1. Item Transaction Category (aka ItemCat)
2. Customer Transaction Category (aka CustCat)
The ItemCat and CustCat are combined to create a Transaction Category. The Transaction Category provides the starting point for the Revenue and COGS accounts. These accounts will be overridden by GL Groups attached to the last 7 factors.
3. Sales Order Type - The Sales Order Type (SOTYPE) may have a GL Group attached to it.
4. Warehouse - The Shipping Warehouse of each line item may have a GL Group attached to it.
5. Department (only applicable in Time Billing) - In Time Billing, the department of the Task may have a GL Group attached to it.
6. Account Manager - The Account Manager Account Manager on the SO may have a GL Group attached to him/her.
7. Salesperson - The Salesperson on the SO may have a GL Group attached to him/her.
8. Resource (only applicable in Time Billing) - In Time Billing, the Resource used may have a GL Group attached to him/her/it.
9. Solution Code (only applicable in Time Billing) - In Time Billing, the Solution Code used may have a GL Group attached to it.
Work in Process
WIP accounts are figured on an item-by-item basis. The item's WIP account listed on the OHF tab of the Item Master will be credited when the item is invoiced.
The same account is debited when the item is shipped. The debit entry for WIP is made during the WIP (Sales Order) batch. The item's Inventory Control Account is credited.
If this account is blank or invalid, then the WIP account on the Warehouse will be used. If that account is blank or invalid, then the WIP account on the CID Maintenance screen will be used.
