User Tools

Site Tools


start:backoffice:accounts:account_payment_allocation

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
start:backoffice:accounts:account_payment_allocation [2017/09/04 12:27] Emmastart:backoffice:accounts:account_payment_allocation [2021/08/02 15:36] (current) Justin
Line 1: Line 1:
 ====== Account Payment Allocation ====== ====== Account Payment Allocation ======
 +
 +
 +To allocate your payments you click on {{:start:backoffice:accounts:payment_has_been_allocated.png|}} Allocate Payments. 
 +
 +Please note your Account should be in credit when allocating payments. You must have a Invoice row and payment row to clear off Invoices outstanding.
 +
 +{{:start:backoffice:accounts:account_payment_allocation.png|}}
 +
 +Click on the Invoice you would like paid and press Pay in Full. You will see the $ amount allocated next to the amount outstanding.
 +
 +{{:start:backoffice:accounts:account_payment_allocation_invoice.png|}}
 +
 +Allocate All - Looks at the oldest Invoice to pay and allocates the money to pay it.
 +
 +
 +====== How to find out what invoices got allocated to a Payment ======
 +
 +Data is stored in `audit_change_history` and then we put the audit_info information into https://jsonlint.com/ to make it pretty/easier to read
 +
 +This is the technical data we stored for the allocation in question:
 +
 +{
 +    "0": {
 +        "SALETYPE": "Invoice",
 +        "ALLOCATE": "120.00",  **//This is how much we are allocating to the item**
 +        "ORIOUTVALUE": "120.00",
 +        "ACCOUNT": "00296",
 +        "TRANSTYPE": "I",
 +        "TRANSDATE": "03-12-2020", **//Sale date**
 +        "BRANCH": 1,
 +        "TRANSNO": 75793,
 +        "REF": "I001-009996", **//Invoice reference number**
 +        "DETAILS": "POS Invoice",
 +        "DEBIT": "120.00", **//Value of sale - debit**
 +        "CREDIT": "0.00", **//Value of sale/refund - credit**
 +        "OUTVALUE": "120.00",
 +        "FINISHED": 0, **//Is this completed? 0 = no, 1 = yes**
 +        "CBOOKREF": "",
 +        "CORIGREF": "",
 +        "CREFERENCE": "",
 +        "NONACCOUNT": "120.00",
 +        "CTIME": "15:43",
 +        "CUNIQUEID": "_5FC87B119",
 +        "LUNCEXPORT": 0,
 +        "NBALANCE": "993.30",
 +        "DLASTEDIT": "2020-12-31 11:40:28",
 +        "OS": ""
 +   
 +    "6": {
 +        "SALETYPE": "Invoice",
 +        "ALLOCATE": "59.85",  **//This is a part allocation** 
 +        "ORIOUTVALUE": "120.00",
 +        "ACCOUNT": "00296",
 +        "TRANSTYPE": "I",
 +        "TRANSDATE": "17-12-2020",
 +        "BRANCH": 1,
 +        "TRANSNO": 76872,
 +        "REF": "I001-010122",
 +        "DETAILS": "POS Invoice",
 +        "DEBIT": "120.00",
 +        "CREDIT": "0.00",
 +        "OUTVALUE": "120.00",
 +        "FINISHED": 0,
 +        "CBOOKREF": "",
 +        "CORIGREF": "",
 +        "CREFERENCE": "",
 +        "NONACCOUNT": "120.00",
 +        "CTIME": "15:47",
 +        "CUNIQUEID": "_5FDAF0F7D",
 +        "LUNCEXPORT": 0,
 +        "NBALANCE": "2,705.02",
 +        "DLASTEDIT": "2020-12-31 11:40:28",
 +        "OS": ""
 +    },
 +    "12": {
 +        "SALETYPE": "Payment",
 +        "ALLOCATE": "-1771.57",
 +        "ORIOUTVALUE": "1771.57",
 +        "ACCOUNT": "00296",
 +        "TRANSTYPE": "P",
 +        "TRANSDATE": "02-02-2021",
 +        "BRANCH": 0,
 +        "TRANSNO": 4701,
 +        "REF": "P000-04701",
 +        "DETAILS": "Account Payment",
 +        "DEBIT": "0.00",
 +        "CREDIT": "1771.57",
 +        "OUTVALUE": "1771.57",
 +        "FINISHED": 0,
 +        "CBOOKREF": "kimflegler",
 +        "CORIGREF": "",
 +        "CREFERENCE": "Account Payment ",
 +        "NONACCOUNT": "0.00",
 +        "CTIME": "12:16",
 +        "CUNIQUEID": "_6018A7D1A",
 +        "LUNCEXPORT": 0,
 +        "NBALANCE": "1,151.87",
 +        "DLASTEDIT": "2021-02-02 12:16:01",
 +        "OS": ""
 +    }
 +}
 +
 +
 +
 +
 +
 +
 +
 +
  
  
start/backoffice/accounts/account_payment_allocation.1504492054.txt.gz · Last modified: 2017/09/04 12:27 by Emma