Postings:AP Invoice: Difference between revisions

From Epiphany
JMeyer (talk | contribs)
Created page with "=== AP INVOICE === {| class="wikitable sortable" |- | align="center" style="background:#69f;" | '''Post AP Invoice''' | align="center" style="background:#69f;" | '''Pre Post'..."
 
JMeyer (talk | contribs)
 
Line 16: Line 16:
| align="center" | <b>X
| align="center" | <b>X
|-  
|-  
| <b>*Update</b> - AP sub total to invoice total
| <b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Update</b> - AP sub total to invoice total
| align="center" | <b>X
| align="center" | <b>X
| align="center" | <b>X
| align="center" | <b>X
Line 44: Line 44:
| align="center" | <b>X
| align="center" | <b>X
|-  
|-  
| * Total all Payments attached to this invoice
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;* Total all Payments attached to this invoice
| align="center" |  
| align="center" |  
| align="center" | <b>X
| align="center" | <b>X
Line 51: Line 51:
| align="center" | <b>X
| align="center" | <b>X
|-  
|-  
| * Update the Amount Paid and Amount Credited on the Invoice to those payment totals
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;* Update the Amount Paid and Amount Credited on the Invoice to those payment totals
| align="center" |  
| align="center" |  
| align="center" | <b>X
| align="center" | <b>X
Line 79: Line 79:
| align="center" | <b>X
| align="center" | <b>X
|-  
|-  
| <b>*Delete</b> - Relationship - Remove Relationship between invoice and inentory transaction
| <b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Delete</b> - Relationship - Remove Relationship between invoice and inentory transaction
| align="center" |  
| align="center" |  
| align="center" | <b>X
| align="center" | <b>X
Line 86: Line 86:
| align="center" | <b>X
| align="center" | <b>X
|-  
|-  
| <b>*Delete</b> - Relationship - Remove Relationship between invoice and inventory reciept
| <b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Delete</b> - Relationship - Remove Relationship between invoice and inventory reciept
| align="center" |  
| align="center" |  
| align="center" | <b>X
| align="center" | <b>X
Line 100: Line 100:
| align="center" | <b>X
| align="center" | <b>X
|-  
|-  
| <b>*Delete</b> - Inventory Transactions - Delete any inventory transactions attached to this invoice. [[Postings:Inventory|PostInventory]]
| <b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Delete</b> - Inventory Transactions - Delete any inventory transactions attached to this invoice. [[Postings:Inventory|PostInventory]]
| align="center" |  
| align="center" |  
| align="center" | <b>X
| align="center" | <b>X
Line 114: Line 114:
| align="center" |  
| align="center" |  
|-  
|-  
| <b>*Update</b> - Qty recieved - When a invoice is deleted it also deletes the inventory transaction so we need to put the original received amount back in PostInvTranHeader
| <b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Update</b> - Qty recieved - When a invoice is deleted it also deletes the inventory transaction so we need to put the original received amount back in PostInvTranHeader
| align="center" |  
| align="center" |  
| align="center" |  
| align="center" |  
Line 128: Line 128:
| align="center" |  
| align="center" |  
|-  
|-  
| <b>*Create</b> - Ledger line related to the default GL account - Accounts Payable is a credit in the ammount of the invoice total GL.AddLedgerLine
| <b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Create</b> - Ledger line related to the default GL account - Accounts Payable is a credit in the ammount of the invoice total GL.AddLedgerLine
| align="center" |  
| align="center" |  
| align="center" | <b>X
| align="center" | <b>X
Line 135: Line 135:
| align="center" |  
| align="center" |  
|-  
|-  
| <b>*Create</b> - Ledger line related to the default GL account - Shipping Expense is a debit in the amount of the invoice shipping GL.AddLedgerLine
| <b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Create</b> - Ledger line related to the default GL account - Shipping Expense is a debit in the amount of the invoice shipping GL.AddLedgerLine
| align="center" |  
| align="center" |  
| align="center" | <b>X
| align="center" | <b>X
Line 142: Line 142:
| align="center" |  
| align="center" |  
|-  
|-  
| <b>*Create</b> -  Ledger line related to the default GL account - Sales Tax Expense is a debit in the amount of the invoice tax total GL.AddLedgerLine
| <b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Create</b> -  Ledger line related to the default GL account - Sales Tax Expense is a debit in the amount of the invoice tax total GL.AddLedgerLine
| align="center" |  
| align="center" |  
| align="center" | <b>X
| align="center" | <b>X
Line 156: Line 156:
| align="center" |  
| align="center" |  
|-  
|-  
| <b>*Create</b> - Inventory Transactions - [[Postings:Inventory|PostInventory]]
| <b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Create</b> - Inventory Transactions - [[Postings:Inventory|PostInventory]]
| align="center" |  
| align="center" |  
| align="center" | <b>X
| align="center" | <b>X

Latest revision as of 14:35, 26 December 2019

AP INVOICE

Post AP Invoice Pre Post Post Delete Create Unpost
If - AP sub total doesn't equal the invoice total X X X X X
     *Update - AP sub total to invoice total X X X X X
Validate - AP date past the closing date X
Validate - AP date within the GL Edit Days limitations for the user X
Update - Current Payment Totals X X X X
     * Total all Payments attached to this invoice X X X X
     * Update the Amount Paid and Amount Credited on the Invoice to those payment totals X X X X
Validate - Make sure payments do not exist before deleting. X
Delete - Journal Entry - Delete all journal entries attached to this invoice. GL.Delete X X X
If - Invoice is related to an inventory recipt X X X
     *Delete - Relationship - Remove Relationship between invoice and inentory transaction X X X
     *Delete - Relationship - Remove Relationship between invoice and inventory reciept X X X
Else X X X
     *Delete - Inventory Transactions - Delete any inventory transactions attached to this invoice. PostInventory X X X
If - Invoice is related to an inventory recipt X
     *Update - Qty recieved - When a invoice is deleted it also deletes the inventory transaction so we need to put the original received amount back in PostInvTranHeader X
Create - Journal Entry GL.NewJournalEntry X X
     *Create - Ledger line related to the default GL account - Accounts Payable is a credit in the ammount of the invoice total GL.AddLedgerLine X X
     *Create - Ledger line related to the default GL account - Shipping Expense is a debit in the amount of the invoice shipping GL.AddLedgerLine X X
     *Create - Ledger line related to the default GL account - Sales Tax Expense is a debit in the amount of the invoice tax total GL.AddLedgerLine X X
For Each - Invoice Line X X
     *Create - Inventory Transactions - PostInventory X X
Update - Balance - Update the Balance on the Chart accounts related to the ledger lines GL.Post X X X X