Postings:AP Invoice: Difference between revisions
From Epiphany
Created page with "=== AP INVOICE === {| class="wikitable sortable" |- | align="center" style="background:#69f;" | '''Post AP Invoice''' | align="center" style="background:#69f;" | '''Pre Post'..." |
|||
| Line 16: | Line 16: | ||
| align="center" | <b>X | | align="center" | <b>X | ||
|- | |- | ||
| <b>*Update</b> - AP sub total to invoice total | | <b> *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 | | * 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 | | * 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> *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> *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> *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> *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> *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> *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> *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> *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 |