User Tools

Site Tools


Sidebar

Index

start:backoffice:accounts:account_payment_allocation

Account Payment Allocation

To allocate your payments you click on 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.

Click on the Invoice you would like paid and press Pay in Full. You will see the $ amount allocated next to the amount outstanding.

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.txt · Last modified: 2021/08/02 15:36 by Justin