CloudHQ4 Manual

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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": ""
    }
}
CloudHQ4 Manual

User Tools

Site Tools

Page Tools
